<?php
require_once './core_files/excel_file_extractor.php';
require_once './core_files/attendance_processor.php';
include_once './core_files/acessories.php';
$excelfile = 'tmpdir/file.xlsx';
echo "Data You Are about to submit" . '<br/>' . '<br/>';
$raw_data = extract_to_array($excelfile);
//extracts the excel file into an array
$clean_data = clean_data($raw_data);
//removes all unnecessory spacess at the end of rows
print_review($clean_data);
if (isset($_GET['cancel'])) {
header('Location: home.php');
}
if (isset($_GET['submit'])) {
insert_students($clean_data);
insert_section($clean_data);
insert_attendance($clean_data);
echo "<script>setTimeout(\"location.href = 'home.php';\",7000);</script>";
//header('Location: index.php');
}
?>
<a href='confirm.php?cancel=true'>Cancel</a>
<a href='confirm.php?submit=true'>Submit</a>
<?php
/*
Nom : controller_assign_user.php
Créé par : Simon Roy
Gestion de la vue view_assign_user.php
*/
if (!isset($_SESSION)) {
session_start();
}
include_once "../assets/constants.php";
include_once REQUETES_BD;
if (isset($_POST['class_list_all']) && !empty($_POST['class_list_all'])) {
// on crée un plan-cadre en élaboration pour un cours qui n'a pas
// déjà de plan-cadre en élaboration
$codecours = $_POST["class_list_all"];
$etat = "Élaboration";
$plancadre_id = createPlanCadre($codecours, $etat);
$titre = array("", "Présentation du cours", "Objectifs d'intégration", "Évaluation des apprentissages", "Énoncé des compétences", "Objectifs d'apprentissage");
for ($i = 1; $i <= 5; $i++) {
insert_section($plancadre_id, $i, $titre[$i]);
}
if (isset($_POST['user_list_all']) && !empty($_POST['user_list_all'])) {
assignUserPlanCadre($plancadre_id, $_POST["user_list_all"]);
}
$_SESSION['info_assign'] = 'Le plan-cadre a bien été ajouté';
header('Location: ../view/view_nouveau_plancadre.php');
} else {
$_SESSION['info_assign'] = 'Vous devez sélectionné un cours pour ajouter un plan-cadre';
header('Location: ../view/view_nouveau_plancadre.php');
}
}
if (isset($_POST['titres']) && !empty($_POST['titres'])) {
foreach ($_POST['textes'] as $i => $texte) {
$emplacement = $i + 1;
updatesection($_POST["section_id"][$i], $emplacement, $_POST['titres'][$i], $pdo);
}
}
if (isset($_POST['new_titres']) && !empty($_POST['new_titres'])) {
$result = getcountsections($_SESSION['id_plancadre']);
if (!empty($result)) {
$new_emplacement = $result[0]['nbr'];
} else {
$new_emplacement = 1;
}
foreach ($_POST['new_textes'] as $i => $new_texte) {
insert_section($_SESSION['id_plancadre'], $new_emplacement, $_POST['new_titres'][$i], $pdo);
$new_emplacement++;
}
}
if (isset($_POST['textes']) && !empty($_POST['textes'])) {
foreach ($_POST['textes'] as $i => $texte) {
$emplacement = $i;
$save_texte = fopen($_POST['save_path'] . $emplacement . ".txt", "w");
fwrite($save_texte, $texte);
fclose($save_texte);
}
}
if (isset($_POST['new_textes']) && !empty($_POST['new_textes'])) {
foreach ($_POST['new_textes'] as $i => $new_texte) {
$emplacement = $i;
$save_texte = fopen($_POST['save_path'] . $new_emplacement . ".txt", "w");
session_regenerate_id(true);
session_write_close();
header("Location:quarterstaff.php");
}
if (isset($_POST['section'])) {
//get section data from file and input to db.
if ($_FILES["file"]["error"] > 0) {
echo "Error: " . $_FILES["file"]["error"] . "<br>";
} else {
$filename = $_FILES["file"]["tmp_name"];
$data = new Spreadsheet_Excel_Reader();
$data->setOutputEncoding('CP1251');
$data->read($filename);
drop_table("section", $data->sheets[0]['cells'][2][3], $_SESSION['year'], $_SESSION['season']);
for ($i = 2; $i <= $data->sheets[0]['numRows']; $i++) {
$status = insert_section($data, $i, $_SESSION['year'], $_SESSION['season']);
}
if ($status == NULL) {
$status = array("success-message", "Section file uploaded successfully.");
}
}
}
staffheader($_SESSION['name'], "section.php", $_SESSION['year'], $_SESSION['season_name']);
?>
<h3> <center> Please Upload the Section Sheet </center></h3>
<form id="singlesection" name="section" action="section.php" enctype="multipart/form-data" method="post">
<fieldset class="scheduler-border">
<legend class="scheduler-border">Section Excel Sheet Upload:</legend>
