{% extends "AdmingeneratorGeneratorBundle::base_admin_assetic_less.html.twig" %}

{% block title %}Synthèse{% endblock %}
{% block stylesheets %}
{{parent()}}
    <style media="print" >
        <!--
       @page {
         size: landscape;   /* auto is the initial value */
         margin: 7mm;
       }
       -->
       body{
           padding-top: 0px;
           padding-bottom: 0px;
       }
       .navbar, 
       .navbar-fixed-top, 
       #list-actions-bar, 
       .list_nbresults,
       .row-fluid>form,
       .form-actions,
       #table_list_sort,
       .sf-toolbar >div,
       .sf-toolbar,
       #menuprint{
         display: none;
       }
       .break{
         page-break-before : avoid;
         page-break-after: auto;
       }
       .table .thead,
       .table .tbody {
         page-break-inside: avoid;
       }
       .table thead tr>th,
       .table tbody tr>td{
         font-size: 8pt;
         padding: 1px;
       }
       .table thead tr>th{
         font-weight: normal;
       }    
    </style>
{% endblock %}
{% block body %}
<script>
$(document).ready(function(){            
   {% if (requete_groupe!=-1) %}
           $("#synthese_search_groupes").val("{{requete_groupe}}");
   {% endif %} 
   {% if (requete_centre!=-1) %}
           $("#synthese_search_centres").val("{{requete_centre}}");
   {% endif %}    
   $("#synthese_search_centres").change(function ()
    {
        $("#synthese_search_groupes").val("");
        $("#synthese_search_stagiaires").val("");
        document.getElementById('forme').submit();
    });
   $("#synthese_search_groupes").change(function ()
    {
        $("#synthese_search_stagiaires").val("");    
        document.getElementById('forme').submit();
    });
    /*$("thead.toggleon").click(function() {
       $(this).next(".hideprise").first().toggle();
       if($(this).attr("data")=="on"){
           $(this).next().siblings("tbody.hideprise").first().toggle();
       }
    });*/
    $(".hideline").click( function(){
       $('.toggleon').toggle();
       $('.hiddable').toggle();
       $('.hideprise').toggle();
    });
});
</script>    
<div class="row-fluid">
<form name="forme" id="forme" method="GET" action="{{path("synthese_index")}}">
    <legend>Filtres</legend>
    <fieldset class="form_block form_fieldset_NONE">
      {{form_widget(formulaire)}}
    </fieldset>
    <div class="form-actions">
        <input type="submit" name="lance" value="Filtrer" class="btn btn-small btn-primary">
    </div>
</form>
        <div class="well pull-right" id="menuprint"><a href="#" class="btn hideline">Afficher Total Stagiaires <i class="icon-zoom-in"></i></a> <a href="{{filename}}" class="btn">Exporter en excel <i class="icon-file"></i></a> <a href="#" onclick="print();" class="btn">Imprimer la synthèse <i class="icon-print"></i></a> </div>
</div>                                 
    <div class="row-fluid">
    <div class="span12">
          <table class="table table-condensed table-hover table-striped" border="1">
{% set totalgencsp=0 %}
{% set totalgencse=0 %}                                
{% set totalgendip=0 %} 
{% set totalgendie=0 %}
{% set stagcsgen=0 %}             
{% set totalgenstag=0 %}
                  
{% for c in centres %}
                  
    {% set totalcencsp=0 %}
    {% set totalcencse=0 %}                                
    {% set totalcendip=0 %} 
    {% set totalcendie=0 %}
    {% set stagcscen=0 %}
    {% set totalcenstag=0 %}
   
    {% if (ctrsolde|length>0) and (ctrsolde[c.id]==1) %}
    {% else %}
                  
     {% for g in c.idGroupes %}
                  
               {% set stagcsgr=0 %}   
               {% set stagcs=0 %}
               {% set totalgrcsp=0 %}
               {% set totalgrcse=0 %}                                
               {% set totalgrdip=0 %} 
               {% set totalgrdie=0 %}
               {% set totalgrstag=0 %}
                  
         {% if (g.idStagiaires|length<1) or ((grsolde|length>0) and (grsolde[g.id]==1)) %}
         {% else %}
                  
            <thead class="headcentre">
                <tr>
                    <th colspan="10">
                        <div class="well well-small" style="margin-top: 15px;">
                            <div class="span2"><strong>Centre</strong> : {{ c.lib}}</div>
                            <div class="span8"><strong>Groupe</strong> : {{ g.lib }} - Date début : {{ g.datedebut|date("d/m/Y") }} - Date de fin : {{ g.datefin|date("d/m/Y") }}</div>
                            <div class="span2"></div>
                        </div>
                    </th>
                </tr>
            </thead>
            {% for s in g.idStagiaires %}
            {% set stagcs=s.cs %}
            {# Affichage pour les soldes négatifs #}
            
            {% if solde|length > 0 %}
                {% if solde[s.id] < 0 %}
                        <thead class="headuser"> 
                            <tr class="info" onclick="window.open('{{ path("alldevs_IfocopBundle_Groupes_edit", { 'pk': g.id }) }}','groupes')" style="cursor:pointer" >
                                <th colspan="4" style="border-top:1px solid #000">{{s.nom}} {{s.prenom}}</th>
                                <th  style="text-align: right;border-top:1px solid #000">CS : {{s.cs|number_format(2, ',', ' ')}}</th>
                                <th style="text-align: right;border-top:1px solid #000" colspan="2"></th>
                                <th style="text-align: right;border-top:1px solid #000" colspan="2">DI dû : {{s.di|number_format(2, ',', ' ')}}</th>
                                <th style="text-align: right;border-top:1px solid #000">{{(s.cs+s.di)|number_format(2, ',', ' ')}}</th>
                            </tr>
                            <tr class="info">
                                <th colspan="10" style="border-top:1px solid #000">Remarque(s) : {{s.observation}}</th>
                            </tr>
                        </thead>
                        {% if s.idPrises|length<1 %}
                        {% else %}
                        <thead class="toggleon" data="on">
                            <tr>
                                <th colspan='10'>Les prises en charges</th>
                            </tr>
                        </thead>
                        <thead class="toggleon">
                            <tr class="list_thead">
                                <th class="actions">Date</th>
                                <th colspan=2">Nom de l'organisme</th>
                                <th colspan="3"></th>
                                <th colspan="2" style="text-align: right;">Montant</th>
                                <th style="text-align: right;" colspan="2"></th>
                                <th class="actions " style="text-align: right;"></th>
                          </tr>
                        </thead>
                        <tbody class="hideprise">
                        {% for p in s.idPrises %}                            
                            <tr onclick="window.open('{{ path("alldevs_IfocopBundle_PrisesStandalone_edit", { 'pk': p.id }) }}','prises')" style="cursor:pointer">
                                <td class="actions">{{p.dateprise|date("d/m/Y")}}</td>
                                <td colspan="2">{{p.idOrganismes.lib}}</td>
                                <td colspan="3"></td>
                                <td colspan="2" style="text-align: right;">{{p.montant|number_format(2, ',', ' ')}}</td>
                                <td style="text-align: right;" colspan="2"></td>
                                <td class="actions " style="text-align: right;"></td>
                            </tr>
                            
                         {% endfor %}
                            
                        </tbody>
                        
                        {% endif %}
                             {% set totalcsp=0 %}
                             {% set totalcse=0 %}                                
                             {% set totaldip=0 %} 
                             {% set totaldie=0 %}
                             {% set totalstag=0 %}
                        
                        {% if s.idReglement|length<1 %}
                        {% else %}
                        
                        <thead>
                            <tr>
                                <th colspan='10'>Les règlements</th>
                            </tr>
                        </thead>
                        <thead class="toggleon">
                            <tr class="list_thead">
                                <th class="actions">Date</th>
                                <th >Nom du payeur</th>
                                <th >Date de remise</th>
                                <th >Type de règlement</th>
                                <th >Prise en Charge</th>
                                <th style="text-align: right;">CS prévu</th>
                                <th style="text-align: right;">Encaissé</th>                                
                                <th style="text-align: right;">DI prévu</th>
                                <th style="text-align: right;">Encaissé</th>                                
                                <th class="actions " style="text-align: right;">Total dû</th>
                          </tr>
                        </thead>
                        <tbody class="hiddable">    
                             {% for r in s.idReglement %} 
                           {% if (is_granted('ROLE_CENTRE')) %}
                                {% if (((r.idModalite.lib=="Représentation chèque") or (r.idModalite.lib=="Chèque") and (r.validation==1)) or (r.idModalite.lib=="Virement organisme") or (r.idModalite.lib=="Virement") or (r.idModalite.lib=="Mandat Cash") or (r.idModalite.lib=="Régularisation") or (r.idModalite.lib=="Régularisation négative") or (r.idModalite.lib=="Chèque impayé") ) %}
                                 <tr>                                    
                                {% else %}
                                 <tr  onclick="window.open('{{ path("alldevs_IfocopBundle_Reglement_edit", { 'pk': r.id }) }}','reglement')" style="cursor:pointer">
                                {% endif %}
                           {% else %}
                                 <tr  onclick="window.open('{{ path("alldevs_IfocopBundle_Reglement_edit", { 'pk': r.id }) }}','reglement')" style="cursor:pointer">
                           {% endif %}
                                <td class="td_datetime td_date">{% if(r.idModalite.lib=="Représentation chèque") or (r.idModalite.lib=="Chèque") %} {% if(r.dateremise!=NULL)%} {{r.dateremise|date("d/m/Y")}} {% endif %} {% endif %}</td>
                                <td class="td_string td_stagiaire">{{r.idPrises?r.idPrises.idOrganismes.lib:(r.idStagiaires.nom~" "~r.idStagiaires.prenom)}}</td>
                                <td class="td_datetime td_date">{{r.dateremise|date("d/m/Y")}}</td>
                                <td class="td_integer td_typereglement">{{r.idModalite.lib}} {% if(r.idModalite.lib=="Représentation chèque") or (r.idModalite.lib=="Chèque") %} - {{r.numcheque}} {% endif %}</td>
                                <td class="td_bool td_prise">{{r.idPrises?"Oui":"NON"}}</td>
                             {% if r.typecompte==3 %}
                                {% set totalcsp=totalcsp+(((r.idModalite.lib=="Remboursement") or (r.idModalite.lib=="Régularisation négative") or (r.idModalite.lib=="Chèque impayé"))?-1*r.rmbcs:r.rmbcs) %}
                                {% set totalcse=totalcse+(r.validation==1?(((r.idModalite.lib=="Remboursement") or (r.idModalite.lib=="Régularisation négative") or (r.idModalite.lib=="Chèque impayé"))?-1*r.rmbcs:r.rmbcs):0) %}                                
                                <td class="td_bool td_validation" style="text-align: right;">{{((r.idModalite.lib=="Remboursement") or (r.idModalite.lib=="Régularisation négative") or (r.idModalite.lib=="Chèque impayé")?'<span class="badge badge-important">'~(-1*r.rmbcs)|number_format(2, ',', ' ')~'</span>':r.rmbcs|number_format(2, ',', ' '))|raw}}</td>
                                <td class="td_float td_credit" style="text-align: right;">{{(r.validation==1?((r.idModalite.lib=="Remboursement") or (r.idModalite.lib=="Régularisation négative") or (r.idModalite.lib=="Chèque impayé"))?'<span class="badge badge-important">'~(-1*r.rmbcs)|number_format(2, ',', ' ')~'</span>':r.rmbcs|number_format(2, ',', ' '):'')|raw}}</td>
                             {% else %}
                                {% set totalcsp=totalcsp+(r.typecompte==1?(((r.idModalite.lib=="Remboursement") or (r.idModalite.lib=="Régularisation négative") or (r.idModalite.lib=="Chèque impayé"))?-1*r.montant:r.montant):0) %}
                                {% set totalcse=totalcse+(r.typecompte==1 and r.validation==1?(((r.idModalite.lib=="Remboursement") or (r.idModalite.lib=="Régularisation négative") or (r.idModalite.lib=="Chèque impayé"))?-1*r.montant:r.montant):0) %}                                
                                <td class="td_bool td_validation" style="text-align: right;">{{(r.typecompte==1?((r.idModalite.lib=="Remboursement") or (r.idModalite.lib=="Régularisation négative") or (r.idModalite.lib=="Chèque impayé"))?'<span class="badge badge-important">'~(-1*r.montant)|number_format(2, ',', ' ')~'</span>':r.montant|number_format(2, ',', ' '):'')|raw}}</td>
                                <td class="td_float td_credit" style="text-align: right;">{{(r.typecompte==1 and r.validation==1?((r.idModalite.lib=="Remboursement") or (r.idModalite.lib=="Régularisation négative") or (r.idModalite.lib=="Chèque impayé"))?'<span class="badge badge-important">'~(-1*r.montant)|number_format(2, ',', ' ')~'</span>':r.montant|number_format(2, ',', ' '):'')|raw}}</td>
                             {% endif %}
                             {% if r.typecompte==3 %}   
                                {% set totaldip=totaldip+(((r.idModalite.lib=="Remboursement") or (r.idModalite.lib=="Régularisation négative") or (r.idModalite.lib=="Chèque impayé"))?-1*r.rmbdi:r.rmbdi) %}
                                {% set totaldie=totaldie+(r.validation==1?(((r.idModalite.lib=="Remboursement") or (r.idModalite.lib=="Régularisation négative") or (r.idModalite.lib=="Chèque impayé"))?-1*r.rmbdi:r.rmbdi):0) %}                                
                                <td class="td_bool td_validation" style="text-align: right;">{{((r.idModalite.lib=="Remboursement") or (r.idModalite.lib=="Régularisation négative") or (r.idModalite.lib=="Chèque impayé")?'<span class="badge badge-important">'~(-1*r.rmbdi)|number_format(2, ',', ' ')~'</span>':r.rmbdi|number_format(2, ',', ' '))|raw}}</td>
                                <td class="td_float td_credit" style="text-align: right;">{{(r.validation==1?((r.idModalite.lib=="Remboursement") or (r.idModalite.lib=="Régularisation négative") or (r.idModalite.lib=="Chèque impayé"))?'<span class="badge badge-important">'~(-1*r.rmbdi)|number_format(2, ',', ' ')~'</span>':r.rmbdi|number_format(2, ',', ' '):'')|raw}}</td>
                             {% else %}
                                {% set totaldip=totaldip+(r.typecompte==2?(((r.idModalite.lib=="Remboursement") or (r.idModalite.lib=="Régularisation négative") or (r.idModalite.lib=="Chèque impayé"))?-1*r.montant:r.montant):0) %} 
                                {% set totaldie=totaldie+(r.typecompte==2 and r.validation==1?(((r.idModalite.lib=="Remboursement") or (r.idModalite.lib=="Régularisation négative") or (r.idModalite.lib=="Chèque impayé"))?-1*r.montant:r.montant):0) %} 
                                <td class="actions td_float td_solde" style="text-align: right;">{{(r.typecompte==2?((r.idModalite.lib=="Remboursement") or (r.idModalite.lib=="Régularisation négative") or (r.idModalite.lib=="Chèque impayé"))?'<span class="badge badge-important">'~(-1*r.montant)|number_format(2, ',', ' ')~'</span>':r.montant|number_format(2, ',', ' '):'')|raw}}</td>
                                <td class="actions td_float td_solde" style="text-align: right;">{{(r.typecompte==2 and r.validation==1?((r.idModalite.lib=="Remboursement") or (r.idModalite.lib=="Régularisation négative") or (r.idModalite.lib=="Chèque impayé"))?'<span class="badge badge-important">'~(-1*r.montant)|number_format(2, ',', ' ')~'</span>':r.montant|number_format(2, ',', ' '):'')|raw}}</td>
                             {% endif %}   
                                <td class="actions td_float td_solde" style="text-align: right;"></td>
                            </tr>
                              {% endfor %}
                          </tbody>{% endif %}
                                    {% set totalstag=totalstag+((s.cs-totalcse)+(s.di-totaldie)) %}
                          <tbody class="hiddable">
                              <tr class="warning break">
                                <td class="td_string td_lib"  colspan="5" style="border-top:1px solid gray;">Total STAGIAIRES {{s.nom}} {{s.prenom}}</td>
                                <td style="text-align: right;border-top:1px solid gray"><strong>{{totalcsp|number_format(2, ',', ' ')}}</strong></td>
                                <td style="text-align: right;border-top:1px solid gray"><strong>{{totalcse|number_format(2, ',', ' ')}}</strong></td>
                                <td class="actions " style="text-align: right;border-top:1px solid gray"><strong>{{totaldip|number_format(2, ',', ' ')}}</strong></td>
                                <td class="actions " style="text-align: right;border-top:1px solid gray"><strong>{{totaldie|number_format(2, ',', ' ')}}</strong></td>
                                {% if (totalstag>-0.004) and (totalstag<0.004) %}
                                {% set totalstag=0 %}
                                {% endif %}
                                <td class="actions " style="text-align: right;border-top:1px solid gray"><span class="badge {{(totalstag<0)?"badge-important":((totalstag==0)?"badge-success":"badge-warning")}} right">{{totalstag|number_format(2, ',', ' ')}}</span></td>
                              </tr>
                          </tbody>
                                    
                                    {% set totalgrcsp=totalgrcsp+totalcsp %}
                                    {% set totalgrcse=totalgrcse+totalcse %}                                
                                    {% set totalgrdip=totalgrdip+totaldip %} 
                                    {% set totalgrdie=totalgrdie+totaldie %}
                                    {% set stagcsgr=stagcsgr+stagcs %}
                                    {% set totalgrstag=totalgrstag+totalstag %}
                                    
                          <tbody>
                              <tr>
                                  <td style="height: 20px;" colspan="10"></td>
                              </tr>
                          </tbody>
                          {% endif %}
                 {% else %}
          {# Affichage pour les soldes négatifs #}
                        <thead class="headuser">
                            <tr class="info" onclick="window.open('{{ path("alldevs_IfocopBundle_Groupes_edit", { 'pk': g.id }) }}','groupes')" style="cursor:pointer" >
                                <th colspan="4" style="border-top:1px solid #000">{{s.nom}} {{s.prenom}}</th>
                                <th  style="text-align: right;border-top:1px solid #000">CS : {{s.cs|number_format(2, ',', ' ')}}</th>
                                <th style="text-align: right;border-top:1px solid #000" colspan="2"></th>
                                <th style="text-align: right;border-top:1px solid #000" colspan="2">DI dû : {{s.di|number_format(2, ',', ' ')}}</th>
                                <th style="text-align: right;border-top:1px solid #000">{{(s.cs+s.di)|number_format(2, ',', ' ')}}</th>
                            </tr>
                            <tr class="info">
                                <th colspan="10" style="border-top:1px solid #000">Remarque(s) : {{s.observation}}</th>
                            </tr>
                        </thead>
                        
                        {% if s.idPrises|length<1 %}
                        {% else %}
                        
                        <thead class="toggleon" data="on">
                            <tr>
                                <th colspan='10'>Les prises en charges</th>
                            </tr>
                        </thead>
                        <thead class="toggleon">
                            <tr class="list_thead">
                                <th class="actions">Date</th>
                                <th colspan="2">Nom de l'organisme</th>
                                <th colspan="3"></th>
                                <th colspan="2" style="text-align: right;">Montant</th>
                                <th style="text-align: right;" colspan="2"></th>
                                <th class="actions " style="text-align: right;"></th>
                          </tr>
                        </thead>
                        <tbody class="hideprise">
                        {% for p in s.idPrises %}                            
                            <tr onclick="window.open('{{ path("alldevs_IfocopBundle_PrisesStandalone_edit", { 'pk': p.id }) }}','prises')" style="cursor:pointer">
                                <td class="actions">{{p.dateprise|date("d/m/Y")}}</td>
                                <td colspan="2">{{p.idOrganismes.lib}}</td>
                                <td colspan="3"></td>
                                <td colspan="2" style="text-align: right;">{{p.montant|number_format(2, ',', ' ')}}</td>
                                <td style="text-align: right;" colspan="2"></td>
                                <td class="actions " style="text-align: right;"></td>
                            </tr>
                            
                         {% endfor %}
                            
                        </tbody>
                        
                        {% endif %}
                             {% set totalcsp=0 %}
                             {% set totalcse=0 %}                                
                             {% set totaldip=0 %} 
                             {% set totaldie=0 %}
                             {% set totalstag=0 %}
                        
                        {% if s.idReglement|length<1 %}
                        {% else %}
                        
                        <thead class="toggleon">
                            <tr>
                                <th colspan='10'>Les règlements</th>
                            </tr>
                        </thead>
                        <thead class="toggleon">
                            <tr class="list_thead">
                                <th class="actions">Date</th>
                                <th >Nom du payeur</th>
                                <th class="actions">Date de remise</th>
                                <th >Type de règlement</th>
                                <th >Prise en Charge</th>
                                <th style="text-align: right;">CS prévu</th>
                                <th style="text-align: right;">Encaissé</th>                                
                                <th style="text-align: right;">DI prévu</th>
                                <th style="text-align: right;">Encaissé</th>                                
                                <th class="actions " style="text-align: right;">Total dû</th>
                          </tr>
                        </thead>
                        <tbody class="hiddable">    
                             {% for r in s.idReglement %} 
                           {% if (is_granted('ROLE_CENTRE')) %}
                                {% if (((r.idModalite.lib=="Représentation chèque") or (r.idModalite.lib=="Chèque") and (r.validation==1)) or (r.idModalite.lib=="Virement organisme") or (r.idModalite.lib=="Virement") or (r.idModalite.lib=="Mandat Cash") or (r.idModalite.lib=="Régularisation") or (r.idModalite.lib=="Régularisation négative") or (r.idModalite.lib=="Chèque impayé") ) %}
                                 <tr>                                    
                                {% else %}
                                 <tr  onclick="window.open('{{ path("alldevs_IfocopBundle_Reglement_edit", { 'pk': r.id }) }}','reglement')" style="cursor:pointer">
                                {% endif %}
                           {% else %}
                                 <tr  onclick="window.open('{{ path("alldevs_IfocopBundle_Reglement_edit", { 'pk': r.id }) }}','reglement')" style="cursor:pointer">
                           {% endif %}
                                <td class="td_datetime td_date">{{r.datereception|date("d/m/Y")}}</td>
                                <td class="td_string td_stagiaire">{{r.idPrises?r.idPrises.idOrganismes.lib:(r.idStagiaires.nom~" "~r.idStagiaires.prenom)}}</td>
                                <td class="td_datetime td_date">{% if(r.idModalite.lib=="Représentation chèque") or (r.idModalite.lib=="Chèque") %} {% if(r.dateremise!=NULL)%} {{r.dateremise|date("d/m/Y")}} {% endif %}{% endif %}</td>
                                <td class="td_integer td_typereglement">{{r.idModalite.lib}}  {% if(r.idModalite.lib=="Représentation chèque") or (r.idModalite.lib=="Chèque") %} - {{r.numcheque}} {% endif %}</td>
                                <td class="td_bool td_prise">{{r.idPrises?"Oui":"NON"}}</td>
                             {% if r.typecompte==3 %}
                                {% set totalcsp=totalcsp+(((r.idModalite.lib=="Remboursement") or (r.idModalite.lib=="Régularisation négative") or (r.idModalite.lib=="Chèque impayé"))?(-1*r.rmbcs):r.rmbcs|raw) %}
                                {% set totalcse=totalcse+(r.validation==1?(((r.idModalite.lib=="Remboursement") or (r.idModalite.lib=="Régularisation négative") or (r.idModalite.lib=="Chèque impayé"))?(-1*r.rmbcs):r.rmbcs|raw):0) %}                                
                                <td class="td_bool td_validation" style="text-align: right;">{{((r.idModalite.lib=="Remboursement") or (r.idModalite.lib=="Régularisation négative") or (r.idModalite.lib=="Chèque impayé")?'<span class="badge badge-important">'~(-1*r.rmbcs)|number_format(2, ',', ' ')~'</span>':r.rmbcs|number_format(2, ',', ' '))|raw}}</td>
                                <td class="td_float td_credit" style="text-align: right;">{{(r.validation==1?((r.idModalite.lib=="Remboursement") or (r.idModalite.lib=="Régularisation négative") or (r.idModalite.lib=="Chèque impayé"))?'<span class="badge badge-important">'~(-1*r.rmbcs)|number_format(2, ',', ' ')~'</span>':r.rmbcs|number_format(2, ',', ' '):'')|raw}}</td>
                             {% else %}
                                {% set totalcsp=totalcsp+(r.typecompte==1?(((r.idModalite.lib=="Remboursement") or (r.idModalite.lib=="Régularisation négative") or (r.idModalite.lib=="Chèque impayé"))?-1*r.montant:r.montant):0) %}
                                {% set totalcse=totalcse+(r.typecompte==1 and r.validation==1?(((r.idModalite.lib=="Remboursement") or (r.idModalite.lib=="Régularisation négative") or (r.idModalite.lib=="Chèque impayé"))?-1*r.montant:r.montant):0) %}                                
                                <td class="td_bool td_validation" style="text-align: right;">{{(r.typecompte==1?((r.idModalite.lib=="Remboursement") or (r.idModalite.lib=="Régularisation négative") or (r.idModalite.lib=="Chèque impayé"))?'<span class="badge badge-important">'~(-1*r.montant)|number_format(2, ',', ' ')~'</span>':r.montant|number_format(2, ',', ' '):'')|raw}}</td>
                                <td class="td_float td_credit" style="text-align: right;">{{(r.typecompte==1 and r.validation==1?((r.idModalite.lib=="Remboursement") or (r.idModalite.lib=="Régularisation négative") or (r.idModalite.lib=="Chèque impayé"))?'<span class="badge badge-important">'~(-1*r.montant)|number_format(2, ',', ' ')~'</span>':r.montant|number_format(2, ',', ' '):'')|raw}}</td>
                             {% endif %}
                             {% if r.typecompte==3 %}  
                                {% set totaldip=totaldip+(((r.idModalite.lib=="Remboursement") or (r.idModalite.lib=="Régularisation négative") or (r.idModalite.lib=="Chèque impayé"))?(-1*r.rmbdi):r.rmbdi|raw) %}
                                {% set totaldie=totaldie+(r.validation==1?(((r.idModalite.lib=="Remboursement") or (r.idModalite.lib=="Régularisation négative") or (r.idModalite.lib=="Chèque impayé"))?(-1*r.rmbdi):r.rmbdi|raw):0) %}                                
                                <td class="td_bool td_validation" style="text-align: right;">{{((r.idModalite.lib=="Remboursement") or (r.idModalite.lib=="Régularisation négative") or (r.idModalite.lib=="Chèque impayé")?'<span class="badge badge-important">'~(-1*r.rmbdi)|number_format(2, ',', ' ')~'</span>':r.rmbdi|number_format(2, ',', ' '))|raw}}</td>
                                <td class="td_float td_credit" style="text-align: right;">{{(r.validation==1?((r.idModalite.lib=="Remboursement") or (r.idModalite.lib=="Régularisation négative") or (r.idModalite.lib=="Chèque impayé"))?'<span class="badge badge-important">'~(-1*r.rmbdi)|number_format(2, ',', ' ')~'</span>':r.rmbdi|number_format(2, ',', ' '):'')|raw}}</td>
                             {% else %}
                                {% set totaldip=totaldip+(r.typecompte==2?(((r.idModalite.lib=="Remboursement") or (r.idModalite.lib=="Régularisation négative") or (r.idModalite.lib=="Chèque impayé"))?-1*r.montant:r.montant):0) %} 
                                {% set totaldie=totaldie+(r.typecompte==2 and r.validation==1?(((r.idModalite.lib=="Remboursement") or (r.idModalite.lib=="Régularisation négative") or (r.idModalite.lib=="Chèque impayé"))?-1*r.montant:r.montant):0) %} 
                                <td class="actions td_float td_solde" style="text-align: right;">{{(r.typecompte==2?((r.idModalite.lib=="Remboursement") or (r.idModalite.lib=="Régularisation négative") or (r.idModalite.lib=="Chèque impayé"))?'<span class="badge badge-important">'~(-1*r.montant)|number_format(2, ',', ' ')~'</span>':r.montant|number_format(2, ',', ' '):'')|raw}}</td>
                                <td class="actions td_float td_solde" style="text-align: right;">{{(r.typecompte==2 and r.validation==1?((r.idModalite.lib=="Remboursement") or (r.idModalite.lib=="Régularisation négative") or (r.idModalite.lib=="Chèque impayé"))?'<span class="badge badge-important">'~(-1*r.montant)|number_format(2, ',', ' ')~'</span>':r.montant|number_format(2, ',', ' '):'')|raw}}</td>
                             {% endif %}   
                                <td class="actions td_float td_solde" style="text-align: right;"></td>
                            </tr>
                              {% endfor %}
                          </tbody>{% endif %}
                          
                          {% set totalstag=totalstag+((s.cs-totalcse)+(s.di-totaldie)) %}
                          <tbody class="nohiddable">
                              <tr class="warning break">
                                <td class="td_string td_lib"  colspan="5" style="border-top:1px solid gray;">Total STAGIAIRES {{s.nom}} {{s.prenom}}</td>
                                <td style="text-align: right;border-top:1px solid gray"><strong>{{totalcsp|number_format(2, ',', ' ')}}</strong></td>
                                <td style="text-align: right;border-top:1px solid gray"><strong>{{totalcse|number_format(2, ',', ' ')}}</strong></td>
                                <td class="actions " style="text-align: right;border-top:1px solid gray"><strong>{{totaldip|number_format(2, ',', ' ')}}</strong></td>
                                <td class="actions " style="text-align: right;border-top:1px solid gray"><strong>{{totaldie|number_format(2, ',', ' ')}}</strong></td>
                                {% if (totalstag>-0.004) and (totalstag<0.004) %}
                                {% set totalstag=0 %}
                                {% endif %}
                                <td class="actions " style="text-align: right;border-top:1px solid gray"><span class="badge {{(totalstag<0)?"badge-important":((totalstag==0)?"badge-success":"badge-warning")}} right">{{totalstag|number_format(2, ',', ' ')}}</span></td>
                              </tr>
                          </tbody>
                                    
                                    {% set totalgrcsp=totalgrcsp+totalcsp %}
                                    {% set totalgrcse=totalgrcse+totalcse %}                                
                                    {% set totalgrdip=totalgrdip+totaldip %} 
                                    {% set totalgrdie=totalgrdie+totaldie %}
                                    {% set stagcsgr=stagcsgr+stagcs %}
                                    {% set totalgrstag=totalgrstag+totalstag %}
                                    
                          <tbody>
                              <tr>
                                  <td style="height: 20px;" colspan="9"></td>
                              </tr>
                          </tbody>
          {# Affichage pour les soldes négatifs #}
                {% endif %}
                {% endfor %} 
                                                              
                          <tbody>
                              <tr class="error break" style="">
                                <td class="td_string td_lib"  colspan="4" Style=" font-weight: bold;"> Total Groupes {{ g.lib }}</td>
                                <td style="text-align: right;"><strong>CS Total : {{stagcsgr|number_format(2, ',', ' ')}}</strong></td>
                                <td style="text-align: right;"><strong>{{totalgrcsp|number_format(2, ',', ' ')}}</strong></td>
                                <td style="text-align: right;"><strong>{{totalgrcse|number_format(2, ',', ' ')}}</strong></td>
                                <td class="actions " style="text-align: right;"><strong>{{totalgrdip|number_format(2, ',', ' ')}}</strong></td>
                                <td class="actions " style="text-align: right;"><strong>{{totalgrdie|number_format(2, ',', ' ')}}</strong></td>
                                <td class="actions " style="text-align: right;"><span class="badge {{(totalgrstag<0)?"badge-important":((totalgrstag==0)?"badge-success":"badge-warning")}} right">{{totalgrstag|number_format(2, ',', ' ')}}</span></td>
                              </tr>
                          </tbody>
                          <tbody>
                              <tr>
                                  <td style="height: 20px; border-bottom:1px solid #000" colspan="10"></td>
                              </tr>
                          </tbody>
        {% endif %}
                                    {% set totalcencsp=totalcencsp+totalgrcsp %}
                                    {% set totalcencse=totalcencse+totalgrcse %}                                
                                    {% set totalcendip=totalcendip+totalgrdip %} 
                                    {% set totalcendie=totalcendie+totalgrdie %}
                                    {% set stagcscen=stagcscen+stagcsgr %}
                                    {% set totalcenstag=totalcenstag+totalgrstag %}
    {% endfor %}  
                          <tbody>
                              <tr class="error" style="height: 50px;">
                                <td class="td_string td_lib"  colspan="4" Style="font-size: 16px;font-weight: bold;line-height: 50px;"> Total Centre {{ c.lib }}</td>
                                <td style="font-size: 14px;text-align: right;line-height: 50px;"><strong>{{stagcscen|number_format(2, ',', ' ')}}</strong></td>
                                <td style="font-size: 14px;text-align: right;line-height: 50px;"><strong>{{totalcencsp|number_format(2, ',', ' ')}}</strong></td>
                                <td style="font-size: 14px;text-align: right;line-height: 50px;"><strong>{{totalcencse|number_format(2, ',', ' ')}}</strong></td>
                                <td class="actions " style="font-size: 14px;text-align: right;line-height: 50px;"><strong>{{totalcendip|number_format(2, ',', ' ')}}</strong></td>
                                <td class="actions " style="font-size: 14px;text-align: right;line-height: 50px;"><strong>{{totalcendie|number_format(2, ',', ' ')}}</strong></td>
                                <td class="actions " style="font-size: 14px;text-align: right;line-height: 50px;"><span class="badge {{(totalcenstag<0)?"badge-important":((totalcenstag==0)?"badge-success":"badge-warning")}} right">{{totalcenstag|number_format(2, ',', ' ')}}</span></td>
                              </tr>
                          </tbody>
                          <tbody>
                              <tr>
                                  <td style="height: 20px; border-bottom:2px solid #000" colspan="10"></td>
                              </tr>
                          </tbody>
{% set totalgencsp=totalgencsp+totalcencsp %}
{% set totalgencse=totalgencse+totalcencse %}                                
{% set totalgendip=totalgendip+totalcendip %} 
{% set totalgendie=totalgendie+totalcendie %}
{% set stagcsgen=stagcsgen+stagcscen %}
{% set totalgenstag=totalgenstag+totalcenstag %}
                          {% endif %}
{% endfor %}  
                          {% if centres|length>1 %}
                          <tbody>
                              <tr>
                                  <td style="height: 20px; border-bottom:1px solid #000" colspan="10"></td>
                              </tr>
                          </tbody>
                          <tbody>
                              <tr class="error" style="height: 50px;">
                                <td class="td_string td_lib"  colspan="4" Style="font-size: 16px;font-weight: bold;line-height: 50px;"> Total Général</td>
                                <td style="font-size: 14px;text-align: right;line-height: 50px;"><strong>{{stagcsgen|number_format(2, ',', ' ')}}</strong></td>
                                <td style="font-size: 14px;text-align: right;line-height: 50px;"><strong>{{totalgencsp|number_format(2, ',', ' ')}}</strong></td>
                                <td style="font-size: 14px;text-align: right;line-height: 50px;"><strong>{{totalgencse|number_format(2, ',', ' ')}}</strong></td>
                                <td class="actions " style="font-size: 14px;text-align: right;line-height: 50px;"><strong>{{totalgendip|number_format(2, ',', ' ')}}</strong></td>
                                <td class="actions " style="font-size: 14px;text-align: right;line-height: 50px;"><strong>{{totalgendie|number_format(2, ',', ' ')}}</strong></td>
                                <td class="actions " style="font-size: 14px;text-align: right;line-height: 50px;"><span class="badge {{(totalgenstag<0)?"badge-important":((totalgenstag==0)?"badge-success":"badge-warning")}} right">{{totalgenstag|number_format(2, ',', ' ')}}</span></td>
                              </tr>
                          </tbody>
                          <tbody>
                              <tr>
                                  <td style="height: 20px; border-bottom:1px solid #000" colspan="10"></td>
                              </tr>
                          </tbody>              
                          {% endif %}
              </table>
            </div>
        </div>
<div class="well pull-right" id="menuprint"><a href="#" class="btn hideline">Afficher Total Stagiaires <i class="icon-zoom-in"></i></a>  <a href="{{filename}}" class="btn">Exporter en excel <i class="icon-file"></i></a> <a href="#" onclick="print();" class="btn">Imprimer la synthèse <i class="icon-print"></i></a> </div>
{% endblock %}