<?php

namespace App\Models\Quote;

use App\Models\User;
use App\Traits\Auditable;
use App\Traits\BelongsToTenant;
use App\Traits\ModelTrait;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\BelongsTo;
use Illuminate\Database\Eloquent\Relations\HasMany;
use Illuminate\Database\Eloquent\SoftDeletes;

/**
 * 견적 수식 카테고리 모델
 *
 * @property int $id
 * @property int $tenant_id
 * @property string $code
 * @property string $name
 * @property string|null $description
 * @property int $sort_order
 * @property bool $is_active
 * @property int|null $created_by
 * @property int|null $updated_by
 */
class QuoteFormulaCategory extends Model
{
    use Auditable, BelongsToTenant, ModelTrait, SoftDeletes;

    protected $table = 'quote_formula_categories';

    protected $fillable = [
        'tenant_id',
        'code',
        'name',
        'description',
        'sort_order',
        'is_active',
        'created_by',
        'updated_by',
    ];

    protected $casts = [
        'is_active' => 'boolean',
        'sort_order' => 'integer',
    ];

    protected $attributes = [
        'sort_order' => 0,
        'is_active' => true,
    ];

    // =========================================================================
    // Relationships
    // =========================================================================

    /**
     * 카테고리에 속한 수식들
     */
    public function formulas(): HasMany
    {
        return $this->hasMany(QuoteFormula::class, 'category_id')
            ->orderBy('sort_order');
    }

    /**
     * 활성화된 수식만
     */
    public function activeFormulas(): HasMany
    {
        return $this->formulas()->where('is_active', true);
    }

    /**
     * 생성자
     */
    public function creator(): BelongsTo
    {
        return $this->belongsTo(User::class, 'created_by');
    }

    /**
     * 수정자
     */
    public function updater(): BelongsTo
    {
        return $this->belongsTo(User::class, 'updated_by');
    }

    // =========================================================================
    // Scopes
    // =========================================================================

    /**
     * Scope: 활성화된 카테고리
     */
    public function scopeActive(Builder $query): Builder
    {
        return $query->where('is_active', true);
    }

    /**
     * Scope: 정렬 순서
     */
    public function scopeOrdered(Builder $query): Builder
    {
        return $query->orderBy('sort_order');
    }
}