<?php require('include/ludo/session_verify.inc.php'); require_once('include/ludo/html_elements.inc.php'); generate_html_doctype_and_head("R�unions"); echo "<body>\n"; generate_html_divs_menu(); ?> <div id="sous_menu"> <p class="arbre"> > <a href="index.php">Accueil</a> > <a href="index.php">Réunions</a> > Liste des réunions </p> </div> <?php generate_html_div_help(); ?> <div id="contenu"> <?php $idP= $_SESSION['session_idP']; if ( isset( $_SESSION['session_prenomP'] ) && isset( $_SESSION['session_prenomP'] ) ) { $nom=$_SESSION['session_prenomP'] . ' ' . $_SESSION['session_nomP']; } else { $nom = $_SESSION['loginP']; } echo "Bonjour $nom, nous sommes le " . date('d/m/Y') . ' et il est ' . date('H:i'); //~ echo "<pre>DEBUG : SESSION :\n"; //~ print_r($_SESSION); //~ echo "\nDEBUG : REQUEST :\n"; //~ print_r($_REQUEST); //~ echo "</pre>"; ?> <br/><br/> <a href="details_reunion.php?action=creer_reunion">Organiser une réunion</a> <br/><br/> <table class="listeReunions" summary="Liste des r�unions vous concernant"> <tr> <th>Objet</th> <th>Organisateur</th> <th>Date</th> <th>Etat</th> <th>Détails</th> </tr> <?php // Connexion � la base et s�lection de la database require_once 'include/connect.inc.php'; function fill_array_liste_reunion($query) { if ( ! $result = @mysql_query($query) ) { require_once('fonctions.inc.php'); $errmsg=mysql_generate_errmsg(); } else { // On �crit ligne � ligne les personnes et les disponibilit�s while ( list($idR, $objetR, $nomP, $prenomP, $idC_Fixe, $estAnnulee) = mysql_fetch_array($result) ) { // Boucle sur chaque personne echo " <tr>\n"; echo ' <td><a href="details_reunion.php?idR=' . $idR . '">' . "$objetR</a></td>\n"; echo " <td>$prenomP $nomP</td>\n"; if ( $estAnnulee=='oui' ) { $etat = 'reunion_annulee'; } elseif ( $idC_Fixe!=null) { $etat ='reunion_fixee'; } else { $etat = 'reunion_en_cours'; } $dateStr=''; switch($etat) { case 'reunion_fixee': echo ' <td>' . date('d/m/Y \� H:i', $idC_Fixe) . "</td>\n"; echo " <td class='$etat'>Fix�e</td>\n"; break; case 'reunion_en_cours': echo " <td></td>\n"; echo " <td class='$etat'>En pr�paration</td>\n"; break; case 'reunion_annulee': echo " <td></td>\n"; echo " <td class='$etat'>Annul�e</td>\n"; break; } echo ' <td>'; generate_html_reunion_detail_button($idR); echo "</td>\n"; echo " </tr>\n"; } } } // R�unions fix�es et pass�es $query = 'SELECT DISTINCT R.idR, R.objetR, P.nomP, P.prenomP, UNIX_TIMESTAMP(C.dateHeure), R.estAnnulee' . ' FROM AWOR_Liste L,AWOR_Reunion R,AWOR_Appartenir A,AWOR_Creneau C,AWOR_Personne P' . " WHERE ((A.idP = $idP AND A.idL = L.idL) OR R.idP_Orga = $idP)" . ' AND R.idL = L.idL AND P.idP = R.idP_Orga AND R.idC_Fixe = C.idC' . ' ORDER BY C.dateHeure DESC;'; fill_array_liste_reunion($query); // R�union en pr�paration $query = 'SELECT DISTINCT R.idR, R.objetR, P.nomP, P.prenomP, NULL, R.estAnnulee' . ' FROM AWOR_Liste L,AWOR_Reunion R,AWOR_Appartenir A,AWOR_Personne P' // Creneau C, . " WHERE ((A.idP = $idP AND A.idL = L.idL) OR R.idP_Orga = $idP)" . ' AND R.idL = L.idL AND P.idP = R.idP_Orga AND ISNULL(R.idC_Fixe);'; //echo "DEBUG : $query\n"; fill_array_liste_reunion($query); //$query = //echo "DEBUG : $query\n"; ?> </table> <br/> <a href="details_reunion.php?action=creer_reunion">Organiser une réunion</a> </div> <?php if ( isset ($errmsg) ) { generate_html_div_errmsg($errmsg); } generate_html_div_footer(); ?> <div id="msg"></div> </body> </html>