isPost()){ $param = input('post.'); if(empty($param['word'])){ return json(['code' => -1, 'data' => '', 'msg' => '回复内容不能为空']); } try{ db('reply')->where('id', 1)->update($param); }catch(\Exception $e){ return json(['code' => -2, 'data' => '', 'msg' => $e->getMessage()]); } return json(['code' => 1, 'data' => '', 'msg' => '设置成功']); } $info = db('reply')->where('id', 1)->find(); $this->assign([ 'info' => $info, 'status' => config('kf_status') ]); return $this->fetch(); } // 客服设置 public function customerService() { if(request()->isPost()){ $param = input('post.'); db('kf_config')->where('id', 1)->update($param); return json(['code' => 1, 'data' => '', 'msg' => '设置成功']); } $this->assign([ 'config' => db('kf_config')->where('id', 1)->find(), 'status' => config('kf_status') ]); return $this->fetch(); } // 历史会话记录 public function wordsLog() { if(request()->isAjax()){ $param = input('param.'); $limit = $param['pageSize']; $offset = ($param['pageNumber'] - 1) * $limit; // 默认显示最近7天 $start = input('param.start'); $end = input('param.end'); $temp = db('service_log'); $countTmp = db('service_log'); if(!empty($param['searchText'])){ $user = db('users')->where('user_name', $param['searchText'])->find(); $temp = $temp->where('kf_id', $user['id']); $countTmp = $countTmp->where('kf_id', $user['id']); } if(!empty($start) && !empty($end) && $start <= $end){ $temp = $temp->whereBetween('start_time', [strtotime($start), strtotime($end . ' 23:59:59')]); $countTmp = $countTmp->whereBetween('start_time', [strtotime($start), strtotime($end . ' 23:59:59')]); } $result = $temp->limit($offset, $limit)->order('start_time', 'desc')->select(); foreach($result as $key=>$vo){ if($result[$key]['start_time'] != 0){ $result[$key]['start_time'] = date('Y-m-d H:i:s', $vo['start_time']); }else{ $result[$key]['start_time'] = '-'; } if($result[$key]['end_time'] != 0){ $result[$key]['end_time'] = date('Y-m-d H:i:s', $vo['start_time']); }else{ $result[$key]['end_time'] = '-'; } //客服名称 $kefu = db('users')->where('id', $result[$key]['kf_id'])->find(); $result[$key]['kefu_name'] = $kefu['user_name']; //满意度 $evaluate = db('evaluate')->where('evaluate_id', $result[$key]['evaluate_id'])->find(); $result[$key]['evaluate_name'] = $evaluate['evaluate_name']; } $return['total'] = $countTmp->count(); //总数据 $return['rows'] = $result; return json($return); } $users = db('users')->select(); $this->assign([ 'users' => $users ]); return $this->fetch(); } }