prepare("SELECT first_name FROM residents WHERE id = ?"); $stmt->execute([$resident_id]); $resident_name = $stmt->fetchColumn(); // Fetch resident's domain risk scores, levels, and drivers $risk_scores_stmt = $pdo->prepare(" SELECT domain, score_int, level, drivers FROM risk_scores WHERE resident_id = ? ORDER BY domain "); $risk_scores_stmt->execute([$resident_id]); $risk_scores = $risk_scores_stmt->fetchAll(PDO::FETCH_ASSOC | PDO::FETCH_GROUP); // Fetch resident's action plans $action_plans_stmt = $pdo->prepare(" SELECT ap.id, ap.title, ap.status, ap.domain_key FROM action_plans ap WHERE ap.resident_id = ? ORDER BY ap.created_at DESC "); $action_plans_stmt->execute([$resident_id]); $action_plans = $action_plans_stmt->fetchAll(PDO::FETCH_ASSOC); // Domain names mapping $domains = [ 'economic' => 'Economic Stability', 'education' => 'Education Access & Quality', 'healthcare' => 'Health Care Access & Quality', 'neighborhood' => 'Neighborhood & Built Environment', 'social' => 'Social & Community Context', ]; ?> Resident Dashboard | Continuum Nexus

Welcome, !

My Messages

Your Domain Overview

$domain_name): ?>

/100

Risk Score

Key Factors:

No specific risk factors identified.

Your Action Plans

Title	Domain	Status
You have no active action plans.
			View