model = new \app\admin\model\patient\PatientInfoModel; } public function index() { //设置过滤方法 $this->request->filter(['strip_tags']); if ($this->request->isAjax()) { //如果发送的来源是Selectpage,则转发到Selectpage if ($this->request->request('keyField')) { return $this->selectpage(); } list($where, $sort, $order, $offset, $limit) = $this->buildparams($this->searchFields, true); $join = [ ['institution i','p.institution_id = i.id','LEFT'] ]; $field = ['p.*','i.name as institution_name']; // 过滤机构 $childInsIds = $this->auth->getMyInsId(); if($childInsIds == false){ $more = false; } else { $more = ['p.institution_id' => ['in', $childInsIds]]; } $total = $this->model->alias('p') ->join($join) ->where($more) ->where($where) ->order($sort, $order) ->count(); $list = $this->model->alias('p') ->join($join) ->where($more) ->where($where) ->order($sort, $order) ->limit($offset, $limit) ->field($field) ->select(); $list = collection($list)->toArray(); $result = array("total" => $total, "rows" => $list); return json($result); } return $this->view->fetch(); } }