prepare("SELECT b.*, p.package_name, p.services FROM bookings b LEFT JOIN packages p ON b.package_id = p.id WHERE b.start_time BETWEEN :day_start AND :day_end AND b.status != '已取消' ORDER BY b.start_time ASC"); $stmt->execute(['day_start' => $day_start, 'day_end' => $day_end]); $today_bookings = $stmt->fetchAll(PDO::FETCH_ASSOC); // 计算今日待处理和已完成的数量 $pending_count = 0; $completed_count = 0; foreach ($today_bookings as $booking) { if ($booking['status'] == '已完成') { $completed_count++; } else { $pending_count++; } } } catch (PDOException $e) { $error_message = '获取今日预约失败: ' . $e->getMessage(); $today_bookings = []; } ?>