function getModules($userID, $mysqlidb)
{
$modules = array();
$session = date_utils::get_current_academic_year();
$result = $mysqlidb->prepare("SELECT idmod FROM modules_student WHERE calendar_year = ? AND userID = ?");
$result->bind_param('si', $session, $userID);
$result->execute();
$result->bind_result($moduleid);
$result->store_result();
while ($result->fetch()) {
$modules[] = module_utils::get_moduleid_from_id($moduleid, $mysqlidb);
}
$result->close();
return $modules;
}
$folder = $_GET['folder'];
} else {
$folder = '';
}
?>
<div id="content">
<div class="head_title">
<div><img src="../artwork/toprightmenu.gif" id="toprightmenu_icon" /></div>
<div class="breadcrumb"><a href="../index.php"><?php
echo $string['home'];
?>
</a><img src="../artwork/breadcrumb_arrow.png" class="breadcrumb_arrow" alt="-" /><a href="../module/index.php?module=<?php
echo $modID;
?>
"><?php
echo module_utils::get_moduleid_from_id($modID, $mysqli);
?>
</a><img src="../artwork/breadcrumb_arrow.png" class="breadcrumb_arrow" alt="-" /><a href="sessions_list.php?module=<?php
echo $modID . '&folder=' . $folder;
?>
"><?php
echo $string['manageobjectives'];
?>
</a></div>
<div class="page_title"><?php
echo $string['newsession'];
?>
</div>
</div>
<br />
<?php
// paper_options.inc modifies result! Store it temporarily
$import_result = $result;
require '../include/paper_options.inc';
require '../include/toprightmenu.inc';
echo draw_toprightmenu();
$result = $import_result;
?>
<div id="content">
<div class="head_title">
<div><img src="../artwork/toprightmenu.gif" id="toprightmenu_icon" /></div>
<?php
echo "<div class=\"breadcrumb\">";
echo '<a href="../index.php">' . $string['home'] . '</a>';
if ($module != '') {
echo '<img src="../artwork/breadcrumb_arrow.png" class="breadcrumb_arrow" alt="-" /><a href="../module/index.php?module=' . $module . '">' . module_utils::get_moduleid_from_id($_GET['module'], $mysqli) . '</a>';
} elseif ($folder != '') {
echo '<img src="../artwork/breadcrumb_arrow.png" class="breadcrumb_arrow" alt="-" /><a href="../folder/index.php?folder=' . $folder . '">' . $folder_name . '</a>';
}
echo "</div><div class=\"page_title\">{$paper_title}</div>";
echo "</div>";
?>
<br/>
<br/>
<br/>
<br/>
<table border="0" cellpadding="0" cellspacing="0" class="dialog_border" style="width:500px; text-align:left">
<tr>
<td class="dialog_header" style="width:55px"><img src="../artwork/ims_logo.png" width="47" height="44" alt="IMS Logo" /></td><td class="dialog_header" style="width:445px; font-size:160%; font-weight:bold; color:#5582D2"><?php
echo $string['qtiimport'];
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
// GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with Rogō. If not, see <http://www.gnu.org/licenses/>.
/**
*
* @author Simon Wilkinson
* @version 1.0
* @copyright Copyright (c) 2014 The University of Nottingham
* @package
*/
require '../../include/staff_auth.inc';
require_once '../../classes/moduleutils.class.php';
if (isset($_GET['teamID'])) {
if (!module_utils::get_moduleid_from_id($_GET['teamID'], $mysqli)) {
$msg = sprintf($string['furtherassistance'], $configObject->get('support_email'), $configObject->get('support_email'));
$notice->display_notice_and_exit($mysqli, $string['pagenotfound'], $msg, $string['pagenotfound'], '../../artwork/page_not_found.png', '#C00000', true, true);
}
}
?>
<html>
<head>
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<meta http-equiv="content-type" content="text/html;charset=<?php
echo $configObject->get('cfg_page_charset');
?>
" />
<title>by Paper</title>
<link rel="stylesheet" type="text/css" href="../../css/body.css" />
">
<div class="head_title">
<div style="float:right; vertical-align:top"><img src="../artwork/toprightmenu.gif" id="toprightmenu_icon" /></div>
<?php
echo "<div class=\"breadcrumb\"><a href=\"../index.php\">" . $string['home'] . "</a>";
if (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 "</div><div class=\"page_title\">" . $string['usersearch'] . " ({$user_no}): <span style=\"font-weight: normal\">";
if (isset($_GET['paperID'])) {
echo implode(', ', array_values($paper_modules)) . ' (' . $paper_calendar_year . ')';
} elseif (isset($_GET['search_surname']) and $_GET['search_surname'] != '') {
echo "'" . $_GET['search_surname'] . "'";
} elseif (isset($_GET['module']) and $_GET['module'] != '%') {
echo module_utils::get_moduleid_from_id($_GET['module'], $mysqli);
if (isset($_GET['calendar_year']) and $_GET['calendar_year'] != '' and isset($_GET['students']) and $_GET['students'] != '') {
echo ' (' . $_GET['calendar_year'] . ')';
}
} elseif (isset($_GET['search_username']) and $_GET['search_username'] != '') {
echo $_GET['search_username'];
} elseif (isset($_GET['student_id']) and $_GET['student_id'] != '') {
echo $_GET['student_id'];
} elseif (isset($_GET['calendar_year']) and $_GET['calendar_year'] != '%') {
echo $_GET['calendar_year'];
}
echo "</span></div>\n";
echo "</div>\n";
if (isset($_GET['search_surname'])) {
$tmp_surname = $_GET['search_surname'];
} else {
$lab_details = array($string['default'] => array('-1' => $string['alllabs']));
$stmt = $mysqli->prepare("SELECT id, building, room_no, campus FROM labs ORDER BY campus, building, room_no");
$stmt->execute();
$stmt->bind_result($id, $building, $room_no, $campus);
while ($stmt->fetch()) {
$lab_details[$campus][$id] = $building . ' - ' . $room_no;
}
$stmt->close();
?>
<form action="" method="get" id="theform">
<table class="header">
<tr><th>
<?php
if (isset($_GET['module'])) {
echo '<div class="breadcrumb"><a href="../index.php">' . $string['home'] . '</a><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></div>';
} else {
if ($userObject->has_role('SysAdmin')) {
echo '<div class="breadcrumb"><a href="../index.php">' . $string['home'] . '</a><img src="../artwork/breadcrumb_arrow.png" class="breadcrumb_arrow" alt="-" /><a href="./index.php">' . $string['administrativetools'] . '</a></div>';
} else {
echo '<div class="breadcrumb"><a href="../index.php">' . $string['home'] . '</a></div>';
}
}
?>
<div class="page_title"><?php
echo $string['calendar'];
?>
: <span style="font-weight:normal"><?php
echo $current_year;
?>
</span></div></th>
* @version 1.0
* @copyright Copyright (c) 2014 The University of Nottingham
* @package
*/
require_once '../include/staff_auth.inc';
require_once '../include/errors.inc';
require_once '../include/mapping.inc';
require_once '../classes/moduleutils.class.php';
$errors = array();
if (empty($_POST['source_y']) or empty($_POST['dest_y']) or empty($_POST['moduleID'])) {
$errors[] = "Undefined source or destination year";
} elseif ($_POST['source_y'] == $_POST['dest_y']) {
$errors[] = "Source and destination years cannot be the same";
} else {
// Get the sessions for the source year
$module_code = module_utils::get_moduleid_from_id($_POST['moduleID'], $mysqli);
$modules_array = array($_POST['moduleID'] => $module_code);
$objectives = getObjectives($modules_array, $_POST['source_y'], '', '', $mysqli);
try {
copyObjectives($objectives, $_POST['moduleID'], $module_code, $_POST['dest_y'], $mysqli);
} catch (Exception $ex) {
$errors[] = "An error occured when copying the objectives. Please try again.";
}
}
?>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<meta http-equiv="content-type" content="text/html;charset=<?php
echo $configObject->get('cfg_page_charset');
// You should have received a copy of the GNU General Public License
// along with Rogō. If not, see <http://www.gnu.org/licenses/>.
/**
*
* Confirm that it is OK to proceed deleting a module.
*
* @author Simon Wilkinson
* @version 1.0
* @copyright Copyright (c) 2014 The University of Nottingham
* @package
*/
require '../include/sysadmin_auth.inc';
require_once '../include/errors.inc';
require_once '../classes/moduleutils.class.php';
$idMod = check_var('idMod', 'GET', true, false, true);
$moduleid = module_utils::get_moduleid_from_id($idMod, $mysqli);
if (!$moduleid) {
$msg = sprintf($string['furtherassistance'], $configObject->get('support_email'), $configObject->get('support_email'));
$notice->display_notice_and_exit($mysqli, $string['pagenotfound'], $msg, $string['pagenotfound'], '../artwork/page_not_found.png', '#C00000', true, true);
}
$mysqli->close();
?>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<meta http-equiv="content-type" content="text/html;charset=<?php
echo $configObject->get('cfg_page_charset');
?>
" />
}
?>
<div class="form">
<h2 class="midblue_header"><?php
echo $string['metadata'];
?>
</h2>
</div>
<?php
$q_teams = array();
if (count($question->get_teams()) > 0) {
$q_teams = $question->get_teams();
} elseif (isset($module)) {
$q_teams[$module] = module_utils::get_moduleid_from_id($module, $mysqli);
}
echo render_metadata($mysqli, $question, $question->use_bloom(), $q_teams, $q_disabled, $string, $userObject);
?>
</div>
</div>
<div id="changes" class="tab-area">
<?php
$changes = $question->get_changes();
echo render_changes($changes, $string);
?>
</div>
<div id="comments" class="tab-area">
<?php
if ($line_no == 0) {
// Read the header row
$heading = $cols;
$col_no = count($cols);
echo "<tr><th></th><th>Username</th><th colspan=\"3\">Student Name</th>";
for ($i = 1; $i < $col_no; $i++) {
echo "<th>" . trim($heading[$i]) . "</th>";
}
echo "</tr>\n";
} else {
// 'username' can be either the real username or sid
$username = trim($cols[0]);
// Check see if user was found
if (!isset($student_id_array[$username])) {
if (UserUtils::userid_exists($username, $mysqli) or UserUtils::username_exists($username, $mysqli)) {
echo "<tr><td><img src=\"../artwork/red_cross_16.png\" wodth=\"16\" height=\"16\" alt=\"Failed\" /></td><td class=\"failed\">{$username}</td><td colspan=\"" . (3 + $col_no) . "\" class=\"failed\" style=\"text-align:center\"><user not registered on " . module_utils::get_moduleid_from_id($_GET['module'], $mysqli) . "></td>";
} else {
echo "<tr><td><img src=\"../artwork/red_cross_16.png\" wodth=\"16\" height=\"16\" alt=\"Failed\" /></td><td class=\"failed\">{$username}</td><td colspan=\"" . (3 + $col_no) . "\" class=\"failed\" style=\"text-align:center\"><unknown user></td>";
}
} else {
$student_id = $student_id_array[$username];
echo "<tr><td><img src=\"../artwork/green_plus_16.png\" wodth=\"16\" height=\"16\" alt=\"Add\" /></td><td>{$username}</td><td>" . $student_data[$student_id]['title'] . "</td><td>" . $student_data[$student_id]['surname'] . "</td><td>" . $student_data[$student_id]['first_names'] . "</td>";
for ($i = 1; $i < $col_no; $i++) {
$type = trim($heading[$i]);
$value = trim($cols[$i]);
echo "<td>{$value}</td>";
if ($type != '') {
$stmt->execute();
}
}
echo "</tr>\n";
}
}
$cols = count($table_order);
echo "<div style=\"font-size:80%\">\n";
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=' . $paperID . '">' . $paper . '</a></div>';
$report_title = $string['classtotals'];
if (isset($_GET['repmodule']) and $_GET['repmodule'] != '') {
$report_title .= ' <span style="font-weight: normal">(' . module_utils::get_moduleid_from_id($_GET['repmodule'], $mysqli) . ' ' . $string['studentsonly'] . ')</span>';
} elseif (isset($_GET['percent']) and $_GET['percent'] < 100) {
if ($ordering == 'desc') {
$report_title .= ' <span style="font-weight: normal">(' . $string['top'] . ' ' . $_GET['percent'] . '%)</span>';
} else {
$report_title .= ' <span style="font-weight: normal">(' . $string['bottom'] . ' ' . $_GET['percent'] . '%)</span>';
}
}
echo "<div class=\"page_title\">{$report_title}</div>";
echo "</div>\n";
// Warning display banners
$report->check_late_submission_warnings();
$report->check_unmarked_textbox_warnings();
$report->check_unmarked_enhancedcalc_warnings();
$report->check_temp_account_warnings();
// Output table header
/**
* Translates from internal numerical module IDs to institution module codes for display.
*/
private function convert_moduleIDs()
{
$result_no = count($this->user_results);
$moduleIDs = array();
// Build up an array of IDs to module codes.
for ($i = 0; $i < $result_no; $i++) {
$id = $this->user_results[$i]['module'];
if ($id != '') {
if (!isset($moduleIDs[$id])) {
$moduleIDs[$id] = module_utils::get_moduleid_from_id($id, $this->db);
}
}
}
// Loop around the results array and convert to codes.
for ($i = 0; $i < $result_no; $i++) {
if (isset($moduleIDs[$this->user_results[$i]['module']])) {
$this->user_results[$i]['module'] = $moduleIDs[$this->user_results[$i]['module']];
}
}
}
}
$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) {
echo $notice->info_strip($string['msg1'], 100) . "</div>\n</body>\n</html>\n";
exit;
}
echo '</div>';
$qid_list = substr($qid_list, 0, -1);
$objByModule = getObjectivesByMapping($moduleID, $session, $paperID, $qid_list, $mysqli);
unset($objByModule['none_of_the_above']);
if (count($objByModule) == 0) {
echo "</table>" . $notice->info_strip($string['msg2'], 100);
} else {
foreach ($objByModule as $module => $mappings) {
foreach ($mappings as $id => $mappingData) {
