isAjax()) {
$param = input('param.');
$limit = $param['pageSize'];
$offset = (($param['pageNumber'] - 1) * $limit);
$where['sensitivewords_for'] = $param['type'];
if (empty($param['searchText']) === false) {
$where['sensitivewords_word'] = ['like', '%' . $param['searchText'] . '%'];
}
$result = db('sensitivewords')
->field(['sensitivewords_id', 'sensitivewords_word', 'sensitivewords_time', 'sensitivewords_status', 'user_name'])
->alias('a')
->join('admins b', 'a.sensitivewords_uid = b.id')
->where($where)
->limit($offset, $limit)
->select();
foreach ($result as $key => $vo) {
// 优化显示状态.
if(1 === $vo['sensitivewords_status']) {
$result[$key]['sensitivewords_status'] = '启用';
} else {
$result[$key]['sensitivewords_status'] = '禁用';
}
// 生成操作按钮.
$result[$key]['operate'] = $this->makeBtn($vo['sensitivewords_id']);
}
// 总数据.
$return['total'] = db('sensitivewords')->where($where)->count(); //总数据
$return['rows'] = $result;
return json($return);
}
return $this->fetch();
}
//敏感词添加
public function addsensitive(){
if(request()->isPost()){
$param = input('post.');
$has = db('sensitivewords')->field('sensitivewords_id')->where('sensitivewords_word', $param['sensitivewords_word'])->find();
if(!empty($has)){
return json(['code' => -1, 'data' => '', 'msg' => '该敏感词已经存在']);
}
$param['sensitivewords_time'] = date('Y-m-d H:i:s');
$param['sensitivewords_uid'] = session('user_id');
try {
db('sensitivewords')->insert($param);
} 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 editsensitive(){
if(request()->isAjax()){
$param = input('post.');
// 检测用户修改的管理员是否重复
$has = db('sensitivewords')->where('sensitivewords_word', $param['sensitivewords_word'])->where('sensitivewords_id', '<>', $param['sensitivewords_id'])->find();
if(!empty($has)){
return json(['code' => -1, 'data' => '', 'msg' => '该敏感词已经存在']);
}
$param['sensitivewords_time'] = date('Y-m-d H:i:s');
$param['sensitivewords_uid'] = session('user_id');//uid
try{
db('sensitivewords')->where('sensitivewords_id', $param['sensitivewords_id'])->update($param);
}catch(\Exception $e){
return json(['code' => -2, 'data' => '', 'msg' => $e->getMessage()]);
}
return json(['code' => 1, 'data' => '', 'msg' => '编辑敏感词成功']);
}
$id = input('param.sensitivewords_id/d');
$info = db('sensitivewords')->where('sensitivewords_id', $id)->find();
$this->assign([
'info' => $info,
'status' => config('kf_status')
]);
return $this->fetch();
}
//删除
public function delWord(){
if(request()->isAjax()){
$id = input('param.id/d');
// return $id;
try{
db('sensitivewords')->where('sensitivewords_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 .= ' ';
$operate .= ' ';
return $operate;
}
}