PHP Faculty::fetchAllStudentsExcel Exemples

Exemple #1

Fichier : list-students.php Projet : hughnguy/php

    $l10n->localizeArray($semester, 'now_long');
    $l10n->localizeArray($semester, 'previous_long');
    $l10n->localizeArray($semester, 'previous2_long');
    $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-students.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-students.json');
    $result = $model->fetchAllStudentsExcel(array("Exam"), $SESSION->user_id, $selected_semester);
    foreach ($result as &$r) {
        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_student_list'));
} else {
    header('Location: https://' . URL_PHP . '/error-external.php?eid=F011');
    exit;
}