<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class UserCourse extends Model
{
    protected $fillable = ['id', 'user_id', 'course_id', 'status'];

    public function course()
    {
        return $this->hasOne('App\Course', 'id', 'course_id');
    }

    public function completed_lessons()
    {
        return $this->hasMany('App\UsersProgress', 'user_id', 'user_id')->whereRaw('`lesson_id` IN (SELECT `id` FROM `lessons` WHERE `lessons`.`course_id` = `user_courses`.`course_id`)');
    }

    public function last_completed_lesson()
    {
        return $this->hasOne('App\UsersProgress', 'user_id', 'user_id')->whereRaw('`lesson_id` IN (SELECT `id` FROM `lessons` WHERE `lessons`.`course_id` = 1)')->orderBy('lesson_id', 'desc');
    }

    public function lessons()
    {
        return $this->hasMany('App\Lesson', 'course_id', 'course_id');
    }
}