$page_opening = "Group photos for project {$afko}: {$description} {$year}-" . ($year + 1) . "<br/><span style='font-size:6pt;'> prj_id={$prj_id} milestone {$milestone} (prjm_id={$prjm_id}) group {$grp_num} (prjtg_id={$prjtg_id}) {$grp_alias} </span>"; $nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening); $nav->setInterestMap($tabInterestCount); $pg = new GroupPhoto($dbConn, $prjtg_id); //$pg->setWhereConstraint("prjtg_id in (select prjtg_id from prj_grp where snummer=$peer_id)"); echo $nav->show(); ?> <div id='navmain' style='padding:1em;'> <div class='nav'> <form method="get" name="project" action="<?php echo $PHP_SELF; ?> "> Project : <?php echo $prj_id_selector; ?> <input type='submit' name='get' value='Get'/> </form> </div> <?php echo $pg->getGroupPhotos(); ?> </div> <?php echo $dbConn->getLogHtml(); echo "<!-- db_name=" . $db_name . "-->\n"; ?> <!-- $Id: igroupphoto.php 1825 2014-12-27 14:57:05Z hom $--> </body> </html>
$pg->setWhereConstraint(" snummer <> {$snummer}"); $pg->setPictSize('84', '126'); $pg->setMaxCol(8); $criteria = getCriteria($prjm_id); $rainbow = new RainBow(); $criteriaList = getCriterialist($criteria, $lang, $rainbow); $rainbow = new RainBow(STARTCOLOR, COLORINCREMENT_RED, COLORINCREMENT_GREEN, COLORINCREMENT_BLUE); $remarkList = 'no remarks'; if (isset($prjtg_id)) { $sqlC = "SELECT judge,roepnaam||coalesce(' '||voorvoegsel,'')||' '||achternaam||coalesce(' ('||role||')','') as naam ,ja.prj_id,\n" . "grp_num,criterium,milestone,grade from judge_assessment ja \n" . " left join student_role sr on(ja.prjm_id=sr.prjm_id and ja.judge=sr.snummer)\n" . " left join project_roles pr on(ja.prj_id=pr.prj_id and sr.rolenum=pr.rolenum)\n" . " where contestant={$judge} and prjtg_id={$prjtg_id} \n" . "order by achternaam,judge,criterium"; $gcTable = groupContestantTable($dbConn, $sqlC, false, $criteria, $lang, $rainbow); $remarkList = remarkListIndividual($dbConn, $prjtg_id, $contestant_snummer); } else { $gcTable = "<p>No project group selected</p>"; } $groupPhotos = $pg->getGroupPhotos(); ob_start(); // ?> <div id='content' style='padding:1em;'> <?php echo $prjSel->getWidget(); ?> <?php if (!$prjSel->isEmptySelector()) { include_once 'templates/icontestant.html'; } ?> </div><?php $page->addBodyComponent(new Component(ob_get_clean())); $page->show();