Customer-Service/application/admin/model/Message.php

<?php
namespace app\admin\model;
use\think\Model;
use think\Session;
use think\cache\driver\Redis;
use think\Loader;
use think\Cache;
use think\DB;

class Message extends Model
{


    /**
     * 消息列表
     */
    public function messageList()
    {
        $code         = -2;
        $limit        = (input('pageSize') ?? 10);
        $currentPage  = (input('currentPage') ?? 1);
        $platformName = input('platformName');
        $getData      = [
            'pageSize'    => $limit,
            'currentPage' => $currentPage,
        ];

        // 验证传参.
        $validate = Loader::validate('Common');
        if (!$validate->scene('messageList')->check($getData)) {
            return [
                'code' => $code,
                'msg'  => $validate->getError(),
                'data' => [
                    'messageList'  => [],
                    'messageCount' => 0,
                    'currentPage'  => 1,
                    'page'         => [],
                ],
            ];
        }

        $offset = (($currentPage - 1) * $limit);
        $where  = [];
        if (strlen($platformName)) {
            $where['platform_name'] = [
                'like',
                "%$platformName%"
            ];
        }

        $messageList = $this
            ->field('message_title, message_time, message_ip, platform_name, message_id')
            ->alias('a')
            ->join('platform b', 'a.platform_identity = b.platform_identity');

        if ($where) {
            $messageList = $messageList->where($where);
        }

        $messageList = $messageList->order('message_time', 'desc')
            ->limit($offset, $limit)
            ->select();
        // 查询总数.
        $messageCount = $this
            ->alias('a')
            ->join('platform b', 'a.platform_identity = b.platform_identity');

        if ($where) {
            $messageCount = $messageCount->where($where);
        }

        $messageCount = $messageCount->count();
        // 分页.
        $page = getPage($messageCount, $limit, $currentPage);

        return [
            'code' => 1,
            'msg'  => lang('MC01005'),
            'data' => [
                'messageList'  => $messageList,
                'messageCount' => $messageCount,
                'currentPage'  => $currentPage,
                'page'         => $page,
            ],
        ];

    }//end messageList()


    /**
     * 消息详情
     */
    public function messageInfo()
    {

        $code      = -2;
        $messageId = input('id');
        $getData   = ['message_id' => $messageId];

        // 验证传参.
        $validate = Loader::validate('Common');
        if (!$validate->scene('messageInfo')->check($getData)) {
            return [
                'code' => $code,
                'msg'  => $validate->getError(),
                'data' => ['messageInfo' => []],
            ];
        }

        $messageInfo = $this
            ->field('message_title, message_time, message_content, platform_name')
            ->alias('a')
            ->join('platform b', 'a.platform_identity = b.platform_identity')
            ->where($getData)
            ->find();

        if (empty($messageInfo) === false) {
            return [
                'code' => 1,
                'msg'  => lang('MC01005'),
                'data' => ['messageInfo' => $messageInfo],
            ];
        } else {
            return [
                'code' => $code,
                'msg'  => lang('EC01002'),
                'data' => ['messageInfo' => []],
            ];
        }

    }//end messageInfo()

    /**
     * 删除所选消息
     */
    public function delMessage($ids)
    {
        $this->wherein('message_id',$ids)->delete();

        return [
            'code' => 1,
            'msg'  => lang('MC01003'),
            'data' => [],
        ];

    }//end delMessage()


}