@extends('layouts.app')

@section('content')
<div class="bg-body-light">
    <div class="content content-full">
        <div class="d-flex flex-column flex-sm-row justify-content-sm-between align-items-sm-center py-2">
            <div class="flex-grow-1">
                <h1 class="h3 fw-bold mb-2">
                    <i class="fa fa-database text-flat me-2"></i>Copia de Seguridad (Backup)
                </h1>
                <h2 class="fs-base lh-base fw-medium text-muted mb-0">
                    Resguarde la integridad de la base de datos **BDcosmos79**.
                </h2>
            </div>
        </div>
    </div>
</div>

<div class="content">
    @if(session('success'))
        <div class="alert alert-success d-flex align-items-center" role="alert">
            <i class="fa fa-check-circle me-2"></i>
            <p class="mb-0">{{ session('success') }}</p>
            <button type="button" class="btn-close ms-auto" data-bs-dismiss="alert"></button>
        </div>
    @endif

    <div class="row justify-content-center">
        <div class="col-xl-8">
            
            {{-- Backup de Autorizaciones --}}
            <div class="block block-rounded block-bordered">
                <div class="block-header block-header-default bg-warning-light">
                    <h3 class="block-title">
                        <i class="fa fa-file-export me-1"></i> Exportación de Autorizaciones
                    </h3>
                </div>
                <div class="block-content block-content-full">
                    <div class="row align-items-center">
                        <div class="col-sm-8">
                            @if($ultimaExp)
                                <p class="fs-sm mb-1 text-dark">
                                    <i class="fa fa-history me-1 text-muted"></i> Última exportación: 
                                    <span class="fw-bold">{{ \App\Helpers\FechaHelper::bdToLocal($ultimaExp->fechaini) }}</span>
                                    al
                                    <span class="fw-bold">{{ \App\Helpers\FechaHelper::bdToLocal($ultimaExp->fechafin) }}</span>
                                </p>
                            @endif
                            <p class="fs-sm text-muted mb-0">
                                Genera un archivo SQL incremental con los registros de la tabla <code>autorizaciones</code>.
                            </p>
                        </div>
                        <div class="col-sm-4 text-sm-end mt-3 mt-sm-0">
                            <a href="{{ route('backup.autorizaciones') }}"
                               class="btn btn-warning w-100"
                               onclick="return confirm('¿Generar backup de autorizaciones?')">
                                <i class="fa fa-download me-1"></i> Descargar
                            </a>
                        </div>
                    </div>
                </div>
            </div>

            {{-- Backup General --}}
            <div class="block block-rounded block-bordered shadow-sm">
                <div class="block-header block-header-default">
                    <h3 class="block-title">
                        <i class="fa fa-archive me-1"></i> Backup General del Sistema
                    </h3>
                </div>
                <div class="block-content">
                    <form method="POST" action="{{ route('backup.descargar') }}">
                        @csrf
                        <div class="mb-4">
                            <label class="form-label" for="denominacion">Nombre de la Copia <span class="text-danger">*</span></label>
                            <input type="text" class="form-control" name="denominacion" 
                                   placeholder="Ej: Backup Mensual Abril 2026" maxlength="50" required>
                            <div class="form-text fs-xs text-muted italic">Este nombre se usará para identificar el archivo descargado.</div>
                        </div>

                        <div class="mb-4">
                            <label class="form-label d-flex justify-content-between align-items-center">
                                Seleccionar Tablas
                                <span class="badge bg-primary-light text-primary fs-xs">Dejar vacío para incluir TODAS</span>
                            </label>
                            
                            <div class="p-3 border rounded bg-body-light" style="max-height: 220px; overflow-y: auto;">
                                @php
                                    $tablas = DB::select('SHOW TABLES');
                                    $nombreTablas = array_map(fn($t) => array_values((array)$t)[0], $tablas);
                                @endphp
                                <div class="row g-2">
                                    @foreach($nombreTablas as $t)
                                    <div class="col-sm-6 col-md-4">
                                        <div class="form-check fs-sm">
                                            <input class="form-check-input" type="checkbox" name="tablas[]" value="{{ $t }}" id="t_{{ $t }}">
                                            <label class="form-check-label text-dark" for="t_{{ $t }}">{{ $t }}</label>
                                        </div>
                                    </div>
                                    @endforeach
                                </div>
                            </div>
                        </div>

                        <div class="block-content block-content-full block-content-sm bg-body-light mx-n4 mb-n4 text-end">
                            <a href="{{ route('backup.copias') }}" class="btn btn-alt-secondary">
                                <i class="fa fa-list me-1"></i> Ver Historial
                            </a>
                            <button type="submit" class="btn btn-primary" onclick="return confirm('¿Generar y descargar backup?')">
                                <i class="fa fa-download me-1"></i> Iniciar Backup
                            </button>
                        </div>
                    </form>
                </div>
            </div>

            {{-- Nota Técnica --}}
            <div class="block block-rounded bg-info-light mt-4">
                <div class="block-content block-content-full d-flex align-items-center justify-content-between">
                    <div class="me-3">
                        <p class="fs-sm text-info-dark mb-0">
                            <i class="fa fa-info-circle me-1"></i>
                            <strong>Restauración:</strong> Para importar un backup use: 
                            <code>mysql -u root -p BDcosmos79 < archivo.sql</code>
                        </p>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection