Approve Bookings - Department of Biological Sciences, Studies in Life Sciences

Biotron Administration System: The following booking has been Reject

"; $sql="SELECT * FROM Biotron_Bookings WHERE BookingID=$BookingID"; $result_Approve_Booking=mysqli_query('Content', $sql); if($Approve_Booking=mysqli_fetch_assoc($result_Approve_Booking)) { $sql="SELECT * FROM People WHERE ccid='". $Approve_Booking['CCID']."'"; $result_People=mysqli_query('Content', $sql); if($Current_People=mysqli_fetch_assoc($result_People)) { $sql="SELECT * FROM Biotron_Chamber WHERE ChamberID=". $Approve_Booking['ChamberID']; $result_Chamber=mysqli_query('Content', $sql); if($Current_Chamber=mysqli_fetch_assoc($result_Chamber)) { ?>

ChamberID	ID	Start Date	End Date
".$Current_Chamber['Room_Number']."	".$Current_People['FirstName'].", ".$Current_People['LastName']."	".date('F j, Y', strtotime($Approve_Booking['Start_Date']))."	".date('F j, Y', strtotime($Approve_Booking['End_Date']))."

"; } } } $sql="DELETE FROM Biotron_Bookings WHERE BookingID=$BookingID"; if($result_Delete_Booking=mysqli_query('Content', $sql)) { //****************************************** //** REJECTED BOOKING EMAIL ** //****************************************** $to = $Current_People['ccid'].'@ualberta.ca'; $subject = 'Biotron Booking'; $message = " Biotron Booking Rejected

Biotron Booking Rejected

Room Number	Start Date	End Date	Status
".$Current_Chamber['Room_Number']."	".date('F j, Y', strtotime($Approve_Booking['Start_Date']))."	".date('F j, Y', strtotime($Approve_Booking['End_Date']))."	Rejected

Sorry your booking is rejected

If you have any questions please contact Glen Law

"; // To send HTML mail, the Content-type header must be set $headers = 'MIME-Version: 1.0' . "\r\n"; $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n"; // Additional headers $headers .= 'From: glaw@ualberta.ca' . "\r\n"; if(!mail($to, $subject, $message, $headers)) { echo "ERROR SENDING EMAIL"; } echo "BOOKING DELETED"; //****************************************** //** REJECTED BOOKING EMAIL ** //****************************************** } } else { echo "Are you sure you want to Reject the following booking?
"; $sql="SELECT * FROM Biotron_Bookings WHERE BookingID=$BookingID"; $result_Approve_Booking=mysqli_query('Content', $sql); if($Approve_Booking=mysqli_fetch_assoc($result_Approve_Booking)) { $sql="SELECT * FROM People WHERE ccid='". $Approve_Booking['CCID']."'"; $result_People=mysqli_query('Content', $sql); if($Current_People=mysqli_fetch_assoc($result_People)) { $sql="SELECT * FROM Biotron_Chamber WHERE ChamberID=". $Approve_Booking['ChamberID']; $result_Chamber=mysqli_query('Content', $sql); if($Current_Chamber=mysqli_fetch_assoc($result_Chamber)) { ?>

ChamberID	ID	Start Date	End Date	Yes/No
".$Current_Chamber['Room_Number']."	".$Current_People['FirstName'].", ".$Current_People['LastName']."	".date('F j, Y', strtotime($Approve_Booking['Start_Date']))."	".date('F j, Y', strtotime($Approve_Booking['End_Date']))."

"; } } } } } else { if($approve) { //******************************************************************************* //******** Start of Selected Booking Yes/No Approve ********** //******************************************************************************* echo "Are you sure you want to approve the following booking?

ChamberID	ID	Start Date	End Date	Yes/No
".$Current_Chamber['Room_Number']."	".$Current_People['FirstName'].", ".$Current_People['LastName']."	".date('F j, Y', strtotime($Approve_Booking['Start_Date']))."	".date('F j, Y', strtotime($Approve_Booking['End_Date']))."

"; } } } echo "

Extra comments for approved booking email:

"; //******************************************************************************* //******** Start of Confilicting Bookings ********** //******************************************************************************* echo "

Conflicting Bookings in this chamber

"; $sql="SELECT * FROM Biotron_Bookings WHERE ChamberID=".$Approve_Booking['ChamberID'] ." AND ((Start_Date >= '".$Approve_Booking['Start_Date']."' AND Start_Date <= '".$Approve_Booking['End_Date']."') OR (End_Date >= '".$Approve_Booking['Start_Date']."' AND End_Date <= '".$Approve_Booking['End_Date']."') OR (Start_Date <= '".$Approve_Booking['Start_Date']."' AND End_Date >= '".$Approve_Booking['End_Date']."')) AND BookingID != ".$Approve_Booking['BookingID']." AND (Approved ='n' or Approved = 'Y') ORDER BY ChamberID DESC"; $init=0; $result_Conflict_Booking=mysqli_query('Content', $sql); while($Conflict_Booking=mysqli_fetch_assoc($result_Conflict_Booking)) { $sql="SELECT * FROM People WHERE ccid='". $Conflict_Booking['CCID']."'"; $result_People=mysqli_query('Content', $sql); if($Current_People=mysqli_fetch_assoc($result_People)) { $sql="SELECT * FROM Biotron_Chamber WHERE ChamberID=". $Conflict_Booking['ChamberID']; $result_Chamber=mysqli_query('Content', $sql); if($Current_Chamber=mysqli_fetch_assoc($result_Chamber)) { if($init==0) { ?> "; } } } if($init==1) { echo "

BookingID	ID	Start Date	End Date	Status
".$Conflict_Booking['BookingID']."	".$Current_People['FirstName'].", ".$Current_People['LastName']."	".date('F j, Y', strtotime($Conflict_Booking['Start_Date']))."	".date('F j, Y', strtotime($Conflict_Booking['End_Date']))."	".$Status."

"; echo "

Extra comments for deleted bookings email:

"; } else { echo "No Conflicting Bookings Found"; } echo "

"; //******************************************************************************* //******** Start of All Chamber Bookings ********** //******************************************************************************* echo "

Current Bookings in this chamber

"; $sql="SELECT * FROM Biotron_Bookings WHERE ChamberID=".$Approve_Booking['ChamberID'] ." AND CURDATE() <= End_Date AND (Approved !='P' OR Approved !='Lease') ORDER BY ChamberID DESC"; $result_Approve_Booking=mysqli_query('Content', $sql); $init=0; while($Approve_Booking=mysqli_fetch_assoc($result_Approve_Booking)) { $sql="SELECT * FROM People WHERE ccid='". $Approve_Booking['CCID']."'"; $result_People=mysqli_query('Content', $sql); if($Current_People=mysqli_fetch_assoc($result_People)) { $sql="SELECT * FROM Biotron_Chamber WHERE ChamberID=". $Approve_Booking['ChamberID']; $result_Chamber=mysqli_query('Content', $sql); if($Current_Chamber=mysqli_fetch_assoc($result_Chamber)) { if($init==0) { ?> "; } } } if($init==1) { echo "

BookingID	ID	Start Date	End Date	Status
".$Approve_Booking['BookingID']."	".$Current_People['FirstName'].", ".$Current_People['LastName']."	".date('F j, Y', strtotime($Approve_Booking['Start_Date']))."	".date('F j, Y', strtotime($Approve_Booking['End_Date']))."	".$Status."

"; } else { echo "
No Current Bookings Found"; } //******************************************************************************* //******** End of Yes/No Appoval ********** //******************************************************************************* } else { //******************************************************************************* //******** Approve Booking and Delete Conflicts ********** //******************************************************************************* if($Yes) { $sql="SELECT * FROM Biotron_Bookings WHERE BookingID=$BookingID"; $result_Approve_Booking=mysqli_query('Content', $sql); if($Approve_Booking=mysqli_fetch_assoc($result_Approve_Booking)) { $sql="SELECT * FROM Biotron_Bookings WHERE ChamberID=".$Approve_Booking['ChamberID'] ." AND ((Start_Date >= '".$Approve_Booking['Start_Date']."' AND Start_Date <= '".$Approve_Booking['End_Date']."') OR (End_Date >= '".$Approve_Booking['Start_Date']."' AND End_Date <= '".$Approve_Booking['End_Date']."') OR (Start_Date <= '".$Approve_Booking['Start_Date']."' AND End_Date >= '".$Approve_Booking['End_Date']."')) AND BookingID != ".$BookingID." AND (Approved ='n' or Approved = 'Y') ORDER BY ChamberID DESC"; $init=0; $result_Conflict_Booking=mysqli_query('Content', $sql); while($Conflict_Booking=mysqli_fetch_assoc($result_Conflict_Booking)) { $sql="SELECT * FROM People WHERE ccid='". $Conflict_Booking['CCID']."'"; $result_People=mysqli_query('Content', $sql); if($Current_People=mysqli_fetch_assoc($result_People)) { $sql="SELECT * FROM Biotron_Chamber WHERE ChamberID=". $Conflict_Booking['ChamberID']; $result_Chamber=mysqli_query('Content', $sql); if($Current_Chamber=mysqli_fetch_assoc($result_Chamber)) { if($init==0) { ?> The Following Bookings Have Been Deleted

Biotron Booking Rejected

BookingID

Start Date

End Date

Status

Room Number	Start Date	End Date	Status
".$Current_Chamber['Room_Number']."	".date('F j, Y', strtotime($Conflict_Booking['Start_Date']))."	".date('F j, Y', strtotime($Conflict_Booking['End_Date']))."	Rejected

Sorry your booking is rejected

Additional comments from Glen Law:
$Delete_Comments

If you have any questions please contact Glen Law

ERROR SENDING DELETE EMAIL"; $mailerror=1; } //****************************************** //** REJECTED BOOKING EMAIL ** //****************************************** $Status='Deleted'; } else { $error='Yes'; } echo "".$Conflict_Booking['BookingID']."".$Current_People['FirstName'].", ".$Current_People['LastName']."".date('F j, Y', strtotime($Conflict_Booking['Start_Date']))."".date('F j, Y', strtotime($Conflict_Booking['End_Date']))."".$Status.""; } else { $error='Yes'; } } } } if($init==1) { echo ""; } if($error!='Yes') { $sql="UPDATE Biotron_Bookings SET Approved='Y' WHERE BookingID=$BookingID"; if($update_chamber=mysqli_query('Content', $sql)) { //****************************************** //** APPROVE BOOKING EMAIL ** //****************************************** $sql="SELECT * FROM Biotron_Chamber WHERE ChamberID=". $Approve_Booking['ChamberID']; $result_Chamber=mysqli_query('Content', $sql); $Current_Chamber=mysqli_fetch_assoc($result_Chamber); echo "

Biotron Booking Approved

Room Number	Start Date	End Date	Status
".$Current_Chamber['Room_Number']."	".date('F j, Y', strtotime($Approve_Booking['Start_Date']))."	".date('F j, Y', strtotime($Approve_Booking['End_Date']))."	Approved

"; $to = $Approve_Booking['CCID'].'@ualberta.ca'; $subject = 'Biotron Booking'; $message = " Biotron Booking Approved

Biotron Booking Approved

Room Number	Start Date	End Date	Status
".$Current_Chamber['Room_Number']."	".date('F j, Y', strtotime($Approve_Booking['Start_Date']))."	".date('F j, Y', strtotime($Approve_Booking['End_Date']))."	Approved

Your booking is Approved

Additional comments from Glen Law:
$Approve_Comments

If you have any questions please contact Glen Law

ERROR SENDING DELETE EMAIL"; $mailerror=1; } if($mailerror!=1) { echo "

All Emails sent out successfully

"; } echo "

[ Return to Administration ]

"; echo "

[ Return to Approve/Reject ]

"; //****************************************** //** APPROVE BOOKING EMAIL ** //****************************************** } } else { echo "There was and error deleted conficting bookings"; } } } else { //******************************************************************************* //******** Selected Booking to Approve ********** //******************************************************************************* $sql="SELECT * FROM Biotron_Bookings WHERE Approved='n' AND CURDATE() <= End_Date ORDER BY ChamberID DESC"; $result_Pending_Bookings=mysqli_query('Content', $sql); $pending_booking=0; while($Pending_Bookings=mysqli_fetch_assoc($result_Pending_Bookings)) { $sql="SELECT * FROM People WHERE ccid='". $Pending_Bookings['CCID']."'"; $result_People=mysqli_query('Content', $sql); if($Current_People=mysqli_fetch_assoc($result_People)) { $sql="SELECT * FROM Biotron_Chamber WHERE ChamberID=". $Pending_Bookings['ChamberID']; $result_Chamber=mysqli_query('Content', $sql); if($Current_Chamber=mysqli_fetch_assoc($result_Chamber)) { if($pending_booking==0) { ?>"; } } } if($pending_booking==1) { ?>

ChamberID	ID	Start Date	End Date	Approve/Reject
".$Current_Chamber['Room_Number']."	".$Current_People['FirstName'].", ".$Current_People['LastName']."	".date('F j, Y', strtotime($Pending_Bookings['Start_Date']))."	".date('F j, Y', strtotime($Pending_Bookings['End_Date']))."