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