PHP -检查预约是否与可用地点重叠

function isOverlap($start1, $end1, $start2, $end2) {
    return ($start1 < $end2 && $end1 > $start2);
}

$start1 = strtotime('2023-10-01 10:00:00');
$end1 = strtotime('2023-10-01 11:00:00');
$start2 = strtotime('2023-10-01 10:30:00');
$end2 = strtotime('2023-10-01 11:30:00');

if (isOverlap($start1, $end1, $start2, $end2)) {
    echo "预约时间重叠";
} else {
    echo "预约时间不重叠";
}

$locationId = 1; // 假设我们要检查的地点ID
$newStartTime = strtotime('2023-10-01 10:00:00');
$newEndTime = strtotime('2023-10-01 11:00:00');

$sql = "SELECT * FROM appointments WHERE location_id = ? AND ((start_time <= ? AND end_time >= ?) OR (start_time <= ? AND end_time >= ?))";
$stmt = $pdo->prepare($sql);
$stmt->execute([$locationId, $newEndTime, $newStartTime, $newEndTime, $newStartTime]);

if ($stmt->fetch()) {
    echo "预约时间重叠";
} else {
    echo "预约时间不重叠";
}