prepare("SELECT COUNT(*) as count FROM projects"); $stmt->execute(); $stats['total_projects'] = $stmt->get_result()->fetch_assoc()['count']; $stmt->close(); // Total Vendors $stmt = $conn->prepare("SELECT COUNT(*) as count FROM vendors"); $stmt->execute(); $stats['total_vendors'] = $stmt->get_result()->fetch_assoc()['count']; $stmt->close(); // Active Vendors $stmt = $conn->prepare("SELECT COUNT(*) as count FROM vendors WHERE status = 'Active'"); $stmt->execute(); $stats['active_vendors'] = $stmt->get_result()->fetch_assoc()['count']; $stmt->close(); // Pending $stmt = $conn->prepare("SELECT COUNT(*) as count FROM vendors WHERE status = 'Pending'"); $stmt->execute(); $stats['pending_vendors'] = $stmt->get_result()->fetch_assoc()['count']; $stmt->close(); // On Hold Vendors (specific) $stmt = $conn->prepare("SELECT COUNT(*) as count FROM vendors WHERE status = 'On Hold'"); $stmt->execute(); $stats['onhold_vendors'] = $stmt->get_result()->fetch_assoc()['count']; $stmt->close(); // Pending Tasks $stmt = $conn->prepare("SELECT COUNT(*) as count FROM tasks WHERE status = 'Pending'"); $stmt->execute(); $stats['pending_tasks'] = $stmt->get_result()->fetch_assoc()['count']; $stmt->close(); // Completed Projects $stmt = $conn->prepare("SELECT COUNT(*) as count FROM projects WHERE status = 'Completed'"); $stmt->execute(); $stats['completed_projects'] = $stmt->get_result()->fetch_assoc()['count']; $stmt->close(); // Project status breakdown for chart $project_status_counts = ['Planning' => 0, 'Active' => 0, 'Completed' => 0, 'On Hold' => 0, 'Cancelled' => 0]; $status_query = $conn->prepare(" SELECT status, COUNT(*) as count FROM projects GROUP BY status "); $status_query->execute(); $result = $status_query->get_result(); while ($row = $result->fetch_assoc()) { if (array_key_exists($row['status'], $project_status_counts)) { $project_status_counts[$row['status']] = $row['count']; } } $status_query->close(); // Chart data $chart_labels = json_encode(array_keys($project_status_counts)); $chart_data = json_encode(array_values($project_status_counts)); $chart_colors = json_encode([ '#1976d2', '#388e3c', '#7b1fa2', '#f57c00', '#d32f2f' ]); // Total Clients $stmt = $conn->prepare("SELECT COUNT(*) as count FROM clients"); $stmt->execute(); $stats['total_clients'] = $stmt->get_result()->fetch_assoc()['count']; $stmt->close(); // Recent Projects (TOP 5) $stmt = $conn->prepare(" SELECT p.id, p.project_name, c.client_name, p.status, p.created_date, p.start_date FROM projects p JOIN clients c ON p.client_id = c.id ORDER BY p.created_date DESC LIMIT 5 "); $stmt->execute(); $result = $stmt->get_result(); $recent_projects = []; while ($row = $result->fetch_assoc()) { $row['created_time'] = date('M j, Y', strtotime($row['created_date'])); $recent_projects[] = $row; } $stmt->close(); // User avatar initial $user_initial = strtoupper(substr($user_name, 0, 1)); ?> Dashboard - ConstructCRM