think\db\BaseQuery::pageSelect()

Complexity

Conditions	11
Paths	288

Size

Total Lines	48
Code Lines	30

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	132

Importance

Changes	3
Bugs	0	Features	0

<?php
    public function pageSelect($listRows = null, $key = null, $sort = null, $lastId = null)
    {
        $defaultConfig = [
            'query'     => [], //url额外参数
            'fragment'  => '', //url锚点
            'var_page'  => 'page', //分页变量
            'list_rows' => 15, //每页数量
        ];

        if (is_array($listRows)) {
            $config = array_merge($defaultConfig, $listRows);
        } else {
            $config = $defaultConfig;
        }

        $listRows = is_int($listRows) ? $listRows : (int) $config['list_rows'];

        $page = isset($config['page']) ? (int) $config['page'] : Paginator::getCurrentPage($config['var_page']);

        $page = $page < 1 ? 1 : $page;

        $config['path'] = $config['path'] ?? Paginator::getCurrentPath();

        if (is_null($key)) {
            $key = $this->getPk();
        }

        if (is_null($sort)) {
            $order = $this->getOptions('order');
            if (!empty($order)) {
                $sort = $order[$key] ?? 'desc';
            } else {
                $this->order($key, 'desc');
                $sort = 'desc';
            }
        }

        if (is_null($lastId)) {
            $data   = $this->newQuery()->field($key)->where('1=1')->limit(1)->order($key, $sort)->find();
            $result = $data[$key];
            $lastId = 'asc' == $sort ? $result + ($page - 1) * $listRows : $result - ($page - 1) * $listRows;
        }

        $results = $this->limit($listRows)
            ->where($key, 'asc' == $sort ? '>=' : '<=', $lastId)
            ->select();

        return Paginator::make($results, $listRows, $page, null, true, $config);
    }