<?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'>
<?php
include_once './peerlib/peerutils.inc';
require_once 'component.inc';
$page = new PageContainer();
$page->setTitle('Critique history');
$page->addHeadComponent(new Component("<script type='text/javascript'>\n" . "/*\n" . " * refresh parent page on close\n" . " */\n" . "function bye(){ \n" . " opener.focus();\n" . " self.close();\n" . "}\n" . "</script>"));
$page->addHeadComponent(new Component("<link rel='stylesheet' type='text/css' href='{$root_url}/style/newdivstyle.css'/>"));
$page->addHeadComponent(new Component("<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>"));
$maindiv = new HtmlContainer("<div id='main'>");
$page->addBodyComponent($maindiv);
if (isset($_REQUEST['critique_id'])) {
$critique_id = validate($_REQUEST['critique_id'], 'integer', 1);
$maindiv->addText("<div class='navopening'><h1>Critique history of critique {$critique_id} <button onClick='javascript:bye()'>Close</button></h1></div>");
$sql = "select distinct critiquer, roepnaam,voorvoegsel,achternaam,critique_id,id,\n" . "date_trunc('seconds',ch.edit_time) as critique_time,ch.critique_text as critique_text,\n" . "afko,year,apt.grp_num as critiquer_grp\n" . "from document_critique dcr\n" . "join critique_history ch using(critique_id)\n" . "join student st on (dcr.critiquer=st.snummer)\n" . "join uploads u on(dcr.doc_id=u.upload_id)\n" . "join all_prj_tutor apt on(u.prjtg_id=apt.prjtg_id) where critique_id={$critique_id}\n" . "order by id desc";
$resultSet = $dbConn->Execute($sql);
if ($resultSet === false) {
die('Error: ' . $dbConn->ErrorMsg() . ' with ' . $sql);
}
$table_div = new HtmlContainer("<div id='tablediv' style='padding: 0 2em 0 2em'>");
$table = new HtmlContainer("<table id='critique_table' class='layout' style='padding:0;margin:0;'");
$table_div->add($table);
$maindiv->add($table_div);
while (!$resultSet->EOF) {
extract($resultSet->fields);
$table->add(new Component("<tr><td>\n" . "\t<div class='critique' style='background:#ffffe0;'>\n" . "\t<fieldset style='margin: .2em border:2;'>\n" . "\t\t<legend>Critique {$critique_id} by {$roepnaam} {$voorvoegsel} {$achternaam} ({$critiquer}) </legend>\n" . "\t\t\t<table class='layout'>\n" . "\t\t\t\t<tr><td>Group</td><th align='left'>{$critiquer_grp} ({$afko} {$year}) </th></tr>\n" . "\t\t\t\t<tr><td>Critique time</td><th align='left'> {$critique_time}</th></tr>\n" . "\t\t\t</table>\n" . "{$critique_text}\n" . "\t</fieldset>\n" . "\t</div>\n" . "</td></tr>"));
$resultSet->MoveNext();
}
}
$page->show();
$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}\";");
}
$page->addBodyComponent(new Component($text));
$page->addBodyComponent(new Component('<!-- db_name=' . $db_name . '-->'));
}
$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 = "Settings/time book-keeping for {$roepnaam} {$voorvoegsel} {$achternaam} ({$snummer})";
$page = new PageContainer();
$page->setTitle('Personal settings and time book-keeping');
$script = "function splitter(task_timer_id,new_task_timer_id) {\n" . "window.open('timesplitter.php?task_timer_id='+task_timer_id+'&new_task_timer_id='+new_task_timer_id,'_blank','width=800,height=670,scrollbars')" . "}";
$scriptContainer = new HtmlContainer("<script id='tasktimerstarter' type='text/javascript'>");
$scriptContainer->add(new Component($script));
$page->addHeadComponent($scriptContainer);
$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();
$sqltt = "select distinct rtrim(afko)||':M'||milestone||':'||rtrim(task_description) as name\n" . ", prj_id||':'||milestone||':'||task_id as value,prj_id,milestone,task_id\n" . "from project_tasks join all_prj_tutor using(prj_id) join prj_grp using(snummer,prjtg_id) where snummer={$peer_id}\n" . "order by prj_id,milestone,task_id";
$taskSelector = "\n<select name='new_task_timer' title='select task to time'>\n" . getOptionList($dbConn, $sqltt, $new_task_timer) . "\n</select>\n";
$timebookTable = "";
$sql = "select afko as project,description as project_title ,task_description,task_id,id as task_timer_id,prj_id,milestone,\n" . "to_char(start_time,'YYYY-MM-DD HH24:MI:SS')::text as start_time,\n" . "to_char(stop_time,'YYYY-MM-DD HH24:MI:SS')::text as stop_time,\n" . "from_ip,\n" . "date_trunc('seconds',stop_time-start_time) as time_diff,\n" . "tsum.task_time as total_time,\n" . "psum.project_time as project_time,\n" . "time_tag,\n" . "case when start_time=time_tag then 'P' else 'Q' end as validity,\n" . "extract(month from start_time) as month\n" . "from project_tasks join project using(prj_id)\n" . "join task_timer using (snummer,prj_id,task_id) \n" . "join task_timer_sum tsum using (snummer,prj_id,milestone,task_id)\n" . "join task_timer_project_sum psum using (snummer,prj_id,milestone)\n" . "where snummer={$snummer}\n";
if ($timeorder == 'Y') {
$sql .= " order by start_time desc";
} else {
