ScannerController.php in Search and Replace Scanner 8        
                          
                  
                        
  
  
  
  
  
File
  src/Controller/ScannerController.php
  
    View source  
  <?php
namespace Drupal\scanner\Controller;
use Drupal\Core\Controller\ControllerBase;
use Drupal\Core\Url;
use Drupal\Core\Link;
class ScannerController extends ControllerBase {
  
  public function undoListing() {
    $connection = \Drupal::service('database');
    $query = $connection
      ->query('SELECT * from {scanner} WHERE undone = 0');
    $results = $query
      ->fetchAll();
    $header = [
      $this
        ->t('Date'),
      $this
        ->t('Searched'),
      $this
        ->t('Replaced'),
      $this
        ->t('Count'),
      $this
        ->t('Operation'),
    ];
    $rows = [];
    
    foreach ($results as $result) {
      $undo_link = Link::fromTextAndUrl($this
        ->t('Undo'), Url::fromUri("internal:/admin/content/scanner/undo/{$result->undo_id}/confirm"))
        ->toString();
      $rows[] = [
        \Drupal::service('date.formatter')
          ->format($result->time),
        $result->searched,
        $result->replaced,
        $result->count,
        $undo_link,
      ];
    }
    $table = [
      '#type' => 'table',
      '#header' => $header,
      '#rows' => $rows,
      '#attributes' => NULL,
    ];
    return $table;
  }
}