$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 $sql = "delete from project_scribe where scribe={$newsnummer} and prj_id={$prj_id}\n"; $dbConn->Execute($sql); $dbConn->log($sql); // $dbConn->log($dbConn->ErrorMsg()); } $page = new PageContainer();
require_once './peerlib/peerutils.inc'; include_once 'navigation2.inc'; requireCap(CAP_EDIT_RIGHTS); require_once 'bitset.php'; require_once 'studentpicker.php'; $newuserid = $peer_id; /* * To change this template, choose Tools | Templates * and open the template in the editor. */ $dbMsg = ''; extract($_SESSION); $tutorPicker = new StudentPicker($dbConn, $newuserid, 'Search tutor.'); $tutorPicker->setShowAcceptButton(false); $tutorPicker->setPresentQuery("select userid as snummer from tutor"); $newuserid = $tutorPicker->processRequest(); $tutor_picker_text = $tutorPicker->getPicker(); $cluster_widget = "<table border='1' style='border-collapse:collapse; width:100%'>\n"; if (isset($_REQUEST['class_cluster']) && isset($_REQUEST['newuserid'])) { $newuserid = $_REQUEST['newuserid']; $sql1 = "begin work;\n" . "delete from tutor_class_cluster where userid={$newuserid};\n"; for ($i = 0; $i < count($_REQUEST['class_cluster']); $i++) { if ($_REQUEST['cluster_order'][$i] > 0) { $sql1 .= "insert into tutor_class_cluster select {$newuserid},{$_REQUEST['class_cluster'][$i]},{$_REQUEST['cluster_order'][$i]};\n"; } } $sql1 .= "commit;\n"; $rs = $dbConn->Execute($sql1); } $sql = "select cluster_name, cluster_description, class_cluster,sort_order,coalesce(cluster_order,0) as cluster_order\n" . " from class_cluster left join (select class_cluster,cluster_order from tutor_class_cluster where userid={$newuserid}) tcc using(class_cluster)\n" . "order by sort_order"; $resultSet = $dbConn->Execute($sql);