<?= htmlspecialchars($page_title) ?> - <?= htmlspecialchars($project

query("SELECT title, start_date as start, end_date as end, event_type FROM calendar_events"); $events = $stmt->fetchAll(PDO::FETCH_ASSOC); $calendar_events_json = json_encode($events); // Stat cards data $stmt_upcoming = $pdo->prepare("SELECT COUNT(*) FROM calendar_events WHERE start_date BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 7 DAY)"); $stmt_upcoming->execute(); $upcoming_appointments_count = $stmt_upcoming->fetchColumn(); } catch (PDOException $e) { $error = "Database error: " . $e->getMessage(); } $project_name = "HVAC Command Center"; $page_title = "Calendar"; ?> <?= htmlspecialchars($page_title) ?> - <?= htmlspecialchars($project_name) ?>

Upcoming Appointments (Next 7 Days)

Technician Workload

Workload summary coming soon.