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

{% block pagetitle %}Statistiques des appels {{ 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 rowspan="3">
                                        {% if sortie.criteres == 1 %}
                                            HORAIRE
                                        {% elseif sortie.criteres == 2 %}
                                            JOUR
                                        {% elseif sortie.criteres == 3 %}
                                            MOIS
                                        {% else %}
                                            DATE
                                        {% endif %}
                                    </th>
                                    <th colspan="14">TOTAL APPELS</th>
                                    <th colspan="8">TAUX APPELS</th>
                                    <th colspan="4" rowspan="2">DUREE MOYENNE</th>
                                    <th rowspan="3">NBR<br>OP<br>CON</th>
                                    <th rowspan="3">ACW</th>
                                    <th rowspan="3">DMT</th>
                                    <th rowspan="3">SLA<br>(en %)</th>
                                </tr>
                                <tr>
                                    <th rowspan="2">TOTAL</th>
                                    <th rowspan="2">SVI</th>
                                    <th rowspan="2">PREcc</th>
                                    <th rowspan="2">PRESop</th>
                                    <th colspan="2">DECROCHES</th>
                                    <th rowspan="2">DISS</th>
                                    <th colspan="3">PERDUS</th>
                                    <th colspan="3">ABANDON</th>
                                    <th rowspan="2">HOR</th>
                                    <th colspan="3">TRAITES</th>
                                    <th colspan="2">PERDUS</th>
                                    <th colspan="2">ABANDON</th>
                                    <th rowspan="2">HOR</th>
                                </tr>
                                <tr>
                                    <th>TOTAL</th>
                                    <th>-30s</th>
                                    <th>TOTAL</th>
                                    <th>EXP</th>
                                    <th>INEXP</th>
                                    <th>TOTAL</th>
                                    <th>EXP</th>
                                    <th>INEXP</th>
                                    <th>EFFIC</th>
                                    <th>SVI</th>
                                    <th>OP</th>
                                    <th>EXP</th>
                                    <th>INEXP</th>
                                    <th>EXP</th>
                                    <th>INEXP</th>
                                    <th>APP</th>
                                    <th>ATT</th>
                                    <th>DIALG</th>
                                    <th>PAU</th>
                                </tr>

                                </thead>
                                <tbody>
                                {% set total_app_recus = 0 %}
                                {% set total_app_svi = 0 %}
                                {% set total_callcenter = 0 %}
                                {% set total_app_presentes = 0 %}
                                {% set total_app_traites = 0 %}
                                {% set nb_app_traites_moins_30s = 0 %}
                                {% set total_app_dissuades = 0 %}
                                {% set total_app_perdus = 0 %}
                                {% set total_app_perdus_exp = 0 %}
                                {% set total_app_perdus_inexp = 0 %}
                                {% set total_abandon_exp = 0 %}
                                {% set total_abandon_inexp = 0 %}
                                {% set total_app_fermeture = 0 %}
                                {% set nb_op_connecte = 0 %}

                                {% for stats in statistiques %}
                                    <tr>
                                        {% if sortie.criteres == 1 %}
                                            {#<td>{{ stats.date_stat|date('d-m-Y') }} </td>#}
                                            <td>{{ stats.horraire }} </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.total_app_recus }}</td>
                                        <td>{{ stats.total_app_svi }}</td>
                                        <td>{{ stats.total_callcenter }}</td>
                                        <td>{{ stats.total_app_presentes }}</td>
                                        <td>{{ stats.total_app_traites }}</td>
                                        <td>{{ stats.nb_app_traites_moins_30s }}</td>
                                        <td>{{ stats.total_app_dissuades }}</td>
                                        <td>{{ stats.total_app_perdus }}</td>
                                        <td>{{ stats.total_app_perdus_exp }}</td>
                                        <td>{{ stats.total_app_perdus_inexp }}</td>
                                        <td>{{ stats.total_abandon_exp + stats.total_abandon_inexp  }}</td>
                                        <td>{{ stats.total_abandon_exp }}</td>
                                        <td>{{ stats.total_abandon_inexp }}</td>
                                        <td>{{ stats.total_app_fermeture }}</td>
                                        <td>{{ stats.taux_app_traite|number_format(2,'.',' ') }}</td>
                                        <td>{{ stats.taux_app_svi|number_format(2,'.',' ') }}</td>
                                        <td>{{ stats.taux_app_op|number_format(2,'.',' ') }}</td>
                                        <td>{{ stats.taux_app_perdus_exp|number_format(2,'.',' ') }}</td>
                                        <td>{{ stats.taux_app_perdus_inexp|number_format(2,'.',' ') }}</td>
                                        <td>{{ stats.taux_abandon_exp|number_format(2,'.',' ') }}</td>
                                        <td>{{ stats.taux_abandon_inexp|number_format(2,'.',' ') }}</td>
                                        <td>{{ stats.taux_app_fermeture|number_format(2,'.',' ') }}</td>
                                        <td>{{ stats.duree_moy_appel|number_format(2,'.',' ') }}</td>
                                        <td>{{ stats.duree_moy_attente|number_format(2,'.',' ') }}</td>
                                        <td>{{ stats.duree_moy_dialogue|number_format(2,'.',' ') }}</td>
                                        <td>{{ stats.duree_moy_pause|number_format(2,'.',' ') }}</td>
                                        <td>{{ stats.nb_op_connecte }}</td>
                                        <td>{{ stats.acw|number_format(2,'.',' ') }}</td>
                                        <td>{{ stats.dmt|number_format(2,'.',' ') }}</td>
                                        <td class="active">
                                            {{ stats.service_level|number_format(2,'.',' ') }}
                                        </td>
                                    </tr>

                                    {% set total_app_recus = total_app_recus + stats.total_app_recus %}
                                    {% set total_app_svi = total_app_svi + stats.total_app_svi %}
                                    {% set total_callcenter = total_callcenter + stats.total_callcenter %}
                                    {% set total_app_presentes = total_app_presentes + stats.total_app_presentes %}
                                    {% set total_app_traites = total_app_traites + stats.total_app_traites %}
                                    {% set nb_app_traites_moins_30s = nb_app_traites_moins_30s + stats.nb_app_traites_moins_30s %}
                                    {% set total_app_dissuades = total_app_dissuades + stats.total_app_dissuades %}
                                    {% set total_app_perdus = total_app_perdus + stats.total_app_perdus %}
                                    {% set total_app_perdus_exp = total_app_perdus_exp + stats.total_app_perdus_exp %}
                                    {% set total_app_perdus_inexp = total_app_perdus_inexp + stats.total_app_perdus_inexp %}
                                    {% set total_abandon_exp = total_abandon_exp + stats.total_abandon_exp %}
                                    {% set total_abandon_inexp = total_abandon_inexp + stats.total_abandon_inexp %}
                                    {% set total_app_fermeture = total_app_fermeture + stats.total_app_fermeture %}
                                    {% set nb_op_connecte = nb_op_connecte + stats.nb_op_connecte %}
                                {% endfor %}
                                </tbody>
                                <tfoot>
                                <tr class="bg-primary">
                                    <th>TOTAUX</th>
                                    <th>{{ total_app_recus|number_format(0,'.',' ') }}</th>
                                    <th>{{ total_app_svi|number_format(0,'.',' ') }}</th>
                                    <th>{{ total_callcenter|number_format(0,'.',' ') }}</th>
                                    <th>{{ total_app_presentes|number_format(0,'.',' ') }}</th>
                                    <th>{{ total_app_traites|number_format(0,'.',' ') }}</th>
                                    <th>{{ nb_app_traites_moins_30s|number_format(0,'.',' ') }}</th>
                                    <th>{{ total_app_dissuades|number_format(0,'.',' ') }}</th>
                                    <th>{{ total_app_perdus|number_format(0,'.',' ') }}</th>
                                    <th>{{ total_app_perdus_exp|number_format(0,'.',' ') }}</th>
                                    <th>{{ total_app_perdus_inexp|number_format(0,'.',' ') }}</th>
                                    <th>{{ total_abandon_exp + total_abandon_inexp }}</th>
                                    <th>{{ total_abandon_exp|number_format(0,'.',' ') }}</th>
                                    <th>{{ total_abandon_inexp|number_format(0,'.',' ') }}</th>
                                    <th>{{ total_app_fermeture|number_format(0,'.',' ') }}</th>
                                    <th></th>
                                    <th></th>
                                    <th></th>
                                    <th></th>
                                    <th></th>
                                    <th></th>
                                    <th></th>
                                    <th></th>
                                    <th></th>
                                    <th></th>
                                    <th></th>
                                    <th></th>
                                    <th>{{ nb_op_connecte|number_format(0,'.',' ') }}</th>
                                    </th>
                                    <th></th>
                                    <th></th>
                                    <th></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 %}