BillQuery::initSelect() - Code Metrics - Inspection of "Added work with Bills" - hiqdev/billing-hiapi - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( 65052d...e6fef9 )

by Dmitry

created 2017-06-12 11:41 UTC

BillQuery::initSelect() A

↳ Parent: BillQuery

Complexity

Conditions	1
Paths	1

Size

Total Lines	13
Code Lines	10

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	2

Importance

Changes

Metric	Value
dl	0
loc	13
ccs	0
cts	5
cp	0
rs	9.4285
c	0
b	0
f	0
cc	1
eloc	10
nc	1
nop	0
crap	2

<?php

namespace hiqdev\billing\hiapi\query;

use hiqdev\billing\hiapi\models\Bill;

class BillQuery extends \hiapi\query\Query
{
    protected $modelClass = Bill::class;

    public function initSelect()
    {
        return $this->selectByFields($this->getFields())
            ->from('zbill           zb')
            ->leftJoin('zref        bt', 'bt.obj_id = zb.type_id')
            ->leftJoin('purse       zp', 'zp.obj_id = zb.purse_id')
            ->leftJoin('zclient     zc', 'zc.obj_id = zp.client_id')
            ->leftJoin('zclient     cr', 'cr.obj_id = zc.seller_id')
            ->leftJoin('zref        cu', 'cu.obj_id = zp.currency_id')
            ->leftJoin('obj         zo', 'zo.obj_id = zb.object_id')
            ->leftJoin('zref        oc', 'oc.obj_id = zo.class_id')
        ;
    }

    /**
     * @return mixed
     */
    protected function attributesMap()
    {
        return [
            'id' => 'zb.obj_id',
            'time' => 'zb.time',
            'quantity' => [
                'quantity' => 'zb.quantity',
            ],
            'sum' => [
                'currency' => 'cu.name',
                'amount' => 'zb.sum',
            ],
            'type' => [
                'name' => 'bt.name',
            ],
            'customer' => [
                'id' => 'zc.obj_id',
                'login' => 'zc.login',
                'seller' => [
                    'id' => 'cr.obj_id',
                    'login' => 'cr.login',
                ],
            ],
            'target' => [
                'id' => 'zb.object_id',
                'type' => 'oc.name',
            ],
        ];
    }
}


1			<?php
2
3			namespace hiqdev\billing\hiapi\query;
4
5			use hiqdev\billing\hiapi\models\Bill;
6
7			class BillQuery extends \hiapi\query\Query
8			{
9			protected $modelClass = Bill::class;
10
11			public function initSelect()
12			{
13			return $this->selectByFields($this->getFields())
14			->from('zbill zb')
15			->leftJoin('zref bt', 'bt.obj_id = zb.type_id')
16			->leftJoin('purse zp', 'zp.obj_id = zb.purse_id')
17			->leftJoin('zclient zc', 'zc.obj_id = zp.client_id')
18			->leftJoin('zclient cr', 'cr.obj_id = zc.seller_id')
19			->leftJoin('zref cu', 'cu.obj_id = zp.currency_id')
20			->leftJoin('obj zo', 'zo.obj_id = zb.object_id')
21			->leftJoin('zref oc', 'oc.obj_id = zo.class_id')
22			;
23			}
24
25			/**
26			* @return mixed
27			*/
28			protected function attributesMap()
29			{
30			return [
31			'id' => 'zb.obj_id',
32			'time' => 'zb.time',
33			'quantity' => [
34			'quantity' => 'zb.quantity',
35			],
36			'sum' => [
37			'currency' => 'cu.name',
38			'amount' => 'zb.sum',
39			],
40			'type' => [
41			'name' => 'bt.name',
42			],
43			'customer' => [
44			'id' => 'zc.obj_id',
45			'login' => 'zc.login',
46			'seller' => [
47			'id' => 'cr.obj_id',
48			'login' => 'cr.login',
49			],
50			],
51			'target' => [
52			'id' => 'zb.object_id',
53			'type' => 'oc.name',
54			],
55			];
56			}
57			}
58

hiqdev / billing-hiapi

Push — master ( 65052d...e6fef9 )

BillQuery::initSelect() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like