isAjax()){ $param = input('param.'); $limit = $param['pageSize']; $offset = ($param['pageNumber'] - 1) * $limit; $where = []; if (!empty($param['searchText'])) { $where['atext'] = ['like', '%' . $param['searchText'] . '%']; } $model = new ServicenoticeModel(); $result = $model->where($where)->limit($offset, $limit)->order('id','desc')->select(); foreach($result as $key=>$vo){ $vo->readtime = empty($vo->readtime) ? '' : date('Y-m-d H:i:s', $vo->readtime); $vo->uid = $vo->kfuser->user_name; $result[$key] = array_merge($vo->toArray(),['operate'=>$this->makeBtn($vo->id)]) ; } $return['total'] = db('servicenotice')->where($where)->count(); //总数据 $return['rows'] = $result; return json($return); } return $this->fetch(); } // 添加管理员 public function add() { if(request()->isPost()){ $atext = input('post.atext'); if (empty($atext)){ return json(['code' => -1, 'data' => '', 'msg' => '内容不能为空']); } $Users = (new Usersmodel())->where(['status'=>1])->select(); if (!$Users){ return json(['code' => -2, 'data' => '', 'msg' => '没有可用客服']); } $datas = [] ; foreach ($Users as $val){ $arr = [ 'uid'=>$val->id, 'atext'=>$atext ]; $datas[] = $arr; } try{ db('servicenotice')->insertAll($datas); }catch(\Exception $e){ return json(['code' => -2, 'data' => '', 'msg' => $e->getMessage()]); } return json(['code' => 1, 'data' => '', 'msg' => '添加公告成功']); } $this->assign([ 'status' => config('kf_status') ]); return $this->fetch(); } // 删除管理员 public function del() { if(request()->isAjax()){ $id = input('param.id/d'); //return $id; try{ db('servicenotice')->where('id', $id)->delete(); }catch(\Exception $e){ return json(['code' => -1, 'data' => '', 'msg' => $e->getMessage()]); } return json(['code' => 1, 'data' => '', 'msg' => '删除成功']); } } // 生成按钮 private function makeBtn($id) { $operate = ''; $operate .= ' 删除 '; return $operate; } }