<?php
requireCap(CAP_TUTOR);
include_once './peerlib/peerutils.inc';
include_once 'documentfolders2.inc';
include_once 'navigation2.inc';
require_once 'prjMilestoneSelector2.php';
$prj_id = 1;
$milestone = 1;
$prjm_id = 0;
$prjtg_id = 1;
extract($_SESSION);
$prjSel = new PrjMilestoneSelector2($dbConn, $peer_id, $prjm_id);
$prjSel->setJoin('has_uploads using (prj_id,milestone)');
extract($prjSel->getSelectedData());
$_SESSION['prj_id'] = $prj_id;
$_SESSION['prjm_id'] = $prjm_id;
$_SESSION['milestone'] = $milestone;
$doctype = 1;
if (isset($_REQUEST['doctype'])) {
$_SESSION['doctype'] = $doctype = validate($_REQUEST['doctype'], 'integer', 1);
}
if (!isset($_SESSION['doctype'])) {
$sql = "select min(doctype) as doctype from uploads where prjm_id={$prjm_id}";
$resultSet = $dbConn->Execute($sql);
if (!$resultSet->EOF) {
extract($resultSet->fields);
} else {
$doctype = 1;
}
}
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" >
</head>
<body>
';
$message = $bodyprefix . $mailbody . "\n</body>\n</html>\n";
domail($toAddress, $subject, $message, $headers);
// send author a copy, so he 'll know he is confirmed of sending the email.
$recipients = htmlentities(preg_replace('/,/', ",\n", $toAddress));
domail($replyto, $subject . ', your copy', $bodyprefix . $mailbody . "\n<br/><hr/>The above mail has been sent to the following recipients:\n<pre>" . $recipients . "\n</pre>\n" . "\n</body>\n</html>\n", $headers);
if ($triggerList != '') {
$subject = 'You have mail at your fontys email address';
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');
include_once './peerlib/peerutils.inc';
require_once './peerlib/validators.inc';
include_once 'navigation2.inc';
require_once 'prjMilestoneSelector2.php';
require_once 'TableBuilder.class.php';
require_once 'TaskRowFactory.class.php';
requireScribeCap($peer_id);
// get group tables for a project
$prj_id = 0;
$prjm_id = 0;
$milestone = 1;
$afko = 'PRJ00';
$description = '';
extract($_SESSION);
$prjSel = new PrjMilestoneSelector2($dbConn, $peer_id, $prjm_id);
$prjSel->setJoin('milestone_grp using (prj_id,milestone) natural join activity_project ');
$prjSel->setJoin(' all_project_scribe using(prj_id) ');
$prjSel->setWhere(' prj_id in (select prj_id from project_task) and ' . $peer_id . '=scribe');
extract($prjSel->getSelectedData());
$_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();
$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'>");
//$form2Form->addText( "Legend:class name [class size]<br/>\n" );
$sql = "select distinct rtrim(student_class.sclass) as sclass,class_id,sort1,sort2,sort_order,\n" . "rtrim(faculty.faculty_short) as opl_afko, student_count,rtrim(faculty.faculty_short) as faculty_short,\n" . "trim(cluster_name) as cluster_name,class_cluster \n" . "from student_class\n" . " join faculty using(faculty_id)\n" . "join class_cluster using(class_cluster)\n" . "join current_student_class using (class_id) join class_size using(class_id)\n " . "where sort2 < 9 and sclass not like 'UIT%' \n" . "order by sort_order,faculty_short desc,cluster_name,sort1,sort2,sclass asc";
$resultSet = $dbConn->Execute($sql);
if ($resultSet === false) {
die("<br>Cannot get groups with \"" . $sql . '", cause ' . $dbConn->ErrorMsg() . "<br>");
}
//ob_start();
$opl_afko = '';
$trans_title = "title = 'operator {$operator} at {$ts} from {$from_ip}'";
}
return "\t<td>\n" . "\t\t<div style='font-size:80%' id='radio_{$snummer}' class='{$divClass}'>\n" . "\t\t\t<input type='radio' class='absent a{$grp_id}' name='mark_{$snummer}[]'" . " value='' {$checkedAbsent} style='vertical-align: middle' onChange='this.parentNode.className=\"absent\"'>Absent <br/>\n" . "\t\t\t<input type='radio' class='present p{$grp_id}' name='mark_{$snummer}[]'" . " value='P' {$checkedPresent} style='vertical-align: middle' onChange='this.parentNode.className=\"present\"'/>Present <br/>\n" . "\t\t\t<input type='radio' class='reason r{$grp_id}' name='mark_{$snummer}[]' " . "value='A' {$checkedReason} style='vertical-align: middle' onChange='this.parentNode.className=\"reason\"'/>Absent with reason \n" . "\t\t</div>\n\t</td>" . "\t<td class='tabledata'><textarea rows='2' cols='50' name='comment[]'>{$comment}</textarea></td>\n";
// ."\t<td class='tabledata num' $trans_title >$trans_id</td>\n";
}
public function buildHeaderCell($valueArray)
{
return '';
}
}
$prjm_id = 0;
$act_id = 1;
extract($_SESSION);
//$dbConn->setSqlAutoLog(true);
$prjSel = new PrjMilestoneSelector2($dbConn, $peer_id, $prjm_id);
$prjSel->setJoin(' all_project_scribe aps using(prj_id) ');
$prjSel->setWhere(" {$peer_id} =aps.scribe ");
extract($prjSel->getSelectedData());
$_SESSION['prj_id'] = $prj_id;
$_SESSION['prjm_id'] = $prjm_id;
$_SESSION['milestone'] = $milestone;
if (isset($_REQUEST['act_id'])) {
$_SESSION['act_id'] = $act_id = validate($_REQUEST['act_id'], 'integer', $act_id);
} else {
if (!defined($_SESSION['act_id'])) {
// get last defined activity for project milestone
$sql = "select max(act_id) as act_id from activity where prjm_id={$prjm_id}";
$rs = $dbConn->Execute($sql);
if (!$rs->EOF) {
extract($rs->fields);
$_SESSION['act_id'] = $act_id;
$class = $title = '';
}
$result .= "\t\t<td {$class} {$title}>" . $valueArray['check'] . "</td>\n";
return $result;
}
}
// get group tables for a project
$prj_id = 0;
$prjm_id = 0;
$milestone = 1;
$afko = 'PRJ00';
$description = '';
extract($_SESSION);
$prjSel = new PrjMilestoneSelector2($dbConn, $peer_id, $prjm_id);
//$prjSel->setJoin('milestone_grp using (prj_id,milestone) natural join activity_project ');
$prjSel->setJoin('activity_project using(prj_id) join all_project_scribe using(prj_id) ');
$prjSel->setWhere(' prjm_id in (select prjm_id from activity) and ' . $peer_id . '=scribe');
extract($prjSel->getSelectedData());
$_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();
$scripts = '<script type="text/javascript" src="js/jquery.js"></script>
<script src="js/jquery.tablesorter.js"></script>
<script type="text/javascript">
$(document).ready(function() {
// do stuff when DOM is ready
$("#myTable").tablesorter({ });
});
</script>
<link rel=\'stylesheet\' type=\'text/css\' href=\'' . SITEROOT . '/style/tablesorterstyle.css\'/>
';
pagehead2('Get the raw data of an assessment', $scripts);
$page_opening = "Scores voor module {$afko}: {$description} ({$year}) milestone {$milestone} " . "<span style='font-size:6pt;'>({$prj_id} M {$milestone})</span>";
$nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening);
$nav->setInterestMap($tabInterestCount);
$prjSel->setJoin('available_assessment using (prjm_id)');
$prj_id_selector = $prjSel->getSelector();
echo $nav->show();
?>
<div id='navmain' style='padding:1em;'>
<p>Deze pagina maakt het mogelijk de ingevulde waarden voor een module (project) op te halen.
De gegevens worden gepresenteerd als een tabel of een csv file die automatisch door excel wordt opengemaakt</p>
<p>De naam van de csv-file wordt gemaakt van module afkorting, grp,milestone en datum van opvragen.
Daarbij wordt groep als een underscore weergegeven indien alle groepen wordt opgevraagd. Voorbeeld:<strong>PRJ11Am1_2004-10-09.csv</strong></p>
<form method="post" name="moduleresult" action="<?php
echo $PHP_SELF;
?>
">
<table>
<tr><th>Project milestone</th><td><?php
echo $prj_id_selector;
