src/EventSubscriber/Management/SearchSubscriber.php line 64

Open in your IDE?
  1. <?php
  3. namespace App\EventSubscriber\Management;
  5. use EasyCorp\Bundle\EasyAdminBundle\Event\EasyAdminEvents;
  6. use Symfony\Component\EventDispatcher\EventSubscriberInterface;
  7. use Symfony\Component\EventDispatcher\GenericEvent;
  8. use Symfony\Component\HttpFoundation\Request;
  9. use Symfony\Component\HttpFoundation\RequestStack;
  11. class SearchSubscriber implements EventSubscriberInterface
  12. {
  13.     public function __construct(
  14.         private RequestStack $requestStack,
  15.     ) {}
  17.     public static function getSubscribedEvents(): array
  18.     {
  19.         return [
  20.             EasyAdminEvents::PRE_SEARCH => 'lowercaseSearchRequest',
  21.             EasyAdminEvents::POST_SEARCH_QUERY_BUILDER => [
  22.                 ['addRegexPhoneSearch', 0]
  23.             ],
  24.         ];
  25.     }
  27.     public function addRegexPhoneSearch(GenericEvent $event): void
  28.     {
  29.         // if($event->getArgument('entity')['name'] != 'Profile')
  30.         //     return;
  32.         $searchableFields = array_keys($event->getArgument('searchable_fields'));
  33.         $queryBuilder = $event->getArgument('query_builder');
  34.         $entitiesAlreadyJoined = $queryBuilder->getAllAliases();
  36.         foreach ($searchableFields as $fieldName) {
  37.             if(false === $this->endsWith($fieldName, 'phoneNumber'))
  38.                 continue;
  40.             $entityName = 'entity';
  41.             if (false !== strpos($fieldName, '.')) {
  42.                 // support arbitrarily nested associations (e.g. foo.bar.baz.qux)
  43.                 $associationComponents = \explode('.', $fieldName);
  44.                 for ($i = 0; $i < \count($associationComponents) - 1; ++$i) {
  45.                     $associatedEntityName = $associationComponents[$i];
  46.                     $associatedFieldName = $associationComponents[$i + 1];
  48.                     if (!\in_array($associatedEntityName, $entitiesAlreadyJoined)) {
  49.                         $parentEntityName = 0 === $i ? 'entity' : $associationComponents[$i - 1];
  50.                         $queryBuilder->leftJoin($parentEntityName . '.' . $associatedEntityName, $associatedEntityName);
  51.                         $entitiesAlreadyJoined[] = $associatedEntityName;
  52.                     }
  54.                     $entityName = $associatedEntityName;
  55.                     $fieldName = $associatedFieldName;
  56.                 }
  57.             }
  59.             $queryBuilder->orWhere(\sprintf("REGEXP_REPLACE(%s.%s, '-| ', '') LIKE :fuzzy_query", $entityName, $fieldName));
  60.             $queryBuilder->setParameter('fuzzy_query', '%'.$event->getArgument('search_query').'%');
  61.         }
  62.     }
  64.     public function lowercaseSearchRequest(GenericEvent $event): void
  65.     {
  66.         $this->requestStack->getCurrentRequest()->query->set(
  67.             'query',
  68.             mb_strtolower($this->requestStack->getCurrentRequest()->query->get('query'))
  69.         );
  70.     }
  72.     protected function endsWith( $haystack, $needle )
  73.     {
  74.         $length = strlen( $needle );
  75.         if( !$length ) {
  76.             return true;
  77.         }
  78.         return substr( $haystack, -$length ) === $needle;
  79.     }
  80. }