hiqdev\billing\hiapi\query\BillQuery::initSelect()

Complexity

Conditions	1
Paths	1

Size

Total Lines	23
Code Lines	19

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	2

Importance

Changes

0

<?php
    public function initSelect()
    {
        return $this->select([
                'zb.obj_id as id',
                'zb.time',
                'zb.quantity    AS "quantity.quantity"',
                'zb.sum         AS "sum.amount"',
                'cu.name        AS "sum.currency"',
                'bt.name        AS "type.name"',
                'zc.obj_id      AS "customer.id"',
                'zc.login       AS "customer.login"',
                'zb.object_id   AS "target.id"',
                'oc.name        AS "target.type"',
            ])
            ->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('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')
        ;
    }
}