= htmlspecialchars($page_title) ?>
= htmlspecialchars($error) ?>
Upcoming Appointments (Next 7 Days)
= htmlspecialchars($upcoming_appointments_count) ?>
Technician Workload
Workload summary coming soon.
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"; ?>
Workload summary coming soon.