// 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();
$page_opening = "Add project scribe" . "<span style='font-size:8pt;'>prj_id {$prj_id} milestone {$milestone} prjm_id {$prjm_id}</span>";
$page->setTitle('Add a project scribe');
$nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening);
$page->addBodyComponent($nav);
$templatefile = 'templates/addscribe.html';
$template_text = file_get_contents($templatefile, true);
$studentPicker->setPresentQuery("select scribe as snummer from project_scribe where prj_id={$prj_id}");
$student_picker_text = $studentPicker->getPicker();
$scribeQuery = "select snummer,achternaam,roepnaam,voorvoegsel from student\n" . "where snummer in (select scribe from project_scribe where prj_id={$prj_id}) order by achternaam,roepnaam";
$scribeTable = simpleTableString($dbConn, $scribeQuery, "<table summary='students found' border='1' style='border-collapse:collapse'>");
if ($template_text === false) {
$page->addBodyComponent(new Component("<strong>cannot read template file {$templatefile}</strong>"));
} else {
eval("\$text = \"{$template_text}\";");
$page->addBodyComponent(new Component($text));
}
$page->show();
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);
if ($resultSet === false) {
