}
$subSelect = $cols . "\n from" . $join;
// $dbConn->log($subSelect);
}
$grades = "";
$con = '';
foreach ($gradeColumns as $grade) {
$grades .= $con . "subselect.{$grade},subselect.{$grade}_mul";
$con = "\n\t,";
}
$sql = "select snummer,achternaam,roepnaam,voorvoegsel, afko, year, \n" . "milestone,grp_num,\"alias\",tutor,\"role\",{$grades},sw.final_grade \n" . "from prj_grp join all_prj_tutor using(prjtg_id)\n" . " join student using(snummer) \n" . " left join milestone_grade using(prjm_id,snummer)\n" . " left join student_role using (prjm_id,snummer)\n" . " left join project_roles using (prj_id,rolenum)\n" . " join ({$subSelect}) subselect using(snummer)\n" . " left join (select snummer,round(grade_weight_sum/w.weight_sum,1) \n" . " as final_grade from project_grade_weight_sum_product\n" . " cross join (select weight_sum from project_weight_sum where prj_id={$prj_id}) w where prj_id={$prj_id} ) sw using(snummer)\n" . "where prjm_id={$prjm_id} order by grp_num,achternaam,roepnaam";
$pp = array();
$dbConn->log($sql);
$spreadSheetWriter = new SpreadSheetWriter($dbConn, $sql);
$title = "Results for all participants in project {$afko} {$year} milestone {$milestone}";
$spreadSheetWriter->setFilename($filename)->setLinkUrl($server_url . $PHP_SELF)->setTitle($title)->setColorChangerColumn(7);
//->setRowParser( new RowWithArraysParser());
$spreadSheetWriter->processRequest();
$pp['spreadSheetWidget'] = $spreadSheetWriter->getWidget();
$page = new PageContainer();
$page->setTitle('Get group tables');
$page_opening = "Group lists for project {$afko} {$description} <span style='font-size:8pt;'>prjm_id {$prjm_id} prj_id {$prj_id} milestone {$milestone} </span>";
$nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening);
$nav->setInterestMap($tabInterestCount);
$rainbow = new RainBow();
$pp['rtable'] = getQueryToTableChecked($dbConn, $sql, false, 7, $rainbow, -1, '', '');
$pp['selector'] = $prjSel->getSelector();
$pp['selectionDetails'] = $prjSel->getSelectionDetails();
$page->addBodyComponent($nav);
$page->addHtmlFragment('templates/milestonegrades.html', $pp);
$page->show();
';
$csvout = 'N';
$csvout_checked = '';
if (isset($_REQUEST['csvout'])) {
$csvout = $_REQUEST['csvout'];
$csvout_checked = $csvout == 'Y' ? 'checked' : '';
}
// <a href='../emailaddress.php?snummer=snummer'>snummer</a>
$fdate = date('Ymd-Hi');
$filename = 'jaag_buit-' . $fdate;
$sql = "select * from jaag_buit_html";
$sqlcsv = "select * from jaag_buit";
$spreadSheetWriter = new SpreadSheetWriter($dbConn, $sqlcsv);
$spreadSheetWriter->setFilename($filename)->setTitle("Jaag buit {$fdate}")->setLinkUrl($server_url . $PHP_SELF)->setFilename($filename)->setAutoZebra(true);
$spreadSheetWriter->processRequest();
$spreadSheetWidget = $spreadSheetWriter->getWidget();
pagehead2('Jaag Buit', $scripts);
$page_opening = "Resultaat van jaagactie tot nu toe";
$nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening);
echo $nav->show();
?>
<div id='navmain' style='padding:1em;'>
<fieldset><legend>Select output type</legend>
<form method="get" name="project" action="<?php
echo $PHP_SELF;
?>
">
<input type='submit' name='get' value='Get' />
Excel file:
<?php
echo $spreadSheetWidget;
