BOOKINGS FOR THE MONTH
get_total_bookings_this_month(); ?>
BOOKINGS FOR LAST MONTH
get_total_bookings_last_month(); ?>
TOTAL BOOKINGS
get_total_bookings(); ?>
query("SELECT * FROM `bookings` WHERE `status` = 1 ORDER BY record_id DESC LIMIT 15");
while ($booking = $bookings_res->fetch_assoc()) {
if ($booking['status'] == 0) {
$status = 'Pending Payment';
} else if ($booking['status'] == 1) {
$status = 'Pending Approval';
} else if ($booking['status'] == 2) {
$status = 'APPROVED';
} else if ($booking['status'] == 3) {
$status = 'DECLINED';
}
$table_data[] = [
$booking['record_id'],
$calls->get_username($booking['user_id']),
$booking['date_of_booking'],
$booking['time_start'],
$status,
$booking['type'],
'booking.php?record_id=' . $booking['record_id']
];
}
echo DashboardWidget::tableBlock(
'WAITING APPROVAL',
['No', 'User', 'Date', 'Time', 'status', 'Type'],
$table_data,
'90vw'
);
$table_data = [];
$bookings_res = $db->query("SELECT * FROM `bookings` WHERE `status` = 2 ORDER BY record_id DESC LIMIT 15");
while ($booking = $bookings_res->fetch_assoc()) {
if ($booking['status'] == 0) {
$status = 'Pending Payment';
} else if ($booking['status'] == 1) {
$status = 'Pending Approval';
} else if ($booking['status'] == 2) {
$status = 'APPROVED';
} else if ($booking['status'] == 3) {
$status = 'DECLINED';
}
$table_data[] = [
$booking['record_id'],
$calls->get_username($booking['user_id']),
$booking['date_of_booking'],
$booking['time_start'],
$status,
$booking['type'],
'booking.php?record_id=' . $booking['record_id']
];
}
echo DashboardWidget::tableBlock(
'CONFIRMED BOOKINGS',
['No', 'User', 'Date', 'Time', 'status', 'Type'],
$table_data,
'90vw'
);
$table_data = [];
$bookings_res = $db->query("SELECT * FROM `bookings` WHERE `status` = 3 ORDER BY record_id DESC LIMIT 15");
while ($booking = $bookings_res->fetch_assoc()) {
if ($booking['status'] == 0) {
$status = 'Pending Payment';
} else if ($booking['status'] == 1) {
$status = 'Pending Approval';
} else if ($booking['status'] == 2) {
$status = 'APPROVED';
} else if ($booking['status'] == 3) {
$status = 'DECLINED';
}
$table_data[] = [
$booking['record_id'],
$calls->get_username($booking['user_id']),
$booking['date_of_booking'],
$booking['time_start'],
$status,
$booking['type'],
'booking.php?record_id=' . $booking['record_id']
];
}
echo DashboardWidget::tableBlock(
'CANCELED BOOKINGS',
['No', 'User', 'Date', 'Time', 'status', 'Type'],
$table_data,
'90vw'
);
?>
html_end(); ?>