Esempio n. 1
0
?>
</td></tr>
    </table>
  <?php 
echo "<div style=\"position:absolute; top:0; left:0; width:100%\">\n";
echo "<table class=\"header\">\n";
echo "<tr><th style=\"padding:10px\"><div style=\"font-size:220%; font-weight:bold\">{$paper_title}</div>\n";
echo "<div><strong>{$student_name} " . $string['feedback'] . "</strong></div></th>";
echo "<th style=\"text-align:right; vertical-align:top\"><img src=\"../artwork/toprightmenu.gif\" id=\"toprightmenu_icon\" /></th></tr>\n";
if ($userObject->has_role(array('SysAdmin', 'Admin', 'Staff')) and !isset($_GET['userID'])) {
    echo "<tr><td class=\"yellowwarn\"><div style=\"margin-left:10px\">" . $string['staffmsg'] . "</div></td></tr>\n";
}
// Get Cohort Data
$tmp_start_date = DateTime::createFromFormat('U', $start_date);
$tmp_end_date = DateTime::createFromFormat('U', $end_date);
$chort_question_data = getCohortData($mysqli, $moduleID, $tmp_start_date->format('YmdHis'), $tmp_end_date->format('YmdHis'), '%', '%', '%', $paperID, $paper_type, '');
// Get users log data excluding exclued questions
$qid_list = '';
$question_data = array();
$metadataID_SQL = '';
if (isset($_GET['metadataID'])) {
    $metadataID_SQL = ' AND log_metadata.id = ' . $_GET['metadataID'];
}
if ($paper_type == '0' or $paper_type == '1') {
    $sql = "SELECT q_id, mark, totalpos, started FROM log0, log_metadata WHERE log0.metadataID = log_metadata.id AND q_id NOT IN (SELECT q_id FROM question_exclude WHERE paperID = ?) AND userID = ? AND paperID = ? UNION SELECT q_id, mark, totalpos, started FROM log1, log_metadata WHERE log1.metadataID = log_metadata.id AND q_id NOT IN (SELECT q_id FROM question_exclude WHERE paperID = ?) AND userID = ? AND paperID = ? {$metadataID_SQL} ORDER BY q_id, started";
} elseif ($paper_type == '4') {
    $sql = "SELECT log4.q_id, log4.rating, NULL, NULL AS totalpos FROM log4 INNER JOIN log4_overall l4o ON log4.log4_overallID = l4o.id WHERE log4.q_id NOT IN (SELECT q_id FROM question_exclude WHERE q_paper = ?) AND l4o.userID = ? AND l4o.q_paper = ? ORDER BY log4.q_id, l4o.started";
} else {
    $sql = "SELECT q_id, mark, totalpos, NULL FROM log{$paper_type}, log_metadata WHERE log{$paper_type}.metadataID = log_metadata.id AND q_id NOT IN (SELECT q_id FROM question_exclude WHERE paperID = ?) AND userID = ? AND paperID = ? {$metadataID_SQL} ORDER BY q_id, started";
}
$result = $mysqli->prepare($sql);
Esempio n. 2
0
<div style="font-size:90%">
<?php 
// Get some paper properties
$propertyObj = PaperProperties::get_paper_properties_by_id($paperID, $mysqli, $string);
$paper_title = $propertyObj->get_paper_title();
$paper_type = $propertyObj->get_paper_type();
$session = $propertyObj->get_calendar_year();
$moduleID = Paper_utils::get_modules($paperID, $mysqli);
if ($_GET['percent'] != 100 and $_GET['percent'] != '') {
    $percent = $_GET['percent'];
} else {
    $percent = 100;
}
$student_no = 0;
$user_total = 0;
$question_data = getCohortData($mysqli, $moduleID, $startdate, $enddate, $_GET['repcourse'], $_GET['repmodule'], '%', $paperID, $paper_type, $_GET['ordering'], $student_no, $user_total, $percent);
echo '<div class="head_title">';
echo '<div><img src="../artwork/toprightmenu.gif" id="toprightmenu_icon" /></div>';
echo '<div class="breadcrumb"><a href="../index.php">' . $string['home'] . '</a>';
if (isset($_GET['folder']) and $_GET['folder'] != '') {
    echo '<img src="../artwork/breadcrumb_arrow.png" class="breadcrumb_arrow" alt="-" /><a href="../folder/index.php?folder=' . $_GET['folder'] . '">' . folder_utils::get_folder_name($_GET['folder'], $mysqli) . '</a>';
} elseif (isset($_GET['module']) and $_GET['module'] != '') {
    echo '<img src="../artwork/breadcrumb_arrow.png" class="breadcrumb_arrow" alt="-" /><a href="../module/index.php?module=' . $_GET['module'] . '">' . module_utils::get_moduleid_from_id($_GET['module'], $mysqli) . '</a>';
}
echo '<img src="../artwork/breadcrumb_arrow.png" class="breadcrumb_arrow" alt="-" /><a href="../paper/details.php?paperID=' . $paperID . '">' . $paper_title . '</a></div>';
echo "<div class=\"page_title\">" . $string['learningobjectiveanalysis'];
if (isset($_GET['repmodule']) and $_GET['repmodule'] != '') {
    echo ' (' . module_utils::get_moduleid_from_id($_GET['repmodule'], $mysqli) . ' ' . $string['studentsonly'] . ')';
}
echo "</div>\n";
if ($student_no == 0) {