function convertTagNamesToArray($tag_name_array) { $tag_array = array(); foreach ($tag_name_array as $tag_name) { if (strlen($tag_name) > 0 && $tag_name !== " ") { $name = trim($tag_name); $query = "SELECT `Tag ID` ID, `Name` From TTAGS WHERE Name = '{$name}'"; try { $tag = db_select_exception($query); } catch (Exception $ex) { failRequestWithException("Error getting tags", $ex); } if (count($tag) > 0) { array_push($tag_array, $tag[0]); } } } return $tag_array; }
function getWorksheetInformationFor($array) { $query = "SELECT SQ.`Stored Question ID` SQID, SQ.`Version ID` VID, SQ.`Number` Number, SQ.`Marks` Marks, WV.`WName` WName, WV.`VName` VName, WV.`Link` Link FROM TSTOREDQUESTIONS SQ\n JOIN TQUESTIONS Q ON Q.`Question ID` = SQ.`Question ID`\n JOIN TWORKSHEETVERSION WV ON WV.`Version ID` = SQ.`Version ID`\n WHERE SQ.`Stored Question ID` IN ("; foreach ($array as $row) { $query .= $row["sqid"] . ", "; } $query = substr($query, 0, -2); $query .= ");"; try { $results = db_select_exception($query); } catch (Exception $ex) { failRequestWithException("Something went wrong loading all of the worksheet details", $ex); } foreach ($array as $rowKey => $row) { foreach ($results as $result) { if ($row["sqid"] === $result["SQID"]) { $array[$rowKey]["details"] = $result; // TODO Add a proper break function in here to break the for loop break; } } } return $array; }
function setStudentWorksheetStatus() { global $studentWorksheets, $returns; $query = "SELECT CW.`Group Worksheet ID` GWID, CW.`Notes` Notes, CW.`Completion Status` Comp, CW.`Date Status` Days\n FROM TCOMPLETEDWORKSHEETS CW\n WHERE "; $inputs = $returns["inputs"]; if (array_key_exists("student", $inputs)) { $student = $inputs["student"]; $query .= "CW.`Student ID` = {$student} AND "; } $query .= "CW.`Group Worksheet ID` IN ("; foreach ($studentWorksheets as $worksheet) { $query .= $worksheet["GWID"] . ", "; } $query = substr($query, 0, -2); $query .= ")"; try { $results = db_select_exception($query); foreach ($results as $result) { $studentWorksheets[$result["GWID"]]["Notes"] = $result["Notes"]; $studentWorksheets[$result["GWID"]]["Comp"] = $result["Comp"]; $studentWorksheets[$result["GWID"]]["Days"] = $result["Days"]; } } catch (Exception $ex) { $message = "There was an error generating the report."; failRequestWithException($message, $ex); } }