AHEC Results

connect_error) { die("Connection failed: " . $conn->connect_error); } $conn-> select_db($dbname); $questions = array(); $questions['Access'] = array( "Practice_Visits", "Assigning_Patients", "Enhanced_Access", "Patient_Communication" ); $questions['Care Coordination'] = array( "Care_mgmt", "Referrals_to_appropriate", "Transitions_of_Care_Follow_Up" ); $questions['Use of Health IT'] = array( "Optional_Use_of_Health_Information_Exchange", "Using_HIT_Integrations_for_Patient_Care_and_Operations", "Using_HIT_for_Quality_Improvement_Efforts" ); $questions['Team Based Relationships'] = array( "Team_member_roles", "Team_training", "Measuring_Continuity" ); $questions['Patient and Family Engagement'] = array( "Shared_Decision_making", "4_habits_model", "Physical_and_Behavioral_Health_Outcomes", "Patient_Feedback" ); $questions['Quality Improvement and Evidence Based Care'] = array( "Comprehensive_guidelines_Information", "Quality_Improvement_Concepts", "Behavioral_Health" ); $questions['Financial Health: Leadership'] = array( "Business_Leadership_Engagement", "Strategic_Planning_Budgeting" ); $questions['Financial Health: Management'] = array( "Financial_Operating_reports", "Administrative_process", "Revenue_cycle", "Financial_Status" ); //print_r($questions); $uid = $_REQUEST['uid']; foreach ($questions as $key => $value) { $total = 0; $answers = 0; $ansArray[$key] = array(); foreach ($value as $sub_key => $sub_val) { $total = $total + 4; if (is_array($sub_val)) { foreach ($sub_val as $k => $v) { $sql = "SELECT RIGHT(um_key,1) AS Score FROM wpkd_um_metadata WHERE user_id=$uid AND um_value != 'a:0:{}' AND um_key LIKE '" . $v . "%'"; //echo $sql . "\n"; } } else { $sql = "SELECT um_key,RIGHT(um_key,1) AS Score FROM wpkd_um_metadata WHERE user_id=$uid AND um_value != 'a:0:{}' AND um_key LIKE '" . $sub_val . "%'"; //echo $sql . "\n"; $result = $conn->query($sql); if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { $answers = $answers + $row['Score']; $ansArray[$key][$sub_val] = $row['Score']; } } else { $ansArray[$key][$sub_val] = 0; } //echo $sub_key . " = " . $sub_val . "\n"; } } $ansArray[$key]["Total"] = $answers; $ansArray[$key]["Possible"] = $total; } //echo "
";
//$friendly = str_replace("_"," ",json_encode($ansArray,JSON_PRETTY_PRINT));
//echo $friendly;
//echo "
"; $conn->close(); ?>

Access /

% !important;">

Practice Visits

% !important;">

Assigning Patients to a Provider Panel

% !important;">

Enhanced Access to Care

% !important;">

24/7 Patient Communication

Care Coordination /

% !important;">

Care Management

% !important;">

Referrals

% !important;">

Transitions of Care

Use of Health IT /

% !important;">

Use of HIE

% !important;">

Integration

% !important;">

Quality Improvement

Team Based Relationships /

% !important;">

Team Member Roles

% !important;">

Team Training

% !important;">

Measuring Continuity

Patient and Family Engagement /

% !important;">

Shared Decision Making

% !important;">

4 Habits Model

% !important;">

Health Outcomes

% !important;">

Patient Feedback

Quality Improvement and Evidence Based Care /

% !important;">

Comprehensive Guidelines

% !important;">

Quality Improvement Concepts

% !important;">

Behavioral Health

Financial Health: Leadership /

% !important;">

Business Leadership

% !important;">

Strategic Planning

Financial Health: Management /

% !important;">

Financial Operating Reports

% !important;">

Administrative Process

% !important;">

Revenue Cycle

% !important;">

Financial Status