RelatedPlusTrait::modelJoinSelects() - Code Metrics - blasttech/eloquent-related-plus - Measure and Improve Code Quality continuously with Scrutinizer

RelatedPlusTrait::modelJoinSelects() A
last analyzed 2021-04-13 00:05 UTC

↳ Parent: RelatedPlusTrait

Complexity

Conditions	3
Paths	4

Size

Total Lines	11
Code Lines	5

Duplication

Lines	0
Ratio	0 %

Importance

Changes	2
Bugs	0	Features	0

Metric	Value
cc	3
eloc	5
c	2
b	0
f	0
nc	4
nop	3
dl	0
loc	11
rs	10

<?php

namespace Blasttech\EloquentRelatedPlus;

use Illuminate\Database\Eloquent\Builder;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\BelongsTo;
use Illuminate\Database\Eloquent\Relations\HasOneOrMany;
use Illuminate\Database\Query\Expression;
use Illuminate\Database\Query\JoinClause;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Schema;

/**
 * Trait RelatedPlusTrait
 *
 * @property array attributes
 * @property array nullable
 * @property array orderFields
 * @property array orderDefaults
 * @property array orderRelations
 * @property array orderWith
 * @property array searchFields
 * @property string connection
 * @method Model getModel()
 * @method string getTable()
 */
trait RelatedPlusTrait
{
    use CustomOrderTrait, SearchTrait, HelpersTrait;

    /**
     * Boot method for trait
     *
     */
    public static function bootRelatedPlusTrait()
    {
        static::saving(function ($model) {
            if (!empty($model->nullable)) {
                /* @var \Illuminate\Database\Eloquent\Model|RelatedPlusTrait|static $model */
                $model->setAttributesNull();
            }
        });
    }


    /**
     * Get the search fields for the model
     *
     * @return array
     */
    public function getSearchFields()
    {
        return $this->hasSearchFields() ? $this->searchFields : [];
    }

    /**
     * Set the search fields for the model
     *
     * @param array $searchFields
     */
    public function setSearchFields(array $searchFields)
    {
        $this->searchFields = $searchFields;
    }

    /**
     * Add joins for one or more relations
     * This determines the foreign key relations automatically to prevent the need to figure out the columns.
     * Usages:
     * $query->modelJoin('customers')
     * $query->modelJoin('customer.client')
     *
     * @param Builder $query
     * @param string $relationName
     * @param string $operator
     * @param string $type
     * @param bool $where
     * @param bool $relatedSelect
     * @param string|null $direction
     *
     * @return Builder
     */
    public function scopeModelJoin(
        Builder $query,
        $relationName,
        $operator = '=',
        $type = 'left',
        $where = false,
        $relatedSelect = true,
        $direction = null
    ) {
        foreach ($this->parseRelationNames($this->getModel(), $relationName) as $relation) {
            // Add selects
            $query = $this->modelJoinSelects($query, $relation, $relatedSelect);

            $query->relationJoin($relation, $operator, $type, $where, $direction);
        }

        return $query;
    }

    /**
     * Get the relations from a relation name
     * $relationName can be a single relation
     * Usage for User model:
     * parseRelationNames('customer') returns [$user->customer()]
     * parseRelationNames('customer.contact') returns [$user->customer(), $user->customer->contact()]
     *
     * @param Model $model
     * @param string $relationNameString
     * @return RelationPlus[]
     */
    protected function parseRelationNames($model, $relationNameString)
    {
        $relationNames = explode('.', $relationNameString);
        $parentRelation = null;
        $relations = [];

        foreach ($relationNames as $relationName) {
            $relation = $this->getRelationFromName($model, $parentRelation, $relationName);
            $relations[] = new RelationPlus($relation);
            $parentRelation = $relation->getModel();
        }

        return $relations;
    }

    /**
     * @param Model $model
     * @param BelongsTo|HasOneOrMany|null $parentRelation
     * @param string $relationName
     * @return BelongsTo|HasOneOrMany
     */
    protected function getRelationFromName($model, $parentRelation, $relationName)
    {
        if (is_null($parentRelation)) {
            return $model->$relationName();
        }

        return $parentRelation->$relationName();
    }

    /**
     * Add selects for model join
     *
     * @param Builder $query
     * @param RelationPlus $relation
     * @param bool $relatedSelect
     * @return mixed
     */
    protected function modelJoinSelects($query, $relation, $relatedSelect)
    {
        if (empty($query->getQuery()->columns)) {
            $query->select($this->getTable() . ".*");
        }

        if ($relatedSelect) {
            $query = $this->selectRelated($query, $relation);
        }

        return $query;
    }

    /**
     * Add select for related table fields
     *
     * @param Builder $query
     * @param RelationPlus $relation
     * @return Builder
     */
    protected function selectRelated(Builder $query, $relation)
    {
        $connection = $this->connection;

        foreach (Schema::connection($connection)->getColumnListing($relation->tableName) as $relatedColumn) {
            $query->addSelect(
                new Expression("`$relation->tableAlias`.`$relatedColumn` AS `$relation->tableAlias.$relatedColumn`")
            );
        }

        return $query;
    }

    /**
     * Set the order of a model
     *
     * @param Builder $query
     * @param string $orderField
     * @param string $direction
     * @return Builder
     */
    public function scopeOrderByCustom(Builder $query, $orderField, $direction)
    {
        if ($this->hasOrderFieldsAndDefaults($orderField, $direction)) {
            $query = $this->removeGlobalScopes($this->getModel(), $query, 'order');
        }

        return $query->setCustomOrder($orderField, $direction);
    }

    /**
     * Use a model method to add columns or joins if in the order options
     *
     * @param Builder $query
     * @param string $order
     * @return Builder
     */
    public function scopeOrderByWith(Builder $query, $order)
    {
        if (isset($this->orderWith[$order])) {
            $query = $this->addOrderWith($query, $order);
        }

        if (isset($this->orderFields[$order])) {
            $query = $this->addOrderJoin($query, $order);
        }

        return $query;
    }

    /**
     * Join a model
     *
     * @param Builder $query
     * @param RelationPlus $relation
     * @param string $operator
     * @param string $type
     * @param boolean $where
     * @param string $direction
     * @return Builder|\Illuminate\Database\Query\Builder
     */
    public function scopeRelationJoin(
        Builder $query,
        $relation,
        $operator,
        $type,
        $where,
        $direction = null
    ) {
        $fullTableName = $relation->getTableWithAlias();

        return $query->join($fullTableName, function (JoinClause $join) use (
            $relation,
            $operator,
            $direction
        ) {
            return $relation->getRelationJoin($join, $operator, $direction);
        }, null, null, $type, $where);
    }

    /**
     * Add where statements for the model search fields
     *
     * @param Builder $query
     * @param string $searchText
     * @return Builder
     */
    public function scopeSearch(Builder $query, $searchText = '')
    {
        $searchText = trim($searchText);

        // If search is set
        if ($searchText != "" && $this->hasSearchFields()) {
            $query = $this->checkSearchFields($query, $searchText);
        }

        return $query;
    }

    /**
     * Switch a query to be a subquery of a model
     *
     * @param Builder $query
     * @param Builder $model
     * @return Builder|\Illuminate\Database\Query\Builder
     */
    public function scopeSetSubquery(Builder $query, $model)
    {
        $sql = $this->toSqlWithBindings($model);
        $table = $model->getQuery()->from;

        return $query
            ->from(DB::raw("({$sql}) as " . $table))
            ->select($table . '.*');
    }

    /**
     * Set the model order
     *
     * @param Builder $query
     * @param string $column
     * @param string $direction
     * @return Builder
     */
    public function scopeSetCustomOrder(Builder $query, $column, $direction)
    {
        if (isset($this->orderDefaults)) {
            $column = $this->setOrderColumn($column);
            $direction = $this->setOrderDirection($direction);
        }

        return $this->setOrder($query, $column, $direction);
    }

    /**
     * Check if column being sorted by is from a related model
     *
     * @param Builder $query
     * @param string $column
     * @param string $direction
     * @return Builder
     */
    public function scopeOrderByCheckModel(Builder $query, $column, $direction)
    {
        $query->orderBy(DB::raw($column), $direction);

        if (isset($this->orderRelations) && (strpos($column, '.') !== false ||
                isset($this->orderRelations[$column]))) {
            $query = $this->joinRelatedTable($query, $this->getTableFromColumn($column));
        }

        return $query;
    }
}


1			<?php
2
3			namespace Blasttech\EloquentRelatedPlus;
4
5			use Illuminate\Database\Eloquent\Builder;
6			use Illuminate\Database\Eloquent\Model;
7			use Illuminate\Database\Eloquent\Relations\BelongsTo;
8			use Illuminate\Database\Eloquent\Relations\HasOneOrMany;
9			use Illuminate\Database\Query\Expression;
10			use Illuminate\Database\Query\JoinClause;
11			use Illuminate\Support\Facades\DB;
12			use Illuminate\Support\Facades\Schema;
13
14			/**
15			* Trait RelatedPlusTrait
16			*
17			* @property array attributes
18			* @property array nullable
19			* @property array orderFields
20			* @property array orderDefaults
21			* @property array orderRelations
22			* @property array orderWith
23			* @property array searchFields
24			* @property string connection
25			* @method Model getModel()
26			* @method string getTable()
27			*/
28			trait RelatedPlusTrait
29			{
30			use CustomOrderTrait, SearchTrait, HelpersTrait;
31
32			/**
33			* Boot method for trait
34			*
35			*/
36			public static function bootRelatedPlusTrait()
37			{
38			static::saving(function ($model) {
39			if (!empty($model->nullable)) {
40			/* @var \Illuminate\Database\Eloquent\Model\|RelatedPlusTrait\|static $model */
41			$model->setAttributesNull();
42			}
43			});
44			}
45
46
47			/**
48			* Get the search fields for the model
49			*
50			* @return array
51			*/
52			public function getSearchFields()
53			{
54			return $this->hasSearchFields() ? $this->searchFields : [];
55			}
56
57			/**
58			* Set the search fields for the model
59			*
60			* @param array $searchFields
61			*/
62			public function setSearchFields(array $searchFields)
63			{
64			$this->searchFields = $searchFields;
65			}
66
67			/**
68			* Add joins for one or more relations
69			* This determines the foreign key relations automatically to prevent the need to figure out the columns.
70			* Usages:
71			* $query->modelJoin('customers')
72			* $query->modelJoin('customer.client')
73			*
74			* @param Builder $query
75			* @param string $relationName
76			* @param string $operator
77			* @param string $type
78			* @param bool $where
79			* @param bool $relatedSelect
80			* @param string\|null $direction
81			*
82			* @return Builder
83			*/
84			public function scopeModelJoin(
85			Builder $query,
86			$relationName,
87			$operator = '=',
88			$type = 'left',
89			$where = false,
90			$relatedSelect = true,
91			$direction = null
92			) {
93			foreach ($this->parseRelationNames($this->getModel(), $relationName) as $relation) {
94			// Add selects
95			$query = $this->modelJoinSelects($query, $relation, $relatedSelect);
96
97			$query->relationJoin($relation, $operator, $type, $where, $direction);
98			}
99
100			return $query;
101			}
102
103			/**
104			* Get the relations from a relation name
105			* $relationName can be a single relation
106			* Usage for User model:
107			* parseRelationNames('customer') returns [$user->customer()]
108			* parseRelationNames('customer.contact') returns [$user->customer(), $user->customer->contact()]
109			*
110			* @param Model $model
111			* @param string $relationNameString
112			* @return RelationPlus[]
113			*/
114			protected function parseRelationNames($model, $relationNameString)
115			{
116			$relationNames = explode('.', $relationNameString);
117			$parentRelation = null;
118			$relations = [];
119
120			foreach ($relationNames as $relationName) {
121			$relation = $this->getRelationFromName($model, $parentRelation, $relationName);
122			$relations[] = new RelationPlus($relation);
123			$parentRelation = $relation->getModel();
124			}
125
126			return $relations;
127			}
128
129			/**
130			* @param Model $model
131			* @param BelongsTo\|HasOneOrMany\|null $parentRelation
132			* @param string $relationName
133			* @return BelongsTo\|HasOneOrMany
134			*/
135			protected function getRelationFromName($model, $parentRelation, $relationName)
136			{
137			if (is_null($parentRelation)) {
138			return $model->$relationName();
139			}
140
141			return $parentRelation->$relationName();
142			}
143
144			/**
145			* Add selects for model join
146			*
147			* @param Builder $query
148			* @param RelationPlus $relation
149			* @param bool $relatedSelect
150			* @return mixed
151			*/
152			protected function modelJoinSelects($query, $relation, $relatedSelect)
153			{
154			if (empty($query->getQuery()->columns)) {
155			$query->select($this->getTable() . ".*");
156			}
157
158			if ($relatedSelect) {
159			$query = $this->selectRelated($query, $relation);
160			}
161
162			return $query;
163			}
164
165			/**
166			* Add select for related table fields
167			*
168			* @param Builder $query
169			* @param RelationPlus $relation
170			* @return Builder
171			*/
172			protected function selectRelated(Builder $query, $relation)
173			{
174			$connection = $this->connection;
175
176			foreach (Schema::connection($connection)->getColumnListing($relation->tableName) as $relatedColumn) {
177			$query->addSelect(
178			new Expression("`$relation->tableAlias`.`$relatedColumn` AS `$relation->tableAlias.$relatedColumn`")
179			);
180			}
181
182			return $query;
183			}
184
185			/**
186			* Set the order of a model
187			*
188			* @param Builder $query
189			* @param string $orderField
190			* @param string $direction
191			* @return Builder
192			*/
193			public function scopeOrderByCustom(Builder $query, $orderField, $direction)
194			{
195			if ($this->hasOrderFieldsAndDefaults($orderField, $direction)) {
196			$query = $this->removeGlobalScopes($this->getModel(), $query, 'order');
197			}
198
199			return $query->setCustomOrder($orderField, $direction);
200			}
201
202			/**
203			* Use a model method to add columns or joins if in the order options
204			*
205			* @param Builder $query
206			* @param string $order
207			* @return Builder
208			*/
209			public function scopeOrderByWith(Builder $query, $order)
210			{
211			if (isset($this->orderWith[$order])) {
212			$query = $this->addOrderWith($query, $order);
213			}
214
215			if (isset($this->orderFields[$order])) {
216			$query = $this->addOrderJoin($query, $order);
217			}
218
219			return $query;
220			}
221
222			/**
223			* Join a model
224			*
225			* @param Builder $query
226			* @param RelationPlus $relation
227			* @param string $operator
228			* @param string $type
229			* @param boolean $where
230			* @param string $direction
231			* @return Builder\|\Illuminate\Database\Query\Builder
232			*/
233			public function scopeRelationJoin(
234			Builder $query,
235			$relation,
236			$operator,
237			$type,
238			$where,
239			$direction = null
240			) {
241			$fullTableName = $relation->getTableWithAlias();
242
243			return $query->join($fullTableName, function (JoinClause $join) use (
244			$relation,
245			$operator,
246			$direction
247			) {
248			return $relation->getRelationJoin($join, $operator, $direction);
249			}, null, null, $type, $where);
250			}
251
252			/**
253			* Add where statements for the model search fields
254			*
255			* @param Builder $query
256			* @param string $searchText
257			* @return Builder
258			*/
259			public function scopeSearch(Builder $query, $searchText = '')
260			{
261			$searchText = trim($searchText);
262
263			// If search is set
264			if ($searchText != "" && $this->hasSearchFields()) {
265			$query = $this->checkSearchFields($query, $searchText);
266			}
267
268			return $query;
269			}
270
271			/**
272			* Switch a query to be a subquery of a model
273			*
274			* @param Builder $query
275			* @param Builder $model
276			* @return Builder\|\Illuminate\Database\Query\Builder
277			*/
278			public function scopeSetSubquery(Builder $query, $model)
279			{
280			$sql = $this->toSqlWithBindings($model);
281			$table = $model->getQuery()->from;
282
283			return $query
284			->from(DB::raw("({$sql}) as " . $table))
285			->select($table . '.*');
286			}
287
288			/**
289			* Set the model order
290			*
291			* @param Builder $query
292			* @param string $column
293			* @param string $direction
294			* @return Builder
295			*/
296			public function scopeSetCustomOrder(Builder $query, $column, $direction)
297			{
298			if (isset($this->orderDefaults)) {
299			$column = $this->setOrderColumn($column);
300			$direction = $this->setOrderDirection($direction);
301			}
302
303			return $this->setOrder($query, $column, $direction);
304			}
305
306			/**
307			* Check if column being sorted by is from a related model
308			*
309			* @param Builder $query
310			* @param string $column
311			* @param string $direction
312			* @return Builder
313			*/
314			public function scopeOrderByCheckModel(Builder $query, $column, $direction)
315			{
316			$query->orderBy(DB::raw($column), $direction);
317
318			if (isset($this->orderRelations) && (strpos($column, '.') !== false \|\|
319			isset($this->orderRelations[$column]))) {
320			$query = $this->joinRelatedTable($query, $this->getTableFromColumn($column));
321			}
322
323			return $query;
324			}
325			}
326

blasttech / eloquent-related-plus

RelatedPlusTrait::modelJoinSelects() A last analyzed 2021-04-13 00:05 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

RelatedPlusTrait::modelJoinSelects() A
last analyzed 2021-04-13 00:05 UTC