php 分页处理,分页处理

分页数据查询方式

以下代码仅供参考：

~~~

/**

* Note:获取项目信息列表

* Created by liuchuan.

* Time: 2019/2/26 9:58

* @return \think\response\Json

*/

public function listProject(){

$data = input('post.');

$where = [];

if(!empty($data['project_state'])){

$where = array_merge($where,array('project_state' => $data['project_state']));

}

return $this->listPageFunction(new ProjectModel(),$where);

}

~~~

**不推荐以下方法**

~~~

//这种方式会导致模糊查询或条件查询数据加载错误，不要使用，已经使用请先计算满足数据的条数再分页

public function listUser()

{

//分页数据

$limit = $this->getLimit();

//需要排序的字段

$sortType = $this->getSortType();

//搜索字段

$searchText = $this->getSearchText();

//TODO 在这里进行其他条件组装

$where = input('post.where');

if (empty($where)) {

$where = array();

}

$userModer = new UserModel();

$res = $userModer->getUserList($searchText, $where, $limit, $sortType);

$count = $userModer->getUserCount($searchText, $where);

$result = $this->responseSuccess($res, $count);

return json($result);

}

~~~

修正后的代码

~~~

public function listStaff()

{

$searchText = $this->getSearchText();

$where = input('post.where');

if (empty($where)) {

$where = array();

}

$staffModel = new StaffModel();

$count = $staffModel->getCount($searchText, $where);

$limit = $this->getLimit($count);

$sortType = $this->getSortType();

$leave = input('level');

if (empty($leave)) {

$leave = false;

}

$result = $staffModel->getList($searchText, $where, $limit, $sortType, $leave);

return $this->responseSuccess($result, $count);

}

~~~