<?php

namespace App\Models;

use App\Models\Concerns\SyncsProjectTemplateOwnership;
use Database\Factories\TicketStatusFactory;
use Illuminate\Database\Eloquent\Attributes\Fillable;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\BelongsTo;
use Illuminate\Database\Eloquent\Relations\BelongsToMany;
use Illuminate\Database\Eloquent\Relations\HasMany;
use Illuminate\Support\Str;

#[Fillable(['board_column_id', 'name', 'position', 'project_id', 'project_template_id', 'slug'])]
class TicketStatus extends Model
{
    /** @use HasFactory<TicketStatusFactory> */
    use HasFactory;

    use SyncsProjectTemplateOwnership;

    protected static function booted(): void
    {
        static::saving(function (self $ticketStatus): void {
            if ($ticketStatus->project_template_id === null && $ticketStatus->board_column_id !== null) {
                $ticketStatus->project_template_id = BoardColumn::query()
                    ->whereKey($ticketStatus->board_column_id)
                    ->value('project_template_id');
            }

            $ticketStatus->syncProjectTemplateOwnership();
            $ticketStatus->slug = Str::slug($ticketStatus->name);
        });
    }

    public function allowedSourceStatuses(): BelongsToMany
    {
        return $this->belongsToMany(
            self::class,
            'ticket_status_transitions',
            'to_ticket_status_id',
            'from_ticket_status_id',
        )
            ->orderBy('board_column_id')
            ->orderBy('position')
            ->withTimestamps();
    }

    public function allowedTargetStatuses(): BelongsToMany
    {
        return $this->belongsToMany(
            self::class,
            'ticket_status_transitions',
            'from_ticket_status_id',
            'to_ticket_status_id',
        )
            ->orderBy('board_column_id')
            ->orderBy('position')
            ->withTimestamps();
    }

    public function boardColumn(): BelongsTo
    {
        return $this->belongsTo(BoardColumn::class);
    }

    public function project(): BelongsTo
    {
        return $this->belongsTo(Project::class);
    }

    public function tickets(): HasMany
    {
        return $this->hasMany(Ticket::class)
            ->orderByDesc('sequence_number');
    }
}