Ui\DataManager::getRows()

Complexity

Conditions	70
Paths	12482

Size

Total Lines	165
Code Lines	122

Duplication

Lines	86
Ratio	52.12 %

Importance

Changes

0

<?php
    public function getRows($params = [], $model = null) {

getRows uses the super-global variable $_SERVER which is generally not recommended.

        $modelName = $this->modelName;
        if (!class_exists($modelName)) {
            return [];
        }
        if (!$this->checkAccess()) {

This code seems to be duplicated across your project.

            $this->drawError('you not have access to "' . $this->modelName . '" manager with name: "' . $this->managerName . '"');
            return [];
        }
        $modelName = $this->modelName;
        $queryParams = [];
        if (empty($params['all'])) {
            if (!empty($params['limit'])) {
                $this->limit = (int) $params['limit'];
            }
            if (!empty($params['page'])) {
                $this->page = (int) $params['page'];
            }
            $queryParams['limit'] = $this->limit;
            $queryParams['start'] = $this->page * $this->limit - $this->limit;
        }
        if (!empty($params['categoryPath']) && $modelName::$categoryModel) {

This code seems to be duplicated across your project.

            $queryParams['where'][] = ['tree_path', $params['categoryPath'] . '%', 'LIKE'];
        }
        if (!empty($params['appType'])) {
            $queryParams['appType'] = $params['appType'];
        }
        if ($this->joins) {
            $queryParams['joins'] = $this->joins;
        }
        if (!empty($this->managerOptions['userGroupFilter'][\Users\User::$cur->group_id]['getRows'])) {

This code seems to be duplicated across your project.

            foreach ($this->managerOptions['userGroupFilter'][\Users\User::$cur->group_id]['getRows'] as $colName => $colOptions) {
                if (!empty($colOptions['userCol'])) {
                    $queryParams['where'][] = [$colName, \Model::getColValue(\Users\User::$cur, $colOptions['userCol'])];
                } elseif (isset($colOptions['value'])) {
                    if (is_array($colOptions['value'])) {
                        foreach ($colOptions['value'] as $key => $value) {
                            if ($key === 'userCol') {
                                $colOptions['value'][$key] = \Model::getColValue(\Users\User::$cur, $value);
                            }
                        }
                    }
                    $queryParams['where'][] = [$colName, $colOptions['value'], is_array($colOptions['value']) ? 'IN' : '='];
                }
            }
        }
        if (!empty($this->managerOptions['filters'])) {
            foreach ($this->managerOptions['filters'] as $col) {
                $colInfo = $modelName::getColInfo($col);
                switch ($colInfo['colParams']['type']) {
                    case 'select':

This code seems to be duplicated across your project.

                        if (empty($params['filters'][$col]['value'])) {
                            continue;
                        }
                        if (is_array($params['filters'][$col]['value'])) {
                            foreach ($params['filters'][$col]['value'] as $key => $value) {
                                if ($value === '') {
                                    unset($params['filters'][$col]['value'][$key]);
                                }
                            }
                        }
                        if (!$params['filters'][$col]['value']) {
                            continue;
                        }
                        $queryParams['where'][] = [$col, $params['filters'][$col]['value'], is_array($params['filters'][$col]['value']) ? 'IN' : '='];
                        break;
                    case 'bool':

The case body in a switch statement must start on the line following the statement.

                        if (!isset($params['filters'][$col]['value']) || $params['filters'][$col]['value'] === '') {
                            continue;
                        }
                        $queryParams['where'][] = [$col, $params['filters'][$col]['value']];
                        break;
                    case 'dateTime':
                    case 'date':

This code seems to be duplicated across your project.

                        if (empty($params['filters'][$col]['min']) && empty($params['filters'][$col]['max'])) {
                            continue;
                        }
                        if (!empty($params['filters'][$col]['min'])) {
                            $queryParams['where'][] = [$col, $params['filters'][$col]['min'], '>='];
                        }
                        if (!empty($params['filters'][$col]['max'])) {
                            if ($colInfo['colParams']['type'] == 'dateTime' && !strpos($params['filters'][$col]['max'], ' ')) {

                                $date = $params['filters'][$col]['max'] . ' 23:59:59';
                            } else {
                                $date = $params['filters'][$col]['max'];
                            }
                            $queryParams['where'][] = [$col, $date, '<='];
                        }
                        break;
                    case 'number':

This code seems to be duplicated across your project.

                        if (empty($params['filters'][$col]['min']) && empty($params['filters'][$col]['max'])) {
                            continue;
                        }
                        if (!empty($params['filters'][$col]['min'])) {
                            $queryParams['where'][] = [$col, $params['filters'][$col]['min'], '>='];
                        }
                        if (!empty($params['filters'][$col]['max'])) {
                            $queryParams['where'][] = [$col, $params['filters'][$col]['max'], '<='];
                        }
                        break;
                    case 'email':
                    case 'text':
                    case 'textarea':
                    case 'html':

This code seems to be duplicated across your project.

                        if (empty($params['filters'][$col]['value'])) {
                            continue;
                        }
                        switch ($params['filters'][$col]['compareType']) {
                            case 'contains':
                                $queryParams['where'][] = [$col, '%' . $params['filters'][$col]['value'] . '%', 'LIKE'];
                                break;
                            case 'equals':
                                $queryParams['where'][] = [$col, $params['filters'][$col]['value']];
                                break;
                            case 'starts_with':
                                $queryParams['where'][] = [$col, $params['filters'][$col]['value'] . '%', 'LIKE'];
                                break;
                            case 'ends_with':
                                $queryParams['where'][] = [$col, '%' . $params['filters'][$col]['value'], 'LIKE'];
                                break;
                        }
                        break;
                }
            }
        }
        if (!empty($params['mode']) && $params['mode'] == 'sort') {
            $queryParams['order'] = ['weight', 'asc'];
        } elseif (!empty($params['sortered']) && !empty($this->managerOptions['sortable'])) {
            foreach ($params['sortered'] as $colName => $sortType) {
                if ($colName && in_array($colName, $this->managerOptions['sortable'])) {
                    $sortType = in_array($sortType, ['desc', 'asc']) ? $sortType : 'desc';
                    $queryParams['order'][] = [$colName, $sortType];
                }
            }
        }
        if ($model && !empty($params['relation'])) {
            $relation = $model::getRelation($params['relation']);
            $items = $model->$params['relation']($queryParams);
        } else {
            $relation = false;
            $items = $modelName::getList($queryParams);
        }
        $rows = [];
        foreach ($items as $item) {
            if ($relation && !empty($relation['relModel'])) {
                $item = $relation['relModel']::get([[$item->index(), $item->id], [$model->index(), $model->id]]);
            }
            $row = [];
            $row[] = '<input type ="checkbox" name = "pk[]" value =' . $item->pk() . '>';
            $redirectUrl = !empty($_SERVER['HTTP_REFERER']) ? $_SERVER['HTTP_REFERER'] : '/admin/' . str_replace('\\', '%5C', get_class($originalItem));

The variable $originalItem does not exist. Did you forget to declare it?

            $row[] = "<a href ='/admin/" . $item->genViewLink() . "?redirectUrl={$redirectUrl}'>{$item->pk()}</a>";
            foreach ($this->managerOptions['cols'] as $key => $colName) {
                if (!empty($params['download'])) {
                    $row[] = \Model::getColValue($item, is_array($colName) ? $key : $colName, true, false);
                } else {
                    $row[] = DataManager::drawCol($item, is_array($colName) ? $key : $colName, $params, $this);
                }
            }
            $row[] = $this->rowButtons($item, $params);
            $rows[] = $row;
        }
        return $rows;
    }

}