X-Git-Url: http://git.euphorik.ch/?a=blobdiff_plain;f=php%2Ftx_inscrits.php;h=b394d763b4ad599fd736309b717df6c5f8424b94;hb=7ba28ff47a9cec801736677a79b3bf4d3a5adb03;hp=eac839016a2d1f9bc9426b8c8613c95a409fcaf1;hpb=eb13d74a54796fabaa4034eeb2e803f41c7424ab;p=cl7.git

diff --git a/php/tx_inscrits.php b/php/tx_inscrits.php
index eac8390..b394d76 100644
--- a/php/tx_inscrits.php
+++ b/php/tx_inscrits.php
@@ -1,50 +1,55 @@
-<?php # coding:utf-8
-
-include_once("traitement_pre_affichage.php");
-
+<?php # coding:utf-8
+
+include_once("traitement_pre_affichage.php");
+
 $participants = mysql_query("
    SELECT id, pseudo, nom, prenom, clan_nom, clan_tag, remarques
    FROM participants
    ORDER by clan_nom, clan_tag, pseudo
-");
+");
 
-$periodes = mysql_query("SELECT nom_abrege FROM periodes ORDER BY id");
-$debut_table = '
-<table class="inscrits">
- <tr>
-  <th>pseudo</th>
-  <th>nom</th>
+$periodes = mysql_query("SELECT nom_abrege FROM periodes ORDER BY id");
+$debut_table = '
+ <tr>
+  <th>pseudo</th>
+  <th>nom</th>
   <th>prénom</th>';
+$nb_periode = 0;
 while($periode = mysql_fetch_object($periodes))
-   $debut_table .= '<th>'.$periode->nom_abrege.'</th>';
-$debut_table .= '<th>remarques</th>
- </tr>';
- 
-$clan_courant = null;
-
-while($participant = mysql_fetch_object($participants))
-{  
-   if ($clan_courant !== $participant->clan_nom)
-   {
-      echo ($participant->clan_nom != '' ? '</table><h1>'.traitement_pre_affichage($participant->clan_nom).'</h1>' : ''), $debut_table;
-      $clan_courant = $participant->clan_nom;
+{
+   $debut_table .= '<th>'.$periode->nom_abrege.'</th>';
+   $nb_periode++;
+}
+$debut_table .= '<th>remarques</th>
+ </tr>';
+ 
+$clan_courant = null;
+
+echo '<table class="inscrits">';
+while($participant = mysql_fetch_object($participants))
+{  
+   if ($clan_courant !== $participant->clan_nom)
+   {
+      echo ($participant->clan_nom != '' ? '<tr><td colspan="'. ($nb_periode + 4) .'"><h1>'.traitement_pre_affichage($participant->clan_nom).'</h1></td>' : ''), $debut_table;
+      $clan_courant = $participant->clan_nom;
    }
    
    $participations = mysql_query("
       SELECT periodes.nom, participations.participant_id FROM periodes
       LEFT JOIN participations ON periodes.id = participations.periode_id AND participations.participant_id = ".$participant->id."
       ORDER BY id
-   ");
-   
-   echo '<tr>';
-	echo '<td>', htmlentities($participant->clan_tag, ENT_QUOTES, "UTF-8"), traitement_pre_affichage($participant->pseudo), '</td>';
-	echo '<td>', traitement_pre_affichage($participant->nom), '</td>';
+   ");
+   
+   echo '<tr>';
+	echo '<td>', htmlentities($participant->clan_tag, ENT_QUOTES, "UTF-8"), traitement_pre_affichage($participant->pseudo), '</td>';
+	echo '<td>', traitement_pre_affichage($participant->nom), '</td>';
 	echo '<td>', traitement_pre_affichage($participant->prenom), '</td>';
    while ($participation = mysql_fetch_object($participations))
       echo '<td '.($participation->participant_id == $participant->id ? 'class="participe"' : '').'></td>';
-   
-	echo '<td>', traitement_pre_affichage($participant->remarques), '</td>';
-	echo '</tr>';
-}
-echo '</table>';
-?>
+   
+	echo '<td>', traitement_pre_affichage($participant->remarques), '</td>';
+	echo '</tr>';
+}
+echo '</table>';
+?>
+