<?php
namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;

class Exercise extends Model
{
    use SoftDeletes;

    protected $table = 'se_exercises';

    protected $fillable = [
        'subject_id',
        'lesson_name',
        'description',
        'level',
        'avatar',
        'status',
        'category_id',
        'skill_id',
        'year',
        'media_object_id',
    ];

    protected $appends = ['level_label'];

    public function getLevelLabelAttribute()
    {
        return match ($this->level) {
            0 => 'easy',
            1 => 'normal',
            2 => 'hard',
            default => 'normal',
        };
    }

    public function subject()
    {
        return $this->belongsTo(Subject::class, 'subject_id');
    }

    public function category()
    {
        return $this->belongsTo(Category::class, 'category_id');
    }

    public function skills()
    {
        return $this->belongsToMany(Skill::class, 'se_exercise_skills', 'exercise_id', 'skill_id');
    }

    public function questionGroups()
    {
        return $this->hasMany(QuestionGroup::class, 'exercise_id');
    }

    public function questions()
    {
        return $this->hasMany(Question::class, 'exercise_id');
    }
}