<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\BelongsTo;

class SubscriptionRequest extends Model
{
    protected $table = 'subscription_requests';

    protected $fillable = [
        'company_id',
        'subscription_plan_id',
        'employee_count',
        'billing_cycle',
        'selected_addons',
        'amount',
        'addons_total',
        'calculated_total',
        'currency',
        'proof_path',
        'status',
        'requested_at',
        'approved_at',
        'approved_by',
        'notes',
    ];

    protected $casts = [
        'amount' => 'decimal:2',
        'addons_total' => 'decimal:2',
        'calculated_total' => 'decimal:2',
        'employee_count' => 'integer',
        'selected_addons' => 'array',
        'requested_at' => 'datetime',
        'approved_at' => 'datetime',
    ];

    public function company(): BelongsTo
    {
        return $this->belongsTo(Company::class);
    }

    public function subscriptionPlan(): BelongsTo
    {
        return $this->belongsTo(SubscriptionPlan::class, 'subscription_plan_id');
    }

    public function approvedByUser(): BelongsTo
    {
        return $this->belongsTo(User::class, 'approved_by');
    }

    public function isPending(): bool
    {
        return $this->status === 'pending';
    }
}