$req_supp = mysqli_query($GLOBALS["mysqli"], "DELETE FROM edt_calendrier WHERE id_calendrier = '" . $data['supprimer'] . "'") or die('Suppression impossible !');
if ($data['supprimer'] != 0) {
$req_supp_cours = mysqli_query($GLOBALS["mysqli"], "DELETE FROM edt_cours WHERE id_calendrier = '" . $data['supprimer'] . "'") or die('Suppression impossible !');
}
}
/* ============================================ On copie le contenu de l'edt ====================================== */
if (isset($data['calendrier']) and isset($data['copier_edt'])) {
$_SESSION['copier_periode_edt'] = $data['copier_edt'];
$req_edt_periode = mysqli_query($GLOBALS["mysqli"], "SELECT nom_calendrier FROM edt_calendrier WHERE id_calendrier ='" . $data['copier_edt'] . "'");
$rep_edt_periode = mysqli_fetch_array($req_edt_periode);
$data['message'] = "Le contenu de la période \"" . $rep_edt_periode['nom_calendrier'] . "\" est prêt à être dupliqué";
}
/* ============================================ On colle le contenu de l'edt dans la nouvelle période ====================================== */
if (isset($data['calendrier']) and isset($data['coller_edt']) and isset($_SESSION['copier_periode_edt'])) {
if (PeriodExistsInDB($_SESSION['copier_periode_edt'])) {
if (PeriodExistsInDB($data['coller_edt'])) {
if ($data['coller_edt'] != $_SESSION['copier_periode_edt']) {
$req_edt_periode = mysqli_query($GLOBALS["mysqli"], "SELECT * FROM edt_cours WHERE \r\n id_calendrier = '" . $_SESSION['copier_periode_edt'] . "'\r\n ") or die(mysqli_error($GLOBALS["mysqli"]));
$i = 0;
while ($rep_edt_periode = mysqli_fetch_array($req_edt_periode)) {
$sql = "SELECT id_cours FROM edt_cours WHERE \r\n id_groupe = '" . $rep_edt_periode['id_groupe'] . "' AND\r\n\t\t\t\t\t id_salle = '" . $rep_edt_periode['id_salle'] . "' AND\r\n\t\t\t\t\t jour_semaine = '" . $rep_edt_periode['jour_semaine'] . "' AND\r\n\t\t\t\t\t id_definie_periode = '" . $rep_edt_periode['id_definie_periode'] . "' AND\r\n\t\t\t\t\t duree = '" . $rep_edt_periode['duree'] . "' AND\r\n\t\t\t\t\t heuredeb_dec = '" . $rep_edt_periode['heuredeb_dec'] . "' AND\r\n\t\t\t\t\t id_semaine = '" . $rep_edt_periode['id_semaine'] . "' AND\r\n\t\t\t\t\t id_calendrier = '" . $data['coller_edt'] . "' AND\r\n\t\t\t\t\t login_prof = '" . $rep_edt_periode['login_prof'] . "'\r\n ";
$verif_existence = mysqli_query($GLOBALS["mysqli"], $sql) or die('Erreur dans la vérification du cours : ' . mysqli_error($GLOBALS["mysqli"]));
if (mysqli_num_rows($verif_existence) == 0) {
$nouveau_cours = mysqli_query($GLOBALS["mysqli"], "INSERT INTO edt_cours SET \r\n id_groupe = '" . $rep_edt_periode['id_groupe'] . "',\r\n\t\t\t\t\t id_salle = '" . $rep_edt_periode['id_salle'] . "',\r\n\t\t\t\t\t jour_semaine = '" . $rep_edt_periode['jour_semaine'] . "',\r\n\t\t\t\t\t id_definie_periode = '" . $rep_edt_periode['id_definie_periode'] . "',\r\n\t\t\t\t\t duree = '" . $rep_edt_periode['duree'] . "',\r\n\t\t\t\t\t heuredeb_dec = '" . $rep_edt_periode['heuredeb_dec'] . "',\r\n\t\t\t\t\t id_semaine = '" . $rep_edt_periode['id_semaine'] . "',\r\n\t\t\t\t\t id_calendrier = '" . $data['coller_edt'] . "',\r\n\t\t\t\t\t login_prof = '" . $rep_edt_periode['login_prof'] . "'") or die('Erreur dans la création du cours : ' . mysqli_error($GLOBALS["mysqli"]));
$i++;
}
}
if ($i == 0) {
$data['message'] = "la duplication a déjà été réalisée";
} else {
$data['message'] = "duplication réalisée. " . $i . " cours ont été copiés avec succès";
$javascript_specifique = "edt_organisation/script/fonctions_edt";
$ua = getenv("HTTP_USER_AGENT");
if (strstr($ua, "MSIE 6.0")) {
$style_specifique = "templates/" . NameTemplateEDT() . "/css/style_edt_ie6";
} else {
$style_specifique = "templates/" . NameTemplateEDT() . "/css/style_edt";
}
//=========================== GESTION DES PERIODES
if (PeriodesExistent()) {
if ($period_id != NULL) {
$_SESSION['period_id'] = $period_id;
}
if (!isset($_SESSION['period_id'])) {
$_SESSION['period_id'] = ReturnIdPeriod(date("U"));
}
if (!PeriodExistsInDB($_SESSION['period_id'])) {
$_SESSION['period_id'] = ReturnFirstIdPeriod();
}
$DisplayPeriodBar = true;
} else {
$DisplayPeriodBar = false;
$_SESSION['period_id'] = 0;
}
//=========================== CONSTRUCTION DES EDT
if ($_SESSION['statut'] == "eleve") {
$tab_data = ConstruireEDTEleve($_SESSION['login'], $_SESSION['period_id']);
$entetes = ConstruireEnteteEDT();
$creneaux = ConstruireCreneauxEDT();
$DisplayEDT = true;
$login_edt = $_SESSION['login'];
} else {
public function launch(Request $request, Response $response)
{
$type_edt = null;
$id = null;
if ($request->getParam('login_prof')) {
$id = $request->getParam('login_prof');
$type_edt = "prof";
} else {
if ($request->getParam('id_classe')) {
$id = $request->getParam('id_classe');
$type_edt = "classe";
} else {
if ($request->getParam('id_salle')) {
$id = $request->getParam('id_salle');
$type_edt = "salle";
}
}
}
if ($request->getParam('message') != "") {
$_SESSION["message"] = "";
}
// =================== Gérer la bascule entre emplois du temps périodes et emplois du temps semaines.
if ($request->getParam('bascule_edt')) {
$_SESSION['bascule_edt'] = $bascule_edt;
}
if (!isset($_SESSION['bascule_edt'])) {
$_SESSION['bascule_edt'] = 'periode';
}
if ($_SESSION['bascule_edt'] == 'periode') {
if (PeriodesExistent()) {
if ($period_id != NULL) {
$_SESSION['period_id'] = $period_id;
}
if (!isset($_SESSION['period_id'])) {
$_SESSION['period_id'] = ReturnIdPeriod(date("U"));
}
if (!PeriodExistsInDB($_SESSION['period_id'])) {
$_SESSION['period_id'] = ReturnFirstIdPeriod();
}
$DisplayPeriodBar = true;
$DisplayWeekBar = false;
} else {
$DisplayWeekBar = false;
$DisplayPeriodBar = false;
$_SESSION['period_id'] = 0;
}
} else {
$DisplayPeriodBar = false;
$DisplayWeekBar = true;
if ($week_selected != NULL) {
$_SESSION['week_selected'] = $week_selected;
}
if (!isset($_SESSION['week_selected'])) {
$_SESSION['week_selected'] = date("W");
}
}
// =================== Forcer l'affichage d'un edt si l'utilisateur est un prof
if (!$id) {
if ($_SESSION['statut'] == "professeur" and $type_edt == "prof") {
$id = $_SESSION['login'];
$_GET["login_edt"] = $id;
$_GET["type_edt_2"] = "prof";
$type_edt_2 = "prof";
$visioedt = "prof1";
}
}
// =================== Construire les emplois du temps
if ($id) {
if ($type_edt == "prof") {
$tab_data = ConstruireEDTProf($id, $_SESSION['period_id']);
$entetes = ConstruireEnteteEDT();
$creneaux = ConstruireCreneauxEDT();
FixColumnPositions($tab_data, $entetes);
// en cours de devel
$DisplayEDT = true;
} else {
if ($type_edt == "classe") {
$tab_data = ConstruireEDTClasse($id, $_SESSION['period_id']);
$entetes = ConstruireEnteteEDT();
$creneaux = ConstruireCreneauxEDT();
$DisplayEDT = true;
} else {
if ($type_edt == "salle") {
$tab_data = ConstruireEDTSalle($id, $_SESSION['period_id']);
$entetes = ConstruireEnteteEDT();
$creneaux = ConstruireCreneauxEDT();
//FixColumnPositions($tab_data, $entetes); // en cours de devel
$DisplayEDT = true;
} else {
if ($type_edt == "eleve") {
$tab_data = ConstruireEDTEleve($id, $_SESSION['period_id']);
$entetes = ConstruireEnteteEDT();
$creneaux = ConstruireCreneauxEDT();
$DisplayEDT = true;
} else {
$DisplayEDT = false;
}
}
}
}
} else {
$DisplayEDT = false;
}
$response->addVar('message', $message);
$response->addVar('NomPeriode', calendar::getPeriodName(time()));
$response->addVar('TypeSemaineCourante', calendar::getTypeCurrentWeek());
$response->addVar('SemaineCourante', calendar::getCurrentWeek());
$this->render("./lib/template/edtSuccess.php");
$this->printOut();
}
