hiqdev\billing\hiapi\target\TargetQuery

Complexity

Total Complexity

2

Size/Duplication

Total Lines	30
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	2

Test Coverage

Coverage

0%

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	attributesMap()	0	14	1
A	initFrom()	0	7	1

<?php

namespace hiqdev\billing\hiapi\target;

use hiqdev\billing\hiapi\models\Target;
use yii\db\Expression;

class TargetQuery extends \hiqdev\yii\DataMapper\query\Query
{
    protected $modelClass = Target::class;

    /**
     * @return array
     */
    protected function attributesMap()
    {
        return [
            'id' => 'o.obj_id',
            'type' => new Expression("
                t.name || 
                CASE WHEN tt.name IS NOT NULL THEN
                    '.' || tt.name
                ELSE
                    ''
                END as type
            "),
        ];
    }

    public function initFrom()
    {
        return $this->from('obj   o')
                ->leftJoin('zref   t',  't.obj_id  = o.class_id')
                ->leftJoin('device d',  'd.obj_id  = o.obj_id')
                ->leftJoin('zref   tt', 'tt.obj_id = coalesce(d.type_id)');
    }
}