security_check();
if ($resultat_session == 'c') {
header("Location: ../utilisateurs/mon_compte.php?change_mdp=yes");
die();
} else if ($resultat_session == '0') {
header("Location: ../logout.php?auto=1");
die();
}
if (!checkAccess()) {
header("Location: ../logout.php?auto=1");
die();
}
include "../lib/periodes.inc.php";
if (isset($is_posted) and ($is_posted == 'yes')) {
check_token();
$msg = "";
$appel_donnees_eleves = mysqli_query($GLOBALS["mysqli"], "SELECT DISTINCT e.* FROM eleves e, j_eleves_classes c WHERE (c.id_classe='$id_classe' and c.login = e.login)");
$nombre_lignes = mysqli_num_rows($appel_donnees_eleves);
$i = "0";
while($i < $nombre_lignes) {
$current_eleve_login = old_mysql_result($appel_donnees_eleves, $i, "login");
$j="1";
while ($j < $nb_periode) {
//
// on teste si l'élève appartient à la classe pour la période en cours
//
$call_trim = mysqli_query($GLOBALS["mysqli"], "SELECT periode FROM j_eleves_classes WHERE (id_classe = '$id_classe' and periode = '$j' and login = '$current_eleve_login')");
$nb_ligne = mysqli_num_rows($call_trim);
if ($nb_ligne != 0) {
// si l'élève appartient à la classe pour la période en cours, on continue
$temp = $current_eleve_login."_".$j;
$option_eleve[$j] = isset($_POST[$temp])?$_POST[$temp]:NULL;
if ($option_eleve[$j] == 'yes') {
$delete = mysqli_query($GLOBALS["mysqli"], "DELETE FROM j_eleves_matieres WHERE (matiere='$current_matiere' and login='$current_eleve_login' and periode = '$j') ");
} else {
$test = mysqli_query($GLOBALS["mysqli"], "SELECT * FROM j_eleves_matieres WHERE (matiere='$current_matiere' and login='$current_eleve_login' and periode = '$j')");
$nb_test = mysqli_num_rows($test);
if ($nb_test == 0) {
$test1 = mysqli_query($GLOBALS["mysqli"], "SELECT * FROM matieres_notes WHERE (matiere='$current_matiere' and login='$current_eleve_login' and periode = '$j')");
$nb_test1 = mysqli_num_rows($test1);
$test2 = mysqli_query($GLOBALS["mysqli"], "SELECT * FROM matieres_appreciations WHERE (matiere='$current_matiere' and login='$current_eleve_login' and periode = '$j')");
$nb_test2 = mysqli_num_rows($test2);
if (($nb_test1 != 0) or ($nb_test2 != 0)) {
$msg = $msg."--> Impossible de supprimer cette option pour l'élève $current_eleve_login car des moyennes ou appréciations ont déjà été rentrées en $current_matiere pour la période $j ! Commencez par supprimer ces données ! ";
} else {
$reg = mysqli_query($GLOBALS["mysqli"], "INSERT INTO j_eleves_matieres SET matiere='$current_matiere' , login='$current_eleve_login', periode='$j'");
}
}
}
}
$j++;
}
$i++;
}
$affiche_message = 'yes';
}
$message_enregistrement = "Les modifications ont été enregistrées !";
//**************** EN-TETE *****************
$titre_page = "Gestion des classes | Modification des options";
require_once("../lib/header.inc.php");
//**************** FIN EN-TETE *****************
?>