Last active
June 9, 2024 15:20
-
-
Save axelvnk/edf879af5c7dbd9616a4eeb77c7181a3 to your computer and use it in GitHub Desktop.
Api platform OR search filter
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
namespace Axelvkn\AppBundle\Filter; | |
use ApiPlatform\Core\Bridge\Doctrine\Orm\Filter\SearchFilter; | |
use ApiPlatform\Core\Bridge\Doctrine\Orm\Util\QueryNameGeneratorInterface; | |
use ApiPlatform\Core\Exception\InvalidArgumentException; | |
use Doctrine\ORM\QueryBuilder; | |
class OrSearchFilter extends SearchFilter | |
{ | |
/** | |
* {@inheritDoc} | |
*/ | |
protected function addWhereByStrategy(string $strategy, QueryBuilder $queryBuilder, QueryNameGeneratorInterface $queryNameGenerator, string $alias, string $field, $value, bool $caseSensitive) | |
{ | |
$wrapCase = $this->createWrapCase($caseSensitive); | |
$valueParameter = $queryNameGenerator->generateParameterName($field); | |
switch ($strategy) { | |
case null: | |
case self::STRATEGY_EXACT: | |
$queryBuilder | |
->orWhere(sprintf($wrapCase('%s.%s').' = '.$wrapCase(':%s'), $alias, $field, $valueParameter)) | |
->setParameter($valueParameter, $value); | |
break; | |
case self::STRATEGY_PARTIAL: | |
$queryBuilder | |
->orWhere(sprintf($wrapCase('%s.%s').' LIKE '.$wrapCase('CONCAT(\'%%\', :%s, \'%%\')'), $alias, $field, $valueParameter)) | |
->setParameter($valueParameter, $value); | |
break; | |
case self::STRATEGY_START: | |
$queryBuilder | |
->orWhere(sprintf($wrapCase('%s.%s').' LIKE '.$wrapCase('CONCAT(:%s, \'%%\')'), $alias, $field, $valueParameter)) | |
->setParameter($valueParameter, $value); | |
break; | |
case self::STRATEGY_END: | |
$queryBuilder | |
->orWhere(sprintf($wrapCase('%s.%s').' LIKE '.$wrapCase('CONCAT(\'%%\', :%s)'), $alias, $field, $valueParameter)) | |
->setParameter($valueParameter, $value); | |
break; | |
case self::STRATEGY_WORD_START: | |
$queryBuilder | |
->orWhere(sprintf($wrapCase('%1$s.%2$s').' LIKE '.$wrapCase('CONCAT(:%3$s, \'%%\')').' OR '.$wrapCase('%1$s.%2$s').' LIKE '.$wrapCase('CONCAT(\'%% \', :%3$s, \'%%\')'), $alias, $field, $valueParameter)) | |
->setParameter($valueParameter, $value); | |
break; | |
default: | |
throw new InvalidArgumentException(sprintf('strategy %s does not exist.', $strategy)); | |
} | |
} | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
services: | |
axelvnk.filter.or_search_filter: | |
class: Axelvnk\AppBundle\Filter\OrSearchFilter | |
parent: "api_platform.doctrine.orm.search_filter" | |
axelvnk.filter.customer: | |
parent: axelvnk.filter.or_search_filter | |
arguments: | |
- { name: "partial", vatNumber: "partial" } | |
tags: | |
- { name: "api_platform.filter", id: "customer.search" } | |
#now you can search /api/customers?name=0844.010.460&vatNumber=0844.010.460 and your filter will be applied with all or conditions! |
@aesislabs you're welcome
@loicngr please that is work only for string what i do if i want to search with int
Thank you very much! @loicngr
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
@loicngr This is absolutely on point, thanks !!