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

diff --git a/php/tx_inscrits.php b/php/tx_inscrits.php
index 89ff6a0..eac8390 100644
--- a/php/tx_inscrits.php
+++ b/php/tx_inscrits.php
@@ -2,33 +2,47 @@
 
 include_once("traitement_pre_affichage.php");
 
-$res = mysql_query("SELECT pseudo, nom, prenom, age, clan_nom, clan_tag, remarques FROM participants ORDER by clan_nom, clan_tag, pseudo");
-
+$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>
-  <th>prénom</th>
-  <th>age</th>
-  <th>remarques</th>
+  <th>prénom</th>';
+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($res))
+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;
-   }
+   }
+   
+   $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 '<td>', traitement_pre_affichage($participant->prenom), '</td>';
-	echo '<td>', traitement_pre_affichage($participant->age), '</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>';
 }