Customer-Service/application/admin/controller/System.php

<?php
/**
 * User: nickbai
 * Date: 2017/10/31 12:47
 * Email: 1902822973@qq.com
 */
namespace app\admin\controller;

class System extends Base
{
    // 自动回复设置
    public function reply()
    {
        if(request()->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();
    }
}