include_once './peerlib/peerutils.inc';
require_once './peerlib/validators.inc';
include_once 'navigation2.inc';
requireCap(CAP_TUTOR);
include './peerlib/simplequerytable.inc';
require_once 'ClassSelectorClass.php';
require_once 'SpreadSheetWriter.php';
// get group tables for a project
$class_id = 1;
$fileExtension = 'xls';
if (isset($_REQUEST['class_id'])) {
$_SESSION['class_id'] = $class_id = validate($_REQUEST['class_id'], 'integer', 1);
}
extract($_SESSION);
$classSelectorClass = new ClassSelectorClass($dbConn, $class_id);
$oldClassSelector = $classSelectorClass->addConstraint('sort1 < 10 and student_count <>0')->getSelector();
if (isset($class_id)) {
$sql = "select trim(faculty_short) as faculty_short,trim(sclass) as sclass\n" . " from student_class join faculty using(faculty_id) where class_id={$class_id}";
$resultSet = $dbConn->Execute($sql);
if ($resultSet !== false) {
extract($resultSet->fields);
}
}
$sqlhead = "select distinct snummer," . "achternaam ,roepnaam, voorvoegsel as tussenvoegsel, " . "pcn,lang,gebdat as birth_date,t.tutor as slb,country as nation,rtrim(email1) as email1,rtrim(email2) as email2,\n" . "studieplan_short as studieplan,sclass,hoofdgrp ,\n" . "straat,huisnr,plaats,phone_gsm,phone_home\n" . " from \n";
$sqltail = " join student_class using(class_id) left join tutor t on (s.slb=t.userid)\n" . " left join studieplan using(studieplan)\n" . "left join iso3166 on(nationaliteit=a2)\n" . "where class_id='{$class_id}' order by achternaam,roepnaam";
$fdate = date('Y-m-d');
$filename = 'class_list_' . $faculty_short . '_' . $sclass . '-' . $fdate;
$spreadSheetWriter = new SpreadSheetWriter($dbConn, $sqlhead . ' student s left join alt_email aem using(snummer) ' . $sqltail);
$spreadSheetWriter->setTitle("Class list {$faculty_short} {$sclass} {$fdate}")->setLinkUrl($server_url . $PHP_SELF . '?class_id=' . $class_id)->setFilename($filename)->setAutoZebra(true);
$spreadSheetWriter->processRequest();
$spreadSheetWidget = $spreadSheetWriter->getWidget();
