{% extends "ChakaStatistiquesBundle:base.html.twig" %}

{% block pagetitle %}Statistiques des Emails {{ titre }}{% endblock %}

{% block body %}
    <article class="content-block">
        <div class="row">
            <div class="col-md-12">
                <div role="tabpanel">
                    <div class="row">
                        <div class="col-md-4">
                            <ul class="nav nav-pills stats-tab" role="tablist">
                                <li role="presentation" class="active"><a href="#tableau" aria-controls="tableau"
                                                                          role="tab" data-toggle="tab"><span
                                                class="icon-list"></span> Affichage Tableau</a></li>
                                <li role="presentation"><a href="#chart" aria-controls="chart" role="tab"
                                                           data-toggle="tab"><span
                                                class="icon-chart-area"></span> Affichage Charts</a></li>
                            </ul>
                        </div>
                        <div class="col-md-6 text-right">
                            {% include "ChakaStatistiquesBundle:Statistiques:form_stats.html.twig" %}
                        </div>
                        <div class="col-md-2 text-right">
                            {% include "ChakaStatistiquesBundle:Statistiques:form_export.html.twig" %}
                        </div>
                    </div>

                    <!-- Tab panes -->
                    <div class="tab-content">
                        <div role="tabpanel" class="tab-pane active table-responsive" id="tableau">

                            <table class="table-stat table table-bordered table-striped table-hover text-center"
                                   style="font-size: 12px;">

                                <thead class="header">
                                <tr>
                                    <th >
                                        {% if sortie.criteres == 1 %}
                                            HORAIRE
                                        {% elseif sortie.criteres == 2 %}
                                            JOUR
                                        {% elseif sortie.criteres == 3 %}
                                            MOIS
                                        {% else %}
                                            DATE
                                        {% endif %}
                                    </th>
                                    <th >DNIS</th>
                                    <th >TOTAL MAIL</th>
                                    <th >TOTAL MAIL RECU</th>
                                    <th >TOTAL MAIL ENVOYE</th>
                                    <th >TOTAL MAIL NON ENVOYE</th>
                                </tr>

                                </thead>
                                <tbody>
                                {% set total_mail = 0 %}
                                {% set total_mail_recus = 0 %}
                                {% set total_mail_envoyes = 0 %}
                                {% set total_mail_non_envoyes = 0 %}

                                {% for stats in statistiques %}
                                    <tr>
                                        {% if sortie.criteres == 1 %}
                                            <td>{{ stats.date_stat|date('d-m-Y') }} </td>
                                        {% elseif sortie.criteres == 2 %}
                                            <td>{{ stats.date_stat|date("d") }}</td>
                                        {% elseif sortie.criteres == 3 %}
                                            {% set current_date = "now"|date('Y') %}
                                            <td>{{ stats.annee }}</td>
                                        {% elseif sortie.criteres %}
                                            <td>{{ stats.date_stat|date('d-m-Y') }}</td>
                                        {% endif %}
                                        <td>{{ stats.dnis }}</td>
                                        <td>{{ stats.total_mail }}</td>
                                        <td>{{ stats.total_mail_recus }}</td>
                                        <td>{{ stats.total_mail_envoye }}</td>
                                        <td>{{ stats.total_mail_non_envoye }}</td>

                                    </tr>

                                    {% set total_mail = total_mail+stats.total_mail %}
                                    {% set total_mail_recus = total_mail_recus+stats.total_mail_recus %}
                                    {% set total_mail_envoyes = total_mail_envoyes+stats.total_mail_envoye %}
                                    {% set total_mail_non_envoyes =total_mail_non_envoyes+stats.total_mail_non_envoye  %}
                                {% endfor %}
                                </tbody>
                                <tfoot>
                                <tr class="bg-primary">
                                    <th>TOTAUX</th>
                                    <th></th>
                                    <th>{{ total_mail|number_format(0,'.',' ') }}</th>
                                    <th>{{ total_mail_recus|number_format(0,'.',' ') }}</th>
                                    <th>{{ total_mail_envoyes|number_format(0,'.',' ') }}</th>
                                    <th>{{ total_mail_non_envoyes|number_format(0,'.',' ') }}</th>

                                </tr>
                                </tfoot>
                            </table>

                        </div>
                        <div role="tabpanel" class="tab-pane" id="chart">
                            {#{% include "ChakaStatsBundle:Statistiques:charts.html.twig" %}#}
                        </div>
                    </div>

                </div>

            </div>
        </div>
    </article>
{% endblock %}


{% block javascripts %}
    {#{% include "ChakaStatsBundle:Statistiques:charts_js.html.twig" %}#}
    {% include "ChakaStatistiquesBundle:Statistiques:form_stats_scripts.html.twig" %}
{% endblock %}