NN2025081602/app/Models/MessageModel.php

<?php
// +----------------------------------------------------------------------
// | LARAVEL8.0 框架 [ LARAVEL ][ RXThinkCMF ]
// +----------------------------------------------------------------------
// | 版权所有 2017~2021 LARAVEL研发中心
// +----------------------------------------------------------------------
// | 官方网站: http://www.laravel.cn
// +----------------------------------------------------------------------
// | Author: laravel开发员 <laravel.qq.com>
// +----------------------------------------------------------------------

namespace App\Models;

/**
 * 消息管理-模型
 * @author laravel开发员
 * @since 2020/11/11
 * @package App\Models
 */
class MessageModel extends BaseModel
{
    // 设置数据表
    protected $table = 'message';

    /**
     * 发送用户
     * @return \Illuminate\Database\Eloquent\Relations\HasOne
     */
    public function fromUser()
    {
        return $this->hasOne(MemberModel::class, 'id','from_uid')
            ->select(['id','avatar','nickname','status']);
    }

    /**
     * 接收用户
     * @return \Illuminate\Database\Eloquent\Relations\HasOne
     */
    public function toUser()
    {
        return $this->hasOne(MemberModel::class, 'id','to_uid')
            ->select(['id','avatar','nickname','status']);
    }

    /**
     * 最新消息
     * @return \Illuminate\Database\Eloquent\Relations\HasOne
     */
    public function last()
    {
        return $this->hasOne(MessageModel::class, 'chat_key','chat_key')
            ->where(['type'=>1,'mark'=>1])
            ->select(['id','title','type','msg_type','content','from_uid','chat_key','to_uid','create_time','is_read','status'])
            ->orderBy('create_time','desc');
    }
}