{% extends "base.html" %}
{% block title %}Gestion des bases — GMAO{% endblock %}

{% block content %}
<div class="container-fluid py-4">
    <div class="row">
        <div class="col-12">
            <h2 class="mb-4"><i class="bi bi-database"></i> Gestion des bases de données</h2>
            
            <!-- Actions principales -->
            <div class="card mb-4">
                <div class="card-header">
                    <i class="bi bi-gear"></i> Actions
                </div>
                <div class="card-body">
                    <div class="row g-3">
                        <!-- Créer une nouvelle base -->
                        <div class="col-md-4">
                            <div class="card h-100 border-primary">
                                <div class="card-body">
                                    <h5 class="card-title"><i class="bi bi-plus-circle text-primary"></i> Nouvelle base</h5>
                                    <p class="card-text small">Créer une nouvelle base de données vide.</p>
                                    <form method="POST" action="{{ url_for('setup_wizard.create') }}">
                                        <div class="input-group input-group-sm">
                                            <input type="text" class="form-control" name="name" placeholder="Nom (ex: test)" required pattern="[a-zA-Z0-9_-]+" title="Caractères alphanumériques, tirets et underscores uniquement">
                                            <span class="input-group-text">.db</span>
                                            <button type="submit" class="btn btn-primary"><i class="bi bi-plus"></i></button>
                                        </div>
                                    </form>
                                </div>
                            </div>
                        </div>
                        
                        <!-- Sauvegarder la base actuelle -->
                        <div class="col-md-4">
                            <div class="card h-100 border-success">
                                <div class="card-body">
                                    <h5 class="card-title"><i class="bi bi-download text-success"></i> Sauvegarder</h5>
                                    <p class="card-text small">Créer une copie horodatée de la base active.</p>
                                    <form method="POST" action="{{ url_for('setup_wizard.backup') }}">
                                        <button type="submit" class="btn btn-success btn-sm w-100">
                                            <i class="bi bi-download"></i> Créer une sauvegarde
                                        </button>
                                    </form>
                                </div>
                            </div>
                        </div>
                        
                       <!-- Recharger la base à chaud -->
                        <div class="col-md-4">
                            <div class="card h-100 border-info">
                                <div class="card-body">
                                    <h5 class="card-title"><i class="bi bi-arrow-repeat text-info"></i> Recharger</h5>
                                    <p class="card-text small">Recharger la base de données active sans redémarrer.</p>
                                    <form method="POST" action="{{ url_for('setup_wizard.reload_db') }}">
                                        <button type="submit" class="btn btn-info btn-sm w-100">
                                            <i class="bi bi-arrow-repeat"></i> Recharger la base
                                        </button>
                                    </form>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            
            <!-- Liste des bases -->
            <div class="card">
                <div class="card-header d-flex justify-content-between align-items-center">
                    <span><i class="bi bi-collection"></i> Bases de données disponibles</span>
                    <form method="POST" action="{{ url_for('setup_wizard.delete_db', filename='dummy') }}" onsubmit="return confirm('Vider la corbeille ?');" id="clearTrashForm">
                        <button type="button" class="btn btn-outline-danger btn-sm" onclick="clearTrash()">
                            <i class="bi bi-trash"></i> Vider la corbeille
                        </button>
                    </form>
                </div>
                <div class="card-body p-0">
                    {% if databases %}
                    <div class="table-responsive">
                        <table class="table table-hover mb-0">
                            <thead class="table-light">
                                <tr>
                                    <th>Fichier</th>
                                    <th>Taille</th>
                                    <th>Modifié le</th>
                                    <th>Statut</th>
                                    <th class="text-end">Actions</th>
                                </tr>
                            </thead>
                            <tbody>
                                {% for db in databases %}
                                <tr {% if db.is_current %}class="table-primary"{% endif %}>
                                    <td>
                                        <code>{{ db.filename }}</code>
                                        {% if db.is_current %}
                                        <span class="badge bg-primary ms-2">Active</span>
                                        {% endif %}
                                    </td>
                                    <td>{{ (db.size / 1024) | round(1) }} Ko</td>
                                    <td>{{ db.modified.strftime('%d/%m/%Y %H:%M') }}</td>
                                    <td>
                                        {% if db.is_current %}
                                        <span class="badge bg-success"><i class="bi bi-check-circle"></i> En cours</span>
                                        {% else %}
                                        <span class="badge bg-secondary">Inactive</span>
                                        {% endif %}
                                    </td>
                                    <td class="text-end">
                                        {% if not db.is_current %}
                                        <form method="POST" action="{{ url_for('setup_wizard.switch_db', filename=db.filename) }}" style="display:inline;" onsubmit="return confirm('Basculer vers cette base ?');">
                                            <button type="submit" class="btn btn-sm btn-outline-primary" title="Activer cette base">
                                                <i class="bi bi-arrow-repeat"></i> Activer
                                            </button>
                                        </form>
                                        <form method="POST" action="{{ url_for('setup_wizard.delete_db', filename=db.filename) }}" style="display:inline;" onsubmit="return confirm('Supprimer cette base ?');">
                                            <button type="submit" class="btn btn-sm btn-outline-danger" title="Supprimer">
                                                <i class="bi bi-trash"></i>
                                            </button>
                                        </form>
                                        {% else %}
                                        <span class="text-muted small">Base active</span>
                                        {% endif %}
                                    </td>
                                </tr>
                                {% endfor %}
                            </tbody>
                        </table>
                    </div>
                    {% else %}
                    <div class="p-4 text-center text-muted">
                        <i class="bi bi-inbox fs-1"></i>
                        <p>Aucune base de données trouvée.</p>
                    </div>
                    {% endif %}
                </div>
            </div>
            
            <!-- Avertissement -->
            <div class="alert alert-warning mt-4" role="alert">
                <i class="bi bi-exclamation-triangle"></i> <strong>Attention :</strong> 
                Le basculement vers une autre base nécessite un rechargement pour prendre effet.
                Les bases supprimées sont déplacées vers une corbeille.
            </div>
        </div>
    </div>
</div>

<script>
function clearTrash() {
    if (confirm('Vider la corbeille ? Cette action est irréversible.')) {
        fetch('/setup-wizard/admin/clear-trash', {method: 'POST'})
            .then(r => r.json())
            .then(data => {
                if (data.success) {
                    location.reload();
                } else {
                    alert(data.error || 'Erreur');
                }
            });
    }
}
</script>
{% endblock %}