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;'>