<?php

namespace App\Models;

use App\Models\Concerns\BelongsToCompany;
use Illuminate\Database\Eloquent\Relations\BelongsTo;
use Illuminate\Database\Eloquent\Relations\HasMany;

class EmployeePayroll extends Model
{
    use BelongsToCompany;

    protected $table = 'employee_payrolls';

    protected $fillable = [
        'company_id',
        'payroll_cycle_id',
        'user_id',
        'ctc_annual',
        'gross_monthly',
        'net_monthly',
        'total_deductions',
        'lop_days',
        'lop_amount',
        'working_days',
        'paid_days',
        'status',
        'payment_date',
    ];

    protected function casts(): array
    {
        return [
            'ctc_annual' => 'decimal:2',
            'gross_monthly' => 'decimal:2',
            'net_monthly' => 'decimal:2',
            'total_deductions' => 'decimal:2',
            'lop_days' => 'decimal:2',
            'lop_amount' => 'decimal:2',
            'payment_date' => 'date',
        ];
    }

    public function company(): BelongsTo
    {
        return $this->belongsTo(Company::class);
    }

    public function payrollCycle(): BelongsTo
    {
        return $this->belongsTo(PayrollCycle::class, 'payroll_cycle_id');
    }

    public function user(): BelongsTo
    {
        return $this->belongsTo(User::class);
    }

    public function components(): HasMany
    {
        return $this->hasMany(EmployeePayrollComponent::class, 'employee_payroll_id')->orderBy('display_order')->orderBy('id');
    }

    public function earnings(): HasMany
    {
        return $this->hasMany(EmployeePayrollComponent::class, 'employee_payroll_id')->where('category', 'earning')->orderBy('display_order')->orderBy('id');
    }

    public function deductions(): HasMany
    {
        return $this->hasMany(EmployeePayrollComponent::class, 'employee_payroll_id')->where('category', 'deduction')->orderBy('display_order')->orderBy('id');
    }

    public function employerContributions(): HasMany
    {
        return $this->hasMany(EmployeePayrollComponent::class, 'employee_payroll_id')->where('category', 'employer_contribution')->orderBy('display_order')->orderBy('id');
    }
}