Criteriable::searchByCriteriaQueryPerColumn() - Code Metrics - Inspection of "add the ability to overwrite how the search is don..." - mshamaseen/laravel-repositories - Measure and Improve Code Quality continuously with Scrutinizer

Passed
Push — main ( 67fd11...cd2b2c )

by Mohammad
created 2023-09-14 13:35 UTC
Criteriable::searchByCriteriaQueryPerColumn() A

↳ Parent: Criteriable
Complexity

Conditions	1
Paths	1
Size

Total Lines	3
Code Lines	1
Duplication

Lines	0
Ratio	0 %
Importance

Changes
Metric	Value
cc	1
eloc	1
nc	1
nop	3
dl	0
loc	3
rs	10
c	0
b	0
f	0
<?php

namespace Shamaseen\Repository\Utility\Models;

use Illuminate\Database\Eloquent\Builder;

/**
 * @method static Builder filterByCriteria(array $criteria)
 * @method static Builder searchByCriteria(array $criteria)
 * @method static Builder orderByCriteria(array $criteria)
 * @method static Builder setSearchables(array $searchables)
 * @method static Builder appendSearchables(array $searchables)
 * @method static Builder setFilterables(array $filterables)
 * @method static Builder appendFilterables(array $filterables)
 * @method static Builder setSortables(array $sortables)
 * @method static Builder appendSortables(array $sortables)
 */
trait Criteriable
{
    protected ?array $searchables = null;
    protected ?array $filterables = null;
    protected ?array $sortables = null;
    protected string $fullTextSearchMode = '';

    /**
     * @var array<array<string>>
     */
    protected ?array $fulltextSearch = [];

    public function getFilterKey()
    {
        return config('repository.filter_key');
    }

    protected function getFiltersFromCriteria(array $criteria): array
    {
        $filterKey = $this->getFilterKey();

        if ($filterKey) {
            return (array) ($criteria[$filterKey] ?? []);
        }

        return $criteria;
    }

    public function scopeFilterByCriteria($query, array $criteria): Builder
    {
        $requestFilters = $this->getFiltersFromCriteria($criteria);

        foreach ($this->getFilterables() as $method => $columns) {
            // if this is associative then it is a relation
            if ('string' === gettype($method)) {
                if (method_exists($this, $method) && array_key_exists($method, $requestFilters)) {
                    $query->whereHas($method, function ($query) use ($requestFilters, $columns, $method) {
                        /* @var $query Builder */
                        $query->where(function ($query2) use ($requestFilters, $columns, $method) {
                            /* @var $query2 Builder */
                            foreach ((array) $columns as $column) {
                                if (isset($requestFilters[$method][$column])) {
                                    $query2->where($column, $requestFilters[$method][$column]);
                                }
                            }
                        });
                    });
                }
            } elseif (array_key_exists($columns, $requestFilters)) {
                $query->where($columns, $requestFilters[$columns]);
            }
        }

        return $query;
    }
    private function buildMatchAgainst($query, array $columns, $search)
    {
        return $query->whereRaw('MATCH('.implode(',', $columns).') AGAINST (? '.$this->fullTextSearchMode.')', $search);
    }
    public function scopeSearchByCriteria($query, array $criteria): Builder
    {
        if (!isset($criteria['search'])) {
            return $query;
        }

        $query->where(function ($q) use ($criteria) {
            foreach ($this->fulltextSearch as $method => $columns) {
                if (method_exists($this, $method)) {
                    $q->orWhereHas($method, function ($q2) use ($criteria, $columns) {
                        $this->buildMatchAgainst($q2, $columns, $criteria['search']);
                    });
                } else {
                    $this->buildMatchAgainst($q, $columns, $criteria['search']);
                }
            }

            /*
             * @var Builder $q
             */
            foreach ($this->getSearchables() as $method => $columns) {
                if (method_exists($this, $method)) {
                    $q->orWhereHas($method, function ($query) use ($criteria, $columns) {
                        /* @var $query Builder */
                        $query->where(function ($query2) use ($criteria, $columns) {
                            /* @var $query2 Builder */
                            foreach ((array) $columns as $column) {
                                $this->searchByCriteriaQueryPerColumn($query2, $column, $criteria['search']);
                            }
                        });
                    });
                } else {
                    $this->searchByCriteriaQueryPerColumn($q, $columns, $criteria['search']);
                }
            }
        });

        return $query;
    }

    protected function searchByCriteriaQueryPerColumn(Builder $query, string $column, string $search): void
    {
        $query->orWhere($column, 'like', $search.'%');
    }

    public function scopeOrderByCriteria($query, array $criteria): Builder
    {
        if (isset($criteria['order']) && in_array($criteria['order'], $this->getSortables())) {
            $query->orderBy($criteria['order'], $criteria['direction'] ?? 'desc');
        }

        return $query;
    }

    /**
     * By default, all fillables and not hidden are searchables, if you want to override that explicitly set an array of searchables.
     * For a relation this is the syntax [ relationName => [columns in the relation] ].
     */
    public function getSearchables(): array
    {
        if (null !== $this->searchables) {
            return $this->searchables;
        }

        return array_diff($this->getFillable(), $this->getHidden());
        return array_diff($this->getFillable(), $this->/** @scrutinizer ignore-call */ getHidden());
    }

    public function scopeAppendSearchables($query, array $searchables): Builder
    {
        $this->searchables = collect($this->searchables)->merge($searchables)->unique()->toArray();

        return $query;
    }

    public function scopeSetSearchables($query, array $searchables): Builder
    {
        $this->searchables = $searchables;

        return $query;
    }

    /**
     * By default, all fillables and not hidden are sortables, if you want to override that explicitly set an array of sortables.
     */
    public function getSortables(): array
    {
        if (null !== $this->sortables) {
            return $this->sortables;
        }

        return array_diff($this->getFillable(), $this->getHidden());
    }

    public function scopeAppendSortables($query, array $sortables): Builder
    {
        $this->sortables = collect($this->sortables)->merge($sortables)->unique()->toArray();

        return $query;
    }

    public function scopeSetSortables($query, array $sortables): Builder
    {
        $this->sortables = $sortables;

        return $query;
    }

    /**
     * By default, all fillables and not hidden are filterables, if you want to override that explicitly set an array of searchables.
     * For a relation this is the syntax [ relationName => [columns in the relation] ].
     */
    public function getFilterables(): array
    {
        if (null !== $this->filterables) {
            return $this->filterables;
        }

        return array_diff($this->getFillable(), $this->getHidden());
    }

    public function scopeAppendFilterables($query, array $filterables): Builder
    {
        $this->filterables = collect($this->filterables)->merge($filterables)->unique()->toArray();

        return $query;
    }

    public function scopeSetFilterables($query, array $filterables): Builder
    {
        $this->filterables = $filterables;

        return $query;
    }
}

mshamaseen / laravel-repositories

Push — main ( 67fd11...cd2b2c )

Criteriable::searchByCriteriaQueryPerColumn() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like
