' . "Occupancy Report" . '
';
// $msg .= '
' . TABLE_VIEW_BY . ': '."Customer Arrival/Departure Summary".'';
$excelContent .= "Occupancy Report"."\n";
if (isset($_POST['monthSelect']) && $_POST['monthSelect'] != '' && isset($_POST['yearSelect']) && $_POST['yearSelect'] != '') {
$months = [
1 => "January", 2 => "February", 3 => "March",
4 => "April", 5 => "May", 6 => "June",
7 => "July", 8 => "August", 9 => "September",
10 => "October", 11 => "November", 12 => "December"
];
$monthName = $months[$_POST['monthSelect']] . " " . $_POST['yearSelect']; // Get the month name from the array
$msg .= $monthName;
$excelContent .= $monthName . "\n";
}
echo $this->element('/print/header-report',array('msg'=>$msg));
?>
0) ? round(($occupiedRooms / $totalRooms) * 100, 0) : 0;
if ($type == 1) {
return "{$occupancyPercentage}%";
} else {
return "{$occupiedRooms}";
}
} else {
if ($type == 1) {
return "0%";
} else {
return "0";
}
}
}
function fetchTotalOccupancy($formattedDay) {
$totalOccupancyQuery = mysql_query("
SELECT COUNT(DISTINCT r.id) AS totalOccupancy
FROM rooms AS r
WHERE EXISTS (
SELECT 1
FROM orders
INNER JOIN order_services ON orders.id = order_services.order_id
LEFT JOIN order_night_audits ona ON orders.id = ona.order_id
WHERE order_services.room_id = r.id
AND (
(order_services.is_night_audit = 1
AND ona.night_audit_report_date != '0000-00-00 00:00:00'
AND DATE_FORMAT(ona.night_audit_report_date, '%Y-%m-%d') = '{$formattedDay}')
OR
(order_services.is_night_audit = 0
AND '{$formattedDay}' BETWEEN order_services.start_date
AND DATE_SUB(order_services.end_date, INTERVAL 1 DAY))
)
GROUP BY order_services.room_id
)
");
$result = mysql_fetch_array($totalOccupancyQuery);
return $result['totalOccupancy'];
}
function fetchTotalRooms() {
$totalRoomsQuery = mysql_query("SELECT COUNT(id) AS total FROM rooms");
$result = mysql_fetch_array($totalRoomsQuery);
return $result['total'];
}
$totalRooms = fetchTotalRooms();
?>