\n"; generate_html_divs_menu(); ?>
Objet | Organisateur | Date | Etat | Détails | ' . "$objetR | \n"; echo "$prenomP $nomP | \n"; $dateStr=''; $stateStr='En préparation'; if ( isset($dateR) ) { $dateStr=date('d/m/Y \à H:i', $dateR); if ( $dateR > time() ) { $stateStr='Fixée'; } else { $stateStr='Passée'; } } echo "$dateStr | \n"; echo "$stateStr | \n"; 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)' . ' 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' . ' 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"; ?>
---|