<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Concerns\HasUuids;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\HasMany;

/**
 * Etapas de proyecto. Catálogo editable desde Ajustes; a diferencia de
 * lead_stages y deal_stages, esta tabla sí tiene `id` uuid y `projects`
 * la referencia por `stage_id`.
 */
class ProjectStage extends Model
{
    use HasUuids;

    protected $table = 'project_stages';

    protected $guarded = ['id'];

    /** La tabla solo tiene created_at. */
    const UPDATED_AT = null;

    /**
     * @return array<string, string>
     */
    protected function casts(): array
    {
        return [
            'position' => 'integer',
            'is_active' => 'boolean',
            'created_at' => 'datetime',
        ];
    }

    public function projects(): HasMany
    {
        return $this->hasMany(Project::class, 'stage_id');
    }

    /**
     * @return array<string, string>
     */
    public static function options(): array
    {
        return static::query()
            ->where('is_active', true)
            ->orderBy('position')
            ->pluck('name', 'id')
            ->all();
    }
}