{% extends "base.html" %}
{% block titre %}Grand livre client{% endblock %}
{% block contenu %}
<div class="d-flex justify-content-between align-items-center mb-3 no-print">
  <h1 class="h3 mb-0">📗 Grand livre client</h1>
  <a href="/commercial#clients" class="btn btn-outline-secondary btn-sm">← Retour</a>
</div>

<form method="get" action="/commercial/grand-livre" class="card p-3 bg-white mb-4 no-print">
  <div class="row g-2 align-items-end">
    <div class="col-md-5">
      <label class="form-label small mb-1">Client</label>
      <select name="client_id" class="form-select form-select-sm" onchange="this.form.submit()">
        <option value="" {% if not client %}selected{% endif %}>Tous</option>
        {% for c in clients %}
        <option value="{{ c.id }}" {% if client and client.id == c.id %}selected{% endif %}>{{ c.nom }}</option>
        {% endfor %}
      </select>
    </div>
    <div class="col-md-3">
      <label class="form-label small mb-1">Du</label>
      <input type="date" name="date_debut" class="form-control form-control-sm" value="{{ date_debut }}">
    </div>
    <div class="col-md-3">
      <label class="form-label small mb-1">Au</label>
      <input type="date" name="date_fin" class="form-control form-control-sm" value="{{ date_fin }}">
    </div>
    <div class="col-md-1">
      <button type="submit" class="btn btn-success btn-sm w-100">Filtrer</button>
    </div>
  </div>
</form>

{% if not clients %}
<div class="alert alert-warning">Veuillez d'abord créer un <a href="/commercial/clients/nouveau">client</a>.</div>
{% elif livres %}
<div class="d-flex justify-content-end mb-2 no-print">
  <button type="button" class="btn btn-outline-success btn-sm" onclick="window.print()">🖨️ Imprimer / Exporter en PDF</button>
</div>

{% if livres|length > 1 %}
<div class="table-responsive mb-4 no-print">
  <table class="table table-sm table-hover bg-white align-middle">
    <thead><tr><th>Client</th><th class="text-end">Débit</th><th class="text-end">Crédit</th><th class="text-end">Solde final (MAD)</th></tr></thead>
    <tbody>
      {% for livre in livres %}
      <tr>
        <td><a href="#client-{{ livre.client.id }}">{{ livre.client.nom }}</a></td>
        <td class="text-end">{{ "%.2f"|format(livre.total_debit) }}</td>
        <td class="text-end">{{ "%.2f"|format(livre.total_credit) }}</td>
        <td class="text-end {{ 'text-danger fw-semibold' if livre.solde_final > 0 else 'text-success' }}">{{ "%.2f"|format(livre.solde_final) }}</td>
      </tr>
      {% endfor %}
    </tbody>
    <tfoot>
      <tr class="fw-bold table-light">
        <td class="text-end">Total :</td>
        <td class="text-end">{{ "%.2f"|format(livres|sum(attribute="total_debit")) }}</td>
        <td class="text-end">{{ "%.2f"|format(livres|sum(attribute="total_credit")) }}</td>
        <td class="text-end">{{ "%.2f"|format(livres|sum(attribute="solde_final")) }}</td>
      </tr>
    </tfoot>
  </table>
</div>
{% endif %}

{% for livre in livres %}
<div class="grand-livre bg-white p-4 mb-4" id="client-{{ livre.client.id }}">
  <h2 class="h5 mb-1">{{ livre.client.nom }}</h2>
  <div class="text-muted small mb-3">Du {{ livre.date_debut.strftime('%d/%m/%Y') }} au {{ livre.date_fin.strftime('%d/%m/%Y') }}</div>

  <div class="table-responsive">
    <table class="table table-bordered table-sm align-middle grand-livre-table">
      <thead>
        <tr>
          <th>Date</th>
          <th>Journal</th>
          <th>Référence</th>
          <th>Libellé</th>
          <th class="text-end">Débit</th>
          <th class="text-end">Crédit</th>
          <th class="text-end">Solde DB</th>
          <th class="text-end">Solde CR</th>
        </tr>
      </thead>
      <tbody>
        <tr class="table-light">
          <td>{{ livre.date_debut.strftime('%d/%m/%Y') }}</td>
          <td>ANV</td>
          <td></td>
          <td><em>À nouveau (solde d'ouverture)</em></td>
          <td class="text-end"></td>
          <td class="text-end"></td>
          <td class="text-end">{{ "%.2f"|format(livre.solde_ouverture) if livre.solde_ouverture >= 0 else "" }}</td>
          <td class="text-end">{{ "%.2f"|format(-livre.solde_ouverture) if livre.solde_ouverture < 0 else "" }}</td>
        </tr>
        {% for l in livre.lignes %}
        <tr>
          <td>{{ l.date.strftime('%d/%m/%Y') }}</td>
          <td>{{ l.journal }}</td>
          <td>{{ l.reference or "—" }}</td>
          <td>{{ l.libelle }}</td>
          <td class="text-end">{{ "%.2f"|format(l.debit) if l.debit else "" }}</td>
          <td class="text-end">{{ "%.2f"|format(l.credit) if l.credit else "" }}</td>
          <td class="text-end">{{ "%.2f"|format(l.solde_db) if l.solde_db else "" }}</td>
          <td class="text-end">{{ "%.2f"|format(l.solde_cr) if l.solde_cr else "" }}</td>
        </tr>
        {% else %}
        <tr><td colspan="8" class="text-center text-muted">Aucun mouvement sur cette période.</td></tr>
        {% endfor %}
      </tbody>
      <tfoot>
        <tr class="fw-bold table-light">
          <td colspan="4" class="text-end">Total :</td>
          <td class="text-end">{{ "%.2f"|format(livre.total_debit) }}</td>
          <td class="text-end">{{ "%.2f"|format(livre.total_credit) }}</td>
          <td class="text-end" colspan="2">
            Solde final : {{ "%.2f"|format(livre.solde_final) }} MAD
            {{ "(dû par le client)" if livre.solde_final >= 0 else "(en faveur du client)" }}
          </td>
        </tr>
      </tfoot>
    </table>
  </div>
</div>
{% endfor %}
{% endif %}
{% endblock %}