isAjax()) {
$param = input('param.');
$limit = $param['pageSize'];
$offset = (($param['pageNumber'] - 1) * $limit);
$where = [];
if (strlen($param['searchText'])) {
// $where['robot_name'] = $param['searchText'];
$where['robot_name'] = ['like', '%' . $param['searchText'] . '%'];
}
$field = ['robot_id', 'robot_name', 'robot_content', 'robot_host', 'robot_status', 'user_name', 'robot_updateTime'];
$join = [
'admins b' => 'a.admin_id = b.id',
];
$result = model('Robot')->selectJoin($field, $join, $where, $offset, $limit);
foreach ($result as $key => $vo) {
// 优化显示状态.
if(1 == $vo['robot_status']) {
$result[$key]['robot_status'] = '启用';
} else {
$result[$key]['robot_status'] = '禁用';
}
// 优化显示热点问题.
if (1 == $vo['robot_host']) {
$result[$key]['robot_host'] = '是';
} else {
$result[$key]['robot_host'] = '否';
}
// 生成操作按钮.
$result[$key]['operate'] = $this->makeBtn($vo['robot_id']);
}
// var_dump($where);die;
// 总数据.
$return['total'] = model('Robot')->count($where);
$return['rows'] = $result;
return json($return);
}
return $this->fetch();
}//end index()
// 添加智能问答
public function addWord()
{
if(request()->isPost()){
$param = input('post.');
$param['robot_content'] = trim($param['robot_content']);
$robotWhere = [
'robot_name' => $param['robot_name'],
];
$has = db('robot')->field('robot_id')->where($robotWhere)->find();
if(!empty($has)){
return json(['code' => -1, 'data' => '', 'msg' => '该智能问答已经存在']);
}
$param['robot_addTime'] = date('Y-m-d H:i:s');
$param['robot_updateTime'] = date('Y-m-d H:i:s');
$param['groups_id'] = 1;
$param['robotgroups_id'] = 1;
$param['admin_id'] = session('user_id');
try{
db('robot')->insert($param);
}catch(\Exception $e){
return json(['code' => -2, 'data' => '', 'msg' => $e->getMessage()]);
}
return json(['code' => 1, 'data' => '', 'msg' => '添加智能问答成功']);
}
$groups = db('groups')->where('status', 1)->select();
$robotgroups = db('robotgroups')->where('robotgroups_status', 1)->select();
$this->assign([
'status' => config('kf_status'),
'host' => config('host'),
'groups' => $groups,
'robotgroups' => $robotgroups,
]);
return $this->fetch('addword');
}
// 编辑智能问答
public function editWord()
{
if(request()->isAjax()){
$param = input('post.');
$param['robot_content'] = trim($param['robot_content']);
$param['robot_updateTime'] = date('Y-m-d H:i:s');
$robotWhere = [
'robot_name' => $param['robot_name'],
];
// 检测用户修改的智能问答是否重复
$has = db('robot')->where($robotWhere)->count();
if($has>1){
return json(['code' => -1, 'data' => '', 'msg' => '该智能问答已经存在']);
}
$param['groups_id'] = 1;
$param['robotgroups_id'] = 1;
$param['admin_id'] = session('user_id');
try{
db('robot')->where('robot_id', $param['robot_id'])->update($param);
}catch(\Exception $e){
return json(['code' => -2, 'data' => '', 'msg' => $e->getMessage()]);
}
return json(['code' => 1, 'data' => '', 'msg' => '编辑智能问答成功']);
}
$id = input('param.robot_id/d');
$info = db('robot')->where('robot_id', $id)->find();
$groups = db('groups')->where('status', 1)->select();
$robotgroups = db('robotgroups')->where('robotgroups_status', 1)->select();
$this->assign([
'info' => $info,
'host' => config('host'),
'groups' => $groups,
'robotgroups' => $robotgroups,
'status' => config('kf_status')
]);
return $this->fetch('editword');
}
// 删除智能问答
public function delWord()
{
if(request()->isAjax()){
$id = input('param.id/d');
try{
db('robot')->where('robot_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;
}
//导入智能问答
function inserExcel()
{
Loader::import('PHPExcel.PHPExcel');
Loader::import('PHPExcel.PHPExcel.PHPExcel_IOFactory');
Loader::import('PHPExcel.PHPExcel.PHPExcel_Cell');
//获取表单上传文件
$file = request()->file('excel');
$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]['robot_name'] = $v[0];
$info[$k]['robot_content'] = $v[1];
$info[$k]['robot_status'] = $v[2];
$info[$k]['robot_host'] = $v[3];
$info[$k]['groups_id'] = 1;
$info[$k]['robotgroups_id'] = 1;
$info[$k]['robot_addTime'] = date('Y-m-d H:m:s',time());
$info[$k]['robot_updateTime'] = date('Y-m-d H:m:s',time());
$info[$k]['admin_id'] = session('user_id');
}
$robot = db('robot')->select();
for($i=0;$i -1, 'data' => url('robot/index'), 'msg' => 'excel表第'.($i+1).'行智能问答问题已存在']);
}
}
}
db('robot')->insertAll($info); //批量插入数据
return json(['code' => 1, 'data' => $this->redirect('robot/index'), 'msg' => '插入智能问答数据成功']);
} else {
return json(['code' => -2, 'data' => url('robot/index'), 'msg' => '插入智能问答数据失败']);
}
}
}