{% extends 'base.html.twig' %}
{% block title %}Paiements - liste{% endblock %}
{% block breadcrumb %}
<nav aria-label="breadcrumb">
    <ol class="breadcrumb">
        <li class="breadcrumb-item active" aria-current="page">Paiements</li>
    </ol>
</nav>
{% endblock %}
{% block body %}
<h1>Liste des paiements</h1>
<div>
    Raccourcis :
    <a class="btn btn-primary" href="{{ path('payment_index',{'search':{'date_from':dates.current_month.start,'date_to':dates.current_month.stop}}) }}">Ce mois-ci</a>
    |
    <a class="btn btn-primary" href="{{ path('payment_index',{'search':{'date_from':dates.sliding_month.start,'date_to':dates.sliding_month.stop}}) }}">Mois glissant</a>
    |
    <a class="btn btn-primary" href="{{ path('payment_index',{'search':{'date_from':dates.current_year.start,'date_to':dates.current_year.stop}}) }}">Cette année</a>
    |
    <a class="btn btn-primary" href="{{ path('payment_index',{'search':{'date_from':dates.sliding_year.start,'date_to':dates.sliding_year.stop}}) }}">Année glissante</a>
    |
    <a class="btn btn-primary" href="{{ path('payment_index',{'search':{'date_from':'','date_to':''}}) }}">Depuis toujours</a>
</div>
{% block search %}
<div class="border bg-light p-1 mt-2">
    <form method="get" class="">
        <div class="row">
            <div class="col-md-4">
                <input type="text" class="form-control" name="search[search]" placeholder="Recherche" value="{{ search.search ?? '' }}">
            </div>
            <div class="col-md-2 row">
                <div class="col-md-auto">
                    <label for="search[date_from]">du</label>
                </div>
                <div class="col-md-auto">
                    <div class="input-group">
                        <input type="date" class="form-control" name="search[date_from]" palceholder="du" value="{{ search.date_from ?? '' }}">
                        <span class="input-group-text"><i class="bi bi-calendar"></i></span>
                    </div>
                </div>
            </div>
            <div class="col-md-2 row">
                <div class="col-md-auto">
                    <label for="search[date_to]">au</label>
                </div>
                <div class="col-md-auto">
                    <div class="input-group">
                        <input type="date" class="form-control" name="search[date_to]" palceholder="au" value="{{ search.date_to ?? '' }}">
                        <span class="input-group-text"><i class="bi bi-calendar"></i></span>
                    </div>
                </div>
            </div>
            <div class="col-md-auto">
                <button type="submit" class="btn btn-primary" name="rechercher"><i class="bi bi-search"></i>&nbsp;Rechercher</button>
            </div>
            <div class="col-md-auto">
                <a class="btn btn-success" href="{{ path('payment_new') }}"><i class="bi-plus"></i>&nbsp;Ajouter un paiement</a>
            </div>
        </div>
    </form>
</div>
{% endblock %}
<table class="table">
    <thead>
        <tr>
            <th>Date Paiement</th>
            {# <th>Id</th> #}
            <th>Nom</th>
            <th>Référence</th>
            <th>Type</th>
            <th>Montant</th>
            <th>Moyen de paiement</th>
            {# <th>Description</th> #}
            {# <th>Date_added</th> #}
            <th>Actions</th>
        </tr>
    </thead>
    <tbody>
        {% for payment in payments %}
        <tr>
            <td>{{ payment.datePayment ? payment.datePayment|date('d/m/Y') : '' }}</td>
            {# <td>{{ payment.id }}</td> #}
            <td>{{ payment.name }}</td>
            <td>{{ payment.reference }}</td>
            <td>{{ payment.type ? 'Débit' : 'Crédit' }}</td>
            <td class="text-{{ payment.type ? 'danger' : 'success' }}">
                {{ payment.type ? '-' : '+' }}
                {{ payment.amount|number_format(2) }}
                {{ 'EUR'|currency_symbol }}
            </td>
            <td>{{ payment.getMeanOfPaymentLabel() }}</td>
            {# <td>{{ payment.description }}</td> #}
            {# <td>{{ payment.dateAdded ? payment.dateAdded|date('d/m/Y H:i:s') : '' }}</td> #}
            <td>
                <a class="btn btn-primary" href="{{ path('payment_show', {'id': payment.id}) }}"><i class="bi-eye"></i>&nbsp;Afficher</a>
                <a class="btn btn-success" href="{{ path('payment_edit', {'id': payment.id}) }}"><i class="bi-pencil"></i>&nbsp;Modifier</a>
                <a class="btn btn-outline-primary" data-bs-toggle="collapse" href="#payment-lines-{{ payment.id }}" role="button" aria-expanded="false" aria-controls="payment-lines-{{ payment.id }}"><i class="bi-list"></i>&nbsp;Afficher les lignes</a>
            </td>
        </tr>
        <tr id="payment-lines-{{ payment.id }}" class="collapse bg-light">
            <td>Lignes</td>
            <td colspan="5">
                <div class="pl-5 pr-5">
                    {{ include('payment_line/_payment_lines_table.html.twig',{'paymentLines':payment.paymentLines,'show_description':false}) }}
                </div>
            </td>
            <td></td>
        </tr>
        {% else %}
        <tr>
            <td colspan="7">Aucun paiement à afficher</td>
        </tr>
        {% endfor %}
    </tbody>
</table>
{{ paginer|raw }}
<h2>Statistiques</h2>
<div class="row mt-2">
    <div class="col-md-4">
        <div class="card">
            <div class="card-body">
                <div class="card-title">
                    <h5>Montants</h5>
                </div>
                {% set total = (stats.amounts.plus - stats.amounts.minus) %}
                <table class="table">
                    <thead>
                        <th>Type</th>
                        <th>Montant</th>
                    </thead>
                    <tbody>
                        <tr>
                            <td>Débit</td>
                            <td class="text-danger">
                                -
                                {{ stats.amounts.minus|number_format(2) }}
                                {{ 'EUR'|currency_symbol }}
                            </td>
                        </tr>
                        <tr>
                            <td>Crédit</td>
                            <td class="text-success">
                                +
                                {{ stats.amounts.plus|number_format(2) }}
                                {{ 'EUR'|currency_symbol }}
                            </td>
                        </tr>
                    </tbody>
                    <tfoot>
                        <td>Total</td>
                        <td class="text-{{ (total < 0) ? 'danger' : 'success' }}">
                            {{ total|number_format(2) }} {{ 'EUR'|currency_symbol }} </td>
                    </tfoot>
                </table>
            </div>
        </div>
    </div>
    <div class="col-md-4">
        <div class="card">
            <div class="card-body">
                <div class="card-title">
                    <h5>Catégories</h5>
                    <table class="table">
                        <thead>
                            <th>Catégorie</th>
                            <th>Débit</th>
                            <th>Crédit</th>
                            <th>Total</th>
                        </thead>
                        <tbody>
                            {% set total = 0 %}
                            {% set minus = 0 %}
                            {% set plus = 0 %}
                            {% for category, category_stats in stats.categories %}
                            {% set category_total = (category_stats.plus - category_stats.minus) %}
                            {% set total = total + category_total %}
                            {% set minus = minus + category_stats.minus %}
                            {% set plus = plus + category_stats.plus %}
                            <tr>
                                <td>{{ category }}</td>
                                <td class="text-danger">
                                    -
                                    {{ category_stats.minus|number_format(2) }}
                                    {{ 'EUR'|currency_symbol }}
                                </td>
                                <td class="text-success">
                                    +
                                    {{ category_stats.plus|number_format(2) }}
                                    {{ 'EUR'|currency_symbol }}
                                </td>
                                <td class="text-{{ (category_total < 0) ? 'danger' : 'success' }}">
                                    {{ category_total|number_format(2) }} {{ 'EUR'|currency_symbol }}
                                </td>
                            </tr>
                            {% endfor %}
                        </tbody>
                        <tfoot>
                            <td>Total</td>
                            <td class="text-danger">
                                -
                                {{ minus|number_format(2) }}
                                {{ 'EUR'|currency_symbol }}
                            </td>
                            <td class="text-success">
                                +
                                {{ plus|number_format(2) }}
                                {{ 'EUR'|currency_symbol }}
                            </td>
                            <td class="text-{{ (total < 0) ? 'danger' : 'success' }}">
                                {{ total|number_format(2) }} {{ 'EUR'|currency_symbol }}
                            </td>
                        </tfoot>
                    </table>
                </div>
            </div>
        </div>
    </div>
    <div class="col-md-4">
        <div class="card">
            <div class="card-body">
                <div class="card-title">
                    <h5>Moyens de paiement</h5>
                    <table class="table">
                        <thead>
                            <th>Moyen</th>
                            <th>Débit</th>
                            <th>Crédit</th>
                            <th>Total</th>
                        </thead>
                        <tbody>
                            {% set total = 0 %}
                            {% set minus = 0 %}
                            {% set plus = 0 %}
                            {% for mop, mop_stats in stats.means %}
                            {% set mop_total = (mop_stats.plus - mop_stats.minus) %}
                            {% set total = total + mop_total %}
                            {% set minus = minus + mop_stats.minus %}
                            {% set plus = plus + mop_stats.plus %}
                            <tr>
                                <td>{{ mop }}</td>
                                <td class="text-danger">
                                    -
                                    {{ mop_stats.minus|number_format(2) }}
                                    {{ 'EUR'|currency_symbol }}
                                </td>
                                <td class="text-success">
                                    +
                                    {{ mop_stats.plus|number_format(2) }}
                                    {{ 'EUR'|currency_symbol }}
                                </td>
                                <td class="text-{{ (mop_total < 0) ? 'danger' : 'success' }}">
                                    {{ mop_total|number_format(2) }} {{ 'EUR'|currency_symbol }}
                                </td>
                            </tr>
                            {% endfor %}
                        </tbody>
                        <tfoot>
                            <td>Total</td>
                            <td class="text-danger">
                                -
                                {{ minus|number_format(2) }}
                                {{ 'EUR'|currency_symbol }}
                            </td>
                            <td class="text-success">
                                +
                                {{ plus|number_format(2) }}
                                {{ 'EUR'|currency_symbol }}
                            </td>
                            <td class="text-{{ (total < 0) ? 'danger' : 'success' }}">
                                {{ total|number_format(2) }} {{ 'EUR'|currency_symbol }}
                            </td>
                        </tfoot>
                    </table>
                </div>
            </div>
        </div>
    </div>
</div>
{% endblock %}