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

Open in your IDE?
  1. <?php
  3. namespace Knp\Component\Pager\Event\Subscriber\Sortable\Doctrine\ORM;
  5. use Doctrine\ORM\Query;
  6. use Knp\Component\Pager\ArgumentAccess\ArgumentAccessInterface;
  7. use Knp\Component\Pager\Event\ItemsEvent;
  8. use Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\Query\Helper as QueryHelper;
  9. use Knp\Component\Pager\Event\Subscriber\Sortable\Doctrine\ORM\Query\OrderByWalker;
  10. use Knp\Component\Pager\Exception\InvalidValueException;
  11. use Knp\Component\Pager\PaginatorInterface;
  12. use Symfony\Component\EventDispatcher\EventSubscriberInterface;
  14. class QuerySubscriber implements EventSubscriberInterface
  15. {
  16.     private ArgumentAccessInterface $argumentAccess;
  18.     public function __construct(ArgumentAccessInterface $argumentAccess)
  19.     {
  20.         $this->argumentAccess = $argumentAccess;
  21.     }
  23.     public function items(ItemsEvent $event): void
  24.     {
  25.         // Check if the result has already been sorted by another sort subscriber
  26.         $customPaginationParameters = $event->getCustomPaginationParameters();
  27.         if (!empty($customPaginationParameters['sorted']) ) {
  28.             return;
  29.         }
  31.         if ($event->target instanceof Query) {
  32.             $event->setCustomPaginationParameter('sorted', true);
  33.             $sortField = $event->options[PaginatorInterface::SORT_FIELD_PARAMETER_NAME];
  34.             $sortDir = $event->options[PaginatorInterface::SORT_DIRECTION_PARAMETER_NAME];
  35.             if (null !== $sortField && $this->argumentAccess->has($sortField)) {
  36.                 $dir = null !== $sortDir && $this->argumentAccess->has($sortDir) && strtolower($this->argumentAccess->get($sortDir)) === 'asc' ? 'asc' : 'desc';
  38.                 if (isset($event->options[PaginatorInterface::SORT_FIELD_ALLOW_LIST]) && !in_array($this->argumentAccess->get($sortField), $event->options[PaginatorInterface::SORT_FIELD_ALLOW_LIST])) {
  39.                     throw new InvalidValueException("Cannot sort by: [{$this->argumentAccess->get($sortField)}] this field is not in allow list.");
  40.                 }
  42.                 $sortFieldParameterNames = $this->argumentAccess->get($sortField);
  43.                 $fields = [];
  44.                 $aliases = [];
  45.                 if (!is_string($sortFieldParameterNames)) {
  46.                     throw new InvalidValueException('Cannot sort with array parameter.');
  47.                 }
  49.                 foreach (explode('+', $sortFieldParameterNames) as $sortFieldParameterName) {
  50.                     $parts = explode('.', $sortFieldParameterName, 2);
  52.                     // We have to prepend the field. Otherwise, OrderByWalker will add
  53.                     // the order-by items in the wrong order
  54.                     array_unshift($fields, end($parts));
  55.                     array_unshift($aliases, 2 <= count($parts) ? reset($parts) : false);
  56.                 }
  58.                 $event->target
  59.                     ->setHint(OrderByWalker::HINT_PAGINATOR_SORT_DIRECTION, $dir)
  60.                     ->setHint(OrderByWalker::HINT_PAGINATOR_SORT_FIELD, $fields)
  61.                     ->setHint(OrderByWalker::HINT_PAGINATOR_SORT_ALIAS, $aliases)
  62.                 ;
  64.                 QueryHelper::addCustomTreeWalker($event->target, OrderByWalker::class);
  65.             }
  66.         }
  67.     }
  69.     public static function getSubscribedEvents(): array
  70.     {
  71.         return [
  72.             'knp_pager.items' => ['items', 1],
  73.         ];
  74.     }
  75. }