$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(); }