0) { $row = @mysqli_fetch_array($result); } $sql2 = "select * from health_advice"; $result2 = @mysqli_query($conn, $sql2); if (mysqli_num_rows($result2) > 0) { $row2 = @mysqli_fetch_array($result2); } $sql3 = "select * from health_risk"; $result3 = @mysqli_query($conn, $sql3); if (mysqli_num_rows($result3) > 0) { $row3 = @mysqli_fetch_array($result3); } $sql4 = "select * from training"; // training table not present ==> training_master $result4 = mysqli_query($conn, $sql4); $row4 = mysqli_fetch_array($result4); $query5 = "SELECT height, date(appointment_date) as dat FROM employee_appointment where emp_id='$id'and height != '' UNION SELECT cf.checkup_form_value as weight ,date(c.checkup_date) as dat from checkup_form c left join checkup_form_key_value cf on c.checkup_id=cf.checkup_form_id left join checkup_parameter cp on cp.`column_name` = cf.checkup_form_key where c.emp_id='$id' and cp.key_health_map_name=(select key_param_id from key_health_reportable_parameter_master where key_param_name='height') order by dat desc limit 1"; error_log("height " . $query5); $result5 = @mysqli_query($conn, $query5); $row5 = mysqli_fetch_array($result5); $query6 = "SELECT `weight`, date(appointment_date) as dat FROM employee_appointment where emp_id='$id' and `weight` != '' UNION SELECT cf.checkup_form_value as weight ,date(c.checkup_date) as dat from checkup_form c left join checkup_form_key_value cf on c.checkup_id=cf.checkup_form_id left join checkup_parameter cp on cp.`column_name` = cf.checkup_form_key where c.emp_id='$id' and cp.key_health_map_name=(select key_param_id from key_health_reportable_parameter_master where key_param_name='weight') order by dat desc limit 1"; error_log("weight " . $query6); $result6 = @mysqli_query($conn, $query6); $row6 = mysqli_fetch_array($result6); $query7 = "SELECT heart_rate as pulse, date(appointment_date) as dat FROM employee_appointment where emp_id='$id' and heart_rate != '' UNION SELECT cf.checkup_form_value as weight ,date(c.checkup_date) as dat from checkup_form c left join checkup_form_key_value cf on c.checkup_id=cf.checkup_form_id left join checkup_parameter cp on cp.`column_name` = cf.checkup_form_key where c.emp_id='$id' and cp.key_health_map_name=(select key_param_id from key_health_reportable_parameter_master where key_param_name='pulse') order by dat desc limit 1"; error_log("pulse " . $query7); $result7 = @mysqli_query($conn, $query7); $row7 = mysqli_fetch_array($result7); $query8 = "SELECT bmi, date(appointment_date) as dat FROM employee_appointment where emp_id='$id' and bmi != '' UNION SELECT cf.checkup_form_value as weight ,date(c.checkup_date) as dat from checkup_form c left join checkup_form_key_value cf on c.checkup_id=cf.checkup_form_id left join checkup_parameter cp on cp.`column_name` = cf.checkup_form_key where c.emp_id='$id' and cp.key_health_map_name=(select key_param_id from key_health_reportable_parameter_master where key_param_name='bmi') order by dat desc limit 1"; error_log("bmi " . $query8); $result8 = @mysqli_query($conn, $query8); $row8 = mysqli_fetch_array($result8); $query9 = "SELECT bp_sbp as sbp, date(appointment_date) as dat FROM employee_appointment where emp_id='$id'and bp_sbp != '' UNION SELECT cf.checkup_form_value as sbp ,date(c.checkup_date) as dat from checkup_form c left join checkup_form_key_value cf on c.checkup_id=cf.checkup_form_id left join checkup_parameter cp on cp.`column_name` = cf.checkup_form_key where c.emp_id='$id' and (cp.key_health_map_name=(select key_param_id from key_health_reportable_parameter_master where key_param_name='sbp') or cp.key_health_map_name=(select key_param_id from key_health_reportable_parameter_master where key_param_name='sbp/dbp')) order by dat desc limit 1"; error_log("systolic_blood_pressure " . $query9); $result9 = @mysqli_query($conn, $query9); $row9 = mysqli_fetch_array($result9); $query11 = "SELECT bp_dbp as dbp, date(appointment_date) as dat FROM employee_appointment where emp_id='$id'and bp_sbp != '' UNION SELECT cf.checkup_form_value as dbp ,date(c.checkup_date) as dat from checkup_form c left join checkup_form_key_value cf on c.checkup_id=cf.checkup_form_id left join checkup_parameter cp on cp.`column_name` = cf.checkup_form_key where c.emp_id='$id' and (cp.key_health_map_name=(select key_param_id from key_health_reportable_parameter_master where key_param_name='dbp') or cp.key_health_map_name=(select key_param_id from key_health_reportable_parameter_master where key_param_name='sbp/dbp')) order by dat desc limit 1"; error_log("systolic_blood_pressure " . $query11); $result11 = @mysqli_query($conn, $query11); $row11 = mysqli_fetch_array($result11); $sbp = ""; $dbp = ""; $bp_arr = explode("/", $row9['sbp']); error_log("size " . sizeof($bp_arr)); if (sizeof($bp_arr) > 1) { $sbp = $bp_arr[0]; } else { $sbp = $bp_arr[0]; } $bp_arr = explode("/", $row11['dbp']); error_log("size " . sizeof($bp_arr)); if (sizeof($bp_arr) > 1) { $dbp = $bp_arr[1]; } else { $dbp = $bp_arr[0]; } $bp = $sbp . "/" . $dbp; $query10 = "SELECT health_index from checkup_form where emp_id='$id' order by checkup_date desc limit 1"; error_log("health index query " . $query10); $result10 = @mysqli_query($conn, $query10); $row10 = mysqli_fetch_array($result10); $query12 = "SELECT blood_sugar_fbs as fbs, date(appointment_date) as dat FROM employee_appointment where emp_id='$id' and blood_sugar_fbs != '' UNION SELECT cf.checkup_form_value as weight ,date(c.checkup_date) as dat from checkup_form c left join checkup_form_key_value cf on c.checkup_id=cf.checkup_form_id left join checkup_parameter cp on cp.`column_name` = cf.checkup_form_key where c.emp_id='$id' and cp.key_health_map_name=(select key_param_id from key_health_reportable_parameter_master where key_param_name='fbs') order by dat desc limit 1"; error_log("fbs " . $query12); $result12 = @mysqli_query($conn, $query12); $row12 = mysqli_fetch_array($result12); $query13 = "SELECT blood_sugar_rbs as rbs, date(appointment_date) as dat FROM employee_appointment where emp_id='$id' and blood_sugar_rbs != '' UNION SELECT cf.checkup_form_value as weight ,date(c.checkup_date) as dat from checkup_form c left join checkup_form_key_value cf on c.checkup_id=cf.checkup_form_id left join checkup_parameter cp on cp.`column_name` = cf.checkup_form_key where c.emp_id='$id' and cp.key_health_map_name=(select key_param_id from key_health_reportable_parameter_master where key_param_name='rbs') order by dat desc limit 1"; error_log("fbs " . $query13); $result13 = @mysqli_query($conn, $query13); $row13 = mysqli_fetch_array($result13); $query14 = "SELECT blood_sugar_ppbs as ppbs, date(appointment_date) as dat FROM employee_appointment where emp_id='$id' and blood_sugar_ppbs != '' UNION SELECT cf.checkup_form_value as weight ,date(c.checkup_date) as dat from checkup_form c left join checkup_form_key_value cf on c.checkup_id=cf.checkup_form_id left join checkup_parameter cp on cp.`column_name` = cf.checkup_form_key where c.emp_id='$id' and cp.key_health_map_name=(select key_param_id from key_health_reportable_parameter_master where key_param_name='ppbs') order by dat desc limit 1"; error_log("fbs " . $query14); $result14 = @mysqli_query($conn, $query14); $row14 = mysqli_fetch_array($result14); function calcBMI($weight, $height) { $bmi = ($weight / ($height * $height)) * 10000; return round($bmi, 1) . PHP_EOL; } function ppa($past_illness) { $params=''; $param_present = explode(', ', $past_illness); foreach ($param_present as $x => $val) { $params .= getFieldFromTable('param_name', 'history_parameter', 'param_id', $val) . "
"; } return $params; } function healthAdvices($past_advices) {$params=''; $param_present = explode(', ', $past_advices); foreach ($param_present as $x => $val) { $params .= getFieldFromTable('health_advice_name', 'health_advice', 'health_advice_id', $val) . "
"; } return $params; } ?>
<?php echo $row['patient_name'] ?> <?php echo $row['fname'] ?>'s Avatar <?php echo $row['fname'] ?>'s Avatar
 

Employee Health Dashboard


Height
Weight
BMI
BP
Pulse
Health Index
FBS
RBS
PPBS

 PATIENT BASIC INFO

 PATIENT LATEST VISIT DATA

 Dependent List

 Previous Illness Visit

'; for ($i = 0; $i < count($risks); $i++) { if ($i == 0) { $str_risks .= "
  • " . getTableFieldValue('health_risk', 'health_risk_name', 'health_risk_id', $risks[$i], ''); $str_risks .= "
    • "; } else { $str_risks .= '
  • ' . getTableFieldValue('health_risk', 'health_risk_name', 'health_risk_id', $risks[$i], ''); $str_risks .= "
    • "; } } $str_risks .= ''; echo $str_risks; ?>

    0) { if ($row_checkup = mysqli_fetch_assoc($result_checkup)) { ?>
    Date & Time:
    Recommendations:
    No Record found

     Choose date filter to see past data

    Start date

    End date

    Select Health Parameter

    Select Chart

     BMI TRACKING

    0) { while ($row_bmi = mysqli_fetch_assoc($result_bmi)) { array_push($medical_date, $row_bmi['dat']); $bmi['bmi'][$row_bmi['dat']] = $row_bmi['bmi']; } } $medical_date = array_values(array_unique($medical_date)); for ($i = 0; $i < sizeof($medical_date); $i++) { error_log("inside loop value" . $bmi['bmi'][$medical_date[$i]]); error_log("inside loop value" . $height['height'][$medical_date[$i]]); error_log("inside loop value" . $weight['weight'][$medical_date[$i]]); if ($bmi['bmi'][$medical_date[$i]] == '') { array_push($bmi_new, 0); } else { array_push($bmi_new, $bmi['bmi'][$medical_date[$i]]); } if ($height['height'][$medical_date[$i]] == '') { array_push($height_new, 0); } else { array_push($height_new, $height['height'][$medical_date[$i]]); } if ($weight['weight'][$medical_date[$i]] == '') { array_push($weight_new, 0); } else { array_push($weight_new, $weight['weight'][$medical_date[$i]]); } } ?>
    Date height weight bmi

     OSI TRACKING

    fetch_assoc()) { $month_name = date("F", mktime(0, 0, 0, $i, 10)); ?> fetch_assoc()) { ?> fetch_assoc()) { ?>
    Months Illness Visits Injury Visits Sickness Visits

     BP TRACKING

    0) { while ($row = @mysqli_fetch_array($result)) { array_push($medical_date, $row[1]); $bp_arr = explode("/", $row[0]); error_log("size " . sizeof($bp_arr)); if (sizeof($bp_arr) > 1) { $bp_sbp['sbp'][$row[1]] = $bp_arr[0]; } else { $bp_sbp['sbp'][$row[1]] = $bp_arr[0]; } } } $query = "SELECT bp_dbp as dbp, date(appointment_date) as dat FROM employee_appointment where emp_id='$id'and bp_dbp != '' and date(appointment_date) between STR_TO_DATE('" . $startDate . "', '%d-%m-%Y') AND STR_TO_DATE('" . $endDate . "', '%d-%m-%Y')UNION SELECT cf.checkup_form_value as dbp ,date(c.checkup_date) as dat from checkup_form c left join checkup_form_key_value cf on c.checkup_id=cf.checkup_form_id left join checkup_parameter cp on cp.`column_name` = cf.checkup_form_key where c.emp_id='$id' and (cp.key_health_map_name=(select key_param_id from key_health_reportable_parameter_master where key_param_name='dbp') or cp.key_health_map_name=(select key_param_id from key_health_reportable_parameter_master where key_param_name='sbp/dbp')) and date(c.checkup_date) between STR_TO_DATE('" . $startDate . "', '%d-%m-%Y') AND STR_TO_DATE('" . $endDate . "', '%d-%m-%Y') order by dat desc limit 25"; error_log("dbp query " . $query); $result = @mysqli_query($conn, $query); if (mysqli_num_rows($result) > 0) { while ($row = @mysqli_fetch_array($result)) { array_push($medical_date, $row[1]); $bp_arr = explode("/", $row[0]); error_log("size " . sizeof($bp_arr)); if (sizeof($bp_arr) > 1) { $bp_dbp['dbp'][$row[1]] = $bp_arr[1]; } else { $bp_dbp['dbp'][$row[1]] = $bp_arr[0]; } } } $medical_date = array_values(array_unique($medical_date)); for ($i = 0; $i < sizeof($medical_date); $i++) { error_log("inside loop value" . $bp_sbp['sbp'][$medical_date[$i]]); error_log("inside loop value" . $bp_dbp['dbp'][$medical_date[$i]]); if ($bp_sbp['sbp'][$medical_date[$i]] == '') { array_push($sbp_new, 0); } else { array_push($sbp_new, $bp_sbp['sbp'][$medical_date[$i]]); } if ($bp_dbp['dbp'][$medical_date[$i]] == '') { array_push($dbp_new, 0); } else { array_push($dbp_new, $bp_dbp['dbp'][$medical_date[$i]]); } } ?>
    Date Sbp Dbp

     BLOOD SUGAR TRACKING

    0) { while ($row = @mysqli_fetch_array($result)) { array_push($medical_date, $row[1]); $blood_sugar_rbs['rbs'][$row[1]] = $row[0]; } } $query = "SELECT blood_sugar_fbs as fbs, date(appointment_date) as dat FROM employee_appointment where emp_id='$id'and blood_sugar_fbs != '' and date(appointment_date) between STR_TO_DATE('" . $startDate . "', '%d-%m-%Y') AND STR_TO_DATE('" . $endDate . "', '%d-%m-%Y') UNION SELECT cf.checkup_form_value as fbs ,date(c.checkup_date) as dat from checkup_form c left join checkup_form_key_value cf on c.checkup_id=cf.checkup_form_id left join checkup_parameter cp on cp.`column_name` = cf.checkup_form_key where c.emp_id='$id' and cp.key_health_map_name=(select key_param_id from key_health_reportable_parameter_master where key_param_name='fbs') and date(c.checkup_date) between STR_TO_DATE('" . $startDate . "', '%d-%m-%Y') AND STR_TO_DATE('" . $endDate . "', '%d-%m-%Y') order by dat desc limit 25"; error_log("rbs query " . $query); $result = @mysqli_query($conn, $query); if (mysqli_num_rows($result) > 0) { while ($row = @mysqli_fetch_array($result)) { array_push($medical_date, $row[1]); $blood_sugar_fbs['fbs'][$row[1]] = $row[0]; } } $query = "SELECT blood_sugar_ppbs as ppbs, date(appointment_date) as dat FROM employee_appointment where emp_id='$id'and blood_sugar_ppbs != '' and date(appointment_date) between STR_TO_DATE('" . $startDate . "', '%d-%m-%Y') AND STR_TO_DATE('" . $endDate . "', '%d-%m-%Y') UNION SELECT cf.checkup_form_value as ppbs ,date(c.checkup_date) as dat from checkup_form c left join checkup_form_key_value cf on c.checkup_id=cf.checkup_form_id left join checkup_parameter cp on cp.`column_name` = cf.checkup_form_key where c.emp_id='$id' and cp.key_health_map_name=(select key_param_id from key_health_reportable_parameter_master where key_param_name='ppbs') and date(c.checkup_date) between STR_TO_DATE('" . $startDate . "', '%d-%m-%Y') AND STR_TO_DATE('" . $endDate . "', '%d-%m-%Y') order by dat desc limit 25"; error_log("rbs query " . $query); $result = @mysqli_query($conn, $query); if (mysqli_num_rows($result) > 0) { while ($row = @mysqli_fetch_array($result)) { array_push($medical_date, $row[1]); $blood_sugar_ppbs['ppbs'][$row[1]] = $row[0]; } } $medical_date = array_values(array_unique($medical_date)); error_log("sugar chart date array " . print_r($medical_date, true)); for ($i = 0; $i < sizeof($medical_date); $i++) { error_log("inside loop value" . $blood_sugar_rbs['rbs'][$medical_date[$i]]); error_log("inside loop value" . $blood_sugar_fbs['fbs'][$medical_date[$i]]); error_log("inside loop value" . $blood_sugar_ppbs['ppbs'][$medical_date[$i]]); if ($blood_sugar_rbs['rbs'][$medical_date[$i]] == '') { array_push($rbs_new, 0); } else { array_push($rbs_new, $blood_sugar_rbs['rbs'][$medical_date[$i]]); } if ($blood_sugar_fbs['fbs'][$medical_date[$i]] == '') { array_push($fbs_new, 0); } else { array_push($fbs_new, $blood_sugar_fbs['fbs'][$medical_date[$i]]); } if ($blood_sugar_ppbs['ppbs'][$medical_date[$i]] == '') { array_push($ppbs_new, 0); } else { array_push($ppbs_new, $blood_sugar_ppbs['ppbs'][$medical_date[$i]]); } } ?>
    Date FBS RBS PPBS