function index($config, $parameters)
{
loadModel('models/Students');
$students = getAllStudents($config);
if ($students['status']) {
if (isset($_SESSION['uname'])) {
$students['loggedIn'] = true;
}
if (isset($_SESSION['urole'])) {
$students['role'] = $_SESSION['urole'];
}
if (isset($_SESSION['addStatus'])) {
$students['addStatus'] = $_SESSION['addStatus'];
$_SESSION['addStatus'] = null;
unset($_SESSION['addStatus']);
}
if (isset($_SESSION['addStatusMessage'])) {
$students['addStatusMessage'] = $_SESSION['addStatusMessage'];
$_SESSION['addStatusMessage'] = null;
unset($_SESSION['addStatusMessage']);
}
return $students;
}
return ['status' => false, 'message' => 'An error occured while trying to retrieve Students records.', 'code' => 500];
}
$role = validateRequest($userid, $userval, $external);
if (!$role) {
failRequest("There was a problem validating your request");
}
switch ($requestType) {
case "STUDENTSBYSET":
if (!authoriseUserRoles($role, ["SUPER_USER", "STAFF"])) {
failRequest("You are not authorised to complete that request");
}
getStudentsForSet($setid, $orderby, $desc);
break;
case "ALLSTUDENTS":
if (!authoriseUserRoles($role, ["SUPER_USER", "STAFF"])) {
failRequest("You are not authorised to complete that request");
}
getAllStudents($orderby, $desc);
break;
default:
break;
}
function getStudentsForSet($setid, $orderby, $desc)
{
$query = "select U.`User ID` ID, U.`First Name` FName, U.`Surname` SName, S.`Preferred Name` PName from TUSERGROUPS UG\n join TSTUDENTS S ON S.`User ID` = UG.`User ID`\n join TUSERS U ON U.`User ID` = S.`User ID`";
$query .= filterBy(["UG.`Group ID`", "UG.`Archived`"], [$setid, "0"]);
$query .= orderBy([$orderby], [$desc]);
try {
$students = db_select_exception($query);
} catch (Exception $ex) {
$message = "There was an error loading the students";
returnToPageError($ex, $message);
}
<!-- Optional theme -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap-theme.min.css">
<head>
<body>
<form method ="POST" action="">
<div class="row">
<div class="col-md-1"></div>
<div class="col-lg-10">
<!-- creating registered Student list -->
<?php
require 'API.php';
/* adding API */
$registerStudent = getAllStudents();
$totalStudent = count($registerStudent);
//print_r($registerStudent[0]);//testing
?>
<h2>
Registered Student
<?php
echo "[{$totalStudent}]";
?>
</h2>
<table class="table table-striped">
<tr>
<th>ID</th>
<th></th>
<th></th>
<?php
require_once '../api/student.php';
include '../templates/includes/header.html';
?>
<style>
body{margin-left:25px}
</style>
<h1>Students:</h1>
<ul>
<?php
$listStudents = getAllStudents();
foreach ($listStudents as $student) {
echo "<li><a href='metrics/userMetrics.php?type=Student&email=" . $student['email'] . "'>" . $student['name'] . "</a></li>";
}
?>
</ul>
<?php
include '../templates/includes/footer.html';
break;
case 3:
echo json_encode(getAllGroups());
break;
case 4:
echo json_encode(getTasksFromClass($_POST['group']));
break;
case 5:
echo json_encode(getStudentsFromClass($_POST['group']));
break;
case 6:
echo json_encode(getAllGroupsReport());
break;
case 7:
echo json_encode(getTeacherUserGroupsReport($_POST['id']));
break;
case 8:
echo json_encode(getAllStudents());
break;
case 9:
if (isset($_POST['student'])) {
echo json_encode(getStudent($_POST['student']));
} else {
echo "No proper data";
}
break;
default:
}
} else {
echo "No proper data";
}
