ControleOnline\Filter\CustomOrFilter

Complexity

Total Complexity

9

Size/Duplication

Total Lines	58
Duplicated Lines	0 %

Importance

Changes	3
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
B	filterProperty()	0	42	8
A	getDescription()	0	9	1

<?php

namespace ControleOnline\Filter;

use ApiPlatform\Doctrine\Orm\Filter\AbstractFilter;

The type ApiPlatform\Doctrine\Orm\Filter\AbstractFilter was not found. Maybe you did not declare it correctly or list all dependencies?

use ApiPlatform\Doctrine\Orm\Util\QueryNameGeneratorInterface;

The type ApiPlatform\Doctrine\Orm\Util\QueryNameGeneratorInterface was not found. Maybe you did not declare it correctly or list all dependencies?

use ApiPlatform\Metadata\Operation;

The type ApiPlatform\Metadata\Operation was not found. Maybe you did not declare it correctly or list all dependencies?

use Doctrine\ORM\QueryBuilder;

The type Doctrine\ORM\QueryBuilder was not found. Maybe you did not declare it correctly or list all dependencies?

class CustomOrFilter extends AbstractFilter
{
    public function getDescription(string $resourceClass): array
    {
        return [
            'search' => [
                'property' => null,
                'type' => 'string',
                'required' => false,
                'openapi' => [
                    'description' => 'Search across multiple fields',
                ],
            ]
        ];
    }

    protected function filterProperty(string $property, $value, QueryBuilder $queryBuilder, QueryNameGeneratorInterface $queryNameGenerator, string $resourceClass, ?Operation $operation = null, array $context = []): void
    {
        if ($property !== 'search') {
            return;
        }

        $alias = $queryBuilder->getRootAliases()[0];
        $andWhere = '';
        $relations = [];

        foreach ($this->properties as $property => $propVal) {
            $relation = explode('.', $property);

            if (count($relation) > 1) {
                if (!array_key_exists($relation[0], $relations)) {
                    $relations[$relation[0]] = uniqid();
                    $queryBuilder->leftJoin(sprintf('%s.%s', $alias, $relation[0]), 'i');
                }

                $queryBuilder->orWhere(sprintf('%s.%s LIKE :search', 'i', $relation[1]));
                $queryBuilder->setParameter('search', '%' . $value . '%');
                continue;
            }

            $andWhere .= sprintf('%s.%s LIKE :search', $alias, $property);

            next($this->properties);
            $nextKey = key($this->properties);

            if ($nextKey !== null && !strpos($nextKey, '.') !== false) {
                $andWhere .= ' OR ';
            }
        }


        if (empty($relations)) {
            $queryBuilder->andWhere($andWhere);
        } else {
            $queryBuilder->orWhere($andWhere);
        }

        $queryBuilder->setParameter('search', '%' . $value . '%');
    }
}