hiqdev\billing\hiapi\bill\BillQuery

Complexity

Total Complexity

2

Size/Duplication

Total Lines	53
Duplicated Lines	0 %

Test Coverage

Coverage

0%

Importance

Changes	2
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	initFrom()	0	11	1
A	attributesMap()	0	32	1

<?php
/**
 * API for Billing
 *
 * @link      https://github.com/hiqdev/billing-hiapi
 * @package   billing-hiapi
 * @license   BSD-3-Clause
 * @copyright Copyright (c) 2017-2018, HiQDev (http://hiqdev.com/)
 */

namespace hiqdev\billing\hiapi\bill;

use hiqdev\billing\hiapi\models\Bill;

class BillQuery extends \hiqdev\yii\DataMapper\query\Query
{
    /**
     * @var string
     */
    protected $modelClass = Bill::class;

    protected function attributesMap()
    {
        return [
            'id' => 'zb.obj_id',
            'type' => [
                'id' => 'zb.type_id',
                'name' => 'bt.g2name',
            ],
            'plan' => [
                'id' => 'zb.tariff_id',
            ],
            'target' => [
                'id' => 'zb.object_id',
                'type' => 'tt.name',
            ],
            'customer' => [
                'id' => 'zc.obj_id',
                'login' => 'zc.login',
                'seller' => [
                    'id' => 'cr.obj_id',
                    'login' => 'cr.login',
                ],
            ],
            'sum' => [
                'currency' => 'py.name',
                'amount' => 'zb.sum',
            ],
            'quantity' => [
                'unit' => 'qu.name',
                'quantity' => 'zb.quantity',
            ],
            'time' => 'zb.time',
        ];
    }

    public function initFrom()
    {
        return $this->from('zbill   zb')
            ->leftJoin('gref        bt', 'bt.obj_id = zb.type_id')
            ->leftJoin('obj         tj', 'tj.obj_id = zb.object_id')
            ->leftJoin('zref        tt', 'tt.obj_id = tj.class_id')
            ->leftJoin('purse       bp', 'bp.obj_id = zb.purse_id')
            ->leftJoin('zclient     zc', 'zc.obj_id = bp.client_id')
            ->leftJoin('zclient     cr', 'cr.obj_id = zc.seller_id')
            ->leftJoin('zref        py', 'py.obj_id = bp.currency_id')
            ->leftJoin('zref        qu', 'qu.obj_id = zb.unit_id');
    }
}