<?php

namespace App\Models;

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

/**
 * Etapas del tablero de conectores. Catálogo editable desde Ajustes:
 * `leads.connector_stage` guarda la `key` de una de estas filas.
 *
 * OJO: la tabla no tiene columna `id`; la clave primaria es `key` (text).
 */
class ConnectorStage extends Model
{
    protected $table = 'connector_stages';

    protected $primaryKey = 'key';

    protected $keyType = 'string';

    public $incrementing = false;

    protected $guarded = [];

    /** 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 leads(): HasMany
    {
        return $this->hasMany(Lead::class, 'connector_stage', 'key');
    }

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