{% extends "base.html" %}
{% block title %}Exporter – AAZ Accounting{% endblock %}
{% block page_title %}Exporter vers Sage{% endblock %}

{% block content %}
<div style="display:grid;grid-template-columns:1fr 1fr;gap:1.5rem;margin-bottom:1.5rem">

  <!-- Formulaire export -->
  <div class="card">
    <div class="card-header">Générer un export</div>
    <div class="card-body">
      <form method="POST" action="{{ url_for('export.generate') }}">
        <input type="hidden" name="csrf_token" value="{{ csrf_token() }}">

        <div class="form-group">
          <label>Format d'export</label>
          <div style="display:flex;gap:.75rem;flex-wrap:wrap">
            {% for val, label, desc in [
              ('fec', 'FEC .txt', 'Norme DGFiP – toutes versions Sage'),
              ('xlsx', 'Excel .xlsx', 'Journal mis en forme AAZ'),
              ('csv', 'CSV Sage', 'Format import natif Sage')
            ] %}
            <label style="flex:1;min-width:140px;cursor:pointer">
              <input type="radio" name="type" value="{{ val }}" {% if val=='fec' %}checked{% endif %}
                     style="margin-right:.4rem">
              <strong>{{ label }}</strong><br>
              <span style="font-size:.75rem;color:var(--text-muted);margin-left:1.2rem">{{ desc }}</span>
            </label>
            {% endfor %}
          </div>
        </div>

        <div style="display:grid;grid-template-columns:1fr 1fr;gap:1rem">
          <div class="form-group">
            <label>Date début</label>
            <input type="date" name="period_start">
          </div>
          <div class="form-group">
            <label>Date fin</label>
            <input type="date" name="period_end">
          </div>
        </div>

        <div class="form-group">
          <label style="display:flex;align-items:center;gap:.5rem;font-weight:400;cursor:pointer">
            <input type="checkbox" name="only_validated" value="1" checked>
            Uniquement les écritures validées
          </label>
        </div>

        <button type="submit" class="btn btn-primary w-100">
          ⬇ Générer et télécharger
        </button>
      </form>
    </div>
  </div>

  <!-- Guide import Sage -->
  <div class="card">
    <div class="card-header">Guide import Sage</div>
    <div class="card-body">
      <div style="font-size:.87rem;color:var(--text-muted);line-height:1.8">
        <p style="margin-bottom:1rem"><strong style="color:var(--primary)">FEC .txt (recommandé)</strong></p>
        <ol style="margin-left:1.2rem;margin-bottom:1rem">
          <li>Dans Sage : <strong>Fichier → Importer</strong></li>
          <li>Sélectionner <strong>FEC</strong> comme format</li>
          <li>Choisir le fichier <code>*_FEC.txt</code></li>
          <li>Vérifier le mapping des colonnes</li>
          <li>Valider l'import</li>
        </ol>
        <hr style="border-color:var(--border);margin:1rem 0">
        <p style="margin-bottom:.5rem"><strong style="color:var(--primary)">CSV Sage</strong></p>
        <ol style="margin-left:1.2rem">
          <li>Sage : <strong>Fichier → Importer → Journal</strong></li>
          <li>Séparateur : <strong>point-virgule ( ; )</strong></li>
          <li>Encodage : <strong>UTF-8</strong></li>
        </ol>
        <div style="margin-top:1rem;padding:.75rem;background:#F0FFF4;border-radius:8px;font-size:.8rem">
          ✓ Compatible Sage 50, Sage 100, Sage Comptabilité (toutes versions)
        </div>
      </div>
    </div>
  </div>
</div>

<!-- Historique exports -->
{% if exports %}
<div class="card">
  <div class="card-header">Historique des exports</div>
  <div class="table-wrapper">
    <table>
      <thead>
        <tr><th>Date</th><th>Fichier</th><th>Type</th><th>Période</th><th>Écritures</th></tr>
      </thead>
      <tbody>
        {% for ex in exports %}
        <tr>
          <td>{{ ex.created_at.strftime('%d/%m/%Y %H:%M') }}</td>
          <td class="font-mono" style="font-size:.8rem">{{ ex.filename }}</td>
          <td><span class="tag tag-info">{{ ex.export_type.upper() }}</span></td>
          <td>
            {% if ex.period_start %}
            {{ ex.period_start.strftime('%d/%m/%Y') }} → {{ ex.period_end.strftime('%d/%m/%Y') }}
            {% else %}–{% endif %}
          </td>
          <td class="text-right">{{ ex.entries_count }}</td>
        </tr>
        {% endfor %}
      </tbody>
    </table>
  </div>
</div>
{% endif %}
{% endblock %}