ESH/previous_data_history.php
2024-10-23 18:28:06 +05:30

1616 lines
65 KiB
PHP

<?php
$randomDate = date('Y-m-d', strtotime($row_checkup['checkup_date']));
$chup_id = $row_checkup['checkup_id'];
$randomDateTime = new DateTime($randomDate);
//41,52,53,54,57
if ($randomDateTime->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'];
}
}
?>
<h2 style="font-size: 12px; text-align: center;"><b>CARDIO RESPIRATORY:</b></h2>
<table border="1" width="100%" cellspacing="0">
<tr>
<td style="width: 80px; text-align: center;">&nbsp;</td>
<td style="width: 50px; text-align: center;">P.E.</td>
<td style="width: 50px; text-align: center;">I</td>
<td style="width: 50px; text-align: center;">II</td>
<td style="width: 50px; text-align: center;">III</td>
<td style="width: 50px; text-align: center;">IV</td>
</tr>
<tr>
<td>Nasal Discharge </td>
<td style="text-align: center;"><?php echo $nasal_discharge ?></td>
<td style="text-align: center;"><?php echo $nasal_discharge_1 ?></td>
<td style="text-align: center;"><?php echo $nasal_discharge_2 ?></td>
<td style="text-align: center;"><?php echo $nasal_discharge_3 ?></td>
<td style="text-align: center;"><?php echo $nasal_discharge_4 ?></td>
</tr>
<tr>
<td>Wheeze</td>
<td style="text-align: center;"><?php echo $wheeze ?></td>
<td style="text-align: center;"><?php echo $wheeze_1 ?></td>
<td style="text-align: center;"><?php echo $wheeze_2 ?></td>
<td style="text-align: center;"><?php echo $wheeze_3 ?></td>
<td style="text-align: center;"><?php echo $wheeze_4 ?></td>
</tr>
<tr>
<td>Cough</td>
<td style="text-align: center;"><?php echo $cough ?></td>
<td style="text-align: center;"><?php echo $cough_1 ?></td>
<td style="text-align: center;"><?php echo $cough_2 ?></td>
<td style="text-align: center;"><?php echo $cough_3 ?></td>
<td style="text-align: center;"><?php echo $cough_4 ?></td>
</tr>
<tr>
<td>Expectoration</td>
<td style="text-align: center;"><?php echo $expectoration ?></td>
<td style="text-align: center;"><?php echo $expectoration_1 ?></td>
<td style="text-align: center;"><?php echo $expectoration_2 ?></td>
<td style="text-align: center;"><?php echo $expectoration_3 ?></td>
<td style="text-align: center;"><?php echo $expectoration_4 ?></td>
</tr>
<tr>
<td>Tightness of chest </td>
<td style="text-align: center;"><?php echo $tightness_of_chest ?></td>
<td style="text-align: center;"><?php echo $tightness_of_chest_1 ?></td>
<td style="text-align: center;"><?php echo $tightness_of_chest_2 ?></td>
<td style="text-align: center;"><?php echo $tightness_of_chest_3 ?></td>
<td style="text-align: center;"><?php echo $tightness_of_chest_4 ?></td>
</tr>
<tr>
<td>Dyspnoea</td>
<td style="text-align: center;"><?php echo $dyspnoea ?></td>
<td style="text-align: center;"><?php echo $dyspnoea_1 ?></td>
<td style="text-align: center;"><?php echo $dyspnoea_2 ?></td>
<td style="text-align: center;"><?php echo $dyspnoea_3 ?></td>
<td style="text-align: center;"><?php echo $dyspnoea_4 ?></td>
</tr>
<tr>
<td>Palpitation</td>
<td style="text-align: center;"><?php echo $palpitation ?></td>
<td style="text-align: center;"><?php echo $palpitation_1 ?></td>
<td style="text-align: center;"><?php echo $palpitation_2 ?></td>
<td style="text-align: center;"><?php echo $palpitation_3 ?></td>
<td style="text-align: center;"><?php echo $palpitation_4 ?></td>
</tr>
<tr>
<td>Heart</td>
<td style="text-align: center;"><?php echo $heart ?></td>
<td style="text-align: center;"><?php echo $heart_1 ?></td>
<td style="text-align: center;"><?php echo $heart_2 ?></td>
<td style="text-align: center;"><?php echo $heart_3 ?></td>
<td style="text-align: center;"><?php echo $heart_3 ?></td>
</tr>
<tr>
<td>Cyanosis</td>
<td style="text-align: center;"><?php echo $cyanosis ?></td>
<td style="text-align: center;"><?php echo $cyanosis_1 ?></td>
<td style="text-align: center;"><?php echo $cyanosis_2 ?></td>
<td style="text-align: center;"><?php echo $cyanosis_3 ?></td>
<td style="text-align: center;"><?php echo $cyanosis_4 ?></td>
</tr>
<tr>
<td>Tachycardia / Bradycardia</td>
<td style="text-align: center;"><?php echo $tachycardia_bradycardia ?></td>
<td style="text-align: center;"><?php echo $tachycardia_bradycardia_1 ?></td>
<td style="text-align: center;"><?php echo $tachycardia_bradycardia_2 ?></td>
<td style="text-align: center;"><?php echo $tachycardia_bradycardia_3 ?></td>
<td style="text-align: center;"><?php echo $tachycardia_bradycardia_4 ?></td>
</tr>
</table>
<br>
<!--
<h2 style="font-size: 12px; text-align: center;"><b>4. NEURO MUSCULAR: </b></h2>
<table border="1" width="100%" cellspacing="0">
<tr>
<td style="width: 80%; text-align: center;">Headache </td>
<td style="width: 50%; text-align: center;"><?php echo $nasal_discharge ?></td>
<td style="width: 50%; text-align: center;"><?php echo $nasal_discharge_1 ?></td>
<td style="width: 50%; text-align: center;"><?php echo $nasal_discharge_2 ?></td>
<td style="width: 50%; text-align: center;"><?php echo $nasal_discharge_3 ?></td>
<td style="width: 50%; text-align: center;"><?php echo $nasal_discharge_4 ?></td>
</tr>
<tr>
<td>Dizziness</td>
<td><?php echo $diziness ?></td>
<td><?php echo $diziness_1 ?></td>
<td><?php echo $diziness_2 ?></td>
<td><?php echo $diziness_3 ?></td>
<td><?php echo $diziness_4 ?></td>
</tr>
<tr>
<td>Irritability</td>
<td><?php echo $irritability ?></td>
<td><?php echo $irritability_1 ?></td>
<td><?php echo $irritability_2 ?></td>
<td><?php echo $irritability_3 ?></td>
<td><?php echo $irritability_4 ?></td>
</tr>
<tr>
<td>Twitching </td>
<td><?php echo $twitching ?></td>
<td><?php echo $twitching_1 ?></td>
<td><?php echo $twitching_2 ?></td>
<td><?php echo $twitching_3 ?></td>
<td><?php echo $twitching_4 ?></td>
</tr>
<tr>
<td>Tremors</td>
<td><?php echo $tremors ?></td>
<td><?php echo $tremors_1 ?></td>
<td><?php echo $tremors_2 ?></td>
<td><?php echo $tremors_3 ?></td>
<td><?php echo $tremors_4 ?></td>
</tr>
<tr>
<td>Convulsions </td>
<td><?php echo $convulsions ?></td>
<td><?php echo $convulsions_1 ?></td>
<td><?php echo $convulsions_2 ?></td>
<td><?php echo $convulsions_3 ?></td>
<td><?php echo $convulsions_4 ?></td>
</tr>
<tr>
<td>Paresthesia </td>
<td><?php echo $paraesthesia ?></td>
<td><?php echo $paraesthesia_1 ?></td>
<td><?php echo $paraesthesia_2 ?></td>
<td><?php echo $paraesthesia_3 ?></td>
<td><?php echo $paraesthesia_4 ?></td>
</tr>
<tr>
<td>Hallucination </td>
<td><?php echo $hallucinations ?></td>
<td><?php echo $hallucinations_1 ?></td>
<td><?php echo $hallucinations_2 ?></td>
<td><?php echo $hallucinations_3 ?></td>
<td><?php echo $hallucinations_4 ?></td>
</tr>
<tr>
<td>H/o Unconsciousness </td>
<td><?php echo $h_o_unconsciousness_1 ?></td>
<td><?php echo $h_o_unconsciousness_1_1 ?></td>
<td><?php echo $h_o_unconsciousness_2_3 ?></td>
<td><?php echo $h_o_unconsciousness_3_4 ?></td>
<td><?php echo $h_o_unconsciousness_4_5 ?></td>
</tr>
<tr>
<td>Superficial Reflexes </td>
<td><?php echo $superficial_reflexes ?></td>
<td><?php echo $superficial_reflexes_1 ?></td>
<td><?php echo $superficial_reflexes_2 ?></td>
<td><?php echo $superficial_reflexes_3 ?></td>
<td><?php echo $superficial_reflexes_4 ?></td>
</tr>
<tr>
<td>Deep reflexes </td>
<td><?php echo $deep_reflexes ?></td>
<td><?php echo $deep_reflexes_1 ?></td>
<td><?php echo $deep_reflexes_2 ?></td>
<td><?php echo $deep_reflexes_3 ?></td>
<td><?php echo $deep_reflexes_4 ?></td>
</tr>
<tr>
<td>Co-ordination </td>
<td><?php echo $co_ordination ?></td>
<td><?php echo $co_ordination_1 ?></td>
<td><?php echo $co_ordination_2 ?></td>
<td><?php echo $co_ordination_3 ?></td>
<td><?php echo $co_ordination_4 ?></td>
</tr>
</table>
<br> -->
<!--
<h2 style="font-size: 12px; text-align: center;"><b>5. EYE: </b></h2>
<table border="1" width="100%" cellspacing="0">
<tr>
<td style="width: 80%; text-align: center;">Pupil </td>
<td style="width: 50%; text-align: center;"><?php echo $pupil ?></td>
<td style="width: 50%; text-align: center;"><?php echo $pupil_1 ?></td>
<td style="width: 50%; text-align: center;"><?php echo $pupil_2 ?></td>
<td style="width: 50%; text-align: center;"><?php echo $pupil_3 ?></td>
<td style="width: 50%; text-align: center;"><?php echo $pupil_4 ?></td>
</tr>
<tr>
<td>Lachrymation</td>
<td><?php echo $lachrymation ?></td>
<td><?php echo $lachrymation_1 ?></td>
<td><?php echo $lachrymation_2 ?></td>
<td><?php echo $lachrymation_3 ?></td>
<td><?php echo $lachrymation_4 ?></td>
</tr>
<tr>
<td>Double vision </td>
<td><?php echo $double_vision ?></td>
<td><?php echo $double_vision_1 ?></td>
<td><?php echo $double_vision_2 ?></td>
<td><?php echo $double_vision_3 ?></td>
<td><?php echo $double_vision_4 ?></td>
</tr>
<tr>
<td>Blurred vision </td>
<td><?php echo $bullred_vision ?></td>
<td><?php echo $bullred_vision_1 ?></td>
<td><?php echo $bullred_vision_2 ?></td>
<td><?php echo $bullred_vision_3 ?></td>
<td><?php echo $bullred_vision_4 ?></td>
</tr>
</table>
<br>
<h2 style="font-size: 12px; text-align: center;"><b>6. PSYCHOLOGICAL</b></h2>
<table border="1" width="100%" cellspacing="0">
<tr>
<td style="width: 80%; text-align: center;">Temperament </td>
<td style="width: 50%; text-align: center;"><?php echo $temperament ?></td>
<td style="width: 50%; text-align: center;"><?php echo $temperament_1 ?></td>
<td style="width: 50%; text-align: center;"><?php echo $temperament_2 ?></td>
<td style="width: 50%; text-align: center;"><?php echo $temperament_3 ?></td>
<td style="width: 50%; text-align: center;"><?php echo $temperament_4 ?></td>
</tr>
<tr>
<td>Judgement</td>
<td><?php echo $judgement ?></td>
<td><?php echo $jaundice_1_4 ?></td>
<td><?php echo $judgement_2 ?></td>
<td><?php echo $judgement_3 ?></td>
<td><?php echo $judgement_4 ?></td>
</tr>
<tr>
<td>Nervousness</td>
<td><?php echo $nervousness ?></td>
<td><?php echo $nervousness1 ?></td>
<td><?php echo $nervousness2 ?></td>
<td><?php echo $nervousness3 ?></td>
<td><?php echo $nervousness4 ?></td>
</tr>
</table>
<br>
<h2 style="font-size: 12px; text-align: center;"><b>7. KIDNEY</b></h2>
<table border="1" width="100%" cellspacing="0">
<tr>
<td style="width: 80%; text-align: center;">Kidney Condition </td>
<td style="width: 50%; text-align: center;"><?php echo $kidney_condition ?></td>
<td style="width: 50%; text-align: center;"><?php echo $kidney_condition_1 ?></td>
<td style="width: 50%; text-align: center;"><?php echo $kidney_condition_2 ?></td>
<td style="width: 50%; text-align: center;"><?php echo $kidney_condition_3 ?></td>
<td style="width: 50%; text-align: center;"><?php echo $kidney_condition_4 ?></td>
</tr>
</table>
<br> -->
<h2 style="font-size: 12px;"><b>INVESTIGATIONS</b></h2>
<table border="1" width="100%" cellspacing="0">
<tr>
<td style="width: 15%; text-align: center;">&nbsp;</td>
<td style="width: 15%; text-align: center;" colspan="5">P.E.</td>
<td style="width: 15%; text-align: center;" colspan="5">I</td>
<td style="width: 15%; text-align: center;" colspan="5">II</td>
<td style="width: 15%; text-align: center;" colspan="5">III</td>
<td style="width: 15%; text-align: center;" colspan="5">IV</td>
</tr>
<tr>
<td style="width: 15%;">1) Blood Hb gm%</td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $hb_1 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $hb_1_1 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $hb_1_2 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $hb_1_3 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $hb_1_4 ?></td>
</tr>
<tr>
<td style="width: 15%;">2) Total RBC Count</td>
<td style="width: 15%; text-align: center; " colspan="5"><?php echo $total_rbc_count ?></td>
<td style="width: 15%; text-align: center; " colspan="5"><?php echo $total_rbc_count_1 ?></td>
<td style="width: 15%; text-align: center; " colspan="5"><?php echo $total_rbc_count_2 ?></td>
<td style="width: 15%; text-align: center; " colspan="5"><?php echo $total_rbc_count_3 ?></td>
<td style="width: 15%; text-align: center; " colspan="5"><?php echo $total_rbc_count_4 ?></td>
</tr>
<tr>
<td style="width: 15%;">3) TLC</td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $tlc_count ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $tlc_count_1 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $tlc_count_2 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $tlc_count_3 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $tlc_count_4 ?></td>
</tr>
<tr>
<td style="width: 15%;" rowspan="2">4) DLC</td>
<td style="width: 3%; text-align: center;">P</td>
<td style="width: 3%; text-align: center;">E</td>
<td style="width: 3%; text-align: center;">B</td>
<td style="width: 3%; text-align: center;">L</td>
<td style="width: 3%; text-align: center;">M</td>
<td style="width: 3%; text-align: center;">P</td>
<td style="width: 3%; text-align: center;">E</td>
<td style="width: 3%; text-align: center;">B</td>
<td style="width: 3%; text-align: center;">L</td>
<td style="width: 3%; text-align: center;">M</td>
<td style="width: 3%; text-align: center;">P</td>
<td style="width: 3%; text-align: center;">E</td>
<td style="width: 3%; text-align: center;">B</td>
<td style="width: 3%; text-align: center;">L</td>
<td style="width: 3%; text-align: center;">M</td>
<td style="width: 3%; text-align: center;">P</td>
<td style="width: 3%; text-align: center;">E</td>
<td style="width: 3%; text-align: center;">B</td>
<td style="width: 3%; text-align: center;">L</td>
<td style="width: 3%; text-align: center;">M</td>
<td style="width: 3%; text-align: center;">P</td>
<td style="width: 3%; text-align: center;">E</td>
<td style="width: 3%; text-align: center;">B</td>
<td style="width: 3%; text-align: center;">L</td>
<td style="width: 3%; text-align: center;">M</td>
</tr>
<tr>
<td style="width: 3%; text-align: center;"><?php echo $lymphocyte ?></td>
<td style="width: 3%; text-align: center;"><?php echo $basophils_5 ?></td>
<td style="width: 3%; text-align: center;"><?php echo $eosinophil_5 ?></td>
<td style="width: 3%; text-align: center;"><?php echo $polymorphs_2 ?></td>
<td style="width: 3%; text-align: center;"><?php echo $monocyte ?></td>
<td style="width: 3%; text-align: center;"><?php echo $lymphocyte_1 ?></td>
<td style="width: 3%; text-align: center;"><?php echo $basophils_5_1 ?></td>
<td style="width: 3%; text-align: center;"><?php echo $eosinophil_5_1 ?></td>
<td style="width: 3%; text-align: center;"><?php echo $polymorphs_2_1 ?></td>
<td style="width: 3%; text-align: center;"><?php echo $monocyte_1 ?></td>
<td style="width: 3%; text-align: center;"><?php echo $lymphocyte_2 ?></td>
<td style="width: 3%; text-align: center;"><?php echo $basophils_5_2 ?></td>
<td style="width: 3%; text-align: center;"><?php echo $eosinophil_5_2 ?></td>
<td style="width: 3%; text-align: center;"><?php echo $polymorphs_2_2 ?></td>
<td style="width: 3%; text-align: center;"><?php echo $monocyte_2 ?></td>
<td style="width: 3%; text-align: center;"><?php echo $lymphocyte_3 ?></td>
<td style="width: 3%; text-align: center;"><?php echo $basophils_5_3 ?></td>
<td style="width: 3%; text-align: center;"><?php echo $eosinophil_5_3 ?></td>
<td style="width: 3%; text-align: center;"><?php echo $polymorphs_2_3 ?></td>
<td style="width: 3%; text-align: center;"><?php echo $monocyte_3 ?></td>
<td style="width: 3%; text-align: center;"><?php echo $lymphocyte_4 ?></td>
<td style="width: 3%; text-align: center;"><?php echo $basophils_5_4 ?></td>
<td style="width: 3%; text-align: center;"><?php echo $eosinophil_5_4 ?></td>
<td style="width: 3%; text-align: center;"><?php echo $polymorphs_2_4 ?></td>
<td style="width: 3%; text-align: center;"><?php echo $monocyte_4 ?></td>
</tr>
<tr>
<td style="width: 15%;">5) Platelet Count</td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $platelet_count ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $platelet_count_1 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $platelet_count_2 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $platelet_count_3 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $platelet_count_4 ?></td>
</tr>
<tr>
<td style="width: 15%;">6) Reticulocyte Count </td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $reticulocyte_count ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $reticulocyte_count_1 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $reticulocyte_count_2 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $reticulocyte_count_3 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $reticulocyte_count_41 ?></td>
</tr>
<tr>
<td style="width: 15%;">7) ESR</td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $esr_3 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $esr_3_1 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $esr_3_2 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $esr_3_3 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $esr_3_41 ?></td>
</tr>
<tr>
<td style="width: 15%;">8) Serum Bilirubin T/D </td>
<td style="width: 8%; text-align: center;" colspan="3">T</td>
<td style="width: 8%; text-align: center;" colspan="2">D</td>
<td style="width: 8%; text-align: center;" colspan="3">T</td>
<td style="width: 8%; text-align: center;" colspan="2">D</td>
<td style="width: 8%; text-align: center;" colspan="3">T</td>
<td style="width: 8%; text-align: center;" colspan="2">D</td>
<td style="width: 8%; text-align: center;" colspan="3">T</td>
<td style="width: 8%; text-align: center;" colspan="2">D</td>
<td style="width: 8%; text-align: center;" colspan="3">T</td>
<td style="width: 8%; text-align: center;" colspan="2">D</td>
</tr>
<tr>
<td style="width: 15%; text-align: center;"></td>
<td style="width: 8%; padding: 3px; text-align: center;" colspan="3"><?php echo $serum_bilirubin_total ?></td>
<td style="width: 8%; padding: 3px; text-align: center;" colspan="2"><?php echo $serum_bilirubin_direct ?></td>
<td style="width: 8%; padding: 3px; text-align: center;" colspan="3"><?php echo $serum_bilirubin_total_1 ?></td>
<td style="width: 8%; padding: 3px; text-align: center;" colspan="2"><?php echo $serum_bilirubin_direct_1 ?></td>
<td style="width: 8%; padding: 3px; text-align: center;" colspan="3"><?php echo $serum_bilirubin_total_2 ?></td>
<td style="width: 8%; padding: 3px; text-align: center;" colspan="2"><?php echo $serum_bilirubin_direct_2 ?></td>
<td style="width: 8%; padding: 3px; text-align: center;" colspan="3"><?php echo $serum_bilirubin_total_3 ?></td>
<td style="width: 8%; padding: 3px; text-align: center;" colspan="2"><?php echo $serum_bilirubin_direct_3 ?></td>
<td style="width: 8%; padding: 3px; text-align: center;" colspan="3"><?php echo $serum_bilirubin_total_4 ?></td>
<td style="width: 8%; padding: 3px; text-align: center;" colspan="2"><?php echo $serum_bilirubin_direct_4 ?></td>
</tr>
<tr>
<td style="width: 15%;">9) Serum Alk Phosp</td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $serum_creatinine_1 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $serum_creatinine_1_1 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $serum_creatinine_1_2 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $serum_creatinine_1_3 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $serum_creatinine_1_4 ?></td>
</tr>
<tr>
<td style="width: 15%;">10) S.G.O.T. </td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $sgot_1 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $sgot_1_1 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $sgot_1_2 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $sgot_1_3 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $sgot_1_41 ?></td>
</tr>
<tr>
<td style="width: 15%;">11) S.G.P.T. </td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $sgpt_1 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $sgpt_1_1 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $sgpt_1_2 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $sgpt_1_3 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $sgpt_1_4 ?></td>
</tr>
<tr>
<td style="width: 15%;">12) Cholesterol </td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $cholesterol ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $cholesterol_1 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $cholesterol_2 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $cholesterol_3 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $cholesterol_4 ?></td>
</tr>
<tr>
<td style="width: 15%;">13) Total Protein </td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $total_protein ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $total_protein_1 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $total_protein_2 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $total_protein_3 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $total_protein_4 ?></td>
</tr>
<tr>
<td style="width: 15%;">14) Serum Albumin </td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $serum_albumin ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $serum_albumin_1 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $serum_albumin_2 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $serum_albumin_3 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $serum_albumin_4 ?></td>
</tr>
<tr>
<td style="width: 15%;">15) Blood Urea </td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $blood_urea ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $blood_urea_1 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $blood_urea_2 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $blood_urea_3 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $blood_urea_4 ?></td>
</tr>
<tr>
<td style="width: 15%; ">15) Serum Creatinine </td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $serum_creatinine_1 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $serum_creatinine_1_1 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $serum_creatinine_1_2 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $serum_creatinine_1_3 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $serum_creatinine_1_4 ?></td>
</tr>
<tr>
<td style="width: 15%;">17) Blood Sugar </td>
<td style="width: 30px; text-align: center;" colspan="2">F</td>
<td style="width: 30px; text-align: center;" colspan="2">PL</td>
<td style="width: 30px; text-align: center;" colspan="1">R</td>
<td style="width: 30px; text-align: center;" colspan="2">F</td>
<td style="width: 30px; text-align: center;" colspan="2">PL</td>
<td style="width: 30px; text-align: center;" colspan="1">R</td>
<td style="width: 30px; text-align: center;" colspan="2">F</td>
<td style="width: 30px; text-align: center;" colspan="2">PL</td>
<td style="width: 30px; text-align: center;" colspan="1">R</td>
<td style="width: 30px; text-align: center;" colspan="2">F</td>
<td style="width: 30px; text-align: center;" colspan="2">PL</td>
<td style="width: 30px; text-align: center;" colspan="1">R</td>
<td style="width: 30px; text-align: center;" colspan="2">F</td>
<td style="width: 30px; text-align: center;" colspan="2">PL</td>
<td style="width: 30px; text-align: center;" colspan="1">R</td>
</tr>
<tr>
<td style="width: 15%; text-align: center;"></td>
<td style="width: 5%; padding: 3px; text-align: center;" colspan="2"><?php echo $fasting_2 ?></td>
<td style="width: 5%; padding: 3px; text-align: center;" colspan="2"><?php echo $post_prandial_2 ?></td>
<td style="width: 5%; padding: 3px; text-align: center;" colspan="1"><?php echo $rbs_2 ?></td>
<td style="width: 5%; padding: 3px; text-align: center;" colspan="2"><?php echo $fasting_2_1 ?></td>
<td style="width: 5%; padding: 3px; text-align: center;" colspan="2"><?php echo $post_prandial_2_1 ?></td>
<td style="width: 5%; padding: 3px; text-align: center;" colspan="1"><?php echo $rbs_2_1 ?></td>
<td style="width: 5%; padding: 3px; text-align: center;" colspan="2"><?php echo $fasting_2_2 ?></td>
<td style="width: 5%; padding: 3px; text-align: center;" colspan="2"><?php echo $post_prandial_2_2 ?></td>
<td style="width: 5%; padding: 3px; text-align: center;" colspan="1"><?php echo $rbs_2_2 ?></td>
<td style="width: 5%; padding: 3px; text-align: center;" colspan="2"><?php echo $fasting_2_3 ?></td>
<td style="width: 5%; padding: 3px; text-align: center;" colspan="2"><?php echo $post_prandial_2_3 ?></td>
<td style="width: 5%; padding: 3px; text-align: center;" colspan="1"><?php echo $rbs_2_3 ?></td>
<td style="width: 5%; padding: 3px; text-align: center;" colspan="2"><?php echo $fasting_2_4 ?></td>
<td style="width: 5%; padding: 3px; text-align: center;" colspan="2"><?php echo $post_prandial_2_4 ?></td>
<td style="width: 5%; padding: 3px; text-align: center;" colspan="1"><?php echo $rbs_2_4 ?></td>
</tr>
<tr>
<td style="width: 15%;">18) HbA1C </td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $hba1c_1 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $hba1c_1_1 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $hba1c_1_2 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $hba1c_1_3 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $hba1c_1_4 ?></td>
</tr>
<tr>
<td style="width: 15%;">19) Serum Cholinesterase </td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $serum_cholinesterase ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $serum_cholinesterase_1 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $serum_cholinesterase_2 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $serum_cholinesterase_3 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $serum_cholinesterase_4 ?></td>
</tr>
<!-- <tr>
<td style="width: 100; text-align: center;" colspan="26">15) Blood residue estimation (organochlorine once In year) </td>
</tr> -->
<tr>
<td style="width: 15%;"><b>Urine Examination </b></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php ?></td>
<td style="width: 15%; text-align: center;" colspan="5"></td>
<td style="width: 15%; text-align: center;" colspan="5"></td>
<td style="width: 15%; text-align: center;" colspan="5"></td>
<td style="width: 15%; text-align: center;" colspan="5"></td>
</tr>
<tr>
<td style="width: 15%;">&nbsp; a) Routine </td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $routine ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $routine_1 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $routine_2 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $routine_3 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $routine_4 ?></td>
</tr>
<tr>
<td style="width: 15%;">&nbsp; b) Microscopic </td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $microscopic ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $microscopic_1 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $microscopic_2 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $microscopic_3 ?></td>
<td style="width: 15%; text-align: center;" colspan="5"><?php echo $microscopic_4 ?></td>
</tr>
<!--
<tr>
<td style="width: 100%; text-align: center;" colspan="26">22) X -ray chest (PA View) Once in a year : <?php echo $x_ray_chest_pa_view_once_in_year ?> </td>
</tr>
<tr>
<td style="width: 100%; text-align: center;" colspan="26">23) USG Abdomen (Once in a yoar): <?php echo $usg_abdomen ?> </td>
</tr> -->
<!--
<tr>
<td style="width: 100%; text-align: center;" colspan="26">24) 1)Serum cholinesterase level should be meAsured in Six monthly intervals in case of organophosphorus, carbamate group of insecticides. <br>
2) General remarks of the Doctor in light of above examination, Serum cholinesterase <br>
3) In organochlorine group of insecticides the blood residue estimation should be done once a year.
</td>
</tr> -->
<!-- <tr>
<td style="width: 100%; padding: 30px; text-align: center;" colspan="26">III: DIAGNOSIS
</td>
</tr> -->
<!--
<tr>
<td style="width: 20%; text-align: center;">IV: Advice given to : </td>
<td style="width: 20%; text-align: center;" colspan="5">P.E.</td>
<td style="width: 20%; text-align: center;" colspan="5">I</td>
<td style="width: 20%; text-align: center;" colspan="5">II</td>
<td style="width: 20%; text-align: center;" colspan="5">III</td>
<td style="width: 20%; text-align: center;" colspan="5">IV</td>
</tr>
<tr>
<td style="width: 20%; text-align: center;">1. The employee </td>
<td style="width: 20%; text-align: center;" colspan="5"><?php echo $advice_given_to_employee ?></td>
<td style="width: 20%; text-align: center;" colspan="5"><?php echo $advice_given_to_employee_1 ?></td>
<td style="width: 20%; text-align: center;" colspan="5"><?php echo $advice_given_to_employee_2 ?></td>
<td style="width: 20%; text-align: center;" colspan="5"><?php echo $advice_given_to_employee_3 ?></td>
<td style="width: 20%; text-align: center;" colspan="5"><?php echo $advice_given_to_employee_4 ?></td>
</tr>
<tr>
<td style="width: 20%; text-align: center;">2. The employer </td>
<td style="width: 20%; text-align: center;" colspan="5"><?php echo $advice_given_to_employer ?></td>
<td style="width: 20%; text-align: center;" colspan="5"><?php echo $advice_given_to_employer_1 ?></td>
<td style="width: 20%; text-align: center;" colspan="5"><?php echo $advice_given_to_employer_2 ?></td>
<td style="width: 20%; text-align: center;" colspan="5"><?php echo $advice_given_to_employer_3 ?></td>
<td style="width: 20%; text-align: center;" colspan="5"><?php echo $advice_given_to_employer_4 ?></td>
</tr>
<tr>
<td style="width: 20%; text-align: center;"> <b> Signature of the Doctor with Date and seal </b></td>
<td style="width: 20%; text-align: center;" colspan="5"><br><br><br></td>
<td style="width: 20%; text-align: center;" colspan="5"><br><br><br></td>
<td style="width: 20%; text-align: center;" colspan="5"><br><br><br></td>
<td style="width: 20%; text-align: center;" colspan="5"><br><br><br></td>
<td style="width: 20%; text-align: center;" colspan="5"><br><br><br></td>
</tr> -->
<!--
<tr>
<td style="width: 100%; text-align: center;" colspan="26">V: Acknowledgement to be given by </td>
</tr> -->
<!-- <?php
$sql_employee_key11 = "SELECT * FROM checkup_form_key_value WHERE checkup_form_id ='" . $checkup_id . "'";
error_log("get_data_key:" . $sql_employee_key11);
$res_data_key11 = mysqli_query($conn, $sql_employee_key11);
while ($rows_exa_key11 = mysqli_fetch_array($res_data_key11)) {
if ($rows_exa_key11['checkup_form_key'] == 'acknowedgement_to_be_given_by_employee') {
$acknowedgement_to_be_given_by_employee = $rows_exa_key11['checkup_form_value'];
}
if ($rows_exa_key11['checkup_form_key'] == 'acknowedgement_to_be_given_by_employer') {
$acknowedgement_to_be_given_by_employer = $rows_exa_key11['checkup_form_value'];
}
if ($rows_exa_key11['checkup_form_key'] == 'acknowedgement_to_be_given_by_licensing_officer') {
$acknowedgement_to_be_given_by_licensing_officer = $rows_exa_key11['checkup_form_value'];
}
if ($rows_exa_key11['checkup_form_key'] == 'action_taken_by_the_employer_on_doctors_advice') {
$action_taken_by_the_employer_on_doctors_advice = $rows_exa_key11['checkup_form_value'];
}
}
?> -->
<!-- <tr>
<td style="width: 100px; text-align: center;" colspan="26">1. The employee: <?php echo $acknowedgement_to_be_given_by_employee ?></td>
</tr>
<tr>
<td style="width: 100px; text-align: center;" colspan="26">2. The employer <?php echo $acknowedgement_to_be_given_by_employer ?></td>
</tr>
<tr>
<td style="width: 100px; text-align: center;" colspan="26">3. The Licensing Officer <?php echo $acknowedgement_to_be_given_by_licensing_officer ?></td>
</tr> -->
</table>