QueryHelper::addWhereCondition() - Code Metrics - Inspection of "change version of laravel to 6" - Alive2212/LaravelQueryHelper - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( 76d1c8...bf40a8 )

by Babak

created 2020-01-16 20:52 UTC

QueryHelper::addWhereCondition() A

↳ Parent: QueryHelper

Complexity

Conditions	3
Paths	3

Size

Total Lines	12
Code Lines	7

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	1

Metric	Value
cc	3
eloc	7
c	1
b	0
f	1
nc	3
nop	2
dl	0
loc	12
rs	10

<?php
/**
 * Created by PhpStorm.
 * User: alive
 * Date: 10/8/17
 * Time: 4:04 AM
 */

namespace Alive2212\LaravelQueryHelper;

use Illuminate\Database\Eloquent\Builder;
filter:
    dependency_paths: ["lib/*"]
use Illuminate\Database\Eloquent\Model;
filter:
    dependency_paths: ["lib/*"]

class QueryHelper
{
    /**
     * filter Delimiter
     * @var
     */
    protected $filterDelimiter = '.';


    /**
     * @var string
     */
    protected $queryFilterTitle = 'query_filters';

    /**
     * @param $query
     * @param $filters
     * @return mixed
     */
    public function orDeepFilter($query, $filters)
    {
        $result = $query;
        $keys = explode('.', $filters[0]['key']);
        if (collect($keys)->count() == 2) {
            $result = $result->orWhereHas($keys[0], function ($query) use ($filters, $keys) {

                foreach ($filters as $filter) {
                    $keys = explode('.', $filter['key']);
                    $query->where($keys[1], $filter['operator'], $filter['value']);
                }
            });
        }
        return $result;
    }

    /**
     * @param $query
     * @param $param
     * @return mixed
     */
    public function orderBy($query, $param)
    {
        $result = $query;
        if ($param->count()) {
            $query->orderBy($param[0], $param[1]);
        }
        return $result;
    }

    /**
     * @param $params
     * @param $field
     * @return array
     */
    public function getValueArray($params, $field)
    {
        $result = [];
        foreach ($params as $key => $item) {
            array_push($result, $item[$field]);
        }
        return $result;
    }

    /**
     * @param Builder $model
     * @param array $filters
     * @return Builder
     */
    public function smartDeepFilter(Builder $model, array $filters): Builder
    {
        $filters = $this->filterAdaptor($filters);
        $model = $this->addCondition($model, $filters);
        return $model;
    }

    /**
     * @param array $filters
     * @return array
     */
    public function filterAdaptor(array $filters): array
    {
        $adaptedFilters = [];
        foreach ($filters as $filter) {
            array_push($adaptedFilters, $this->filterWhereConditionAdaptor($filter));
        }
        return $adaptedFilters;
    }

    /**
     * @param array $filters
     * @return array
     */
    public function filterWhereConditionAdaptor(array $filters): array
    {
        $result = [];
        foreach ($filters as $filter) {
            $result = array_merge_recursive($result, $this->getHierarchyFilterKey($filter));
        }
        return $result;
    }

    public function getHierarchyFilterKey(array $filter): array
    {
        $filterKeyParams = $this->getFilterKey($filter);
        $firstFilterKey = $filterKeyParams[0];
        if (count($filterKeyParams) > 1) {
            unset($filterKeyParams[0]);
            $filter[0] = implode($this->filterDelimiter, $filterKeyParams);
            $result[$firstFilterKey] = $this->getHierarchyFilterKey($filter);

        } else {
            $firstFilterOperator = $this->getFilterOperator($filter);
            $firstFilterValue = $this->getFilterValue($filter);
            $result[$this->queryFilterTitle] = [
                [
                    $firstFilterKey,
                    $firstFilterOperator,
                    $firstFilterValue,
                ],
            ];
        }
        return $result;
    }

    /**
     * @param Builder $model
     * @param array $filters
     * @return Builder
     */
    public function addCondition(Builder $model, array $filters): Builder
    {
        $firstFilter = $filters[0];
        $modelQuery = $model->where(function ($query) use ($firstFilter) {
            $this->addWhereCondition($query, $firstFilter);
        });
        unset($filters[0]);
        foreach ($filters as $filter) {
            $modelQuery = $modelQuery->orWhere(function ($query) use ($filter) {
                $this->addWhereCondition($query, $filter);
            });
        }
        return $modelQuery;
    }

    /**
     * @param Builder $model
     * @param array $filters
     * @return Builder
     */
    public function addWhereCondition(Builder $model, array $filters): Builder
    {
        foreach ($filters as $filterKey => $filtersValues) {
            if ($filterKey == $this->queryFilterTitle) {
                $model = $model->where($filtersValues);
            } else {
                $model = $model->whereHas($filterKey, function (Builder $query) use ($model, $filtersValues) {

                    $query = $this->addWhereCondition($query,$filtersValues);

                });
            }
        }
        return $model;
    }

    /**
     * @return string
     */
    public function getFilterDelimiter():string
    {
        return $this->filterDelimiter;
    }

    /**
     * @param $filterDelimiter
     * @return QueryHelper
     */
    public function setFilterDelimiter($filterDelimiter):QueryHelper
    {
        $this->filterDelimiter = $filterDelimiter;
        return $this;
    }

    /**
     * @param array $filter
     * @return array
     */
    public function getFilterKey(array $filter): array
    {
        if (array_key_exists('key', $filter)) {
            $result = explode($this->filterDelimiter, $filter['key']);
        } else {
            $result = explode($this->filterDelimiter, $filter[0]);
        }
        return $result;
    }

    /**
     * @param array $filter
     * @return string
     */
    public function getFilterOperator(array $filter): string
    {
        return array_key_exists('operator', $filter) ? $filter['operator'] : $filter[1];
    }

    /**
     * @param array $filter
     * @return string
     */
    public function getFilterValue(array $filter): string
    {
        return array_key_exists('value', $filter) ? $filter['value'] : $filter[2];
    }
}

1			<?php
2			/**
3			* Created by PhpStorm.
4			* User: alive
5			* Date: 10/8/17
6			* Time: 4:04 AM
7			*/
8
9			namespace Alive2212\LaravelQueryHelper;
10
11			use Illuminate\Database\Eloquent\Builder;
			0 ignored issues – show Bug introduced 2020-01-16 20:55 UTC by Report Bug Copy Issue Report The type `Illuminate\Database\Eloquent\Builder` was not found. Maybe you did not declare it correctly or list all dependencies? The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g. `excluded_paths: ["lib/"]`, you can move it to the dependency path list as follows: filter: dependency_paths: ["lib/"] For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths Loading history...
12			use Illuminate\Database\Eloquent\Model;
			0 ignored issues – show Bug introduced 2020-01-16 20:55 UTC by Report Bug Copy Issue Report The type `Illuminate\Database\Eloquent\Model` was not found. Maybe you did not declare it correctly or list all dependencies? The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g. `excluded_paths: ["lib/"]`, you can move it to the dependency path list as follows: filter: dependency_paths: ["lib/"] For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths Loading history...
13
14			class QueryHelper
15			{
16			/**
17			* filter Delimiter
18			* @var
19			*/
20			protected $filterDelimiter = '.';
21
22
23			/**
24			* @var string
25			*/
26			protected $queryFilterTitle = 'query_filters';
27
28			/**
29			* @param $query
30			* @param $filters
31			* @return mixed
32			*/
33			public function orDeepFilter($query, $filters)
34			{
35			$result = $query;
36			$keys = explode('.', $filters[0]['key']);
37			if (collect($keys)->count() == 2) {
38			$result = $result->orWhereHas($keys[0], function ($query) use ($filters, $keys) {
			0 ignored issues – show Unused Code introduced 2018-05-28 10:29 UTC by Report Bug Copy Issue Report The import `$keys` is not used and could be removed. This check looks for imports that have been defined, but are not used in the scope. Loading history...
39			foreach ($filters as $filter) {
40			$keys = explode('.', $filter['key']);
41			$query->where($keys[1], $filter['operator'], $filter['value']);
42			}
43			});
44			}
45			return $result;
46			}
47
48			/**
49			* @param $query
50			* @param $param
51			* @return mixed
52			*/
53			public function orderBy($query, $param)
54			{
55			$result = $query;
56			if ($param->count()) {
57			$query->orderBy($param[0], $param[1]);
58			}
59			return $result;
60			}
61
62			/**
63			* @param $params
64			* @param $field
65			* @return array
66			*/
67			public function getValueArray($params, $field)
68			{
69			$result = [];
70			foreach ($params as $key => $item) {
71			array_push($result, $item[$field]);
72			}
73			return $result;
74			}
75
76			/**
77			* @param Builder $model
78			* @param array $filters
79			* @return Builder
80			*/
81			public function smartDeepFilter(Builder $model, array $filters): Builder
82			{
83			$filters = $this->filterAdaptor($filters);
84			$model = $this->addCondition($model, $filters);
85			return $model;
86			}
87
88			/**
89			* @param array $filters
90			* @return array
91			*/
92			public function filterAdaptor(array $filters): array
93			{
94			$adaptedFilters = [];
95			foreach ($filters as $filter) {
96			array_push($adaptedFilters, $this->filterWhereConditionAdaptor($filter));
97			}
98			return $adaptedFilters;
99			}
100
101			/**
102			* @param array $filters
103			* @return array
104			*/
105			public function filterWhereConditionAdaptor(array $filters): array
106			{
107			$result = [];
108			foreach ($filters as $filter) {
109			$result = array_merge_recursive($result, $this->getHierarchyFilterKey($filter));
110			}
111			return $result;
112			}
113
114			public function getHierarchyFilterKey(array $filter): array
115			{
116			$filterKeyParams = $this->getFilterKey($filter);
117			$firstFilterKey = $filterKeyParams[0];
118			if (count($filterKeyParams) > 1) {
119			unset($filterKeyParams[0]);
120			$filter[0] = implode($this->filterDelimiter, $filterKeyParams);
121			$result[$firstFilterKey] = $this->getHierarchyFilterKey($filter);
			0 ignored issues – show Comprehensibility Best Practice introduced 2020-01-16 20:55 UTC by Report Bug Copy Issue Report `$result` was never initialized. Although not strictly required by PHP, it is generally a good practice to add `$result = array();` before regardless. Loading history...
122			} else {
123			$firstFilterOperator = $this->getFilterOperator($filter);
124			$firstFilterValue = $this->getFilterValue($filter);
125			$result[$this->queryFilterTitle] = [
126			[
127			$firstFilterKey,
128			$firstFilterOperator,
129			$firstFilterValue,
130			],
131			];
132			}
133			return $result;
134			}
135
136			/**
137			* @param Builder $model
138			* @param array $filters
139			* @return Builder
140			*/
141			public function addCondition(Builder $model, array $filters): Builder
142			{
143			$firstFilter = $filters[0];
144			$modelQuery = $model->where(function ($query) use ($firstFilter) {
145			$this->addWhereCondition($query, $firstFilter);
146			});
147			unset($filters[0]);
148			foreach ($filters as $filter) {
149			$modelQuery = $modelQuery->orWhere(function ($query) use ($filter) {
150			$this->addWhereCondition($query, $filter);
151			});
152			}
153			return $modelQuery;
154			}
155
156			/**
157			* @param Builder $model
158			* @param array $filters
159			* @return Builder
160			*/
161			public function addWhereCondition(Builder $model, array $filters): Builder
162			{
163			foreach ($filters as $filterKey => $filtersValues) {
164			if ($filterKey == $this->queryFilterTitle) {
165			$model = $model->where($filtersValues);
166			} else {
167			$model = $model->whereHas($filterKey, function (Builder $query) use ($model, $filtersValues) {
			0 ignored issues – show Unused Code introduced 2020-01-16 20:55 UTC by Report Bug Copy Issue Report The import `$model` is not used and could be removed. This check looks for imports that have been defined, but are not used in the scope. Loading history...
168			$query = $this->addWhereCondition($query,$filtersValues);
			0 ignored issues – show Unused Code introduced 2020-01-16 20:55 UTC by Report Bug Copy Issue Report The assignment to `$query` is dead and can be removed. Loading history...
169			});
170			}
171			}
172			return $model;
173			}
174
175			/**
176			* @return string
177			*/
178			public function getFilterDelimiter():string
179			{
180			return $this->filterDelimiter;
181			}
182
183			/**
184			* @param $filterDelimiter
185			* @return QueryHelper
186			*/
187			public function setFilterDelimiter($filterDelimiter):QueryHelper
188			{
189			$this->filterDelimiter = $filterDelimiter;
190			return $this;
191			}
192
193			/**
194			* @param array $filter
195			* @return array
196			*/
197			public function getFilterKey(array $filter): array
198			{
199			if (array_key_exists('key', $filter)) {
200			$result = explode($this->filterDelimiter, $filter['key']);
201			} else {
202			$result = explode($this->filterDelimiter, $filter[0]);
203			}
204			return $result;
205			}
206
207			/**
208			* @param array $filter
209			* @return string
210			*/
211			public function getFilterOperator(array $filter): string
212			{
213			return array_key_exists('operator', $filter) ? $filter['operator'] : $filter[1];
214			}
215
216			/**
217			* @param array $filter
218			* @return string
219			*/
220			public function getFilterValue(array $filter): string
221			{
222			return array_key_exists('value', $filter) ? $filter['value'] : $filter[2];
223			}
224			}

Alive2212 / LaravelQueryHelper

Push — master ( 76d1c8...bf40a8 )

QueryHelper::addWhereCondition() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like