model = new \app\admin\model\Res; $this->view->assign("statusList", $this->model->getStatusList()); } /** * 默认生成的控制器所继承的父类中有index/add/edit/del/multi五个基础方法、destroy/restore/recyclebin三个回收站方法 * 因此在当前控制器中可不用编写增删改查的代码,除非需要自己控制这部分逻辑 * 需要将application/admin/library/traits/Backend.php中对应的方法复制到当前控制器,然后进行修改 */ /** * 查看 * * @return string|Json * @throws \think\Exception * @throws DbException */ public function index() { //设置过滤方法 $this->request->filter(['strip_tags', 'trim']); if (false === $this->request->isAjax()) { return $this->view->fetch(); } //如果发送的来源是 Selectpage,则转发到 Selectpage if ($this->request->request('keyField')) { return $this->selectpage(); } [$where, $sort, $order, $offset, $limit] = $this->buildparams(); $user_id = Session::get('admin')['id']; if ($user_id == 1){//超级管理员 $list = $this->model ->where($where) ->order($sort, $order) ->paginate($limit); }else{ $userinfo = Db::name('admin')->where('id',$user_id)->find(); $pidList = Db::name('company')->where('pid',$userinfo['company'])->select(); $map = []; if (!empty($pidList)){//总公司 $pid = []; foreach ($pidList as $key=>$value){ $pid[$key] = $value['id']; } $map['work_unit'] = array('in',$pid); }else{//分公司 $map['work_unit'] = $userinfo['company']; } $list = $this->model ->where($where) ->where($map) ->order($sort, $order) ->paginate($limit); } $result = ['total' => $list->total(), 'rows' => $list->items()]; return json($result); } //检测数据查看 public function data(){ $params = input('id'); if (empty($params)){ $this->error('参数错误'); } $entrust_id = Db::name('res')->where('id',$params)->value('entrust_id'); $gather_id = Db::name('entrust')->where('id',$entrust_id)->find(); if (empty($gather_id['gather_id'])){ $this->error('此委托单还未提交检测,暂无检测数据'); } //此处根据实际获取到的采集表的数据 gather_tab 去对应表里查数据 重新写一个gc表格页面 js加代码 if ($gather_id['gather_tab'] == 'gather_txt_check_gcms'){ $gather = Db::name('gather_txt_gcms')->where('id',$gather_id['gather_id'])->find(); $data = Db::name('gather_txt_check_gcms')->where('pid',$gather_id['gather_id'])->select(); $this->view->assign('gather', $gather); $this->view->assign('data', $data); $this->view->assign('id', $params); return $this->view->fetch(); }else if ($gather_id['gather_tab'] == 'gather_txt_check_gc'){ $gather = Db::name('gather_txt_gc')->where('id',$gather_id['gather_id'])->find(); $data = Db::name('gather_txt_check_gc')->where('pid',$gather_id['gather_id'])->select(); $this->view->assign('gather', $gather); $this->view->assign('data', $data); $this->view->assign('id', $params); return $this->fetch('datagc'); } } //数据报告 public function report(){ $this->error('此功能暂未开发'); } }