\n";
echo "TROMBINOSCOPE ";
$datej = date('Y-m-d');
$annee_en_cours_t=annee_en_cours_t($datej);
echo $annee_en_cours_t;
echo " \n";
echo "\n";
// on regarde ce qui a été choisi
if ( $classe != '' and $groupe === '' and $aid === '' and $equipepeda === '' and $discipline === '' and $statusgepi === '' ) {
// c'est une classe
$action_affiche = 'classe';
}
elseif ( $classe === '' and $groupe != '' and $aid === '' and $equipepeda === '' and $discipline === '' and $statusgepi === '' ) {
// c'est un groupe
$action_affiche = 'groupe';
}
elseif ( $classe === '' and $groupe === '' and $aid != '' and $equipepeda === '' and $discipline === '' and $statusgepi === '' ) {
// c'est un groupe
$action_affiche = 'aid';
}
elseif ( $classe === '' and $groupe === '' and $equipepeda != '' and $discipline === '' and $statusgepi === '' ) {
// c'est une équipe pédagogique
$action_affiche = 'equipepeda';
}
elseif ( $classe === '' and $groupe === '' and $equipepeda === '' and $discipline != '' and $statusgepi === '' ) {
// c'est une discipline
$action_affiche = 'discipline';
}
elseif ( $classe === '' and $groupe === '' and $equipepeda === '' and $discipline === '' and $statusgepi != '' ) {
// c'est un status de gepi
$action_affiche = 'statusgepi';
}
if ( $action_affiche === 'classe' ) {
if($_SESSION['statut']=='eleve') {
if($GepiAccesEleTrombiTousEleves=='yes') {
$requete_qui = 'SELECT c.id, c.nom_complet, c.classe FROM '.$prefix_base.'classes c WHERE c.id = "'.$classe.'"';
}
elseif($GepiAccesEleTrombiElevesClasse=='yes') {
$requete_qui="SELECT DISTINCT c.id, c.nom_complet, c.classe FROM classes c, j_eleves_classes jec WHERE c.id='$classe' AND c.id=jec.id_classe AND jec.login='".$_SESSION['login']."';";
}
else {
echo "Vous n'avez pas accès aux trombinoscopes de classes. \n";
require("../lib/footer.inc.php");
die();
}
}
else {
$requete_qui = 'SELECT c.id, c.nom_complet, c.classe FROM '.$prefix_base.'classes c WHERE c.id = "'.$classe.'"';
}
}
if ( $action_affiche === 'groupe' ) {
if($_SESSION['statut']=='eleve') {
if($GepiAccesEleTrombiTousEleves=='yes') {
$requete_qui = 'SELECT g.id, g.name FROM '.$prefix_base.'groupes g WHERE g.id = "'.$groupe.'"';
}
elseif($GepiAccesEleTrombiElevesClasse=='yes') {
$requete_qui="SELECT DISTINCT g.id, g.name FROM groupes g, j_eleves_groupes jeg WHERE g.id='$groupe' AND g.id=jeg.id_groupe AND jeg.login='".$_SESSION['login']."';";
}
else {
echo "Vous n'avez pas accès aux trombinoscopes de groupes. \n";
require("../lib/footer.inc.php");
die();
}
}
else {
$requete_qui = 'SELECT g.id, g.name FROM '.$prefix_base.'groupes g WHERE g.id = "'.$groupe.'"';
}
}
if ( $action_affiche === 'aid' ) {
if($_SESSION['statut']=='eleve') {
if($GepiAccesEleTrombiTousEleves=='yes') {
$requete_qui = "SELECT id , nom FROM aid WHERE id = '".$aid."'";
}
elseif($GepiAccesEleTrombiElevesClasse=='yes') {
$requete_qui = "SELECT id , nom FROM aid WHERE id = '".$aid."'";
}
else {
echo "Vous n'avez pas accès aux trombinoscopes de groupes. \n";
require("../lib/footer.inc.php");
die();
}
}
else {
$requete_qui = "SELECT id , nom FROM aid WHERE id = '".$aid."'";
}
}
if ( $action_affiche === 'equipepeda' ) {
if($_SESSION['statut']=='eleve') {
if($GepiAccesEleTrombiPersonnels=='yes') {
$requete_qui = 'SELECT c.id, c.nom_complet, c.classe FROM '.$prefix_base.'classes c WHERE c.id = "'.$equipepeda.'"';
}
elseif($GepiAccesEleTrombiProfsClasse=='yes') {
$requete_qui="SELECT DISTINCT c.id, c.nom_complet, c.classe FROM classes c, j_eleves_classes jec WHERE c.id='$equipepeda' AND c.id=jec.id_classe AND jec.login='".$_SESSION['login']."';";
}
else {
echo "Vous n'avez pas accès aux trombinoscopes d'équipes pédagogiques. \n";
require("../lib/footer.inc.php");
die();
}
}
else {
$requete_qui = 'SELECT c.id, c.nom_complet, c.classe FROM '.$prefix_base.'classes c WHERE c.id = "'.$equipepeda.'"';
}
}
if ( $action_affiche === 'discipline' ) {
if($_SESSION['statut']=='eleve') {
if($GepiAccesEleTrombiPersonnels=='yes') {
$requete_qui = 'SELECT m.matiere, m.nom_complet FROM '.$prefix_base.'matieres m WHERE m.matiere = "'.$discipline.'"';
}
else {
echo "Vous n'avez pas accès aux trombinoscopes par disciplines. \n";
require("../lib/footer.inc.php");
die();
}
}
else {
$requete_qui = 'SELECT m.matiere, m.nom_complet FROM '.$prefix_base.'matieres m WHERE m.matiere = "'.$discipline.'"';
}
}
//if ( $action_affiche === 'statusgepi' ) { $requete_qui = 'SELECT statut FROM '.$prefix_base.'utilisateurs u WHERE u.statut = "'.$statusgepi.'"'; }
if ( $action_affiche === 'statusgepi' ) {
if($_SESSION['statut']=='eleve') {
if(($GepiAccesEleTrombiPersonnels!='yes')&&($GepiAccesEleTrombiProfsClasse=='yes')) {
$statusgepi='professeur';
}
else {
echo "Vous n'avez pas accès aux trombinoscopes par statut. \n";
require("../lib/footer.inc.php");
die();
}
}
$requete_qui = 'SELECT statut FROM '.$prefix_base.'utilisateurs u WHERE u.statut = "'.$statusgepi.'" AND etat="actif";';
}
$execute_qui = mysqli_query($GLOBALS["mysqli"], $requete_qui) or die('Erreur SQL !'.$requete_qui.' '.mysqli_error($GLOBALS["mysqli"]));
if(mysqli_num_rows($execute_qui)==0) {
// On doit être dans le cas d'un élève qui a tenté d'accéder aux photos d'une classe, groupe, équipe,... à laquelle il n'est pas associé.
echo "La requête n'a retourné aucun enregistrement. \n";
require("../lib/footer.inc.php");
die();
}
$donnees_qui = mysqli_fetch_array($execute_qui) or die('Erreur SQL !'.$execute_qui.' '.mysqli_error($GLOBALS["mysqli"]));
if ( $action_affiche === 'classe' ) {
echo "Classe : ".$donnees_qui['nom_complet'];
echo ' ('.ucwords($donnees_qui['classe']).')';
$repertoire = 'eleves';
$requete_trombi = "SELECT e.login, e.nom, e.prenom, e.elenoet, jec.login, jec.id_classe, jec.periode, c.classe, c.id, c.nom_complet
FROM ".$prefix_base."eleves e, ".$prefix_base."j_eleves_classes jec, ".$prefix_base."classes c
WHERE e.login = jec.login
AND jec.id_classe = c.id
AND id = '".$classe."'
AND (e.date_sortie is NULL OR e.date_sortie NOT LIKE '20%')
GROUP BY nom, prenom";
}
if ( $action_affiche === 'aid' ) {
echo "AID : ".$donnees_qui['nom'];
$repertoire = 'eleves';
if((isset($_POST['order_by']))&&($_POST['order_by']=='classe')) {
$grp_order_by="c.classe, e.nom, e.prenom";
$requete_trombi = "SELECT e.login , e.nom, e.prenom , e.elenoet , a.id , a.nom nom_complet
FROM eleves e, aid a, j_aid_eleves j , j_eleves_classes jec , classes c
WHERE j.login = e.login
AND e.login = jec.login
AND jec.id_classe = c.id
AND j.id_aid = a.id
AND a.id = '".$aid."'
AND (e.date_sortie is NULL OR e.date_sortie NOT LIKE '20%')
GROUP BY e.login , e.nom , e.prenom
ORDER BY $grp_order_by;";
}
else {
$grp_order_by="e.nom, e.prenom";
$requete_trombi = "SELECT e.login, e.nom, e.prenom, e.elenoet, a.id, a.nom nom_complet
FROM eleves e , aid a , j_aid_eleves j , classes c
WHERE j.login = e.login
AND j.id_aid = a.id
AND a.id = '".$aid."'
AND (e.date_sortie is NULL OR e.date_sortie NOT LIKE '20%')
GROUP BY e.nom, e.prenom
ORDER BY $grp_order_by;";
}
}
if ( $action_affiche === 'groupe' ) {
$current_group=get_group($groupe);
echo "Groupe : ".htmlspecialchars($donnees_qui['name'])." (".$current_group['classlist_string'].")";
$repertoire = 'eleves';
if((isset($_POST['order_by']))&&($_POST['order_by']=='classe')) {
$grp_order_by="c.classe, e.nom, e.prenom";
$requete_trombi = "SELECT jeg.login, jeg.id_groupe, jeg.periode, e.login, e.nom, e.prenom, e.elenoet, g.id, g.name, g.description
FROM ".$prefix_base."eleves e, ".$prefix_base."groupes g, ".$prefix_base."j_eleves_groupes jeg, ".$prefix_base."j_eleves_classes jec, ".$prefix_base."classes c
WHERE jeg.login = e.login
AND jec.login = e.login
AND jec.id_classe=c.id
AND jeg.id_groupe = g.id
AND g.id = '".$groupe."'
AND (e.date_sortie is NULL OR e.date_sortie NOT LIKE '20%')
GROUP BY nom, prenom
ORDER BY $grp_order_by;";
}
else {
$grp_order_by="nom, prenom";
$requete_trombi = "SELECT jeg.login, jeg.id_groupe, jeg.periode, e.login, e.nom, e.prenom, e.elenoet, g.id, g.name, g.description
FROM ".$prefix_base."eleves e, ".$prefix_base."groupes g, ".$prefix_base."j_eleves_groupes jeg
WHERE jeg.login = e.login
AND jeg.id_groupe = g.id
AND g.id = '".$groupe."'
AND (e.date_sortie is NULL OR e.date_sortie NOT LIKE '20%')
GROUP BY nom, prenom
ORDER BY $grp_order_by;";
}
//echo "$requete_trombi ";
}
if ( $action_affiche === 'equipepeda' ) {
echo "Equipe pédagogique : ".$donnees_qui['nom_complet']." (".$donnees_qui['classe'].")";
$repertoire = 'personnels';
$requete_trombi = 'SELECT * FROM '.$prefix_base.'utilisateurs u, '.$prefix_base.'j_groupes_professeurs jgp, '.$prefix_base.'j_groupes_classes jgc, '.$prefix_base.'classes c
WHERE jgp.id_groupe = jgc.id_groupe
AND jgc.id_classe = c.id
AND u.login = jgp.login
AND c.id = "'.$equipepeda.'"
AND u.etat="actif"
GROUP BY u.nom, u.prenom
ORDER BY nom ASC, prenom ASC';
}
if ( $action_affiche === 'discipline' ) {
echo "Discipline : ".$donnees_qui['nom_complet']." (".$donnees_qui['matiere'].")";
$repertoire = 'personnels';
$requete_trombi = 'SELECT * FROM '.$prefix_base.'utilisateurs u, '.$prefix_base.'j_professeurs_matieres jpm, '.$prefix_base.'matieres m
WHERE u.login = jpm.id_professeur
AND m.matiere = jpm.id_matiere
AND m.matiere = "'.$discipline.'"
AND u.etat="actif"
GROUP BY u.nom, u.prenom
ORDER BY nom ASC, prenom ASC';
}
if ( $action_affiche === 'statusgepi' ) {
echo "Statut : ".my_ereg_replace("scolarite","scolarité",$statusgepi);
$repertoire = 'personnels';
if($_SESSION['statut']=='eleve') {
if($GepiAccesEleTrombiPersonnels=='yes') {
$requete_trombi = 'SELECT * FROM '.$prefix_base.'utilisateurs u
WHERE u.statut = "'.$statusgepi.'"
AND u.etat="actif"
GROUP BY u.nom, u.prenom
ORDER BY nom ASC, prenom ASC';
}
elseif($GepiAccesEleTrombiProfsClasse=='yes') {
$requete_trombi = "SELECT DISTINCT u.* FROM utilisateurs u, j_groupes_professeurs jgp, j_eleves_groupes jeg
WHERE u.statut = 'professeur' AND
jgp.id_groupe=jeg.id_groupe AND
jgp.login=u.login AND
jeg.login='".$_SESSION['login']."'
AND u.etat='actif'
GROUP BY u.nom, u.prenom
ORDER BY nom ASC, prenom ASC";
}
else {
echo "Vous n'avez pas accès aux trombinoscopes par statut. \n";
require("../lib/footer.inc.php");
die();
}
}
else {
$requete_trombi = 'SELECT * FROM '.$prefix_base.'utilisateurs u
WHERE u.statut = "'.$statusgepi.'"
AND u.etat="actif"
GROUP BY u.nom, u.prenom
ORDER BY nom ASC, prenom ASC';
}
}
//===========================================
function matiereprof($prof, $equipepeda) {
global $prefix_base;
$prof_de = '';
if ( $prof != '' ) {
$requete_matiere = 'SELECT * FROM '.$prefix_base.'j_groupes_classes jgc, '.$prefix_base.'j_groupes_matieres jgm, '.$prefix_base.'j_groupes_professeurs jgp, '.$prefix_base.'matieres m
WHERE jgc.id_classe = "'.$equipepeda.'"
AND jgc.id_groupe = jgp.id_groupe
AND jgm.id_matiere = m.matiere
AND jgp.id_groupe = jgm.id_groupe
AND jgp.login = "'.$prof.'"';
$execution_matiere = mysqli_query($GLOBALS["mysqli"], $requete_matiere) or die('Erreur SQL !'.$requete_matiere.' '.mysqli_error($GLOBALS["mysqli"]));
while ($donnee_matiere = mysqli_fetch_array($execution_matiere)) {
$prof_de = $prof_de.' '.htmlspecialchars($donnee_matiere['nom_complet']).' ';
}
}
return ($prof_de);
}
//===========================================
$execution_trombi = mysqli_query($GLOBALS["mysqli"], $requete_trombi) or die('Erreur SQL !'.$requete_trombi.' '.mysqli_error($GLOBALS["mysqli"]));
$cpt_photo = 1;
while ($donnee_trombi = mysqli_fetch_array($execution_trombi))
{
//insertion de l'élève dans la varibale $eleve_absent
$login_trombinoscope[$cpt_photo] = $donnee_trombi['login'];
$nom_trombinoscope[$cpt_photo] = $donnee_trombi['nom'];
$prenom_trombinoscope[$cpt_photo] = $donnee_trombi['prenom'];
if ( $action_affiche === 'classe' ) { $id_photo_trombinoscope[$cpt_photo] = mb_strtolower($donnee_trombi['elenoet']); }
if ( $action_affiche === 'groupe' ) { $id_photo_trombinoscope[$cpt_photo] = mb_strtolower($donnee_trombi['elenoet']); }
if ( $action_affiche === 'aid' ) {
$id_photo_trombinoscope[$cpt_photo] = mb_strtolower($donnee_trombi['elenoet']);
}
if ( $action_affiche === 'equipepeda' ) { $id_photo_trombinoscope[$cpt_photo] = $donnee_trombi['login']; }
if ( $action_affiche === 'discipline' ) { $id_photo_trombinoscope[$cpt_photo] = $donnee_trombi['login']; }
if ( $action_affiche === 'statusgepi' ) { $id_photo_trombinoscope[$cpt_photo] = $donnee_trombi['login']; }
$matiere_prof[$cpt_photo] = '';
if ( $action_affiche === 'equipepeda' and $affdiscipline === 'oui' ) {
$matiere_prof[$cpt_photo] = matiereprof($login_trombinoscope[$cpt_photo], $equipepeda);
}
$cpt_photo = $cpt_photo + 1;
}
$total = $cpt_photo;
echo "\n";
echo " | \n";
echo "
\n";
echo "