include_once 'tutorhelper.inc'; require_once './peerlib/validators.inc'; require_once './peerlib/simplequerytable.inc'; include_once 'navigation2.inc'; require_once 'studentPrjMilestoneSelector.php'; $doctype = 0; $version_limit = 2; $url = $PHP_SELF; $filesizelimit = 10000000; $prj_id = 1; $milestone = 1; $prjm_id = 0; $prjtg_id = 1; extract($_SESSION); $prjSel = new StudentMilestoneSelector($dbConn, $snummer, $prjm_id); $prjSel->setExtraConstraint(" and prjm_id in (select distinct prjm_id from project_deliverables) and valid_until > now()::date "); $pp = $prjSel->getSelectedData(); extract($pp); $pp['filesizelimit'] = $filesizelimit; $pp['uploadMessage'] = ''; $_SESSION['prjtg_id'] = $prjtg_id; $_SESSION['prj_id'] = $prj_id; $_SESSION['prjm_id'] = $prjm_id; $_SESSION['milestone'] = $milestone; $_SESSION['grp_num'] = $grp_num; if (!isset($_SESSION['userfile'])) { $_SESSION['userfile'] = ''; } $sql = "select rtrim(afko) as uafko,year as myear,roepnaam as uroepnaam,\n" . " rtrim(email1) as uemail1, rtrim(email2) as uemail2, voorvoegsel as uvoorvoegsel,\n" . "achternaam as uachternaam,grp_num as ugrp,description as udescription,prjm_id,prjtg_id \n" . "from prj_grp join all_prj_tutor using(prjtg_id) join student using(snummer) left join alt_email using(snummer)\n" . "where prjm_id={$prjm_id} and snummer={$snummer}"; $resultSet = $dbConn->Execute($sql); //echo $sql;
/* $Id: studentgroupresult.php 1825 2014-12-27 14:57:05Z hom $ */ include_once './peerlib/peerutils.inc'; include_once 'tutorhelper.inc'; include_once 'navigation2.inc'; require_once 'groupresult3.inc'; require_once 'studentPrjMilestoneSelector.php'; $prjm_id = 0; $pp = array(); $pp['productgrade'] = $productgrade = 7; extract($_SESSION); ob_start(); tutorHelper($dbConn, $isTutor); $tutor_Helper = ob_get_clean(); $prjSel = new StudentMilestoneSelector($dbConn, $judge, $prjtg_id); $prjSel->setExtraConstraint(" and prjtg_id in (select distinct prjtg_id from assessment) and " . " (pr.capabilities &" . CAP_READ_PEER_ASSESSMENT_DATA . ") <> 0"); $prjSel->setEmptySelectorResult("<h1>There are no projects of which you may view the peer results</h1>"); extract($prjSel->getSelectedData()); $_SESSION['prjm_id'] = $prjm_id; $_SESSION['prjtg_id'] = $prjtg_id; $studentMayRead = hasStudentCap($snummer, CAP_READ_PEER_ASSESSMENT_DATA, $prjm_id); $pp['prjList'] = $prjList = $prjSel->getWidget(); $page = new PageContainer(); // now test if student is allowed if (!$studentMayRead) { $page_opening = 'You cannot view the results for this project and group'; $page->setTitle($page_opening); $page->addBodyComponent(new Component($tutor_Helper)); $nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening); $page->addBodyComponent($nav); $page->addHtmlFragment('templates/studentgroupresult_noaccess.html', $pp);
<?php //session_start(); include_once './peerlib/peerutils.inc'; include_once 'tutorhelper.inc'; include_once './peerlib/simplequerytable.inc'; include_once 'documentfolders.inc'; include_once 'navigation2.inc'; require_once 'studentPrjMilestoneSelector.php'; $prj_id = 1; $milestone = 1; $afko = 'undef'; $prjm_id = 0; extract($_SESSION); $prjSel = new StudentMilestoneSelector($dbConn, $judge, $prjm_id); $prjSel->setExtraConstraint(" and prjm_id in (select prjm_id from project_deliverables) "); 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; if (isset($_REQUEST['prj_id_milestone'])) { list($prj_id, $milestone) = explode(':', validate($_REQUEST['prj_id_milestone'], 'prj_id_milestone', $prj_id, ':' . $milestone)); $_SESSION['prj_id'] = $prj_id; $_SESSION['milestone'] = $milestone; } $sql = "select prjm_id from prj_milestone where prj_id={$prj_id} and milestone={$milestone}"; $resultSet = $dbConn->Execute($sql); if ($resultSet === false) { die('Error: ' . $dbConn->ErrorMsg() . ' with ' . $sql);
/* $Id: reverseView.php 1825 2014-12-27 14:57:05Z hom $ */ include_once 'peerutils.inc'; include_once 'tutorhelper.inc'; include_once 'navigation2.inc'; require_once 'GroupPhoto.class.php'; require_once 'studentPrjMilestoneSelector.php'; $prj_id = 1; $milestone = 1; $prjm_id = 0; $grp_num = 1; $prjtg_id = 1; extract($_SESSION); $judge = $snummer; $prjSel = new StudentMilestoneSelector($dbConn, $judge, $prjtg_id); $prjSel->setExtraConstraint(" and prjtg_id in (select distinct prjtg_id from assessment) "); 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; // get data stored in session or added to session by helpers $replyText = ''; $script = $lang = 'nl'; //echo "$user<br/>\n"; $sql = "select * from student where snummer={$judge}"; $resultSet = $dbConn->Execute($sql); if ($resultSet === false) { print "error fetching judge data with {$sql} : " . $dbConn->ErrorMsg() . "<br/>\n"; }
include_once './peerlib/peerutils.inc'; include_once 'tutorhelper.inc'; include_once 'documentfolders.inc'; require_once './peerlib/simplequerytable.inc'; include_once 'navigation2.inc'; require_once 'studentPrjMilestoneSelector.php'; $prj_id = 1; $milestone = 1; $prjm_id = 0; $grp_num = 1; $prjtg_id = 1; extract($_SESSION); $judge = $snummer; $prjSel = new StudentMilestoneSelector($dbConn, $judge, $prjm_id); $prjSel->setExtraConstraint(" and prjm_id in (select distinct prjm_id from task_timer) "); 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; $year = date('Y'); $month = date('m'); $sql = "select year,month,first_second,last_second from task_timer_year_month order by year desc,month desc limit 1"; $resultSet = $dbConn->Execute($sql); extract($resultSet->fields); $prj_id = 1; $milestone = 1; $grp_num = -1; $afko = 'undef';