isAjax()){ //分页参数 $length = input('rows',10,'intval'); //每页条数 $page = input('page',1,'intval'); //第几页 $start = ($page - 1) * $length; //分页开始位置 //排序 $sortRow = input('sidx','id','trim'); //排序列 $sort = input('sord','desc','trim'); //排序方式 $order = $sortRow.' '.$sort; $status = input('status','','trim'); if($status != ''){ $map[] = ['status','=',$status]; } $map[] = ['org_id','=',$this->orgId]; $map[] = ['patrol_mode','=',$mode]; $map= empty($map) ? true: $map; //数据查询 $lists = Db::name('patrol_task_delay')->where($map) ->limit($start,$length)->order($order)->select(); foreach ($lists as $k=>$v){ $taskTitle = Db::name('patrol_task')->where('id',$v['task_id'])->value('title'); $lists[$k]['task_title'] = $taskTitle?$taskTitle:''; $lists[$k]['end_time'] = date('Y-m-d H:i',strtotime($v['end_time'])); $lists[$k]['uname'] = Db::name('user')->where('id',$v['user_id'])->value('real_name'); $lists[$k]['deal_user'] = ''; if($v['deal_user_id'] > 0){ $lists[$k]['deal_user'] = Db::name('user')->where('id',$v['deal_user_id'])->value('real_name'); } } //数据返回 $totalCount = Db::name('patrol_task_delay')->where($map)->count(); $totalPage = ceil($totalCount/$length); $result['page'] = $page; $result['total'] = $totalPage; $result['records'] = $totalCount; $result['rows'] = $lists; return json($result); }else{ $this->assign('mode',$mode); return $this->fetch(); } } /** * 处理 */ public function deal($id = 0){ if(request()->isPost()){ $res = model('PatrolTaskDelay')->dealDelay($this->userId,$this->orgId); if($res){ $this->success('操作成功',url('deal')); }else{ $this->error(model('PatrolTaskDelay')->getError()); } }else{ $info = Db::name('patrol_task_delay')->where('id',$id)->find(); $this->assign('info',$info); $this->assign('id',$id); return $this->fetch(); } } }