BOOKINGS FOR THE MONTH
get_total_bookings_this_month(); ?>
TOTAL MADE THIS MONTH
get_total_value_from_payments_this_month(); ?>
BOOKINGS FOR LAST MONTH
get_total_bookings_last_month(); ?>
LAST MONTH PAYMENTS
get_total_value_from_payments_last_month(); ?>
query("SELECT * FROM `bookings` WHERE `status` = 1 ORDER BY record_id DESC LIMIT 15");
while ($booking = $bookings_res->fetch_assoc()) {
$table_data[] = [
$booking['record_id'],
$calls->get_username($booking['user_id']),
$booking['date_of_booking'],
$booking['time_start'],
$booking['type'],
$calls->get_service_name($booking['service']),
'booking.php?record_id=' . $booking['record_id']
];
}
if (count($table_data) != 0) {
echo DashboardWidget::tableBlock(
'WAITING APPROVAL',
['No', 'User', 'Date', 'Time', 'Type', 'Service'],
$table_data,
'90vw'
);
}
?>