model = new \app\admin\model\Gonghui; } public function import() { parent::import(); } /** * 查看 */ public function index() { //设置过滤方法 $this->request->filter(['strip_tags', 'trim']); if ($this->request->isAjax()) { //如果发送的来源是Selectpage,则转发到Selectpage if ($this->request->request('keyField')) { return $this->selectpage(); } list($where, $sort, $order, $offset, $limit) = $this->buildparams(); //公会分权限 $gh_map = []; $gh_ids = db('admin')->where('id',$this->auth->id)->value('gh_ids'); if(empty($gh_ids)){ $gh_map = ['id' => '-1']; }else{ $gh_map = ['id' => ['IN',$gh_ids]]; } if($gh_ids == '*'){ $gh_map = []; } $list = $this->model ->where($where) ->where($gh_map) ->order($sort, $order) //->select(false);dump($list);exit; ->paginate($limit); $rows = collection($list->items())->toArray(); foreach($rows as $key => $info){ $info['usernum'] = Db::name('user')->where('gh_id',$info['id'])->count('id'); $rows[$key] = $info; } $result = array("total" => $list->total(), "rows" => $rows); return json($result); } return $this->view->fetch(); } }