分頁數據查詢方式
以下代碼僅供參考：
~~~
/**
* 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);
}
~~~
