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

792 lines
30 KiB
PHP

<html>
<head>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
<div id="opd_form_div" style="display:none">
<form id="opd_form" name="opd_form">
<?php
//include autoloader;
include('includes/config/config.php');
include_once("includes/functions.php");
$checkup_id = $_REQUEST['checkup_id'];
$sql_employee_appointment = "SELECT * FROM checkup_form WHERE checkup_id ='" . $checkup_id . "'";
error_log("get_data:" . $sql_employee_appointment);
$res_emp_appoint = mysqli_query($conn, $sql_employee_appointment);
$rows_emp_appoint = mysqli_fetch_array($res_emp_appoint);
@extract($rows_emp_appoint);
error_log($emp_id);
$sr_no = $ticket_no;
$date_a = $checkup_date;
$appointment_date = date("d-m-Y", strtotime($date_a));
$patient_name = getFieldFromTable('patient_name', 'patient_master', 'id', $emp_id);
$gender = getFieldFromTable('gender', 'patient_master', 'id', $emp_id);
$blood_group = getFieldFromTable('blood_group', 'patient_master', 'id', $emp_id);
$dept_id = getFieldFromTable('dept_id', 'patient_master', 'id', $emp_id);
$designation_id = getFieldFromTable('designation_id', 'patient_master', 'id', $emp_id);
$dept = getFieldFromTable('dept_name', 'department', 'dept_id', $dept_id);
$designation = getFieldFromTable('designation_name', 'designation', 'designation_id', $designation_id);
$address = $village_name . "," . $district . "," . $state . "," . $pin_code . "";
$dob = getFieldFromTable('dob', 'patient_master', 'id', $rows_emp_appoint['emp_id']);
$date_of_birth = date("d-m-Y", strtotime($dob));
$doj = getFieldFromTable('doj', 'patient_master', 'id', $rows_emp_appoint['emp_id']);
$date_of_joining = date("d-m-Y", strtotime($doj));
$c = date('Y');
$y = date('Y', strtotime($dob));
$age = $c - $y;
$sql_employee_key = "SELECT * FROM checkup_form_key_value WHERE checkup_form_id ='" . $checkup_id . "'";
error_log("get_data_key:" . $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'] == 'smoking') {
$smoking = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
}
if ($rows_exa_key['checkup_form_key'] == 'marital_status') {
$marital_status = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
}
if ($rows_exa_key['checkup_form_key'] == 'alcohol_2') {
$alcohol_2 = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
}
if ($rows_exa_key['checkup_form_key'] == 'h_o_major_illness') {
$h_o_major_illness = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
}
if ($rows_exa_key['checkup_form_key'] == 'h_o_any_accident') {
$h_o_any_accident = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
}
if ($rows_exa_key['checkup_form_key'] == 'h_o_any_major_operation') {
$h_o_any_major_operation = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
}
if ($rows_exa_key['checkup_form_key'] == 'diabetes') {
$diabetes = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
}
if ($rows_exa_key['checkup_form_key'] == 'hypertension') {
$hypertension = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
}
if ($rows_exa_key['checkup_form_key'] == 'bronchial_asthma') {
$bronchial_asthma = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
}
if ($rows_exa_key['checkup_form_key'] == 'heart_disease') {
$heart_disease = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
}
if ($rows_exa_key['checkup_form_key'] == 'tuberculosis') {
$tuberculosis = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
}
if ($rows_exa_key['checkup_form_key'] == 'tobacco_chewing') {
$tobacco_chewing = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
}
if ($rows_exa_key['checkup_form_key'] == 'others') {
$others = $rows_exa_key['checkup_form_value'];
}
if ($rows_exa_key['checkup_form_key'] == 'if_answeris_yes_then_give_remarks_1') {
$if_answeris_yes_then_give_remarks_1 = $rows_exa_key['checkup_form_value'];
}
if ($rows_exa_key['checkup_form_key'] == 'if_answer_is_yes_then_give_remarks_3') {
$if_answer_is_yes_then_give_remarks_3 = $rows_exa_key['checkup_form_value'];
}
if ($rows_exa_key['checkup_form_key'] == 'height_1') {
$height_1 = $rows_exa_key['checkup_form_value'];
}
if ($rows_exa_key['checkup_form_key'] == 'if_answer_is_yes_then_give_remarks_8') {
$if_answer_is_yes_then_give_remarks_8 = $rows_exa_key['checkup_form_value'];
}
if ($rows_exa_key['checkup_form_key'] == 'weight_2') {
$weight_2 = $rows_exa_key['checkup_form_value'];
}
if ($rows_exa_key['checkup_form_key'] == 'ent') {
$ent = $rows_exa_key['checkup_form_value'];
}
if ($rows_exa_key['checkup_form_key'] == 'tongue') {
$tongue = $rows_exa_key['checkup_form_value'];
}
if ($rows_exa_key['checkup_form_key'] == 'conjuctiva') {
$conjuctiva = $rows_exa_key['checkup_form_value'];
}
if ($rows_exa_key['checkup_form_key'] == 'teeth') {
$teeth = $rows_exa_key['checkup_form_value'];
}
if ($rows_exa_key['checkup_form_key'] == 'nails') {
$nails = $rows_exa_key['checkup_form_value'];
}
if ($rows_exa_key['checkup_form_key'] == 'skin') {
$skin = $rows_exa_key['checkup_form_value'];
}
if ($rows_exa_key['checkup_form_key'] == 'thyroid_gland') {
$thyroid_gland = $rows_exa_key['checkup_form_value'];
}
if ($rows_exa_key['checkup_form_key'] == 'deformities') {
$deformities = $rows_exa_key['checkup_form_value'];
}
if ($rows_exa_key['checkup_form_key'] == 'lymph_nodes') {
$lymph_nodes = $rows_exa_key['checkup_form_value'];
}
if ($rows_exa_key['checkup_form_key'] == 'distant_rt_uncorrected') {
$distant_rt_uncorrected = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
}
if ($rows_exa_key['checkup_form_key'] == 'distant_lt_uncorrected') {
$distant_lt_uncorrected = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
}
if ($rows_exa_key['checkup_form_key'] == 'near_lt_uncorrected') {
$near_lt_uncorrected = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
}
if ($rows_exa_key['checkup_form_key'] == 'near_rt_uncorrected') {
$near_rt_uncorrected = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
}
if ($rows_exa_key['checkup_form_key'] == 'distant_rt_corrected') {
$distant_rt_corrected = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
}
if ($rows_exa_key['checkup_form_key'] == 'distant_lt_corrected') {
$distant_lt_corrected = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
}
if ($rows_exa_key['checkup_form_key'] == 'near_rt_corrected') {
$near_rt_corrected = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
}
if ($rows_exa_key['checkup_form_key'] == 'near_lt_corrected') {
$near_lt_corrected = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
}
if ($rows_exa_key['checkup_form_key'] == 'hernia_1') {
$hernia_1 = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
}
if ($rows_exa_key['checkup_form_key'] == 'hydrocele_1') {
$hydrocele_1 = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
}
if ($rows_exa_key['checkup_form_key'] == 'varicocele') {
$varicocele = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
}
if ($rows_exa_key['checkup_form_key'] == 'pulse') {
$pulse = $rows_exa_key['checkup_form_value'];
}
if ($rows_exa_key['checkup_form_key'] == 'history_of_illness') {
$history_of_illness = $rows_exa_key['checkup_form_value'];
}
if ($rows_exa_key['checkup_form_key'] == 'heart_sound_1') {
$heart_sound_1 = $rows_exa_key['checkup_form_value'];
}
if ($rows_exa_key['checkup_form_key'] == 'blood_pressure') {
$blood_pressure = $rows_exa_key['checkup_form_value'];
}
if ($rows_exa_key['checkup_form_key'] == 'murmurs') {
$murmurs = $rows_exa_key['checkup_form_value'];
}
if ($rows_exa_key['checkup_form_key'] == 'shape_of_chest') {
$shape_of_chest = $rows_exa_key['checkup_form_value'];
}
if ($rows_exa_key['checkup_form_key'] == 'chest_of_movements') {
$chest_of_movements = $rows_exa_key['checkup_form_value'];
}
if ($rows_exa_key['checkup_form_key'] == 'trachea') {
$trachea = $rows_exa_key['checkup_form_value'];
}
if ($rows_exa_key['checkup_form_key'] == 'breath_sounds') {
$breath_sounds = $rows_exa_key['checkup_form_value'];
}
if ($rows_exa_key['checkup_form_key'] == 'abnormal_sounds') {
$abnormal_sounds =getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
}
if ($rows_exa_key['checkup_form_key'] == 'liver') {
$liver = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
}
if ($rows_exa_key['checkup_form_key'] == 'spleen') {
$spleen = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
}
if ($rows_exa_key['checkup_form_key'] == 'any_lumps') {
$any_lumps = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
}
if ($rows_exa_key['checkup_form_key'] == 'ascitis') {
$ascitis = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
}
if ($rows_exa_key['checkup_form_key'] == 'higher_functions') {
$higher_functions = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
}
if ($rows_exa_key['checkup_form_key'] == 'bult') {
$bult = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
}
if ($rows_exa_key['checkup_form_key'] == 'cranial_nerves') {
$cranial_nerves = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
}
if ($rows_exa_key['checkup_form_key'] == 'sensory_system') {
$sensory_system = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
}
if ($rows_exa_key['checkup_form_key'] == 'motor_functions') {
$motor_functions = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
}
if ($rows_exa_key['checkup_form_key'] == 'reflexes') {
$reflexes = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
}
if ($rows_exa_key['checkup_form_key'] == 'posture_3') {
$posture_3 = $rows_exa_key['checkup_form_value'];
}
if ($rows_exa_key['checkup_form_key'] == 'abnormality_remarks_2') {
$abnormality_remarks_2 = $rows_exa_key['checkup_form_value'];
}
if ($rows_exa_key['checkup_form_key'] == 'gait') {
$gait = $rows_exa_key['checkup_form_value'];
}
if ($rows_exa_key['checkup_form_key'] == 'spine') {
$spine = $rows_exa_key['checkup_form_value'];
}
}
?>
<style>
div b {
text-transform: capitalize;
}
.tbl1 {
width: 100%;
}
th {
background-color: #e1e1e1;
font-size: 12px;
font-style: bold;
vertical-align: top;
}
td {
text-align: left;
font-size: 12px;
vertical-align: top;
}
h1 {
text-align: left;
font-size: 12px;
vertical-align: top;
}
/* .tbl_tbl {
border: 1px solid black;
border-collapse: collapse;
} */
</style>
</head>
<?php
$queryc = "select * from company_profile ";
$resultc = mysqli_query($conn, $queryc);
$row_company = mysqli_fetch_array($resultc);
@extract($row_company);
?>
<table width="100%" cellspacing="0">
<tr>
<td width="20%">
<?php if (isset($row_company['company_logo']) && $row_company['company_logo'] != null) { ?>
<img src="data:<?php echo $row_company['image_type'] ?>;base64,<?php echo base64_encode($row_company['company_logo']) ?>" style="width: 100px; height: 60px; margin: 0px; padding: 0px;">
<?php } ?>
</td>
<td width="60%" align="center">
<div style="margin-left: 20px; margin-top: 5px; line-height: 1;">
<center style="font-size: 18px ; text-transform: capitalize;"><b>
<?php echo ($row_company['company_name']) ?>
<br>
<br> <span style="font-size: 12px;"> <?php echo ($row_company['address']) ?>
<br>MEDICAL CENTRE</span>
</b>
</center>
</div>
</td>
<!-- <td width="20%" align="right">
D/PHA/F-16
<br>Eff.Dt.01/04/97
<br>Rev.No.00
</td> -->
</tr>
<tr rowspan="2">
<td colspan="1"></td>
<td colspan="2"></td>
</tr>
<tr>
<td colspan="1"></td>
<td colspan="2"></td>
</tr>
<tr>
<td colspan="1"></td>
<td colspan="2"></td>
</tr>
</table>
<h5>
<center><b>PRE - EMPLOYMENT MEDICAL EXAMINATION FORM FOR TEMPORARY CANDIDATES.</b></center>
</h5>
<table style="width: 100%;">
<tr>
<td style="width: 80%;"></td>
<td style="width: 30%; align-items: end;">Sr No. <u><?php echo $ticket_no ?></u></td>
</tr>
<tr>
<td style="width: 80%;"></td>
<td style="width: 30%; align-items: end;">Date: <u><?php echo $appointment_date ?></u></td>
</tr>
</table>
<br>
<table style="width: 100%;">
<tr>
<td style="width: 80%;">NAME: <u><?php echo $patient_name ?></u> </td>
<td style="width: 10%;">Age: <u><?php echo $age ?></u> </td>
<td style="width: 10%;">Sex: <u><?php if ($gender == 'M') {
echo 'Male';
} else if ($gender == 'F') {
echo 'Female';
} ?></u></td>
</tr>
</table>
<br>
<table style="width: 100%;">
<tr>
<td style="width: 100%;"><b>Present History of Illness: </b> <?php echo $history_of_illness ?></td>
</tr>
</table>
<table style="width: 100%;">
<tr>
<td style="width: 20%;"><b>Present History:</b></td>
<td style="width: 40%;">Smoking: <u> <?php echo $smoking ?></u></td>
<td style="width: 40%;">Marital Status: <u> <?php echo $marital_status ?></u></td>
</tr>
<tr>
<td style="width: 20%;"></td>
<td style="width: 40%;">Alcohol: <u> <?php echo $alcohol_2 ?></u></td>
<td style="width: 40%;"></td>
</tr>
<tr>
<td style="width: 20%;"></td>
<td style="width: 40%;">Tobacco Chewing: <u> <?php echo $tobacco_chewing ?></u></td>
<td style="width: 40%;"></td>
</tr>
<tr>
<td style="width: 20%;"></td>
<td style="width: 40%;">Others <u>:<?php echo $others ?></u></td>
<td style="width: 40%;"></td>
</tr>
<tr>
<td style="width: 20%;"></td>
<td style="width: 40%;">Remarks <u>:<?php echo $if_answer_is_yes_then_give_remarks_3 ?></u></td>
<td style="width: 40%;"></td>
</tr>
</table>
<table style="width: 100%;">
<tr>
<td style="width: 20%;"><b>Past History:</b></td>
<td style="width: 80%;">H/o. Major illness: <u> <?php echo $h_o_major_illness ?></u></td>
</tr>
<tr>
<td style="width: 20%;"></td>
<td style="width: 80%;">H/o. Any Accident: <u> <?php echo $h_o_any_accident ?></u></td>
</tr>
<tr>
<td style="width: 20%;"></td>
<td style="width: 80%;">H/o. Any Major Operation: <u> <?php echo $h_o_any_major_operation ?></u></td>
</tr>
<tr>
<td style="width: 20%;"></td>
<td style="width: 80%;"> Remarks <u> <?php echo $if_answeris_yes_then_give_remarks_1 ?></u></td>
</tr>
</table>
<br>
<table style="width: 100%;">
<tr>
<td style="width: 20%;"><b>Family History: </b></td>
<td style="width: 80%;">Has anyone in the family suffered / suffering from</td>
</tr>
</table>
<table style="align-self: center;" border="1" width="50%" cellspacing="0">
<tr>
<td style="width:60;">Diseases</td>
<td style="width:20;">Yes</td>
<td style="width:20;">No</td>
</tr>
<tr>
<td style="width:60;">Diabetes</td>
<td style="width:20;"><?php if ($diabetes == 'Yes') { ?> <input checked type="checkbox" name="" id=""> <?php } ?></td>
<td style="width:20;"><?php if ($diabetes == 'No') { ?> <input checked type="checkbox" name="" id=""> <?php } ?> </td>
</tr>
<tr>
<td style="width:60;">Hypertension</td>
<td style="width:20;"><?php if ($hypertension == 'Yes') { ?> <input checked type="checkbox" name="" id=""> <?php } ?></td>
<td style="width:20;"><?php if ($hypertension == 'No') { ?> <input checked type="checkbox" name="" id=""> <?php } ?> </td>
</tr>
<tr>
<td style="width:60;">Bronchial Asthma</td>
<td style="width:20;"><?php if ($bronchial_asthma == 'Yes') { ?> <input checked type="checkbox" name="" id=""> <?php } ?></td>
<td style="width:20;"><?php if ($bronchial_asthma == 'No') { ?> <input checked type="checkbox" name="" id=""> <?php } ?> </td>
</tr>
<tr>
<td style="width:60;">Heart Diseases</td>
<td style="width:20;"><?php if ($heart_disease == 'Yes') { ?> <input checked type="checkbox" name="" id=""> <?php } ?></td>
<td style="width:20;"><?php if ($heart_disease == 'No') { ?> <input checked type="checkbox" name="" id=""> <?php } ?> </td>
</tr>
<tr>
<td style="width:60;">Tuberculosis</td>
<td style="width:20;"><?php if ($tuberculosis == 'Yes') { ?> <input checked type="checkbox" name="" id=""> <?php } ?></td>
<td style="width:20;"><?php if ($tuberculosis == 'No') { ?> <input checked type="checkbox" name="" id=""> <?php } ?> </td>
</tr>
<tr>
<td colspan="3" style="width:60;">Remarks : <?php echo $if_answer_is_yes_then_give_remarks_8?></td>
</tr>
</table>
<h2 style="font-size: 12px;">GENERAL EXAMINATION</h2>
<table style="width: 100%;">
<tr>
<td style="width: 50%;">1. Height : <u><?php echo $height_1 ?> cms</u> </td>
<td style="width: 50%;">2. Weight : <u><?php echo $weight_2 ?> Kg</u></td>
</tr>
<tr>
<td style="width: 50%;">3. Built : <u><?php echo $bult ?></u></td>
<td style="width: 50%;">4. E.N.T. : <u><?php echo $ent ?></u></td>
</tr>
<tr>
<td style="width: 50%;">5. Teeth : <u><?php echo $teeth ?></u></td>
<td style="width: 50%;">6. Tongue : <u><?php echo $tongue ?></u></td>
</tr>
<tr>
<td style="width: 50%;">7. Nails : <u><?php echo $nails ?></u></td>
<td style="width: 50%;">8. Conjunctiva : <u><?php echo $conjuctiva ?></u></td>
</tr>
<tr>
<td style="width: 50%;">9. Skin : <u><?php echo $skin ?></u></td>
<td style="width: 50%;">10. Lymph Nodes : <u><?php echo $lymph_nodes ?></u></td>
</tr>
<tr>
<td style="width: 50%;">11. Thyroid Gland : <u><?php echo $thyroid_gland ?></u></td>
<td style="width: 50%;">12. Deformities : <u><?php echo $deformities ?></u></td>
</tr>
</table>
<table border="1" width="80%" cellspacing="0">
<tr>
<td style="width: 33px;" rowspan="2" colspan="1">Eyes</td>
<td style="width: 33px;" colspan="2">Distant</td>
<td style="width: 33px;" colspan="2">Near</td>
</tr>
<tr>
<td style="width: 16px;" colspan="1">R</td>
<td style="width: 16px;" colspan="1">L</td>
<td style="width: 16px;" colspan="1">R</td>
<td style="width: 16px;" colspan="1">L</td>
</tr>
<tr>
<td style="width: 33px;" colspan="1">Uncorrected</td>
<td style="width: 16px;" colspan="1"><?php echo $distant_rt_uncorrected ?></td>
<td style="width: 16px;" colspan="1"><?php echo $distant_lt_uncorrected ?></td>
<td style="width: 16px;" colspan="1"><?php echo $near_lt_uncorrected ?> </td>
<td style="width: 16px;" colspan="1"><?php echo $near_rt_uncorrected ?> </td>
</tr>
<tr>
<td style="width: 33px;" colspan="1">Corrected</td>
<td style="width: 16px;" colspan="1"><?php echo $distant_rt_corrected ?></td>
<td style="width: 16px;" colspan="1"><?php echo $distant_lt_corrected ?></td>
<td style="width: 16px;" colspan="1"><?php echo $near_lt_corrected ?> </td>
<td style="width: 16px;" colspan="1"><?php echo $near_rt_corrected ?> </td>
</tr>
</table>
<h2 style="font-size: 12px;">Genito Urinary System :</h2>
<table style="width: 100%;">
<tr>
<td style="width: 33%;">Hernia: <u> <?php echo $hernia_1 ?></u></td>
<td style="width: 33%;">Hydrocele: <u> <?php echo $hydrocele_1 ?></u></td>
<td style="width: 33%;">Vericocele: <u> <?php echo $varicocele ?></u></td>
</tr>
</table>
<br>
<h2 style="font-size: 12px;">SYSTEMIC EXAMINATION:</h2>
<table style="width: 100%;">
<tr>
<td style="width: 33%;">1. Cardio vascular system:</td>
<td style="width: 33%;">Pulse <u> <?php echo $pulse ?> / min.</td>
<td style="width: 33%;">Blood pressure: <u> <?php echo $blood_pressure ?> mm of Hg</td>
</tr>
<tr>
<td style="width: 33%;"></td>
<td style="width: 33%;">Heart sounds: <u> <?php echo $heart_sound_1 ?></u></td>
<td style="width: 33%;">Murmurs: <u> <?php echo $murmurs ?></u></td>
</tr>
</table>
<table border="1" width="100%" cellspacing="0">
<tr>
<td style="width: 25%; padding: 30px;"><b> <u>Respiratory System</u></b> <br> <b>Shape of Chest</b> <br> <b>Chest Movements</b> <br> <b>Trachea</b> <br><b> Breath Sounds</b> <br> <b>Abnormal Sounds</b> </td>
<td style="width: 25%; padding: 30px;"> &nbsp;<br><?php echo $shape_of_chest ?><br> <?php echo $chest_of_movements ?> <br> <?php echo $trachea ?> <br> <?php echo $breath_sounds ?> <br> <?php echo $abnormal_sounds ?></td>
<td style="width: 25%; padding: 30px;"><b> <u> Abdomen </u></b> <br> <b>Liver</b> <br> <b>Spleen</b> <br> <b>Ascites</b> <br><b>Any Lumps</b> </td>
<td style="width: 25%; padding: 30px;"> &nbsp;<br> <?php echo $liver ?><br> <?php echo $spleen ?><br> <?php echo $ascitis ?><br> <?php echo $any_lumps ?></td>
</tr>
<tr>
<td style="width: 25%; padding: 30px;"><b><u>Central Nervous System </u></b><br> <b>Higher Functions</b> <br><b>Cranial Nerves</b> <br> <b>Sensory System</b> <br> <b>Motor Functions</b> <br> <b>Reflexes</b> </td>
<td style="width: 25%; padding: 30px;"> &nbsp;<br><br> <?php echo $motor_functions ?> <br> <?php echo $cranial_nerves ?> <br> <?php echo $sensory_system ?> <br> <?php echo $motor_functions ?><br> <?php echo $reflexes ?></td>
<td style="width: 25%; padding: 30px;"><b><u>Locomotor System</u></b> <br> <b>Posture</b> <br> <b>Gait</b> <br> <b>Spine</b></td>
<td style="width: 25%; padding: 30px;"> &nbsp;<br> <?php echo $posture_3 ?> <br> <?php echo $gait ?> <br> <?php echo $spine ?> </td>
</tr>
<tr>
<td colspan="4">Remarks : <?php echo $abnormality_remarks_2?></td>
</tr>
</table>
<br>
<h2 style="font-size: 12px;">Remarks: Medically <?php echo $fit_unfit_status; ?></h2>
<br><br><br><br><br>
<?php
$query = "select e.emp_sign,e.image_type from employee_signature e left join checkup_form b on e.emp_id = b.doc_attend where b.checkup_id ='" . $checkup_id . "'";
// error_log("Signatures :" . $query);
$result1 = mysqli_query($conn, $query);
$sign_row = mysqli_fetch_array($result1);
extract($sign_row);
?>
<table style="width: 95%;">
<tr>
<td style="width: 80%;"></td>
<td style="width: 20%; align-items: end;"><img id='sign' style="text-align:center; width:150px; height:80px;" class="card-img-bottm" src="data:<?= $sign_row['image_type']; ?>;base64,<?= base64_encode($sign_row['emp_sign']) ?>"><br></td>
</tr>
</table>
<table style="width: 100%;">
<tr>
<td style="text-align: right;">FACTORY MEDICAL OFFICER</td>
</tr>
</table>
</form>
<form id="employeeDetailsFormPdf" action="" method="POST">
<input type="hidden" name="htmlText" id="htmlText" />
</form>
</div>
<script>
formSubmit();
function formSubmit() {
$("#htmlText").val($("#opd_form").html());
document.forms['employeeDetailsFormPdf'].action = "pdf_dynamic.php";
document.forms['employeeDetailsFormPdf'].method = "post";
document.forms['employeeDetailsFormPdf'].submit();
}
</script>