$latecount = $resultSet->fields['latecount'];
$mailbutton = $latecount > 0 ? "<input type='submit' name='domail' value='Send Mail'/>" : " ";
$sql = $sqlhead . " from \n" . "prj_grp pg \n" . "join prj_tutor pt using(prjtg_id)\n" . "join tutor t on (userid=tutor_id)\n" . "join prj_milestone pm using(prjm_id)\n" . "join project p using(prj_id)\n" . "join student s using(snummer)\n" . "where prjm_id={$prjm_id}" . " and snummer in" . $sqllate . "\n" . " order by afko,grp_num,achternaam,roepnaam";
echo "<div>\n";
?>
<table>
<tr>
<td>To mail to (almost) all students, select <input type='hidden' name='peerdata' value='prj_id_milestone'/>
<button name='checkAll' type='button' onclick='javascript:checkThem("snmailto[]")'>Select All</button></td>
<td> To mail to a few choose
<button name='checkNone' type='button' onclick='javascript:unCheckThem("snmailto[]")'>Select None</button></td>
</tr>
</table>
<?php
queryToTableChecked($dbConn, $sql, true, 2, new RainBow(0x46b4b4, 64, 32, 0), 3, 'snmailto[]', $snmailto);
echo "</div>\n";
$selecttable = ob_get_clean();
$templatefile = 'templates/dueassessment.html.inc';
$template_text = file_get_contents($templatefile, true);
if ($template_text === false) {
$page->addText("<strong>cannot read template file {$templatefile}</strong>");
} else {
eval("\$text = \"{$template_text}\";");
$page->addBodyComponent(new Component($text));
}
$page->addHeadText('<script language="javascript" type="text/javascript" src="' . SITEROOT . '/js/tiny_mce/tiny_mce.js"></script>
<script language="javascript" type="text/javascript">
tinyMCE.init({
theme: "advanced",
auto_resize: true,
<form method="get" name="activity" action="<?php
echo $PHP_SELF;
?>
">
<?php
echo $act_id_selector;
?>
csv:
<input type='checkbox' name='csvout' <?php
echo $csvout_checked;
?>
value='Y' />
<input type='submit' name='get' value='Get' />
</form>
</fieldset>
<?php
$studentPicker->setPresentQuery("select snummer,act_id from activity_participant where act_id={$act_id}");
$studentPicker->show();
?>
<div align='center'>
<?php
$inputColumns = array('4' => array('type' => 'H', 'size' => '2'));
echo queryToTableChecked($dbConn, $sql1, true, 3, $rainbow, -1, '', '', $inputColumns);
?>
</div>
</div>
</body>
</html>
<?php
echo "<!-- dbname={$db_name} -->";
<input type='hidden' name='newauditor' value='<?php
echo $newauditor;
?>
'/>
<input type='hidden' name='prjm_id' value='<?php
echo $prjm_id;
?>
'/>
</form>
</fieldset>
<?php
}
$sql = "select afko,year,milestone, prjm_id,gid,snummer,achternaam,roepnaam,voorvoegsel \n" . " from project_auditor natural join student natural join prj_milestone natural join project\n" . " where prjm_id={$prjm_id}\n" . " order by year desc,afko,gid,achternaam,roepnaam\n";
//$dbConn->log($sql);
$rainbow = new RainBow(STARTCOLOR, COLORINCREMENT_RED, COLORINCREMENT_GREEN, COLORINCREMENT_BLUE);
?>
<div align='center'>
<fieldset><legend>The current list of project auditors in the system</legend>
<?php
queryToTableChecked($dbConn, $sql, true, 0, $rainbow, -1, '', '');
?>
</fieldset>
</div>
</div>
<!-- db_name=<?php
echo $db_name;
?>
-->
<!-- $Id: projectauditor.php 1723 2014-01-03 08:34:59Z hom $ -->
</body>
</html>
echo $prj_id_selector;
?>
<input type='submit' name='get' value='Get' />
<?php
echo $spreadSheetWidget;
echo $prjSel->getSelectionDetails();
?>
</form>
</fieldset>
<a href='classtablecards.php?prjm_id=<?php
echo $prjm_id;
?>
'>Project table cards</a>
<div align='left'>
<?php
echo queryToTableChecked($dbConn, $sqlhead . $sqltail, true, 14, $rainbow, -1, '', '');
?>
</div>
<div align='left'>
<table>
<?php
echo "<tr><th>All</th><td>" . implode(';', $emailList) . "</td></tr>\n";
foreach ($grpList as $key => $list) {
echo "<tr><th>Group {$key}</th><td>" . implode(';', $list) . "</td></tr>\n";
}
?>
</table>
</div>
</div>
</body>
</html>
