public function RecentDownload::build in Download Count 8

Builds and returns the renderable array for this block plugin.

If a block should not be rendered because it has no content, then this method must also ensure to return no content: it must then only return an empty array, or an empty array with #cache set (with cacheability metadata indicating the circumstances for it being empty).

Return value

array A renderable array representing the content of the block.

Overrides BlockPluginInterface::build

See also

\Drupal\block\BlockViewBuilder

File

src/Plugin/Block/RecentDownload.php, line 55

Class

RecentDownload

Provides a 'Recent Download Count' block.

Namespace

Drupal\download_count\Plugin\Block

Code

public function build() {
  $config = $this
    ->getConfiguration();
  $limit = isset($config['download_count_recent_block_limit']) ? $config['download_count_recent_block_limit'] : 10;
  $rows = [];
  $connection = Database::getConnection();
  $sql = $connection
    ->select('download_count', 'dc');
  $sql
    ->join('file_managed', 'f', 'f.fid = dc.fid');
  $sql
    ->addExpression('MAX(dc.timestamp)', 'date');
  $sql
    ->fields('dc', [
    'fid',
  ]);
  $sql
    ->fields('f', [
    'filename',
    'filesize',
  ]);
  $sql
    ->groupBy('dc.fid');
  $sql
    ->groupBy('f.filename');
  $sql
    ->groupBy('f.filesize');
  $sql
    ->orderBy('date', 'DESC');
  $header = [
    [
      'data' => $this
        ->t('Name'),
      'class' => 'filename',
    ],
    [
      'data' => $this
        ->t('Size'),
      'class' => 'size',
    ],
    [
      'data' => $this
        ->t('Last Downloaded'),
      'class' => 'last',
    ],
  ];
  $result = $connection
    ->queryRange($sql, 0, $limit);
  foreach ($result as $file) {
    $row = [];
    $row[] = Html::escape($file->filename);
    $row[] = format_size($file->filesize);
    $row[] = $this
      ->t('%time ago', [
      '%time' => $this->dateFormatter
        ->formatInterval(REQUEST_TIME - $file->date),
    ]);
    $rows[] = $row;
  }
  if (count($rows)) {
    return [
      '#theme' => 'table',
      '#header' => $header,
      '#rows' => $rows,
    ];
  }
}