<?php

namespace App\Models\Experience;

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

class Experience extends Model
{
    use SoftDeletes;
    protected $dates = ['deleted_at'];

    protected $fillable = [
        'id',
        'name',
        'icon',
        'short_description',
        'description',
        'apply_to',
        'includes',
        'when',
        'experience_type',
        'active'
    ];

    public function plans()
    {
        return $this->hasMany(ExperiencePlan::class)->select(['id', 'name', 'description', 'experience_id'])->where('type', 'experience')->whereHas('prices')->orderBy('name', 'ASC');
    }

    public function academy_plans()
    {
        return $this->hasMany(ExperiencePlan::class)->select(['id', 'name', 'description', 'type', 'experience_id'])->where('type', 'academy')->whereHas('prices')->orderBy('name', 'ASC');
    }
}