vendor/knplabs/knp-components/src/Knp/Component/Pager/Event/Subscriber/Filtration/PropelQuerySubscriber.php line 22

Open in your IDE?
  1. <?php
  3. namespace Knp\Component\Pager\Event\Subscriber\Filtration;
  5. use Knp\Component\Pager\Event\ItemsEvent;
  6. use Knp\Component\Pager\PaginatorInterface;
  7. use Symfony\Component\EventDispatcher\EventSubscriberInterface;
  8. use Symfony\Component\HttpFoundation\Request;
  10. class PropelQuerySubscriber implements EventSubscriberInterface
  11. {
  12.     /**
  13.      * @var Request
  14.      */
  15.     private $request;
  17.     public function __construct(?Request $request)
  18.     {
  19.         $this->request = $request ?? Request::createFromGlobals();
  20.     }
  22.     public function items(ItemsEvent $event): void
  23.     {
  24.         $query = $event->target;
  25.         if ($query instanceof \ModelCriteria) {
  26.             if (!$this->request->query->has($event->options[PaginatorInterface::FILTER_VALUE_PARAMETER_NAME])) {
  27.                 return;
  28.             }
  29.             if ($this->request->query->has($event->options[PaginatorInterface::FILTER_FIELD_PARAMETER_NAME])) {
  30.                 $columns = $this->request->query->get($event->options[PaginatorInterface::FILTER_FIELD_PARAMETER_NAME]);
  31.             } elseif (!empty($event->options[PaginatorInterface::DEFAULT_FILTER_FIELDS])) {
  32.                 $columns = $event->options[PaginatorInterface::DEFAULT_FILTER_FIELDS];
  33.             } else {
  34.                 return;
  35.             }
  36.             if (is_string($columns) && false !== strpos($columns, ',')) {
  37.                 $columns = explode(',', $columns);
  38.             }
  39.             $columns = (array) $columns;
  40.             if (isset($event->options[PaginatorInterface::FILTER_FIELD_ALLOW_LIST])) {
  41.                 foreach ($columns as $column) {
  42.                     if (!in_array($column, $event->options[PaginatorInterface::FILTER_FIELD_ALLOW_LIST])) {
  43.                         throw new \UnexpectedValueException("Cannot filter by: [{$column}] this field is not in allow list");
  44.                     }
  45.                 }
  46.             }
  47.             $value = $this->request->query->get($event->options[PaginatorInterface::FILTER_VALUE_PARAMETER_NAME]);
  48.             $criteria = \Criteria::EQUAL;
  49.             if (false !== strpos($value, '*')) {
  50.                 $value = str_replace('*', '%', $value);
  51.                 $criteria = \Criteria::LIKE;
  52.             }
  53.             foreach ($columns as $column) {
  54.                 if (false !== strpos($column, '.')) {
  55.                     $query->where($column.$criteria.'?', $value);
  56.                 } else {
  57.                     $query->{'filterBy'.$column}($value, $criteria);
  58.                 }
  59.             }
  60.         }
  61.     }
  63.     public static function getSubscribedEvents(): array
  64.     {
  65.         return [
  66.             'knp_pager.items' => ['items', 0],
  67.         ];
  68.     }
  69. }