View source
<?php
namespace Drupal\uc_file\Controller;
use Drupal\Core\Controller\ControllerBase;
use Drupal\Core\Database\Connection;
use Drupal\Core\Form\FormBuilderInterface;
use Drupal\Core\Url;
use Symfony\Component\DependencyInjection\ContainerInterface;
class FileController extends ControllerBase {
protected $database;
protected $formBuilder;
public static function create(ContainerInterface $container) {
return new static($container
->get('database'), $container
->get('form_builder'));
}
public function __construct(Connection $database, FormBuilderInterface $form_builder) {
$this->database = $database;
$this->formBuilder = $form_builder;
}
public function show() {
$build['#tree'] = TRUE;
$build['#attached']['library'][] = 'uc_file/uc_file.scripts';
$build['file_action_form'] = $this->formBuilder
->getForm('Drupal\\uc_file\\Form\\FileActionForm');
$header = [
[
'data' => '',
'class' => [
'select-all',
],
],
'filename' => [
'data' => $this
->t('File'),
'field' => 'f.filename',
'sort' => 'asc',
],
'title' => [
'data' => $this
->t('Product'),
'field' => 'n.title',
],
'model' => [
'data' => $this
->t('SKU'),
'field' => 'fp.model',
'class' => [
RESPONSIVE_PRIORITY_LOW,
],
],
];
$query = $this->database
->select('uc_files', 'f')
->extend('Drupal\\Core\\Database\\Query\\PagerSelectExtender')
->extend('Drupal\\Core\\Database\\Query\\TableSortExtender')
->orderByHeader($header)
->limit(UC_FILE_PAGER_SIZE);
$query
->leftJoin('uc_file_products', 'fp', 'f.fid = fp.fid');
$query
->leftJoin('uc_product_features', 'pf', 'fp.pfid = pf.pfid');
$query
->leftJoin('node_field_data', 'n', 'pf.nid = n.nid');
$query
->addField('n', 'nid');
$query
->addField('f', 'filename');
$query
->addField('n', 'title');
$query
->addField('fp', 'model');
$query
->addField('f', 'fid');
$query
->addField('pf', 'pfid');
$count_query = $this->database
->select('uc_files');
$count_query
->addExpression('COUNT(*)');
$query
->setCountQuery($count_query);
$result = $query
->execute();
$options = [];
foreach ($result as $file) {
if (isset($file->nid)) {
$options[$file->fid] = [
'checked' => [
'data' => [
'#type' => 'checkbox',
'#default_value' => 0,
],
],
'filename' => [
'data' => [
'#plain_text' => $file->filename,
],
'class' => is_dir(uc_file_qualify_file($file->filename)) ? [
'uc-file-directory-view',
] : [],
],
'title' => [
'data' => [
'#type' => 'link',
'#title' => $file->title,
'#url' => Url::fromRoute('entity.node.canonical', [
'node' => $file->nid,
]),
],
],
'model' => [
'data' => [
'#plain_text' => $file->model,
],
],
];
}
else {
$options[$file->fid] = [
'checked' => [
'data' => [
'#type' => 'checkbox',
'#default_value' => 0,
],
],
'filename' => [
'data' => [
'#plain_text' => $file->filename,
],
'class' => is_dir(uc_file_qualify_file($file->filename)) ? [
'uc-file-directory-view',
] : [],
],
'title' => '',
'model' => '',
];
}
}
$build['file_select'] = [
'#type' => 'table',
'#header' => $header,
'#rows' => $options,
'#empty' => $this
->t('No file downloads available.'),
];
$build['file_select_pager'] = [
'#type' => 'pager',
];
return $build;
}
}