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();
?>
<table width='100%'><tr><td valign='top'>
<div style='padding:1em'>
<h2>This page informs you about your peerweb project group memberships</h2>
<fieldset><legend>Group membership</legend>
<a href='membershipreport.php' target='_blank'>Print a report in pdf</a>
<?php
$resultSet = $dbConn->Execute($sql);
if ($resultSet === false) {
$dbConn->log('Error ' . $dbConn->ErrorMsg() . " with " . $sql);
} else {
simpletable($dbConn, $sql, "<table summary='group memership' " . "border='1' style='border-collapse:collapse;background:white;border:1px 1px;' >\n");
}
?>
</fieldset>
</div>
</td></tr></table>
<!-- db_name=<?php
echo $db_name;
?>
-->
<?php
$page->addBodyComponent(new Component(ob_get_clean()));
$page->show();
$spreadSheetWriter->setFilename($filename)->setTitle("Jaag buit {$fdate}")->setLinkUrl($server_url . $PHP_SELF)->setFilename($filename)->setAutoZebra(true);
$spreadSheetWriter->processRequest();
$spreadSheetWidget = $spreadSheetWriter->getWidget();
pagehead2('Jaag Buit', $scripts);
$page_opening = "Resultaat van jaagactie tot nu toe";
$nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening);
echo $nav->show();
?>
<div id='navmain' style='padding:1em;'>
<fieldset><legend>Select output type</legend>
<form method="get" name="project" action="<?php
echo $PHP_SELF;
?>
">
<input type='submit' name='get' value='Get' />
Excel file:
<?php
echo $spreadSheetWidget;
?>
</form><br/>
</fieldset>
<div align='center'>
<?php
echo simpletable($dbConn, $sql, "<table id='myTable' summary='candidates' class='tablesorter' " . "style='empty-cells:show;border-collapse:collapse' border='1'>");
?>
</div>
</body>
</script>
</html>
<?php
echo "<!-- dbname={$db_name} -->";
<?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();
echo $query_text;
?>
</textarea>
<br/>
<input type='submit' name='get' value='Execute' />
<?php
echo $spreadSheetWidget;
?>
</form>
</fieldset>
<div>For query <pre><?php
echo $sql;
?>
</pre>
<?php
if ($sql != '' && !preg_match("/(begin|drop|delete|insert|commit)/", $sql)) {
eval("\$expanded_sql=\"{$sql}\";");
simpletable($dbConn, $expanded_sql, "<table id='myTable' class='tablesorter' summary='your requested data'" . " style='empty-cells:show;border-collapse:collapse' border='1'>");
}
?>
</div>
<fieldset><legend>Saved Queries</legend>
<?php
echo $my_queries_table;
?>
</fieldset>
</body>
</html>
<?php
echo "<!-- dbname={$db_name} -->";
<div id='navmain' style='padding:1em;'>
<fieldset><legend>Select project</legend>
<form method="get" name="project" action="<?php
echo $PHP_SELF;
?>
">
<?php
echo $prj_id_selector;
?>
<input type='submit' name='get' value='Get' />
<?php
echo $spreadSheetWidget;
?>
<?php
echo $prjSel->getSelectionDetails();
?>
</form>
<br/>
<p>If you select <b>comma ',' separated</b> file in the menu, this page will produce a file fit for Auto Multiple Choice use, a.k.a. a Latex exam.</p>
</div>
</fieldset>
<div align='left' style='margin:0 10ex 0 10ex'>
<?php
echo simpletable($dbConn, $sql, "<table summary='candidates' style='border-collapse:collapse' border='1'>");
?>
</div>
</body>
</html>
<?php
echo "<!-- dbname={$db_name} -->";
?>
</th>
<th><?php
echo $project_total;
?>
</th>
</tr>
</table>
<?php
} else {
?>
<p>Your set is empty</p><?php
}
?>
<hr/>
<?php
echo "<h2 class='normal'>Workers in this project {$prj_id}, {$afko}, {$description}, milestone {$milestone}, group {$grp_num}</h2>\n";
$sql = "select snummer as student_number,roepnaam||coalesce(' '||voorvoegsel,'')||' '||achternaam as name,\n" . "'<a href=\\'mailto:'||email1||'\\'>'||email1||'</a>' as fontys_email,\n" . "'<a href=\\'mailto:'||email2||'\\'>'||email2||'</a>' as alt_email from student join prj_grp using(snummer) left join alt_email using(snummer)\n" . " where prj_id={$prj_id} and milestone={$milestone} and grp_num='{$grp_num}' order by achternaam";
simpletable($dbConn, $sql, "<table border='1' style='cell-padding:.5em;border-collapse:collapse;'>\n");
?>
</div>
</div>
<!-- $Id: grouptime.php 1825 2014-12-27 14:57:05Z hom $ -->
<!-- db_name=<?php
echo $db_name;
?>
-->
<?php
$page->addBodyComponent(new Component(ob_get_clean()));
$page->show();
}
$page_opening = 'Group repositories ' . " for {$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);
ob_start();
?>
<table width='100%'><tr><td valign='top'>
<div style='padding:1em'>
<h2>This page informs you about the repositories to which you have access</h2>
<fieldset><legend>Repositories</legend>
<?php
$sql = "select " . "'<a href=\"{$server_url}'||url_tail||'\">'||mpr.description||'</a>' as repo_link,'{$server_url}'||url_tail as url,\n" . " afko as project_name, pr.description \n" . " from my_project_repositories mpr join project pr using(prj_id) where snummer={$snummer} order by prj_id desc\n";
simpletable($dbConn, $sql, "<table width='100%' summary='visited colloquia' " . "border='0' >\n");
?>
</fieldset>
</div>
</td></tr></table>
<!-- db_name=<?php
echo $db_name;
?>
-->
<?php
$page->addBodyComponent(new Component(ob_get_clean()));
$page->show();
$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 width='100%'><tr><td valign='top'>
<div style='padding:1em'>
<h2>This page informs you about the colloquia in which your presence was recorded</h2>
<fieldset><legend>Colloquia you visited</legend>
<a href='activityreport.php' target='_blank'>Print a report in pdf</a>
<?php
$sql = "select datum as date, to_char(start_time,'HH24:MI') as time,short as title,part as p, description from activity join activity_participant using(act_id) where snummer={$judge} order by date,time";
$resultSet = $dbConn->Execute($sql);
if ($resultSet === false) {
$dbConn->log('Error ' . $dbConn->ErrorMsg() . " with " . $sql);
} else {
simpletable($dbConn, $sql, "<table width='100%' summary='visited colloquia' " . "border='0' style='background:rgba(255,255,255,0.5);border:1px 1px;' >\n");
}
?>
</fieldset>
</div>
</td></tr></table>
<!-- db_name=<?php
echo $db_name;
?>
-->
<?php
$page->addBodyComponent(new Component(ob_get_clean()));
$page->show();
$prjSel = new PrjMilestoneSelector2($dbConn, $peer_id, $prjm_id);
extract($prjSel->getSelectedData());
$_SESSION['prj_id'] = $prj_id;
$_SESSION['prjm_id'] = $prjm_id;
$_SESSION['milestone'] = $milestone;
if (isset($_REQUEST['createmaillists'])) {
createGroupMaillists($dbConn, $prjm_id);
createMaillists($dbConn, $prjm_id);
// @system('/bin/kickaliasappender');
}
$prj_id_selector = $prjSel->getSelector();
$selection_details = $prjSel->getSelectionDetails();
$sql = "select distinct grp_num,grp_name, trim(email_to_href(maillist||'@fontysvenlo.org')) as maillist, size as members from prj_grp_email natural join prjtg_size\n" . " where prjm_id={$prjm_id}\n" . " union " . "select distinct grp_num,grp_name, trim(email_to_href(maillist||'@fontysvenlo.org')) as maillist, size as members from prj_grp_email_g0 natural join prjm_size\n" . " where prjm_id={$prjm_id}\n" . " union\n" . "select distinct grp_num,'tutors'::text as grp_name, trim(email_to_href(maillist||'@fontysvenlo.org')) as maillist," . " size as members from prj_tutor_email cross join (select count(*) as size from prj_tutor where prjm_id={$prjm_id}) ptes \n" . " where prjm_id={$prjm_id}\n" . "order by grp_num";
$page = new PageContainer();
$page->setTitle('Create of view maillists for peerweb project');
$page_opening = "Mail lists for project {$afko} {$description} prjm_id {$prjm_id} prj_id {$prj_id} milestone {$milestone}";
$nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening);
$page->addBodyComponent($nav);
ob_start();
simpletable($dbConn, $sql, "<table summary='maillists for project ' style='border-collapse:collapse' border='1'>");
$maillist_table = ob_get_clean();
$templatefile = 'templates/createmaillists.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->show();
