src/Controller/NewsController.php line 14

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Service\NewsFilterService;
  6. use Doctrine\DBAL\Query\QueryBuilder;
  7. use Exception;
  8. use Knp\Component\Pager\PaginatorInterface;
  9. use Pimcore\Model\Document\Listing;
  10. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Template;
  11. use Symfony\Component\HttpFoundation\Request;
  12. use Symfony\Component\Routing\Annotation\Route;
  14. class NewsController extends DefaultFrontendController
  15. {
  16.     /**
  17.      * @Template
  18.      * @Route("{locale}{path}{productname}~p{product}", name="category-detail", defaults={"path"=""}, requirements={"path"=".*?", "productname"="[\w-]+", "product"="\d+"})
  19.      *
  20.      * @param Request $request
  21.      *
  22.      * @return array
  23.      * @throws Exception
  24.      */
  25.     public function singleAction(Request $request): array
  26.     {
  27.         /*
  28.          * Worthwhile noting that the getEditable relation returns an object, and not the page object.
  29.          */
  30.         $projectObjects = $this->document->getEditable('relatedProjects');
  31.         $productCategoryObjects = $this->document->getEditable('relatedProductCategories');
  32.         $sectorObjects = $this->document->getEditable('relatedSectors');
  33.         $relatedNewsType = $this->document->getEditable('relatedNewsType');
  35.         return $this->data($request, [
  36.             'projectObjects' => $projectObjects?->getData(),
  37.             'productCategoryObjects' => $productCategoryObjects?->getData(),
  38.             'sectorObjects' => $sectorObjects?->getData(),
  39.             'relatedNewsType' => $relatedNewsType?->getData(),
  40.         ]);
  41.     }
  43.     /**
  44.      * @Template
  45.      * @Route("{locale}{path}{productname}~p{product}", name="category-detail", defaults={"path"=""}, requirements={"path"=".*?", "productname"="[\w-]+", "product"="\d+"})
  46.      * @param Request $request
  47.      * @return array
  48.      */
  49.     public function archiveAction(Request $request, PaginatorInterface $paginator, NewsFilterService $newsFilterService): array
  50.     {
  51.         $listing = new Listing();
  52.         $listing->addConditionParam('documents.type = :type', ['type' => $this->document->getType()]);
  53.         $listing->addConditionParam('path LIKE :path', ['path' => $this->document->getFullPath() . '%']);
  55.         $relatedProductCategories = $request->query->get('solutions');
  56.         $relatedSectors = $request->query->get('industries');
  57.         $relatedNewsType = $request->query->get('type');
  59.         $listing->onCreateQueryBuilder(function (QueryBuilder $queryBuilder) use ($relatedSectors, $relatedProductCategories, $relatedNewsType) {
  60.             $tableName = $queryBuilder->getQueryParts()['from'][0]['table'] ?? null;
  62.             if ($relatedProductCategories) {
  63.                 $queryBuilder->leftJoin(
  64.                     $tableName,
  65.                     'documents_editables',
  66.                     'categoryRelation',
  67.                     'categoryRelation.documentId = documents.id'
  68.                 );
  70.                 $queryBuilder->andWhere($queryBuilder->expr()->and(
  71.                     $queryBuilder->expr()->eq('categoryRelation.name', '"relatedProductCategories"'),
  72.                     $queryBuilder->expr()->like('categoryRelation.data', 'CONCAT(\'%"id";i:\',' . (int)$relatedProductCategories . ',\';%\')',),
  73.                 ));
  74.             }
  76.             if ($relatedSectors) {
  77.                 $queryBuilder->leftJoin(
  78.                     $tableName,
  79.                     'documents_editables',
  80.                     'sectorRelation',
  81.                     'sectorRelation.documentId = documents.id'
  82.                 );
  84.                 $queryBuilder->andWhere($queryBuilder->expr()->and(
  85.                     $queryBuilder->expr()->eq('sectorRelation.name', '"relatedSectors"'),
  86.                     $queryBuilder->expr()->like('sectorRelation.data', 'CONCAT(\'%"id";i:\',' . (int)$relatedSectors . ',\';%\')',),
  87.                 ));
  88.             }
  90.             if ($relatedNewsType) {
  91.                 $queryBuilder->leftJoin(
  92.                     $tableName,
  93.                     'documents_editables',
  94.                     'typeRelation',
  95.                     'typeRelation.documentId = documents.id'
  96.                 );
  98.                 $queryBuilder->andWhere($queryBuilder->expr()->and(
  99.                     $queryBuilder->expr()->eq('typeRelation.name', '"relatedNewsType"'),
  100.                     $queryBuilder->expr()->like('typeRelation.data', 'CONCAT(\'%"id";i:\',' . (int)$relatedNewsType . ',\';%\')',),
  101.                 ));
  102.             }
  104.             #todo: groupBy causes difference between count and actual data
  105.             if ($relatedProductCategories || $relatedSectors || $relatedNewsType) {
  106.                 $queryBuilder->groupBy('documents.id');
  107.             }
  109.             return $queryBuilder;
  110.         });
  112.         $listing->setOrderKey('index');
  113.         $listing->setOrder('ASC');
  115.         $pagination = $paginator->paginate(
  116.             $listing,
  117.             max(1, (int)$request->get('page', 1)),
  118.             min(100, max(11, (int)$request->get('pageSize', 11))), /** 12 items shown on page, one is hardcoded */
  119.         );
  121.         return $this->data($request, [
  122.             'pagination' => $pagination,
  123.             'paginationVariables' => $pagination->getPaginationData(),
  124.             'filters' => [
  125.                 'type' => $newsFilterService->getTypesFilterOptions($this->document, $request->getLocale()),
  126.                 'industries' => $newsFilterService->getSolutionsFilterOptions($this->document, $request->getLocale()),
  127.                 'solutions' => $newsFilterService->getIndustriesFilterOptions($this->document, $request->getLocale()),
  128.             ],
  129.         ]);
  130.     }
  131. }