vendor/knplabs/knp-components/src/Knp/Component/Pager/Event/Subscriber/Sortable/Doctrine/ORM/QuerySubscriber.php line 14

Open in your IDE?
  1. <?php
  3. namespace Knp\Component\Pager\Event\Subscriber\Sortable\Doctrine\ORM;
  5. use Symfony\Component\EventDispatcher\EventSubscriberInterface;
  6. use Knp\Component\Pager\Event\ItemsEvent;
  7. use Knp\Component\Pager\Event\Subscriber\Sortable\Doctrine\ORM\Query\OrderByWalker;
  8. use Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\Query\Helper as QueryHelper;
  9. use Doctrine\ORM\Query;
  10. use Knp\Component\Pager\PaginatorInterface;
  12. class QuerySubscriber implements EventSubscriberInterface
  13. {
  14.     public function items(ItemsEvent $event)
  15.     {
  16.         // Check if the result has already been sorted by an other sort subscriber
  17.         $customPaginationParameters = $event->getCustomPaginationParameters();
  18.         if (!empty($customPaginationParameters['sorted']) ) {
  19.             return;
  20.         }
  22.         if ($event->target instanceof Query) {
  23.             $event->setCustomPaginationParameter('sorted', true);
  25.             if (isset($_GET[$event->options[PaginatorInterface::SORT_FIELD_PARAMETER_NAME]])) {
  26.                 $dir = isset($_GET[$event->options[PaginatorInterface::SORT_DIRECTION_PARAMETER_NAME]]) && strtolower($_GET[$event->options[PaginatorInterface::SORT_DIRECTION_PARAMETER_NAME]]) === 'asc' ? 'asc' : 'desc';
  28.                 if (isset($event->options[PaginatorInterface::SORT_FIELD_WHITELIST])) {
  29.                     if (!in_array($_GET[$event->options[PaginatorInterface::SORT_FIELD_PARAMETER_NAME]], $event->options[PaginatorInterface::SORT_FIELD_WHITELIST])) {
  30.                         throw new \UnexpectedValueException("Cannot sort by: [{$_GET[$event->options[PaginatorInterface::SORT_FIELD_PARAMETER_NAME]]}] this field is not in whitelist");
  31.                     }
  32.                 }
  34.                 $sortFieldParameterNames = $_GET[$event->options[PaginatorInterface::SORT_FIELD_PARAMETER_NAME]];
  35.                 $fields = array();
  36.                 $aliases = array();
  37.                 foreach (explode('+', $sortFieldParameterNames) as $sortFieldParameterName) {
  38.                     $parts = explode('.', $sortFieldParameterName, 2);
  40.                     // We have to prepend the field. Otherwise OrderByWalker will add
  41.                     // the order-by items in the wrong order
  42.                     array_unshift($fields, end($parts));
  43.                     array_unshift($aliases, 2 <= count($parts) ? reset($parts) : false);
  44.                 }
  46.                 $event->target
  47.                     ->setHint(OrderByWalker::HINT_PAGINATOR_SORT_DIRECTION, $dir)
  48.                     ->setHint(OrderByWalker::HINT_PAGINATOR_SORT_FIELD, $fields)
  49.                     ->setHint(OrderByWalker::HINT_PAGINATOR_SORT_ALIAS, $aliases)
  50.                 ;
  52.                 QueryHelper::addCustomTreeWalker($event->target, 'Knp\Component\Pager\Event\Subscriber\Sortable\Doctrine\ORM\Query\OrderByWalker');
  53.             }
  54.         }
  55.     }
  57.     public static function getSubscribedEvents()
  58.     {
  59.         return array(
  60.             'knp_pager.items' => array('items', 1)
  61.         );
  62.     }
  63. }