function emailTable($dbConn, $prjm_id, $isTutor, $mailto)
{
$counter = 1;
$result = "\n <table border='1' style='border-collapse: collapse'>\n <tr style='background:rgba(240,240,240,0.4)'><td colspan='1'> </td>\n <th><input name='checkAll' type='checkbox' onclick='javascript:checkThem(\"mailto[]\",this.checked)'/></th>\n <th align='left' colspan='7'>Select All</th></tr>\n <tr><th>#</th><th>mail</th><th>role</th>\n <th>snummer</th><th>achternaam</th><th>roepnaam</th><th>class</th>\n <th>grpnum</th><th>grp name</th><th>tutor</th>\n </tr>\n ";
if ($isTutor) {
$grpSelect = '';
} else {
$grpSelect = "and grp_num='{$judge_grp_num}' ";
}
$sql = "select afko,pt.grp_num,coalesce('g'||pt.grp_num,pt.grp_name) as grp_name,\n" . "pg.snummer as mail,rtrim(role) as role, pg.snummer,\n" . "achternaam||coalesce(', '||voorvoegsel,'') as achternaam,roepnaam,\n" . "trim(sclass) as sclass, tutor, 'role'||sr.rolenum as checkclass, 0 as lo\n" . "from\n" . "student join prj_grp pg using(snummer)\n" . "join student_class using (class_id)\n" . " join prj_tutor pt on(pg.prjtg_id=pt.prjtg_id)\n" . " join tutor t on(userid=tutor_id)\n" . " join prj_milestone pm on(pt.prjm_id=pm.prjm_id)\n" . " join project p on(p.prj_id=pm.prj_id) \n" . " left join student_role sr on(pt.prjm_id=sr.prjm_id and sr.snummer=pg.snummer)\n" . " left join project_roles pr on (pm.prj_id=pr.prj_id and pr.rolenum=sr.rolenum)\n" . " left join grp_alias ga on(pg.prjtg_id=ga.prjtg_id)\n" . " where pt.prjm_id={$prjm_id} {$grpSelect} and pm.prj_id>1";
$sql2 = "\n union\n" . "select apt.afko,grp_num,'tutor' as grp_name,\n" . "apt.tutor_id as mail, 'TUTOR' as role, apt.tutor_id as snummer,ts.achternaam||coalesce(', '||ts.voorvoegsel,'') as achternaam,ts.roepnaam,\n" . "'TUTOR' as sclass, tutor, 'role'||'999' as checkclass,1 as lo \n" . "from all_prj_tutor apt join student ts on(apt.tutor_id=ts.snummer) left join grp_alias gat using(prjtg_id) \n" . "where apt.prjm_id ={$prjm_id} {$grpSelect} and apt.prj_id>1\n";
$sql .= $sql2 . " order by grp_num,lo,achternaam,roepnaam";
// echo $sql;
$resultSet = $dbConn->Execute($sql);
$rb = new RainBow();
$bg = $rb->getCurrent();
$og = $resultSet->fields['grp_num'];
while (!$resultSet->EOF) {
extract($resultSet->fields);
if ($og != $grp_num) {
$bg = $rb->getNext();
$og = $grp_num;
}
$checked = in_array($snummer, $mailto) ? 'checked' : '';
$result .= "\n <tr style='background:{$bg}'><td align='right'>{$counter}</td>\n <td align='center'><input type='checkbox' name='mailto[]' value='{$snummer}' class='{$checkclass} {$sclass}' {$checked}/></td>\n <td>{$role}</td>\n <td>{$snummer}</td><td>{$achternaam}</td><td>{$roepnaam}</td><td>{$sclass}</td>\n <td class='num'>{$grp_num}</td><td>{$grp_name}</td><td>{$tutor}</td>\n </tr> ";
$resultSet->moveNext();
$counter++;
}
return $result . "</table>";
}
$form1Form = new HtmlContainer("<form id='project' method='post' name='project' action='{$PHP_SELF}'>");
$input_prj_selector = "<select name='prj_id' onchange='submit()'>\n" . getOptionListGrouped($dbConn, "select afko||': '||description||' ('||year||')' as name" . ", year as namegrp,prj_id as value from project order by year desc,afko", $prj_id) . "\n</select>\n";
if ($isTutorOwner) {
$input_num_criteria = "<input class='" . $validator->validationClass('critcount') . "' type='text' align='right' size='1' maxlength='2' name='critcount' value='{$critcount}'/>";
$input_submit_button = "<input type='submit' name='setcrit' value='Set Criteria'/>";
} else {
$input_num_criteria = "{$critcount}";
$input_submit_button = '';
}
$project_selector = $prjSel->getSelector();
$sql = "select bc.criterium_id as bc,pc.criterium_id as ac,pc.criterium_id as uc,nl_short,nl,de_short,de,en_short,en\n" . " from base_criteria bc natural left join (select prjm_id,criterium_id from prjm_criterium \n" . " where prjm_id={$prjm_id}) pc order by bc";
$resultSet = $dbConn->Execute($sql);
if ($resultSet === false) {
$dbConn->log("cannot get date with {$sql}, reason: " . $dbConn->ErrorMsg() . "<br/>\n");
}
$rainbow = new RainBow(STARTCOLOR, COLORINCREMENT_RED, COLORINCREMENT_GREEN, COLORINCREMENT_BLUE);
$table = "<table style='border-collapse:collapse' border='1'>\n<tr valign='top' >\n <th>C</th>\n <th>S</th>\n <th>U</th>\n <th colspan='2'>NL</th>\n <th colspan='2'>DE</th>\n <th colspan='2'>EN</th>\n </tr>";
while (!$resultSet->EOF) {
extract($resultSet->fields);
$color = $rainbow->getNext();
$checked = isset($ac) && '' != $ac ? 'checked' : '';
$table .= "<tr valign='top' style='background:{$color}'>\n <td>{$bc}</td>\n <td > <input type='checkbox' name='criterium_id[]', value='{$bc}' {$checked}/></td>\n <td>{$uc}</td>\n <td >{$nl_short}</td>\n <td >{$nl}</td>\n <td >{$de_short}</td>\n <td >{$de}</td>\n <td >{$en_short}</td>\n <td >{$en}</td>\n </tr>\n";
$resultSet->moveNext();
}
$table .= "</table>";
//$form1Form->addText($table);
$templatefile = 'templates/criteria3.html.inc';
$template_text = file_get_contents($templatefile, true);
if ($template_text === false) {
$form1Form->addText("<strong>cannot read template file {$templatefile}</strong>");
} else {
<th>Name</th>
<th>Project</th>
<th>Task id</th>
<th>Task description</th>
<th>From ip</th>
<th>Year</th>
<th>Month</th>
<th>Start time</th>
<th>Stop time</th>
<th>Task time</th>
<th>Task Total</th>
<th>Personal Total</th>
</tr>
</thead>
<?php
$rb = new RainBow(STARTCOLOR, COLORINCREMENT_RED, COLORINCREMENT_GREEN, COLORINCREMENT_BLUE);
if (!$resultSet->EOF) {
extract($resultSet->fields);
}
$color = $rb->restart();
$rowstyle = "style='background:{$color}'";
while (!$resultSet->EOF) {
if ($resultSet->fields['task_id'] != $task_id || $resultSet->fields['snummer'] != $snummer) {
?>
<tr>
<th <?php
echo $rowstyle;
?>
colspan='11' align='left'>Task total for <?php
echo $name;
?>
public function setAutoZebra($az)
{
$this->autoZebra = $az;
if ($this->autoZebra) {
$this->rainBow = RainBow::aRGBZebra();
}
return $this;
}
<?php
require_once 'peerutils.inc';
echo pg_escape_string("Hello world nice isn't it");
require_once 'rainbow.inc';
echo "<br/>";
$rb = new RainBow();
for ($i = 0; $i < $rb->count(); $i++) {
echo $rb->getCurrentAsARGBString() . "<br/>";
$rb->getNext();
}
function expandListRowTemplate($la)
{
$result = '';
$con = ', ';
foreach ($la as $expr => $colName) {
$result .= $con . "{$expr} as {$colName}";
}
return $result;
}
$a = array('a', 'b', "achternaam||','||roepnaam" => 'C');
$aA = array();
foreach ($a as $key => $value) {
echo "{$key} = {$value}</br>";
}
foreach ($a as $key => $value) {
if (is_numeric($key)) {
$aA[$value] = $value;
} else {
$aA[$key] = $value;
}
