<?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 {