function test_retrieve_all_dbRoomReservationActivity_byDate($beginDate, $endDate) { $reservations = retrieve_all_RoomReservationActivity_byDate($beginDate, $endDate); if ($reservations == false) { echo "</br>" . "No Reservations were Found." . "</br></br></br>"; } else { echo "</br>" . "Records Found:" . "</br>"; foreach ($reservations as $reservation) { display_reservation($reservation); } } }
$hospital = ""; } else { if ($_POST['hospital'] == "MSKCC") { $hospital = "Memorial Sloan-Kettering Cancer Center"; } else { $hospital = sanitize($_POST['hospital']); } } //REPORT echo "Report Requested by: " . $userId . "<br>"; echo "Beginning Date: " . date('m/d/Y', strtotime($beginDate)) . "<br>"; echo "Ending Date: " . date('m/d/Y', strtotime($endDate)) . "<br>"; //report for all hospitals if (empty($hospital)) { //Retrieve array of data $theReservations = retrieve_all_RoomReservationActivity_byDate($beginDate, $endDate); //report for selected hospital, $hospital } else { echo "Hospital: " . $hospital . "<br>"; //Retrieve array of data $theReservations = retrieve_all_RoomReservationActivity_byHospitalAndDate($hospital, $beginDate, $endDate); } if (empty($theReservations)) { echo '<br><div class="notice">No data matches your selections.</div><br>'; echo '<a href="report.php"><div class="goback"></div></a>'; } else { //TABLE echo '<br><br> <table border = "2" cellspacing = "10" cellpadding = "10">'; echo '<thead> <tr>