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

Open in your IDE?
  1. <?php
  3. namespace Knp\Component\Pager\Event\Subscriber\Filtration\Doctrine\ORM;
  5. use Doctrine\ORM\Query;
  6. use Knp\Component\Pager\Event\ItemsEvent;
  7. use Knp\Component\Pager\Event\Subscriber\Filtration\Doctrine\ORM\Query\WhereWalker;
  8. use Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\Query\Helper as QueryHelper;
  9. use Knp\Component\Pager\PaginatorInterface;
  10. use Symfony\Component\EventDispatcher\EventSubscriberInterface;
  12. class QuerySubscriber implements EventSubscriberInterface
  13. {
  14.     public function items(ItemsEvent $event)
  15.     {
  16.         if ($event->target instanceof Query) {
  17.             if (!isset($_GET[$event->options[PaginatorInterface::FILTER_VALUE_PARAMETER_NAME]]) || (empty($_GET[$event->options[PaginatorInterface::FILTER_VALUE_PARAMETER_NAME]]) && $_GET[$event->options[PaginatorInterface::FILTER_VALUE_PARAMETER_NAME]] !== "0")) {
  18.                 return;
  19.             }
  20.             if (!empty($_GET[$event->options[PaginatorInterface::FILTER_FIELD_PARAMETER_NAME]])) {
  21.                 $columns = $_GET[$event->options[PaginatorInterface::FILTER_FIELD_PARAMETER_NAME]];
  22.             } elseif (!empty($event->options[PaginatorInterface::DEFAULT_FILTER_FIELDS])) {
  23.                 $columns = $event->options[PaginatorInterface::DEFAULT_FILTER_FIELDS];
  24.             } else {
  25.                 return;
  26.             }
  27.             $value = $_GET[$event->options[PaginatorInterface::FILTER_VALUE_PARAMETER_NAME]];
  28.             if (false !== strpos($value, '*')) {
  29.                 $value = str_replace('*', '%', $value);
  30.             }
  31.             if (is_string($columns) && false !== strpos($columns, ',')) {
  32.                 $columns = explode(',', $columns);
  33.             }
  34.             $columns = (array) $columns;
  35.             if (isset($event->options[PaginatorInterface::FILTER_FIELD_WHITELIST])) {
  36.                 foreach ($columns as $column) {
  37.                     if (!in_array($column, $event->options[PaginatorInterface::FILTER_FIELD_WHITELIST])) {
  38.                         throw new \UnexpectedValueException("Cannot filter by: [{$column}] this field is not in whitelist");
  39.                     }
  40.                 }
  41.             }
  42.             $event->target
  43.                     ->setHint(WhereWalker::HINT_PAGINATOR_FILTER_VALUE, $value)
  44.                     ->setHint(WhereWalker::HINT_PAGINATOR_FILTER_COLUMNS, $columns);
  45.             QueryHelper::addCustomTreeWalker($event->target, 'Knp\Component\Pager\Event\Subscriber\Filtration\Doctrine\ORM\Query\WhereWalker');
  46.         }
  47.     }
  49.     public static function getSubscribedEvents()
  50.     {
  51.         return array(
  52.                 'knp_pager.items' => array('items', 0),
  53.         );
  54.     }
  55. }