如何实现排序分页呢,只看到有分页

[wyt232]

如题，请教

[phper666]

@wyt232 我给个截图你参考下

[phper666]

@wyt232 图片要翻墙才能看，我直接给你看下代码

public function getList(array $params)
    {
        $filter = [];
        if (!empty($params['enterprise_id'])) $filter['enterprise_id'] = $params['enterprise_id'];
        if (!empty($params['name'])) $filter['name'] = ['$regex' => "{$params['name']}"];
        $options = [
            'sort' => ['parentid' => 1, 'order' => -1],
            'projection' => [
                'name' => 1,
                'name_en' => 1,
                'parentid' => 1,
                'order' => 1,
                'description' => 1,
                'updated_at' => 1,
                'enterprise_id' => 1,
                'department_id' => 1,
            ]
        ];
        $data = $this->enterpriseDepartmentModel->findPagination($params['page_no'], $params['page_size'], $filter, $options);
        foreach ($data['rows'] as &$v) {
            $v['staff_count'] = $this->getStaffCountByDepartment($params['enterprise_id'], $v['department_id']);
            $v['updated_at'] = date('Y-m-d H:i:s', $v['updated_at']);
        }
        return $data;
    }

[phper666]

sort就是可以直接排序

[wyt232]

sort就是可以直接排序

谢了大佬