<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;
use App\Models\WorkAreaLists;
use App\Models\WorkerRatingAggregate;

class Search extends Model
{
    use HasFactory, SoftDeletes;
	protected $table = 'search';
    protected $fillable = [
        'worker_company_id',
        'worker_id','hourly_rate','original_rate',
        'zip_code','date_from','status',
        'date_to'
    ];

    public function work_area_lists()
    {
        return $this->hasMany(WorkAreaLists::class ,'worker_id', 'worker_id')
            ->join('work_areas', 'work_areas.id', '=', 'work_area_lists.work_area_id')
            ->where('work_area_lists.worker_type', 'worker');
    }

    public function rating(){
        return $this->hasOne(WorkerRatingAggregate::class ,'worker_id', 'worker_id');
    }
}