{% extends 'layouts/authenticated.html.twig' %}

{% block page_title %}{{ page_title }}{% endblock %}

{% block content %}
<div class="max-w-7xl mx-auto">
    {# En-tête #}
    <div class="mb-6">
        <nav class="flex mb-4" aria-label="Breadcrumb">
            <ol class="inline-flex items-center space-x-1 md:space-x-3">
                <li class="inline-flex items-center">
                    <a href="{{ path('app_admin_database_index') }}" class="inline-flex items-center text-sm font-medium text-gray-700 hover:text-indigo-600">
                        <i class="fas fa-database mr-2"></i> Sauvegardes
                    </a>
                </li>
                <li aria-current="page">
                    <div class="flex items-center">
                        <i class="fas fa-chevron-right text-gray-400 mx-2"></i>
                        <span class="text-sm font-medium text-gray-500">Historique</span>
                    </div>
                </li>
            </ol>
        </nav>
        <div class="flex justify-between items-center">
            <div>
                <h1 class="text-3xl font-bold text-gray-900 flex items-center">
                    <i class="fas fa-history text-indigo-600 mr-3"></i>
                    {{ page_title }}
                </h1>
                <p class="mt-1 text-sm text-gray-600">{{ total_backups }} sauvegarde(s) au total</p>
            </div>
            <div>
                <a href="{{ path('app_admin_database_create') }}"
                   class="inline-flex items-center px-4 py-2 border border-transparent shadow-sm text-sm font-medium rounded-md text-white bg-indigo-600 hover:bg-indigo-700 focus:outline-none focus:ring-2 focus:ring-offset-2 focus:ring-indigo-500">
                    <i class="fas fa-plus mr-2"></i> Nouvelle Sauvegarde
                </a>
            </div>
        </div>
    </div>

    <div class="bg-white shadow rounded-lg overflow-hidden">
        {# Filtres #}
        <div class="px-4 py-5 border-b border-gray-200 sm:px-6">
            <div class="flex justify-between items-center">
                <h3 class="text-lg leading-6 font-medium text-gray-900">
                    <i class="fas fa-filter mr-2"></i> Filtrer
                </h3>
                <div class="inline-flex rounded-md shadow-sm" role="group">
                    <a href="{{ path('app_admin_database_history', {filter: 'all'}) }}"
                       class="px-4 py-2 text-sm font-medium {{ filter == 'all' ? 'bg-indigo-600 text-white' : 'bg-white text-gray-700 hover:bg-gray-50' }} border border-gray-300 rounded-l-md">
                        Toutes
                    </a>
                    <a href="{{ path('app_admin_database_history', {filter: 'compressed'}) }}"
                       class="px-4 py-2 text-sm font-medium {{ filter == 'compressed' ? 'bg-indigo-600 text-white' : 'bg-white text-gray-700 hover:bg-gray-50' }} border-t border-b border-gray-300">
                        Compressées
                    </a>
                    <a href="{{ path('app_admin_database_history', {filter: 'uncompressed'}) }}"
                       class="px-4 py-2 text-sm font-medium {{ filter == 'uncompressed' ? 'bg-indigo-600 text-white' : 'bg-white text-gray-700 hover:bg-gray-50' }} border border-gray-300 rounded-r-md">
                        Non compressées
                    </a>
                </div>
            </div>
        </div>

        {# Liste des sauvegardes #}
        {% if backups is empty %}
            <div class="text-center py-12">
                <i class="fas fa-inbox text-gray-400 text-5xl mb-4"></i>
                <p class="text-gray-500 mb-4">Aucune sauvegarde trouvée</p>
                <a href="{{ path('app_admin_database_create') }}"
                   class="inline-flex items-center px-4 py-2 border border-transparent text-sm font-medium rounded-md text-white bg-indigo-600 hover:bg-indigo-700">
                    <i class="fas fa-plus mr-2"></i> Créer la première sauvegarde
                </a>
            </div>
        {% else %}
            <div class="overflow-x-auto">
                <table class="min-w-full divide-y divide-gray-200">
                    <thead class="bg-gray-50">
                        <tr>
                            <th scope="col" class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">
                                Fichier
                            </th>
                            <th scope="col" class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">
                                Date/Heure
                            </th>
                            <th scope="col" class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">
                                Taille
                            </th>
                            <th scope="col" class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">
                                Durée
                            </th>
                            <th scope="col" class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">
                                Intégrité
                            </th>
                            <th scope="col" class="px-6 py-3 text-right text-xs font-medium text-gray-500 uppercase tracking-wider">
                                Actions
                            </th>
                        </tr>
                    </thead>
                    <tbody class="bg-white divide-y divide-gray-200">
                        {% for backup in backups %}
                            <tr class="hover:bg-gray-50">
                                <td class="px-6 py-4">
                                    <div class="flex items-center">
                                        <i class="fas fa-file-archive text-lg {{ backup.compressed ? 'text-green-500' : 'text-gray-400' }} mr-2"></i>
                                        <div>
                                            <div class="text-sm font-medium text-gray-900">{{ backup.filename }}</div>
                                            {% if backup.compressed %}
                                                <div class="text-xs text-gray-500">
                                                    <i class="fas fa-compress"></i> Compressée
                                                </div>
                                            {% endif %}
                                        </div>
                                    </div>
                                </td>
                                <td class="px-6 py-4 whitespace-nowrap">
                                    <div class="text-sm text-gray-900">{{ backup.datetime|date('d/m/Y') }}</div>
                                    <div class="text-xs text-gray-500">{{ backup.datetime|date('H:i:s') }}</div>
                                </td>
                                <td class="px-6 py-4 whitespace-nowrap">
                                    <span class="px-2 inline-flex text-xs leading-5 font-semibold rounded-full bg-gray-100 text-gray-800">
                                        {{ backup.formatted_size }}
                                    </span>
                                </td>
                                <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-500">
                                    {{ backup.duration }} sec
                                </td>
                                <td class="px-6 py-4 whitespace-nowrap">
                                    {% if backup.integrity_check.valid %}
                                        <span class="px-2 inline-flex text-xs leading-5 font-semibold rounded-full bg-green-100 text-green-800">
                                            <i class="fas fa-check mr-1"></i> Valide
                                        </span>
                                    {% else %}
                                        <span class="px-2 inline-flex text-xs leading-5 font-semibold rounded-full bg-red-100 text-red-800"
                                              title="{{ backup.integrity_check.reason|default('Raison inconnue') }}">
                                            <i class="fas fa-times mr-1"></i> Invalide
                                        </span>
                                    {% endif %}
                                </td>
                                <td class="px-6 py-4 whitespace-nowrap text-right text-sm font-medium">
                                    <div class="flex justify-end space-x-2">
                                        {# Télécharger #}
                                        <a href="{{ path('app_admin_database_download', {filename: backup.filename}) }}"
                                           class="text-indigo-600 hover:text-indigo-900"
                                           title="Télécharger">
                                            <i class="fas fa-download"></i>
                                        </a>

                                        {# Test de restauration #}
                                        <button type="button"
                                                onclick="testRestore('{{ backup.filename }}')"
                                                class="text-blue-600 hover:text-blue-900"
                                                title="Tester la restauration">
                                            <i class="fas fa-flask"></i>
                                        </button>

                                        {# Supprimer #}
                                        <button type="button"
                                                onclick="confirmDelete('{{ backup.filename }}')"
                                                class="text-red-600 hover:text-red-900"
                                                title="Supprimer">
                                            <i class="fas fa-trash"></i>
                                        </button>
                                    </div>
                                </td>
                            </tr>
                        {% endfor %}
                    </tbody>
                </table>
            </div>

            {# Pagination #}
            {% if total_pages > 1 %}
                <div class="bg-white px-4 py-3 flex items-center justify-between border-t border-gray-200 sm:px-6">
                    <div class="flex-1 flex justify-between sm:hidden">
                        {% if current_page > 1 %}
                            <a href="{{ path('app_admin_database_history', {page: current_page - 1, filter: filter}) }}"
                               class="relative inline-flex items-center px-4 py-2 border border-gray-300 text-sm font-medium rounded-md text-gray-700 bg-white hover:bg-gray-50">
                                Précédent
                            </a>
                        {% endif %}
                        {% if current_page < total_pages %}
                            <a href="{{ path('app_admin_database_history', {page: current_page + 1, filter: filter}) }}"
                               class="ml-3 relative inline-flex items-center px-4 py-2 border border-gray-300 text-sm font-medium rounded-md text-gray-700 bg-white hover:bg-gray-50">
                                Suivant
                            </a>
                        {% endif %}
                    </div>
                    <div class="hidden sm:flex-1 sm:flex sm:items-center sm:justify-between">
                        <div>
                            <p class="text-sm text-gray-700">
                                Page <span class="font-medium">{{ current_page }}</span> sur <span class="font-medium">{{ total_pages }}</span>
                            </p>
                        </div>
                        <div>
                            <nav class="relative z-0 inline-flex rounded-md shadow-sm -space-x-px" aria-label="Pagination">
                                {% if current_page > 1 %}
                                    <a href="{{ path('app_admin_database_history', {page: current_page - 1, filter: filter}) }}"
                                       class="relative inline-flex items-center px-2 py-2 rounded-l-md border border-gray-300 bg-white text-sm font-medium text-gray-500 hover:bg-gray-50">
                                        <i class="fas fa-chevron-left"></i>
                                    </a>
                                {% endif %}

                                {% for page in 1..total_pages %}
                                    {% if page == current_page %}
                                        <span class="z-10 bg-indigo-50 border-indigo-500 text-indigo-600 relative inline-flex items-center px-4 py-2 border text-sm font-medium">
                                            {{ page }}
                                        </span>
                                    {% elseif page == 1 or page == total_pages or (page >= current_page - 2 and page <= current_page + 2) %}
                                        <a href="{{ path('app_admin_database_history', {page: page, filter: filter}) }}"
                                           class="bg-white border-gray-300 text-gray-500 hover:bg-gray-50 relative inline-flex items-center px-4 py-2 border text-sm font-medium">
                                            {{ page }}
                                        </a>
                                    {% elseif page == current_page - 3 or page == current_page + 3 %}
                                        <span class="relative inline-flex items-center px-4 py-2 border border-gray-300 bg-white text-sm font-medium text-gray-700">
                                            ...
                                        </span>
                                    {% endif %}
                                {% endfor %}

                                {% if current_page < total_pages %}
                                    <a href="{{ path('app_admin_database_history', {page: current_page + 1, filter: filter}) }}"
                                       class="relative inline-flex items-center px-2 py-2 rounded-r-md border border-gray-300 bg-white text-sm font-medium text-gray-500 hover:bg-gray-50">
                                        <i class="fas fa-chevron-right"></i>
                                    </a>
                                {% endif %}
                            </nav>
                        </div>
                    </div>
                </div>
            {% endif %}
        {% endif %}
    </div>
</div>

{# Formulaire de suppression caché #}
<form id="deleteForm" method="post" style="display: none;">
    <input type="hidden" name="_token" id="deleteToken">
</form>

{# Scripts #}
<script>
// Confirmation de suppression
function confirmDelete(filename) {
    if (confirm(`Êtes-vous sûr de vouloir supprimer la sauvegarde :\n${filename} ?\n\nCette action est irréversible.`)) {
        const form = document.getElementById('deleteForm');
        form.action = '{{ path('app_admin_database_delete', {filename: '__FILENAME__'}) }}'.replace('__FILENAME__', filename);

        // Générer et ajouter le token CSRF
        const token = '{{ csrf_token('delete_backup_') }}' + filename;
        document.getElementById('deleteToken').value = token;

        form.submit();
    }
}

// Test de restauration
function testRestore(filename) {
    if (!confirm(`Voulez-vous tester la restauration de :\n${filename} ?\n\nCela créera une base de données temporaire pour vérifier l'intégrité.`)) {
        return;
    }

    const btn = event.target.closest('button');
    const originalHtml = btn.innerHTML;
    btn.disabled = true;
    btn.innerHTML = '<svg class="animate-spin h-4 w-4 text-blue-600 inline-block" xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 24 24"><circle class="opacity-25" cx="12" cy="12" r="10" stroke="currentColor" stroke-width="4"></circle><path class="opacity-75" fill="currentColor" d="M4 12a8 8 0 018-8V0C5.373 0 0 5.373 0 12h4zm2 5.291A7.962 7.962 0 014 12H0c0 3.042 1.135 5.824 3 7.938l3-2.647z"></path></svg>';

    const formData = new FormData();
    formData.append('_token', '{{ csrf_token('test_restore_') }}' + filename);

    fetch('{{ path('app_admin_database_test_restore', {filename: '__FILENAME__'}) }}'.replace('__FILENAME__', filename), {
        method: 'POST',
        body: formData
    })
    .then(response => response.json())
    .then(data => {
        btn.disabled = false;
        btn.innerHTML = originalHtml;

        if (data.success) {
            alert(`✓ Test réussi !\n\nNombre de tables restaurées : ${data.table_count}`);
        } else {
            alert(`✗ Test échoué\n\nErreur : ${data.error}`);
        }
    })
    .catch(error => {
        btn.disabled = false;
        btn.innerHTML = originalHtml;
        alert(`✗ Erreur lors du test\n\n${error.message}`);
    });
}
</script>
{% endblock %}