vendor/sylius/grid-bundle/src/Bundle/Doctrine/ORM/DataSource.php line 71

Open in your IDE?
  1. <?php
  3. /*
  4.  * This file is part of the Sylius package.
  5.  *
  6.  * (c) Paweł Jędrzejewski
  7.  *
  8.  * For the full copyright and license information, please view the LICENSE
  9.  * file that was distributed with this source code.
  10.  */
  12. declare(strict_types=1);
  14. namespace Sylius\Bundle\GridBundle\Doctrine\ORM;
  16. use Doctrine\ORM\QueryBuilder;
  17. use Pagerfanta\Adapter\DoctrineORMAdapter;
  18. use Pagerfanta\Pagerfanta;
  19. use Sylius\Component\Grid\Data\DataSourceInterface;
  20. use Sylius\Component\Grid\Data\ExpressionBuilderInterface;
  21. use Sylius\Component\Grid\Parameters;
  23. final class DataSource implements DataSourceInterface
  24. {
  25.     private QueryBuilder $queryBuilder;
  27.     private ExpressionBuilderInterface $expressionBuilder;
  29.     private bool $fetchJoinCollection;
  31.     private bool $useOutputWalkers;
  33.     /**
  34.      * @param bool $fetchJoinCollection must be 'true' when the query fetch-joins a to-many collection,
  35.      *                                  otherwise the pagination will yield incorrect results
  36.      *                                  https://www.doctrine-project.org/projects/doctrine-orm/en/2.7/tutorials/pagination.html
  37.      * @param bool $useOutputWalkers must be 'true' if the query has an order by statement for a field from
  38.      *                                the to-many association, otherwise it will throw an exception
  39.      *                                might greatly affect the performance (https://github.com/Sylius/Sylius/issues/3775)
  40.      */
  41.     public function __construct(QueryBuilder $queryBuilder, bool $fetchJoinCollection, bool $useOutputWalkers)
  42.     {
  43.         $this->queryBuilder = $queryBuilder;
  44.         $this->expressionBuilder = new ExpressionBuilder($queryBuilder);
  45.         $this->fetchJoinCollection = $fetchJoinCollection;
  46.         $this->useOutputWalkers = $useOutputWalkers;
  47.     }
  49.     public function restrict($expression, string $condition = DataSourceInterface::CONDITION_AND): void
  50.     {
  51.         switch ($condition) {
  52.             case DataSourceInterface::CONDITION_AND:
  53.                 $this->queryBuilder->andWhere($expression);
  55.                 break;
  56.             case DataSourceInterface::CONDITION_OR:
  57.                 $this->queryBuilder->orWhere($expression);
  59.                 break;
  60.         }
  61.     }
  63.     public function getExpressionBuilder(): ExpressionBuilderInterface
  64.     {
  65.         return $this->expressionBuilder;
  66.     }
  68.     public function getData(Parameters $parameters)
  69.     {
  70.         $paginator = new Pagerfanta(
  71.             new DoctrineORMAdapter($this->queryBuilder, $this->fetchJoinCollection, $this->useOutputWalkers)
  72.         );
  73.         $paginator->setNormalizeOutOfRangePages(true);
  74.         $paginator->setCurrentPage($parameters->get('page', 1));
  76.         return $paginator;
  77.     }
  78. }