Customer-Service/application/index/controller/Message.php

<?php

namespace app\index\controller;

use think\Controller;

class Message extends Controller
{
    public function index()
    {
        // 留言知识库(默认查询前七天的留言)
        $end = time();
        $start = time() - 604800;
        if (request()->isPost()) {
            $time = input("param.time/s");
            $key = input("param.key/s");
            $type = input("param.type/s");
            $limit = intval(input("param.pageSize/s", 10));
            $pageNumber = intval(input("param.pageNumber/s", 1));
            $offset = ($pageNumber - 1) * $limit;
            if ($time == 'week') {
                //前一周
                $start = time() - 604800;
            }
            if ($time == 'oneMonth') {
                //前一个月
                $start = time() - 2592000;
            }
            if ($time == 'threeMonth') {
                //前三个月
                $start = time() - 7776000;
            }
            if (!empty($start_time)) {
                $start = strtotime($start_time);
            }
            if (!empty($end_time)) {
                $end = strtotime($end_time . ' 23:59:59');
            }

            $where = array();
            if (!empty($type)) {
                $type_id = db('messagetype')->where('name', $type)->find();
                if (!empty($type)) {
                    $where['type_id'] = $type_id['id'];
                }
            }
        }
        if (!empty($key)) {
            $message = db('accountsmessage')->whereBetween('add_time', [$start, $end])->where($where)->whereLike('content', '%' . $key . '%')->where('if_public', 1)->limit($offset, $limit)->order('add_time', 'desc')->select();
            $total = db('accountsmessage')->whereBetween('add_time', [$start, $end])->where($where)->whereLike('content', '%' . $key . '%')->where('if_public', 1)->limit($offset, $limit)->order('add_time', 'desc')->count();
        } else {
            $message = db('accountsmessage')->whereBetween('add_time', [$start, $end])->where($where)->where('if_public', 1)->limit($offset, $limit)->order('add_time', 'desc')->select();
            $total = db('accountsmessage')->whereBetween('add_time', [$start, $end])->where($where)->where('if_public', 1)->limit($offset, $limit)->order('add_time', 'desc')->count();
        }

        $type = db('messagetype')->select();
        $users = db('users')->select();
        foreach ($message as $key => $vo) {
            //转为日期时间格式
            $message[$key]['add_time'] = date('Y-m-d H:i:s', $vo['add_time']);
            $message[$key]['dealWith_time'] = date('Y-m-d H:i:s', $vo['dealWith_time']);
            //类型名称
            for ($i = 0; $i < count($type); $i++) {
                if ($vo['type_id'] == $type[$i]['id']) {
                    $message[$key]['type_name'] = $type[$i]['name'];
                }
            }
            foreach ($users as $k => $v) {
                if ($vo['user_id'] == $v['id']) {
                    $message[$key]['user_name'] = $users[$k]['user_name'];
                }
            }
        }
        //总页数
        $pages = ceil($total / $limit);
        $list = array();
        $list['total'] = $total;
        $list['pages'] = $pages;
        $list['pageSize'] = $limit;
        $list['pageNumber'] = $pageNumber;
        $list['list'] = $message;

        $data = [
            'status' => 1,
            'msg' => '成功',
            'data' => $list
        ];

        return json_encode($data, JSON_UNESCAPED_UNICODE);
    }

    // 留言类型
    public function type()
    {
        $type = db('messagetype')->where('status', 1)->select();
        for ($i = 0; $i < count($type); $i++) {
            $type[$i]['addtime'] = date('Y-m-d H:i:s', $type[$i]['addtime']);
        }

        $data = [
            'status' => 1,
            'msg' => '成功',
            'data' => $type
        ];

        return json_encode($data, JSON_UNESCAPED_UNICODE);
    }

}