Пример #1
0
 }
 if ($bookingUserID != $_SESSION["netID"] && $class == "Student") {
     //determine the length of a given booking in hours
     $response = determineBookingLength($db, $bookingID);
     $bookingLength = $response[0];
     $bookingDate = $response[1];
     $hrsSourceList = array();
     //retrieve hrsSource for each block
     retrieveHrsSource($db, $bookingID);
     //cancel booking
     deleteBooking($db, $bookingID);
     //email user who made booking
     $to = $bookingUserID . "@queensu.ca";
     cancelBooking($room, $building, $startDate, $start, $end, $reason, $desc, $numP, $db, $to, true);
     //determnes which week the booking was booked in
     $week = determineWhichWeek($bookingDate);
     //return hours to the appropriate week and group
     for ($i = 0; $i < count($hrsSourceList); $i++) {
         if (strtolower($hrsSourceList[$i]) == "weekly") {
             returnWeeklyHoursToUser($db, $week, $bookingUserID, 0.5);
         } else {
             returnSpecialHoursToUser($db, $bookingUserID, $hrsSourceList[$i], 0.5);
         }
     }
     http_response_code(200);
     //success
 } else {
     //otherwise they are admin or deleting a faculty booking
     deleteBooking($db, $bookingID);
     //check if admin is deleting a different user's booking
     if ($bookingUserID != $_SESSION["netID"]) {
                     }
                 }
             }
         } else {
             if ($department == "") {
                 //how did you get here!?!?!
                 $result['msg'] = "You cannot be found within the Music or Drama department and therefore may not book a room";
                 http_response_code(406);
                 $bookingDurationError = true;
             }
         }
     }
 }
 if (!$bookingDurationError) {
     //determnes which week the booking was booked in
     $week = determineWhichWeek($startDate);
     $hoursRemaining = 0;
     //confirm if there are weekly hours for that week
     $sth = $db->prepare("SELECT {$week} FROM User WHERE uID = ?");
     $sth->execute(array($uID));
     while ($row = $sth->fetch(PDO::FETCH_ASSOC)) {
         //Get number of blocks
         $hoursRemaining = $row[$week];
     }
     //if there are more weekly hours remaining than the hours required for the book
     if ($hoursRemaining >= $duration) {
         $hrsSource = "Weekly";
         //because they used their weekly hours to book it
         //create booking
         $bookingID = createBookingInDB($db, $uID, $reason, $desc, $numP, $blocks, $startDate, $room, $totalB, $startTime, $endDate, $endTime, $hrsSource);
         //Send bookingID to front end