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