\n";
if(($_SESSION['statut']=='administrateur')||
($_SESSION['statut']=='cpe')||
($_SESSION['statut']=='scolarite')) {
$sql="SELECT 1=1 FROM s_incidents si
LEFT JOIN s_protagonistes sp ON sp.id_incident=si.id_incident
WHERE sp.id_incident IS NULL
LIMIT 1;";
$test=mysqli_query($GLOBALS["mysqli"], $sql);
if(mysqli_num_rows($test)>0) {
echo " | ".ucfirst($mod_disc_terme_incident)."s sans protagonistes\n";
}
}
elseif (($_SESSION['statut']=='professeur')||($_SESSION['statut']=='autre')) {
$sql="SELECT 1=1 FROM s_incidents si
LEFT JOIN s_protagonistes sp ON sp.id_incident=si.id_incident
WHERE sp.id_incident IS NULL
LIMIT 1;";
//echo "$sql ";
$test=mysqli_query($GLOBALS["mysqli"], $sql);
if(mysqli_num_rows($test)>0) {
echo " | ".ucfirst($mod_disc_terme_incident)."s sans protagonistes\n";
}
}
if((file_exists('mod_discipline_extraction_ooo.php'))&&(($_SESSION['statut']=='cpe')||($_SESSION['statut']=='administrateur')||($_SESSION['statut']=='scolarite'))) {
echo " | Export ODT\n";
}
if(!isset($id_incident)) {
$chaine_criteres="";
//$sql="SELECT * FROM s_incidents si, s_protagonistes sp ORDER BY date,heure,login;";
//$sql="SELECT si.* FROM s_incidents si WHERE 1";
if(($_SESSION['statut']=='professeur')||($_SESSION['statut']=='autre')) {
if($id_classe_incident=="") {
$sql="(SELECT DISTINCT si.* FROM s_incidents si, s_protagonistes sp WHERE (sp.login='".$_SESSION['login']."' OR si.declarant='".$_SESSION['login']."') AND sp.id_incident=si.id_incident";
}
else {
$sql="(SELECT DISTINCT si.* FROM s_incidents si, s_protagonistes sp, j_eleves_classes jec WHERE (sp.login='".$_SESSION['login']."' OR si.declarant='".$_SESSION['login']."') AND sp.id_incident=si.id_incident AND sp.login=jec.login AND jec.id_classe='$id_classe_incident' ";
}
}
else {
if($id_classe_incident=="") {
$sql="(SELECT DISTINCT si.* FROM s_incidents si, s_protagonistes sp WHERE sp.id_incident=si.id_incident";
}
else {
$sql="(SELECT DISTINCT si.* FROM s_incidents si, s_protagonistes sp, j_eleves_classes jec WHERE sp.id_incident=si.id_incident AND jec.id_classe='$id_classe_incident' AND jec.login=sp.login";
}
}
$ajout_sql="";
if($date_incident!="") {$ajout_sql.=" AND si.date='$date_incident'";$chaine_criteres.="&date_incident=$date_incident";}
if($heure_incident!="") {$ajout_sql.=" AND si.heure='$heure_incident'";$chaine_criteres.="&heure_incident=$heure_incident";}
//if($nature_incident!="") {$ajout_sql.=" AND si.nature='$nature_incident'";$chaine_criteres.="&nature_incident=$nature_incident";}
if($nature_incident!="---") {$ajout_sql.=" AND si.nature='$nature_incident'";$chaine_criteres.="&nature_incident=$nature_incident";}
if($protagoniste_incident!="") {$ajout_sql.=" AND sp.login='$protagoniste_incident'";$chaine_criteres.="&protagoniste_incident=$protagoniste_incident";}
//echo "\$declarant_incident=$declarant_incident ";
if($declarant_incident!="---") {$ajout_sql.=" AND si.declarant='$declarant_incident'";$chaine_criteres.="&declarant_incident=$declarant_incident";}
if($id_classe_incident!="") {
$chaine_criteres.="&id_classe_incident=$id_classe_incident";
}
$sql.=$ajout_sql;
$sql2=$sql;
if($incidents_clos!="y") {$sql.=" AND si.etat!='clos'";}
$sql.=")";
$sql2.=")";
//if($_SESSION['statut']=='professeur') {
if($_SESSION['statut']=='professeur') {
//if($declarant_incident=="") {
// On ne devrait plus avoir $declarant_incident=="", mais plutôt $declarant_incident=="---"
if(($declarant_incident=="")||($declarant_incident=="---")) {
if(getSettingValue('visuDiscProfClasses')=='yes') {
$ajout2_sql=" UNION (SELECT DISTINCT si.* FROM s_incidents si,
s_protagonistes sp,
j_eleves_classes jec,
j_groupes_classes jgc,
j_groupes_professeurs jgp
WHERE sp.id_incident=si.id_incident AND
sp.login=jec.login AND
jgp.id_groupe=jgc.id_groupe AND
jgc.id_classe=jec.id_classe AND
jgp.login='".$_SESSION['login']."'";
if($id_classe_incident!="") {
$ajout2_sql.=" AND jec.id_classe='".$id_classe_incident."'";
}
$ajout2_sql.=$ajout_sql;
$sql.=$ajout2_sql;
$sql2.=$ajout2_sql;
if($incidents_clos!="y") {$sql.=" AND si.etat!='clos'";}
$sql.=")";
$sql2.=")";
}
elseif(getSettingValue('visuDiscProfGroupes')=='yes') {
$ajout2_sql=" UNION (SELECT DISTINCT si.* FROM s_incidents si,
s_protagonistes sp,
j_eleves_groupes jeg,
j_groupes_professeurs jgp
WHERE sp.id_incident=si.id_incident AND
sp.login=jeg.login AND
jgp.id_groupe=jeg.id_groupe AND
jgp.login='".$_SESSION['login']."'";
$ajout2_sql.=$ajout_sql;
if($id_classe_incident!="") {
$ajout2_sql2.=" AND jeg.login IN (SELECT login FROM j_eleves_classes WHERE id_classe='".$id_classe_incident."') ";
}
$sql.=$ajout2_sql;
$sql2.=$ajout2_sql;
if($incidents_clos!="y") {$sql.=" AND si.etat!='clos'";}
$sql.=")";
$sql2.=")";
}
// Pour qu'un professeur principal puisse consulter les incidents mettant en cause ses élèves
$ajout2_sql=" UNION (SELECT DISTINCT si.* FROM s_incidents si, s_protagonistes sp, j_eleves_professeurs jep WHERE sp.id_incident=si.id_incident AND sp.login=jep.login AND jep.professeur='".$_SESSION['login']."'";
if($id_classe_incident!="") {
$ajout2_sql.=" AND sp.login IN (SELECT login FROM j_eleves_classes WHERE id_classe='".$id_classe_incident."') ";
}
$ajout2_sql.=$ajout_sql;
$sql.=$ajout2_sql;
$sql2.=$ajout2_sql;
if($incidents_clos!="y") {$sql.=" AND si.etat!='clos'";}
$sql.=")";
$sql2.=")";
}
}
// 20130716
if(!isset($limit)){
$limit=20;
}
if(!isset($debut)){
$debut=0;
}
elseif($limit=='TOUS') {
$debut=0;
}
else{
if(mb_strlen(preg_replace("/[0-9]/","",$debut))){
$debut=0;
}
}
$sql.=" ORDER BY date DESC, heure DESC";
$sql2.=" ORDER BY date DESC, heure DESC";
$res=mysqli_query($GLOBALS["mysqli"], $sql);
$nb_incidents_en_tout_avec_criteres_choisis_hors_limitation_de_tranche=mysqli_num_rows($res);
if($debut>$nb_incidents_en_tout_avec_criteres_choisis_hors_limitation_de_tranche) {
$debut=0;
}
// On va refaire la requête un peu après avec les limitations de tranche choisies
if($limit!='TOUS'){
$sql.=" LIMIT $debut,$limit";
$sql2.=" LIMIT $debut,$limit";
}
//$sql.=" ORDER BY si.date DESC, si.heure DESC;";
//$sql2.=" ORDER BY si.date DESC, si.heure DESC;";
//$sql.=" ORDER BY date DESC, heure DESC;";
//$sql2.=" ORDER BY date DESC, heure DESC;";
//echo "$sql ";
//echo "$sql2 ";
$res=mysqli_query($GLOBALS["mysqli"], $sql);
if(mysqli_num_rows($res)==0) {
echo " | Retour à la page précédente\n";
echo "\n";
if($incidents_clos=="y") {
echo "
Aucun incident n'est encore déclaré";
if(($date_incident!="")||
($heure_incident!="")||
($nature_incident!="---")||
(($declarant_incident!="---")&&($declarant_incident!=""))||
($protagoniste_incident!="")||
//($declarant_incident!="")||
($id_classe_incident!="")) {echo " avec les critères choisis";}
echo ".
Aucun ".$mod_disc_terme_incident." n'est encore déclaré";
if(($date_incident!="")||
($heure_incident!="")||
($nature_incident!="---")||
(($declarant_incident!="---")&&($declarant_incident!=""))||
($protagoniste_incident!="")||
//($declarant_incident!="")||
($id_classe_incident!="")) {echo " avec les critères choisis";}
echo ".
\n";
}
else {
echo "
Aucun incident (non clos) n'est déclaré";
if(($date_incident!="")||
($heure_incident!="")||
($nature_incident!="---")||
(($declarant_incident!="---")&&($declarant_incident!=""))||
($protagoniste_incident!="")||
//($declarant_incident!="")||
($id_classe_incident!="")) {echo " avec les critères choisis";}
echo ".
Lorsqu'un ".$mod_disc_terme_incident." est clos, on ne peut plus modifier l'".$mod_disc_terme_incident.", ni saisir/modifier de ".$mod_disc_terme_sanction.".
On peut en revanche le déclore
Ne jamais clore les ".$mod_disc_terme_incident."s peut provoquer des lenteurs de chargement de la présente page lorsque le nombre d'".$mod_disc_terme_incident."s augmente (avec le temps, l'accumulation est inéluctable).
Retour à l'index\n";
//echo "