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>
