$specialHrs = $groupInfo['hours'];
}
$insertString = "";
$curWeekUpdateString = "";
$nextWeekUpdateString = "";
$restUpdateString = "";
//Array to hold users being added (error-free)
$usersAddedArray = array();
//Array holding users + info to be added to permission table
$insertArray = array();
//Arrays to hold error users
$alreadyInGroupArray = array();
$notInMasterArray = array();
$badEmailUsers = array();
foreach ($fileLines as $user) {
$netid = getNetId($user);
if ($netid) {
//$netid != false
if (!userInGroup($db, $netid, $groupID)) {
// user is NOT already in group, continue with addition
if (userInMasterList($db, $netid)) {
array_push($usersAddedArray, $netid);
// add user to permissions table
// specialHrs = 0 if the group has weekly hours
$insertString .= "(?,?,?), ";
array_push($insertArray, $netid, $groupID, $specialHrs);
if (groupHasCurWeekHours($groupInfo)) {
// if group has weekly hours that are currently active,
// they should be immediately given to the user
$curWeekUpdateString .= "uID = ? OR ";
}
$badFormatUsers = [];
$badClassUsers = [];
$badEmailUsers = [];
//Arrays to hold query values
$insertMasterArray = array();
$insertUserArray = array();
//process each user
foreach ($fileLines as $user) {
$userData = explode(",", $user);
// userData should have format <*****@*****.**>,<firstName>,<lastName>,<type>
if (4 == sizeof($userData)) {
// userData has expected number of elements
if (checkClass($userData[3])) {
// type is expected format; "Student" | "Faculty" | "Admin"
// TODO: check length and format of elements
$netid = getNetId($userData[0]);
if ($netid) {
//$netid != false
// ('id', 'department')
$insertMasterString .= "(?, ?), ";
array_push($insertMasterArray, $netid, $department);
$curUserInfo = getCurUserInfo($db, $netid);
// check if user is already in User table. If they are, update their personal info if it's different
// if they are not in the User table, add them.
if (empty($curUserInfo)) {
//user not in User table, add them to user table
//('uID', 'firstName', 'lastName', 'class', 'curWeekHrs', 'nextWeekHrs', 'thirdWeekHrs', 'hasBookingDurationRestriction')
$insertUserString .= "(?, ?, ?, ?, ?, ?, ?, ?), ";
array_push($insertUserArray, $netid, $userData[1], $userData[2], $userData[3], $defaultHrs, $defaultHrs, $defaultHrs, 'Yes');
// get class, etc
} else {