@extends('layouts.app')

@section('title', 'Sauvegarde / Restauration - Print Manager')

@section('content')
    <div class="card">
        <div class="card-header bg-dark text-white d-flex justify-content-between align-items-center">
            <h1 class="mb-0"><i class="fas fa-database me-2"></i>Sauvegarde / Restauration</h1>
        </div>
        <div class="card-body">
            @include('partials.session-alerts')

            <div class="row">
                <div class="col-md-6 mb-4">
                    <div class="card h-100">
                        <div class="card-header bg-success text-white">
                            <h5 class="mb-0"><i class="fas fa-download me-2"></i>Sauvegarder</h5>
                        </div>
                        <div class="card-body">
                            <p class="card-text">Génère un fichier <code>.sql</code> complet de la base de données (données, structure, procédures).</p>
                            <form action="{{ route('database.backup.run') }}" method="POST">
                                @csrf
                                <button type="submit" class="btn btn-success">
                                    <i class="fas fa-database me-1"></i> Lancer la sauvegarde
                                </button>
                            </form>
                        </div>
                    </div>
                </div>

                <div class="col-md-6 mb-4">
                    <div class="card h-100">
                        <div class="card-header bg-danger text-white">
                            <h5 class="mb-0"><i class="fas fa-upload me-2"></i>Restaurer</h5>
                        </div>
                        <div class="card-body">
                            <p class="card-text">Restaurer la base à partir d'un fichier <code>.sql</code>. <strong class="text-danger">Cette action remplace toutes les données actuelles.</strong></p>
                            <form action="{{ route('database.restore') }}" method="POST" enctype="multipart/form-data">
                                @csrf
                                <div class="mb-3">
                                    <input type="file" class="form-control" name="backup_file" accept=".sql,.txt" required>
                                </div>
                                <button type="submit" class="btn btn-danger" onclick="return confirm('Voulez-vous vraiment restaurer cette sauvegarde ? Toutes les données actuelles seront remplacées.')">
                                    <i class="fas fa-upload me-1"></i> Restaurer
                                </button>
                            </form>
                        </div>
                    </div>
                </div>
            </div>

            @if(count($files) > 0)
            <div class="card mt-2">
                <div class="card-header bg-secondary text-white">
                    <h5 class="mb-0"><i class="fas fa-archive me-2"></i>Sauvegardes sur le serveur</h5>
                </div>
                <div class="card-body p-0">
                    <table class="table table-striped mb-0">
                        <thead>
                            <tr>
                                <th>Fichier</th>
                                <th>Taille</th>
                                <th>Date</th>
                                <th>Actions</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach($files as $file)
                            <tr>
                                <td><code>{{ $file['name'] }}</code></td>
                                <td>{{ number_format($file['size'] / 1024, 0, ',', ' ') }} Ko</td>
                                <td>{{ $file['date'] }}</td>
                                <td>
                                    <a href="{{ route('database.backup.download', $file['name']) }}" class="btn btn-sm btn-primary" title="Télécharger">
                                        <i class="fas fa-download"></i>
                                    </a>
                                    <form action="{{ route('database.backup.delete', $file['name']) }}" method="POST" class="d-inline">
                                        @csrf
                                        @method('DELETE')
                                        <button type="submit" class="btn btn-sm btn-danger btn-delete" title="Supprimer">
                                            <i class="fas fa-trash"></i>
                                        </button>
                                    </form>
                                </td>
                            </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
            @endif
        </div>
    </div>
@endsection