isAjax()){ //分页参数 $length = input('rows',10,'intval'); //每页条数 $page = input('page',1,'intval'); //第几页 $start = ($page - 1) * $length; //分页开始位置 //排序 $sortRow = input('sidx','id','trim'); //排序列 $sort = input('sort','desc','trim'); //排序方式 $order = $sortRow.' '.$sort; $map[] = ['del','=',0]; $map[] = ['org_id','=',$this->orgId]; $map= empty($map) ? true: $map; //数据查询 $lists = db('screen')->where($map)->limit($start,$length)->order('id desc')->select(); foreach ($lists as $k=>$v){ $lists[$k]['temp_title'] = \db('screen_template')->where('id',$v['tid'])->value('title'); $lists[$k]['surl'] = config('app.screen_url').'/home?token='.think_encrypt($v['id'].'|'.$this->orgId); } //数据返回 $totalCount = db('screen')->where($map)->count(); $totalPage = ceil($totalCount/$length); $result['page'] = $page; $result['total'] = $totalPage; $result['records'] = $totalCount; $result['rows'] = $lists; return json($result); }else{ $map1[] = ['del','=',0]; $map1[] = ['org_id','=',$this->orgId]; $map2[] = ['del','=',0]; $map2[] = ['org_id','=',0]; //数据查询 $lists = db('screen')->whereOr([$map1,$map2])->order('id desc')->select(); $nlist = []; foreach ($lists as $k=>$v){ if($v['type'] == 2){ $lists[$k]['surl'] = $v['url']; }else if($v['type'] == 1){ if($v['org_id'] == 0){ $lists[$k]['surl'] = config('app.screen_url').'/home?token='.think_encrypt($v['id'].'|'.$this->orgId); }else{ $lists[$k]['surl'] = config('app.screen_url').'/home?token='.think_encrypt($v['id'].'|'.$v['org_id']); } }else if($v['type'] == 3){ // 3D大屏 $lists[$k]['surl'] = $v['url'].'?token='.think_encrypt($v['id'].'|'.$v['org_id']); } if(!$v['auth'] || ($v['auth'] && model('Roles')->checkUserAuths($this->userId,$v['auth']))){ $nlist[] = $lists[$k]; } } $this->assign('lists',$nlist); return $this->fetch(); } } /** * 新增/编辑 */ public function add($id=0){ if(request()->isPost()){ $res = model('Screen')->updates(); if($res){ $this->success('操作成功',url('index')); }else{ $this->error(model('Screen')->getError()); } }else{ $meta_title = '新增大屏'; $nums = 0; if($id){ $info = db('screen')->where('id',$id)->find(); if($info){ $nums = \db('screen_template')->where('id',$info['tid'])->value('nums'); $info['content2'] = $info['content']?json_decode($info['content'],true):[]; } $meta_title = '编辑大屏'; $this->assign('info',$info); } $this->assign('nums',$nums); $tempList = db('screen_template')->where('del',0)->select(); $this->assign('tempList',$tempList); $moduleList = db('screen_module')->where('del',0)->select(); $this->assign('moduleList',$moduleList); $this->assign('meta_title',$meta_title); return $this->fetch(); } } /** * 删除记录 * @param int $id */ public function del($id=0){ if(!$id){ $this->error('参数错误'); } $res = db('screen')->where('id',$id)->setField('del',1); if($res){ $this->success('删除成功'); }else{ $this->error('删除失败'); } } }