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  = input("param.pageSize/s");
            $pageNumber = input("param.pageNumber/s");
            $offset = (input("param.pageNumber/s") - 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);
    }

}