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; }