<?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();
echo " DEBUG : $errmsg\n";
}
else
{
// On écrit ligne à ligne les personnes et les disponibilités
while ( list($idR, $objetR, $nomP, $prenomP, $idC_Fixe, $estAnnulee) = mysql_fetch_array($result) )
{
$objetR=htmlentities($objetR, ENT_QUOTES);
$nomP=htmlentities($nomP, ENT_QUOTES);
$prenomP=htmlentities($prenomP, ENT_QUOTES);
// 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�union en pr�paration � moi, pas annul�e
$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 P.idP = '$idP'"
. ' AND R.estAnnulee=\'non\' AND R.idL = L.idL AND P.idP = R.idP_Orga AND ISNULL(R.idC_Fixe)'
. ' ORDER BY R.idR ASC;';
fill_array_liste_reunion($query);
//~ echo $query . "\n";
// R�unions fix�es, � moi, pas annul�e
$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 P.idP = '$idP'"
. ' AND R.estAnnulee=\'non\' 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 annul�e � moi
$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 P.idP = '$idP'"
. ' AND R.estAnnulee=\'oui\' AND R.idL = L.idL AND P.idP = R.idP_Orga AND ISNULL(R.idC_Fixe)'
. ' ORDER BY R.idR ASC;';
fill_array_liste_reunion($query);
echo "<tr class=\"empty\"><td></td><td></td><td></td><td></td><td></td></tr>\n";
// R�union en pr�paration pas � moi, pas annul�e
$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 P.idP <> '$idP'"
. ' AND R.estAnnulee=\'non\' AND R.idL = L.idL AND P.idP = R.idP_Orga AND ISNULL(R.idC_Fixe)'
. ' ORDER BY R.idR ASC;';
//~ echo $query . "\n";
fill_array_liste_reunion($query);
// R�unions fix�es, pas � moi, pas annul�e
$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 P.idP <> '$idP'"
. ' AND R.estAnnulee=\'non\' 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 annul�e pas � moi
$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 P.idP <> '$idP'"
. ' AND R.estAnnulee=\'oui\' AND R.idL = L.idL AND P.idP = R.idP_Orga AND ISNULL(R.idC_Fixe)'
. ' ORDER BY R.idR ASC;';
//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>