{% extends templateTwigParent %}

{% block titreContenu %}Résultats des épreuves{% endblock %}


{% block contenu%}
</br>
<div class="col-lg-12">
  <div class="card"> 
    <div class="card-header d-flex align-items-center">
    <div class="table-responsive">   
          <table class="table table-striped table-sm">
              <thead>
              <tr>
        {% for p in promos %}
           <td><a href="{{ path('listerResultatsParPromo', { 'idPromo': p.id }) }}">{{ p.annee }} </a></td>
         {% endfor %}
         </tr>
         </thead>
         </table>
         </div>
    </div>
</div> 
</div> 

{% if sisr is defined and slam is defined%}

<!-- TABLEAU DES SISR -->
<div class="col-lg-12">
  <div class="card"> 
    <div class="card-header d-flex align-items-center">
        <h3 class="h4">Etudiants spécialité SISR</h3>
    </div>       
  <div class="card-body">
      <div class="table-responsive">   
          <table class="table table-striped table-sm">
              <thead>
                  <tr>
                      <th>Nom</th>
                      <th>Prénom</th>                     
                      {% for e in epreuves  %}    
                        <th>{{e.libelleCourt}} </th>
                      {% endfor %}
                      <th>NbPoints</th>
                      <th>Moy</th>
                      <th>Admis</th>
                  </tr>
              </thead>
              <tbody>
                     
              {% set notea= '' %}
              {% set nbAdmisSisr = 0 %}
              {% set nbSisr = 0 %}
              {% set nbPointsTotalSisr = 0 %}
  
              {# boucle etudiant sisr #}
              {% for er in sisr  %}    
              <tr>
                  {% set nbSisr = nbSisr + 1 %}
                  {% if is_granted('ROLE_ADMIN') %} {#  on ajoute le lien pour permettre la saisie des étudiants #}
                    <td><a href="{{ path('sasirNotes', {'idEtudiant': er.id }) }}">{{er.nom}}</a></td>
                    <td><a href="{{ path('sasirNotes', {'idEtudiant': er.id }) }}">{{er.prenom}}</a></td>
                  {% else %}
                    <td>{{er.nom}}</td>
                    <td>{{er.prenom}}</td>
                  {% endif %}

                  {% set nbPoints = 0 %}               
                  {% set codeEpreuve = 0 %}
                  {% for e in epreuves  %}
                      {% set codeEpreuve = e.id %}                     
                      {% for noteEpr in er.noteEpreuves %}
                          {% if noteEpr.epreuve.id == e.id %}
                              {% set notea = noteEpr.note %}

                                  {% if e.isoption == 1 and notea >0 %}                           
                                     {% set nbPoints = nbPoints + notea -10  %}                          
                                  {% else %}                                 
                                    {% set nbPoints = nbPoints + notea * (noteEpr.epreuve.coef) %} 
                                   {% endif %}   
                        
                          {% endif %}
                                
                      {% endfor %}                      
                      <td>{{notea}}</td>
                  {% endfor %}
               
                  <td>{{nbPoints}}</td>
                   {% set nbPointsTotalSisr = nbPointsTotalSisr + nbPoints %}
                  <td>{{(nbPoints * 20/440 )|round(2, 'ceil')}}</td>

                  {% if nbPoints >= 220 %}
                    <td>Admis</td>
                    {% set nbAdmisSisr = nbAdmisSisr + 1 %}
                  {% else %}
                    <td>Non admis</td>
                  {% endif %}
              </tr>
              
              {% endfor %} {# fin boucle etudiants sisr#}
              
              {# dernière ligne tableau sisr avec affichage des moyennes  #}
              <tr>
              <th>Moyennes</th><th></th>
              
              {% for moy in moySisr %}
                  <th>
                    {{ moy.note }}
                  </th>
                {% endfor %}
                <th>{{(nbPointsTotalSisr / nbSisr)}}</th>
                <th></th>               
                <th>{{(nbAdmisSisr * 100 / nbSisr)}} %</th>
              </tr>
              </tbody>
          </table>
      </div>
    </div>
  </div>
</div>



<!-- TABLEAU DES SLAM -->
<div class="col-lg-12">
  <div class="card"> 
    <div class="card-header d-flex align-items-center">
        <h3 class="h4">Etudiants spécialité SLAM</h3>
    </div>       
  <div class="card-body">
      <div class="table-responsive">   
          <table class="table table-striped table-sm">
              <thead>
                  <tr>
                      <th>Nom</th>
                      <th>Prénom</th>                        
                      {% for e in epreuves  %}    
                        <th>{{e.libelleCourt}}</th>
                      {% endfor %}
                      <th>Nb Points</th>
                      <th>Moy</th>
                      <th>Admis</th>
                  </tr>
              </thead>
              <tbody>

              {% set nbAdmisSlam = 0 %}
              {% set nbSlam = 0 %}
              {% set nbPointsTotalSlam = 0 %}
              {% for er in slam  %}    
              <tr>
                 {% set nbSlam = nbSlam + 1 %}
                 {% if is_granted('ROLE_ADMIN') %} {#  on ajoute le lien pour permettre la saisie des étudiants #}
                    <td><a href="{{ path('sasirNotes', {'idEtudiant': er.id }) }}">{{er.nom}}</a></td>
                    <td><a href="{{ path('sasirNotes', {'idEtudiant': er.id }) }}">{{er.prenom}}</a></td>
                  {% else %}
                    <td>{{er.nom}}</td>
                    <td>{{er.prenom}}</td>
                  {% endif %}
                  {% set nbPoints = 0 %}
                  {% for e in epreuves  %}
                      {% set notea= '' %}  
                      {% for noteEpr in er.noteEpreuves %}
                          {% if noteEpr.epreuve.id == e.id %}
                              {% set notea = noteEpr.note %}                           
                              {% set nbPoints = nbPoints + notea * (noteEpr.epreuve.coef) %}                                                       
                          {% endif %}       
                      {% endfor %}
                      <td>{{notea}}</td>
                  {% endfor %}
                  <td>{{nbPoints}}</td>
                   {% set nbPointsTotalSlam = nbPointsTotalSlam + nbPoints %}
                  <td>{{(nbPoints * 20/440 )|round(2, 'ceil')}}</td>
                  {% if nbPoints >= 220 %}
                   {% set nbAdmisSlam = nbAdmisSlam + 1 %}
                    <td>Admis</td>
                  {% else %}
                    <td>Non admis</td>
                  {% endif %}
              </tr>
              {% endfor %}

              {# dernière ligne tableau sisr avec affichage des moyennes  #}
              <tr>
              <th>Moyennes</th><th></th>
              
              {% for moy in moySlam %}
                  <th>
                    {{ moy.note }}
                  </th>
                {% endfor %}
                <th>{{(nbPointsTotalSlam / nbSlam)}}</th>
                <th></th>               
                <th>{{(nbAdmisSlam * 100 / nbSlam)}} %</th>
              </tr>

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


<!-- TABLEAU DES MOYENNES  -->
<div class="col-lg-12">
  <div class="card"> 
    <div class="card-header d-flex align-items-center">
        <h3 class="h4">Résultats promo</h3>
    </div>       
  <div class="card-body">
      <div class="table-responsive">   
          <table class="table table-striped table-sm">
              <thead>
                  <tr>
                      <th></th>
                      <th></th>                     
                      {% for e in epreuves  %}    
                        <th>{{e.libelleCourt}} </th>
                      {% endfor %}
                      <th>Nb Points</th>
                      <th>Moy</th>
                      <th>Admis</th>
                  </tr>
              </thead>
              <tbody>    
              
              {#  ligne tableau  avec affichage des moyennes  #}
              <tr>
              <th>Moyennes</th><th></th>
              
              {% for moy in moyPromo %}          
                  <th>
                    {{ moy.note|round(2, 'ceil') }}
                  </th>
                {% endfor %}
                <th>{{((nbPointsTotalSisr +  nbPointsTotalSlam )/ (nbSisr + nbSlam)) |round(2, 'ceil')}}</th>
                <th></th>               
                <th>{{((nbAdmisSisr + nbAdmisSlam) * 100 / ( nbSisr + nbSlam)) |round(2, 'ceil') }} %</th>
              </tr>
              </tbody>
          </table>
      </div>
    </div>
  </div>
</div>




{% endif %}
{% endblock %}