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

 
 

{% block stylesheets %} 
   {{parent()}}

      <link rel="stylesheet"   href="{{ asset('back/bundles/datatables/datatables.min.css') }}">
      <link rel="stylesheet"   href="{{ asset('back/bundles/datatables/DataTables-1.10.16/css/dataTables.bootstrap4.min.css') }}">
 
 {% endblock %}

{% block body %}
    <div class="main-content">
        <section class="section">
          <div class="section-body">
<form action="{{ path('classement') }}" method="POST" >

    <div class="row">
 
        <div class="col-5 col-sm-5 col-lg-5">
 <select class="form-control" id="mois" name="mois">
                      <option value="">Choisir le mois </option>
                   {% for month in 1..12 %}
    {% set date = month ~ "/1/2021" %}
    <option value="{{ date|date("m") }}">{{ date|date("F") }}</option>
{% endfor %}
 
                      </select>          </div>
        
         <div class="col-5 col-sm-5 col-lg-5">
<select class="form-control" id="annee" name="annee">
        {% for i in "now"|date("Y").."now +3 years"|date("Y") %}
        <option value="{{  ("now +"~(loop.index-1)~" years")|date("Y") }}" >{{  ("now +"~(loop.index-1)~" years")|date("Y") }}</option>
        {% endfor %}
</select>            </div>

      <div class="col-2 col-sm-2 col-lg-2">
         <input name="valide" value="ok" type="hidden"  class="form-control">

          <button type="submit" class="btn btn-info" >RECHERCHER</button>
      </div>

 
    </div>

</form>


            <div class="row">
              <div class="col-12">
                <div class="card">
       
                  <div class="card-body">

                  
 </div>
 
                    <div class="table-responsive">
                      <table class="table table-striped table-hover" id="tableExport" style="width:100%;">
                        <thead>
                          <tr>
           <th>Nom et prenoms</th>
                                        <th>Team</th>
                                        <th>Progress</th>
                                        <th>Date debut</th>
                                        <th>Date fin</th>
                                        <th>Montant obtenue </th>
                                        <th>Objectif </th>
                 
                
                          </tr>
                        </thead>
                        <tbody>
            

                                       {% for user in user %}
                                    {% set refTva  = 0 %}
                                    {% for perfa in perf  %}
                                    {% for perfaa in perfa  %}
                                            {% for commande in perfaa.command.produit if(perfaa.userordancement.id == user.id) %}
                                                {% set refTva = refTva + commande.lproduit.prixunitaire   * commande.quantite   %}
                                            {% endfor %}
                                
                                     
                                    {% endfor %}
                                    {% endfor %}
            <tr>
            
          <td><a href="#">{{ user.nom }} {{ user.prenoms }}    </a></td>
                                            <td class="font-weight-600">CALL CENTER</td>

                                            <td class="align-middle">
                                                <div class="progress" data-height="4" data-toggle="tooltip" title="" data-original-title="{{ ((refTva|trim /notation.montant|trim )*100 )|round(2, 'floor') }}" style="height: 4px;">
                                                    {% if ((refTva|trim /notation.montant|trim )*100 )|round(2, 'floor') < 25 |round(2, 'floor')%}
                                                        <div class="progress-bar bg-danger" role="progressbar" style="width: {{ ((refTva|trim /notation.montant|trim )*100 )|round(2, 'floor') }}%" aria-valuenow="{{ ((refTva|trim /notation.montant|trim )*100 )|round(2, 'floor') }}" aria-valuemin="0" aria-valuemax="100"></div>


                                                    {% endif %}
                                                    {% if ( ((refTva|trim /notation.montant|trim )*100 )|round(2, 'floor') > 25 |round(2, 'floor') ) and  ( ((refTva|trim /notation.montant|trim )*100 )|round(2, 'floor') <75 |round(2, 'floor') ) %}
                                                        <div class="progress-bar bg-orange" role="progressbar" style="width: {{ ((refTva|trim /notation.montant|trim )*100 )|round(2, 'floor') }}%" aria-valuenow="{{ ((refTva|trim /notation.montant|trim )*100 )|round(2, 'floor') }}" aria-valuemin="0" aria-valuemax="100"></div>

                                                    {% endif %}
                                                    {% if ((refTva|trim /notation.montant|trim )*100 )|round(2, 'floor') > 75 |round(2, 'floor')%}
                                                        <div class="progress-bar bg-green" role="progressbar" style="width: {{ ((refTva|trim /notation.montant|trim )*100 )|round(2, 'floor') }}%" aria-valuenow="{{ ((refTva|trim /notation.montant|trim )*100 )|round(2, 'floor') }}" aria-valuemin="0" aria-valuemax="100"></div>


                                                    {% endif %}
                                                </div>

                                            <td>{{ notation.datedebut|date('Y-m-d') }}</td>
                                            <td>{{ notation.datefin|date('Y-m-d') }}</td>
                                            <td>{{ refTva|number_format(0, ',', ' ')|trim }}</td>
                                            <td>{{ notation.montant|number_format(0, ',', ' ')|trim }}</td>          
          
                
            </tr>
        {% else %}
            <tr>
                <td colspan="10">Aucun enregistrement trouvé</td>
            </tr>
        {% endfor %}
        </tbody>


                         
                        </tbody>
                      </table>
                    </div>
                  </div>
                </div>
              </div>
            </div>
          </div>
        </section>
     
      </div>


    
{% endblock %}
{% block javascripts %} 
   {{parent()}}

           <script type="text/javascript" src="{{ asset('back/bundles/datatables/datatables.min.js') }}"></script>  
           <script type="text/javascript" src="{{ asset('back/bundles/datatables/DataTables-1.10.16/js/dataTables.bootstrap4.min.js') }}"></script>  
           <script type="text/javascript" src="{{ asset('back/bundles/datatables/export-tables/dataTables.buttons.min.js') }}"></script> 
           <script type="text/javascript" src="{{ asset('back/bundles/datatables/export-tables/buttons.flash.min.js') }}"></script>  
            <script type="text/javascript" src="{{ asset('back/bundles/datatables/export-tables/jszip.min.js') }}"></script>  
            <script type="text/javascript" src="{{ asset('back/bundles/datatables/export-tables/pdfmake.min.js') }}"></script>  
            <script type="text/javascript" src="{{ asset('back/bundles/datatables/export-tables/vfs_fonts.js') }}"></script> 
            <script type="text/javascript" src="{{ asset('back/bundles/datatables/export-tables/buttons.print.min.js') }}"></script>  
             <script type="text/javascript" src="{{ asset('back/js/page/datatables.js') }}"></script>  

 
 
 {% endblock %}