Builder::i18nDeleteQuery() - Code Metrics - spletna-postaja/translatable - Measure and Improve Code Quality continuously with Scrutinizer

Builder::i18nDeleteQuery() A
last analyzed 2021-09-06 11:59 UTC

↳ Parent: Builder

Complexity

Conditions	2
Paths	2

Size

Total Lines	8
Code Lines	4

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	2
eloc	4
c	1
b	0
f	0
nc	2
nop	1
dl	0
loc	8
rs	10

<?php

namespace Laraplus\Data;

use Illuminate\Database\Eloquent\Builder as EloquentBuilder;

class Builder extends EloquentBuilder
{
    /**
     * Update a record in the database.
     *
     * @param array $values
     *
     * @return int
     */
    public function update(array $values)
    {
        $updated = 0;
        $modelKey = $this->getModel()->getKey();
        $modelKeyName = $this->model->getKeyName();
        $values = $this->addUpdatedAtColumn($values);
        [$values, $i18nValues] = $this->filterValues($values);
        $ids = $modelKey ? [$modelKey] : $this->pluck($modelKeyName)->all();

        if ($values) {
            $updated += $this->updateBase($values, $ids);
        }

        if ($i18nValues) {
            $updated += $this->updateI18n($i18nValues, $ids);
        }

        return $updated;
    }

    /**
     * Increment a column's value by a given amount.
     *
     * @param string $column
     * @param int $amount
     * @param array $extra
     *
     * @return int
     */
    public function increment($column, $amount = 1, array $extra = [])
    {
        $extra = $this->addUpdatedAtColumn($extra);

        return $this->noTranslationsQuery()->increment($column, $amount, $extra);
    }

    /**
     * Decrement a column's value by a given amount.
     *
     * @param string $column
     * @param int $amount
     * @param array $extra
     *
     * @return int
     */
    public function decrement($column, $amount = 1, array $extra = [])
    {
        $extra = $this->addUpdatedAtColumn($extra);

        return $this->noTranslationsQuery()->decrement($column, $amount, $extra);
    }

    /**
     * Insert a new record into the database.
     *
     * @param array $values
     *
     * @return bool
     */
    public function insert(array $values)
    {
        [$values, $i18nValues] = $this->filterValues($values);

        if ($this->query->insert($values)) {
            return $this->insertI18n($i18nValues, $values[$this->model->getKeyName()]);
        }

        return false;
    }

    /**
     * Insert a new record and get the value of the primary key.
     *
     * @param array $values
     * @param string $sequence
     *
     * @return int
     */
    public function insertGetId(array $values, $sequence = null)
    {
        [$values, $i18nValues] = $this->filterValues($values);

        if ($id = $this->query->insertGetId($values, $sequence)) {
            if ($this->insertI18n($i18nValues, $id)) {
                return $id;
            }
        }

        return false;

    }

    /**
     * Delete a record from the database.
     *
     * @return mixed
     */
    public function delete()
    {
        if (isset($this->onDelete)) {
            return call_user_func($this->onDelete, $this);
        }

        return $this->i18nDeleteQuery()->delete() | $this->toBase()->delete();
    }

    /**
     * Run the default delete function on the builder.
     *
     * @return mixed
     */
    public function forceDelete()
    {
        return $this->i18nDeleteQuery(false)->delete() & $this->query->delete();
    }

    /**
     * Filters translatable values from non-translatable.
     *
     * @param array $values
     *
     * @return array
     */
    protected function filterValues(array $values)
    {
        $attributes = $this->model->translatableAttributes();
        $translatable = [];

        foreach ($attributes as $key) {
            if (array_key_exists($key, $values)) {
                $translatable[$key] = $values[$key];

                unset($values[$key]);
            }
        }

        return [$values, $translatable];
    }

    /**
     * Insert translation.
     *
     * @param array $values
     * @param mixed $key
     *
     * @return bool
     */
    protected function insertI18n(array $values, $key)
    {
        if (count($values) == 0) {
            return true;
        }

        $values[$this->model->getForeignKey()] = $key;
        $values[$this->model->getLocaleKey()] = $this->model->getLocale();

        return $this->i18nQuery()->insert($values);
    }

    /**
     * Update values in base table.
     *
     * @param array $values
     * @param array $ids
     *
     * @return mixed
     */
    private function updateBase(array $values, array $ids)
    {
        $query = $this->model
            ->newQuery()
            ->whereIn($this->model->getKeyName(), $ids)
            ->getQuery();

        return $query->update($values);
    }

    /**
     * Update translations.
     *
     * @param array $values
     * @param array $ids
     *
     * @return bool
     */
    protected function updateI18n(array $values, array $ids)
    {
        if (count($values) == 0) {
            return true;
        }

        $updated = 0;

        foreach ($ids as $id) {
            $query = $this->i18nQuery()
                ->whereOriginal($this->model->getForeignKey(), $id)
                ->whereOriginal($this->model->getLocaleKey(), $this->model->getLocale());

            if ($query->exists()) {
                unset($values[$this->model->getLocaleKey()]);

                $updated += $query->update($values);
            } else {
                $updated += $this->insertI18n($values, $id);
            }
        }

        return $updated;
    }

    /**
     * Get the query builder instance for translation table.
     *
     * @return \Illuminate\Database\Query\Builder
     */
    public function i18nQuery()
    {
        $query = $this->getModel()->newQueryWithoutScopes()->getQuery();

        $query->from($this->model->getI18nTable());

        return $query;
    }

    /**
     * Get the delete query instance for translation table.
     *
     * @param bool $withGlobalScopes
     *
     * @return \Illuminate\Database\Query\Builder
     */
    protected function i18nDeleteQuery($withGlobalScopes = true)
    {
        $subQuery = $withGlobalScopes ? $this->toBase() : $this->getQuery();

        $subQuery->select($this->model->getQualifiedKeyName());

        return $this->i18nQuery()->whereIn(
            $this->model->getForeignKey(), $subQuery->pluck($this->model->getKeyName())
        );
    }

    /**
     * Get the base query without translations.
     *
     * @return \Illuminate\Database\Query\Builder
     */
    protected function noTranslationsQuery()
    {
        return $this->withoutGlobalScope(TranslatableScope::class)->toBase();
    }
}


1			<?php
2
3			namespace Laraplus\Data;
4
5			use Illuminate\Database\Eloquent\Builder as EloquentBuilder;
6
7			class Builder extends EloquentBuilder
8			{
9			/**
10			* Update a record in the database.
11			*
12			* @param array $values
13			*
14			* @return int
15			*/
16			public function update(array $values)
17			{
18			$updated = 0;
19			$modelKey = $this->getModel()->getKey();
20			$modelKeyName = $this->model->getKeyName();
21			$values = $this->addUpdatedAtColumn($values);
22			[$values, $i18nValues] = $this->filterValues($values);
23			$ids = $modelKey ? [$modelKey] : $this->pluck($modelKeyName)->all();
24
25			if ($values) {
26			$updated += $this->updateBase($values, $ids);
27			}
28
29			if ($i18nValues) {
30			$updated += $this->updateI18n($i18nValues, $ids);
31			}
32
33			return $updated;
34			}
35
36			/**
37			* Increment a column's value by a given amount.
38			*
39			* @param string $column
40			* @param int $amount
41			* @param array $extra
42			*
43			* @return int
44			*/
45			public function increment($column, $amount = 1, array $extra = [])
46			{
47			$extra = $this->addUpdatedAtColumn($extra);
48
49			return $this->noTranslationsQuery()->increment($column, $amount, $extra);
50			}
51
52			/**
53			* Decrement a column's value by a given amount.
54			*
55			* @param string $column
56			* @param int $amount
57			* @param array $extra
58			*
59			* @return int
60			*/
61			public function decrement($column, $amount = 1, array $extra = [])
62			{
63			$extra = $this->addUpdatedAtColumn($extra);
64
65			return $this->noTranslationsQuery()->decrement($column, $amount, $extra);
66			}
67
68			/**
69			* Insert a new record into the database.
70			*
71			* @param array $values
72			*
73			* @return bool
74			*/
75			public function insert(array $values)
76			{
77			[$values, $i18nValues] = $this->filterValues($values);
78
79			if ($this->query->insert($values)) {
80			return $this->insertI18n($i18nValues, $values[$this->model->getKeyName()]);
81			}
82
83			return false;
84			}
85
86			/**
87			* Insert a new record and get the value of the primary key.
88			*
89			* @param array $values
90			* @param string $sequence
91			*
92			* @return int
93			*/
94			public function insertGetId(array $values, $sequence = null)
95			{
96			[$values, $i18nValues] = $this->filterValues($values);
97
98			if ($id = $this->query->insertGetId($values, $sequence)) {
99			if ($this->insertI18n($i18nValues, $id)) {
100			return $id;
101			}
102			}
103
104			return false;
			0 ignored issues – show Bug Best Practice introduced 2019-10-15 09:58 UTC by Report Bug Copy Issue Report The expression `return false` returns the type `false` which is incompatible with the documented return type `integer`. Loading history...
105			}
106
107			/**
108			* Delete a record from the database.
109			*
110			* @return mixed
111			*/
112			public function delete()
113			{
114			if (isset($this->onDelete)) {
115			return call_user_func($this->onDelete, $this);
116			}
117
118			return $this->i18nDeleteQuery()->delete() \| $this->toBase()->delete();
119			}
120
121			/**
122			* Run the default delete function on the builder.
123			*
124			* @return mixed
125			*/
126			public function forceDelete()
127			{
128			return $this->i18nDeleteQuery(false)->delete() & $this->query->delete();
129			}
130
131			/**
132			* Filters translatable values from non-translatable.
133			*
134			* @param array $values
135			*
136			* @return array
137			*/
138			protected function filterValues(array $values)
139			{
140			$attributes = $this->model->translatableAttributes();
141			$translatable = [];
142
143			foreach ($attributes as $key) {
144			if (array_key_exists($key, $values)) {
145			$translatable[$key] = $values[$key];
146
147			unset($values[$key]);
148			}
149			}
150
151			return [$values, $translatable];
152			}
153
154			/**
155			* Insert translation.
156			*
157			* @param array $values
158			* @param mixed $key
159			*
160			* @return bool
161			*/
162			protected function insertI18n(array $values, $key)
163			{
164			if (count($values) == 0) {
165			return true;
166			}
167
168			$values[$this->model->getForeignKey()] = $key;
169			$values[$this->model->getLocaleKey()] = $this->model->getLocale();
170
171			return $this->i18nQuery()->insert($values);
172			}
173
174			/**
175			* Update values in base table.
176			*
177			* @param array $values
178			* @param array $ids
179			*
180			* @return mixed
181			*/
182			private function updateBase(array $values, array $ids)
183			{
184			$query = $this->model
185			->newQuery()
186			->whereIn($this->model->getKeyName(), $ids)
187			->getQuery();
188
189			return $query->update($values);
190			}
191
192			/**
193			* Update translations.
194			*
195			* @param array $values
196			* @param array $ids
197			*
198			* @return bool
199			*/
200			protected function updateI18n(array $values, array $ids)
201			{
202			if (count($values) == 0) {
203			return true;
204			}
205
206			$updated = 0;
207
208			foreach ($ids as $id) {
209			$query = $this->i18nQuery()
210			->whereOriginal($this->model->getForeignKey(), $id)
211			->whereOriginal($this->model->getLocaleKey(), $this->model->getLocale());
212
213			if ($query->exists()) {
214			unset($values[$this->model->getLocaleKey()]);
215
216			$updated += $query->update($values);
217			} else {
218			$updated += $this->insertI18n($values, $id);
219			}
220			}
221
222			return $updated;
223			}
224
225			/**
226			* Get the query builder instance for translation table.
227			*
228			* @return \Illuminate\Database\Query\Builder
229			*/
230			public function i18nQuery()
231			{
232			$query = $this->getModel()->newQueryWithoutScopes()->getQuery();
233
234			$query->from($this->model->getI18nTable());
235
236			return $query;
237			}
238
239			/**
240			* Get the delete query instance for translation table.
241			*
242			* @param bool $withGlobalScopes
243			*
244			* @return \Illuminate\Database\Query\Builder
245			*/
246			protected function i18nDeleteQuery($withGlobalScopes = true)
247			{
248			$subQuery = $withGlobalScopes ? $this->toBase() : $this->getQuery();
249
250			$subQuery->select($this->model->getQualifiedKeyName());
251
252			return $this->i18nQuery()->whereIn(
253			$this->model->getForeignKey(), $subQuery->pluck($this->model->getKeyName())
254			);
255			}
256
257			/**
258			* Get the base query without translations.
259			*
260			* @return \Illuminate\Database\Query\Builder
261			*/
262			protected function noTranslationsQuery()
263			{
264			return $this->withoutGlobalScope(TranslatableScope::class)->toBase();
265			}
266			}
267

spletna-postaja / translatable

Builder::i18nDeleteQuery() A last analyzed 2021-09-06 11:59 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

Builder::i18nDeleteQuery() A
last analyzed 2021-09-06 11:59 UTC