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);
}
$response = array("success" => TRUE, "students" => $students);
echo json_encode($response);
}
function getSetsForStaffMember($staffid, $orderby, $desc)
{
$query = "select G.`Group ID` ID, G.`Name` Name from TGROUPS G\n join TUSERGROUPS UG on G.`Group ID` = UG.`Group ID`";
$query .= filterBy(["UG.`User ID`", "G.`Type ID`", "UG.`Archived`"], [$staffid, 3, 0]);
$query .= orderBy([$orderby], [$desc]);
try {
$sets = db_select_exception($query);
} catch (Exception $ex) {
errorLog("Error loading the worksheets: " . $ex->getMessage());
$response = array("success" => TRUE);
echo json_encode($response);
}
$response = array("success" => TRUE, "sets" => $sets);
echo json_encode($response);
}
function getAllCompletedWorksheetsForGroup($groupid, $staffid, $orderby, $desc)
{
$query = "SELECT GW.`Group Worksheet ID` ID, WV.`WName` WName, DATE_FORMAT(GW.`Date Due`, '%d/%m/%Y') DueDate FROM TGROUPWORKSHEETS GW \n JOIN TWORKSHEETVERSION WV ON GW.`Version ID` = WV.`Version ID` ";
$query .= filterBy(["GW.`Group ID`", "GW.`Primary Staff ID`", "WV.`Deleted`"], [$groupid, $staffid, "0"]);
$query .= "AND (GW.`Deleted` IS NULL OR GW.`Deleted` = 0) ";
$query .= orderBy([$orderby], [$desc]);
try {
$worksheets = db_select_exception($query);
} catch (Exception $ex) {
$message = "There was an error retrieving the worksheets";
returnToPageError($ex, $message);
}
$response = array("success" => TRUE, "worksheets" => $worksheets);
echo json_encode($response);
exit;
}
