<?= htmlspecialchars($page_title . '

query('SELECT COUNT(*) as total FROM customers'); $total_customers = $stmt_customers->fetch()['total']; // Fetch total bookings $stmt_bookings = $pdo->query('SELECT COUNT(*) as total FROM bookings'); $total_bookings = $stmt_bookings->fetch()['total']; // Fetch total revenue $stmt_revenue = $pdo->query("SELECT SUM(actual_revenue) as total FROM bookings WHERE status = 'completed'"); $total_revenue = $stmt_revenue->fetch()['total'] ?? 0; // Fetch recent bookings $stmt_recent_bookings = $pdo->query('SELECT * FROM bookings ORDER BY created_at DESC LIMIT 5'); $recent_bookings = $stmt_recent_bookings->fetchAll(); // Handle API key generation if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['generate_api_key'])) { $new_key = 'hvac_' . bin2hex(random_bytes(16)); $stmt_insert_key = $pdo->prepare("INSERT INTO api_keys (api_key) VALUES (?)"); $stmt_insert_key->execute([$new_key]); header("Location: " . $_SERVER['PHP_SELF']); exit; } // Fetch all API keys $stmt_api_keys = $pdo->query('SELECT * FROM api_keys ORDER BY created_at DESC'); $api_keys = $stmt_api_keys->fetchAll(); // Fetch latest weather data $default_zip_code = '28202'; $stmt_weather = $pdo->prepare('SELECT * FROM weather WHERE zip_code = ? ORDER BY observation_time DESC LIMIT 1'); $stmt_weather->execute([$default_zip_code]); $current_weather = $stmt_weather->fetch(); // Fetch chat stats $today_start = date('Y-m-d 00:00:00'); $stmt_chats_today = $pdo->prepare("SELECT COUNT(*) FROM chat_logs WHERE chat_start_time >= ?"); $stmt_chats_today->execute([$today_start]); $chats_today_count = $stmt_chats_today->fetchColumn(); $stmt_total_chats = $pdo->query("SELECT COUNT(*) FROM chat_logs"); $total_chats = $stmt_total_chats->fetchColumn(); $stmt_converted_chats = $pdo->query("SELECT COUNT(*) FROM chat_logs WHERE was_converted = 1"); $converted_chats = $stmt_converted_chats->fetchColumn(); $chat_conversion_rate = ($total_chats > 0) ? ($converted_chats / $total_chats) * 100 : 0; } catch (PDOException $e) { $error = "Database error: " . $e->getMessage(); } $project_name = "HVAC Command Center"; $project_description = "Central dashboard for managing your HVAC business operations."; $page_title = "Dashboard"; ?> <?= htmlspecialchars($page_title . ' | ' . $project_name) ?>

Total Customers

5% this month

Total Bookings

12% this month

Chats Today

% conv.

Completed Revenue

$

8% this month

Current Weather

Last updated:

°F

Feels like °F

Weather data not available. Click Refresh.

Service Area Weather Map

Recent Bookings

Date	Customer	Service	Urgency	Status	Est. Revenue
					$
No recent bookings found.

API Keys

API Key	Status	Created On	Actions

No API keys found.