isAjax()) {
$param = input('param.');
$limit = $param['pageSize'];
$offset = (($param['pageNumber'] - 1) * $limit);
$where['sensitivewords_for'] = $param['type'];
if (strlen($param['searchText'])) {
$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','left')
->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.');
$findWhere = [
'sensitivewords_word' => $param['sensitivewords_word'],
'sensitivewords_for' => $param['sensitivewords_for'],
];
$has = db('sensitivewords')->field('sensitivewords_id')->where($findWhere)->find();
if (empty($has) === false) {
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'])->find();
$thisWord = db('sensitivewords')->where('sensitivewords_id', $param['sensitivewords_id'])->find();
if(!empty($has) && $has['sensitivewords_id'] != $param['sensitivewords_id'] && $thisWord['sensitivewords_for'] == $has['sensitivewords_for']){
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' => '删除敏感词成功']);
}
}
//删除所有关键字
public function delAll(){
if(request()->isAjax()){
$type = input('param.type/d');
if($type == 1){
$name = '用户';
}
if($type == 2){
$name = '客服';
}
try{
db('sensitivewords')->where('sensitivewords_for', $type)->delete();
}catch(\Exception $e){
return json(['code' => -1, 'data' => '', 'msg' => $e->getMessage()]);
}
return json(['code' => 1, 'data' => '', 'msg' => '删除全部'.$name.'敏感词成功']);
}
}
// 生成按钮
private function makeBtn($id)
{
$operate = '';
// $operate .= ' ';
$operate .= ' ';
$operate .= ' ';
$operate .= ' 删除 ';
return $operate;
}
//导入敏感词
function inserExcel()
{
Loader::import('PHPExcel.PHPExcel');
Loader::import('PHPExcel.PHPExcel.PHPExcel_IOFactory');
Loader::import('PHPExcel.PHPExcel.PHPExcel_Cell');
//获取表单上传文件
$file = request()->file('excel');
//$file = $_FILES['excel'];
// return $file;
// print_r($file) ;
// if(request()->isAjax()){
// $file = input('param.file');
// //return $file;
// }
if(empty($file)){
//return '';
$this->error('请先上传文件');
return json(['code' => -4, 'data' => '', 'msg' => '请先上传文件']);
}
$info = $file->validate(['ext' => 'xlsx'])->move(ROOT_PATH . 'public' . DS . 'uploads');
//上传验证后缀名,以及上传之后移动的地址
if ($info) {
// echo $info->getFilename();
$exclePath = $info->getSaveName(); //获取文件名
$file_name = ROOT_PATH . 'public' . DS . 'uploads' . DS . $exclePath; //上传文件的地址
$objReader = \PHPExcel_IOFactory::createReader('Excel2007');
$obj_PHPExcel = $objReader->load($file_name, $encode = 'utf-8'); //加载文件内容,编码utf-8
$excel_array = $obj_PHPExcel->getsheet(0)->toArray(); //转换为数组格式
array_shift($excel_array); //删除第一个数组(标题);
$info = [];
foreach ($excel_array as $k => $v) {
$info[$k]['sensitivewords_word'] = $v[0];
$info[$k]['sensitivewords_status'] = $v[1];
$info[$k]['sensitivewords_for'] = $v[2];
$info[$k]['sensitivewords_time'] = date('Y-m-d H:i:s',time());
$info[$k]['sensitivewords_uid'] = session('user_id');
}
//检查表中数据是否为空和重复
for($a=0;$aerror('excel表第'.($a+2).'行敏感词为空');
return json(['code' => -3, 'data' => url('sensitivec/index'), 'msg' => 'excel表第'.($a+2).'行敏感词为空']);
}
for($b=$a+1;$berror('excel表第'.($a+2).'行与第'.($b+2).'行敏感词重复');
return json(['code' => -1, 'data' => url('sensitivec/index'), 'msg' => 'excel表第'.($a+2).'行与第'.($b+2).'行敏感词重复']);
}
}
}
//检查表格中数据是否已存在与数据库
$sensitivewords = db('sensitivewords')->select();
for($i=0;$ierror('excel表第'.($i+2).'行敏感词已存在');
return json(['code' => -1, 'data' => url('sensitivec/index'), 'msg' => 'excel表第'.($i+2).'行敏感词已存在']);
}
}
}
db('sensitivewords')->insertAll($info); //批量插入数据
$this->success('插入敏感词成功');
return json(['code' => 1, 'data' => $this->redirect('sensitivec/index'), 'msg' => '插入敏感词成功']);
} else {
$this->error('插入敏感词失败');
return json(['code' => -2, 'data' => url('sensitivec/index'), 'msg' => '插入敏感词失败']);
}
}
}