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