public function overwriteRead($return)
{
$return = parent::overwriteRead($return);
$objs = $return['objs'];
foreach ($objs as $obj) {
if (isset($obj->container_active)) {
$obj->container_active = $this->arrayYesNO[$obj->container_active];
}
if (isset($obj->container_parent_id)) {
$pc = new PageContainer();
if ($obj->container_parent_id > 0) {
$pc->getByID($obj->container_parent_id);
$txt = $pc->container_name;
} else {
$txt = Lang::t("No Parent");
}
$obj->container_parent_id = $txt;
}
}
return $return;
}
extract($resultSet->fields);
$_SESSION['prj_id'] = $prj_id;
$_SESSION['milestone'] = $milestone;
$_SESSION['prjm_id'] = $prjm_id;
$_SESSION['prjtg_id'] = $prjtg_id;
}
}
$sql = "select afko as abbriviation,description,year,comment from project where prj_id={$prj_id}";
$resultSet = $dbConn->Execute($sql);
if ($resultSet === false) {
die('Error: ' . $dbConn->ErrorMsg() . ' with ' . $sql);
}
if (!$resultSet->EOF) {
extract($resultSet->fields);
}
$page = new PageContainer();
$page->setTitle('Peer (re)viewable portfolio');
$page_opening = "Welcome to the upload page of {$roepnaam} {$voorvoegsel} {$achternaam} ({$snummer})";
$nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening);
$nav->setInterestMap($tabInterestCount);
$nav->addLeftNavText(file_get_contents('news.html'));
ob_start();
tutorHelper($dbConn, $isTutor);
$page->addBodyComponent(new Component(ob_get_clean()));
$page->addBodyComponent($nav);
$ob_start = ob_start();
$sql = "SELECT roepnaam, voorvoegsel,achternaam,lang FROM student WHERE snummer={$snummer}";
$resultSet = $dbConn->Execute($sql);
if ($resultSet === false) {
die('Error: ' . $dbConn->ErrorMsg() . ' with ' . $sql);
}
public function subconMenu($mode)
{
?>
<style>
.pagecon{
text-decoration: underline;
color: #0066cc;
line-height: 30px;
text-align: center;
}
</style>
<div class="col-md-3 ">
<div style="margin: 10px; border:1px solid #dedede; margin-left: 40px; border-radius: 10px;">
<div style="font-size:15px; background-color: #efefef; padding: 5px;"><?php
echo Lang::t('Sub Container');
?>
</div>
<?php
$pc = new PageContainer();
$parenttext = "AND container_parent_id = '{$mode}'";
$arrGal = $pc->getWhere("container_active =1 {$parenttext} ORDER BY container_name ASC");
//pr($arrGal);
if (count($arrGal) == 0) {
?>
<div style="line-height: 30px; font-size: 12px; text-align: center;">
<?php
echo Lang::t('No SubContainer yet');
?>
</div>
<?php
}
foreach ($arrGal as $pcsub) {
?>
<div class="pagecon"><a href="<?php
echo _SPPATH;
?>
pagecontainer?mode=<?php
echo $pcsub->container_id;
?>
"><?php
echo $pcsub->container_name;
?>
</a></div>
<?php
}
?>
</div>
</div><?php
}
}
$subSelect = $cols . "\n from" . $join;
// $dbConn->log($subSelect);
}
$grades = "";
$con = '';
foreach ($gradeColumns as $grade) {
$grades .= $con . "subselect.{$grade},subselect.{$grade}_mul";
$con = "\n\t,";
}
$sql = "select snummer,achternaam,roepnaam,voorvoegsel, afko, year, \n" . "milestone,grp_num,\"alias\",tutor,\"role\",{$grades},sw.final_grade \n" . "from prj_grp join all_prj_tutor using(prjtg_id)\n" . " join student using(snummer) \n" . " left join milestone_grade using(prjm_id,snummer)\n" . " left join student_role using (prjm_id,snummer)\n" . " left join project_roles using (prj_id,rolenum)\n" . " join ({$subSelect}) subselect using(snummer)\n" . " left join (select snummer,round(grade_weight_sum/w.weight_sum,1) \n" . " as final_grade from project_grade_weight_sum_product\n" . " cross join (select weight_sum from project_weight_sum where prj_id={$prj_id}) w where prj_id={$prj_id} ) sw using(snummer)\n" . "where prjm_id={$prjm_id} order by grp_num,achternaam,roepnaam";
$pp = array();
$dbConn->log($sql);
$spreadSheetWriter = new SpreadSheetWriter($dbConn, $sql);
$title = "Results for all participants in project {$afko} {$year} milestone {$milestone}";
$spreadSheetWriter->setFilename($filename)->setLinkUrl($server_url . $PHP_SELF)->setTitle($title)->setColorChangerColumn(7);
//->setRowParser( new RowWithArraysParser());
$spreadSheetWriter->processRequest();
$pp['spreadSheetWidget'] = $spreadSheetWriter->getWidget();
$page = new PageContainer();
$page->setTitle('Get group tables');
$page_opening = "Group lists for project {$afko} {$description} <span style='font-size:8pt;'>prjm_id {$prjm_id} prj_id {$prj_id} milestone {$milestone} </span>";
$nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening);
$nav->setInterestMap($tabInterestCount);
$rainbow = new RainBow();
$pp['rtable'] = getQueryToTableChecked($dbConn, $sql, false, 7, $rainbow, -1, '', '');
$pp['selector'] = $prjSel->getSelector();
$pp['selectionDetails'] = $prjSel->getSelectionDetails();
$page->addBodyComponent($nav);
$page->addHtmlFragment('templates/milestonegrades.html', $pp);
$page->show();
$_SESSION['hourcode'] = $hourcode = validate($_REQUEST['hourcode'], 'integer', 1);
}
// get project data
$sql = "select * from project where prj_id={$presence_prj_id}";
$resultSet = $dbConn->Execute($sql);
if ($resultSet == false) {
die("<br>Cannot get project data with <pre>{$sql}</pre> cause" . $dbConn->ErrorMsg() . "<br>");
}
extract($resultSet->fields);
if (isset($_REQUEST['personal_presence'])) {
$_SESSION['personal_presence'] = $personal_presence = $_REQUEST['personal_presence'] == 'Y' ? 'Y' : 'N';
}
if ($personal_presence == 'Y') {
$page_opening = "Presence of {$roepnaam} {$voorvoegsel} {$achternaam}, <span style='font-size:6pt;'>({$snummer})</span>";
} else {
$page_opening = "Student presence for participants of module {$presence_prj_id} {$afko}, {$year} {$description}";
}
$page = new PageContainer();
$page->setTitle('Presence during fontys timetable hours');
$page_opening = "Presence of {$roepnaam} {$voorvoegsel} {$achternaam} ({$snummer})";
$nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening);
$nav->setInterestMap($tabInterestCount);
$nav->addLeftNavText(file_get_contents('news.html'));
ob_start();
tutorHelper($dbConn, $isTutor);
$page->addBodyComponent(new Component(ob_get_clean()));
$page->addBodyComponent($nav);
ob_start();
include_once 'presence1.php';
$page->addBodyComponent(new Component(ob_get_clean()));
$page->show();
$mailbody = preg_replace('/"/', '\'', $_POST['mailbody']);
// $dbConn->log($mailbody);
}
if (isset($_POST['formsubject'])) {
$formsubject = $_POST['formsubject'];
}
if (isset($_POST['snmailto']) && isset($_POST['domail'])) {
$snmailto = $_POST['snmailto'];
$mailset = '\'' . implode("','", $snmailto) . '\'';
$sql = "select distinct email1,email2, tutor_email, \n" . "s.roepnaam ||' '||coalesce(s.voorvoegsel,'')||' '||s.achternaam as name\n" . ", afko, description,milestone,assessment_due as due \n" . " from prj_grp pg \n" . " join student s on (s.snummer=pg.snummer) \n" . " join prj_tutor pt on(pt.prjtg_id=pg.prjtg_id) \n" . " join tutor t on(userid=tutor_id) \n" . " join prj_milestone pm on(pt.prjm_id=pm.prjm_id) \n" . " join project p on (pm.prj_id=p.prj_id)\n" . " join tutor_data td on (pt.tutor_id=td.tutor_id)" . " left join alt_email aem on (s.snummer=aem.snummer)\n" . "where s.snummer in ({$mailset}) and pm.prjm_id={$prjm_id}";
$dbConn->log($sql);
formMailer($dbConn, $sql, $formsubject, $mailbody, $sender, $sender_name);
}
$page_opening = "These students are overdue with filling in their peer assessment forms.";
$nav = new Navigation(array(), basename($PHP_SELF), $page_opening);
$page = new PageContainer();
$page->addBodyComponent($nav);
ob_end_clean();
if (hasCap(CAP_SYSTEM)) {
$tutor_select = "";
} else {
$tutor_select = " and (tutor='{$tutor}' or tutor_owner='{$tutor}') ";
}
ob_start();
$prjSel->setWhere("assessment_due <now() and pm.prj_milestone_open=true");
$prj_id_selector = $prjSel->getWidget();
$sqlhead = "select afko as code,pm.milestone as milstn,pt.grp_num,\n" . "s.snummer as snmailto,s.snummer,\n" . "achternaam||coalesce(', '||voorvoegsel,'') as achternaam\n" . ",roepnaam, s.snummer,pm.assessment_due as due,tutor\n";
$sqllate = "( select distinct snummer from prj_grp \n" . "natural join prj_tutor pt \n" . "join tutor t on(userid=tutor_id)\n" . "natural join prj_milestone \n" . "where written =false \n" . "and prj_milestone_open=true \n" . "and prj_grp_open=true \n" . "and assessment_due < now()::date \n" . "and prjm_id={$prjm_id})";
$sqltail = " \n" . " join milestone_open_past_due mopd on(jnr.prjtg_id=mopd.prjtg_id)" . " join prj_grp_open pgo on(pgo.prjtg_id=jnr.prjtg_id)\n" . " join student s on (jnr.snummer=s.snummer) \n" . " join prj_tutor pt on(jnr.prjtg_id=pt.prjtg_id)\n" . " join tutor t on(userid=tutor_id)\n" . " join prj_milestone pm on(pt.prjm_id=pm.prjm_id)\n" . " join project p on(p.prj_id=pm.prj_id)\n" . " where pm.prjm_id={$prjm_id}\n";
//$dbConn->log($sql);
$latecountsql = "select count(*) as latecount from {$sqllate} foo";
domail($triggerList, $subject, "See the subject.\n" . "One way to read your mail there is to visit " . "http://webmail.fontys.nl\n---\nKind Regards,\n Peerweb services", 'From: peerweb@fontysvenlo.org');
//$headers
}
}
$prjSel->setJoin('milestone_grp using (prj_id,milestone)');
$prjList = $prjSel->getSelector();
$sql = "select * from student\n" . "where snummer={$peer_id}";
$resultSet = $dbConn->Execute($sql);
if ($resultSet === false) {
print "error fetching judge data with {$sql} : " . $dbConn->ErrorMsg() . "<br/>\n";
}
if (!$resultSet->EOF) {
extract($resultSet->fields);
}
$page_opening = "Email to group members From: {$roepnaam} {$voorvoegsel} {$achternaam} <span style='font-family: courier'><{$email1}></span>";
$page = new PageContainer();
$page->setTitle('Mail-list page');
$nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening);
$page->addBodyComponent($nav);
$page->addFileContentsOnce('templates/tinymce_include.html');
$page->addHeadText('<script type="text/javascript">
function checkThem(ref,state){
var checks = document.getElementsByName(ref);
var boxLength = checks.length;
for ( i=0; i < boxLength; i++ ) {
checks[i].checked = state;
}
}
function unCheckThem(ref){
var checks = document.getElementsByName(ref);
var boxLength = checks.length;
$close_button = " ";
if ($isTutorOwner) {
$deleteButton = "<input type='submit' name='delete' value='Delete members' " . "title='Throw members out of this project' />";
$updateButton = "<button type='submit' name='bmove' value='Move' " . "title='Update the group composition' >Move student(s)</button>";
$sql = "select prj_milestone_open from prj_milestone where prjm_id={$prjm_id}";
$resultSet = $dbConn->Execute($sql);
if ($resultSet === false) {
print "<br>Cannot get open close data <pre>{$sql}</pre>, cause" . $dbConn->ErrorMsg() . "<br>";
}
$assessment_open = false;
while (!$resultSet->EOF) {
$assessment_open = $assessment_open || $resultSet->fields['prj_milestone_open'] == 't';
$resultSet->moveNext();
}
}
$page = new PageContainer();
$page_opening = "Put participants into groups";
$page_opening = "Select participants into project groups " . "<span style='font-size:8pt;'>prj_id {$prj_id} milestone {$milestone} prjm_id {$prjm_id}</span>";
$page->setTitle('Put participants into groups');
$nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening);
extract(getTutorOwnerData2($dbConn, $prjm_id), EXTR_PREFIX_ALL, 'ot');
$page->addBodyComponent($nav);
$templatefile = 'templates/defgroupmembers3.html';
$ie_warning = strpos($_SERVER['HTTP_USER_AGENT'], 'MSIE') ? "Internet Exploder is not supported" : "";
$template_text = file_get_contents($templatefile, true);
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));
}
$_SESSION['prj_id'] = $prj_id;
$_SESSION['prjm_id'] = $prjm_id;
$_SESSION['milestone'] = $milestone;
$filename = 'presencelist_' . $afko . '-' . date('Ymd') . '.csv';
$csvout = 'N';
$csvout_checked = '';
if (isset($_REQUEST['csvout'])) {
$csvout = $_REQUEST['csvout'];
$csvout_checked = $csvout == 'Y' ? 'checked' : '';
}
//pagehead2("Presence list to $afko $year $description");//,$scripts);
$prj_id_selector = $prjSel->getSelector();
$selection_details = $prjSel->getSelectionDetails();
$sql = "select st.snummer,roepnaam||coalesce(' '||voorvoegsel||' ',' ')||achternaam as name," . " '#'||task_number||': '||apt.afko||': '||apt.description as checktitle,\n" . " pt.name as task_name,\n" . " coalesce(grade::text,mark) as check, ptc.comment as title,photo,grp_num \n" . " from prj_grp join all_prj_tutor apt using(prjtg_id)\n" . " natural join student st \n" . " join portrait tp using (snummer) \n" . " join project_task pt using(prj_id)\n" . " left join project_task_completed_latest ptc using(snummer,task_id)\n" . " where prj_id={$prj_id} \n" . " order by grp_num,achternaam,roepnaam, task_number\n";
$dbConn->log($sql);
$page = new PageContainer();
include 'js/balloonscript.php';
$page->setTitle('Overview of tasks completed');
$page->addHeadComponent(new Component("<style type='text/css'>\n *.notered { \n\tbackground-image:url('images/redNote.png');\n }\n *.notegreen { \n\tbackground-image:url('images/greenNote.png');\n }\n *.noteblue { \n\tbackground-image:url('images/blueNote.png');\n }\n </style>"));
$page_opening = "Task completed list for project {$afko} {$description} prj_id {$prj_id}";
$nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening);
$page->addBodyComponent($nav);
$tableBuilder = new TableBuilder($dbConn, new TaskRowFactory());
$task_table = $tableBuilder->getTable($sql, 'snummer');
$templatefile = 'templates/taskoverview.html';
$template_text = file_get_contents($templatefile, true);
$text = '';
if ($template_text === false) {
$text = "<strong>cannot read template file {$templatefile}</strong>";
} else {
eval("\$text = \"{$template_text}\";");
// insert into session
$_SESSION['class_ids'] = $class_ids;
}
$prj_id = isset($_SESSION['prj_id']) ? $_SESSION['prj_id'] : -1;
extract(getTutorOwnerData($dbConn, $prj_id), EXTR_PREFIX_ALL, 'ot');
$_SESSION['prj_id'] = $prj_id = $ot_prj_id;
$isTutorOwner = $ot_tutor == $tutor_code;
if ($isTutorOwner) {
$submit_button = '<button name=\'bsubmit\' value=\'submit\'>Submit</button>';
} else {
$submit_button = '';
}
$resultSet = $dbConn->execute("select count(*) as participants from prj_grp join prj_tutor using(prjtg_id) where prjm_id={$prjm_id}");
extract($resultSet->fields);
// generating output
$page = new PageContainer();
$page->setTitle('Select participating student_class');
$page_opening = "Select the student_class of the participating students";
$nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening);
$page->addBodyComponent($nav);
$resultSet = $dbConn->Execute("select afko,description from project where prj_id={$prj_id}");
extract($resultSet->fields);
$form1Form = new HtmlContainer("<div id='projectsel'>");
$prjSel->setJoin(" (select distinct prjm_id from prj_milestone natural join project where owner_id={$peer_id}) p_mil using (prjm_id)");
//$dbConn->log($prjSel->getQuery());
$form1Form->addText($prjSel->getWidget());
$form2Form = new HtmlContainer("<form method='post' name='group_def' action='{$PHP_SELF}'>");
//$form2Table = new HtmlContainer( "<table border='3' style='border-collapse:3d; padding:2pt;'" .
// " align='left' rules='groups' frame='box'" .
// "summary='class selection' id='form2table'>" );
$form2Table = new HtmlContainer("<div id='tabs'>");
</option>
<?php
}
?>
</select>
<span class="help-block" id="warning_post_gallery_id"></span>
</div>
</div>
<div id="formgroup_post_subcon_id" class="form-group">
<label for="post_subcon_id" class="col-sm-2 control-label"><?php
echo Lang::t('post_subcon_id');
?>
</label>
<div class="col-sm-10">
<?php
$gal2 = new PageContainer();
if ($cid != "") {
$parenttext = "AND container_parent_id = '{$cid}'";
} else {
$parenttext = "AND container_parent_id != '0'";
}
$arrGal = $gal2->getWhere("container_active =1 {$parenttext} ORDER BY container_name ASC");
?>
<select class="form-control" name="post_subcon_id" id="post_subcon_id">
<option value="0"><?php
echo Lang::t('No Subcontainer');
?>
</option>
<?php
foreach ($arrGal as $gal) {
?>
$memberset = '\'' . implode("','", $_POST['studenten']) . '\'';
$sql = "update student set hoofdgrp=substr('{$newhoofdgrp}',1,10) " . "where snummer in ({$memberset})";
$resultSet = $dbConn->Execute($sql);
if ($resultSet === false) {
die("<br>Cannot update student with " . $sql . " reason " . $dbConn->ErrorMsg() . "<br>");
}
}
if (isset($_POST['maillist'])) {
createGenericMaillistByClassid($dbConn, $oldclass_id);
}
$pp['mailalias'] = $prefix . '@fontysvenlo.org';
$oclassSelectorClass = new ClassSelectorClass($dbConn, $oldclass_id);
$pp['oldClassSelector'] = $oclassSelectorClass->setSelectorName('oldclass_id')->addConstraint('student_count <>0')->setAutoSubmit(true)->getSelector();
$nclassSelectorClass = new ClassSelectorClass($dbConn, $newclass_id);
$pp['newClassSelector'] = $nclassSelectorClass->setSelectorName('newclass_id')->getSelector();
$page = new PageContainer();
$page_opening = "Move students between student_class.";
$page->setTitle($page_opening);
$nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening);
$nav->setInterestMap($tabInterestCount);
$page->addBodyComponent($nav);
$css = '<link rel=\'stylesheet\' type=\'text/css\' href=\'' . SITEROOT . '/style/tablesorterstyle.css\'/>';
$page->addScriptResource('js/jquery.js');
$page->addScriptResource('js/jquery.tablesorter.js');
$page->addHeadText($css);
$page->addJqueryFragment('$("#myTable").tablesorter({widgets: [\'zebra\'],headers: {0:{sorter:false}}});
var table = $("#myTable");
table.bind("sortEnd",function() {
var i = 0;
table.find("tr:gt(0)").each(function(){
$(this).find("td:eq(0)").text(i);
$rights = '{' . $groupRead . ',' . $projectRead . '}';
$doctype = $_POST['doctype'];
$mime_type = $_POST['mime_type'];
$new_prjtg_id = $_POST['new_prjtg_id'];
$sql = "update uploads \n" . "set title='{$doc_title}'," . "\t rights='{$rights}', " . "\t doctype={$doctype}," . "\t mime_type=substr('{$mime_type}',1,64),\n " . "\t mime_type_long='{$mime_type}',\n" . "\t prjtg_id={$new_prjtg_id}\n " . "where upload_id={$doc_id}";
$dbConn->log($sql);
$resultSet = $dbConn->execute($sql);
}
if (isset($_REQUEST['delete_critique'])) {
$critique_id = validate($_REQUEST['critique_id'], 'integer', 1);
$sql = "update document_critique set deleted=true where critique_id={$critique_id}";
$resultSet = $dbConn->execute($sql);
}
// debug hack
//$_GET['doc_id'] = 1;
$page = new PageContainer();
$page->setTitle('Document and feedback viewer');
if (!isset($_REQUEST['doc_id'])) {
echo "<p>To critisize a document you should select a document from the <a href='uploadviewer.php'>documents page</a> " . "and click on the critisizeable document</p>";
} else {
// a document is selected
$doc_id = validate($_REQUEST['doc_id'], 'doc_id', 0);
$sql = "select upload_id,title, to_char(uploadts,'YYYY-MM-DD HH24:MI')::text as uploadts,due,mime_type,\n" . "ups.snummer as author,achternaam,voorvoegsel,roepnaam,apt.prj_id,apt.prjm_id,apt.milestone,apt.afko,apt.description as project_description,\n" . "apt.year,apt.grp_num, ups.prjtg_id,rel_file_path, coalesce(apt.alias,'g'||apt.grp_num) as grp_name,\n" . " coalesce('g'||apts.grp_num||' '''||apts.alias||'''','g'||apts.grp_num)||' tutor '||apts.tutor as sgrp_name,\n" . "vers, pd.doctype,udt.description as documenttype,apt.long_name,ups.rights[0:2] as rights,\n" . "getDocAuthors({$doc_id}) as coauthors,filesize \n" . "from (uploads ups join student std using(snummer) \n" . "join all_prj_tutor apt using(prjtg_id)) \n" . "join (all_prj_tutor join prj_grp using (prjtg_id)) apts on (apts.snummer=ups.snummer and apts.prjm_id =ups.prjm_id)\n" . "join uploaddocumenttypes udt on (apt.prj_id=udt.prj_id and ups.doctype=udt.doctype) \n" . "join project_deliverables pd on(apt.prjm_id=pd.prjm_id and ups.doctype=pd.doctype)" . " where upload_id={$doc_id}";
$resultSet = $dbConn->execute($sql);
if ($resultSet === false) {
die('Error: ' . $dbConn->ErrorMsg() . ' with <br/><pre>' . $sql . '</pre>');
}
if (!$resultSet->EOF) {
extract($resultSet->fields);
$author = $resultSet->fields['author'];
$pp = array_merge($pp, $resultSet->fields);
<?php
include_once './peerlib/peerutils.inc';
require_once './peerlib/simplequerytable.inc';
requireCap(CAP_TUTOR);
$page_opening = 'Select or define a project ';
$page = new PageContainer();
$page->setTitle('Fontys knwon courses');
$nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening);
$nav->setInterestMap($tabInterestCount);
$form1 = new HtmlContainer('<fieldset id=\'fieldset1\'><legend>Fontys courses known by peerweb</legend>');
$sql = "select course," . "rtrim(course_description)," . "faculty,faculty_short as inst from fontys_course join faculty using(faculty_id)";
ob_start();
simpletable($dbConn, $sql, '<table border=\'1\' style=\'border-collapse:collapse\' summary=\'table of courses\'>');
$form1->addText(ob_get_clean());
$page->addBodyComponent($form1);
$page->addBodyComponent(new Component('<!-- db_name=$db_name $Id: known_courses.php 1723 2014-01-03 08:34:59Z hom $ -->'));
$page->addBodyComponent($nav);
$page->show();
<?php
/**
* The simple table editor for the tutor
* @author Pieter van den Hombergh
* $Id: bigface_settings.php 1723 2014-01-03 08:34:59Z hom $
*/
include_once "ste.php";
$page = new PageContainer();
$page->setTitle("Bigface settings on DB " . $db_name);
$ste = new SimpleTableEditor($dbConn, $page);
$ste->setFormAction($PHP_SELF)->setRelation('bigface_settings')->setMenuName('bigface_settings')->setKeyColumns(array('bfkey'))->setNameExpression("rtrim(bfkey)")->setListRowTemplate(array('bfkey', 'bfvalue', 'comment'))->setOrderList(array('bfkey'))->setFormTemplate('templates/bigface_settings.html')->show();
} else {
if (!$resultSet->EOF) {
$pp = array_merge($pp, $resultSet->fields);
extract($resultSet->fields);
}
}
// get definition of role 1 for this project
$sql = "select coalesce('That is '||short||': '||role||' for this project','') as role_one \n" . "from project_roles where prj_id={$prj_id} and rolenum=1";
//$dbConn->log($sql);
$resultSet = $dbConn->Execute($sql);
if ($resultSet !== false && !$resultSet->EOF) {
extract($resultSet->fields);
$pp = array_merge($pp, $resultSet->fields);
}
$page_opening = "Data for active group {$grp_num}";
$page = new PageContainer();
$page->setTitle('Project group data');
$nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening);
ob_start();
tutorHelper($dbConn, $isTutor);
$page->addBodyComponent(new Component(ob_get_clean()));
$page->addBodyComponent($nav);
$pp['prjList'] = $prjSel->getWidget();
$sqlm = "select '<a href=''mailto:'||rtrim(email1)||'''>'||roepnaam||coalesce(' '||voorvoegsel||' ',' ')||achternaam||'</a>' as name," . "role\n" . " from prj_grp pg join student using (snummer)\n" . "join all_prj_tutor using(prjtg_id)\n" . " join student_role using (prjm_id,snummer)\n" . " join project_roles using(prj_id,rolenum)\n" . " where pg.prjtg_id={$prjtg_id} order by achternaam,roepnaam";
$pp['memberTable'] = simpleTableString($dbConn, $sqlm);
if (!$resultSet->EOF) {
$pp = array_merge($pp, $resultSet->fields);
extract($resultSet->fields);
$pp['field_alias'] = makeinputfor('alias', $alias, $may_change, 15);
$pp['field_long_name'] = makeinputfor('long_name', $long_name, $may_change, 40);
$pp['field_productname'] = makeinputfor('productname', $productname, $may_change, 60);
<?php
include_once './peerlib/peerutils.inc';
require_once './peerlib/validators.inc';
//require_once('rubberstuff.php');
include_once 'navigation2.inc';
require_once './peerlib/conffileeditor2.php';
requireCap(CAP_SYSTEM);
// anticipate a save initiated by user.
$saveResult = ConfFileEditor::save();
$page_opening = "Rubber editor file ";
$page = new PageContainer();
$page->setTitle($page_opening);
$nav = new Navigation($navtable, basename($PHP_SELF), $page_opening);
$page->addBodyComponent($nav);
if ($saveResult != '') {
$page->addBodyComponent(new Component($saveResult));
}
if (isset($_REQUEST['formEditFile'])) {
$_SESSION['formFileToEdit'] = $_REQUEST['formEditFile'];
}
$_SESSION['formFileToEdit'] = './templates/editform/html';
$pp = array();
$fileEditor = new ConfFileEditor($PHP_SELF, 'templates/formedit.html');
$fileEditor->setDescription("Edit query, template or tex file");
$fileEditor->getWidgetForPage($page);
$page->show();
//echo "<pre>{$sql}</pre>\n";
$resultSet = $dbConn->Execute($sql);
$dbConn->transactionEnd();
unset($_SESSION['gradeSet']);
}
}
$rows = "";
if (count($gradeSet)) {
$cands = implode(',', array_keys($gradeSet));
$sql = "select snummer, achternaam,roepnaam,coalesce(', '||voorvoegsel,'') as voorvoegsel " . "from student where snummer in ({$cands}) order by achternaam,roepnaam";
$resultSet = $dbConn->Execute($sql);
if ($resultSet === FALSE) {
die("error " . $dbConn->ErrorMsg() . "\n");
}
for (; !$resultSet->EOF; $resultSet->moveNext()) {
extract($resultSet->fields);
$rows .= "<tr><td><input type='hidden' name='cand[]' value='{$snummer}'/>{$snummer}</td><td>{$achternaam}{$voorvoegsel}</td>" . "<td>{$roepnaam}</td><td><input style='text-align:right' size='3' type='number' name='grade[]' min='0' max='10.0' step='0.1' value='{$gradeSet[$snummer]}'/></td></tr>\n";
}
if ($rows != "") {
$rows = "<table border='1' style='border-collapse:collapse;'>\n" . "<tr><th>snummer</th><th>lastname</th><th>name</th><th>grade</th></tr>" . $rows . "\n</table>\n";
}
}
$pp = array();
$pp['rows'] = $rows;
$pp['showInput'] = $showInput;
$pp['event'] = $event;
$page_opening = "Upload grades on DB {$db_name} ";
$nav = new Navigation(array(), basename($PHP_SELF), $page_opening);
$page = new PageContainer();
$page->addBodyComponent($nav);
$page->addHtmlFragment('templates/uploadGrades.php', $pp)->show();
<?php
require_once './peerlib/peerutils.inc';
include_once 'tutorhelper.inc';
require_once 'navigation2.inc';
/**
* @package peerweb
* @author Pieter van den Hombergh
* $Id: home.php 1761 2014-05-24 13:17:31Z hom $
* Redirect to real main page
*/
$page = new PageContainer();
$page->setTitle('Welcome to peerweb');
$page->addHeadComponent(new Component("\n<style type='text/css'>\n p {text-align: justify;}\n p:first-letter {font-size:180%; font-family: script;font-weight:bold; color:#800;}\n </style>"));
if (file_exists('fotos/' . $judge . '.jpg')) {
$foto = 'fotos/' . $judge . '.jpg';
} else {
$foto = 'fotos/0.jpg';
}
$lang = strtolower($lang);
$page_opening = "Hello {$roepnaam} {$voorvoegsel} {$achternaam} <a href='myface.php'><img src='{$foto}' alt='you' style='width:32px;height:auto;'/></a><span style='font-size:60%;'>({$snummer})</span>, this is <i>Peerweb</i>: the place where you share with your fellow students<br/> Click on your face to see yourselves a bit better.";
$nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening);
$nav->setInterestMap($tabInterestCount);
$nav->addLeftNavText(file_get_contents('news.html'));
ob_start();
tutorHelper($dbConn, $isTutor);
$page->addBodyComponent(new Component(ob_get_clean()));
$page->addBodyComponent($nav);
ob_start();
?>
<table class='layout' style='layout:fixed;border-collapse:collapse;' border='0' summary='layout'>
/**
* addToIndex
* @param string $strIndexPath
* @param string $strKey
* @param PageContainer $objParentPageContainer
* @author Thomas Schedler <*****@*****.**>
* @version 1.0
*/
protected final function addToIndex($strIndexPath, $strKey, $objParentPageContainer = null, $arrParentFolderIds = array())
{
try {
$this->core->logger->debug('massiveart->generic->data->types->GenericDataTypeAbstract->addToIndex(' . $strIndexPath . ', ' . $strKey . ')');
if (!is_object($this->objIndex) || !$this->objIndex instanceof Zend_Search_Lucene) {
if (count(scandir($strIndexPath)) > 2) {
$this->objIndex = Zend_Search_Lucene::open($strIndexPath);
} else {
$this->objIndex = Zend_Search_Lucene::create($strIndexPath);
}
}
Zend_Search_Lucene_Analysis_Analyzer::setDefault(new Zend_Search_Lucene_Analysis_Analyzer_Common_Utf8Num_CaseInsensitive());
$objDoc = new Zend_Search_Lucene_Document();
$objDoc->addField(Zend_Search_Lucene_Field::keyword('key', $strKey));
if ($this->setup->getLanguageFallbackId() > 0 && $this->setup->getLanguageFallbackId() != $this->setup->getLanguageId()) {
$objDoc->addField(Zend_Search_Lucene_Field::keyword('languageId', $this->setup->getLanguageFallbackId()));
} else {
$objDoc->addField(Zend_Search_Lucene_Field::keyword('languageId', $this->setup->getLanguageId()));
}
$objDoc->addField(Zend_Search_Lucene_Field::keyword('rootLevelId', $this->setup->getRootLevelId()));
$objDoc->addField(Zend_Search_Lucene_Field::unIndexed('date', $this->setup->getPublishDate('d.m.Y')));
$objDoc->addField(Zend_Search_Lucene_Field::unIndexed('elementTypeId', $this->setup->getElementTypeId()));
if ($objParentPageContainer !== null && $objParentPageContainer instanceof PageContainer) {
if (count($objParentPageContainer->getEntries()) > 0) {
$objDoc->addField(Zend_Search_Lucene_Field::unIndexed('parentPages', serialize($objParentPageContainer->getEntries())));
$objDoc->addField(Zend_Search_Lucene_Field::keyword('rootLevelId', end($objParentPageContainer->getEntries())->rootLevelId));
}
}
if (count($arrParentFolderIds) > 0) {
$objDoc->addField(Zend_Search_Lucene_Field::unStored('parentFolderIds', implode(',', $arrParentFolderIds)));
}
/**
* index fields
*/
foreach ($this->setup->FieldNames() as $strField => $intFieldType) {
$objField = $this->setup->getField($strField);
if (is_object($objField) && $objField->idSearchFieldTypes != Search::FIELD_TYPE_NONE) {
$this->indexFieldNow($objField, $strField, $intFieldType, $objField->getValue(), $objDoc);
}
}
foreach ($this->setup->MultiplyRegionIds() as $intRegionId) {
$objRegion = $this->setup->getRegion($intRegionId);
if ($objRegion instanceof GenericElementRegion) {
$intRegionPosition = 0;
foreach ($objRegion->RegionInstanceIds() as $intRegionInstanceId) {
$intRegionPosition++;
foreach ($objRegion->FieldNames() as $strField => $intFieldType) {
$objField = $objRegion->getField($strField);
if (is_object($objField) && $objField->idSearchFieldTypes != Search::FIELD_TYPE_NONE) {
$this->indexFieldNow($objField, $objField->name . '_' . $intRegionPosition, $intFieldType, $objField->getInstanceValue($intRegionInstanceId), $objDoc);
}
}
}
}
}
// Add document to the index.
$this->objIndex->addDocument($objDoc);
unset($objDoc);
$this->objIndex->optimize();
} catch (Exception $exc) {
$this->core->logger->err($exc);
}
}
<?php
require_once './peerlib/peerutils.inc';
require_once 'component.inc';
$page = new PageContainer();
$html = new HtmlContainer('<html>');
$page->setTitle('Welcome to peerweb');
$page->setBodyTag("<body id='body'>");
$navtop = new HtmlContainer("<div id='navtop' class='navopening'>");
$navtop->add(new Component('<h1>Hello World</h1>'));
$navmid = new HtmlContainer("<div id='navmid'>");
$navcol = new HtmlContainer("<div id='navcol' class='navcol'>");
// force page log
$dbConn->Execute("bogus sql");
$navcol->add(new Component("<table class='navcol'>\n\t\t\t <tr><th class='navcol'><img src='" . IMAGEROOT . "/filter.png' alt=''>Link1</th></tr>\n\t\t\t <tr><td class='navcol selected'><img src='" . IMAGEROOT . "/attach.gif' alt=''>Link1</td></tr>\n\t\t\t <tr><td class='navcol'><img src='" . IMAGEROOT . "/editcut.gif' alt=''>Link1</td></tr>\n</table>"));
// test if can add som more to navcol after adding navcol to parent.
$navcol->add($gif1 = new Component("<img src='" . IMAGEROOT . "/fireworks015.gif' alt=''>"));
$navmid->add($navcol);
$navcol->add($gif2 = new Component("<img src='" . IMAGEROOT . "/fireworks015.gif' alt='' style='background:black;'>"));
$navmain = new HtmlContainer("<div id='navmain' class='navmain'>");
$navmain->add(new Component("<h1 class='normal'>Main</h1>"));
$navmain->add(new Component("\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Praesent\ntempor. Nulla vel tortor. Suspendisse tristique viverra urna. Proin tristique\nsuscipit magna. Donec ut elit. Quisque ligula enim, sollicitudin vel, mollis\nquis, tincidunt sit amet, enim. Maecenas elit. Sed viverra leo at\npede. Phasellus vestibulum semper tellus. Ut facilisis. Fusce sed odio. </p>\n"));
$navmain->add(new Component("\n<p>Duis auctor massa sed turpis. Ut hendrerit urna. Sed vitae leo et neque\nelementum varius. Aenean ac nunc. Nulla congue. Praesent turpis nulla, tempus\nvitae, rutrum quis, pellentesque a, orci. Vestibulum placerat pellentesque\nmi. Vivamus cursus sapien nec nunc. Cras dolor lectus, vestibulum vel,\nimperdiet at, lobortis eu, mi. Pellentesque a libero. Sed ornare. Integer\nfeugiat luctus ipsum. Nulla ante. </p>\n<h2>Factum est</h2>\n<p>Sed vestibulum ullamcorper justo. Etiam eu sapien. Proin elit magna, varius\nquis, faucibus a, congue sit amet, mi. Nam accumsan justo sed sem. Vestibulum\nnibh ipsum, laoreet et, congue eget, posuere quis, lacus. Vivamus neque tellus,\nconvallis sit amet, rhoncus ac, accumsan et, nulla. Vestibulum eu\nsapien. Praesent eu massa at neque molestie porta. Nullam turpis. Nullam\nbibendum quam vitae enim. Suspendisse ligula turpis, mollis at, consectetuer\nsit amet, venenatis eu, dolor. Maecenas eu augue. Praesent vitae mauris. Proin\nrhoncus tincidunt eros. </p>\n \n<h3>Platea dictumst</h3>\n<p>In hac habitasse platea dictumst. In adipiscing justo eget lacus. Ut eget lacus\nquis purus posuere porttitor. In pretium. Etiam vulputate elit non purus. Donec\nac lacus et lectus ultricies cursus. Quisque erat turpis, blandit nec, nonummy\neu, auctor ornare, justo. Cras adipiscing pulvinar eros. Nullam dolor metus,\nsuscipit nec, ullamcorper id, posuere ut, wisi. Donec justo mauris, scelerisque\nid, feugiat eu, dictum ut, lacus. Nunc orci lectus, laoreet placerat, nonummy\neuismod, rhoncus in, tellus. Aenean feugiat est vel purus. Fusce tempor. Sed\naugue. </p>\n\nPellentesque malesuada arcu lacinia dui. Nunc feugiat ligula eget magna. Proin\nvarius. Duis eget quam. Ut non nibh. Nam a felis. Class aptent taciti sociosqu\nad litora torquent per conubia nostra, per inceptos hymenaeos. Cras quis metus\nin sapien tempor dignissim. Quisque id metus. Sed sed tellus et metus lacinia\nultricies. Fusce venenatis diam sed augue. Nunc libero diam, consequat in,\nplacerat et, rhoncus eu, tellus. Nullam mattis ultricies velit. Donec at nisl a\nmauris vulputate accumsan. Suspendisse non lorem. \n<p>Duis auctor massa sed turpis. Ut hendrerit urna. Sed vitae leo et neque\nelementum varius. Aenean ac nunc. Nulla congue. Praesent turpis nulla, tempus\nvitae, rutrum quis, pellentesque a, orci. Vestibulum placerat pellentesque\nmi. Vivamus cursus sapien nec nunc. Cras dolor lectus, vestibulum vel,\nimperdiet at, lobortis eu, mi. Pellentesque a libero. Sed ornare. Integer\nfeugiat luctus ipsum. Nulla ante. </p>\n<h2>Factum est</h2>\n<p>Sed vestibulum ullamcorper justo. Etiam eu sapien. Proin elit magna, varius\nquis, faucibus a, congue sit amet, mi. Nam accumsan justo sed sem. Vestibulum\nnibh ipsum, laoreet et, congue eget, posuere quis, lacus. Vivamus neque tellus,\nconvallis sit amet, rhoncus ac, accumsan et, nulla. Vestibulum eu\nsapien. Praesent eu massa at neque molestie porta. Nullam turpis. Nullam\nbibendum quam vitae enim. Suspendisse ligula turpis, mollis at, consectetuer\nsit amet, venenatis eu, dolor. Maecenas eu augue. Praesent vitae mauris. Proin\nrhoncus tincidunt eros. </p>\n \n<h3>Platea dictumst</h3>\n<p>In hac habitasse platea dictumst. In adipiscing justo eget lacus. Ut eget lacus\nquis purus posuere porttitor. In pretium. Etiam vulputate elit non purus. Donec\nac lacus et lectus ultricies cursus. Quisque erat turpis, blandit nec, nonummy\neu, auctor ornare, justo. Cras adipiscing pulvinar eros. Nullam dolor metus,\nsuscipit nec, ullamcorper id, posuere ut, wisi. Donec justo mauris, scelerisque\nid, feugiat eu, dictum ut, lacus. Nunc orci lectus, laoreet placerat, nonummy\neuismod, rhoncus in, tellus. Aenean feugiat est vel purus. Fusce tempor. Sed\naugue. </p>\n\nPellentesque malesuada arcu lacinia dui. Nunc feugiat ligula eget magna. Proin\nvarius. Duis eget quam. Ut non nibh. Nam a felis. Class aptent taciti sociosqu\nad litora torquent per conubia nostra, per inceptos hymenaeos. Cras quis metus\nin sapien tempor dignissim. Quisque id metus. Sed sed tellus et metus lacinia\nultricies. Fusce venenatis diam sed augue. Nunc libero diam, consequat in,\nplacerat et, rhoncus eu, tellus. Nullam mattis ultricies velit. Donec at nisl a\nmauris vulputate accumsan. Suspendisse non lorem. \n"));
$navmid->add($navmain);
$page->addBodyComponent($navtop);
$page->addBodyComponent($navmid);
$page->show();
include_once './peerlib/peerutils.inc';
include_once './peerlib/simplequerytable.inc';
include_once 'makeinput.inc';
include_once 'tutorhelper.inc';
include_once 'navigation2.inc';
$judge = $snummer;
$sql = "select * from student where snummer={$judge}";
$resultSet = $dbConn->Execute($sql);
if ($resultSet === false) {
print "error fetching judge data with {$sql} : " . $dbConn->ErrorMsg() . "<br/>\n";
}
if (!$resultSet->EOF) {
extract($resultSet->fields, EXTR_PREFIX_ALL, 'judge');
}
$page_opening = 'The groups of ' . "{$judge_roepnaam} {$judge_voorvoegsel} {$judge_achternaam} ({$judge_snummer})";
$page = new PageContainer();
$page->setTitle($page_opening);
$nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening);
$nav->setInterestMap($tabInterestCount);
$nav->addLeftNavText(file_get_contents('news.html'));
ob_start();
tutorHelper($dbConn, $isTutor);
$page->addBodyComponent(new Component(ob_get_clean()));
$page->addBodyComponent($nav);
if (hasCap(CAP_TUTOR)) {
$sql = "select year,'<a href=\"grouplist.php?prjm_id='||prjm_id||'\" target=\"_blank\">'||afko||'.'||milestone||'</a>' as \"project/m\",\n" . "description,prj_id,milestone,milestone_name,grp_name as group_name,prjtg_id,grp_name,coalesce(alias,'G'||grp_num) as group_alias,\n" . " long_name as group_description,tutor as group_tutor,tutor as project_owner" . " from prj_grp join all_prj_tutor using(prjtg_id) \n" . " where snummer={$snummer} order by year desc,prj_id,afko,milestone";
} else {
$sql = "select year,prjm_id,description,prj_id,milestone,milestone_name,\n" . "grp_num,prjtg_id,grp_name as group_name,coalesce(alias,'G'||grp_num) as group_alias,\n" . " long_name as group_description,tutor as group_tutor,tutor_owner as project_owner" . " from prj_grp join all_prj_tutor using(prjtg_id) \n" . " where snummer={$peer_id} order by year desc,prj_id,afko,milestone";
}
//echo "<pre>$sql</pre>";
ob_start();
$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();
$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));
<?php
require_once 'component.inc';
require_once 'navigation2.inc';
$page = new PageContainer();
$page_opening = "Manage you git keys";
$page->setTitle($page_opening);
$pp = array();
$nav = new Navigation(array(), basename($PHP_SELF), $page_opening);
$page->addBodyComponent($nav);
$pp['purpose'] = 'laptop';
$keydir = '/home/git/sandbox/gitolite-admin/keydir/' . $peer_id;
/*
* if file uploaded. move it to some git sandbox keydir/<peer_id>/email1@purbose.pub file.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
if (isset($_POST['btn']) && isset($_FILES['keyfile']['name'])) {
$f = $_FILES['keyfile']['name'];
if (isset($_POST['purpose'])) {
if (preg_match('/[a-zA-Z0-9]{1,15}/', $_REQUEST['purpose'])) {
$pp['purpose'] = $purpose = $_REQUEST['purpose'];
}
$keyfilename = $LOGINDATA['snummer'] . '@' . $purpose . '.pub';
$tmp_file = $_FILES['keyfile']['tmp_name'];
if (!is_dir($keydir) && !mkdir($keydir, 02775, true)) {
die('cannot create dir ' . $keydir . '<br/>');
}
$dest_file = "{$keydir}/{$keyfilename}";
// verify or try to convert key to acceptable to open-ssh
$kinfo = @system("/home/git/bin/ensure_open_ssh_key {$tmp_file}", $retval);
<?php
/**
* mini task_timer
*/
require_once 'component.inc';
$peer_id = $_SESSION['peer_id'];
require_once 'tasktimer.inc';
$page = new PageContainer();
$page->setTitle('Your personal task timer');
$task_div = new HtmlContainer('<div id=\'task_timer_id\' class=\'navopening\'>');
ob_start();
taskTimer($_SESSION['peer_id']);
$task_div->addText("<a href='logout.php' title='logout'><img src='" . IMAGEROOT . "/close_1.png' border='0' alt='logout'/></a>");
$task_div->addText(ob_get_clean());
$page->addBodyComponent($task_div);
$page->show();
}
$sql = "SELECT roepnaam, voorvoegsel,achternaam,lang,email1,email2 FROM student left join alt_email using(snummer) WHERE snummer={$snummer}";
$resultSet = $dbConn->Execute($sql);
if ($resultSet === false) {
die('Error: ' . $dbConn->ErrorMsg() . ' with ' . $sql);
}
$lang = strtolower($resultSet->fields['lang']);
$email1 = $resultSet->fields['email1'];
if (isset($resultSet->fields['email2'])) {
$email2 = $resultSet->fields['email2'];
} else {
$email2 = '';
}
extract($resultSet->fields, EXTR_PREFIX_ALL, 'stud');
$page_opening = "The project tasks of {$roepnaam} {$voorvoegsel} {$achternaam} ({$snummer})";
$page = new PageContainer();
$page->setTitle('Project tasks');
$nav = new Navigation($navtable, basename($PHP_SELF), $page_opening);
$nav->setInterestMap($tabInterestCount);
$nav->addLeftNavText(file_get_contents('news.html'));
ob_start();
tutorHelper($dbConn, $isTutor);
$page->addBodyComponent(new Component(ob_get_clean()));
$page->addBodyComponent($nav);
ob_start();
?>
<div id="content">
<div style='padding: 2em;'>
<h2 class='normal'>Defined project task defined by you</h2>
<fieldset><legend>My defined tasks</legend>
<p>Each user in this application can use a personal task timer. This task timer can be used to record time spent on
public static function printMenu()
{
?>
<style>
a.submenu{
color:#305029;
}
.topmenu:hover a.submenu{
color:#305029;
}
</style>
<?php
$menu = self::$menus;
//pr($menu);
$menu2 = array_reverse($menu);
foreach ($menu as $text => $m) {
$active = "";
if ($_GET['url'] == $m) {
$active = "topmenu_active";
}
if ($_GET['url'] == "km" || $_GET['url'] == "webapps") {
if ($text == "tools") {
$active = "topmenu_active";
}
}
?>
<div style="cursor:pointer;" <?php
if ($m != "tools" && $m != "pages") {
?>
onclick="document.location='<?php
echo _SPPATH . $m;
?>
';"<?php
}
?>
class="topmenu <?php
echo $active;
?>
dropdown">
<a <?php
if ($m == "tools") {
?>
id="dropdownMenu1" data-toggle="dropdown"<?php
}
?>
<?php
if ($m == "pages") {
?>
id="dropdownMenu2" data-toggle="dropdown"<?php
}
?>
href="<?php
echo _SPPATH . $m;
?>
">
<?php
if ($m == "home") {
?>
<i class="glyphicon glyphicon-home"></i><?php
}
?>
<?php
if ($m == "shop") {
?>
<i class="glyphicon glyphicon-shopping-cart"></i><?php
}
?>
<?php
if ($m == "tools") {
?>
<i class="glyphicon glyphicon-cog"></i><?php
}
?>
<?php
if ($m == "pages") {
?>
<i class="glyphicon glyphicon-hdd"></i><?php
}
?>
<?php
echo $text;
?>
<?php
if ($m == "tools" || $m == "pages") {
?>
<span <?php
if ($m == "tools") {
?>
id="dropdownMenu1" data-toggle="dropdown"<?php
}
if ($m == "pages") {
?>
id="dropdownMenu2" data-toggle="dropdown"<?php
}
?>
class="caret"></span>
<?php
}
?>
</a>
<?php
if ($m == "tools") {
?>
<ul class="dropdown-menu" role="menu" aria-labelledby="dropdownMenu1">
<li role="presentation"><a class="submenu" role="menuitem" tabindex="-1" target="_blank" href="<?php
echo _SPPATH;
?>
tools?mode=email">TBS Email</a></li>
<li role="presentation"><a class="submenu" role="menuitem" tabindex="-1" href="<?php
echo _SPPATH;
?>
tools?mode=wikipedia">TBS Wikipedia</a></li>
<li role="presentation"><a class="submenu" role="menuitem" tabindex="-1" href="<?php
echo _SPPATH;
?>
km">TBS Knowledge</a></li>
<li role="presentation"><a class="submenu" role="menuitem" tabindex="-1" href="<?php
echo _SPPATH;
?>
webapps">TBS Apps</a></li>
</ul>
<?php
}
?>
<?php
if ($m == "pages") {
?>
<ul class="dropdown-menu" role="menu" aria-labelledby="dropdownMenu2">
<?php
$arrG = PageContainer::getActiveSession();
foreach ($arrG as $gg) {
?>
<li role="presentation"><a class="submenu" role="menuitem" tabindex="-1" href="<?php
echo _SPPATH;
?>
pagecontainer?mode=<?php
echo $gg->container_id;
?>
"><?php
echo $gg->container_name;
?>
</a></li>
<?php
}
?>
</ul>
<?php
}
?>
</div>
<?php
}
}
$_SESSION['prjm_id'] = $prjm_id;
$_SESSION['milestone'] = $milestone;
if (isset($_POST['criterium_id']) && isset($_POST['setcrit'])) {
$critset = implode(",", $_POST['criterium_id']);
$sql = "begin work;\n" . "delete from prjm_criterium where prjm_id={$prjm_id} and criterium_id not in ({$critset});\n" . "insert into prjm_criterium select {$prjm_id},criterium_id from base_criteria \n" . " where criterium_id in ({$critset}) and ({$prjm_id},criterium_id) not in (select prjm_id,criterium_id from prjm_criterium);\n" . "commit\n";
$resultSet = $dbConn->Execute($sql);
if ($resultSet === false) {
$dbConn->log("cannot insert appplied criteria with <pre>{$sql}</pre>, reason: " . $dbConn->ErrorMsg() . "<br/>\n");
$dbConn->Execute("rollback;");
}
}
$prj_id = isset($_SESSION['prj_id']) ? $_SESSION['prj_id'] : -1;
extract(getTutorOwnerData($dbConn, $prj_id));
$_SESSION['prj_id'] = $prj_id;
$isTutorOwner = $tutor == $tutor_code;
$page = new PageContainer();
$page->setTitle('Peer assessment, define project');
$page_opening = "Define the number of criteria for the project.";
$nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening);
$nav->setInterestMap($tabInterestCount);
$page->addBodyComponent($nav);
$form1 = new HtmlContainer("<fieldset id='form1'><legend><b>Project milestone and number of criteria.</b></legend>");
$form1Form = new HtmlContainer("<form id='project' method='post' name='project' action='{$PHP_SELF}'>");
$input_prj_selector = "<select name='prj_id' onchange='submit()'>\n" . getOptionListGrouped($dbConn, "select afko||': '||description||' ('||year||')' as name" . ", year as namegrp,prj_id as value from project order by year desc,afko", $prj_id) . "\n</select>\n";
if ($isTutorOwner) {
$input_num_criteria = "<input class='" . $validator->validationClass('critcount') . "' type='text' align='right' size='1' maxlength='2' name='critcount' value='{$critcount}'/>";
$input_submit_button = "<input type='submit' name='setcrit' value='Set Criteria'/>";
} else {
$input_num_criteria = "{$critcount}";
$input_submit_button = '';
}
} else {
$signature = "<hr/><div>Sent by the peerweb service at" . " fontysvenlo.org on behalf of {$sender_name}</div>";
}
} else {
$replyto = '*****@*****.**';
$sender_name = 'Pieter van den Hombergh';
$signature = '';
}
if (isset($_POST['signature'])) {
$signature = $_POST['signature'];
$sql_signature = pg_escape_string($signature);
$sql = "begin work;\n" . " delete from email_signature where snummer={$peer_id};\n" . " insert into email_signature (snummer,signature) values({$peer_id},'{$signature}');\n" . "commit";
$dbConn->doSilent($sql);
}
$page_opening = "Set you mailer signature";
$page = new PageContainer();
$page->setTitle($page_opening);
$nav = new Navigation(array(), basename($PHP_SELF), $page_opening);
$page->addBodyComponent($nav);
$mailer_signature = "\n<form method='post' action='{$PHP_SELF}' name='mailerform' id='mailerform'>\n<fieldset><legend>Mailer</legend>\nThis signature will be appended to your email editor on startup. \nYou may use html enriched tex.\n<div>\n\n<b>Signature:</b><br/>\n<textarea cols='120' rows='20' id='signature' name='signature' class='mceEditor'>\n{$signature}\n</textarea >\n<input type='submit' name='set' value='Update signature'/>\n<input type='reset' name='reset' value='reset'/>\n</div>\n</fieldset>\n</form>\n";
$page->addBodyComponent(new Component($mailer_signature));
$page->addHeadText('<script language="javascript" type="text/javascript" src="' . SITEROOT . '/js/tiny_mce/tiny_mce.js"></script>
<script language="javascript" type="text/javascript">
tinyMCE.init({
theme: "advanced",
gecko_spellcheck : true,
theme_advanced_toolbar_location : "top",
mode : "textareas", /*editor_selector : "mceEditor",*/
theme_advanced_styles : "Header 1=header1;Header 2=header2;Header 3=header3;Table Row=tableRow1",
plugins: "advlink,searchreplace,insertdatetime,table",
<?php
require_once 'peerlib/component.inc';
require_once 'navigation2.inc';
require_once 'peerlib/SimpleTableFormatter.php';
require_once 'peerlib/mailFunctions.php';
$pp = array();
$page = new PageContainer();
$page->setTitle("Plan meeloopdag");
$nav = new Navigation($tutor_navtable, basename($PHP_SELF), "Plan een meeloopdag");
$page->addBodyComponent($nav);
//$css = "<link rel='stylesheet' type='text/css' href='style/tablesorterstyle.css'/>";
//$page->addScriptResource('js/jquery.js');
//$page->addScriptResource('js/jquery.tablesorter.js');
//$page->addJqueryFragment( '$("#myTable").tablesorter({widgets: [\'zebra\'],headers: {0:{sorter:false}}});' );
//$page->addHeadText($css);
$page->addHeadFragment('templates/tinymce_include.html');
$pp['subject_de'] = 'Einladung zum Schnuppertag an der Fontys FH in Venlo';
$pp['subject_nl'] = 'Uitnodiging voor een meeloopdag bij Fontys Hogescholen in Venlo';
$pp['mailbody_de'] = file_get_contents('templates/meeloop_mailbody_de.html', true);
$pp['mailbody_nl'] = file_get_contents('templates/meeloop_mailbody_nl.html', true);
$sql = "select 0 as sorter,m.*,s.roepnaam||coalesce(' '||s.voorvoegsel||' ',' ')||s.achternaam as mail_author from meeloopmail m join student s on (owner=snummer) where owner={$peer_id} \n" . "union\n" . "select 1 as sorter,m.* ,s.roepnaam||coalesce(' '||s.voorvoegsel||' ',' ')||s.achternaam as mail_author from meeloopmail m join student s on (owner=snummer) \n" . "order by sorter,meeloop_datum desc limit 1";
$resultSet = $dbConn->Execute($sql);
if ($resultSet !== false && !$resultSet->EOF) {
$pp = array_merge($pp, $resultSet->fields);
}
$sqlsender = "select rtrim(email1) as sender,roepnaam||coalesce(' '||voorvoegsel,'')||' '||achternaam as sender_name," . "coalesce(signature," . "'sent by the peerweb service on behalf of '||roepnaam||coalesce(' '||voorvoegsel,'')||' '||achternaam)\n" . " as signature from student left join email_signature using(snummer) where snummer='{$peer_id}'";
$rs = $dbConn->Execute($sqlsender);
if (!$rs->EOF) {
extract($rs->fields);
} else {
