44 lines
1.2 KiB
PHP
44 lines
1.2 KiB
PHP
<?php
|
|
|
|
namespace App\Models\Course;
|
|
|
|
use App\Models\Live\Viewer;
|
|
use App\Models\Server\MerchantUser;
|
|
use App\Models\Server\TouristOrder;
|
|
use App\Models\User;
|
|
|
|
use Illuminate\Database\Eloquent\Model;
|
|
use Illuminate\Database\Eloquent\SoftDeletes;
|
|
|
|
class UserCourses extends Model
|
|
{
|
|
|
|
protected $fillable = ['user_id','course_id','trade_no','status','from_user_id','open_id'];
|
|
//用户信息
|
|
public function user()
|
|
{
|
|
return $this->belongsTo(User::class)->select('id','nickname','app_avatar','photo','circle_avatar');
|
|
|
|
}
|
|
|
|
//用户信息
|
|
public function course()
|
|
{
|
|
return $this->belongsTo(Course::class)->select('id','title','thumb','charge','team_id','teacher_name','user_count','published_at')->withTrashed();
|
|
|
|
}
|
|
//报名信息
|
|
public function member(){
|
|
return $this->hasOne(Viewer::class,'openid','open_id')->select('openid','avatar','mobile','sex','nickname');
|
|
}
|
|
|
|
//报名信息
|
|
public function s_member(){
|
|
return $this->hasOne(MerchantUser::class,'openid','open_id')->select('openid','pic','mobile','sex','nickname');
|
|
}
|
|
|
|
public function torder(){
|
|
return $this->belongsTo(TouristOrder::class,'trade_no','trade_no');
|
|
}
|
|
}
|