<?php require_once './peerlib/peerutils.inc'; require_once 'queryToXlsx.php'; require_once 'SpreadSheetWriter.php'; require_once 'pgrowparser.php'; $_REQUEST['filetype'] = 'Excel2007'; $prjm_id = 266; $criteria = criteriaShortAsArray(getCriteria($prjm_id), 'en'); $criteria[] = 'Overall'; $sql = "select prjtg_id from prj_tutor where prjm_id={$prjm_id}"; $sql2 = ""; $resultSet = $dbConn->Execute($sql); $con = " "; while (!$resultSet->EOF) { extract($resultSet->fields); $sql2 .= $con . " select * from assessment_grade_set({$prjtg_id},6.5)\n"; $con = "union\n\t"; $resultSet->moveNext(); } //echo "<pre>$sql2</pre>\n"; $sqlt = "select s.snummer,achternaam,roepnaam,voorvoegsel,gebdat,grp_num,grade\n" . " from ({$sql2}) ags \n" . " join prj_grp using(prjtg_id,snummer)" . " join all_prj_tutor using(prjtg_id) \n" . " join student s using(snummer) order by grp_num,achternaam"; //echo "<pre>$sqlt</pre>\n"; global $ADODB_FETCH_MODE; $ADODB_FETCH_MODE = ADODB_FETCH_NUM; $spreadSheetWriter = new SpreadSheetWriter($dbConn, $sqlt); $headers = array('snummer', 'achternaam', 'roepnaam', 'voorvoegsel', 'gebdat', 'grp_num', $criteria); $filename = 'groupresult' . date('Y-m-d'); $c = array('FFC0C0FF', 'FFFFFFFF'); $spreadSheetWriter->setFilename($filename)->setTitle("Group result")->setLinkUrl("http://www.fontysvenlo.org")->setColorChangerColumn(5)->setFilename($filename)->setRowParser(new RowWithArraysPreHeadersParser($headers)); $spreadSheetWriter->processRequest();
$resultSet = $dbConn->Execute($sql); if ($resultSet === false) { die("<br>Cannot get project name with \"" . $sql . '", cause ' . $dbConn->ErrorMsg() . "<br>"); } if (!$resultSet->EOF) { extract($resultSet->fields); } $filename = 'groupresult' . trim($afko) . ($grp_num == '*' ? '_' : $grp_num) . 'm' . $milestone . '_consolidated_' . $fdate; $title = "Group result project {$afko} {$year}, milestone {$milestone} group {$grp_num} "; if (isset($alias)) { $title .= " ({$alias})"; } $title .= "; spreadsheet file created on {$fdate}"; $sqlt = "select s.snummer as contestant, " . "roepnaam||' '||coalesce(voorvoegsel,'')||' '||achternaam as naam, " . "ags.grade as peerg,\n" . "ags.multiplier[array_upper(ags.multiplier,1)] as grp_multiplier, " . "coalesce(round(mg.grade,2),round({$productgrade}*ags.multiplier[array_upper(ags.multiplier,1)],2)) as tutorg \n" . " from student s join assessment_grade_set({$prjtg_id},{$productgrade}) ags using (snummer)" . " join all_prj_tutor using(prjtg_id) " . " left join milestone_grade mg using(prjm_id,snummer) order by achternaam,roepnaam,snummer"; $spreadSheetWriter = new SpreadSheetWriter($dbConn, $sqlt); $spreadSheetWriter->setFilename($filename)->setLinkUrl($server_url . $PHP_SELF . '?class_id=' . $class_id)->setTitle($title)->setAutoZebra(true)->setWeights(array(1, 2, 3, 4))->setFirstWeightsColumn(2)->setWeightSumsColumn(9)->setRowParser(new RowWithArraysPreHeadersParser(array('contestant', 'name', criteriaShortAsArray($criteria, 'en'), 'multiplier', 'tutorg'))); $spreadSheetWriter->processRequest(); $scripts = '<script type="text/javascript" src="js/jquery.js"></script> <script src="js/jquery.tablesorter.js"></script> <script type="text/javascript"> $(document).ready(function() { // do stuff when DOM is ready $("#groupresult").tablesorter({ }); }); </script> <link rel=\'stylesheet\' type=\'text/css\' href=\'' . SITEROOT . '/style/tablesorterstyle.css\'/> '; pagehead2('groupresult', $scripts); $prj_id_selector = $prjSel->getSelector(); $prj_data = $prjSel->getSelectionDetails();