@extends('layouts.panel-admin')
@section('title', 'Vídeos huérfanos')
@section('content')

<div class="page-header">
    <h1>Vídeos huérfanos</h1>
    <span class="text-muted">
        {{ $orphanedFiles->count() }} archivo(s) sin registro &bull;
        {{ $brokenRecords->count() }} registro(s) sin archivo &bull;
        {{ $profilelessRecords->count() }} registro(s) sin perfil
    </span>
</div>

@if($orphanedFiles->isEmpty() && $brokenRecords->isEmpty() && $profilelessRecords->isEmpty())
    <div class="alert alert-success">
        Todo limpio. No hay vídeos huérfanos.
    </div>
@endif

{{-- ── Archivos sin registro en BD ── --}}
@if($orphanedFiles->isNotEmpty())
<section style="margin-bottom:2.5rem">
    <h2 style="font-size:1.1rem;margin-bottom:1rem">
        Archivos en disco sin registro en BD
        <span class="badge badge-warning">{{ $orphanedFiles->count() }}</span>
    </h2>
    <div class="video-grid">
        @foreach($orphanedFiles as $video)
        <div class="video-card">
            <div class="video-card__preview">
                <video controls preload="none" style="width:100%;height:100%;object-fit:cover">
                    <source src="/videos/{{ $video->filename }}" type="video/{{ $video->ext === 'mov' ? 'quicktime' : $video->ext }}">
                </video>
            </div>
            <div class="video-card__info">
                <p class="video-card__name" title="{{ $video->filename }}">{{ $video->filename }}</p>
                <p class="video-card__meta">
                    {{ number_format($video->size / (1024 * 1024), 1) }} MB
                    &bull; <span style="text-transform:uppercase">{{ $video->ext }}</span>
                </p>
            </div>
            <div class="video-card__actions">
                <a href="/videos/{{ $video->filename }}" target="_blank" class="btn btn-sm btn-secondary">Ver</a>
                <form method="POST"
                      action="/panel-admin/videos-huerfanos/archivo/{{ $video->filename }}"
                      onsubmit="return confirm('¿Eliminar este archivo del disco?')">
                    @csrf @method('DELETE')
                    <button type="submit" class="btn btn-sm btn-danger">Eliminar</button>
                </form>
            </div>
        </div>
        @endforeach
    </div>
</section>
@endif

{{-- ── Registros en BD sin archivo en disco ── --}}
@if($brokenRecords->isNotEmpty())
<section style="margin-bottom:2.5rem">
    <h2 style="font-size:1.1rem;margin-bottom:1rem">
        Registros en BD sin archivo en disco
        <span class="badge badge-warning">{{ $brokenRecords->count() }}</span>
    </h2>
    <table class="admin-table">
        <thead>
            <tr>
                <th>Filename</th>
                <th>Profile ID</th>
                <th>Estado</th>
                <th>Creado</th>
                <th>Acciones</th>
            </tr>
        </thead>
        <tbody>
            @foreach($brokenRecords as $record)
            <tr>
                <td style="font-family:monospace;font-size:.85rem">{{ $record->filename }}</td>
                <td style="font-family:monospace;font-size:.75rem">
                    <a href="/panel-admin/perfiles/{{ $record->profile_id }}/editar">{{ $record->profile_id }}</a>
                </td>
                <td>
                    <span class="badge {{ $record->status === 'approved' ? 'badge-success' : 'badge-warning' }}">
                        {{ $record->status === 'approved' ? 'Aprobado' : 'Pendiente' }}
                    </span>
                </td>
                <td>{{ $record->created_at }}</td>
                <td>
                    <form method="POST"
                          action="/panel-admin/videos-huerfanos/registro/{{ $record->id }}"
                          onsubmit="return confirm('¿Eliminar este registro de la base de datos?')">
                        @csrf @method('DELETE')
                        <button type="submit" class="btn btn-sm btn-danger">Eliminar registro</button>
                    </form>
                </td>
            </tr>
            @endforeach
        </tbody>
    </table>
</section>
@endif

{{-- ── Registros con perfil inexistente ── --}}
@if($profilelessRecords->isNotEmpty())
<section style="margin-bottom:2.5rem">
    <h2 style="font-size:1.1rem;margin-bottom:1rem">
        Registros cuyo perfil fue eliminado
        <span class="badge badge-warning">{{ $profilelessRecords->count() }}</span>
    </h2>
    <div class="video-grid">
        @foreach($profilelessRecords as $record)
        <div class="video-card">
            <div class="video-card__preview">
                @if($record->fileExists)
                    <video controls preload="none" style="width:100%;height:100%;object-fit:cover">
                        <source src="/videos/{{ $record->filename }}" type="video/{{ $record->ext === 'mov' ? 'quicktime' : $record->ext }}">
                    </video>
                @else
                    <div style="display:flex;align-items:center;justify-content:center;height:100%;color:#94a3b8;font-size:.8rem;padding:1rem;text-align:center">
                        Archivo no encontrado
                    </div>
                @endif
            </div>
            <div class="video-card__info">
                <p class="video-card__name" title="{{ $record->filename }}">{{ $record->filename }}</p>
                <p class="video-card__meta">
                    @if($record->fileExists)
                        <span style="color:var(--color-success)">Archivo en disco ✓</span>
                    @else
                        <span style="color:#94a3b8">Sin archivo</span>
                    @endif
                    &bull;
                    <span class="badge {{ $record->status === 'approved' ? 'badge-success' : 'badge-warning' }}">
                        {{ $record->status === 'approved' ? 'Aprobado' : 'Pendiente' }}
                    </span>
                </p>
            </div>
            <div class="video-card__actions">
                @if($record->fileExists)
                    <a href="/videos/{{ $record->filename }}" target="_blank" class="btn btn-sm btn-secondary">Ver</a>
                @endif
                <form method="POST"
                      action="/panel-admin/videos-huerfanos/sin-perfil/{{ $record->id }}"
                      onsubmit="return confirm('¿Eliminar registro y archivo?')">
                    @csrf @method('DELETE')
                    <button type="submit" class="btn btn-sm btn-danger">Eliminar</button>
                </form>
            </div>
        </div>
        @endforeach
    </div>
</section>
@endif

<style>
.video-grid {
    display: grid;
    grid-template-columns: repeat(auto-fill, minmax(240px, 1fr));
    gap: 1rem;
}
.video-card {
    border: 1px solid var(--color-border, #e2e8f0);
    border-radius: 8px;
    overflow: hidden;
    background: #fff;
    display: flex;
    flex-direction: column;
}
.video-card__preview {
    aspect-ratio: 16/9;
    overflow: hidden;
    background: #0f172a;
}
.video-card__info {
    padding: .5rem .75rem .25rem;
    flex: 1;
}
.video-card__name {
    font-size: .78rem;
    font-family: monospace;
    white-space: nowrap;
    overflow: hidden;
    text-overflow: ellipsis;
    margin: 0 0 .25rem;
}
.video-card__meta {
    font-size: .75rem;
    color: #64748b;
    margin: 0;
}
.video-card__actions {
    padding: .5rem .75rem .75rem;
    display: flex;
    gap: .5rem;
}
.video-card__actions form { margin: 0; }
</style>

@endsection