<?php

namespace App\Models;

use App\Models\WorkAreaExpertise;
use App\Models\CompanyExpertise;

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

class Expertise extends Model
{
    use HasFactory;
    use SoftDeletes;

    protected $table = 'expertises';

    protected $fillable = 
    [
        'name',
    ];

    public function areas_of_work()
    {
        return $this->hasMany(WorkAreaExpertise::class, 'expertise_id', 'id')
            ->join('work_areas', 'work_areas.id', '=', 'work_areas_expertise.work_area_id');
    }

    public function company() 
    {
        return $this->hasMany(CompanyExpertise::class, 'expertise_id', 'id')
            ->join('companies', 'companies.id', '=', 'company_expertises.company_id');
    }   
}