\n"; generate_html_divs_menu(); ?>
Objet | Organisateur | Date | Etat | Détails | ' . "$objetR | \n"; echo "$prenomP $nomP | \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 '' . date('d/m/Y \à H:i', $idC_Fixe) . " | \n"; echo "Fixée | \n"; break; case 'reunion_en_cours': echo "\n"; echo " | En préparation | \n"; break; case 'reunion_annulee': echo "\n"; echo " | Annulée | \n"; break; } echo ''; generate_html_reunion_detail_button($idR); echo " | \n"; echo " \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 Liste L,Reunion R,Appartenir A,Creneau C,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 Liste L,Reunion R,Appartenir A,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"; ?>
---|