course-site/app/Repositories/Models/Course/Video.php

<?php

namespace App\Repositories\Models\Course;

use App\Repositories\Models\Model;
use App\Repositories\Models\Base\Resource;
use Prettus\Repository\Contracts\Transformable;
use Prettus\Repository\Traits\TransformableTrait;

/**
 * Class CourseVideo.
 *
 * @package namespace App\Repositories\Models;
 */
class Video extends Model implements Transformable
{
    use TransformableTrait;

    protected $table = 'course_videos';

    protected $guarded = [];

    public function getDurationTextAttribute()
    {
        return sec2time($this->attributes['duration']);
    }

    public function comments()
    {
        return $this->hasMany(Comment::class, 'course_video_id');
    }

    public function attaches()
    {
        return $this->hasMany(Attach::class, 'course_video_id');
    }

    public function course_chapter()
    {
        return $this->belongsTo(Chapter::class);
    }

    public function course()
    {
        return $this->belongsTo(Course::class)->select(['id', 'title']);
    }

    public function getProgressAttribute()
    {
        return WatchRecord::query()->where('video_id', $this->attributes['id'])->where('user_id', login_user_id())->orderByDesc('progress_index')->value('progress') ?? 0;
    }

    public function url_resource()
    {
        return $this->belongsTo(Resource::class, 'url', 'id')->select(['path', 'id', 'url']);
    }

    public function subtitle_zh_path_resource()
    {
        return $this->belongsTo(Resource::class, 'subtitle_zh_path', 'id')->select(['path', 'id', 'url']);
    }

    public function subtitle_en_path_resource()
    {
        return $this->belongsTo(Resource::class, 'subtitle_en_path', 'id')->select(['path', 'id', 'url']);
    }
}