vendor/knplabs/knp-components/src/Knp/Component/Pager/Event/Subscriber/Paginate/Doctrine/DBALQueryBuilderSubscriber.php line 16

Open in your IDE?
  1. <?php
  3. namespace Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine;
  5. use Doctrine\DBAL\Query\QueryBuilder;
  6. use Knp\Component\Pager\Event\ItemsEvent;
  7. use Symfony\Component\EventDispatcher\EventSubscriberInterface;
  9. /**
  10.  * DBALQueryBuilderSubscriber.php
  11.  *
  12.  * @author Vladimir Chub <v@chub.com.ua>
  13.  */
  14. class DBALQueryBuilderSubscriber implements EventSubscriberInterface
  15. {
  16.     public function items(ItemsEvent $event): void
  17.     {
  18.         if ($event->target instanceof QueryBuilder) {
  19.             /** @var QueryBuilder $target */
  20.             $target = $event->target;
  21.         
  22.             // count results
  23.             $qb = clone $target;
  24.             
  25.             //reset count orderBy since it can break query and slow it down
  26.             $qb
  27.                 ->resetQueryPart('orderBy')
  28.             ;
  29.             
  30.             // get the query
  31.             $sql = $qb->getSQL();
  32.             
  33.             $qb
  34.                 ->resetQueryParts()
  35.                 ->select('count(*) as cnt')
  36.                 ->from('(' . $sql . ')', 'dbal_count_tbl')
  37.             ;
  39.             $compat = $qb->execute();
  40.             $event->count = method_exists($compat, 'fetchColumn') ? $compat->fetchColumn(0) : $compat->fetchOne();
  42.             // if there is results
  43.             $event->items = [];
  44.             if ($event->count) {
  45.                 $qb = clone $target;
  46.                 $qb
  47.                     ->setFirstResult($event->getOffset())
  48.                     ->setMaxResults($event->getLimit())
  49.                 ;
  50.                 
  51.                 $event->items = $qb
  52.                     ->execute()
  53.                     ->fetchAll()
  54.                 ;
  55.             }
  56.             
  57.             $event->stopPropagation();
  58.         }
  59.     }
  61.     public static function getSubscribedEvents(): array
  62.     {
  63.         return [
  64.             'knp_pager.items' => ['items', 10 /*make sure to transform before any further modifications*/],
  65.         ];
  66.     }
  67. }