$preload = array('0' => array('name' => ' ', 'value' => '1:1'));
$pp['doctypeSelect'] = "<select name='doctype'>\n" . getOptionList($dbConn, $sql, $doctype) . "\n</select>\n";
// collect the rights in an array and pass it to javascript.
$resultSet = $dbConn->execute($sql);
$rightsArray = array();
$rr = 0;
while (!$resultSet->EOF) {
extract($resultSet->fields);
$rightsArray[$rr] = $rights;
$rr++;
$resultSet->moveNext();
}
//$dbConn->log("3 prj_id=$prj_id, milestone=$milestone prj_id_milestone=$prj_id_milestone\n");
$sql = "SELECT distinct prj_id||':'||milestone as value, \n" . "afko||': '||description||'('||year::text||')'||' milestone '||milestone as name\n" . ", prj_id,milestone,afko, year as namegrp,year, description,grp_num,prj_grp_open,prj_id \n" . "FROM prj_grp join all_prj_tutor using(prjtg_id) join project_deliverables using(prjm_id)\n" . " where snummer={$snummer} and valid_until > now()::date order by year desc,afko";
//$dbConn->log($sql);
$pp['prjList'] = $prjSel->getSelector();
// get some default prj_id
if (!isset($prj_id) || $prj_id == 0) {
$sql = "select prj_id,milestone,prjm_id,prjtg_id from all_prj_tutor join prj_grp using(prjtg_id) where snummer={$snummer} limit 1";
$resultSet = $dbConn->execute($sql);
if ($resultSet === false) {
echo "<br>Cannot get prj_id, milestone value with <pre>{$sql}</pre> cause: " . $dbConn->ErrorMsg() . "<br>";
}
if (!$resultSet->EOF) {
extract($resultSet->fields);
$_SESSION['prj_id'] = $prj_id;
$_SESSION['milestone'] = $milestone;
$_SESSION['prjm_id'] = $prjm_id;
$_SESSION['prjtg_id'] = $prjtg_id;
}
}
$prjm_id = 0;
$grp_num = 1;
$prjtg_id = 1;
extract($_SESSION);
$judge = $snummer;
$prjSel = new StudentMilestoneSelector($dbConn, $judge, $prjtg_id);
extract($prjSel->getSelectedData());
$_SESSION['prjtg_id'] = $prjtg_id;
$_SESSION['prj_id'] = $prj_id;
$_SESSION['prjm_id'] = $prjm_id;
$_SESSION['milestone'] = $milestone;
$_SESSION['grp_num'] = $grp_num;
tutorHelper($dbConn, $isTutor);
pagehead('group photos');
$prjSel->setSubmitOnChange(true);
$prj_id_selector = $prjSel->getSelector();
$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;
die('Error: ' . $dbConn->ErrorMsg() . ' with ' . $sql);
}
extract($resultSet->fields);
extract($resultSet->fields, EXTR_PREFIX_ALL, 'stud');
$page_opening = "Roles in project groups";
$page = new PageContainer();
$page->setTitle('Set peer roles in projects');
$nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening);
$nav->setInterestMap($tabInterestCount);
$nav->addLeftNavText(file_get_contents('news.html'));
ob_start();
tutorHelper($dbConn, $isTutor);
$page->addBodyComponent(new Component(ob_get_clean()));
$page->addBodyComponent($nav);
ob_start();
$prjList = $prjSel->getSelector();
$sql = "select pm.prj_id,s.snummer as actor, rtrim(achternaam) as achternaam,rtrim(voorvoegsel) as voorvoegsel,\n" . "rtrim(roepnaam) as roepnaam, nationaliteit,hoofdgrp as class,alias,f.faculty_short as faculty,\n" . "course_description,role as current_role,sr.rolenum,pr.capabilities as capabilities\n" . " from prj_grp pg join student s using(snummer)\n" . " join prj_tutor pt on (pt.prjtg_id=pg.prjtg_id) join prj_milestone pm on(pt.prjm_id=pm.prjm_id)\n" . " left join fontys_course on (opl=course)\n" . " join faculty f on(s.faculty_id=f.faculty_id)\n " . " left join student_role sr on(sr.snummer=s.snummer and pt.prjm_id=sr.prjm_id)\n" . " left join project_roles pr on(pr.prj_id=pm.prj_id and pr.rolenum=sr.rolenum) " . " left join grp_alias ga on(ga.prjtg_id=pt.prjtg_id)" . " where (pg.prjtg_id) in (select prjtg_id \n" . " from prj_grp pga join prj_tutor pta using(prjtg_id) where pga.snummer={$snummer} and pta.prjm_id={$prjm_id})\n " . " order by pm.prj_id,achternaam,roepnaam";
$resultSet = $dbConn->Execute($sql);
if ($resultSet === false) {
echo "cannot excute <pre>\n{$sql}\n</pre>, cause " . $dbConn->ErrorMsg();
}
extract($resultSet->fields);
$dbConn->log($sql);
$sql3 = "select role as name, rolenum as value from project_roles where prj_id={$prj_id}";
$resultSet3 = $dbConn->Execute($sql3);
//$dbConn->log( $sql3 );
?>
<div style='padding:1em'>
<form method='post' name='project' action='<?php
echo $PHP_SELF;
?>
$page_opening = "Welcome to the files of the groups of {$roepnaam} {$voorvoegsel} {$achternaam} ({$snummer})";
$page_opening = "Files uploaded for projects in which {$roepnaam} {$voorvoegsel} {$achternaam} ({$snummer}) participates on {$today}";
$nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening);
$_SESSION['referer'] = $PHP_SELF;
ob_start();
tutorHelper($dbConn, $isTutor);
$page->addBodyComponent(new Component(ob_get_clean()));
$page->addBodyComponent($nav);
$sql = "SELECT distinct apt.prj_id||':'||apt.milestone as value, \n" . "apt.afko||': '||apt.description||'('||apt.year::text||')'||' milestone '||apt.milestone as name\n" . ", apt.prj_id,apt.milestone,apt.afko, apt.year as namegrp,apt.year, apt.description,apt.grp_num \n" . "FROM all_prj_tutor apt join prj_grp pg using(prjtg_id) " . " join project_deliverables pd using(prjm_id)\n" . " where snummer={$snummer} order by year desc,afko";
$resultSet = $dbConn->Execute($sql);
if ($resultSet === false) {
die('Error: ' . $dbConn->ErrorMsg() . ' with <pre>' . $sql . "</pre>\n");
}
extract($resultSet->fields);
$preload = array('0' => array('name' => ' ', 'value' => '1:1'));
$prjList = "<form name='prjmil' action='{$PHP_SELF}' method='get'>\n" . $prjSel->getSelector() . "</select> <input type='submit' value='Get'/>\n</form>";
$pp = array();
$pp['prjList'] = $prjList;
$sql = "SELECT roepnaam, voorvoegsel,achternaam,lang,prjtg_id FROM student \n" . "join prj_grp using(snummer) join prj_tutor pt using(prjtg_id) \n" . "WHERE snummer={$snummer} and pt.prjm_id={$prjm_id}";
$resultSet = $dbConn->Execute($sql);
if ($resultSet === false) {
die('Error: ' . $dbConn->ErrorMsg() . ' with ' . $sql);
}
if (!$resultSet->EOF) {
extract($resultSet->fields);
}
$isTutorBool = $isTutor ? 'true' : 'false';
$sqlfolders = "select ddd.*,doc_count from (select rtrim(afko) as afko,rtrim(description) as description,\n dd.prj_id,dd.year,dd.milestone,\n dd.prjtg_id as authorgrp,dd.grp_num as author_grp_num,long_name,title,rel_file_path,\n to_char(uploadts,'YYYY-MM-DD HH24:MI')::text as uploadts,dd.due,rtrim(mime_type) as mime_type,\n case when dd.uploadts::date > dd.due then 'late' else 'early' end as late_or_early,\n vers,dd.doctype,dd.dtdescr,upload_id,\n dd.snummer, roepnaam,voorvoegsel,achternaam,sclass,critique_count as crits,dd.rights,filesize,\n\t (coalesce({$peer_id} = aud.reader,false) or {$isTutorBool}) as link, viewergrp\n from document_data3 dd \n left join (select upload_id,prjm_id,reader,reader_role,viewergrp \n\t \t \t from document_audience where prjm_id={$prjm_id} and reader={$peer_id}) aud using(upload_id,prjm_id)\n \n\t\t where dd.prjm_id={$prjm_id} ) ddd\n join grp_upload_count2 guc on(ddd.authorgrp=guc.prjtg_id)\n\n order by afko,milestone,authorgrp";
$pp['documentFolders'] = getDocumentFolders($dbConn, $sqlfolders);
if ($isTutor) {
$pp['tutorText'] = "Tutors can always read all files without limitation.\n The extra files visable to the tutor have <span style='font-weight: bold; color:#800;'>red</span> due dates.\n The others are <span style='font-weight: bold; color:#080;'>green</span>\n (And these last remarks are only visible because you appear to be a tutor. )";
