$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
$sql = "delete from project_scribe where scribe={$newsnummer} and prj_id={$prj_id}\n";
$dbConn->Execute($sql);
$dbConn->log($sql);
// $dbConn->log($dbConn->ErrorMsg());
}
requireCap(CAP_EDIT_RIGHTS);
require_once 'bitset.php';
require_once 'studentpicker.php';
$newsnummer = $peer_id;
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
$cap_names = array('CAP_TUTOR', 'CAP_MKPROJECT', 'CAP_MKCLASSES', 'CAP_ALTER_STUDENT', 'CAP_ALTER_STUDENT_CLASS', 'CAP_LOOKUP_STUDENT', 'CAP_IMPERSONATE_STUDENT', 'CAP_TUTOR_OWNER', 'CAP_RECRUITER', 'CAP_STUDENT_ADMIN', 'CAP_TUTOR_ADMIN', 'CAP_SUBVERSION', 'CAP_SHARING', 'CAP_JAAG', 'CAP_SYSTEM', 'CAP_MENU_ADMIN', 'CAP_EDIT_RIGHTS', 'CAP_MODULE', 'CAP_GIT', 'CAP_SELECT_ALL', 'CAP20', 'CAP21', 'CAP22', 'CAP23', 'CAP24', 'CAP25', 'CAP26', 'CAP27', 'CAP28', 'CAP29', 'CAP_BIGFACE', 'CAP31');
$caps = 0;
$dbMsg = '';
extract($_SESSION);
// if (isSet($_REQUEST['capuserid'])) {
// $capuserid = $_REQUEST['capuserid'];
// }
$studentPicker = new StudentPicker($dbConn, $newsnummer, 'Search user.');
$studentPicker->setShowAcceptButton(false);
$studentPicker->setPresentQuery("select userid as snummer from passwd");
$newsnummer = $studentPicker->processRequest();
$student_picker_text = $studentPicker->getPicker();
if (isset($_REQUEST['capability'])) {
$caps = collectBitSet($_REQUEST['capability']);
}
if (isset($_REQUEST['setcap']) && isset($newsnummer) && $newsnummer != 0) {
$sql = "update passwd set capabilities={$caps} where userid={$newsnummer}";
$resultSet = $dbConn->Execute($sql);
// $dbConn->log($sql);
if ($resultSet === false) {
$dbMsg = "error cause " + $dbConn->ErrorMsg();
}
}
unset($_POST['newsnummer']);
$_REQUEST['newsnummer'] = $newsnummer = validate($_GET['newsnummer'], 'integer', '0');
// $dbConn->log('GET '.$newsnummer);
} else {
if (isset($_POST['newsnummer'])) {
unset($_GET['newsnummer']);
$_REQUEST['newsnummer'] = $newsnummer = validate($_POST['newsnummer'], 'integer', '0');
// $dbConn->log('POST '.$newsnummer);
} else {
unset($_POST['newsnummer']);
unset($_REQUEST['newsnummer']);
unset($_GET['newsnummer']);
}
}
$searchname = '';
$studentPicker = new StudentPicker($dbConn, $newsnummer, 'Search and select participant to add.');
if (isset($_REQUEST['searchname'])) {
if (!preg_match('/;/', $_REQUEST['searchname'])) {
$searchname = $_REQUEST['searchname'];
$studentPicker->setSearchString($searchname);
if (!isset($_REQUEST['newsnummer'])) {
$newsnummer = $studentPicker->findStudentNumber();
}
} else {
$searchname = '';
}
$_SESSION['searchname'] = $searchname;
} else {
$_SESSION['searchname'] = $searchname;
$studentPicker->setSearchString($_SESSION['searchname']);
}
unset($_POST['newauditor']);
$_REQUEST['newauditor'] = $newauditor = validate($_GET['newauditor'], 'snummer', '0');
// $dbConn->log('GET '.$newauditor);
} else {
if (isset($_POST['newauditor'])) {
unset($_GET['newauditor']);
$_REQUEST['newauditor'] = $newauditor = validate($_POST['newauditor'], 'snummer', '0');
// $dbConn->log('POST '.$newauditor);
} else {
unset($_POST['newauditor']);
unset($_REQUEST['newauditor']);
unset($_GET['newauditor']);
}
}
$searchname = '';
$studentPicker = new StudentPicker($dbConn, $newauditor, 'Search and select auditor.');
$studentPicker->setInputName('newauditor');
if (isset($_REQUEST['searchname'])) {
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']);
}
unset($_GET['newsnummer']);
}
}
if (isset($_REQUEST['act_id'])) {
$_SESSION['act_id'] = $act_id = validate($_REQUEST['act_id'], 'integer', $act_id);
}
$_SESSION['act_id'] = $act_id;
if (isset($act_id) && $act_id >= 0) {
$sql = "select act_id,short,description,datum,part,start_time from activity where act_id={$act_id}";
$rs = $dbConn->Execute($sql);
if (!$rs->EOF) {
extract($rs->fields);
}
}
$searchname = '';
$studentPicker = new StudentPicker($dbConn, $newsnummer, 'Search and select participant to add.');
if (isset($_REQUEST['searchname'])) {
# $dbConn->log($_REQUEST['searchname']);
if (!preg_match('/;/', $_REQUEST['searchname'])) {
$searchname = $_REQUEST['searchname'];
$studentPicker->setSearchString($searchname);
if (!isset($_REQUEST['newsnummer'])) {
$newsnummer = $studentPicker->findStudentNumber();
}
} else {
$searchname = '';
}
$_SESSION['searchname'] = $searchname;
} else {
$studentPicker->setSearchString($searchname);
}
<?php
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);
}
