$authentication = input('get.authentication');
$islock = input('get.islock');
$realname = input('get.realname');
$mobile = input('get.mobile');
$stime = input('get.stime');
$otime = input('get.otime');
$pageParam = ['query' =>[]];
$userModel = Db::name('users');
if($stime && $otime){
$userModel->where('dotime', 'between', array($stime,$otime));
$pageParam['query']['stime'] = $stime;
$pageParam['query']['otime'] = $otime;
}
if(strlen($authentication) > 0){
$userModel->where('authentication', $authentication);
$pageParam['query']['authentication'] = $authentication;
}
if(strlen($islock) > 0){
$userModel->where('islock', $islock);
$pageParam['query']['islock'] = $islock;
}
if($realname){
$userModel->where('realname', 'like', '%'.$realname.'%');
$pageParam['query']['realname'] = $realname;
}
if($mobile){
$userModel->where('mobile', 'like', '%'.$mobile.'%');
$pageParam['query']['mobile'] = $mobile;
}
//查询个人
$personalList = $userModel -> where('islock=0 and type=1')->order('id DESC')->paginate(10, false, $pageParam);
$page = $personalList->render();