{% extends "lte/with_sidebar.html" %}
{% load rsl_i18n %}

{% block title %}Administração do sistema{% endblock %}

{% block sidebar %}
<nav class="mt-2">
    <ul class="nav nav-pills nav-sidebar flex-column" data-widget="treeview" role="menu">
        <li class="nav-item">
            <a href="{% url 'portal:dashboard' %}" class="nav-link active">
                <i class="nav-icon fas fa-tachometer-alt"></i>
                <p>Painel</p>
            </a>
        </li>
        <li class="nav-item">
            <a href="{% url 'portal:migrations' %}" class="nav-link">
                <i class="nav-icon fas fa-database"></i>
                <p>Migrações</p>
            </a>
        </li>
        <li class="nav-item">
            <a href="{% url 'portal:settings' %}" class="nav-link">
                <i class="nav-icon fas fa-sliders-h"></i>
                <p>Configurações</p>
            </a>
        </li>
        <li class="nav-item">
            <a href="{% url 'reviews:index' %}" class="nav-link">
                <i class="nav-icon fas fa-arrow-left"></i>
                <p>Voltar ao app</p>
            </a>
        </li>
    </ul>
</nav>
{% endblock %}

{% block content %}
<div class="row">
    <div class="col-lg-8">
        <div class="card">
            <div class="card-header"><h3 class="card-title">Banco de dados</h3></div>
            <div class="card-body">
                <p><strong>Conexão:</strong> {{ db_summary }}</p>
                <table class="table table-sm">
                    <thead><tr><th>Tabela</th><th>Registros</th></tr></thead>
                    <tbody>
                    {% for table, count in table_counts %}
                    <tr>
                        <td>{{ table }}</td>
                        <td>{% if count >= 0 %}{{ count }}{% else %}—{% endif %}</td>
                    </tr>
                    {% endfor %}
                    </tbody>
                </table>
            </div>
        </div>

        <div class="card">
            <div class="card-header"><h3 class="card-title">Importar SQLite (Flask)</h3></div>
            <div class="card-body">
                <p class="text-muted">Copia todos os dados de <code>sysRevisao/instance/sysrevisao.db</code> para o MySQL atual.</p>
                <form method="post" action="{% url 'portal:import_sqlite' %}">
                    {% csrf_token %}
                    <div class="form-group">
                        <label>Caminho do SQLite (opcional)</label>
                        <input type="text" name="sqlite_path" class="form-control" placeholder="Padrão: instance/sysrevisao.db do Flask">
                    </div>
                    <div class="form-check mb-3">
                        <input type="checkbox" class="form-check-input" name="force" value="1" id="forceImport" checked>
                        <label class="form-check-label" for="forceImport">Substituir dados existentes nas tabelas</label>
                    </div>
                    <button type="submit" class="btn btn-warning" onclick="return confirm('Importar dados do SQLite? Isso pode substituir registros existentes.');">
                        <i class="fas fa-file-import"></i> Importar agora
                    </button>
                </form>
                {% if request.session.portal_last_output %}
                <pre class="mt-3 small bg-light p-2" style="max-height:240px;overflow:auto;">{{ request.session.portal_last_output }}</pre>
                {% endif %}
            </div>
        </div>
    </div>
    <div class="col-lg-4">
        <div class="card">
            <div class="card-header"><h3 class="card-title">Variáveis (.env)</h3></div>
            <div class="card-body small">
                <ul class="list-unstyled mb-0">
                    <li><strong>DEBUG:</strong> {{ env.DEBUG|default:"—" }}</li>
                    <li><strong>SKIP_DEMO_SEED:</strong> {{ env.SKIP_DEMO_SEED|default:"—" }}</li>
                    <li><strong>SECRET_KEY:</strong> {{ env_masked.SECRET_KEY|default:"—" }}</li>
                    <li><strong>DATABASE_URL:</strong> {{ env_masked.DATABASE_URL|default:"—" }}</li>
                </ul>
                <a href="{% url 'portal:settings' %}" class="btn btn-sm btn-outline-primary mt-3">Editar configurações</a>
            </div>
        </div>
        {% if portal_settings %}
        <div class="card">
            <div class="card-header"><h3 class="card-title">Portal settings</h3></div>
            <div class="card-body small">
                {% for s in portal_settings %}
                <p class="mb-1"><code>{{ s.key }}</code>: {{ s.value|truncatechars:40 }}</p>
                {% endfor %}
            </div>
        </div>
        {% endif %}
    </div>
</div>
{% endblock %}