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 Symfony\Component\EventDispatcher\EventSubscriberInterface;
  6. use Knp\Component\Pager\Event\ItemsEvent;
  7. use Doctrine\DBAL\Query\QueryBuilder;
  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)
  17.     {
  18.         if ($event->target instanceof QueryBuilder) {
  19.             /** @var $target QueryBuilder */
  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.             $event->count = $qb
  40.                 ->execute()
  41.                 ->fetchColumn(0)
  42.             ;
  44.             // if there is results
  45.             $event->items = array();
  46.             if ($event->count) {
  47.                 $qb = clone $target;
  48.                 $qb
  49.                     ->setFirstResult($event->getOffset())
  50.                     ->setMaxResults($event->getLimit())
  51.                 ;
  52.                 
  53.                 $event->items = $qb
  54.                     ->execute()
  55.                     ->fetchAll()
  56.                 ;
  57.             }
  58.             
  59.             $event->stopPropagation();
  60.         }
  61.     }
  63.     public static function getSubscribedEvents()
  64.     {
  65.         return array(
  66.             'knp_pager.items' => array('items', 10 /*make sure to transform before any further modifications*/)
  67.         );
  68.     }
  69. }