/**
* Gets a list of papers for which feadback is available for.
* @param int $userID - The ID of the user to display the plots for. Usually the current student user but could be a member of staff viewing a student.
* @param object $db - Mysqli database link.
* @return array - List of papers that the user has sat and have been released.
*/
function get_taken_papers($userID, $db)
{
$papers = array();
$i = 0;
// Query for Summative and Offline papers
$result = $db->prepare("SELECT DISTINCT log_metadata.id, paperID, paper_title, paper_type, pass_mark, calendar_year, started, crypt_name, idfeedback_release, type FROM log_metadata, properties LEFT JOIN feedback_release ON properties.property_id = feedback_release.paper_id WHERE log_metadata.paperID = properties.property_id AND paper_type IN ('2', '5') AND userID = ? AND feedback_release.type = 'cohort_performance' ORDER BY calendar_year DESC");
$result->bind_param('i', $userID);
$result->execute();
$result->store_result();
$result->bind_result($metadataID, $paperID, $paper_title, $paper_type, $pass_mark, $calendar_year, $started, $crypt_name, $idfeedback_release, $feedback_type);
while ($result->fetch()) {
$papers[$i]['metadataID'] = $metadataID;
$papers[$i]['paperID'] = $paperID;
$papers[$i]['paper_title'] = $paper_title;
$papers[$i]['paper_type'] = $paper_type;
$papers[$i]['calendar_year'] = $calendar_year;
$papers[$i]['started'] = $started;
$papers[$i]['crypt_name'] = $crypt_name;
$papers[$i]['pass_mark'] = $pass_mark;
$results_cache = new ResultsCache($db);
$papers[$i]['stats'] = $results_cache->get_paper_cache($paperID);
$papers[$i]['idfeedback_release'] = $idfeedback_release;
$papers[$i]['feedback_type'] = $feedback_type;
$i++;
}
$result->close();
// Query for OSCE stations
$result = $db->prepare("SELECT DISTINCT log4_overall.id, q_paper, paper_title, paper_type, pass_mark, calendar_year, started, crypt_name, idfeedback_release, type FROM log4_overall, properties LEFT JOIN feedback_release ON properties.property_id = feedback_release.paper_id WHERE log4_overall.q_paper = properties.property_id AND paper_type IN ('4') AND userID = ? AND feedback_release.type = 'cohort_performance' ORDER BY calendar_year DESC");
$result->bind_param('i', $userID);
$result->execute();
$result->store_result();
$result->bind_result($metadataID, $paperID, $paper_title, $paper_type, $pass_mark, $calendar_year, $started, $crypt_name, $idfeedback_release, $feedback_type);
while ($result->fetch()) {
$papers[$i]['metadataID'] = $metadataID;
$papers[$i]['paperID'] = $paperID;
$papers[$i]['paper_title'] = $paper_title;
$papers[$i]['paper_type'] = $paper_type;
$papers[$i]['calendar_year'] = $calendar_year;
$papers[$i]['started'] = $started;
$papers[$i]['crypt_name'] = $crypt_name;
$papers[$i]['pass_mark'] = $pass_mark;
$results_cache = new ResultsCache($db);
$papers[$i]['stats'] = $results_cache->get_paper_cache($paperID);
$papers[$i]['idfeedback_release'] = $idfeedback_release;
$papers[$i]['feedback_type'] = $feedback_type;
$i++;
}
$result->close();
$sortby = 'calendar_year';
$ordering = 'desc';
$papers = array_csort($papers, $sortby, $ordering);
return $papers;
}
<script type="text/javascript" src="../js/toprightmenu.js"></script>
</head>
<body>
<?php
require '../include/toprightmenu.inc';
echo draw_toprightmenu();
?>
<div id="content">
<form action="<?php
echo $_SERVER['PHP_SELF'] . '?paperID=' . $paperID;
?>
" method="post">
<?php
$results_cache = new ResultsCache($mysqli);
$marks = array_values($results_cache->get_paper_marks_by_paper($paperID, true));
$stats = array_values($results_cache->get_paper_cache($paperID));
echo "<div class=\"head_title\">\n";
echo "<div><img src=\"../artwork/toprightmenu.gif\" id=\"toprightmenu_icon\" /></div>\n";
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=' . $_GET['paperID'] . '">' . $properties->get_paper_title() . '</a><img src="../artwork/breadcrumb_arrow.png" class="breadcrumb_arrow" alt="-" /><a href="index.php?paperID=' . $paperID . '&module=&folder=">' . $string['standardssetting'] . '</a></div>';
echo "<div class=\"page_title\">" . $string['hofstee'] . "</div>";
echo "</div>\n";
echo "<table style=\"margin:10px\">";
echo "<tr><td style=\"min-width:150px\">" . $string['cohortsize'] . "</td><td>" . count($marks) . "</td></tr>\n";
echo "<tr><td>" . $string['maximumscore'] . "</td><td>" . round($stats[1], 1) . "%</td></tr>\n";
echo "<tr><td>" . $string['topquartile'] . "</td><td>" . round($stats[6], 1) . "%</td></tr>\n";
