function affiche_evenement($id_ev, $afficher_obsolete = "n")
{
global $gepiPath;
global $tab_salle;
global $evenement_sans_lien_mail;
global $evenement_sans_lien_ics;
global $mes_groupes;
/*
global $posDiv_infobulle;
global $tabid_infobulle;
global $unite_div_infobulle;
global $niveau_arbo;
global $pas_de_decalage_infobulle;
global $class_special_infobulle;
*/
global $tabdiv_infobulle;
$retour = "";
if (count($tab_salle) == 0) {
$tab_salle = get_tab_salle_cours();
}
$sql = "SELECT * FROM d_dates_evenements WHERE id_ev='{$id_ev}';";
$res = mysqli_query($GLOBALS["mysqli"], $sql);
if (mysqli_num_rows($res) > 0) {
$lig = mysqli_fetch_object($res);
$tab_u = array();
$sql = "SELECT * FROM d_dates_evenements_utilisateurs WHERE id_ev='{$id_ev}';";
//echo "$sql<br />";
$res_u = mysqli_query($GLOBALS["mysqli"], $sql);
if (mysqli_num_rows($res_u) > 0) {
while ($lig_u = mysqli_fetch_object($res_u)) {
$tab_u[] = $lig_u->statut;
}
}
if (!isset($evenement_sans_lien_mail) || $evenement_sans_lien_mail != "y") {
if (acces_info_dates_evenements()) {
$retour .= "<div style='float:right; width:16px;margin-right:3px;' title=\"Informer les/des destinataires par mail.\"><a href='{$gepiPath}/classes/info_dates_classes.php?id_ev=" . $id_ev . "' target='_blank'><img src='{$gepiPath}/images/icons/mail.png' class='icone16' alt='Mail' /></a></div>";
}
}
if (!isset($evenement_sans_lien_ics) || $evenement_sans_lien_ics != "y") {
$retour .= "<div style='float:right; width:16px;margin-right:3px;' title=\"Exporter au format ical/ics l'événement.\nVous pourrez l'importer dans un agenda type Google, WebCalendar,...\"><a href='{$gepiPath}/lib/ical.php?id_ev=" . $id_ev . "' target='_blank'><img src='{$gepiPath}/images/icons/ical.png' class='icone16' alt='ical' /></a></div>";
}
if ($lig->type == 'autre') {
//$retour.=nl2br($lig->description)."<br />";
$retour .= $lig->texte_avant;
//$retour.="<br />";
$liste_dest = "";
if (in_array("professeur", $tab_u)) {
$liste_dest .= " <img src='{$gepiPath}/images/icons/prof.png' class='icone16' alt='Prof' title=\"Professeurs de la classe.\" />";
}
if (in_array("cpe", $tab_u)) {
$liste_dest .= " <img src='{$gepiPath}/images/icons/cpe.png' class='icone16' alt='Cpe' title=\"CPE de la classe.\" />";
}
if (in_array("scolarite", $tab_u)) {
$liste_dest .= " <img src='{$gepiPath}/images/icons/scolarite.png' class='icone16' alt='Scol' title=\"Comptes scolarité associés à la classe.\" />";
}
if (in_array("responsable", $tab_u)) {
$liste_dest .= " <img src='{$gepiPath}/images/icons/responsable.png' class='icone16' alt='Resp' title=\"Comptes responsables associés à la classe.\" />";
}
if (in_array("eleve", $tab_u)) {
$liste_dest .= " <img src='{$gepiPath}/images/icons/eleve.png' class='icone16' alt='Resp' title=\"Élèves associés à la classe.\" />";
}
//$retour.="<br />";
if ($afficher_obsolete == "y") {
if ($_SESSION['statut'] == 'professeur') {
$sql = "SELECT * FROM d_dates_evenements_classes d, classes c WHERE id_ev='{$id_ev}' AND d.id_classe=c.id AND id_classe IN (SELECT DISTINCT jgc.id_classe FROM j_groupes_classes jgc, j_groupes_professeurs jgp WHERE jgc.id_groupe=jgp.id_groupe AND jgp.login='******'login'] . "') ORDER BY date_evenement, classe;";
} elseif ($_SESSION['statut'] == 'cpe') {
$sql = "SELECT * FROM d_dates_evenements_classes d, classes c WHERE id_ev='{$id_ev}' AND d.id_classe=c.id AND id_classe IN (SELECT DISTINCT jec.id_classe FROM j_eleves_classes jec, j_eleves_cpe jecpe WHERE jec.e_login=jecpe.cpe_login AND jecpe.cpe_login='******'login'] . "') ORDER BY date_evenement, classe;";
} elseif ($_SESSION['statut'] == 'scolarite') {
$sql = "SELECT * FROM d_dates_evenements_classes d, classes c WHERE id_ev='{$id_ev}' AND d.id_classe=c.id AND id_classe IN (SELECT DISTINCT jsc.id_classe FROM j_scol_classes jsc WHERE jsc.login='******'login'] . "') ORDER BY date_evenement, classe;";
} elseif ($_SESSION['statut'] == 'administrateur') {
$sql = "SELECT * FROM d_dates_evenements_classes d, classes c WHERE id_ev='{$id_ev}' AND d.id_classe=c.id ORDER BY date_evenement, classe;";
} elseif ($_SESSION['statut'] == 'responsable') {
$sql = "SELECT DISTINCT * FROM d_dates_evenements_classes d, classes c WHERE id_ev='{$id_ev}' AND d.id_classe=c.id AND id_classe IN (SELECT DISTINCT jec.id_classe FROM resp_pers rp, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tresponsables2 r, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\televes e, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tj_eleves_classes jec \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE rp.login='******'login'] . "' AND \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\trp.pers_id=r.pers_id AND \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tr.ele_id=e.ele_id AND \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\te.login=jec.login AND \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t(r.resp_legal='1' OR r.resp_legal='2' OR r.acces_sp='y')\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t) ORDER BY date_evenement, classe;";
} elseif ($_SESSION['statut'] == 'eleve') {
$sql = "SELECT DISTINCT d.*, c.* FROM d_dates_evenements_classes d, classes c, j_eleves_classes jec WHERE id_ev='{$id_ev}' AND d.id_classe=c.id AND d.id_classe=jec.id_classe AND jec.login='******'login'] . "' ORDER BY date_evenement, classe;";
}
} else {
// 12h après
if ($_SESSION['statut'] == 'professeur') {
$sql = "SELECT * FROM d_dates_evenements_classes d, classes c WHERE id_ev='{$id_ev}' AND d.id_classe=c.id AND date_evenement>='" . strftime("%Y-%m-%d %H:%M:%S", time() - 12 * 3600) . "' AND id_classe IN (SELECT DISTINCT jgc.id_classe FROM j_groupes_classes jgc, j_groupes_professeurs jgp WHERE jgc.id_groupe=jgp.id_groupe AND jgp.login='******'login'] . "') ORDER BY date_evenement, classe;";
} elseif ($_SESSION['statut'] == 'cpe') {
$sql = "SELECT * FROM d_dates_evenements_classes d, classes c WHERE id_ev='{$id_ev}' AND d.id_classe=c.id AND date_evenement>='" . strftime("%Y-%m-%d %H:%M:%S", time() - 12 * 3600) . "' AND id_classe IN (SELECT DISTINCT jec.id_classe FROM j_eleves_classes jec, j_eleves_cpe jecpe WHERE jec.e_login=jecpe.cpe_login AND jecpe.cpe_login='******'login'] . "') ORDER BY date_evenement, classe;";
} elseif ($_SESSION['statut'] == 'scolarite') {
$sql = "SELECT * FROM d_dates_evenements_classes d, classes c WHERE id_ev='{$id_ev}' AND d.id_classe=c.id AND date_evenement>='" . strftime("%Y-%m-%d %H:%M:%S", time() - 12 * 3600) . "' AND id_classe IN (SELECT DISTINCT jsc.id_classe FROM j_scol_classes jsc WHERE jsc.login='******'login'] . "') ORDER BY date_evenement, classe;";
} elseif ($_SESSION['statut'] == 'administrateur') {
$sql = "SELECT * FROM d_dates_evenements_classes d, classes c WHERE id_ev='{$id_ev}' AND d.id_classe=c.id AND date_evenement>='" . strftime("%Y-%m-%d %H:%M:%S", time() - 12 * 3600) . "' ORDER BY date_evenement, classe;";
} elseif ($_SESSION['statut'] == 'responsable') {
$sql = "SELECT DISTINCT * FROM d_dates_evenements_classes d, classes c WHERE id_ev='{$id_ev}' AND d.id_classe=c.id AND date_evenement>='" . strftime("%Y-%m-%d %H:%M:%S", time() - 12 * 3600) . "' AND id_classe IN (SELECT DISTINCT jec.id_classe FROM resp_pers rp, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tresponsables2 r, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\televes e, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tj_eleves_classes jec \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE rp.login='******'login'] . "' AND \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\trp.pers_id=r.pers_id AND \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tr.ele_id=e.ele_id AND \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\te.login=jec.login AND \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t(r.resp_legal='1' OR r.resp_legal='2' OR r.acces_sp='y')\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t) ORDER BY date_evenement, classe;";
} elseif ($_SESSION['statut'] == 'eleve') {
$sql = "SELECT DISTINCT d.*, c.* FROM d_dates_evenements_classes d, classes c, j_eleves_classes jec WHERE id_ev='{$id_ev}' AND d.id_classe=c.id AND d.id_classe=jec.id_classe AND jec.login='******'login'] . "' AND date_evenement>='" . strftime("%Y-%m-%d %H:%M:%S", time() - 12 * 3600) . "' ORDER BY date_evenement, classe;";
}
}
$res2 = mysqli_query($GLOBALS["mysqli"], $sql);
if (mysqli_num_rows($res2) > 0) {
$tab_tableau = array();
$tab_liste_salles = array();
$tab_liste_dates = array();
while ($lig2 = mysqli_fetch_object($res2)) {
if (!in_array($lig2->date_evenement, $tab_liste_dates)) {
$tab_liste_dates[] = $lig2->date_evenement;
}
if (!in_array($lig2->id_salle, $tab_liste_salles)) {
$tab_liste_salles[] = $lig2->id_salle;
}
if (isset($tab_tableau[$lig2->date_evenement][$lig2->id_salle])) {
$tab_tableau[$lig2->date_evenement][$lig2->id_salle] .= ", ";
} else {
$tab_tableau[$lig2->date_evenement][$lig2->id_salle] = "";
}
if ($lig2->date_evenement < strftime("%Y-%m-%d %H:%M:%S")) {
//$tab_tableau[$lig2->date_evenement][$lig2->id_salle].="<span style='color:red'>".$lig2->classe." : ".formate_date($lig2->date_evenement, "y", "court")."</span>";
$tab_tableau[$lig2->date_evenement][$lig2->id_salle] .= "<span style='color:red'>" . $lig2->classe . "</span>";
} else {
//$tab_tableau[$lig2->date_evenement][$lig2->id_salle].=$lig2->classe." : ".formate_date($lig2->date_evenement, "y", "court");
$tab_tableau[$lig2->date_evenement][$lig2->id_salle] .= $lig2->classe;
}
/*
if(($lig2->id_salle>0)&&(isset($tab_salle['indice'][$lig2->id_salle]))) {
$tab_tableau[$lig2->date_evenement][$lig2->id_salle].=" (<em>salle ".$tab_salle['indice'][$lig2->id_salle]['designation_complete']."</em>)";
}
*/
//$retour.="<br />";
}
$retour .= "<table class='boireaus boireaus_alt'>\n\t<tr>\n\t\t<th>{$liste_dest}</th>";
for ($loop = 0; $loop < count($tab_liste_dates); $loop++) {
$retour .= "\n\t\t<th>" . formate_date($tab_liste_dates[$loop], "y2", "court") . "</th>";
}
$retour .= "\n\t</tr>";
for ($loop0 = 0; $loop0 < count($tab_liste_salles); $loop0++) {
if ($tab_liste_salles[$loop0] > 0 && isset($tab_salle['indice'][$tab_liste_salles[$loop0]])) {
$salle_courante = $tab_salle['indice'][$tab_liste_salles[$loop0]]['designation_complete'];
} else {
$salle_courante = "";
}
$retour .= "\n\t<tr>\n\t\t<th>{$salle_courante}</th>";
for ($loop = 0; $loop < count($tab_liste_dates); $loop++) {
$retour .= "\n\t\t<td>";
if (isset($tab_tableau[$tab_liste_dates[$loop]][$tab_liste_salles[$loop0]])) {
$retour .= $tab_tableau[$tab_liste_dates[$loop]][$tab_liste_salles[$loop0]];
}
$retour .= "</td>";
}
$retour .= "\n\t</tr>";
}
$retour .= "\n</table>";
/*
while($lig2=mysqli_fetch_object($res2)) {
if($lig2->date_evenement<strftime("%Y-%m-%d %H:%M:%S")) {
$retour.="<span style='color:red'>".$lig2->classe." : ".formate_date($lig2->date_evenement, "y", "court")."</span>";
}
else {
$retour.=$lig2->classe." : ".formate_date($lig2->date_evenement, "y", "court");
}
if(($lig2->id_salle>0)&&(isset($tab_salle['indice'][$lig2->id_salle]))) {
$retour.=" (<em>salle ".$tab_salle['indice'][$lig2->id_salle]['designation_complete']."</em>)";
}
$retour.="<br />";
}
*/
}
$retour .= $lig->texte_apres;
} elseif ($lig->type == 'conseil_de_classe') {
$texte_infobulle = "<div id='div_action_conseil_de_classe_{$id_ev}'></div>";
$tabdiv_infobulle[] = creer_div_infobulle('div_infobulle_action_conseil_de_classe_' . $id_ev, "Bulletins et conseils de classe", "", $texte_infobulle, "", 40, 0, 'y', 'y', 'n', 'n');
$retour .= "<script type='text/javascript'>\n\tfunction afficher_action_classe_{$id_ev}(id_classe) {\n\t\tnew Ajax.Updater(\$('div_action_conseil_de_classe_{$id_ev}'), '{$gepiPath}/lib/ajax_action.php?mode=actions_conseil_classe&id_classe='+id_classe,{method: 'get'});\n\t\tafficher_div('div_infobulle_action_conseil_de_classe_{$id_ev}', 'y', 10, 10);\n\t}\n</script>";
$tab_classe_pp = array("id_classe");
if ($_SESSION['statut'] == "professeur") {
$tab_classe_pp = get_tab_ele_clas_pp($_SESSION['login']);
}
if (getSettingAOui('active_mod_engagements')) {
if ($_SESSION['statut'] == "scolarite" || $_SESSION['statut'] == "cpe" && getSettingAOui('imprimerConvocationConseilClasseCpe')) {
$retour .= "<div style='float:right;width:16px;margin-right:3px;'><a href=\"{$gepiPath}/mod_engagements/imprimer_documents.php\" title=\"Imprimer les documents pour les délégués\"><img src='{$gepiPath}/images/icons/odt.png' class='icone16' alt='Document' /></a></div>";
}
}
$retour .= $lig->texte_avant;
//$retour.="<br />";
if ($afficher_obsolete == "y") {
if ($_SESSION['statut'] == 'professeur') {
$sql = "SELECT * FROM d_dates_evenements_classes d, classes c WHERE id_ev='{$id_ev}' AND d.id_classe=c.id AND id_classe IN (SELECT DISTINCT jgc.id_classe FROM j_groupes_classes jgc, j_groupes_professeurs jgp WHERE jgc.id_groupe=jgp.id_groupe AND jgp.login='******'login'] . "') ORDER BY date_evenement, classe;";
} elseif ($_SESSION['statut'] == 'cpe') {
$sql = "SELECT * FROM d_dates_evenements_classes d, classes c WHERE id_ev='{$id_ev}' AND d.id_classe=c.id AND id_classe IN (SELECT DISTINCT jec.id_classe FROM j_eleves_classes jec, j_eleves_cpe jecpe WHERE jec.login=jecpe.e_login AND jecpe.cpe_login='******'login'] . "') ORDER BY date_evenement, classe;";
} elseif ($_SESSION['statut'] == 'scolarite') {
$sql = "SELECT * FROM d_dates_evenements_classes d, classes c WHERE id_ev='{$id_ev}' AND d.id_classe=c.id AND id_classe IN (SELECT DISTINCT jsc.id_classe FROM j_scol_classes jsc WHERE jsc.login='******'login'] . "') ORDER BY date_evenement, classe;";
} elseif ($_SESSION['statut'] == 'administrateur') {
$sql = "SELECT * FROM d_dates_evenements_classes d, classes c WHERE id_ev='{$id_ev}' AND d.id_classe=c.id ORDER BY date_evenement, classe;";
} elseif ($_SESSION['statut'] == 'responsable') {
$sql = "SELECT DISTINCT * FROM d_dates_evenements_classes d, classes c WHERE id_ev='{$id_ev}' AND d.id_classe=c.id AND id_classe IN (SELECT DISTINCT jec.id_classe FROM resp_pers rp, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tresponsables2 r, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\televes e, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tj_eleves_classes jec \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE rp.login='******'login'] . "' AND \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\trp.pers_id=r.pers_id AND \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tr.ele_id=e.ele_id AND \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\te.login=jec.login AND \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t(r.resp_legal='1' OR r.resp_legal='2' OR r.acces_sp='y')\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t) ORDER BY date_evenement, classe;";
} elseif ($_SESSION['statut'] == 'eleve') {
$sql = "SELECT DISTINCT d.*, c.* FROM d_dates_evenements_classes d, classes c, j_eleves_classes jec WHERE id_ev='{$id_ev}' AND d.id_classe=c.id AND d.id_classe=jec.id_classe AND jec.login='******'login'] . "' ORDER BY date_evenement, classe;";
}
} else {
// 12h après
if ($_SESSION['statut'] == 'professeur') {
$sql = "SELECT * FROM d_dates_evenements_classes d, classes c WHERE id_ev='{$id_ev}' AND d.id_classe=c.id AND date_evenement>='" . strftime("%Y-%m-%d %H:%M:%S", time() - 12 * 3600) . "' AND id_classe IN (SELECT DISTINCT jgc.id_classe FROM j_groupes_classes jgc, j_groupes_professeurs jgp WHERE jgc.id_groupe=jgp.id_groupe AND jgp.login='******'login'] . "') ORDER BY date_evenement, classe;";
} elseif ($_SESSION['statut'] == 'cpe') {
$sql = "SELECT * FROM d_dates_evenements_classes d, classes c WHERE id_ev='{$id_ev}' AND d.id_classe=c.id AND date_evenement>='" . strftime("%Y-%m-%d %H:%M:%S", time() - 12 * 3600) . "' AND id_classe IN (SELECT DISTINCT jec.id_classe FROM j_eleves_classes jec, j_eleves_cpe jecpe WHERE jec.login=jecpe.e_login AND jecpe.cpe_login='******'login'] . "') ORDER BY date_evenement, classe;";
} elseif ($_SESSION['statut'] == 'scolarite') {
$sql = "SELECT * FROM d_dates_evenements_classes d, classes c WHERE id_ev='{$id_ev}' AND d.id_classe=c.id AND date_evenement>='" . strftime("%Y-%m-%d %H:%M:%S", time() - 12 * 3600) . "' AND id_classe IN (SELECT DISTINCT jsc.id_classe FROM j_scol_classes jsc WHERE jsc.login='******'login'] . "') ORDER BY date_evenement, classe;";
} elseif ($_SESSION['statut'] == 'administrateur') {
$sql = "SELECT * FROM d_dates_evenements_classes d, classes c WHERE id_ev='{$id_ev}' AND d.id_classe=c.id AND date_evenement>='" . strftime("%Y-%m-%d %H:%M:%S", time() - 12 * 3600) . "' ORDER BY date_evenement, classe;";
} elseif ($_SESSION['statut'] == 'responsable') {
$sql = "(SELECT DISTINCT * FROM d_dates_evenements_classes d, classes c WHERE id_ev='{$id_ev}' AND d.id_classe=c.id AND date_evenement>='" . strftime("%Y-%m-%d %H:%M:%S", time() - 12 * 3600) . "' AND id_classe IN (SELECT DISTINCT jec.id_classe FROM resp_pers rp, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tresponsables2 r, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\televes e, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tj_eleves_classes jec \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE rp.login='******'login'] . "' AND \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\trp.pers_id=r.pers_id AND \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tr.ele_id=e.ele_id AND \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\te.login=jec.login AND \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t(r.resp_legal='1' OR r.resp_legal='2' OR r.acces_sp='y')\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t)) ";
if (getSettingAOui('active_mod_engagements')) {
$sql_test = "SELECT eu.valeur AS id_classe FROM engagements e, \n\t\t\t\t\t\t\t\t\t\t\tengagements_user eu\n\t\t\t\t\t\t\t\t\t\tWHERE e.id=eu.id_engagement AND \n\t\t\t\t\t\t\t\t\t\t\te.conseil_de_classe='yes' AND \n\t\t\t\t\t\t\t\t\t\t\teu.login='******'login'] . "' AND \n\t\t\t\t\t\t\t\t\t\t\te.type='id_classe' AND \n\t\t\t\t\t\t\t\t\t\t\teu.id_type='id_classe' AND \n\t\t\t\t\t\t\t\t\t\t\teu.valeur NOT IN (SELECT DISTINCT jec.id_classe FROM resp_pers rp, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tresponsables2 r, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\televes e, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tj_eleves_classes jec \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE rp.login='******'login'] . "' AND \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\trp.pers_id=r.pers_id AND \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tr.ele_id=e.ele_id AND \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\te.login=jec.login AND \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t(r.resp_legal='1' OR r.resp_legal='2' OR r.acces_sp='y')\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t);";
//echo "$sql_test<br />";
$res_test = mysqli_query($GLOBALS["mysqli"], $sql_test);
if (mysqli_num_rows($res_test) > 0) {
while ($lig_test = mysqli_fetch_object($res_test)) {
$sql .= " UNION (SELECT DISTINCT * FROM d_dates_evenements_classes d, classes c WHERE id_ev='{$id_ev}' AND d.id_classe=c.id AND date_evenement>='" . strftime("%Y-%m-%d %H:%M:%S", time() - 12 * 3600) . "' AND id_classe='" . $lig_test->id_classe . "')";
}
}
}
$sql .= " ORDER BY date_evenement, classe;";
} elseif ($_SESSION['statut'] == 'eleve') {
$sql = "SELECT DISTINCT d.*, c.* FROM d_dates_evenements_classes d, classes c, j_eleves_classes jec WHERE id_ev='{$id_ev}' AND d.id_classe=c.id AND d.id_classe=jec.id_classe AND jec.login='******'login'] . "' AND date_evenement>='" . strftime("%Y-%m-%d %H:%M:%S", time() - 12 * 3600) . "' ORDER BY date_evenement, classe;";
}
}
// DEBUG:
//$retour.="$sql<br />";
$res2 = mysqli_query($GLOBALS["mysqli"], $sql);
if (mysqli_num_rows($res2) > 0) {
// On va remplir un tableau et repérer les jours et heures.
$tab_jours = array();
$tab_heures = array();
$tab_cellules = array();
while ($lig2 = mysqli_fetch_object($res2)) {
$tmp_jour = get_date_slash_from_mysql_date($lig2->date_evenement, "court");
if (!in_array($tmp_jour, $tab_jours)) {
$tab_jours[] = $tmp_jour;
}
//sort($tab_jours);
$tmp_tab_pp = get_tab_prof_suivi($lig2->id_classe);
//$liste_pp=implode(", ", $tmp_tab_pp);
$liste_pp = "";
for ($loop = 0; $loop < count($tmp_tab_pp); $loop++) {
if ($loop > 0) {
$liste_pp .= "";
}
$liste_pp .= affiche_utilisateur($tmp_tab_pp[$loop], $lig2->id_classe);
}
$tmp_heure = get_heure_2pt_minute_from_mysql_date($lig2->date_evenement);
if (!in_array($tmp_heure, $tab_heures)) {
$tab_heures[] = $tmp_heure;
}
sort($tab_heures);
$indication_salle = "";
if ($lig2->id_salle > 0 && isset($tab_salle['indice'][$lig2->id_salle])) {
$indication_salle = "\nSalle: " . $tab_salle['indice'][$lig2->id_salle]['designation_complete'] . "";
}
/*
if($lig2->date_evenement<strftime("%Y-%m-%d %H:%M:%S")) {
if(!isset($tab_cellules[$tmp_jour][$tmp_heure])) {
$tab_cellules[$tmp_jour][$tmp_heure]="";
}
else {
$tab_cellules[$tmp_jour][$tmp_heure].=" - ";
}
$tab_cellules[$tmp_jour][$tmp_heure].="<span style='color:red' title=\"La date du conseil de classe de $lig2->classe est passée : ".formate_date($lig2->date_evenement, "y")."
".ucfirst(getSettingValue('gepi_prof_suivi'))." : $liste_pp\">".$lig2->classe."</span>";
}
else {
*/
if (!isset($tab_cellules[$tmp_jour][$tmp_heure])) {
$tab_cellules[$tmp_jour][$tmp_heure] = "";
} else {
$tab_cellules[$tmp_jour][$tmp_heure] .= " - ";
}
if ($_SESSION["statut"] == "professeur") {
if (in_array($lig2->id_classe, $tab_classe_pp['id_classe'])) {
if ($lig2->date_evenement < strftime("%Y-%m-%d %H:%M:%S")) {
$tab_cellules[$tmp_jour][$tmp_heure] .= "<span style='color:red' title=\"La date du conseil de classe de {$lig2->classe} est passée : " . formate_date($lig2->date_evenement, "y") . "\n" . ucfirst(retourne_denomination_pp($lig2->id_classe)) . " : " . $liste_pp . $indication_salle . "\n\nCliquer pour saisir/consulter l'avis du conseil de classe,\npour saisir vos notes et appréciations,\npour consulter les graphes, les bulletins,...\">";
$tab_cellules[$tmp_jour][$tmp_heure] .= "<a href='{$gepiPath}/saisie/saisie_avis1.php?id_classe={$lig2->id_classe}' style='color:red' onclick=\"afficher_action_classe_{$id_ev}({$lig2->id_classe});return false;\">";
} else {
$tab_cellules[$tmp_jour][$tmp_heure] .= "<span title=\"Date du conseil de classe de {$lig2->classe} : " . formate_date($lig2->date_evenement, "y") . "\n" . ucfirst(retourne_denomination_pp($lig2->id_classe)) . " : " . $liste_pp . $indication_salle . "\n\nCliquer pour saisir l'avis du conseil de classe,\npour saisir vos notes et appréciations,\npour consulter les graphes, les bulletins,...\">";
$tab_cellules[$tmp_jour][$tmp_heure] .= "<a href='{$gepiPath}/saisie/saisie_avis1.php?id_classe={$lig2->id_classe}' style='color:black' onclick=\"afficher_action_classe_{$id_ev}({$lig2->id_classe});return false;\">";
}
$tab_cellules[$tmp_jour][$tmp_heure] .= $lig2->classe;
$tab_cellules[$tmp_jour][$tmp_heure] .= "</a>";
$tab_cellules[$tmp_jour][$tmp_heure] .= "</span>";
if (getSettingAOui('active_mod_engagements')) {
$tab_cellules[$tmp_jour][$tmp_heure] .= " <a href=\"{$gepiPath}/mod_engagements/imprimer_documents.php\" title=\"Imprimer les documents pour les délégués\"><img src='{$gepiPath}/images/icons/odt.png' class='icone16' alt='Document' /></a>";
}
} else {
$tab_cellules[$tmp_jour][$tmp_heure] .= "<a href='#' style='color:black' onclick=\"afficher_action_classe_{$id_ev}({$lig2->id_classe});return false;\">";
if ($lig2->date_evenement < strftime("%Y-%m-%d %H:%M:%S")) {
$tab_cellules[$tmp_jour][$tmp_heure] .= "<span style='color:red' title=\"La date du conseil de classe de {$lig2->classe} est passée : " . formate_date($lig2->date_evenement, "y") . "\n" . ucfirst(retourne_denomination_pp($lig2->id_classe)) . " : " . $liste_pp . $indication_salle . "\n\nCliquer pour consulter vos notes et appréciations, les graphes, les bulletins,...\">";
} else {
$tab_cellules[$tmp_jour][$tmp_heure] .= "<span title=\"Date du conseil de classe de {$lig2->classe} : " . formate_date($lig2->date_evenement, "y") . "\n" . ucfirst(retourne_denomination_pp($lig2->id_classe)) . " : " . $liste_pp . $indication_salle . "\n\nCliquer pour saisir vos notes et appréciations, consulter les graphes, les bulletins,...\">";
}
// Problème: Un prof peut avoir plusieurs groupes dans une classe
//$tab_cellules[$tmp_jour][$tmp_heure].="<a href='$gepiPath/saisie/saisie_appreciations.php?id_groupe=' style='color:black'>";
$tab_cellules[$tmp_jour][$tmp_heure] .= $lig2->classe;
$tab_cellules[$tmp_jour][$tmp_heure] .= "</span>";
$tab_cellules[$tmp_jour][$tmp_heure] .= "</a>";
}
} elseif ($_SESSION["statut"] == "scolarite") {
if ($lig2->date_evenement < strftime("%Y-%m-%d %H:%M:%S")) {
$tab_cellules[$tmp_jour][$tmp_heure] .= "<span style='color:red' title=\"La date du conseil de classe de {$lig2->classe} est passée : " . formate_date($lig2->date_evenement, "y") . "\n" . ucfirst(retourne_denomination_pp($lig2->id_classe)) . " : " . $liste_pp . $indication_salle . "\n\nCliquer pour saisir/consulter l'avis du conseil de classe,\n pour accéder aux bulletins, aux graphes,...\">";
$tab_cellules[$tmp_jour][$tmp_heure] .= "<a href='{$gepiPath}/saisie/saisie_avis1.php?id_classe={$lig2->id_classe}' style='color:red' onclick=\"afficher_action_classe_{$id_ev}({$lig2->id_classe});return false;\">";
} else {
$tab_cellules[$tmp_jour][$tmp_heure] .= "<span title=\"Date du conseil de classe de {$lig2->classe} : " . formate_date($lig2->date_evenement, "y") . "\n" . ucfirst(retourne_denomination_pp($lig2->id_classe)) . " : " . $liste_pp . $indication_salle . "\n\nCliquer pour saisir l'avis du conseil de classe,\n pour accéder aux bulletins, aux graphes,...\">";
$tab_cellules[$tmp_jour][$tmp_heure] .= "<a href='{$gepiPath}/saisie/saisie_avis1.php?id_classe={$lig2->id_classe}' style='color:black' onclick=\"afficher_action_classe_{$id_ev}({$lig2->id_classe});return false;\">";
}
$tab_cellules[$tmp_jour][$tmp_heure] .= $lig2->classe;
$tab_cellules[$tmp_jour][$tmp_heure] .= "</a>";
$tab_cellules[$tmp_jour][$tmp_heure] .= "</span>";
} elseif ($_SESSION["statut"] == "cpe") {
if ($lig2->date_evenement < strftime("%Y-%m-%d %H:%M:%S")) {
$tab_cellules[$tmp_jour][$tmp_heure] .= "<span style='color:red' title=\"La date du conseil de classe de {$lig2->classe} est passée : " . formate_date($lig2->date_evenement, "y") . "\n" . ucfirst(retourne_denomination_pp($lig2->id_classe)) . " : " . $liste_pp . $indication_salle . "\">";
} else {
$tab_cellules[$tmp_jour][$tmp_heure] .= "<span title=\"Date du conseil de classe de {$lig2->classe} : " . formate_date($lig2->date_evenement, "y") . "\n" . ucfirst(retourne_denomination_pp($lig2->id_classe)) . " : " . $liste_pp . $indication_salle . "\">";
}
$tab_cellules[$tmp_jour][$tmp_heure] .= $lig2->classe;
$tab_cellules[$tmp_jour][$tmp_heure] .= "</span>";
} elseif ($_SESSION["statut"] == "administrateur") {
if ($lig2->date_evenement < strftime("%Y-%m-%d %H:%M:%S")) {
$tab_cellules[$tmp_jour][$tmp_heure] .= "<span style='color:red' title=\"La date du conseil de classe de {$lig2->classe} est passée : " . formate_date($lig2->date_evenement, "y") . "\n" . ucfirst(retourne_denomination_pp($lig2->id_classe)) . " : " . $liste_pp . $indication_salle . "\">";
} else {
$tab_cellules[$tmp_jour][$tmp_heure] .= "<span title=\"Date du conseil de classe de {$lig2->classe} : " . formate_date($lig2->date_evenement, "y") . "\n" . ucfirst(retourne_denomination_pp($lig2->id_classe)) . " : " . $liste_pp . $indication_salle . "\">";
}
$tab_cellules[$tmp_jour][$tmp_heure] .= $lig2->classe;
$tab_cellules[$tmp_jour][$tmp_heure] .= "</span>";
} elseif ($_SESSION["statut"] == "responsable" || $_SESSION["statut"] == "eleve") {
if ($lig2->date_evenement < strftime("%Y-%m-%d %H:%M:%S")) {
$tab_cellules[$tmp_jour][$tmp_heure] .= "<span style='color:red' title=\"La date du conseil de classe de {$lig2->classe} est passée : " . formate_date($lig2->date_evenement, "y") . "\n" . ucfirst(retourne_denomination_pp($lig2->id_classe)) . " : " . $liste_pp . $indication_salle . "\">";
} else {
$tab_cellules[$tmp_jour][$tmp_heure] .= "<span title=\"Date du conseil de classe de {$lig2->classe} : " . formate_date($lig2->date_evenement, "y") . "\n" . ucfirst(retourne_denomination_pp($lig2->id_classe)) . " : " . $liste_pp . $indication_salle . "\">";
}
$tab_cellules[$tmp_jour][$tmp_heure] .= $lig2->classe;
$tab_cellules[$tmp_jour][$tmp_heure] .= "</span>";
if (getSettingAOui('active_mod_engagements') && is_delegue_conseil_classe($_SESSION['login'], $lig2->id_classe)) {
$tab_cellules[$tmp_jour][$tmp_heure] .= " <a href=\"{$gepiPath}/mod_engagements/imprimer_documents.php?id_classe=" . $lig2->id_classe . "&imprimer=liste_eleves\" title=\"Imprimer la liste des élèves pour prendre des notes pendant le conseil de classe\" target='_blank'><img src='{$gepiPath}/images/icons/tableau.png' class='icone16' alt='Document' /></a>";
$tab_cellules[$tmp_jour][$tmp_heure] .= " <a href=\"{$gepiPath}/mod_engagements/imprimer_documents.php?id_classe=" . $lig2->id_classe . "&imprimer=convocation\" title=\"Imprimer la convocation pour le conseil de classe\" target='_blank'><img src='{$gepiPath}/images/icons/saisie.png' class='icone16' alt='Document' /></a>";
}
}
//}
}
$retour .= "<table class='boireaus boireaus_alt' summary='Dates de conseils de classe'>\n\t<thead>\n\t\t<tr>\n\t\t\t<th>";
if (in_array("professeur", $tab_u)) {
$retour .= " <img src='{$gepiPath}/images/icons/prof.png' class='icone16' alt='Prof' title=\"Professeurs de la classe.\" />";
}
if (in_array("cpe", $tab_u)) {
$retour .= " <img src='{$gepiPath}/images/icons/cpe.png' class='icone16' alt='Cpe' title=\"CPE de la classe.\" />";
}
if (in_array("scolarite", $tab_u)) {
$retour .= " <img src='{$gepiPath}/images/icons/scolarite.png' class='icone16' alt='Scol' title=\"Comptes scolarité associés à la classe.\" />";
}
if (in_array("responsable", $tab_u)) {
$retour .= " <img src='{$gepiPath}/images/icons/responsable.png' class='icone16' alt='Resp' title=\"Comptes responsables associés à la classe.\" />";
}
if (in_array("eleve", $tab_u)) {
$retour .= " <img src='{$gepiPath}/images/icons/eleve.png' class='icone16' alt='Resp' title=\"Élèves de la classe.\" />";
}
//$retour.="<br />";
$retour .= "</th>";
for ($j = 0; $j < count($tab_jours); $j++) {
$retour .= "\n\t\t\t<th>" . $tab_jours[$j] . "</th>";
}
$retour .= "\n\t</thead>\n\t<tbody>";
for ($i = 0; $i < count($tab_heures); $i++) {
$retour .= "\n\t\t<tr>\n\t\t\t<th>" . $tab_heures[$i] . "</th>";
for ($j = 0; $j < count($tab_jours); $j++) {
$retour .= "\n\t\t\t<td>";
if (isset($tab_cellules[$tab_jours[$j]][$tab_heures[$i]])) {
$retour .= $tab_cellules[$tab_jours[$j]][$tab_heures[$i]];
}
$retour .= "</td>";
}
$retour .= "\n\t\t</tr>";
}
$retour .= "\n\t</tbody>\n</table>";
}
$retour .= $lig->texte_apres;
}
}
return $retour;
}
die;
}
$id_classe = isset($_POST['id_classe']) ? $_POST['id_classe'] : (isset($_GET['id_classe']) ? $_GET['id_classe'] : NULL);
$tab_engagements = get_tab_engagements();
if (count($tab_engagements['indice']) == 0) {
header("Location: ../accueil.php?msg=Aucun type d engagement n est actuellement défini.");
die;
}
$nb_engagements = count($tab_engagements['indice']);
// Restreindre a ses propres documents
if ($_SESSION['statut'] == 'eleve' || $_SESSION['statut'] == 'responsable') {
if (!isset($id_classe)) {
header("Location: ../accueil.php?msg=Classe non choisie.");
die;
}
if (!is_delegue_conseil_classe($_SESSION['login'], $id_classe)) {
header("Location: ../accueil.php?msg=Accès non autorisé.");
die;
}
include_once '../mod_ooo/lib/tinyButStrong.class.php';
include_once '../mod_ooo/lib/tinyDoc.class.php';
$acad = $gepiSettings['gepiSchoolAcademie'];
$etab_anne_scol = $gepiSettings['gepiSchoolName'];
$etab_nom = $gepiSettings['gepiSchoolName'];
$etab_adr1 = $gepiSettings['gepiSchoolAdress1'];
$etab_adr2 = $gepiSettings['gepiSchoolAdress2'];
$etab_cp = $gepiSettings['gepiSchoolZipCode'];
$etab_ville = $gepiSettings['gepiSchoolCity'];
$etab_tel = $gepiSettings['gepiSchoolTel'];
$etab_fax = $gepiSettings['gepiSchoolFax'];
$etab_email = $gepiSettings['gepiSchoolEmail'];
