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; }