$l10n->localizeArray($semester, 'previous3_long'); $l10n->localizeArray($semester, 'next_long'); $l10n->localizeArray($semester, 'next1_long'); require_once FS_PHP . '/header-external.php'; require_once 'views/list-courses.php'; require_once FS_PHP . '/footer-external.php'; } elseif ($_GET['page'] === "excel") { $semester = \Ventus\Utilities\Functions::fetchSemester(); if (!isset($_GET['sem'])) { $selected_semester = $semester['now_short']; } else { $selected_semester = $_GET['sem']; } $l10n->addResource(FS_L10N . '/filenames.json'); $l10n->addResource(__DIR__ . '/l10n/list-courses.json'); $result = $model->fetchAllCoursesExamsExcel($SESSION->user_id, $selected_semester); foreach ($result as &$r) { $r["column5"] = $l10n->__($r["column5"]); //The exam type is stored in English in the database $r["column7"] = $l10n->__($r["column7"]); //The alternate status is stored in English in the database for ($i = 0; $i < sizeof($r); $i++) { $r[$l10n->__("csvColumn" . $i)] = $r["column" . $i]; unset($r["column" . $i]); } } $csv = new \Ventus\Utilities\CSV($result); $csv->generate($l10n->__('file.faculty_course_list')); } else { header('location: https://' . URL_PHP . '/error-external.php?eid=F002'); }