NN2024010801/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 video()
    {
        return $this->hasOne(VideoModel::class, 'id','video_id')
            ->where(['mark'=>1])
            ->select(['id','thumb','type','title','file_url','user_id']);
    }

    /**
     * 商品
     * @return \Illuminate\Database\Eloquent\Relations\HasOne
     */
    public function goods()
    {
        return $this->hasOne(GoodsModel::class, 'id','goods_id')
            ->where(['mark'=>1])
            ->select(['id','main_img','goods_name','goods_id','merch_id','cost_price','retail_price']);
    }

    /**
     * 直播
     * @return \Illuminate\Database\Eloquent\Relations\HasOne
     */
    public function live()
    {
        return $this->hasOne(LiveModel::class, 'id','live_id')
            ->where(['mark'=>1])
            ->select(['id','user_id','play_url','type','title','description','status']);
    }
}