model = new \app\admin\model\KeFuBlacklist; } /** * 查看 */ public function index() { //当前是否为关联查询 $this->relationSearch = true; //设置过滤方法 $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(); $total = $this->model->with(['admin', 'kefuuser'])->where($where)->order($sort, $order)->count(); $list = $this->model->with(['admin', 'kefuuser']) ->where($where) ->order($sort, $order) ->limit($offset, $limit) ->select(); foreach ($list as $row) { $row->getRelation('admin')->visible(['nickname']); if ($row->kefuuser->user_id) { $row->fu_user_nickname = \think\Db::name('user') ->where('id', $row->kefuuser->user_id) ->value('nickname'); } } $list = collection($list)->toArray(); $result = ["total" => $total, "rows" => $list]; return json($result); } return $this->view->fetch(); } }