Customer::getItemQuery() - Code Metrics - Inspection of "Split magical and non-magical implementations (#33..." - yiisoft/active-record - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( bc8b6f...7a9b1f )

by Sergei

created 2024-06-02 02:34 UTC

Customer::getItemQuery() A

↳ Parent: Customer::getName()

Complexity

Conditions	1
Paths	1

Size

Total Lines	2
Code Lines	0

Duplication

Lines	0
Ratio	0 %

Importance

Changes

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

<?php

declare(strict_types=1);

namespace Yiisoft\ActiveRecord\Tests\Stubs\ActiveRecord;

use Yiisoft\ActiveRecord\ActiveQuery;
use Yiisoft\ActiveRecord\ActiveQueryInterface;
use Yiisoft\ActiveRecord\Tests\Stubs\ActiveRecord;

/**
 * Class Customer.
 */
class Customer extends ActiveRecord
{
    public const STATUS_ACTIVE = 1;
    public const STATUS_INACTIVE = 2;

    protected int $id;
    protected string $email;
    protected string|null $name = null;
    protected string|null $address = null;
    protected int|null $status = 0;
    protected bool|string|null $bool_status = false;
    protected int|null $profile_id = null;

    /**
     * @var int|string
     */
    public $status2;
    /**
     * @var int|string|null
     */
    public $sumTotal;

    public function getTableName(): string
    {
        return 'customer';
    }

    public function relationQuery(string $name): ActiveQueryInterface
    {
        return match ($name) {
            'profile' => $this->getProfileQuery(),
            'orders' => $this->getOrdersQuery(),
            'ordersPlain' => $this->getOrdersPlainQuery(),
            'ordersNoOrder' => $this->getOrdersNoOrderQuery(),
            'expensiveOrders' => $this->getExpensiveOrdersQuery(),
            'ordersWithItems' => $this->getOrdersWithItemsQuery(),
            'expensiveOrdersWithNullFK' => $this->getExpensiveOrdersWithNullFKQuery(),
            'ordersWithNullFK' => $this->getOrdersWithNullFKQuery(),
            'orders2' => $this->getOrders2Query(),
            'orderItems' => $this->getOrderItemsQuery(),
            'orderItems2' => $this->getOrderItems2Query(),
            'items2' => $this->getItems2Query(),
            default => parent::relationQuery($name),
        };
    }

    public function getId(): int
    {
        return $this->id;
    }

    public function getEmail(): string
    {
        return $this->email;
    }

    public function getName(): string|null
    {
        return $this->name;
    }

    public function getAddress(): string|null
    {
        return $this->address;
    }

    public function getStatus(): int|null
    {
        return $this->status;
    }

    public function getBoolStatus(): bool|null
    {
        return $this->bool_status;

    }

    public function getProfileId(): int|null
    {
        return $this->profile_id;
    }

    public function setId(int $id): void
    {
        $this->id = $id;
    }

    public function setEmail(string $email): void
    {
        $this->email = $email;
    }

    public function setName(string|null $name): void
    {
        $this->name = $name;
    }

    public function setAddress(string|null $address): void
    {
        $this->address = $address;
    }

    public function setStatus(int|null $status): void
    {
        $this->status = $status;
    }

    public function setBoolStatus(bool|null $bool_status): void
    {
        $this->bool_status = $bool_status;
    }

    public function setProfileId(int|null $profile_id): void
    {
        $this->setAttribute('profile_id', $profile_id);
    }

    public function getProfile(): Profile|null
    {
        return $this->relation('profile');

    }

    public function getProfileQuery(): ActiveQuery
    {
        return $this->hasOne(Profile::class, ['id' => 'profile_id']);
    }

    public function getOrdersPlain(): array
    {
        return $this->relation('ordersPlain');

    }

    public function getOrdersPlainQuery(): ActiveQuery
    {
        return $this->hasMany(Order::class, ['customer_id' => 'id']);
    }

    public function getOrders(): array
    {
        return $this->relation('orders');

    }

    public function getOrdersQuery(): ActiveQuery
    {
        return $this->hasMany(Order::class, ['customer_id' => 'id'])->orderBy('[[id]]');
    }

    public function getOrdersNoOrder(): array
    {
        return $this->relation('ordersNoOrder');

    }

    public function getOrdersNoOrderQuery(): ActiveQuery
    {
        return $this->hasMany(Order::class, ['customer_id' => 'id']);
    }

    public function getExpensiveOrders(): array
    {
        return $this->relation('expensiveOrders');

    }

    public function getExpensiveOrdersQuery(): ActiveQuery
    {
        return $this->hasMany(Order::class, ['customer_id' => 'id'])->andWhere('[[total]] > 50')->orderBy('id');
    }

    public function getItem(): void
    {
    }

    public function getOrdersWithItems(): array
    {
        return $this->relation('ordersWithItems');

    }

    public function getOrdersWithItemsQuery(): ActiveQuery
    {
        return $this->hasMany(Order::class, ['customer_id' => 'id'])->with('orderItems');
    }

    public function getExpensiveOrdersWithNullFK(): array
    {
        return $this->relation('expensiveOrdersWithNullFK');

    }

    public function getExpensiveOrdersWithNullFKQuery(): ActiveQuery
    {
        return $this->hasMany(
            OrderWithNullFK::class,
            ['customer_id' => 'id']
        )->andWhere('[[total]] > 50')->orderBy('id');
    }

    public function getOrdersWithNullFK(): array
    {
        return $this->relation('ordersWithNullFK');

    }

    public function getOrdersWithNullFKQuery(): ActiveQuery
    {
        return $this->hasMany(OrderWithNullFK::class, ['customer_id' => 'id'])->orderBy('id');
    }

    public function getOrders2(): array
    {
        return $this->relation('orders2');

    }

    public function getOrders2Query(): ActiveQuery
    {
        return $this->hasMany(Order::class, ['customer_id' => 'id'])->inverseOf('customer2')->orderBy('id');
    }

    public function getOrderItems(): array
    {
        return $this->relation('orderItems');

    }

    /** deeply nested table relation */
    public function getOrderItemsQuery(): ActiveQuery
    {
        $rel = $this->hasMany(Item::class, ['id' => 'item_id']);

        return $rel->viaTable('order_item', ['order_id' => 'id'], function ($q) {
            /* @var $q ActiveQuery */
            $q->viaTable('order', ['customer_id' => 'id']);
        })->orderBy('id');
    }

    public function getOrderItems2(): array
    {
        return $this->relation('orderItems2');

    }

    public function getOrderItems2Query(): ActiveQuery
    {
        return $this->hasMany(OrderItem::class, ['order_id' => 'id'])
            ->via('ordersNoOrder');
    }

    public function getItems2(): array
    {
        return $this->relation('items2');

    }

    public function getItems2Query(): ActiveQuery
    {
        return $this->hasMany(Item::class, ['id' => 'item_id'])
            ->via('orderItems2');
    }
}


1			<?php
2
3			declare(strict_types=1);
4
5			namespace Yiisoft\ActiveRecord\Tests\Stubs\ActiveRecord;
6
7			use Yiisoft\ActiveRecord\ActiveQuery;
8			use Yiisoft\ActiveRecord\ActiveQueryInterface;
9			use Yiisoft\ActiveRecord\Tests\Stubs\ActiveRecord;
10
11			/**
12			* Class Customer.
13			*/
14			class Customer extends ActiveRecord
15			{
16			public const STATUS_ACTIVE = 1;
17			public const STATUS_INACTIVE = 2;
18
19			protected int $id;
20			protected string $email;
21			protected string\|null $name = null;
22			protected string\|null $address = null;
23			protected int\|null $status = 0;
24			protected bool\|string\|null $bool_status = false;
25			protected int\|null $profile_id = null;
26
27			/**
28			* @var int\|string
29			*/
30			public $status2;
31			/**
32			* @var int\|string\|null
33			*/
34			public $sumTotal;
35
36			public function getTableName(): string
37			{
38			return 'customer';
39			}
40
41			public function relationQuery(string $name): ActiveQueryInterface
42			{
43			return match ($name) {
44			'profile' => $this->getProfileQuery(),
45			'orders' => $this->getOrdersQuery(),
46			'ordersPlain' => $this->getOrdersPlainQuery(),
47			'ordersNoOrder' => $this->getOrdersNoOrderQuery(),
48			'expensiveOrders' => $this->getExpensiveOrdersQuery(),
49			'ordersWithItems' => $this->getOrdersWithItemsQuery(),
50			'expensiveOrdersWithNullFK' => $this->getExpensiveOrdersWithNullFKQuery(),
51			'ordersWithNullFK' => $this->getOrdersWithNullFKQuery(),
52			'orders2' => $this->getOrders2Query(),
53			'orderItems' => $this->getOrderItemsQuery(),
54			'orderItems2' => $this->getOrderItems2Query(),
55			'items2' => $this->getItems2Query(),
56			default => parent::relationQuery($name),
57			};
58			}
59
60			public function getId(): int
61			{
62			return $this->id;
63			}
64
65			public function getEmail(): string
66			{
67			return $this->email;
68			}
69
70			public function getName(): string\|null
71			{
72			return $this->name;
73			}
74
75			public function getAddress(): string\|null
76			{
77			return $this->address;
78			}
79
80			public function getStatus(): int\|null
81			{
82			return $this->status;
83			}
84
85			public function getBoolStatus(): bool\|null
86			{
87			return $this->bool_status;
			0 ignored issues – show Bug Best Practice introduced 2024-05-22 15:44 UTC by Report Bug Copy Issue Report The expression `return $this->bool_status` could return the type `string` which is incompatible with the type-hinted return `boolean\|null`. Consider adding an additional type-check to rule them out. Loading history...
88			}
89
90			public function getProfileId(): int\|null
91			{
92			return $this->profile_id;
93			}
94
95			public function setId(int $id): void
96			{
97			$this->id = $id;
98			}
99
100			public function setEmail(string $email): void
101			{
102			$this->email = $email;
103			}
104
105			public function setName(string\|null $name): void
106			{
107			$this->name = $name;
108			}
109
110			public function setAddress(string\|null $address): void
111			{
112			$this->address = $address;
113			}
114
115			public function setStatus(int\|null $status): void
116			{
117			$this->status = $status;
118			}
119
120			public function setBoolStatus(bool\|null $bool_status): void
121			{
122			$this->bool_status = $bool_status;
123			}
124
125			public function setProfileId(int\|null $profile_id): void
126			{
127			$this->setAttribute('profile_id', $profile_id);
128			}
129
130			public function getProfile(): Profile\|null
131			{
132			return $this->relation('profile');
			0 ignored issues – show Bug Best Practice introduced 2024-05-22 15:44 UTC by Report Bug Copy Issue Report The expression `return $this->relation('profile')` could return the type `array` which is incompatible with the type-hinted return `Yiisoft\ActiveRecord\Tes...tiveRecord\Profile\|null`. Consider adding an additional type-check to rule them out. Loading history...
133			}
134
135			public function getProfileQuery(): ActiveQuery
136			{
137			return $this->hasOne(Profile::class, ['id' => 'profile_id']);
138			}
139
140			public function getOrdersPlain(): array
141			{
142			return $this->relation('ordersPlain');
			0 ignored issues – show Bug Best Practice introduced 2024-05-22 15:44 UTC by Report Bug Copy Issue Report The expression `return $this->relation('ordersPlain')` could return the type `Yiisoft\ActiveRecord\ActiveRecordInterface\|null` which is incompatible with the type-hinted return `array`. Consider adding an additional type-check to rule them out. Loading history...
143			}
144
145			public function getOrdersPlainQuery(): ActiveQuery
146			{
147			return $this->hasMany(Order::class, ['customer_id' => 'id']);
148			}
149
150			public function getOrders(): array
151			{
152			return $this->relation('orders');
			0 ignored issues – show Bug Best Practice introduced 2024-05-22 15:44 UTC by Report Bug Copy Issue Report The expression `return $this->relation('orders')` could return the type `Yiisoft\ActiveRecord\ActiveRecordInterface\|null` which is incompatible with the type-hinted return `array`. Consider adding an additional type-check to rule them out. Loading history...
153			}
154
155			public function getOrdersQuery(): ActiveQuery
156			{
157			return $this->hasMany(Order::class, ['customer_id' => 'id'])->orderBy('[[id]]');
158			}
159
160			public function getOrdersNoOrder(): array
161			{
162			return $this->relation('ordersNoOrder');
			0 ignored issues – show Bug Best Practice introduced 2024-05-22 15:44 UTC by Report Bug Copy Issue Report The expression `return $this->relation('ordersNoOrder')` could return the type `Yiisoft\ActiveRecord\ActiveRecordInterface\|null` which is incompatible with the type-hinted return `array`. Consider adding an additional type-check to rule them out. Loading history...
163			}
164
165			public function getOrdersNoOrderQuery(): ActiveQuery
166			{
167			return $this->hasMany(Order::class, ['customer_id' => 'id']);
168			}
169
170			public function getExpensiveOrders(): array
171			{
172			return $this->relation('expensiveOrders');
			0 ignored issues – show Bug Best Practice introduced 2024-05-22 15:44 UTC by Report Bug Copy Issue Report The expression `return $this->relation('expensiveOrders')` could return the type `Yiisoft\ActiveRecord\ActiveRecordInterface\|null` which is incompatible with the type-hinted return `array`. Consider adding an additional type-check to rule them out. Loading history...
173			}
174
175			public function getExpensiveOrdersQuery(): ActiveQuery
176			{
177			return $this->hasMany(Order::class, ['customer_id' => 'id'])->andWhere('[[total]] > 50')->orderBy('id');
178			}
179
180			public function getItem(): void
181			{
182			}
183
184			public function getOrdersWithItems(): array
185			{
186			return $this->relation('ordersWithItems');
			0 ignored issues – show Bug Best Practice introduced 2024-05-22 15:44 UTC by Report Bug Copy Issue Report The expression `return $this->relation('ordersWithItems')` could return the type `Yiisoft\ActiveRecord\ActiveRecordInterface\|null` which is incompatible with the type-hinted return `array`. Consider adding an additional type-check to rule them out. Loading history...
187			}
188
189			public function getOrdersWithItemsQuery(): ActiveQuery
190			{
191			return $this->hasMany(Order::class, ['customer_id' => 'id'])->with('orderItems');
192			}
193
194			public function getExpensiveOrdersWithNullFK(): array
195			{
196			return $this->relation('expensiveOrdersWithNullFK');
			0 ignored issues – show Bug Best Practice introduced 2024-05-22 15:44 UTC by Report Bug Copy Issue Report The expression `return $this->relation('...nsiveOrdersWithNullFK')` could return the type `Yiisoft\ActiveRecord\ActiveRecordInterface\|null` which is incompatible with the type-hinted return `array`. Consider adding an additional type-check to rule them out. Loading history...
197			}
198
199			public function getExpensiveOrdersWithNullFKQuery(): ActiveQuery
200			{
201			return $this->hasMany(
202			OrderWithNullFK::class,
203			['customer_id' => 'id']
204			)->andWhere('[[total]] > 50')->orderBy('id');
205			}
206
207			public function getOrdersWithNullFK(): array
208			{
209			return $this->relation('ordersWithNullFK');
			0 ignored issues – show Bug Best Practice introduced 2024-05-22 15:44 UTC by Report Bug Copy Issue Report The expression `return $this->relation('ordersWithNullFK')` could return the type `Yiisoft\ActiveRecord\ActiveRecordInterface\|null` which is incompatible with the type-hinted return `array`. Consider adding an additional type-check to rule them out. Loading history...
210			}
211
212			public function getOrdersWithNullFKQuery(): ActiveQuery
213			{
214			return $this->hasMany(OrderWithNullFK::class, ['customer_id' => 'id'])->orderBy('id');
215			}
216
217			public function getOrders2(): array
218			{
219			return $this->relation('orders2');
			0 ignored issues – show Bug Best Practice introduced 2024-05-22 15:44 UTC by Report Bug Copy Issue Report The expression `return $this->relation('orders2')` could return the type `Yiisoft\ActiveRecord\ActiveRecordInterface\|null` which is incompatible with the type-hinted return `array`. Consider adding an additional type-check to rule them out. Loading history...
220			}
221
222			public function getOrders2Query(): ActiveQuery
223			{
224			return $this->hasMany(Order::class, ['customer_id' => 'id'])->inverseOf('customer2')->orderBy('id');
225			}
226
227			public function getOrderItems(): array
228			{
229			return $this->relation('orderItems');
			0 ignored issues – show Bug Best Practice introduced 2024-05-22 15:44 UTC by Report Bug Copy Issue Report The expression `return $this->relation('orderItems')` could return the type `Yiisoft\ActiveRecord\ActiveRecordInterface\|null` which is incompatible with the type-hinted return `array`. Consider adding an additional type-check to rule them out. Loading history...
230			}
231
232			/** deeply nested table relation */
233			public function getOrderItemsQuery(): ActiveQuery
234			{
235			$rel = $this->hasMany(Item::class, ['id' => 'item_id']);
236
237			return $rel->viaTable('order_item', ['order_id' => 'id'], function ($q) {
238			/* @var $q ActiveQuery */
239			$q->viaTable('order', ['customer_id' => 'id']);
240			})->orderBy('id');
241			}
242
243			public function getOrderItems2(): array
244			{
245			return $this->relation('orderItems2');
			0 ignored issues – show Bug Best Practice introduced 2024-05-22 15:44 UTC by Report Bug Copy Issue Report The expression `return $this->relation('orderItems2')` could return the type `Yiisoft\ActiveRecord\ActiveRecordInterface\|null` which is incompatible with the type-hinted return `array`. Consider adding an additional type-check to rule them out. Loading history...
246			}
247
248			public function getOrderItems2Query(): ActiveQuery
249			{
250			return $this->hasMany(OrderItem::class, ['order_id' => 'id'])
251			->via('ordersNoOrder');
252			}
253
254			public function getItems2(): array
255			{
256			return $this->relation('items2');
			0 ignored issues – show Bug Best Practice introduced 2024-05-22 15:44 UTC by Report Bug Copy Issue Report The expression `return $this->relation('items2')` could return the type `Yiisoft\ActiveRecord\ActiveRecordInterface\|null` which is incompatible with the type-hinted return `array`. Consider adding an additional type-check to rule them out. Loading history...
257			}
258
259			public function getItems2Query(): ActiveQuery
260			{
261			return $this->hasMany(Item::class, ['id' => 'item_id'])
262			->via('orderItems2');
263			}
264			}
265

yiisoft / active-record

Push — master ( bc8b6f...7a9b1f )

Customer::getItemQuery() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like