devgroup\JsTreeWidget\actions\nestedset\FullTreeDataAction

Complexity

Total Complexity

18

Size/Duplication

Total Lines	117
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	5

Importance

Changes	1
Bugs	0	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
B	init()	0	25	6
A	run()	0	22	2
D	prepareNestedData()	0	42	10

<?php

namespace devgroup\JsTreeWidget\actions\nestedset;

use yii\base\Action;
use yii\base\InvalidConfigException;
use yii\db\ActiveRecord;
use Yii;
use yii\db\Query;
use yii\web\Response;

class FullTreeDataAction extends Action
{
    /** @var string */
    public $leftAttribute = 'lft';
    /** @var string */
    public $rightAttribute = 'rgt';
    /** @var string set name for multi root tree */
    public $rootAttribute = false;
    /** @var  ActiveRecord */
    public $className;
    /** @var string */
    public $modelLabelAttribute = 'name';

    private $tableName;

    public function init()
    {
        if (true === empty($this->className) || false === is_subclass_of($this->className, ActiveRecord::class)) {

Due to PHP Bug #53727, is_subclass_of might return inconsistent results on some PHP versions if \yii\db\ActiveRecord::class can be an interface. If so, you could instead use ReflectionClass::implementsInterface.

            throw new InvalidConfigException('"className" param must be set and must be child of ActiveRecord');
        }
        /** @var ActiveRecord $class */
        $class = $this->className;
        $this->tableName = $class::tableName();
        $scheme = Yii::$app->getDb()->getTableSchema($this->tableName);
        $columns = $scheme->columns;
        if (false !== $this->rootAttribute && false === isset($columns[$this->rootAttribute])) {
            throw new InvalidConfigException("Column '{$this->rootAttribute}' not found in the '{$this->tableName}' table");

This line exceeds maximum limit of 120 characters; contains 124 characters

        }
        if (false === isset(
                $columns[$this->leftAttribute],
                $columns[$this->rightAttribute],
                $columns[$this->modelLabelAttribute]
            )
        ) {
            throw new InvalidConfigException(
                "Some of the '{$this->leftAttribute}', '{$this->rightAttribute}', '{$this->modelLabelAttribute}', "
                . "not found in the '{$this->tableName}' columns list"
            );
        }
    }

    public function run()
    {
        $selectArray = [
            'id',
            $this->leftAttribute,
            $this->rightAttribute,
            $this->modelLabelAttribute,
        ];
        $orderBy = [];
        if (false !== $this->rootAttribute) {
            $selectArray[] = $this->rootAttribute;
            $orderBy[$this->rootAttribute] = SORT_ASC;
        }
        $orderBy[$this->leftAttribute] = SORT_ASC;
        Yii::$app->response->format = Response::FORMAT_JSON;
        $data = (new Query())
            ->from($this->tableName)
            ->select($selectArray)
            ->orderBy($orderBy)
            ->all();
        return $this->prepareNestedData($data);
    }

    /**
     * Converts single or multi root Nested Set database data into multidimensional array for using in the
     * jsTree widget
     *
     * @param array $data
     * @param int $lft
     * @param null $rgt
     * @param int $root
     * @return array
     */
    public function prepareNestedData($data, $lft = 0, $rgt = null, $root = 0)
    {
        $res = [];
        foreach ($data as $row) {
            $currentRoot = isset($row[$this->rootAttribute]) ? $row[$this->rootAttribute] : 0;
            if (is_null($rgt) || $row[$this->rightAttribute] < $rgt) {
                if ($lft + 1 == $row[$this->leftAttribute] && $root == $currentRoot) {
                    if ($row[$this->leftAttribute] + 1 !== $row[$this->rightAttribute]) {
                        $res[] = [
                            'id' => $row['id'],
                            'text' => $row[$this->modelLabelAttribute],
                            'children' => self::prepareNestedData(
                                $data,
                                $row[$this->leftAttribute],
                                $row[$this->rightAttribute],
                                $currentRoot
                            ),
                        ];
                    } else {
                        $res[] = [
                            'id' => $row['id'],
                            'text' => $row[$this->modelLabelAttribute],
                            'children' => []
                        ];
                    }
                    $lft = $row[$this->rightAttribute];
                } else if ($row[$this->leftAttribute] == 1 && $root !== $currentRoot) {
                    $res[] = [
                        'id' => $row['id'],
                        'text' => $row[$this->modelLabelAttribute],
                        'children' => self::prepareNestedData(
                            $data,
                            $row[$this->leftAttribute],
                            $row[$this->rightAttribute],
                            $currentRoot
                        ),
                    ];
                }
            }
        }
        return $res;
    }
}