<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Relations\BelongsTo;

class EmployeeComponentValue extends Model
{
    protected $table = 'employee_component_values';

    protected $fillable = [
        'user_id',
        'component_definition_id',
        'value_type',
        'value',
        'effective_from',
        'effective_to',
    ];

    protected function casts(): array
    {
        return [
            'value' => 'decimal:4',
            'effective_from' => 'date',
            'effective_to' => 'date',
        ];
    }

    public function user(): BelongsTo
    {
        return $this->belongsTo(User::class);
    }

    public function componentDefinition(): BelongsTo
    {
        return $this->belongsTo(PayrollComponentDefinition::class, 'component_definition_id');
    }

    public function scopeEffectiveAt($query, $date)
    {
        return $query->where(function ($q) use ($date) {
            $q->whereNull('effective_from')->orWhere('effective_from', '<=', $date);
        })->where(function ($q) use ($date) {
            $q->whereNull('effective_to')->orWhere('effective_to', '>=', $date);
        });
    }
}