format('m') < 4) { $financialYearStart = ($randomDateTime->format('Y') - 1) . "-01-01"; } else { $financialYearStart = $randomDateTime->format('Y') . "-01-01"; } if ($randomDateTime->format('m') < 4) { $financialYearEnd = $randomDateTime->format('Y') . "-12-31"; } else { $financialYearEnd = ($randomDateTime->format('Y') + 1) . "-12-31"; } $sql_employee_key = "SELECT a.* ,b.checkup_type_id , b.checkup_id , b.checkup_date FROM checkup_form_key_value a INNER JOIN checkup_form b ON a.checkup_form_id = b.checkup_id WHERE b.emp_id = '" . $emp_id . "' and b.checkup_type_id= '41' and b.checkup_date between '$financialYearStart' AND '$financialYearEnd' "; error_log("dipak mali dipak mali:" . $sql_employee_key); $res_data_key = mysqli_query($conn, $sql_employee_key); while ($rows_exa_key = mysqli_fetch_array($res_data_key)) { if ($rows_exa_key['checkup_form_key'] == 'nasal_discharge') { $nasal_discharge = $rows_exa_key['checkup_form_value']; } if ($rows_exa_key['checkup_form_key'] == 'wheeze') { $wheeze = $rows_exa_key['checkup_form_value']; } if ($rows_exa_key['checkup_form_key'] == 'cough') { $cough = $rows_exa_key['checkup_form_value']; } if ($rows_exa_key['checkup_form_key'] == 'expectoration') { $expectoration = $rows_exa_key['checkup_form_value']; } if ($rows_exa_key['checkup_form_key'] == 'tightness_of_chest') { $tightness_of_chest = $rows_exa_key['checkup_form_value']; } if ($rows_exa_key['checkup_form_key'] == 'dyspnoea') { $dyspnoea = $rows_exa_key['checkup_form_value']; } if ($rows_exa_key['checkup_form_key'] == 'palpitation') { $palpitation = $rows_exa_key['checkup_form_value']; } if ($rows_exa_key['checkup_form_key'] == 'heart') { $heart = $rows_exa_key['checkup_form_value']; } if ($rows_exa_key['checkup_form_key'] == 'cyanosis') { $cyanosis = $rows_exa_key['checkup_form_value']; } if ($rows_exa_key['checkup_form_key'] == 'tachycardia_bradycardia') { $tachycardia_bradycardia = $rows_exa_key['checkup_form_value']; } if ($rows_exa_key['checkup_form_key'] == 'hb_1') { $hb_1 = $rows_exa_key['checkup_form_value']; } if ($rows_exa_key['checkup_form_key'] == 'tlc_count') { $tlc_count = $rows_exa_key['checkup_form_value']; } if ($rows_exa_key['checkup_form_key'] == 'polymorphs_2') { $polymorphs_2 = $rows_exa_key['checkup_form_value']; } if ($rows_exa_key['checkup_form_key'] == 'eosinophil_5') { $eosinophil_5 = $rows_exa_key['checkup_form_value']; } if ($rows_exa_key['checkup_form_key'] == 'basophils_5') { $basophils_5 = $rows_exa_key['checkup_form_value']; } if ($rows_exa_key['checkup_form_key'] == 'lymphocyte') { $lymphocyte = $rows_exa_key['checkup_form_value']; } if ($rows_exa_key['checkup_form_key'] == 'monocyte') { $monocyte = $rows_exa_key['checkup_form_value']; } if ($rows_exa_key['checkup_form_key'] == 'total_rbc_count') { $total_rbc_count = $rows_exa_key['checkup_form_value']; } if ($rows_exa_key['checkup_form_key'] == 'platelet_count') { $platelet_count = $rows_exa_key['checkup_form_value']; } if ($rows_exa_key['checkup_form_key'] == 'reticulocyte_count') { $reticulocyte_count = $rows_exa_key['checkup_form_value']; } if ($rows_exa_key['checkup_form_key'] == 'esr_3') { $esr_3 = $rows_exa_key['checkup_form_value']; } if ($rows_exa_key['checkup_form_key'] == 'serum_bilirubin_total') { $serum_bilirubin_total = $rows_exa_key['checkup_form_value']; } if ($rows_exa_key['checkup_form_key'] == 'serum_bilirubin_direct') { $serum_bilirubin_direct = $rows_exa_key['checkup_form_value']; } if ($rows_exa_key['checkup_form_key'] == 'sgot_1') { $sgot_1 = $rows_exa_key['checkup_form_value']; } if ($rows_exa_key['checkup_form_key'] == 'sgpt_1') { $sgpt_1 = $rows_exa_key['checkup_form_value']; } if ($rows_exa_key['checkup_form_key'] == 'cholesterol') { $cholesterol = $rows_exa_key['checkup_form_value']; } if ($rows_exa_key['checkup_form_key'] == 'total_protein') { $total_protein = $rows_exa_key['checkup_form_value']; } if ($rows_exa_key['checkup_form_key'] == 'serum_albumin') { $serum_albumin = $rows_exa_key['checkup_form_value']; } if ($rows_exa_key['checkup_form_key'] == 'blood_urea') { $blood_urea = $rows_exa_key['checkup_form_value']; } if ($rows_exa_key['checkup_form_key'] == 'serum_creatinine_1') { $serum_creatinine_1 = $rows_exa_key['checkup_form_value']; } if ($rows_exa_key['checkup_form_key'] == 'hba1c_1') { $hba1c_1 = $rows_exa_key['checkup_form_value']; } if ($rows_exa_key['checkup_form_key'] == 'serum_cholinesterase') { $serum_cholinesterase = $rows_exa_key['checkup_form_value']; } if ($rows_exa_key['checkup_form_key'] == 'blood_residue_estimation') { $blood_residue_estimation = $rows_exa_key['checkup_form_value']; } if ($rows_exa_key['checkup_form_key'] == 'routine') { $routine = $rows_exa_key['checkup_form_value']; } if ($rows_exa_key['checkup_form_key'] == 'microscopic') { $microscopic = $rows_exa_key['checkup_form_value']; } if ($rows_exa_key['checkup_form_key'] == 'fasting_2') { $fasting_2 = $rows_exa_key['checkup_form_value']; } if ($rows_exa_key['checkup_form_key'] == 'post_prandial_2') { $post_prandial_2 = $rows_exa_key['checkup_form_value']; } if ($rows_exa_key['checkup_form_key'] == 'rbs_2') { $rbs_2 = $rows_exa_key['checkup_form_value']; } } //EXA_I $sql_employee_key_1 = "SELECT a.* ,b.checkup_type_id , b.checkup_id , b.checkup_date FROM checkup_form_key_value a INNER JOIN checkup_form b ON a.checkup_form_id = b.checkup_id WHERE b.emp_id = '" . $emp_id . "' and b.checkup_type_id= '52' and b.checkup_date between '$financialYearStart' AND '$financialYearEnd' "; error_log("dipak mali dipak mali:" . $sql_employee_key_1); $res_data_key_1 = mysqli_query($conn, $sql_employee_key_1); while ($rows_exa_key_1 = mysqli_fetch_array($res_data_key_1)) { if ($rows_exa_key_1['checkup_form_key'] == 'nasal_discharge') { $nasal_discharge_1 = $rows_exa_key_1['checkup_form_value']; } if ($rows_exa_key_1['checkup_form_key'] == 'wheeze') { $wheeze_1 = $rows_exa_key_1['checkup_form_value']; } if ($rows_exa_key_1['checkup_form_key'] == 'cough') { $cough_1 = $rows_exa_key_1['checkup_form_value']; } if ($rows_exa_key_1['checkup_form_key'] == 'expectoration') { $expectoration_1 = $rows_exa_key_1['checkup_form_value']; } if ($rows_exa_key_1['checkup_form_key'] == 'tightness_of_chest') { $tightness_of_chest_1 = $rows_exa_key_1['checkup_form_value']; } if ($rows_exa_key_1['checkup_form_key'] == 'dyspnoea') { $dyspnoea_1 = $rows_exa_key_1['checkup_form_value']; } if ($rows_exa_key_1['checkup_form_key'] == 'palpitation') { $palpitation_1 = $rows_exa_key_1['checkup_form_value']; } if ($rows_exa_key_1['checkup_form_key'] == 'heart') { $heart_1 = $rows_exa_key_1['checkup_form_value']; } if ($rows_exa_key_1['checkup_form_key'] == 'cyanosis') { $cyanosis_1 = $rows_exa_key_1['checkup_form_value']; } if ($rows_exa_key_1['checkup_form_key'] == 'tachycardia_bradycardia') { $tachycardia_bradycardia_1 = $rows_exa_key_1['checkup_form_value']; } if ($rows_exa_key_1['checkup_form_key'] == 'hb_1') { $hb_1_1 = $rows_exa_key_1['checkup_form_value']; } if ($rows_exa_key_1['checkup_form_key'] == 'tlc_count') { $tlc_count_1 = $rows_exa_key_1['checkup_form_value']; } if ($rows_exa_key_1['checkup_form_key'] == 'polymorphs_2') { $polymorphs_2_1 = $rows_exa_key_1['checkup_form_value']; } if ($rows_exa_key_1['checkup_form_key'] == 'eosinophil_5') { $eosinophil_5_1 = $rows_exa_key_1['checkup_form_value']; } if ($rows_exa_key_1['checkup_form_key'] == 'basophils_5') { $basophils_5_1 = $rows_exa_key_1['checkup_form_value']; } if ($rows_exa_key_1['checkup_form_key'] == 'lymphocyte') { $lymphocyte_1 = $rows_exa_key_1['checkup_form_value']; } if ($rows_exa_key_1['checkup_form_key'] == 'monocyte') { $monocyte_1 = $rows_exa_key_1['checkup_form_value']; } if ($rows_exa_key_1['checkup_form_key'] == 'total_rbc_count') { $total_rbc_count_1 = $rows_exa_key_1['checkup_form_value']; } if ($rows_exa_key_1['checkup_form_key'] == 'platelet_count') { $platelet_count_1 = $rows_exa_key_1['checkup_form_value']; } if ($rows_exa_key_1['checkup_form_key'] == 'reticulocyte_count') { $reticulocyte_count_1 = $rows_exa_key_1['checkup_form_value']; } if ($rows_exa_key_1['checkup_form_key'] == 'esr_3') { $esr_3_1 = $rows_exa_key_1['checkup_form_value']; } if ($rows_exa_key_1['checkup_form_key'] == 'serum_bilirubin_total') { $serum_bilirubin_total_1 = $rows_exa_key_1['checkup_form_value']; } if ($rows_exa_key_1['checkup_form_key'] == 'serum_bilirubin_direct') { $serum_bilirubin_direct_1 = $rows_exa_key_1['checkup_form_value']; } if ($rows_exa_key_1['checkup_form_key'] == 'sgot_1') { $sgot_1_1 = $rows_exa_key_1['checkup_form_value']; } if ($rows_exa_key_1['checkup_form_key'] == 'sgpt_1') { $sgpt_1_1 = $rows_exa_key_1['checkup_form_value']; } if ($rows_exa_key_1['checkup_form_key'] == 'cholesterol') { $cholesterol_1 = $rows_exa_key_1['checkup_form_value']; } if ($rows_exa_key_1['checkup_form_key'] == 'total_protein') { $total_protein_1 = $rows_exa_key_1['checkup_form_value']; } if ($rows_exa_key_1['checkup_form_key'] == 'serum_albumin') { $serum_albumin_1 = $rows_exa_key_1['checkup_form_value']; } if ($rows_exa_key_1['checkup_form_key'] == 'blood_urea') { $blood_urea_1 = $rows_exa_key_1['checkup_form_value']; } if ($rows_exa_key_1['checkup_form_key'] == 'serum_creatinine_1') { $serum_creatinine_1_1 = $rows_exa_key_1['checkup_form_value']; } if ($rows_exa_key_1['checkup_form_key'] == 'hba1c_1') { $hba1c_1_1 = $rows_exa_key_1['checkup_form_value']; } if ($rows_exa_key_1['checkup_form_key'] == 'serum_cholinesterase') { $serum_cholinesterase_1 = $rows_exa_key_1['checkup_form_value']; } if ($rows_exa_key_1['checkup_form_key'] == 'blood_residue_estimation') { $blood_residue_estimation_1 = $rows_exa_key_1['checkup_form_value']; } if ($rows_exa_key_1['checkup_form_key'] == 'routine') { $routine_1 = $rows_exa_key_1['checkup_form_value']; } if ($rows_exa_key_1['checkup_form_key'] == 'microscopic') { $microscopic_1 = $rows_exa_key_1['checkup_form_value']; } if ($rows_exa_key_1['checkup_form_key'] == 'fasting_2') { $fasting_2_1 = $rows_exa_key_1['checkup_form_value']; } if ($rows_exa_key_1['checkup_form_key'] == 'post_prandial_2') { $post_prandial_2_1 = $rows_exa_key_1['checkup_form_value']; } if ($rows_exa_key_1['checkup_form_key'] == 'rbs_2') { $rbs_2_1 = $rows_exa_key_1['checkup_form_value']; } } //EXA-II $sql_employee_key_2 = "SELECT a.* ,b.checkup_type_id , b.checkup_id , b.checkup_date FROM checkup_form_key_value a INNER JOIN checkup_form b ON a.checkup_form_id = b.checkup_id WHERE b.emp_id = '" . $emp_id . "' and b.checkup_type_id= '53' and b.checkup_date between '$financialYearStart' AND '$financialYearEnd' "; error_log("dipak mali dipak mali:" . $sql_employee_key_2); $res_data_key_2 = mysqli_query($conn, $sql_employee_key_2); while ($rows_exa_key_2 = mysqli_fetch_array($res_data_key_2)) { if ($rows_exa_key_2['checkup_form_key'] == 'nasal_discharge') { $nasal_discharge_2 = $rows_exa_key_2['checkup_form_value']; } if ($rows_exa_key_2['checkup_form_key'] == 'wheeze') { $wheeze_2 = $rows_exa_key_2['checkup_form_value']; } if ($rows_exa_key_2['checkup_form_key'] == 'cough') { $cough_2 = $rows_exa_key_2['checkup_form_value']; } if ($rows_exa_key_2['checkup_form_key'] == 'expectoration') { $expectoration_2 = $rows_exa_key_2['checkup_form_value']; } if ($rows_exa_key_2['checkup_form_key'] == 'tightness_of_chest') { $tightness_of_chest_2 = $rows_exa_key_2['checkup_form_value']; } if ($rows_exa_key_2['checkup_form_key'] == 'dyspnoea') { $dyspnoea_2 = $rows_exa_key_2['checkup_form_value']; } if ($rows_exa_key_2['checkup_form_key'] == 'palpitation') { $palpitation_2 = $rows_exa_key_2['checkup_form_value']; } if ($rows_exa_key_2['checkup_form_key'] == 'heart') { $heart_2 = $rows_exa_key_2['checkup_form_value']; } if ($rows_exa_key_2['checkup_form_key'] == 'cyanosis') { $cyanosis_2 = $rows_exa_key_2['checkup_form_value']; } if ($rows_exa_key_2['checkup_form_key'] == 'tachycardia_bradycardia') { $tachycardia_bradycardia_2 = $rows_exa_key_2['checkup_form_value']; } if ($rows_exa_key_2['checkup_form_key'] == 'hb_1') { $hb_1_2 = $rows_exa_key_2['checkup_form_value']; } if ($rows_exa_key_2['checkup_form_key'] == 'tlc_count') { $tlc_count_2 = $rows_exa_key_2['checkup_form_value']; } if ($rows_exa_key_2['checkup_form_key'] == 'polymorphs_2') { $polymorphs_2_2 = $rows_exa_key_2['checkup_form_value']; } if ($rows_exa_key_2['checkup_form_key'] == 'eosinophil_5') { $eosinophil_5_2 = $rows_exa_key_2['checkup_form_value']; } if ($rows_exa_key_2['checkup_form_key'] == 'basophils_5') { $basophils_5_2 = $rows_exa_key_2['checkup_form_value']; } if ($rows_exa_key_2['checkup_form_key'] == 'lymphocyte') { $lymphocyte_2 = $rows_exa_key_2['checkup_form_value']; } if ($rows_exa_key_2['checkup_form_key'] == 'monocyte') { $monocyte_2 = $rows_exa_key_2['checkup_form_value']; } if ($rows_exa_key_2['checkup_form_key'] == 'total_rbc_count') { $total_rbc_count_2 = $rows_exa_key_2['checkup_form_value']; } if ($rows_exa_key_2['checkup_form_key'] == 'platelet_count') { $platelet_count_2 = $rows_exa_key_2['checkup_form_value']; } if ($rows_exa_key_2['checkup_form_key'] == 'reticulocyte_count') { $reticulocyte_count_2 = $rows_exa_key_2['checkup_form_value']; } if ($rows_exa_key_2['checkup_form_key'] == 'esr_3') { $esr_3_2 = $rows_exa_key_2['checkup_form_value']; } if ($rows_exa_key_2['checkup_form_key'] == 'serum_bilirubin_total') { $serum_bilirubin_total_2 = $rows_exa_key_2['checkup_form_value']; } if ($rows_exa_key_2['checkup_form_key'] == 'serum_bilirubin_direct') { $serum_bilirubin_direct_2 = $rows_exa_key_2['checkup_form_value']; } if ($rows_exa_key_2['checkup_form_key'] == 'sgot_1') { $sgot_1_2 = $rows_exa_key_2['checkup_form_value']; } if ($rows_exa_key_2['checkup_form_key'] == 'sgpt_1') { $sgpt_1_2 = $rows_exa_key_2['checkup_form_value']; } if ($rows_exa_key_2['checkup_form_key'] == 'cholesterol') { $cholesterol_2 = $rows_exa_key_2['checkup_form_value']; } if ($rows_exa_key_2['checkup_form_key'] == 'total_protein') { $total_protein_2 = $rows_exa_key_2['checkup_form_value']; } if ($rows_exa_key_2['checkup_form_key'] == 'serum_albumin') { $serum_albumin_2 = $rows_exa_key_2['checkup_form_value']; } if ($rows_exa_key_2['checkup_form_key'] == 'blood_urea') { $blood_urea_2 = $rows_exa_key_2['checkup_form_value']; } if ($rows_exa_key_2['checkup_form_key'] == 'serum_creatinine_1') { $serum_creatinine_1_2 = $rows_exa_key_2['checkup_form_value']; } if ($rows_exa_key_2['checkup_form_key'] == 'hba1c_1') { $hba1c_1_2 = $rows_exa_key_2['checkup_form_value']; } if ($rows_exa_key_2['checkup_form_key'] == 'serum_cholinesterase') { $serum_cholinesterase_2 = $rows_exa_key_2['checkup_form_value']; } if ($rows_exa_key_2['checkup_form_key'] == 'blood_residue_estimation') { $blood_residue_estimation_2 = $rows_exa_key_2['checkup_form_value']; } if ($rows_exa_key_2['checkup_form_key'] == 'routine') { $routine_2 = $rows_exa_key_2['checkup_form_value']; } if ($rows_exa_key_2['checkup_form_key'] == 'microscopic') { $microscopic_2 = $rows_exa_key_2['checkup_form_value']; } if ($rows_exa_key_2['checkup_form_key'] == 'fasting_2') { $fasting_2_2 = $rows_exa_key_2['checkup_form_value']; } if ($rows_exa_key_2['checkup_form_key'] == 'post_prandial_2') { $post_prandial_2_2 = $rows_exa_key_2['checkup_form_value']; } if ($rows_exa_key_2['checkup_form_key'] == 'rbs_2') { $rbs_2_2 = $rows_exa_key_2['checkup_form_value']; } } //EXA=III $sql_employee_key_3 = "SELECT a.* ,b.checkup_type_id , b.checkup_id , b.checkup_date FROM checkup_form_key_value a INNER JOIN checkup_form b ON a.checkup_form_id = b.checkup_id WHERE b.emp_id = '" . $emp_id . "' and b.checkup_type_id= '54' and b.checkup_date between '$financialYearStart' AND '$financialYearEnd' "; error_log("dipak mali dipak mali:" . $sql_employee_key_3); $res_data_key_3 = mysqli_query($conn, $sql_employee_key_3); while ($rows_exa_key_3 = mysqli_fetch_array($res_data_key_3)) { if ($rows_exa_key_3['checkup_form_key'] == 'nasal_discharge') { $nasal_discharge_3 = $rows_exa_key_3['checkup_form_value']; } if ($rows_exa_key_3['checkup_form_key'] == 'wheeze') { $wheeze_3 = $rows_exa_key_3['checkup_form_value']; } if ($rows_exa_key_3['checkup_form_key'] == 'cough') { $cough_3 = $rows_exa_key_3['checkup_form_value']; } if ($rows_exa_key_3['checkup_form_key'] == 'expectoration') { $expectoration_3 = $rows_exa_key_3['checkup_form_value']; } if ($rows_exa_key_3['checkup_form_key'] == 'tightness_of_chest') { $tightness_of_chest_3 = $rows_exa_key_3['checkup_form_value']; } if ($rows_exa_key_3['checkup_form_key'] == 'dyspnoea') { $dyspnoea_3 = $rows_exa_key_3['checkup_form_value']; } if ($rows_exa_key_3['checkup_form_key'] == 'palpitation') { $palpitation_3 = $rows_exa_key_3['checkup_form_value']; } if ($rows_exa_key_3['checkup_form_key'] == 'heart') { $heart_3 = $rows_exa_key_3['checkup_form_value']; } if ($rows_exa_key_3['checkup_form_key'] == 'cyanosis') { $cyanosis_3 = $rows_exa_key_3['checkup_form_value']; } if ($rows_exa_key_3['checkup_form_key'] == 'tachycardia_bradycardia') { $tachycardia_bradycardia_3 = $rows_exa_key_3['checkup_form_value']; } if ($rows_exa_key_3['checkup_form_key'] == 'hb_1') { $hb_1_3 = $rows_exa_key_3['checkup_form_value']; } if ($rows_exa_key_3['checkup_form_key'] == 'tlc_count') { $tlc_count_3 = $rows_exa_key_3['checkup_form_value']; } if ($rows_exa_key_3['checkup_form_key'] == 'polymorphs_2') { $polymorphs_2_3 = $rows_exa_key_3['checkup_form_value']; } if ($rows_exa_key_3['checkup_form_key'] == 'eosinophil_5') { $eosinophil_5_3 = $rows_exa_key_3['checkup_form_value']; } if ($rows_exa_key_3['checkup_form_key'] == 'basophils_5') { $basophils_5_3 = $rows_exa_key_3['checkup_form_value']; } if ($rows_exa_key_3['checkup_form_key'] == 'lymphocyte') { $lymphocyte_3 = $rows_exa_key_3['checkup_form_value']; } if ($rows_exa_key_3['checkup_form_key'] == 'monocyte') { $monocyte_3 = $rows_exa_key_3['checkup_form_value']; } if ($rows_exa_key_3['checkup_form_key'] == 'total_rbc_count') { $total_rbc_count_3 = $rows_exa_key_3['checkup_form_value']; } if ($rows_exa_key_3['checkup_form_key'] == 'platelet_count') { $platelet_count_3 = $rows_exa_key_3['checkup_form_value']; } if ($rows_exa_key_3['checkup_form_key'] == 'reticulocyte_count') { $reticulocyte_count_3 = $rows_exa_key_3['checkup_form_value']; } if ($rows_exa_key_3['checkup_form_key'] == 'esr_3') { $esr_3_3 = $rows_exa_key_3['checkup_form_value']; } if ($rows_exa_key_3['checkup_form_key'] == 'serum_bilirubin_total') { $serum_bilirubin_total_3 = $rows_exa_key_3['checkup_form_value']; } if ($rows_exa_key_3['checkup_form_key'] == 'serum_bilirubin_direct') { $serum_bilirubin_direct_3 = $rows_exa_key_3['checkup_form_value']; } if ($rows_exa_key_3['checkup_form_key'] == 'sgot_1') { $sgot_1_3 = $rows_exa_key_3['checkup_form_value']; } if ($rows_exa_key_3['checkup_form_key'] == 'sgpt_1') { $sgpt_1_3 = $rows_exa_key_3['checkup_form_value']; } if ($rows_exa_key_3['checkup_form_key'] == 'cholesterol') { $cholesterol_3 = $rows_exa_key_3['checkup_form_value']; } if ($rows_exa_key_3['checkup_form_key'] == 'total_protein') { $total_protein_3 = $rows_exa_key_3['checkup_form_value']; } if ($rows_exa_key_3['checkup_form_key'] == 'serum_albumin') { $serum_albumin_3 = $rows_exa_key_3['checkup_form_value']; } if ($rows_exa_key_3['checkup_form_key'] == 'blood_urea') { $blood_urea_3 = $rows_exa_key_3['checkup_form_value']; } if ($rows_exa_key_3['checkup_form_key'] == 'serum_creatinine_1') { $serum_creatinine_1_3 = $rows_exa_key_3['checkup_form_value']; } if ($rows_exa_key_3['checkup_form_key'] == 'hba1c_1') { $hba1c_1_3 = $rows_exa_key_3['checkup_form_value']; } if ($rows_exa_key_3['checkup_form_key'] == 'serum_cholinesterase') { $serum_cholinesterase_3 = $rows_exa_key_3['checkup_form_value']; } if ($rows_exa_key_3['checkup_form_key'] == 'blood_residue_estimation') { $blood_residue_estimation_3 = $rows_exa_key_3['checkup_form_value']; } if ($rows_exa_key_3['checkup_form_key'] == 'routine') { $routine_3 = $rows_exa_key_3['checkup_form_value']; } if ($rows_exa_key_3['checkup_form_key'] == 'microscopic') { $microscopic_3 = $rows_exa_key_3['checkup_form_value']; } if ($rows_exa_key_3['checkup_form_key'] == 'fasting_2') { $fasting_2_3 = $rows_exa_key_3['checkup_form_value']; } if ($rows_exa_key_3['checkup_form_key'] == 'post_prandial_2') { $post_prandial_2_3 = $rows_exa_key_3['checkup_form_value']; } if ($rows_exa_key_3['checkup_form_key'] == 'rbs_2') { $rbs_2_3 = $rows_exa_key_3['checkup_form_value']; } } //EXA-IV $sql_employee_key_4 = "SELECT a.* ,b.checkup_type_id , b.checkup_id , b.checkup_date FROM checkup_form_key_value a INNER JOIN checkup_form b ON a.checkup_form_id = b.checkup_id WHERE b.emp_id = '" . $emp_id . "' and b.checkup_type_id= '57' and b.checkup_date between '$financialYearStart' AND '$financialYearEnd' "; error_log("dipak mali dipak mali:" . $sql_employee_key_4); $res_data_key_4 = mysqli_query($conn, $sql_employee_key_4); while ($rows_exa_key_4 = mysqli_fetch_array($res_data_key_4)) { if ($rows_exa_key_4['checkup_form_key'] == 'nasal_discharge') { $nasal_discharge_4 = $rows_exa_key_4['checkup_form_value']; } if ($rows_exa_key_4['checkup_form_key'] == 'wheeze') { $wheeze_4 = $rows_exa_key_4['checkup_form_value']; } if ($rows_exa_key_4['checkup_form_key'] == 'cough') { $cough_4 = $rows_exa_key_4['checkup_form_value']; } if ($rows_exa_key_4['checkup_form_key'] == 'expectoration') { $expectoration_4 = $rows_exa_key_4['checkup_form_value']; } if ($rows_exa_key_4['checkup_form_key'] == 'tightness_of_chest') { $tightness_of_chest_4 = $rows_exa_key_4['checkup_form_value']; } if ($rows_exa_key_4['checkup_form_key'] == 'dyspnoea') { $dyspnoea_4 = $rows_exa_key_4['checkup_form_value']; } if ($rows_exa_key_4['checkup_form_key'] == 'palpitation') { $palpitation_4 = $rows_exa_key_4['checkup_form_value']; } if ($rows_exa_key_4['checkup_form_key'] == 'heart') { $heart_4 = $rows_exa_key_4['checkup_form_value']; } if ($rows_exa_key_4['checkup_form_key'] == 'cyanosis') { $cyanosis_4 = $rows_exa_key_4['checkup_form_value']; } if ($rows_exa_key_4['checkup_form_key'] == 'tachycardia_bradycardia') { $tachycardia_bradycardia_4 = $rows_exa_key_4['checkup_form_value']; } if ($rows_exa_key_4['checkup_form_key'] == 'hb_1') { $hb_1_4 = $rows_exa_key_4['checkup_form_value']; } if ($rows_exa_key_4['checkup_form_key'] == 'tlc_count') { $tlc_count_4 = $rows_exa_key_4['checkup_form_value']; } if ($rows_exa_key_4['checkup_form_key'] == 'polymorphs_2') { $polymorphs_2_4 = $rows_exa_key_4['checkup_form_value']; } if ($rows_exa_key_4['checkup_form_key'] == 'eosinophil_5') { $eosinophil_5_4 = $rows_exa_key_4['checkup_form_value']; } if ($rows_exa_key_4['checkup_form_key'] == 'basophils_5') { $basophils_5_4 = $rows_exa_key_4['checkup_form_value']; } if ($rows_exa_key_4['checkup_form_key'] == 'lymphocyte') { $lymphocyte_4 = $rows_exa_key_4['checkup_form_value']; } if ($rows_exa_key_4['checkup_form_key'] == 'monocyte') { $monocyte_4 = $rows_exa_key_4['checkup_form_value']; } if ($rows_exa_key_4['checkup_form_key'] == 'total_rbc_count') { $total_rbc_count_4 = $rows_exa_key_4['checkup_form_value']; } if ($rows_exa_key_4['checkup_form_key'] == 'platelet_count') { $platelet_count_4 = $rows_exa_key_4['checkup_form_value']; } if ($rows_exa_key_4['checkup_form_key'] == 'reticulocyte_count') { $reticulocyte_count_4 = $rows_exa_key_4['checkup_form_value']; } if ($rows_exa_key_4['checkup_form_key'] == 'esr_3') { $esr_3_4 = $rows_exa_key_4['checkup_form_value']; } if ($rows_exa_key_4['checkup_form_key'] == 'serum_bilirubin_total') { $serum_bilirubin_total_4 = $rows_exa_key_4['checkup_form_value']; } if ($rows_exa_key_4['checkup_form_key'] == 'serum_bilirubin_direct') { $serum_bilirubin_direct_4 = $rows_exa_key_4['checkup_form_value']; } if ($rows_exa_key_4['checkup_form_key'] == 'sgot_1') { $sgot_1_4 = $rows_exa_key_4['checkup_form_value']; } if ($rows_exa_key_4['checkup_form_key'] == 'sgpt_1') { $sgpt_1_4 = $rows_exa_key_4['checkup_form_value']; } if ($rows_exa_key_4['checkup_form_key'] == 'cholesterol') { $cholesterol_4 = $rows_exa_key_4['checkup_form_value']; } if ($rows_exa_key_4['checkup_form_key'] == 'total_protein') { $total_protein_4 = $rows_exa_key_4['checkup_form_value']; } if ($rows_exa_key_4['checkup_form_key'] == 'serum_albumin') { $serum_albumin_4 = $rows_exa_key_4['checkup_form_value']; } if ($rows_exa_key_4['checkup_form_key'] == 'blood_urea') { $blood_urea_4 = $rows_exa_key_4['checkup_form_value']; } if ($rows_exa_key_4['checkup_form_key'] == 'serum_creatinine_1') { $serum_creatinine_1_4 = $rows_exa_key_4['checkup_form_value']; } if ($rows_exa_key_4['checkup_form_key'] == 'hba1c_1') { $hba1c_1_4 = $rows_exa_key_4['checkup_form_value']; } if ($rows_exa_key_4['checkup_form_key'] == 'serum_cholinesterase') { $serum_cholinesterase_4 = $rows_exa_key_4['checkup_form_value']; } if ($rows_exa_key_4['checkup_form_key'] == 'blood_residue_estimation') { $blood_residue_estimation_4 = $rows_exa_key_4['checkup_form_value']; } if ($rows_exa_key_4['checkup_form_key'] == 'routine') { $routine_4 = $rows_exa_key_4['checkup_form_value']; } if ($rows_exa_key_4['checkup_form_key'] == 'microscopic') { $microscopic_4 = $rows_exa_key_4['checkup_form_value']; } if ($rows_exa_key_4['checkup_form_key'] == 'fasting_2') { $fasting_2_4 = $rows_exa_key_4['checkup_form_value']; } if ($rows_exa_key_4['checkup_form_key'] == 'post_prandial_2') { $post_prandial_2_4 = $rows_exa_key_4['checkup_form_value']; } if ($rows_exa_key_4['checkup_form_key'] == 'rbs_2') { $rbs_2_4 = $rows_exa_key_4['checkup_form_value']; } } ?>

CARDIO RESPIRATORY:

  P.E. I II III IV
Nasal Discharge
Wheeze
Cough
Expectoration
Tightness of chest
Dyspnoea
Palpitation
Heart
Cyanosis
Tachycardia / Bradycardia

INVESTIGATIONS

  P.E. I II III IV
1) Blood Hb gm%
2) Total RBC Count
3) TLC
4) DLC P E B L M P E B L M P E B L M P E B L M P E B L M
5) Platelet Count
6) Reticulocyte Count
7) ESR
8) Serum Bilirubin T/D T D T D T D T D T D
9) Serum Alk Phosp
10) S.G.O.T.
11) S.G.P.T.
12) Cholesterol
13) Total Protein
14) Serum Albumin
15) Blood Urea
15) Serum Creatinine
17) Blood Sugar F PL R F PL R F PL R F PL R F PL R
18) HbA1C
19) Serum Cholinesterase
Urine Examination
  a) Routine
  b) Microscopic