-
-
Save romeugodoi/e136616fd2c60e72d89e9727f2d4e338 to your computer and use it in GitHub Desktop.
Api platform OR search filter
This file contains hidden or 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 hidden or 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&name=0844.010.460 and your filter will be applied with all or conditions! |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment