$val) { $sql_param = "select a.*,b.* from checkup_parameter a left join checkup_form_key_value b on a.column_name = b.checkup_form_key where checkup_form_id = '$checkup_id' and checkup_form_section_id = '$val' order by column_order"; error_log("//query to load fields for each section@@@@@@@!!!!" . $sql_param); $result_param = mysqli_query($conn, $sql_param); $param_name = array(); $param_value = array(); $param_unit =''; $param_ranges=''; while ($row_param = mysqli_fetch_assoc($result_param)) { array_push($param_name, $row_param['parameter_name']); if(empty(getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $row_param['checkup_form_value'])) && empty(getCommaSeperatedValuesForInClause("select parameter_value_name from checkup_parameter_value", 'parameter_value_id', $row_param['checkup_form_value'])) && empty($row_param['checkup_form_value'])){ $param_unit=''; }else{ $param_unit= getFieldFromTable('unit_name', 'checkup_parameter_unit_master', 'unit_id', $row_param['unit']); } if ($row_param['input_type'] == 'select') { array_push($param_value, getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $row_param['checkup_form_value']).' '.$param_unit); } else if ($row_param['input_type'] == 'multiselect') { array_push($param_value, getCommaSeperatedValuesForInClause("select parameter_value_name from checkup_parameter_value", 'parameter_value_id', $row_param['checkup_form_value']).' '.$param_unit); } else { array_push($param_value, $row_param['checkup_form_value'].' '.$param_unit); } } $sql_group_ids = "select count(distinct(a.group_id)) as field_value from checkup_parameter a left join checkup_form_key_value b on a.column_name = b.checkup_form_key where checkup_form_id = '$checkup_id' and checkup_form_section_id = '$val' order by column_order"; $result_grp = mysqli_query($conn, $sql_group_ids); $row_grp = mysqli_fetch_assoc($result_grp); $total_group_ids = $row_grp['field_value']; //echo 'hellooooooooooooooooooo'; error_log("total group ids:" . $total_group_ids); $group_ids = array(); for ($i = 1; $i <= $total_group_ids; $i++) { $group_id = "select count(group_id) from checkup_parameter where group_id = '$i' and enabled!='N' and checkup_form_section_id = '$val'"; error_log("group id len query:" . $group_id); $result_group_id = mysqli_query($conn, $group_id); $row_group_id = mysqli_fetch_array($result_group_id); array_push($group_ids, $row_group_id['0']); } $max_len = max($group_ids); // echo $max_len; // print_r($group_ids); $k = 0; for ($i = 0; $i < $total_group_ids; $i++) { $value = $group_ids[$i]; $value2 = $max_len - $value; while ($value != 0) { $para=array( $param_name[$k]=>$param_value[$k], ); array_push($data,$para); $k++; $value--; } while ($value2 != 0) { $value2--;}}} function chekFromItem($arr, $keyToSearch) { foreach($arr as $key=>$para){ foreach($para as $name=>$value) { if($name==$keyToSearch) return $value; } }} error_log("data".print_r($data,true)); ?>
ANNUAL MEDICAL CHECK UP HEALTH CARD
EMPLOYEE ID:
Date:
AMC No.
GENDER:
DOJ:
DOB:
Age
DESIGNATION:
MOBILE NO.:
DEPARTMENT:
DIVISION:
HEIGHT:
WEIGHT:
BMI:
IDENTIFICATION M.:
B.group:
ETE TEST
RT.EYE
LT.EYE
SPECTS
DIST
WITHOUT GLASS
NEAR
COLOR VISION BY ISHIHARA CHART
PULSE
BP
SYS EXAM
NAD
PAST H/O:
MEDICATION H/O:
PRESENT MEDICATION:
HB:
M: 13-18 F:12-16
RBS:
(70-140)
HBA1C:
(4.0-6.5)
FBS:
(70-110)
TOTAL CHOLESTEROL:
(< 200)
SERUM TRIGLYCERIDES:
(< 150)
SERUM HDL:
(> 40)
SERUM LDL:
(< 100)
SERUM VLDL:
(< 30)
SERUM BILIRUBIN TOTAL:
(0.5-1.2)
SERUM CREATININE:
(M:0.6-1.4 F:0.5-1.2)
SGPT:
(< 40)
SGOT:
(< 40)
BUN:
URINE SUGAR:
AUDIO:
-
PFT:
-
X RAY CHEST (PA VIEW)
-
CHIF MEDICAL OFFICER
OCCUPATIONAL HEALTH CENTRE
CONTACT NO. 9099093222,9099061549,02876-
265302/3/4
Print