1#@!#!123s

��JFIF�� 1#@!#!123s
: / proc / self / root / home / earnlouq / kobilz.co.uk /
Filename : update-booking-times.php
back
<?php
include('../config/xconfig.php');

// Define time slots and window
$times = ['08:00:00', '09:00:00', '10:00:00', '11:00:00', '12:00:00', '13:00:00', '14:00:00', '15:00:00', '16:00:00'];
$window_days = 30;
$start_date = date('Y-m-d');
$end_date = date('Y-m-d', strtotime("+$window_days days"));

// Get the latest date in available_times
$stmt = $con->prepare("SELECT MAX(booking_date) as max_date FROM available_times");
$stmt->execute();
$result = $stmt->get_result()->fetch_assoc();
$max_date = $result['max_date'] ? $result['max_date'] : $start_date;
$stmt->close();

// Start from the day after max_date or today
$start_date = max($start_date, date('Y-m-d', strtotime($max_date . '+1 day')));

// Count bookings for each date and time
$booking_counts = [];
$stmt = $con->prepare("SELECT booking_date, booking_time, COUNT(*) as booking_count 
    FROM bookings 
    WHERE booking_date BETWEEN ? AND ? 
    GROUP BY booking_date, booking_time");
$stmt->bind_param("ss", $start_date, $end_date);
$stmt->execute();
$result = $stmt->get_result();
while ($row = $result->fetch_assoc()) {
    $date = $row['booking_date'];
    $time = substr($row['booking_time'], 0, 5) . ':00'; // Normalize to HH:MM:00
    $booking_counts[$date][$time] = $row['booking_count'];
}
$stmt->close();

// Insert or update available_times
$stmt = $con->prepare("INSERT INTO available_times (booking_date, booking_time, booking_count, max_bookings) 
    VALUES (?, ?, ?, 5) ON DUPLICATE KEY UPDATE booking_count = ?");
for ($date = strtotime($start_date); $date <= strtotime($end_date); $date = strtotime('+1 day', $date)) {
    $date_str = date('Y-m-d', $date);
    foreach ($times as $time) {
        $count = isset($booking_counts[$date_str][$time]) ? $booking_counts[$date_str][$time] : 0;
        $stmt->bind_param("ssii", $date_str, $time, $count, $count);
        $stmt->execute();
    }
}
$stmt->close();

echo "Available times populated from $start_date to $end_date with booking counts.";
?>