think\db\BaseQuery::pageSelect()

Complexity

Conditions	12
Paths	192

Size

Total Lines	59
Code Lines	40

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	156

Importance

Changes	9
Bugs	0	Features	0

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

        $config   = is_array($listRows) ? array_merge($defaultConfig, $listRows) : $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();

        $key     = $key ?: $this->getPk();
        $options = $this->getOptions();

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

        if (is_null($lastId)) {
            $newOption = $options;
            unset($newOption['field'], $newOption['page']);

            $data = $this->newQuery()
                ->options($newOption)
                ->field($key)
                ->where(true)
                ->order($key, $sort)
                ->limit(1)
                ->find();

            $result = $data[$key];

            if (!is_numeric($result)) {
                throw new Exception('not support type');
            }

            $lastId = 'asc' == $sort ? $result + ($page - 1) * $listRows : $result - ($page - 1) * $listRows;
        }

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

        $this->options($options);

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