{% extends 'base.html.twig' %}

{% block title %}Solde Agents & Personnel{% endblock %}

{% block body %}
<div class="container mt-4">

    <h3 class="mb-4">💰 Soldes des Agents et Personnel (Supérieur à 0)</h3>

    {# 🔹 FILTRE #}
    <form method="get" class="row mb-3">
        <div class="col-md-4">
            <select name="type" class="form-select" onchange="this.form.submit()">
                <option value="">-- Tous les types --</option>
                <option value="Agent" {{ app.request.get('type') == 'Agent' ? 'selected' : '' }}>
                    Agent
                </option>
                <option value="Personnel" {{ app.request.get('type') == 'Personnel' ? 'selected' : '' }}>
                    Personnel
                </option>
            </select>
        </div>
    </form>

    {# 🔹 EXPORT PDF (garde le filtre actif) #}
    <a href="{{ path('caisse_solde_tous', {
        export: 'pdf',
        type: app.request.get('type')
    }) }}" 
       class="btn btn-primary mb-3">
       Exporter PDF
    </a>

    {# 🔹 TABLEAU #}
    <table class="table table-bordered">
        <thead class="table-light">
            <tr>
                <th>Type</th>
                <th>Nom Prénom</th>
                <th>Total Débit</th>
                <th>Total Crédit</th>
                <th>Solde</th>
            </tr>
        </thead>
        <tbody>
            {% for r in results %}
            <tr>
                <td>{{ r.type }}</td>
                <td>{{ r.nom }} {{ r.prenom }}</td>
                <td class="text-success">
                    {{ r.debit|number_format(3, '.', ' ') }} DT
                 {% if r.excedent is defined and r.excedent > 0 %}
        <br>
        <small class="text-warning">
            Excédent : {{ r.excedent|number_format(3,'.',' ') }}
        </small>
    {% endif %}
                </td>
                <td class="text-danger">
                    {{ r.credit|number_format(3, '.', ' ') }} DT   
                   {% if r.cashe is defined and r.cashe > 0 %}
        <br>
        <small class="text-warning">
            Cash: {{ r.cashe|number_format(3,'.',' ') }} DT
        </small>
    {% endif %}
                </td>
                <td class="fw-bold
                    {% if r.solde < 0 %}
                        text-danger
                    {% else %}
                        text-success
                    {% endif %}
                ">
                    {{ r.solde|number_format(3, '.', ' ') }} DT
                </td>
            </tr>
            {% else %}
            <tr>
                <td colspan="5" class="text-center text-muted">
                    Aucun solde positif trouvé
                </td>
            </tr>
          
            {% endfor %}


              <tr class="table-primary">
    <td colspan="4"><strong>Total en cours</strong></td>
    <td class="fw-bold text-primary">
        {{ totalGeneral|number_format(3, '.', ' ') }} DT
    </td>
</tr>
        </tbody>
    </table>

   

</div>
{% endblock %}