require_once 'prjMilestoneSelector2.php';
require_once 'studentpicker.php';
//$dbConn->setSqlAutoLog( $db_name <> 'peer' );
requireCap(CAP_TUTOR);
$prjm_id = 0;
$prj_id = 1;
$milestone = 1;
$newsnummer = 1;
extract($_SESSION);
$prjSel = new PrjMilestoneSelector2($dbConn, $peer_id, $prjm_id);
extract($prjSel->getSelectedData());
$_SESSION['prj_id'] = $prj_id;
$_SESSION['prjm_id'] = $prjm_id;
$_SESSION['milestone'] = $milestone;
// unknown project?
$isTutorOwner = checkTutorOwner($dbConn, $prj_id, $peer_id);
// check if this is tutor_owner of this project
$prjm_id_selector = $prjSel->getSimpleForm();
$mail_button = " ";
$isAdmin = hasCap(CAP_SYSTEM) ? 'true' : 'false';
$studentPicker = new StudentPicker($dbConn, $newsnummer, 'Search and select participant to add.');
$newsnummer = $studentPicker->processRequest();
if (isset($_REQUEST['baccept']) && $newsnummer != 0) {
// try to insert this snummer into max prj_grp
$sql = "insert into project_scribe (prj_id,scribe) values({$prj_id},{$newsnummer})\n";
$dbConn->Execute($sql);
$dbConn->log($sql);
// $dbConn->log($dbConn->ErrorMsg());
}
if (isset($_REQUEST['bdelete']) && $newsnummer != 0) {
// try to insert this snummer into max prj_grp
if (!preg_match('/;/', $_REQUEST['searchname'])) {
$searchname = $_REQUEST['searchname'];
$studentPicker->setSearchString($searchname);
if (!isset($_REQUEST['newauditor'])) {
$newauditor = $studentPicker->findStudentNumber();
}
} else {
$searchname = '';
}
$_SESSION['searchname'] = $searchname;
} else {
$studentPicker->setSearchString($_SESSION['searchname']);
}
$_SESSION['searchname'] = $searchname;
// test if this owner can update this project
$isTutorOwner = checkTutorOwner($dbConn, $prj_id, $tutor_code);
if (($isTutorOwner || $isGroupTutor) && isset($_REQUEST['bsetgid']) && $newauditor != 0) {
$gids = join(',', $_REQUEST['gid']);
$sql = "begin work;" . " insert into project_auditor (snummer,prjm_id,gid) \n" . " select {$newauditor},prjm_id,grp_num as gid from \n" . "(select {$newauditor} as snummer ,prjm_id,0 as grp_num from prj_tutor where prjm_id={$prjm_id} \n" . " union select {$newauditor} as snummer,prjm_id,grp_num from prj_tutor where prjm_id={$prjm_id}) pt \n" . " where grp_num in ({$gids}) " . " and ({$newauditor},prjm_id,grp_num) not in (select snummer,prjm_id,gid from project_auditor);\n" . "commit";
$dbConn->Execute($sql);
// $dbConn->log($sql);
// $dbConn->log($dbConn->ErrorMsg());
}
//
pagehead('Add project auditor.');
$page_opening = "Add project auditor to a project. prj_id {$prj_id} milestone {$milestone} prjm_id {$prjm_id}";
$nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening);
$nav->setInterestMap($tabInterestCount);
echo $nav->show();
?>
<div id='navmain' style='padding:1em;'>
