// +---------------------------------------------------------------------- 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']); } }