function getDefaultWeeklyHours($db, $userID)
{
$getDeptQuery = "SELECT department FROM Master WHERE uID = '{$userID}'";
$getDeptStmt = $db->prepare($getDeptQuery);
$getDeptStmt->execute([]);
$defaultHrs = 0;
while ($dept = $getDeptStmt->fetch(PDO::FETCH_ASSOC)["department"]) {
//can be multiple departments
$defaultHrs += getDepartmentDefaultWeeklyHours($db, $dept);
}
return $defaultHrs;
}
$updateInfoStmt = $db->prepare($updateInfoQuery);
$updateInfoStmt->execute(array($userData[1], $userData[2], $userData[3], $netid));
}
}
// reads in file and stores contents in $contents
// each element has format <email>,<firstName>,<lastName>,<type>
// <type> = "Student" | "Faculty" | "Admin"
require '../uploadFile.php';
$fileLines = processFile();
if (!$fileLines) {
//error occured with file upload
http_response_code(400);
//Bad request
die;
}
$defaultHrs = getDepartmentDefaultWeeklyHours($db, $department);
try {
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$db->beginTransaction();
//drop entries in master list that are from the department
$dropMasterQuery = "DELETE FROM Master WHERE department= ?";
$dropMasterStmt = $db->prepare($dropMasterQuery);
$dropMasterStmt->execute(array($department));
$insertMasterString = "";
$insertUserString = "";
$badFormatUsers = [];
$badClassUsers = [];
$badEmailUsers = [];
//Arrays to hold query values
$insertMasterArray = array();
$insertUserArray = array();
