eth0 traffic (32 hours)<br>
<img src='/health/eth0-32hours.png'><br>
</td>
<td valign='top'>
loadavg (3 hours)<br>
<img src='/health/loadavg-3hours.png'><br>
loadavg (32 hours)<br>
<img src='/health/loadavg-32hours.png'><br>
</td>
</tr>
</table>
<a href='/health/'>health monitor</a>
EOS;
}
### function }}}
pagehead('Server Monitor');
_style();
ptitle('Server Monitor');
## {{
print <<<EOS
<table border='0'>
<form name='form' method='get' action='{$self}'>
<tr>
<td>
<input type='hidden' name='mode' value='{$mode}'>
<input type='submit' value='OK' style="width:50;height:50;">
</td>
<td>
EOS;
<?php
include "path.php";
include "{$env['prefix']}/inc/common.php";
include "func.php";
pagehead('Home');
print <<<EOS
EOS;
pagetail();
if (!$resultSet->EOF) {
extract($resultSet->fields);
} else {
$doctype = 1;
}
}
$_SESSION['doctype'] = $doctype;
$sql = "select count(*) as doccount from uploads where prjm_id={$prjm_id}";
$resultSet = $dbConn->Execute($sql);
$doccount = 0;
if ($resultSet === false) {
echo 'Error: ' . $dbConn->ErrorMsg() . ' with ' . $sql;
} else {
extract($resultSet->fields);
}
pagehead('Upload viewer for tutors');
$page_opening = "Documents handed in by a group";
$nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening);
$nav->setInterestMap($tabInterestCount);
$sql = "select sum(filesize) as zip_filesize from uploads where prjm_id={$prjm_id} group by prjm_id";
$resultSet = $dbConn->Execute($sql);
if ($resultSet === false) {
echo 'Error: ' . $dbConn->ErrorMsg() . ' with ' . $sql;
} else {
extract($resultSet->fields);
$zip_filesize = number_format($zip_filesize, 0, ',', '.');
}
echo $nav->show();
?>
<div id='navmain' style='padding:1em;'>
<h1>Read uploaded files</h1>
if ($page > 0 && $rows > 0) {
$pagelink = "[<a href=\"./?id={$id}&page=" . ($page - 1) . "\"" . mbi_ack("*") . ">" . mbi("*.") . "前へ</a>] ";
} else {
$pagelink = "[" . mbi("*.") . "前へ] ";
}
$pagelink .= "[P " . ($page + 1) . "/" . ceil($rows / $LIMIT) . " ]";
if (($page + 1) * $LIMIT < $rows) {
$pagelink .= " [<a href=\"./?id={$id}&page=" . ($page + 1) . "\"" . mbi_ack("#") . ">" . mbi("#.") . "次へ</a>]";
} else {
$pagelink .= " [" . mbi("#.") . "次へ]";
}
?>
<html>
<head>
<?php
echo pagehead($title);
?>
</head>
<body>
<div id="all">
<h1><?php
echo $board->title;
?>
</h1>
<hr class="normal">
<p>
[<a href="./form.php?mode=thform&id=<?php
echo $board->name;
?>
"<?php
echo mbi_ack(8);
$resultSet = $dbConn->Execute($sql);
if ($resultSet === 0) {
$dbConn->log($dbConn->ErrorMsg());
$dbConn->Execute("abort");
}
}
if (($isTutorOwner || $isGroupTutor) && isset($_REQUEST['bdelete']) && $newsnummer != 0) {
// try to insert this snummer into max prj_grp
$sql = "delete from prj_grp pg where snummer={$newsnummer} \n" . "and prjtg_id in (select prjtg_id from prj_tutor where prjm_id={$prjm_id})";
$dbConn->Execute($sql);
// $dbConn->log($dbConn->ErrorMsg());
}
$studentPicker->setPresentQuery("select snummer from prj_grp join prj_tutor using(prjtg_id) where prjm_id={$prjm_id}");
$sql = "select distinct snummer,achternaam,roepnaam,voorvoegsel,pt.grp_num, alias as group,sclass \n" . " from prj_grp pg join prj_tutor pt using(prjtg_id) join student using(snummer) \n" . "join student_class using(class_id)\n" . " left join grp_alias using(prjtg_id)" . " where pt.prjm_id={$prjm_id} \n" . " order by grp_num desc,achternaam,roepnaam";
$rainbow = new RainBow();
$memberTable = getQueryToTableChecked($dbConn, $sql, true, 4, $rainbow, -1, '', '');
pagehead('Add individual student.');
$page_opening = "Add individual student to a project. <span style='font-size:6pt;'>prj_id {$prj_id} milestone {$milestone} </span>";
$nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening);
$nav->setInterestMap($tabInterestCount);
$nav->show();
$prjSelectWidget = $prjSel->getWidget();
include_once 'templates/addindividual.html';
?>
<!-- db_name=<?php
echo $db_name;
?>
-->
<!-- $Id: addindividual.php 1725 2014-01-16 08:39:59Z hom $ -->
</body>
</html>
}
$cflag = false;
// checked if any one
if ($lgac or $lgam or $lgdb or $lgjm or $lgmn or $lgud) {
$cflag = true;
}
if (!$cflag) {
$lgac = 'on';
// check one of them
}
// session save
$_SESSION['lgchks'] = array($lgac, $lgam, $lgdb, $lgjm, $lgmn, $lgud);
return array($lgac, $lgam, $lgdb, $lgjm, $lgmn, $lgud);
}
### function }}}
pagehead($page_title);
_style();
ptitle('Log View');
## {{
print <<<EOS
<table border='0'>
<form name='form' method='get' action='{$self}'>
<tr>
<td>
<input type='hidden' name='mode' value='{$mode}'>
<input type='submit' value='OK' style="width:50;height:50;">
</td>
<td>
EOS;
// session_start();
include_once './peerlib/peerutils.inc';
if (isset($_POST['peer_id']) && isset($_POST['peer_pw'])) {
$peer_id = $_POST['peer_id'];
$peer_pw = $_POST['peer_pw'];
if (authenticate($peer_id, $peer_pw)) {
$_SESSION['auth_user'] = $peer_id;
} else {
unset($_SESSION['auth_user']);
}
}
if (!isset($_SESSION['auth_user'])) {
header("Location: login.php");
exit;
}
pagehead('welcome');
?>
<div id="content">
<fieldset valign="top">
<legend>Welkom <?php
echo $_SESSION['auth_user'];
?>
met wachtwoord <?php
echo $_POST['peer_pw'];
?>
</legend>
Hier kun je kiezen tussen
<ol><li>Het invullen van je formulier voor het beoordelen van je teamgenoten</li>
<li>en het bekijken van de beoordelingen die je van je teamgenoten hebt gekregen. Dit gaat alleen als alle teamgenoten hun formulier hebben ingestuurd.
</li>
<li>Uitloggen</li>
<?php
include "path.php";
include "{$env['prefix']}/inc/common.php";
include "func.php";
pagehead('Management');
ParagraphTitle("Management");
print <<<EOS
<ul>
<li><a href="mgrsite.php">Site Management</a>
<li><a href="mgrostpl.php">OS Template</a>
<li><a href="mgrvm.php">VM Management</a>
EOS;
print <<<EOS
</ul>
EOS;
$title = 'List of records contained in the NEW cloud accounting database started in last 3 hours. (Times are UTC)';
$url = "http://goc-accounting.grid-support.ac.uk/cloudtest/vmshour2.html";
print "<dt>{$title}";
print "<dd><a href='{$url}' target='_blank'>{$url}</a>";
$title = 'Sites publishing new cloud accounting records (SSM 2.0)';
$url = "http://goc-accounting.grid-support.ac.uk/cloudtest/cloudsites2.html";
print "<dt>{$title}";
print "<dd><a href='{$url}' target='_blank'>{$url}</a>";
$title = 'EGI ACCOUNTING PORTAL';
$url = "http://accounting-devel.egi.eu/cloud.php";
print "<dt>{$title}";
print "<dd><a href='{$url}' target='_blank'>{$url}</a>";
pagetail();
foreach ($output as $line) {
if (!$line) {
$is_header = false;
continue;
}
if ($is_header) {
$headers[] = $line;
} else {
$body[] = $line;
}
}
//dd($headers);
//dd($body);
}
### }}}
pagehead('cURL client');
print <<<EOS
<table border='1'>
<form name='form' action='{$env['self']}' method='get'>
<tr>
<td>curl</td>
</tr>
<tr>
<td>URL</td>
<td>
<input type='text' name='url' size='60' value="{$form['url']}">
</td>
</tr>
EOS;
$items = array(array('GET', 'GET'), array('POST', 'POST'));
ParagraphTitle("Generate Proxy Certifiate", 1);
$keypass = $form['keypass'];
$error = generate_proxy($keypass, $debug);
if ($error) {
print "<b>{$error}</b>";
} else {
print "<b>proxy generated</b>";
}
ParagraphTitle("Proxy Infomation", 1);
proxy_info($debug);
pagetail();
exit;
}
### }}}
$title = "Proxy Information";
pagehead($title);
ParagraphTitle($title);
$debug = true;
$debug = false;
ParagraphTitle("Proxy Infomation", 1);
proxy_info($debug);
$title = "Generate Proxy Certificate";
ParagraphTitle($title, 1);
print <<<EOS
<form name='form' method='post' enctype='multipart/form-data'>
Certificate:
<input type='file' name='filecert' size='30' style='height:30;'>
<br>
Key:
<input type='file' name='filekey' size='30' style='height:30;'>
$csvout = 'N';
$csvout_checked = '';
if (isset($_REQUEST['csvout'])) {
$csvout = $_REQUEST['csvout'];
$csvout_checked = $csvout == 'Y' ? 'checked' : '';
}
// <a href='../emailaddress.php?snummer=snummer'>snummer</a>
$sql = "select firstname,lastname,email,emailstatus,token,language_code,attribute_1,attribute_2 \n" . "from lime_token where attribute_2={$prjm_id} order by lastname,firstname";
$sql2 = $sql;
$rainbow = new RainBow(STARTCOLOR, COLORINCREMENT_RED, COLORINCREMENT_GREEN, COLORINCREMENT_BLUE);
if ($csvout == 'Y') {
$content_header = 'Content-type: text/x-comma-separated-values; charset: UTF-8;';
$dbConn->queryToCSV($sql, $filename, ';', true, $content_header, false);
exit(0);
}
pagehead('Get lime survey token table');
$page_opening = "Lime survey token file project {$afko} {$description} <span style='font-size:6pt;'>prj_id {$prj_id} milestone {$milestone} </span>";
$nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening);
$nav->setInterestMap($tabInterestCount);
$prjSel->setJoin('milestone_grp using (prj_id,milestone)');
$prj_id_selector = $prjSel->getSelector();
echo $nav->show();
?>
<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;
* presents a page that allows a time record to be spilt and attaached to other projects
*/
include_once './peerlib/peerutils.inc';
include_once 'tutorhelper.inc';
require_once 'tasktimer.inc';
if (!isset($startend)) {
$startend = 'start';
}
if (isset($_REQUEST['startend'])) {
if ($_REQUEST['startend'] == 'end') {
$startend = 'end';
}
}
extract($_SESSION);
$script = "\n/*\n* refresh parent page on close\n*/\nfunction bye(){\n opener.focus();\n opener.location.reload();\n self.close();\n}\n/* split */\nfunction 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=600,scrollbars')\n}\n";
pagehead('Time splitter.', $script);
//echo "<pre>";print_r($_REQUEST);echo "</pre>\n";
$new_task_timer_id = -1;
if (isset($_REQUEST['task_timer_id'])) {
$task_timer_id = validate($_REQUEST['task_timer_id'], 'integer', 0);
}
// now get the task (which should fit split_time)
$sql = "select prj_id, milestone,prjm_id,task_id,start_time, stop_time from task_timer\n" . " where id={$task_timer_id}";
$resultSet = $dbConn->Execute($sql);
if ($resultSet === false) {
echo "cannot get task timer data with <pre>{$sql}</pre>, error " . $dbConn->ErrorMsg();
}
if (!$resultSet->EOF) {
extract($resultSet->fields);
}
//echo "<pre>";print_r($resultSet->fields);echo "</pre>\n";
$sql .= 'commit;';
if ($db_name == 'peer2') {
$dbConn->log($sql);
}
$resultSet = $dbConn->execute($sql);
if ($resultSet === false) {
echo "<br>Cannot update roles types with <pre>" . $sql . "</pre> reason " . $dbConn->ErrorMsg() . "<br>";
}
}
$sql = "select tutor as tutor_owner from project join tutor on (userid=owner_id) where prj_id={$prj_id}";
$resultSet = $dbConn->execute($sql);
if ($resultSet === false) {
echo "<br>Cannot get tutor owner <pre>" . $sql . "</pre> reason " . $dbConn->ErrorMsg() . "<br>";
}
extract($resultSet->fields);
pagehead('Define types of roles students can play.');
$page_opening = "Define the roles the students may assume in a project team. <span style='font-size:6pt;'>prj_id {$prj_id} milestone {$milestone} </span>";
$nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening);
$nav->setInterestMap($tabInterestCount);
$prjSel->setJoin('milestone_grp using (prj_id,milestone)');
//if ($db_name =='peer2') $dbConn->log($prjSel->getQuery());
$prj_id_selector = $prjSel->getSimpleForm();
$copy_form = '';
$sql = "select count(1) as role_count from project_roles where prj_id={$prj_id}";
$resultSet = $dbConn->execute($sql);
$has_roles = $resultSet->fields['role_count'] > 0;
if (!$has_roles) {
$copyselector = getProjectSelector($dbConn, $peer_id, $prj_id, 'roprj_id', ' prj_id in (select distinct prj_id from project_roles)');
$copy_form = "<fieldset><legend>copy roles from other project</legend><form id='copyform' method='get'>\n" . "{$copyselector}\n" . "<input type='hidden' name='target_prj_id' value='{$prj_id}'/>\n" . "<input type='submit' name='copyroles' value='Copy Roles from project'/>\n" . "</form></fieldset>";
}
$nav->show();
}
if ($sqlTail != '') {
$sql .= $sqlTail;
$dbConn->log($sql);
$rts = $dbConn->Execute($sql);
if ($rts === false) {
$dbConn->Execute("rollback;");
} else {
$dbConn->transactionEnd();
}
} else {
$dbConn->transactionEnd();
}
}
// get group tables for a project
pagehead('Record task completed');
$page_opening = "Record completion of tasks for project";
$nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening);
$nav->setInterestMap($tabInterestCount);
$nav->show();
$sql3 = "select task_id as value,name||': '||description as name from project_task order by task_number";
$taskSel = new Selector($dbConn, 'task_id', $sql3, $task_id);
$task_id_selector = $taskSel->getSelector();
$participant = array();
$sql = "select snummer as participant from project_task_completed where task_id={$task_id}";
$resultSet = $dbConn->Execute($sql);
if ($resultSet === false) {
print "error fetching participant data with {$sql} : " . $dbConn->ErrorMsg() . "<br/>\n";
} else {
while (!$resultSet->EOF) {
array_push($participant, $resultSet->fields['participant']);
extract($_SESSION);
$prjSel = new PrjMilestoneSelector2($dbConn, $peer_id, $prjm_id);
extract($prjSel->getSelectedData());
$_SESSION['prj_id'] = $prj_id;
$_SESSION['prjm_id'] = $prjm_id;
$_SESSION['milestone'] = $milestone;
$new_repos_name = strtolower($afko) . 'm' . $milestone;
$tutor = $tutor_code;
if ($db_name == 'peer2') {
$reposroot = '/home/svnt';
$url_base = 'svnt';
} else {
$reposroot = '/home/svn';
$url_base = 'svn';
}
pagehead('Create Subversion repositories');
$page = new PageContainer();
$pageTitle = "Subversion repositories";
$page->setTitle($pageTitle);
$cmdstring = '';
$pp['repoURL'] = $server_url . '/svn/' . $year . '/' . $new_repos_name . '/';
$twigs = '';
if (isset($_POST['bcreate'])) {
if (isset($_REQUEST['new_repos_name']) && $_REQUEST['new_repos_name']) {
$new_repos_name = trim($_REQUEST['new_repos_name']);
}
$individual = trim($_REQUEST['repos_individual']) == 'individual' ? 'individual' : 'group';
$twigs = trim($_REQUEST['twigs']);
if ($individual == 'individual') {
$cmdstring = $subversionscriptdir . "/mksvnindividual2.pl --db {$db_name} " . "--projectmilestone {$prjm_id} --parent {$reposroot} --name {$new_repos_name} --url_base {$url_base} --twigs='{$twigs}'";
} else {
function showsource($file)
{
if (file_exists($file) && !is_dir($file) && !(is_array($GLOBALS['CONFIG']['DENY_SOURCE']) && in_array($file, $GLOBALS['CONFIG']['DENY_SOURCE']))) {
pagehead($file);
$content = highlight_file($file, 1);
$linecount = substr_count($content, "<br />") + 1;
$size = number_format(filesize($file), 0, ' ', ' ');
$date = date('F d Y H:i:s.', filemtime($file));
echo '<tr><td bgcolor=' . $GLOBALS['CONFIG']['BG_COLOR_3'] . '><b>' . basename($file) . ' has ' . $linecount . ' lines, size is ' . $size . ' bytes, last modified on ' . $date . '</b></font>' . '<table cellspacing="0" width="100%" border="0" cellpadding="2" class="code"><tr valign="top"><td bgcolor="' . $GLOBALS['CONFIG']['TB_COLOR_3'] . '" width="0" align="right"><code>';
for ($i = 1; $i <= $linecount; $i++) {
echo '<a name=' . $i . '></a><a href="#' . $i . '">' . $i . '</a><br>';
}
echo '<td nowrap>';
print_r($content);
echo '</table>';
pagefoot();
} else {
if (!file_exists($file) || is_dir($file)) {
$error = 'No such file named "' . $file . '".';
}
pagehead("Error");
echo '<font class="error"><b>' . $error . '</b></font>';
pagefoot();
}
}
$prjm_id = 0;
extract($_SESSION);
$prjSel = new PrjMilestoneSelector2($dbConn, $peer_id, $prjm_id);
extract($prjSel->getSelectedData());
$_SESSION['prj_id'] = $prj_id;
$_SESSION['prjm_id'] = $prjm_id;
$_SESSION['milestone'] = $milestone;
$sqlhead = "select distinct prj_id,milestone,afko,year,grp_num,tutor,rtrim(alias) as alias,long_name,productname,\n" . " snummer as gm_snumber,roepnaam||coalesce(' '||voorvoegsel||' ',' ')||achternaam as gm_name,rtrim(email1) as gm_email,\n" . " website," . " youtube_link \n" . " from all_prj_tutor_y apt \n" . " left join (select sr.*,s.achternaam,s.roepnaam,s.voorvoegsel,s.email1 from student_role \n" . " join (select snummer,prjtg_id from prj_grp join all_prj_tutor using(prjtg_id)\n" . " where prjm_id={$prjm_id}) sr using(snummer) join student s using(snummer) where prjm_id={$prjm_id} and rolenum=1) gm using (prjtg_id)\n" . " where (now()::date < valid_until) and (apt.prjm_id = {$prjm_id})\n" . " order by grp_num ";
$spreadSheetWriter = new SpreadSheetWriter($dbConn, $sqlhead);
$filename = 'group_defs';
$title = 'Group definitions';
$spreadSheetWriter->setFilename($filename)->setLinkUrl($server_url . $PHP_SELF . '?prjm_id=' . $prjm_id)->setTitle($title)->setAutoZebra(true);
$spreadSheetWriter->processRequest();
$spreadSheetWidget = $spreadSheetWriter->getWidget();
//$dbConn->log("prj mile etc $prj_id, $prjm_id, $milestone");
pagehead('Select group count and tutors');
$grp_count = 5;
$tutor_id = $peer_id;
//include 'prjm_idRequest.php';
// determine the number of groups currently present
// to advise about the number of tutur-grp pairs
$isTutorOwner = checkTutorOwnerMilestone($dbConn, $prjm_id, $peer_id);
//// check if this is tutor_owner of this project
//$dbConn->log('istutorowner='.$isTutorOwner."<br/>\n");
$sql = "select count(distinct grp_num) as org_grp_count from prj_grp join prj_tutor using(prjtg_id) where prjm_id = {$prjm_id}";
$resultSet = $dbConn->Execute($sql);
if ($resultSet === false) {
echo "<br>Cannot get group count with with <pre>\"" . $sql . '"</pre>, cause ' . $dbConn->ErrorMsg() . "<br>";
stacktrace(1);
die;
}
$_SESSION['searchname'] = $searchname;
} else {
$studentPicker->setSearchString($_SESSION['searchname']);
}
$_SESSION['searchname'] = $searchname;
// test if this owner can update this project
$isTutorOwner = checkTutorOwner($dbConn, $prj_id, $tutor_code);
if (($isTutorOwner || $isGroupTutor) && isset($_REQUEST['bsetgid']) && $newauditor != 0) {
$gids = join(',', $_REQUEST['gid']);
$sql = "begin work;" . " insert into project_auditor (snummer,prjm_id,gid) \n" . " select {$newauditor},prjm_id,grp_num as gid from \n" . "(select {$newauditor} as snummer ,prjm_id,0 as grp_num from prj_tutor where prjm_id={$prjm_id} \n" . " union select {$newauditor} as snummer,prjm_id,grp_num from prj_tutor where prjm_id={$prjm_id}) pt \n" . " where grp_num in ({$gids}) " . " and ({$newauditor},prjm_id,grp_num) not in (select snummer,prjm_id,gid from project_auditor);\n" . "commit";
$dbConn->Execute($sql);
// $dbConn->log($sql);
// $dbConn->log($dbConn->ErrorMsg());
}
//
pagehead('Add project auditor.');
$page_opening = "Add project auditor to a project. prj_id {$prj_id} milestone {$milestone} prjm_id {$prjm_id}";
$nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening);
$nav->setInterestMap($tabInterestCount);
echo $nav->show();
?>
<div id='navmain' style='padding:1em;'>
<p>Add a project auditor to a project /group.</p>
<p>Project auditors have the privilege to access the groups resources such as svn and trac. Use case: extra
readers of project artifacts without having to add (empty) project groups with these readers as tutor.
</p>
<?php
echo $prjSel->getWidget();
$studentPicker->setPresentQuery("select snummer from project_auditor where prjm_id={$prjm_id}");
$studentPicker->show();
$sql = "select snummer,achternaam,roepnaam,voorvoegsel from student where snummer={$newauditor}";
$prjSel = new PrjMilestoneSelector2($dbConn, $peer_id, $prjm_id);
extract($prjSel->getSelectedData());
$_SESSION['prj_id'] = $prj_id;
$_SESSION['prjm_id'] = $prjm_id;
$_SESSION['milestone'] = $milestone;
//$dbConn->log("$tutor_code $prjm_id, $prj_id, $milestone");
$filename = 'examlist_' . $afko . '-' . date('Ymd');
$sql = "select distinct snummer as id,achternaam as surname,roepnaam||coalesce(' '||voorvoegsel,'') as name,trim(sclass) as sclass,voorletters\n" . " ,upper(lang) as lang,prjm_id,trim(coalesce(alias,'g'||grp_num)) as alias, md5(prjm_id::text||prj_grp.snummer::text || now()) AS token, \n" . " cohort,email1,course_short as education, case when prjm_id=422 then 1 else 0 end as lo" . " from student s join prj_grp using(snummer) \n" . " join all_prj_tutor using(prjtg_id)\n" . " join student_class using(class_id) left join fontys_course fc on(s.opl=fc.course)" . " where prjm_id in (422,{$prjm_id}) order by lo,surname,name";
$spreadSheetWriter = new SpreadSheetWriter($dbConn, $sql);
$title = "exam list";
$spreadSheetWriter->setFilename($filename)->setLinkUrl($server_url . $PHP_SELF . '?prjm_id=' . $prjm_id)->setTitle($title)->setAutoZebra(true);
$spreadSheetWriter->processRequest();
$spreadSheetWidget = $spreadSheetWriter->getWidget();
// <a href='../emailaddress.php?snummer=snummer'>snummer</a>
$rainbow = new RainBow(STARTCOLOR, COLORINCREMENT_RED, COLORINCREMENT_GREEN, COLORINCREMENT_BLUE);
pagehead('Get exam list');
$page_opening = "Exam list for project {$afko} {$description} (prj_id {$prj_id} milestone {$milestone} prjm_id {$prjm_id})";
$nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening);
$nav->setInterestMap($tabInterestCount);
$prjSel->setJoin('milestone_grp using (prj_id,milestone)');
$prj_id_selector = $prjSel->getSelector();
echo $nav->show();
?>
<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;
define('MAXROW', '3');
define('MAXCOL', '5');
$class_id = 1;
$tutor = $tutor_code;
extract($_SESSION);
$year = 2008;
# get actual course_year
$sql = "select value as year from peer_settings where key='course_year'";
$resultSet = $dbConn->Execute($sql);
if (!$resultSet->EOF) {
extract($resultSet->fields);
}
if (isset($_REQUEST['oldclass_id'])) {
$_SESSION['class_id'] = $class_id = validate($_REQUEST['oldclass_id'], 'integer', 1);
}
pagehead('my class');
$sql = "select class_id from current_student_class where snummer={$snummer}\n";
$resultSet = $dbConn->Execute($sql);
if (!$resultSet->EOF) {
extract($resultSet->fields);
}
$sql = "select * from student_class where class_id={$class_id}";
$resultSet = $dbConn->Execute($sql);
if ($resultSet === false) {
die("<br>Cannot get class data with " . $sql . " reason " . $dbConn->ErrorMsg() . "<br>");
}
if (!$resultSet->EOF) {
extract($resultSet->fields);
}
$tablehead = "<h2>Class photos for class {$sclass}: {$year}-" . ($year + 1) . "</h2>\n";
$page_opening = "Class photos for class {$sclass} {$year}-" . ($year + 1);
}
$filename = 'activity' . $short . '-' . date('Ymd') . '.csv';
$csvout = 'N';
$csvout_checked = '';
if (isset($_REQUEST['csvout'])) {
$csvout = $_REQUEST['csvout'];
$csvout_checked = $csvout == 'Y' ? 'checked' : '';
}
$sql1 = "select snummer," . "achternaam||rtrim(coalesce(', '||voorvoegsel,'')) as achternaam ,roepnaam," . " sclass,sort1,sort2\n " . " from activity_participant join activity using(act_id) join student using(snummer)" . " join student_class using(class_id)\n" . " where act_id={$act_id} order by sort1,sort2,sclass,achternaam,roepnaam";
$sql2 = "select snummer," . "achternaam||rtrim(coalesce(', '||voorvoegsel,'')) as achternaam ,roepnaam," . " sclass,sort1,sort2\n " . " from activity_participant join activity using(act_id) join student using(snummer)" . " join student_class using(class_id)\n" . " where act_id={$act_id} order by sort1,sort2,sclass,achternaam,roepnaam";
$rainbow = new RainBow(STARTCOLOR, COLORINCREMENT_RED, COLORINCREMENT_GREEN, COLORINCREMENT_BLUE);
if ($csvout == 'Y') {
$dbConn->queryToCSV($sql2, $filename);
exit(0);
}
pagehead('Get activity participation');
$page_opening = "List of students attending activities";
$nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening);
$nav->setInterestMap($tabInterestCount);
$sql3 = "select datum||', '||' ('||act_id||', #'||coalesce(apc.count,0)||') '||rtrim(short)||'*'||part||': '||rtrim(description) as name, act_id as value," . "substr(datum::text,1,4) as namegrp\n" . " from activity left join act_part_count apc using(act_id) order by namegrp desc,datum,part";
$prjSel = new Selector($dbConn, 'act_id', $sql3, $act_id);
$act_id_selector = $prjSel->getSelector();
echo $nav->show();
?>
<div id='navmain' style='padding:1em;'>
<fieldset><legend>Select project</legend>
<form method="get" name="activity" action="<?php
echo $PHP_SELF;
?>
">
<?php
if ($page > 0 && $count > 0) {
$pagelink = "<a href=\"{$link}&page=" . ($page - 1) . "\"" . mbi_ack("*") . ">" . mbi("*.") . "前のページ</a> | ";
} else {
$pagelink = mbi("*.") . "前のページ | ";
}
if (($page + 1) * 10 < $count) {
$pagelink .= "<a href=\"{$link}&page=" . ($page + 1) . "\"" . mbi_ack("#") . ">" . mbi("#.") . "次のページ</a>";
} else {
$pagelink .= mbi("#.") . "次のページ";
}
}
?>
<html>
<head>
<?php
echo pagehead($board->title);
?>
</head>
<body>
<div id="all">
<h1><?php
echo $board->title;
?>
</h1>
<hr class="normal">
<h2>メッセージ検索</h2>
<hr class="normal">
<?php
if (device_info() == 'mb') {
$action = $_SERVER["PHP_SELF"] . "?id={$id}";
if ($tid > 0) {
$prj_id = 1;
$milestone = 1;
$prjm_id = 0;
$grp_num = 1;
$prjtg_id = 1;
extract($_SESSION);
$judge = $snummer;
$prjSel = new StudentMilestoneSelector($dbConn, $judge, $prjtg_id);
extract($prjSel->getSelectedData());
$_SESSION['prjtg_id'] = $prjtg_id;
$_SESSION['prj_id'] = $prj_id;
$_SESSION['prjm_id'] = $prjm_id;
$_SESSION['milestone'] = $milestone;
$_SESSION['grp_num'] = $grp_num;
tutorHelper($dbConn, $isTutor);
pagehead('group photos');
$prjSel->setSubmitOnChange(true);
$prj_id_selector = $prjSel->getSelector();
$page_opening = "Group photos for project {$afko}: {$description} {$year}-" . ($year + 1) . "<br/><span style='font-size:6pt;'> prj_id={$prj_id} milestone {$milestone} (prjm_id={$prjm_id}) group {$grp_num} (prjtg_id={$prjtg_id}) {$grp_alias} </span>";
$nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening);
$nav->setInterestMap($tabInterestCount);
$pg = new GroupPhoto($dbConn, $prjtg_id);
//$pg->setWhereConstraint("prjtg_id in (select prjtg_id from prj_grp where snummer=$peer_id)");
echo $nav->show();
?>
<div id='navmain' style='padding:1em;'>
<div class='nav'>
<form method="get" name="project" action="<?php
echo $PHP_SELF;
?>
">
print <<<EOS
<table border='1' class='mmdata'>
EOS;
$keys = array_keys($row);
foreach ($keys as $key) {
print <<<EOS
<tr>
<th>{$key}</th>
<td class='l'>{$row[$key]}</td>
</tr>
EOS;
}
print <<<EOS
</table>
EOS;
}
### function }}}
if ($mode == 'view') {
pagehead();
$agid = $form['agid'];
ptitle("agents [id={$agid}]");
_view1();
pagetail();
exit;
}
pagehead();
_style();
ptitle('Agent List');
_listview();
pagetail();
exit;
// include("blocked_tail.inc");
// exit;
//}
$page_opening = "Peerweb genereer simpele forms voor DB-relaties";
if (isset($_GET['table_name'])) {
$table_name = trim($_GET['table_name']);
} else {
$table_name = '';
}
if (isset($_GET['veld_naam'])) {
$veld_naam = trim($_GET['veld_naam']);
} else {
$veld_naam = 'veld';
}
$sql = "SELECT table_name as name, table_name as value from information_schema.tables WHERE table_schema = 'public'";
pagehead('Form generator');
$nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening);
$nav->setInterestMap($tabInterestCount);
$nav->show();
?>
<div id='navmain' style='padding:1em;'>
<?php
echo 'Het include path =' . ini_get('include_path');
$arr = array();
global $PHP_SELF;
$sql2 = "select distinct table_name as name, table_name as value from information_schema.columns where table_schema='public' order by name";
?>
<h2>Form genereren</h2>
<p>Hiermee kun je een eenvoudige tabel voor in een 'form' laten genereren voor een database relatie (table of view).</p>
<p>Deze versie is nog niet erg slim. Met name bij het gebruik van de gegenereerd tabel uit een view moet je verstandig
omgaan met de primary key velden van de (onderliggende database-)tabel. </p>
document.form.submit();
}
function sf_d() {
if (!confirm('Delete?')) return;
var form = document.form;
form.mode.value = 'dodelete';
//form.target = 'hiddenframe'
form.submit();
}
</script>
EOS;
pagetail();
exit;
}
### }}}
pagehead($pgtitle);
ParagraphTitle($pgtitle);
ParagraphTitle("OS Template", 1);
$qry = "SELECT O.*\n, R.affiliation, R.cmf, R.cc\n FROM ostpl O\n LEFT JOIN resources R ON O.resid=R.id";
$ret = myQuery($qry);
print <<<EOS
<table border='1' class='mmdata'>
<th>#</th>
<th>Affiliation</th>
<th>CC</th>
<th>CMF</th>
<th>OSID</th>
<th>Date</th>
</tr>
EOS;
$_SESSION['milestone'] = $milestone;
$filename = 'ads_data_' . $afko . '-' . date('Ymd') . '.csv';
$csvout = 'N';
$csvout_checked = '';
if (isset($_REQUEST['csvout'])) {
$csvout = $_REQUEST['csvout'];
$csvout_checked = $csvout == 'Y' ? 'checked' : '';
}
$sql = "select snummer,achternaam,roepnaam,voorvoegsel,lower(course_short) as opleiding,\n" . "cohort,email1 as email,pcn,hoofdgrp,lower(lang) as language from student \n" . "join fontys_course on(course=opl) where snummer in \n" . "(select snummer from prj_grp join prj_tutor using(prjtg_id) where prjm_id={$prjm_id})\n";
//$dbConn->log($sql);
$rainbow = new RainBow(STARTCOLOR, COLORINCREMENT_RED, COLORINCREMENT_GREEN, COLORINCREMENT_BLUE);
if ($csvout == 'Y') {
$dbConn->queryToCSV($sql, $filename, ',', true, 'Content-type: application/vnd.sun.xml.calc; charset: utf-8;');
exit(0);
}
pagehead('Get ads data for students in project');
$page_opening = "Ads data to create student accounts in fthv domain for project " . "<i>\"{$afko} {$description}\"</i> prj_id {$prj_id} milestone {$milestone} prjm_id {$prjm_id}";
$nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening);
$nav->setInterestMap($tabInterestCount);
$prjSel->setJoin('milestone_grp using (prj_id,milestone)');
$prj_id_selector = $prjSel->getSelector();
echo $nav->show();
?>
<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;
