Order::getBooksViaTableQuery() - Code Metrics - Inspection of "Rename `getRelation()` to `getRelationQuery()` (#3..." - yiisoft/active-record - Measure and Improve Code Quality continuously with Scrutinizer

Passed
Push — master ( 8c0a7b...a4816d )

by Sergei
created 2024-05-21 00:48 UTC
Order::getBooksViaTableQuery() A

↳ Parent: Order
Complexity

Conditions	1
Paths	1
Size

Total Lines	6
Code Lines	4
Duplication

Lines	0
Ratio	0 %
Importance

Changes
Metric	Value
eloc	4
c	0
b	0
f	0
dl	0
loc	6
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\ActiveRecord;

/**
 * Class Order.
 *
 * @property int $id
 * @property int $customer_id
 * @property int $created_at
 * @property string $total
 */
class Order extends ActiveRecord
{
    public const TABLE_NAME = 'order';

    private string|int|null $virtualCustomerId = null;

    public function getTableName(): string
    {
        return self::TABLE_NAME;
    }

    public function setVirtualCustomerId(string|int|null $virtualCustomerId = null): void
    {
        $this->virtualCustomerId = $virtualCustomerId;
    }

    public function getVirtualCustomerQuery()
    {
        return $this->hasOne(Customer::class, ['id' => 'virtualCustomerId']);
    }

    public function getCustomerQuery(): ActiveQuery
    {
        return $this->hasOne(Customer::class, ['id' => 'customer_id']);
    }

    public function getCustomerJoinedWithProfileQuery(): ActiveQuery
    {
        return $this->hasOne(Customer::class, ['id' => 'customer_id'])->joinWith('profile');
    }

    public function getCustomerJoinedWithProfileIndexOrderedQuery(): ActiveQuery
    {
        return $this->hasMany(
            Customer::class,
            ['id' => 'customer_id']
        )->joinWith('profile')->orderBy(['profile.description' => SORT_ASC])->indexBy('name');
    }

    public function getCustomer2Query(): ActiveQuery
    {
        return $this->hasOne(Customer::class, ['id' => 'customer_id'])->inverseOf('orders2');
    }

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

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

    public function getOrderItems3Query(): ActiveQuery
    {
        return $this->hasMany(
            OrderItem::class,
            ['order_id' => 'id']
        )->indexBy(fn ($row) => $row['order_id'] . '_' . $row['item_id']);
    }

    public function getOrderItemsWithNullFKQuery(): ActiveQuery
    {
        return $this->hasMany(OrderItemWithNullFK::class, ['order_id' => 'id']);
    }

    public function getItemsQuery(): ActiveQuery
    {
        return $this->hasMany(Item::class, ['id' => 'item_id'])->via('orderItems', static function ($q) {
        return $this->hasMany(Item::class, ['id' => 'item_id'])->via('orderItems', static function (/** @scrutinizer ignore-unused */ $q) {
            // additional query configuration
        })->orderBy('item.id');
    }

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

    public function getItemsWithNullFKQuery(): ActiveQuery
    {
        return $this->hasMany(
            Item::class,
            ['id' => 'item_id']
        )->viaTable('order_item_with_null_fk', ['order_id' => 'id']);
    }

    public function getItemsInOrder1Query(): ActiveQuery
    {
        return $this->hasMany(Item::class, ['id' => 'item_id'])->via('orderItems', static function ($q) {
            $q->orderBy(['subtotal' => SORT_ASC]);
        })->orderBy('name');
    }

    public function getItemsInOrder2Query(): ActiveQuery
    {
        return $this->hasMany(Item::class, ['id' => 'item_id'])->via('orderItems', static function ($q) {
            $q->orderBy(['subtotal' => SORT_DESC]);
        })->orderBy('name');
    }

    public function getBooksQuery(): ActiveQuery
    {
        return $this->hasMany(Item::class, ['id' => 'item_id'])->via('orderItems')->where(['category_id' => 1]);
    }

    public function getBooksWithNullFKQuery(): ActiveQuery
    {
        return $this->hasMany(
            Item::class,
            ['id' => 'item_id']
        )->via('orderItemsWithNullFK')->where(['category_id' => 1]);
    }

    public function getBooksViaTableQuery(): ActiveQuery
    {
        return $this->hasMany(
            Item::class,
            ['id' => 'item_id']
        )->viaTable('order_item', ['order_id' => 'id'])->where(['category_id' => 1]);
    }

    public function getBooksWithNullFKViaTableQuery(): ActiveQuery
    {
        return $this->hasMany(
            Item::class,
            ['id' => 'item_id']
        )->viaTable('order_item_with_null_fk', ['order_id' => 'id'])->where(['category_id' => 1]);
    }

    public function getBooks2Query(): ActiveQuery
    {
        return $this->hasMany(
            Item::class,
            ['id' => 'item_id']
        )->onCondition(['category_id' => 1])->viaTable('order_item', ['order_id' => 'id']);
    }

    public function getBooksExplicitQuery(): ActiveQuery
    {
        return $this->hasMany(
            Item::class,
            ['id' => 'item_id']
        )->onCondition(['category_id' => 1])->viaTable('order_item', ['order_id' => 'id']);
    }

    public function getBooksExplicitAQuery(): ActiveQuery
    {
        return $this->hasMany(
            Item::class,
            ['id' => 'item_id']
        )->alias('bo')->onCondition(['bo.category_id' => 1])->viaTable('order_item', ['order_id' => 'id']);
    }

    public function getBookItemsQuery(): ActiveQuery
    {
        return $this->hasMany(
            Item::class,
            ['id' => 'item_id']
        )->alias('books')->onCondition(['books.category_id' => 1])->viaTable('order_item', ['order_id' => 'id']);
    }

    public function getMovieItemsQuery(): ActiveQuery
    {
        return $this->hasMany(
            Item::class,
            ['id' => 'item_id']
        )->alias('movies')->onCondition(['movies.category_id' => 2])->viaTable('order_item', ['order_id' => 'id']);
    }

    public function getLimitedItemsQuery(): ActiveQuery
    {
        return $this->hasMany(Item::class, ['id' => 'item_id'])->onCondition(['item.id' => [3, 5]])->via('orderItems');
    }

    public function getExpensiveItemsUsingViaWithCallableQuery(): ActiveQuery
    {
        return $this->hasMany(Item::class, ['id' => 'item_id'])->via('orderItems', function (ActiveQuery $q) {
            $q->where(['>=', 'subtotal', 10]);
        });
    }

    public function getCheapItemsUsingViaWithCallableQuery(): ActiveQuery
    {
        return $this->hasMany(Item::class, ['id' => 'item_id'])->via('orderItems', function (ActiveQuery $q) {
            $q->where(['<', 'subtotal', 10]);
        });
    }

    public function getOrderItemsFor8Query(): ActiveQuery
    {
        return $this->hasMany(OrderItemWithNullFK::class, ['order_id' => 'id'])->andOnCondition(['subtotal' => 8.0]);
    }

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

yiisoft / active-record

Push — master ( 8c0a7b...a4816d )

Order::getBooksViaTableQuery() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like
