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