function info_eleve($ele_login)
{
global $ele_lieu_naissance;
global $active_cahiers_texte;
global $date_ct1, $date_ct2;
global $type_etablissement, $type_etablissement2;
global $acces_eleve, $acces_responsables, $acces_enseignements, $acces_releves, $acces_bulletins, $acces_cdt, $acces_anna;
global $date_debut_disc, $date_fin_disc;
unset($tab_ele);
$tab_ele = array();
// Récup des infos sur l'élève, les responsables, le PP, le CPE,...
$sql = "SELECT * FROM eleves e WHERE e.login='******';";
$res_ele = mysqli_query($GLOBALS["mysqli"], $sql);
$lig_ele = mysqli_fetch_object($res_ele);
$tab_ele['login'] = $ele_login;
$tab_ele['nom'] = $lig_ele->nom;
$tab_ele['prenom'] = $lig_ele->prenom;
$tab_ele['sexe'] = $lig_ele->sexe;
$tab_ele['naissance'] = formate_date($lig_ele->naissance);
$tab_ele['elenoet'] = $lig_ele->elenoet;
$tab_ele['ele_id'] = $lig_ele->ele_id;
$tab_ele['no_gep'] = $lig_ele->no_gep;
$tab_ele['email'] = $lig_ele->email;
$tab_ele['date_sortie'] = $lig_ele->date_sortie;
$tab_ele['code_lieu_naissance'] = $lig_ele->lieu_naissance;
if ($ele_lieu_naissance == "y") {
$tab_ele['lieu_naissance'] = get_commune($tab_ele['code_lieu_naissance'], 1);
} else {
$tab_ele['lieu_naissance'] = "";
}
$tab_ele['mef'] = "";
$tmp_tab = get_tab_mef_from_mef_code($lig_ele->mef_code);
if (isset($tmp_tab['designation_courte'])) {
$tab_ele['mef'] = $tmp_tab['designation_courte'];
}
unset($tmp_tab);
if ($_SESSION['statut'] == "professeur") {
$is_pp = is_pp($_SESSION['login'], "", $ele_login);
}
$AccesDerniereConnexionEle = AccesDerniereConnexionEle($ele_login);
$AccesDerniereConnexionResp = AccesDerniereConnexionResp("", $ele_login);
$sql = "SELECT * FROM utilisateurs WHERE statut='eleve' AND login='******';";
$res_user = mysqli_query($GLOBALS["mysqli"], $sql);
if (mysqli_num_rows($res_user) == 1) {
$lig_user = mysqli_fetch_object($res_user);
$tab_user = array('login', 'show_email', 'etat', 'date_verrouillage', 'niveau_alerte', 'observation_securite', 'auth_mode');
for ($loop = 0; $loop < count($tab_user); $loop++) {
$champ = $tab_user[$loop];
$tab_ele['compte_utilisateur'][$champ] = $lig_user->{$champ};
}
if ($AccesDerniereConnexionEle) {
$tab_ele['compte_utilisateur']['DerniereConnexionEle'] = get_last_connexion($ele_login);
$tab_ele['compte_utilisateur']['DerniereConnexionEle_Echec'] = get_last_connexion($ele_login, "n");
}
}
$tab_ele['prof_liste_email'] = "";
$tab_ele['tab_prof_liste_email'] = array();
/*
$tab_ele['classe']=array();
$sql="SELECT DISTINCT c.*,jec.periode FROM classes c, j_eleves_classes jec WHERE jec.login='******' AND c.id=jec.id_classe ORDER BY jec.periode;";
$res_clas=mysql_query($sql);
if(mysql_num_rows($res_clas)>0) {
$tab_ele['liste_classes']="";
$cpt=0;
while($lig_clas=mysql_fetch_object($res_clas)) {
if($cpt>0) {$tab_ele['liste_classes'].=", ";}
$tab_ele['liste_classes']=$lig_clas->classe;
$tab_ele['classe'][$cpt]['id_classe']=$lig_clas->id;
$tab_ele['classe'][$cpt]['classe']=$lig_clas->classe;
$tab_ele['classe'][$cpt]['nom_complet']=$lig_clas->nom_complet;
$tab_ele['classe'][$cpt]['periode']=$lig_clas->periode;
// Récup infos Prof Principal (prof_suivi)
$sql="SELECT u.* FROM j_eleves_professeurs jep, utilisateurs u WHERE jep.login='******' AND id_classe='".$lig_clas->id."' AND jep.professeur=u.login;";
$res_pp=mysql_query($sql);
//echo "$sql<br />";
if(mysql_num_rows($res_pp)>0) {
$lig_pp=mysql_fetch_object($res_pp);
$tab_ele['classe'][$cpt]['pp']=array();
$tab_ele['classe'][$cpt]['pp']['login']=$lig_pp->login;
$tab_ele['classe'][$cpt]['pp']['nom']=$lig_pp->nom;
$tab_ele['classe'][$cpt]['pp']['prenom']=$lig_pp->prenom;
$tab_ele['classe'][$cpt]['pp']['civilite']=$lig_pp->civilite;
}
$cpt++;
}
}
*/
// Classes
$tab_ele['classe'] = array();
$sql = "SELECT DISTINCT c.* FROM classes c, j_eleves_classes jec WHERE jec.login='******' AND c.id=jec.id_classe ORDER BY jec.periode;";
$res_clas = mysqli_query($GLOBALS["mysqli"], $sql);
if (mysqli_num_rows($res_clas) > 0) {
$tab_ele['liste_classes'] = "";
$cpt = 0;
while ($lig_clas = mysqli_fetch_object($res_clas)) {
if ($cpt > 0) {
$tab_ele['liste_classes'] .= ", ";
}
$tab_ele['liste_classes'] = $lig_clas->classe;
$tab_ele['classe'][$cpt] = array();
$tab_ele['classe'][$cpt]['id_classe'] = $lig_clas->id;
$tab_ele['classe'][$cpt]['classe'] = $lig_clas->classe;
$tab_ele['classe'][$cpt]['nom_complet'] = $lig_clas->nom_complet;
// On devrait mettre $tab_ele['classe'][$cpt]['rn_nomdev'], mais j'ai mis $tab_ele['rn_nomdev']
// C'est imparfait si l'élève n'est pas dans la même classe sur toutes les périodes , mais cela permet de garder le même code pour visu_releve_notes_func.lib.php et la présente page
//$tab_ele['rn_app']=$lig_clas->; // Ca ne correspond pas à un champ dans la table 'classes'
$tab_ele['rn_nomdev'] = $lig_clas->rn_nomdev;
$tab_ele['rn_toutcoefdev'] = $lig_clas->rn_toutcoefdev;
$tab_ele['rn_coefdev_si_diff'] = $lig_clas->rn_coefdev_si_diff;
$tab_ele['rn_datedev'] = $lig_clas->rn_datedev;
$tab_ele['rn_sign_chefetab'] = $lig_clas->rn_sign_chefetab;
$tab_ele['rn_sign_pp'] = $lig_clas->rn_sign_pp;
$tab_ele['rn_sign_resp'] = $lig_clas->rn_sign_resp;
$tab_ele['rn_formule'] = $lig_clas->rn_formule;
$tab_ele['rn_sign_nblig'] = $lig_clas->rn_sign_nblig;
if ($tab_ele['rn_sign_nblig'] == 0) {
$tab_ele['rn_sign_nblig'] = 3;
}
//echo "\$tab_ele['rn_sign_resp']=$lig_clas->rn_sign_resp<br/>";
// Liste des périodes dans la classe
$sql = "SELECT p.* FROM periodes p, j_eleves_classes jec WHERE jec.login='******' AND p.num_periode=jec.periode AND jec.id_classe='" . $lig_clas->id . "' AND p.id_classe=jec.id_classe ORDER BY p.num_periode;";
$res_per = mysqli_query($GLOBALS["mysqli"], $sql);
$cpt2 = 0;
if (mysqli_num_rows($res_per) > 0) {
$tab_ele['classe'][$cpt]['periodes'][$cpt2] = array();
while ($lig_per = mysqli_fetch_object($res_per)) {
$tab_ele['classe'][$cpt]['periodes'][$cpt2]['num_periode'] = $lig_per->num_periode;
$tab_ele['classe'][$cpt]['periodes'][$cpt2]['nom_periode'] = $lig_per->nom_periode;
// On pourrait extraire les relevés de notes et bulletins à ce niveau
$cpt2++;
}
}
// Récup infos Prof Principal (prof_suivi)
$sql = "SELECT u.* FROM j_eleves_professeurs jep, utilisateurs u WHERE jep.login='******' AND id_classe='" . $lig_clas->id . "' AND jep.professeur=u.login;";
$res_pp = mysqli_query($GLOBALS["mysqli"], $sql);
//echo "$sql<br />";
if (mysqli_num_rows($res_pp) > 0) {
$lig_pp = mysqli_fetch_object($res_pp);
$tab_ele['classe'][$cpt]['pp'] = array();
$tab_ele['classe'][$cpt]['pp']['prof_login'] = $lig_pp->login;
$tab_ele['classe'][$cpt]['pp']['nom'] = $lig_pp->nom;
$tab_ele['classe'][$cpt]['pp']['prenom'] = $lig_pp->prenom;
$tab_ele['classe'][$cpt]['pp']['civilite'] = $lig_pp->civilite;
$tab_ele['classe'][$cpt]['pp']['email'] = $lig_pp->email;
$tab_ele['classe'][$cpt]['pp']['civ_nom_prenom'] = $lig_pp->civilite . " " . $lig_pp->nom . " " . mb_substr($lig_pp->prenom, 0, 1) . ".";
}
$cpt++;
}
}
// Périodes
//$sql="SELECT DISTINCT p.*, jec.id_classe, c.classe, c.nom_complet FROM periodes p, j_eleves_classes jec, classes c WHERE jec.login='******' AND p.num_periode=jec.periode AND c.id=jec.id_classe ORDER BY p.num_periode;";
$sql = "SELECT DISTINCT p.*,jec.id_classe, c.classe, c.nom_complet FROM periodes p, j_eleves_classes jec, classes c WHERE jec.login='******' AND p.num_periode=jec.periode AND jec.id_classe=p.id_classe AND c.id=jec.id_classe ORDER BY p.num_periode;";
//echo "$sql<br />";
$res_per = mysqli_query($GLOBALS["mysqli"], $sql);
$cpt = 0;
if (mysqli_num_rows($res_per) > 0) {
if ($acces_releves == 'y' || $acces_enseignements == 'y' || $acces_bulletins == 'y') {
while ($lig_per = mysqli_fetch_object($res_per)) {
$tab_ele['periodes'][$cpt] = array();
$tab_ele['periodes'][$cpt]['num_periode'] = $lig_per->num_periode;
$tab_ele['periodes'][$cpt]['nom_periode'] = $lig_per->nom_periode;
$tab_ele['periodes'][$cpt]['id_classe'] = $lig_per->id_classe;
$tab_ele['periodes'][$cpt]['classe'] = $lig_per->classe;
$tab_ele['periodes'][$cpt]['nom_complet'] = $lig_per->nom_complet;
//echo "\$tab_ele['periodes'][$cpt]['num_periode']=".$tab_ele['periodes'][$cpt]['num_periode']."<br />";
//echo "\$tab_ele['periodes'][$cpt]['id_classe']=".$tab_ele['periodes'][$cpt]['id_classe']."<br />";
// On regarde si on affiche les catégories de matières dans la classe courante de l'élève
$affiche_categories = sql_query1("SELECT display_mat_cat FROM classes WHERE id='" . $lig_per->id_classe . "'");
if ($affiche_categories == "y") {
$affiche_categories = true;
} else {
$affiche_categories = false;
}
$tab_ele['periodes'][$cpt]['affiche_categories'] = $affiche_categories;
if ($affiche_categories) {
$sql = "SELECT DISTINCT g.*,m.nom_complet " . "FROM j_eleves_groupes jeg,\n\t\t\t\t\t\t\tj_groupes_classes jgc,\n\t\t\t\t\t\t\tj_groupes_matieres jgm,\n\t\t\t\t\t\t\tj_matieres_categories_classes jmcc,\n\t\t\t\t\t\t\tmatieres m,\n\t\t\t\t\t\t\tgroupes g " . "WHERE ( " . "jeg.login = '******' AND " . "jgc.id_groupe = jeg.id_groupe AND " . "jgc.categorie_id = jmcc.categorie_id AND " . "jgc.id_classe = '" . $lig_per->id_classe . "' AND " . "jgm.id_groupe = jgc.id_groupe AND " . "m.matiere = jgm.id_matiere AND " . "g.id=jeg.id_groupe " . "AND jgc.id_groupe NOT IN (SELECT id_groupe FROM j_groupes_visibilite WHERE domaine='cahier_notes' AND visible='n')) " . "ORDER BY jmcc.priority,jgc.priorite,m.nom_complet";
} else {
$sql = "SELECT DISTINCT g.*,m.nom_complet " . "FROM j_groupes_classes jgc, j_groupes_matieres jgm, j_eleves_groupes jeg, matieres m, groupes g " . "WHERE ( " . "jeg.login = '******' AND " . "jgc.id_groupe = jeg.id_groupe AND " . "jgc.id_classe = '" . $lig_per->id_classe . "' AND " . "jgm.id_groupe = jgc.id_groupe AND\n\t\t\t\t\tm.matiere=jgm.id_matiere AND jgm.id_groupe=g.id " . "AND jgc.id_groupe NOT IN (SELECT id_groupe FROM j_groupes_visibilite WHERE domaine='cahier_notes' AND visible='n')) " . "ORDER BY jgc.priorite,jgm.id_matiere";
}
//$sql="SELECT DISTINCT g.*,m.nom_complet FROM groupes g, j_groupes_matieres jgm, matieres m, j_groupes_classes jgc, j_eleves_groupes jeg WHERE g.id=jgm.id_groupe AND m.matiere=jgm.id_matiere AND jgc.id_groupe=jgm.id_groupe AND jeg.id_groupe=g.id AND jeg.periode='".$lig_per->num_periode."' AND jeg.login='******' ORDER BY jgc.priorite,m.nom_complet;";
//echo "$sql<br />";
$res_grp = mysqli_query($GLOBALS["mysqli"], $sql);
if (mysqli_num_rows($res_grp) > 0) {
$cpt2 = 0;
while ($lig_grp = mysqli_fetch_object($res_grp)) {
$tab_ele['periodes'][$cpt]['groupes'][$cpt2] = array();
$tab_ele['periodes'][$cpt]['groupes'][$cpt2]['id_groupe'] = $lig_grp->id;
$tab_ele['periodes'][$cpt]['groupes'][$cpt2]['name'] = $lig_grp->name;
//echo "\$tab_ele['periodes'][$cpt]['groupes'][$cpt2]['name']=".$tab_ele['periodes'][$cpt]['groupes'][$cpt2]['name']."<br />";
$tab_ele['periodes'][$cpt]['groupes'][$cpt2]['description'] = $lig_grp->description;
$tab_ele['periodes'][$cpt]['groupes'][$cpt2]['matiere_nom_complet'] = $lig_grp->nom_complet;
if ($affiche_categories) {
//$sql="SELECT DISTINCT jgc.categorie_id FROM j_groupes_classes jgc WHERE jgc.id_groupe='".$lig_grp->id."' AND id_classe='".$tab_ele['periodes'][$cpt]['id_classe']."';";
$sql = "SELECT DISTINCT jgc.categorie_id, mc.nom_court, mc.nom_complet FROM j_groupes_classes jgc, matieres_categories mc WHERE jgc.id_groupe='" . $lig_grp->id . "' AND id_classe='" . $tab_ele['periodes'][$cpt]['id_classe'] . "' AND mc.id=jgc.categorie_id;";
//echo "$sql<br />";
$res_cat = mysqli_query($GLOBALS["mysqli"], $sql);
if (mysqli_num_rows($res_cat) > 0) {
$lig_cat = mysqli_fetch_object($res_cat);
$tab_ele['periodes'][$cpt]['groupes'][$cpt2]['id_cat'] = $lig_cat->categorie_id;
$tab_ele['periodes'][$cpt]['groupes'][$cpt2]['cat_nom_court'] = $lig_cat->nom_court;
$tab_ele['periodes'][$cpt]['groupes'][$cpt2]['cat_nom_complet'] = $lig_cat->nom_complet;
//echo "\$tab_ele['periodes'][$cpt]['groupes'][$cpt2]['id_cat']=".$tab_ele['periodes'][$cpt]['groupes'][$cpt2]['id_cat']."<br />";
}
}
$sql = "SELECT DISTINCT d.coef FROM cn_notes_devoirs nd, cn_devoirs d, cn_cahier_notes cn WHERE (\n\t\t\t\t\t\tnd.login = '******' and\n\t\t\t\t\t\tnd.id_devoir = d.id and\n\t\t\t\t\t\td.display_parents='1' and\n\t\t\t\t\t\td.id_racine = cn.id_cahier_notes and\n\t\t\t\t\t\tcn.id_groupe = '" . $lig_grp->id . "' and\n\t\t\t\t\t\tcn.periode = '" . $lig_per->num_periode . "'\n\t\t\t\t\t\t)";
$res_differents_coef = mysqli_query($GLOBALS["mysqli"], $sql);
if (mysqli_num_rows($res_differents_coef) > 1) {
$differents_coef = "y";
} else {
$differents_coef = "n";
}
$tab_ele['periodes'][$cpt]['groupes'][$cpt2]['differents_coef'] = $differents_coef;
$sql1 = "SELECT d.coef, nd.note, nd.comment, d.nom_court, nd.statut, d.date, d.note_sur, d.display_parents_app FROM cn_notes_devoirs nd, cn_devoirs d, cn_cahier_notes cn WHERE (\n\t\t\t\t\t\tnd.login = '******' and\n\t\t\t\t\t\tnd.id_devoir = d.id and\n\t\t\t\t\t\td.display_parents='1' and\n\t\t\t\t\t\td.id_racine = cn.id_cahier_notes and\n\t\t\t\t\t\tcn.id_groupe = '" . $lig_grp->id . "' and\n\t\t\t\t\t\tcn.periode = '" . $lig_per->num_periode . "'\n\t\t\t\t\t\t)\n\t\t\t\t\t\tORDER BY d.date\n\t\t\t\t\t\t";
$query_notes = mysqli_query($GLOBALS["mysqli"], $sql1);
$count_notes = mysqli_num_rows($query_notes);
$m = 0;
while ($m < $count_notes) {
$eleve_display_app = @old_mysql_result($query_notes, $m, 'display_parents_app');
$eleve_app = @old_mysql_result($query_notes, $m, 'comment');
$eleve_note = @old_mysql_result($query_notes, $m, 'note');
$eleve_statut = @old_mysql_result($query_notes, $m, 'statut');
$eleve_nom_court = @old_mysql_result($query_notes, $m, 'nom_court');
$date_note = @old_mysql_result($query_notes, $m, 'date');
$coef_devoir = @old_mysql_result($query_notes, $m, 'coef');
$note_sur_devoir = @old_mysql_result($query_notes, $m, 'note_sur');
$tab_ele['periodes'][$cpt]['groupes'][$cpt2]['devoir'][$m]['display_app'] = $eleve_display_app;
$tab_ele['periodes'][$cpt]['groupes'][$cpt2]['devoir'][$m]['app'] = $eleve_app;
$tab_ele['periodes'][$cpt]['groupes'][$cpt2]['devoir'][$m]['note'] = $eleve_note;
$tab_ele['periodes'][$cpt]['groupes'][$cpt2]['devoir'][$m]['statut'] = $eleve_statut;
$tab_ele['periodes'][$cpt]['groupes'][$cpt2]['devoir'][$m]['nom_court'] = $eleve_nom_court;
$tab_ele['periodes'][$cpt]['groupes'][$cpt2]['devoir'][$m]['date'] = $date_note;
$tab_ele['periodes'][$cpt]['groupes'][$cpt2]['devoir'][$m]['coef'] = $coef_devoir;
$tab_ele['periodes'][$cpt]['groupes'][$cpt2]['devoir'][$m]['note_sur'] = $note_sur_devoir;
// On ne récupère pas le nom long du devoir?
$m++;
}
$cpt2++;
}
}
$cpt++;
}
}
$sql = "SELECT DISTINCT g.*,m.nom_complet FROM groupes g, j_groupes_matieres jgm, matieres m, j_groupes_classes jgc, j_eleves_groupes jeg WHERE g.id=jgm.id_groupe AND m.matiere=jgm.id_matiere AND jgc.id_groupe=jgm.id_groupe AND jeg.id_groupe=g.id AND jeg.login='******' ORDER BY jgc.priorite,m.nom_complet;";
//echo "$sql<br />";
$res_grp = mysqli_query($GLOBALS["mysqli"], $sql);
if (mysqli_num_rows($res_grp) > 0) {
$cpt = 0;
while ($lig_grp = mysqli_fetch_object($res_grp)) {
$tab_ele['groupes'][$cpt] = array();
$tab_ele['groupes'][$cpt]['id_groupe'] = $lig_grp->id;
$tab_ele['groupes'][$cpt]['name'] = $lig_grp->name;
$tab_ele['groupes'][$cpt]['description'] = $lig_grp->description;
$tab_ele['groupes'][$cpt]['matiere_nom_complet'] = $lig_grp->nom_complet;
$tab_ele['index_grp'][$lig_grp->id] = $cpt;
$sql = "SELECT periode FROM j_eleves_groupes WHERE login='******' AND id_groupe='" . $lig_grp->id . "' ORDER BY periode;";
$res_per2 = mysqli_query($GLOBALS["mysqli"], $sql);
if (mysqli_num_rows($res_per2) > 0) {
$tab_ele['groupes'][$cpt]['periodes'] = array();
while ($lig_per2 = mysqli_fetch_object($res_per2)) {
$tab_ele['groupes'][$cpt]['periodes'][] = $lig_per2->periode;
}
}
$sql = "SELECT u.* FROM utilisateurs u, j_groupes_professeurs jgp WHERE u.login=jgp.login AND id_groupe='" . $lig_grp->id . "' ORDER BY u.nom, u.prenom;";
$res_prof = mysqli_query($GLOBALS["mysqli"], $sql);
if (mysqli_num_rows($res_prof) > 0) {
$tab_ele['groupes'][$cpt]['prof'] = array();
$tab_ele['groupes'][$cpt]['prof_liste'] = "";
//$tab_ele['groupes'][$cpt]['prof_liste_email']="";
$cpt2 = 0;
while ($lig_prof = mysqli_fetch_object($res_prof)) {
if ($cpt2 > 0) {
$tab_ele['groupes'][$cpt]['prof_liste'] .= ", ";
}
$tab_ele['groupes'][$cpt]['prof'][$cpt2]['prof_login'] = $lig_prof->login;
$tab_ele['groupes'][$cpt]['prof'][$cpt2]['nom'] = $lig_prof->nom;
$tab_ele['groupes'][$cpt]['prof'][$cpt2]['prenom'] = $lig_prof->prenom;
$tab_ele['groupes'][$cpt]['prof'][$cpt2]['civilite'] = $lig_prof->civilite;
$tab_ele['groupes'][$cpt]['prof'][$cpt2]['email'] = $lig_prof->email;
//if($lig_prof->email!='') {
// if($tab_ele['groupes'][$cpt]['prof'][$cpt2]['prof_liste_email']!='') {$tab_ele['groupes'][$cpt]['prof_liste_email'].=", ";}
// $tab_ele['groupes'][$cpt]['prof_liste_email'].=$lig_prof->email;
//}
if ($lig_prof->email != '' && !in_array($lig_prof->email, $tab_ele['tab_prof_liste_email'])) {
$tab_ele['tab_prof_liste_email'][] = $lig_prof->email;
}
$tab_ele['groupes'][$cpt]['prof_liste'] .= $lig_prof->civilite . " " . $lig_prof->nom . " " . mb_substr($lig_prof->prenom, 0, 1) . ".";
$cpt2++;
}
}
$cpt++;
}
}
// Je ne suis pas sûr de la façon la plus pertinente de gérer les groupes/périodes... et il y aurait aussi les classes:
// $tab_ele['groupes'][$cpt]['periodes'][]
// ou $tab_ele['periodes'][$cpt]['groupes'][]
// ou $tab_ele['classes'][$cpt]['groupes'][$cpt2]['periodes'][]
}
for ($i = 0; $i < count($tab_ele['tab_prof_liste_email']); $i++) {
if ($tab_ele['prof_liste_email'] != "") {
$tab_ele['prof_liste_email'] .= ", ";
}
$tab_ele['prof_liste_email'] .= $tab_ele['tab_prof_liste_email'][$i];
}
//===================================
$get_cat = mysqli_query($GLOBALS["mysqli"], "SELECT id FROM matieres_categories");
$categories = array();
while ($row = mysqli_fetch_array($get_cat, MYSQLI_ASSOC)) {
$categories[] = $row["id"];
}
$cat_names = array();
foreach ($categories as $cat_id) {
$sql = "SELECT nom_complet FROM matieres_categories WHERE id='" . $cat_id . "';";
$res_cat = mysqli_query($GLOBALS["mysqli"], $sql);
if ($res_cat) {
$cat_names[$cat_id] = old_mysql_result($res_cat, 0);
}
}
foreach ($cat_names as $key => $value) {
$tab_ele['categorie'][$key] = $value;
}
//===================================
// Régime et redoublement
$sql = "SELECT * FROM j_eleves_regime WHERE login='******';";
$res_ele_reg = mysqli_query($GLOBALS["mysqli"], $sql);
if (mysqli_num_rows($res_ele_reg) > 0) {
$lig_ele_reg = mysqli_fetch_object($res_ele_reg);
$tab_ele['regime'] = $lig_ele_reg->regime;
$tab_ele['doublant'] = $lig_ele_reg->doublant;
}
//$sql="SELECT e.* FROM etablissements e, j_eleves_etablissements j WHERE (j.id_eleve ='".$ele_login."' AND e.id = j.id_etablissement);";
$sql = "SELECT e.* FROM etablissements e, j_eleves_etablissements j WHERE (j.id_eleve ='" . $tab_ele['elenoet'] . "' AND e.id = j.id_etablissement);";
$data_etab = mysqli_query($GLOBALS["mysqli"], $sql);
if (mysqli_num_rows($data_etab) > 0) {
$tab_ele['etab_id'] = @old_mysql_result($data_etab, 0, "id");
$tab_ele['etab_nom'] = @old_mysql_result($data_etab, 0, "nom");
$tab_ele['etab_niveau'] = @old_mysql_result($data_etab, 0, "niveau");
$tab_ele['etab_type'] = @old_mysql_result($data_etab, 0, "type");
$tab_ele['etab_cp'] = @old_mysql_result($data_etab, 0, "cp");
$tab_ele['etab_ville'] = @old_mysql_result($data_etab, 0, "ville");
if ($tab_ele['etab_niveau'] != '') {
foreach ($type_etablissement as $type_etab => $nom_etablissement) {
if ($tab_ele['etab_niveau'] == $type_etab) {
$tab_ele['etab_niveau_nom'] = $nom_etablissement;
}
}
if ($tab_ele['etab_cp'] == 0) {
$tab_ele['etab_cp'] = '';
}
if ($tab_ele['etab_type'] == 'aucun') {
$tab_ele['etab_type'] = '';
} else {
$tab_ele['etab_type'] = $type_etablissement2[$tab_ele['etab_type']][$tab_ele['etab_niveau']];
}
}
}
// Récup infos CPE
$sql = "SELECT u.* FROM j_eleves_cpe jec, utilisateurs u WHERE e_login='******' AND jec.cpe_login=u.login;";
$res_cpe = mysqli_query($GLOBALS["mysqli"], $sql);
if (mysqli_num_rows($res_cpe) > 0) {
$lig_cpe = mysqli_fetch_object($res_cpe);
$tab_ele['cpe'] = array();
$tab_ele['cpe']['login'] = $lig_cpe->login;
$tab_ele['cpe']['nom'] = $lig_cpe->nom;
$tab_ele['cpe']['prenom'] = $lig_cpe->prenom;
$tab_ele['cpe']['civilite'] = $lig_cpe->civilite;
$tab_ele['cpe']['email'] = $lig_cpe->email;
$tab_ele['cpe']['civ_nom_prenom'] = $lig_cpe->civilite . " " . $lig_cpe->nom . " " . mb_substr($lig_cpe->prenom, 0, 1) . ".";
}
$tab_ele['equipe_liste_email'] = $tab_ele['prof_liste_email'];
if (isset($tab_ele['cpe']['email']) && $tab_ele['cpe']['email'] != "" && !in_array($tab_ele['cpe']['email'], $tab_ele['tab_prof_liste_email'])) {
if ($tab_ele['equipe_liste_email'] != "") {
$tab_ele['equipe_liste_email'] .= ", ";
}
$tab_ele['equipe_liste_email'] .= $tab_ele['cpe']['email'];
}
/*
// Récup infos Prof Principal (prof_suivi)
$sql="SELECT u.* FROM j_eleves_professeurs jep, utilisateurs u WHERE jep.login='******' AND id_classe='$id_classe' AND jep.professeur=u.login;";
$res_pp=mysql_query($sql);
//echo "$sql<br />";
if(mysql_num_rows($res_pp)>0) {
$lig_pp=mysql_fetch_object($res_pp);
$tab_ele['pp']=array();
$tab_ele['pp']['login']=$lig_pp->login;
$tab_ele['pp']['nom']=$lig_pp->nom;
$tab_ele['pp']['prenom']=$lig_pp->prenom;
$tab_ele['pp']['civilite']=$lig_pp->civilite;
}
*/
if ($acces_responsables == 'y') {
// Récup infos responsables
$sql = "SELECT rp.*,ra.adr1,ra.adr2,ra.adr3,ra.adr3,ra.adr4,ra.cp,ra.pays,ra.commune,r.resp_legal FROM resp_pers rp,\n\t\t\t\t\t\t\t\t\t\tresp_adr ra,\n\t\t\t\t\t\t\t\t\t\tresponsables2 r\n\t\t\t\t\tWHERE r.ele_id='" . $tab_ele['ele_id'] . "' AND\n\t\t\t\t\t\t\tr.resp_legal!='0' AND\n\t\t\t\t\t\t\tr.pers_id=rp.pers_id AND\n\t\t\t\t\t\t\trp.adr_id=ra.adr_id\n\t\t\t\t\tORDER BY resp_legal;";
$res_resp = mysqli_query($GLOBALS["mysqli"], $sql);
//echo "$sql<br />";
if (mysqli_num_rows($res_resp) > 0) {
$cpt = 0;
while ($lig_resp = mysqli_fetch_object($res_resp)) {
$tab_ele['resp'][$cpt] = array();
$tab_ele['resp'][$cpt]['pers_id'] = $lig_resp->pers_id;
$tab_ele['resp'][$cpt]['login'] = $lig_resp->login;
$tab_ele['resp'][$cpt]['nom'] = $lig_resp->nom;
$tab_ele['resp'][$cpt]['prenom'] = $lig_resp->prenom;
$tab_ele['resp'][$cpt]['civilite'] = $lig_resp->civilite;
$tab_ele['resp'][$cpt]['tel_pers'] = $lig_resp->tel_pers;
$tab_ele['resp'][$cpt]['tel_port'] = $lig_resp->tel_port;
$tab_ele['resp'][$cpt]['tel_prof'] = $lig_resp->tel_prof;
$tab_ele['resp'][$cpt]['mel'] = $lig_resp->mel;
$tab_ele['resp'][$cpt]['adr1'] = $lig_resp->adr1;
$tab_ele['resp'][$cpt]['adr2'] = $lig_resp->adr2;
$tab_ele['resp'][$cpt]['adr3'] = $lig_resp->adr3;
$tab_ele['resp'][$cpt]['adr4'] = $lig_resp->adr4;
$tab_ele['resp'][$cpt]['cp'] = $lig_resp->cp;
$tab_ele['resp'][$cpt]['pays'] = $lig_resp->pays;
$tab_ele['resp'][$cpt]['commune'] = $lig_resp->commune;
$tab_ele['resp'][$cpt]['adr_id'] = $lig_resp->adr_id;
$tab_ele['resp'][$cpt]['resp_legal'] = $lig_resp->resp_legal;
//echo "\$lig_resp->login="******"<br />";
if ($lig_resp->login != "") {
$sql = "SELECT etat, auth_mode FROM utilisateurs WHERE login='******';";
//echo "$sql<br />";
$res_u = mysqli_query($GLOBALS["mysqli"], $sql);
if (mysqli_num_rows($res_u) > 0) {
$lig_u = mysqli_fetch_object($res_u);
$tab_ele['resp'][$cpt]['etat'] = $lig_u->etat;
$tab_ele['resp'][$cpt]['auth_mode'] = $lig_u->auth_mode;
if ($AccesDerniereConnexionResp) {
$tab_ele['resp'][$cpt]['DerniereConnexionResp'] = get_last_connexion($lig_resp->login);
$tab_ele['resp'][$cpt]['DerniereConnexionResp_Echec'] = get_last_connexion($lig_resp->login, "n");
}
}
}
$cpt++;
}
}
// Récup infos responsables resp_legal=0
$sql = "SELECT rp.*,ra.adr1,ra.adr2,ra.adr3,ra.adr3,ra.adr4,ra.cp,ra.pays,ra.commune,r.resp_legal, r.acces_sp, r.envoi_bulletin FROM resp_pers rp,\n\t\t\t\t\t\t\t\t\t\tresp_adr ra,\n\t\t\t\t\t\t\t\t\t\tresponsables2 r\n\t\t\t\t\tWHERE r.ele_id='" . $tab_ele['ele_id'] . "' AND\n\t\t\t\t\t\t\tr.resp_legal='0' AND\n\t\t\t\t\t\t\tr.pers_id=rp.pers_id AND\n\t\t\t\t\t\t\trp.adr_id=ra.adr_id\n\t\t\t\t\tORDER BY resp_legal;";
$res_resp = mysqli_query($GLOBALS["mysqli"], $sql);
//echo "$sql<br />";
if (mysqli_num_rows($res_resp) > 0) {
//$cpt=0;
while ($lig_resp = mysqli_fetch_object($res_resp)) {
$tab_ele['resp'][$cpt] = array();
$tab_ele['resp'][$cpt]['pers_id'] = $lig_resp->pers_id;
$tab_ele['resp'][$cpt]['login'] = $lig_resp->login;
$tab_ele['resp'][$cpt]['nom'] = $lig_resp->nom;
$tab_ele['resp'][$cpt]['prenom'] = $lig_resp->prenom;
$tab_ele['resp'][$cpt]['civilite'] = $lig_resp->civilite;
$tab_ele['resp'][$cpt]['tel_pers'] = $lig_resp->tel_pers;
$tab_ele['resp'][$cpt]['tel_port'] = $lig_resp->tel_port;
$tab_ele['resp'][$cpt]['tel_prof'] = $lig_resp->tel_prof;
$tab_ele['resp'][$cpt]['mel'] = $lig_resp->mel;
$tab_ele['resp'][$cpt]['adr1'] = $lig_resp->adr1;
$tab_ele['resp'][$cpt]['adr2'] = $lig_resp->adr2;
$tab_ele['resp'][$cpt]['adr3'] = $lig_resp->adr3;
$tab_ele['resp'][$cpt]['adr4'] = $lig_resp->adr4;
$tab_ele['resp'][$cpt]['cp'] = $lig_resp->cp;
$tab_ele['resp'][$cpt]['pays'] = $lig_resp->pays;
$tab_ele['resp'][$cpt]['commune'] = $lig_resp->commune;
$tab_ele['resp'][$cpt]['adr_id'] = $lig_resp->adr_id;
$tab_ele['resp'][$cpt]['resp_legal'] = $lig_resp->resp_legal;
$tab_ele['resp'][$cpt]['acces_sp'] = $lig_resp->acces_sp;
$tab_ele['resp'][$cpt]['envoi_bulletin'] = $lig_resp->envoi_bulletin;
//echo "\$lig_resp->login="******"<br />";
if ($lig_resp->login != "") {
$sql = "SELECT etat, auth_mode FROM utilisateurs WHERE login='******';";
//echo "$sql<br />";
$res_u = mysqli_query($GLOBALS["mysqli"], $sql);
if (mysqli_num_rows($res_u) > 0) {
$lig_u = mysqli_fetch_object($res_u);
$tab_ele['resp'][$cpt]['etat'] = $lig_u->etat;
$tab_ele['resp'][$cpt]['auth_mode'] = $lig_u->auth_mode;
if ($AccesDerniereConnexionResp) {
$tab_ele['resp'][$cpt]['DerniereConnexionResp'] = get_last_connexion($lig_resp->login);
$tab_ele['resp'][$cpt]['DerniereConnexionResp_Echec'] = get_last_connexion($lig_resp->login, "n");
}
}
}
$cpt++;
}
}
}
if ($active_cahiers_texte == "y" && $acces_cdt == 'y') {
$ts_limite_visibilite_comptes_rendus_pour_eleves = time();
$ts_limite_visibilite_devoirs_pour_eleves = time() + getSettingValue('delai_devoirs') * 24 * 3600;
$cpt1 = 0;
// pour initialiser la variable
$tab_date_ct = array();
// Un DISTINCT pour éviter les trois exemplaires dûs à j_eleves_groupes
$sql = "SELECT DISTINCT cte.* FROM ct_entry cte, j_eleves_groupes jeg WHERE cte.id_groupe=jeg.id_groupe AND jeg.login='******' AND cte.date_ct>={$date_ct1} AND cte.date_ct<={$date_ct2} AND cte.date_ct<={$ts_limite_visibilite_comptes_rendus_pour_eleves} ORDER BY cte.date_ct, cte.id_groupe;";
//echo "$sql<br />";
$res_ct = mysqli_query($GLOBALS["mysqli"], $sql);
if (mysqli_num_rows($res_ct) > 0) {
$cpt1 = 0;
while ($lig_ct = mysqli_fetch_object($res_ct)) {
$tab_ele['cdt_entry'][$cpt1] = array();
$tab_ele['cdt_entry'][$cpt1]['id_ct'] = $lig_ct->id_ct;
$tab_ele['cdt_entry'][$cpt1]['heure_entry'] = $lig_ct->heure_entry;
$tab_ele['cdt_entry'][$cpt1]['id_groupe'] = $lig_ct->id_groupe;
$tab_ele['cdt_entry'][$cpt1]['date_ct'] = $lig_ct->date_ct;
$tab_ele['cdt_entry'][$cpt1]['id_login'] = $lig_ct->id_login;
$tab_ele['cdt_entry'][$cpt1]['contenu'] = $lig_ct->contenu;
/*
echo "<p>\n";
foreach($tab_ele['cdt_entry'][$cpt] as $key => $value) {
echo "\$tab_ele['cdt_entry'][$cpt]['$key']=$value<br />\n";
}
echo "</p>\n";
*/
$tab_date_ct[] = $lig_ct->date_ct;
$cpt1++;
}
}
$sql = "SELECT DISTINCT ctde.* FROM ct_devoirs_entry ctde, j_eleves_groupes jeg WHERE ctde.id_groupe=jeg.id_groupe AND jeg.login='******' AND ctde.date_ct>={$date_ct1} AND ctde.date_ct<={$date_ct2} AND ctde.date_ct<={$ts_limite_visibilite_devoirs_pour_eleves} ORDER BY ctde.date_ct, ctde.id_groupe;";
//echo "$sql<br />";
$res_ct = mysqli_query($GLOBALS["mysqli"], $sql);
$cpt2 = 0;
if (mysqli_num_rows($res_ct) > 0) {
//$cpt2=0;
while ($lig_ct = mysqli_fetch_object($res_ct)) {
$tab_ele['cdt_dev'][$cpt2] = array();
$tab_ele['cdt_dev'][$cpt2]['id_ct'] = $lig_ct->id_ct;
$tab_ele['cdt_dev'][$cpt2]['id_groupe'] = $lig_ct->id_groupe;
$tab_ele['cdt_dev'][$cpt2]['date_ct'] = $lig_ct->date_ct;
$tab_ele['cdt_dev'][$cpt2]['id_login'] = $lig_ct->id_login;
$tab_ele['cdt_dev'][$cpt2]['contenu'] = $lig_ct->contenu;
$tab_date_ct[] = $lig_ct->date_ct;
$cpt2++;
}
}
sort($tab_date_ct);
$tmp_tab_date_ct = $tab_date_ct;
unset($tab_date_ct);
$tab_date_ct = array_unique($tmp_tab_date_ct);
//array_unique($tab_date_ct);
$cpt1_2 = $cpt1 + $cpt2;
$cpt = 0;
//for($i=0;$i<count($tab_date_ct);$i++) {
//for($i=0;$i<max($cpt1,$cpt2);$i++) {
for ($i = 0; $i < $cpt1_2; $i++) {
//echo "\$tab_date_ct[$i]=".$tab_date_ct[$i]."<br />";
//if($tab_date_ct[$i]!="") {
if (isset($tab_date_ct[$i]) && $tab_date_ct[$i] != "") {
$tab_ele['cdt'][$cpt]['date_ct'] = $tab_date_ct[$i];
$nbre_cdt_dev = isset($tab_ele['cdt_dev']) ? count($tab_ele['cdt_dev']) : 0;
for ($j = 0; $j < $nbre_cdt_dev; $j++) {
if ($tab_ele['cdt_dev'][$j]['date_ct'] == $tab_date_ct[$i]) {
$tab_ele['cdt'][$cpt]['dev'][] = $tab_ele['cdt_dev'][$j];
} elseif ($tab_ele['cdt_dev'][$j]['date_ct'] > $tab_date_ct[$i]) {
break;
}
}
if (isset($tab_ele['cdt_entry'])) {
for ($j = 0; $j < count($tab_ele['cdt_entry']); $j++) {
if ($tab_ele['cdt_entry'][$j]['date_ct'] == $tab_date_ct[$i]) {
$tab_ele['cdt'][$cpt]['entry'][] = $tab_ele['cdt_entry'][$j];
} elseif ($tab_ele['cdt_entry'][$j]['date_ct'] > $tab_date_ct[$i]) {
break;
}
}
}
$cpt++;
}
}
}
$tab_ele['absences'] = array();
$sql = "SELECT * FROM absences WHERE login='******' ORDER BY periode;";
$res = mysqli_query($GLOBALS["mysqli"], $sql);
if (mysqli_num_rows($res) > 0) {
$cpt = 0;
while ($lig = mysqli_fetch_object($res)) {
$tab_ele['absences'][$cpt]['periode'] = $lig->periode;
$tab_ele['absences'][$cpt]['nb_absences'] = $lig->nb_absences;
$tab_ele['absences'][$cpt]['non_justifie'] = $lig->non_justifie;
$tab_ele['absences'][$cpt]['nb_retards'] = $lig->nb_retards;
$tab_ele['absences'][$cpt]['appreciation'] = $lig->appreciation;
$cpt++;
}
}
// ============================================================================= //
// === SUIVI des absences pour ceux qui utilisent la saisie 'fond de classe' === //
// ============================================================================= //
$tab_ele['abs_quotidien'] = array();
$tab_ele['abs_quotidien']['autorisation'] = 'non';
// ne sera changé que dans le cas où la requête suivante renvoie un résultat
$ts_quinze_jours_avant = date("U") - 1296000;
$sql2 = "SELECT DISTINCT * FROM absences_rb WHERE eleve_id = '" . $ele_login . "' AND date_saisie > '" . $ts_quinze_jours_avant . "'";
$query = mysqli_query($GLOBALS["mysqli"], $sql2);
if ($query) {
$test = mysqli_num_rows($query);
if ($test >= 1) {
$tab_ele['abs_quotidien']['autorisation'] = 'oui';
}
// On enregistre toutes les absences de l'élève dans le tableau
$s = 0;
while ($rep = mysqli_fetch_object($query)) {
$jour = date("d/m", $rep->debut_ts);
$creneau = mysqli_fetch_array(mysqli_query($GLOBALS["mysqli"], "SELECT nom_definie_periode FROM edt_creneaux WHERE id_definie_periode = '" . $rep->creneau_id . "' LIMIT 1"));
$tab_ele['abs_quotidien'][$s]['retard_absence'] = $rep->retard_absence;
$tab_ele['abs_quotidien'][$s]['jour_semaine'] = $rep->jour_semaine . ' ' . $jour;
$tab_ele['abs_quotidien'][$s]['debut_heure'] = date("H:i", $rep->debut_ts);
$tab_ele['abs_quotidien'][$s]['creneau'] = $creneau["nom_definie_periode"];
$s++;
}
} else {
// rien et on laisse
}
// Affecter auparavant la valeur de $acces_mod_discipline sur deux tests:
// - Module actif
// - Accès au module discipline précisé dans Gestion générale/Droits d'accès
require_once "../mod_discipline/sanctions_func_lib.php";
// tab_mod_discipline($ele_login,$mode,$date_debut,$date_fin);
// $mode=all ou bien qualité: responsable, victime, témoin,...
$tab_ele['tab_mod_discipline'] = tab_mod_discipline($ele_login, "all", $date_debut_disc, $date_fin_disc);
return $tab_ele;
}
} else {
$url_disc = "../mod_discipline/traiter_incident.php?protagoniste_incident=" . $login_eleve;
}
$html = "<div style='float:right; width:4em; font-size:x-small; text-align:right; margin: 3px;'><a href='{$url_disc}' title=\"Consulter le module Discipline\"><img src='../images/icons/chercher.png' class='icone16' alt='Tout voir' /></a></div>";
$html .= "<div style='font-weight:bold; font-size: large;' class='fieldset_opacite50'>Discipline</div>";
require_once "../mod_discipline/sanctions_func_lib.php";
$tableau_des_avertissements_de_fin_de_periode_eleve_de_cet_eleve = tableau_des_avertissements_de_fin_de_periode_eleve($login_eleve);
if ($tableau_des_avertissements_de_fin_de_periode_eleve_de_cet_eleve != '') {
$html .= $tableau_des_avertissements_de_fin_de_periode_eleve_de_cet_eleve;
}
//$html.="<p style='color:red'>Extraction des incidents et sanctions non encore implémentée.<br />Passez par le menu 'Accueil'</p>";
$mode = "";
$disc_date_debut = "";
$disc_date_fin = "";
$titre_infobulle = $mod_disc_terme_incident . "s, mesures et " . $mod_disc_terme_sanction . "s";
$texte_infobulle = tab_mod_discipline($login_eleve, $mode, $disc_date_debut, $disc_date_fin);
$tabdiv_infobulle[] = creer_div_infobulle('div_disc_infobulle', $titre_infobulle, "", $texte_infobulle, "", 65, 0, 'y', 'y', 'n', 'n');
//$html.="<p style='font-weight: bold;'>Totaux des ".$mod_disc_terme_incident."s/mesures/".$mod_disc_terme_sanction."s en tant que Responsable.</p>\n";
$html .= "<p style='font-weight: bold; margin-top:1em;'>" . ucfirst($mod_disc_terme_incident) . "s</p>\n";
if (count($tab_incidents_ele[$login_eleve]) > 0) {
$html .= "<table class='boireaus' border='1' summary='Totaux " . $mod_disc_terme_incident . "s'>\n";
$html .= "<tr><th>Nature</th><th>Total</th></tr>\n";
$alt = 1;
foreach ($tab_incidents_ele[$login_eleve] as $key => $value) {
$alt = $alt * -1;
$html .= "<tr class='lig{$alt}'><td>" . stripslashes($key) . "</td><td>" . stripslashes($value) . "</td></tr>\n";
}
$html .= "</table>\n";
} else {
$html .= "<p>Aucun " . $mod_disc_terme_incident . " relevé en qualité de responsable.</p>\n";
}
<input type='hidden' name='lien_refermer' value='$lien_refermer' />
<p>Extraire les ".$mod_disc_terme_incident."s entre le
<input type='text' name = 'date_debut_disc' id= 'date_debut_disc' size='10' value = \"".$date_debut_disc."\" onKeyDown=\"clavier_date(this.id,event);\" AutoComplete=\"off\" />
".img_calendrier_js("date_debut_disc", "img_bouton_date_debut_disc")."
et le
<input type='text' name = 'date_fin_disc' id= 'date_fin_disc' size='10' value = \"".$date_fin_disc."\" onKeyDown=\"clavier_date(this.id,event);\" AutoComplete=\"off\" />".
img_calendrier_js("date_fin_disc", "img_bouton_date_fin_disc")."
<input type='submit' name='restreindre_intervalle_dates' value='Valider' />
<input type='hidden' name='login_ele' value=\"$login_ele\" />
</p>
</fieldset>
</form>\n";
$mode="";
echo tab_mod_discipline($login_ele, $mode, $date_debut_disc, $date_fin_disc, $restreindre_affichage_a_eleve_seul);
require("../lib/footer.inc.php");
die();
}
//===============================
// Choix de la classe
if(!isset($id_classe)) {
if($_SESSION['statut']=='administrateur') {
$sql="SELECT DISTINCT c.* FROM classes c, periodes p WHERE p.id_classe = c.id ORDER BY classe";
}
elseif($_SESSION['statut']=='secours') {
$sql="SELECT DISTINCT c.* FROM classes c, periodes p WHERE p.id_classe = c.id ORDER BY classe";
echo "<a href='".$_SERVER['PHP_SELF']."?ele_login="******"'>".$tab_enfants[$i+1]."</a><br />\n";
}
require("../lib/footer.inc.php");
die();
}
}
else {
echo " | <a href='".$_SERVER['PHP_SELF']."'>Autre enfant</a>";
}
}
echo "</p>\n";
require_once("../mod_discipline/sanctions_func_lib.php");
$mode="";
$date_debut="";
$date_fin="";
//echo "<p>Tableau des incidents</p>\n";
$tableau_des_avertissements_de_fin_de_periode_eleve_de_cet_eleve=tableau_des_avertissements_de_fin_de_periode_eleve($ele_login);
if($tableau_des_avertissements_de_fin_de_periode_eleve_de_cet_eleve!='') {
echo "<div style='float:right; width:25em; margin-bottom:0.5em; margin-left:0.5em;'>".$tableau_des_avertissements_de_fin_de_periode_eleve_de_cet_eleve."</div>\n";
}
echo tab_mod_discipline($ele_login,$mode,$date_debut,$date_fin);
require("../lib/footer.inc.php");
?>
