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