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>"; }
?> milestone <?php echo $milestone; ?> </th> <th <?php echo $rowstyle; ?> ><?php echo $project_time; ?> </th> </tr> <?php // change color $color = $rb->getNext(); $rowstyle = "style='background:{$color}'"; } extract($resultSet->fields); $validity_span = $validity == 'Q' ? '<span style=\'color:#800;text-decoration:underline;\' title=\'corrective entry made at ' . $time_tag . ' from ' . $from_ip . '\'>' : '<span>'; ?> <tr> <td <?php echo $rowstyle; ?> ><?php echo $snummer; ?> </td> <td <?php echo $rowstyle;
$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 { eval("\$text = \"{$template_text}\";"); $form1Form->addText($text); } $form1->add($form1Form);
<?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; }