Zing\QueryBuilder\Concerns\WithSearchable

Complexity

Total Complexity

15

Size/Duplication

Total Lines	104
Duplicated Lines	0 %

Test Coverage

Coverage

100%

Importance

Changes	1
Bugs	0	Features	0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	searchable()	0	15	5
A	resolveNestedSearchable()	0	14	4
A	applySearchable()	0	31	4
A	applyRelationSearchable()	0	9	2

<?php

declare(strict_types=1);

namespace Zing\QueryBuilder\Concerns;

use Illuminate\Database\Eloquent\Builder;
use Illuminate\Support\Str;
use Zing\QueryBuilder\Exceptions\ParameterException;
use Zing\QueryBuilder\Filter;

trait WithSearchable
{
    use NestedRelation;

    /**
     * @param string|\Zing\QueryBuilder\Filter|array<(string|\Zing\QueryBuilder\Filter)> $searchable
     *
     * @return $this
     */
    public function searchable($searchable)
    {
        $searchable = \is_array($searchable) ? $searchable : \func_get_args();
        $search = $this->request->input('search');
        if ($search === null) {
            return $this;
        }

        if (\is_string($search) && trim($search) === '') {
            return $this;
        }

        $searchable = $this->resolveNestedSearchable($searchable);

        return $this->applySearchable($search, $searchable);
    }

    /**
     * @param mixed $search
     * @param array<(int|string), (string|array<string>|\Zing\QueryBuilder\Filter)> $searchable
     *
     * @return $this
     */
    protected function applySearchable($search, array $searchable = [])
    {
        $this->where(

It seems like where() must be provided by classes using this trait. How about adding it as abstract method to this trait?

            function (Builder $query) use ($search, $searchable): void {
                collect($searchable)->each(
                    function ($value, $key) use ($query, $search): void {
                        if ($value instanceof Filter) {
                            if ($value->getDefault() !== null) {
                                throw ParameterException::unsupportedFilterWithDefaultValueForSearch();
                            }

                            $query->orWhere(function ($query) use ($value, $search): void {
                                $value->filter($query, $search);
                            });

                            return;
                        }

                        if (is_numeric($key)) {
                            $query->orWhere($value, 'like', sprintf('%%%s%%', $search));

                            return;
                        }

                        $this->applyRelationSearchable($query, $key, (array) $value, $search);
                    }
                );
            }
        );

        return $this;
    }

    /**
     * @param array<string> $fields
     * @param mixed $search
     */
    protected function applyRelationSearchable(Builder $query, string $relation, array $fields, $search): Builder
    {
        return $query->orWhereHas(
            $relation,
            function (Builder $query) use ($fields, $search): void {
                $query->where(
                    function (Builder $query) use ($fields, $search): void {
                        foreach ($fields as $field) {
                            $query->orWhere($field, 'like', sprintf('%%%s%%', $search));
                        }
                    }
                );
            }
        );
    }

    /**
     * @param array<(string|\Zing\QueryBuilder\Filter)> $searchable
     *
     * @return array<(int|string), (string|array<string>|\Zing\QueryBuilder\Filter)>
     */
    private function resolveNestedSearchable(array $searchable): array
    {
        $results = [];
        foreach ($searchable as $singleSearchable) {
            if (! $singleSearchable instanceof Filter && Str::contains($singleSearchable, '.')) {
                [$relation, $property] = $this->resolveNestedRelation($singleSearchable);

                $results[$relation][] = $property;
            } else {
                $results[] = $singleSearchable;
            }
        }

        return $results;

The expression return $results returns an array which contains values of type Zing\QueryBuilder\Filter which are incompatible with the documented value type string|string[]&Zing\QueryBuilder\Filter.

    }
}