949 lines
31 KiB
PHP
949 lines
31 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'];
|
|
if ($appoint_id == '' || $appoint_id == null) {
|
|
$appoint_id = $_REQUEST['appointment_idpdf'];
|
|
}
|
|
error_reporting(E_ERROR | E_PARSE);
|
|
error_log("id:" . $appoint_id);
|
|
$unitMap = getKeyValueMap('unit_master', 'unit_id', 'unit_name');
|
|
|
|
$queryc = "select * from company_profile ";
|
|
|
|
//echo $query;
|
|
|
|
$resultc = mysqli_query($conn, $queryc);
|
|
|
|
$row_company = mysqli_fetch_array($resultc);
|
|
|
|
@extract($row_company);
|
|
|
|
$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);
|
|
|
|
$exa_date = date_format(date_create($checkup_date), "d-M-Y");
|
|
$exa_year = date_format(date_create($checkup_date), "Y");
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$doc_emp_id = getTableFieldValue('tbl_users', 'emp_id', 'user_id', $doc_user_id, '');
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$date = date('Y-m-d H:i:s');
|
|
|
|
$currentDate = date_format(date_create($date), "d-M-Y h:i:sa ");
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
?>
|
|
|
|
|
|
|
|
<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;
|
|
}
|
|
|
|
body {
|
|
border-radius: 25px;
|
|
border: 2px solid #000000;
|
|
|
|
width: 700px;
|
|
|
|
}
|
|
|
|
.page-break {
|
|
page-break-before: always;
|
|
/* or use page-break-after: always; */
|
|
}
|
|
|
|
.outer-border {
|
|
border: 2px solid black;
|
|
/* Set the border style, color, and width */
|
|
padding: 10px;
|
|
/* Optional: Add padding to the div */
|
|
}
|
|
|
|
/* label {
|
|
display: flex;
|
|
align-items: center;
|
|
margin-bottom: 5px;
|
|
}
|
|
|
|
input {
|
|
margin-right: 5px;
|
|
} */
|
|
|
|
/* .tbl_tbl {
|
|
border: 1px solid black;
|
|
border-collapse: collapse;
|
|
} */
|
|
</style>
|
|
|
|
|
|
|
|
</head>
|
|
|
|
<body>
|
|
|
|
<?php
|
|
$queryc = "select * from company_profile ";
|
|
|
|
$resultc = mysqli_query($conn, $queryc);
|
|
|
|
$row_company = mysqli_fetch_array($resultc);
|
|
|
|
@extract($row_company);
|
|
?>
|
|
|
|
|
|
<br>
|
|
<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>OCCUPATION HEALTH CENTER (OHC)</span> -->
|
|
|
|
|
|
|
|
|
|
</b>
|
|
</center>
|
|
</div>
|
|
</td>
|
|
<!-- <td width="20%" align="right">
|
|
DOM/OHC/PE/02
|
|
<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>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
<hr>
|
|
|
|
<h4>
|
|
<center>MEDICAL EXAMINATION REPORT - CANTEEN EMPLOYEES</center>
|
|
</h4>
|
|
<hr>
|
|
|
|
|
|
<table style="text-align: right; width: 100%;">
|
|
<tr>
|
|
<td style="width: 70%;">Date of Pre-employment Medical Exam:</td>
|
|
<td style="width: 30%;">Sr. No. <u> <?php echo $ticket_no ?></u></td>
|
|
</tr>
|
|
</table>
|
|
<?php
|
|
$patient_name = getFieldFromTable('patient_name', 'patient_master', 'id', $emp_id);
|
|
$natural_job = getFieldFromTable('nature_of_job', 'patient_master', 'id', $emp_id);
|
|
$village_name = getFieldFromTable('village', 'patient_master', 'id', $emp_id);
|
|
$district = getFieldFromTable('district', 'patient_master', 'id', $emp_id);
|
|
$state = getFieldFromTable('state', 'patient_master', 'id', $emp_id);
|
|
$pin_code = getFieldFromTable('pin_code', 'patient_master', 'id', $emp_id);
|
|
$blood_group = getFieldFromTable('blood_group', 'patient_master', 'id', $emp_id);
|
|
$dob = getFieldFromTable('dob', 'patient_master', 'id', $emp_id);
|
|
|
|
$c = date('Y');
|
|
$y = date('Y', strtotime($dob));
|
|
$age = $c - $y;
|
|
|
|
|
|
|
|
|
|
$address = $village_name . "," . $district . "," . $state . "," . $pin_code . ".";
|
|
|
|
|
|
?>
|
|
|
|
<table>
|
|
<tr>
|
|
<td>Name: <u><?php echo $patient_name ?></u> </td>
|
|
</tr>
|
|
<tr>
|
|
<td>Address: <u><?php echo $address ?></u> </td>
|
|
</tr>
|
|
<tr>
|
|
<td>Natural Job In Canteen: <u><?php echo $natural_job ?></u> </td>
|
|
</tr>
|
|
</table>
|
|
|
|
<?php
|
|
$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'] == 'marital_status_2') {
|
|
|
|
$marital_status_2 = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
|
|
}
|
|
if ($rows_exa_key['checkup_form_key'] == 'blood_pressure_2') {
|
|
|
|
$blood = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
|
|
}
|
|
if ($rows_exa_key['checkup_form_key'] == 'family_planning_history') {
|
|
|
|
$family_planning_history = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
|
|
}
|
|
if ($rows_exa_key['checkup_form_key'] == 'diet') {
|
|
|
|
$diet = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
|
|
}
|
|
if ($rows_exa_key['checkup_form_key'] == 'smoking_tobacco') {
|
|
|
|
$smoking_tobacco = 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'] == 'fever') {
|
|
|
|
$fever = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
|
|
}
|
|
if ($rows_exa_key['checkup_form_key'] == 'jaundice') {
|
|
|
|
$jaundice = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
|
|
}
|
|
if ($rows_exa_key['checkup_form_key'] == 'skin_infection_on_hands_arms_face') {
|
|
|
|
$skin_infection_on_hands_arms_face = 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_diarrhoea_vomiting_fever_during_last_seven_days') {
|
|
$h_o_diarrhoea_vomiting_fever_during_last_seven_days = $rows_exa_key['checkup_form_value'];
|
|
}
|
|
|
|
if ($rows_exa_key['checkup_form_key'] == 'h_o_boils_styes_septic_fingers_at_present') {
|
|
$h_o_boils_styes_septic_fingers_at_present = $rows_exa_key['checkup_form_value'];
|
|
}
|
|
if ($rows_exa_key['checkup_form_key'] == 'h_o_skin_ear_infection_in_the_past') {
|
|
$h_o_skin_ear_infection_in_the_past = $rows_exa_key['checkup_form_value'];
|
|
}
|
|
if ($rows_exa_key['checkup_form_key'] == 'h_o_contact_with_person_having_jaundice_typhoid_during_last_three_weeks') {
|
|
$h_o_contact_with_person_having_jaundice_typhoid_during_last_three_weeks = $rows_exa_key['checkup_form_value'];
|
|
}
|
|
if ($rows_exa_key['checkup_form_key'] == 'height_3') {
|
|
$height_3 = $rows_exa_key['checkup_form_value'];
|
|
}
|
|
|
|
if ($rows_exa_key['checkup_form_key'] == 'weight_3') {
|
|
$weight_3 = $rows_exa_key['checkup_form_value'];
|
|
}
|
|
if ($rows_exa_key['checkup_form_key'] == 'distant_vision_rt_eye') {
|
|
$distant_vision_rt_eye = $rows_exa_key['checkup_form_value'];
|
|
}
|
|
if ($rows_exa_key['checkup_form_key'] == 'near_vision_rt_eye') {
|
|
$near_vision_rt_eye = $rows_exa_key['checkup_form_value'];
|
|
}
|
|
if ($rows_exa_key['checkup_form_key'] == 'distant_vision_lt_eye') {
|
|
$distant_vision_lt_eye = $rows_exa_key['checkup_form_value'];
|
|
}
|
|
if ($rows_exa_key['checkup_form_key'] == 'near_vision_lt_eye') {
|
|
$near_vision_lt_eye = $rows_exa_key['checkup_form_value'];
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
if ($rows_exa_key['checkup_form_key'] == 'boils_styes_or_septic_finger') {
|
|
$boils_styes_or_septic_finger = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
|
|
}
|
|
if ($rows_exa_key['checkup_form_key'] == 'discharge_from_eye_ear_or_gums_mouth') {
|
|
$discharge_from_eye_ear_or_gums_mouth = 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'] == 'hydocele_1') {
|
|
$hydocele_1 = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
if ($rows_exa_key['checkup_form_key'] == 'pulse_2') {
|
|
$pulse_2 = $rows_exa_key['checkup_form_value'];
|
|
}
|
|
if ($rows_exa_key['checkup_form_key'] == 'blood_pressure_2') {
|
|
$blood_pressure_2 = $rows_exa_key['checkup_form_value'];
|
|
}
|
|
if ($rows_exa_key['checkup_form_key'] == 'cvs') {
|
|
$cvs = $rows_exa_key['checkup_form_value'];
|
|
}
|
|
if ($rows_exa_key['checkup_form_key'] == 'abdomen') {
|
|
$abdomen = $rows_exa_key['checkup_form_value'];
|
|
}
|
|
if ($rows_exa_key['checkup_form_key'] == 'resp_system') {
|
|
$resp_system = $rows_exa_key['checkup_form_value'];
|
|
}
|
|
if ($rows_exa_key['checkup_form_key'] == 'c_n_s') {
|
|
$c_n_s = $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_wbc_count_1') {
|
|
$tlc_wbc_count_1 = $rows_exa_key['checkup_form_value'];
|
|
}
|
|
if ($rows_exa_key['checkup_form_key'] == 'esr') {
|
|
$esr = $rows_exa_key['checkup_form_value'];
|
|
}
|
|
|
|
if ($rows_exa_key['checkup_form_key'] == 'polymorphs') {
|
|
$polymorphs = $rows_exa_key['checkup_form_value'];
|
|
}
|
|
if ($rows_exa_key['checkup_form_key'] == 'lymphocytes') {
|
|
$lymphocytes = $rows_exa_key['checkup_form_value'];
|
|
}
|
|
if ($rows_exa_key['checkup_form_key'] == 'eosinophils_1') {
|
|
$eosinophils_1 = $rows_exa_key['checkup_form_value'];
|
|
}
|
|
if ($rows_exa_key['checkup_form_key'] == 'monocytes_1') {
|
|
$monocytes_1 = $rows_exa_key['checkup_form_value'];
|
|
}
|
|
|
|
if ($rows_exa_key['checkup_form_key'] == 'basophils_1') {
|
|
$basophils_1 = $rows_exa_key['checkup_form_value'];
|
|
}
|
|
if ($rows_exa_key['checkup_form_key'] == 'blood_sugar_r') {
|
|
$blood_sugar_r = $rows_exa_key['checkup_form_value'];
|
|
}
|
|
if ($rows_exa_key['checkup_form_key'] == 'sgpt_2') {
|
|
$sgpt_2 = $rows_exa_key['checkup_form_value'];
|
|
}
|
|
if ($rows_exa_key['checkup_form_key'] == 'widal_test') {
|
|
$widal_test = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
|
|
}
|
|
if ($rows_exa_key['checkup_form_key'] == 'anti_hav_igm') {
|
|
$anti_hav_igm = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
|
|
}
|
|
|
|
if ($rows_exa_key['checkup_form_key'] == 'hiv_test') {
|
|
|
|
$hiv_test = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
|
|
}
|
|
if ($rows_exa_key['checkup_form_key'] == 'stool_examination') {
|
|
$stool_examination = $rows_exa_key['checkup_form_value'];
|
|
}
|
|
if ($rows_exa_key['checkup_form_key'] == 'x_ray_chest_pa_view_once_in_year') {
|
|
$x_ray_chest_pa_view_once_in_year = $rows_exa_key['checkup_form_value'];
|
|
}
|
|
if ($rows_exa_key['checkup_form_key'] == 'x_ray_chest_pa_view_1') {
|
|
$x_ray_chest_pa_view_1 = $rows_exa_key['checkup_form_value'];
|
|
}
|
|
if ($rows_exa_key['checkup_form_key'] == 'date_of_vaccination') {
|
|
$date_of_vaccination = $rows_exa_key['checkup_form_value'];
|
|
}
|
|
if ($rows_exa_key['checkup_form_key'] == 'batch_no') {
|
|
$batch_no = $rows_exa_key['checkup_form_value'];
|
|
}
|
|
if ($rows_exa_key['checkup_form_key'] == 'deworming_date') {
|
|
$deworming_date = $rows_exa_key['checkup_form_value'];
|
|
}
|
|
|
|
|
|
|
|
if ($rows_exa_key['checkup_form_key'] == 'basophils_1') {
|
|
$basophils_1 = $rows_exa_key['checkup_form_value'];
|
|
}
|
|
|
|
if ($rows_exa_key['checkup_form_key'] == 'basophils_1') {
|
|
$basophils_1 = $rows_exa_key['checkup_form_value'];
|
|
}
|
|
|
|
if ($rows_exa_key['checkup_form_key'] == 'basophils_1') {
|
|
$basophils_1 = $rows_exa_key['checkup_form_value'];
|
|
}
|
|
|
|
if ($rows_exa_key['checkup_form_key'] == 'basophils_1') {
|
|
$basophils_1 = $rows_exa_key['checkup_form_value'];
|
|
}
|
|
if ($rows_exa_key['checkup_form_key'] == 'no_of_children_female_1') {
|
|
$no_of_children_female_1 = $rows_exa_key['checkup_form_value'];
|
|
}
|
|
if ($rows_exa_key['checkup_form_key'] == 'no_of_children_male_1') {
|
|
$no_of_children_male_1 = $rows_exa_key['checkup_form_value'];
|
|
}
|
|
if ($rows_exa_key['checkup_form_key'] == 'since_1') {
|
|
$since_1 = $rows_exa_key['checkup_form_value'];
|
|
}
|
|
if ($rows_exa_key['checkup_form_key'] == 'distant_rt_uncorrected_2') {
|
|
$distant_rt_uncorrected_2 = 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_2') {
|
|
$distant_rt_corrected_2 = 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_2') {
|
|
$near_rt_uncorrected_2 = 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_3') {
|
|
$near_rt_uncorrected_3 = 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_2') {
|
|
$distant_lt_uncorrected_2 = 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_2') {
|
|
$distant_lt_corrected_2 = 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_2') {
|
|
$near_lt_uncorrected_2 = 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_2') {
|
|
$near_lt_corrected_2 = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
|
|
}
|
|
}
|
|
?>
|
|
<!-- // @extract($rows_exa_key);
|
|
// if($rows_exa_key['checkup_form_key']=='marital_status_2'){ echo $rows_exa_key['checkup_form_value']; }
|
|
//
|
|
-->
|
|
|
|
<table style="width: 80%;">
|
|
|
|
|
|
<tr>
|
|
<td style="width: 25px;">Marital Status: <u> <?php echo $marital_status_2; ?></u></td>
|
|
<td style="width: 25px;"><label for=""> </label></td>
|
|
<td style="width: 25px;"><label for=""></label></td>
|
|
<td style="width: 25px;"><label for="">Blood Gr. <u><?php echo $blood_group ?></u> </label></td>
|
|
|
|
</tr>
|
|
|
|
|
|
|
|
|
|
|
|
<tr>
|
|
<td style="width: 25px;">No. of children:</td>
|
|
<td style="width: 25px;"><label for="">Male: <u><?php echo $no_of_children_male_1 ?></u></label></td>
|
|
<td style="width: 25px;"><label for="">Female: <u><?php echo $no_of_children_female_1 ?></u></label></td>
|
|
</tr>
|
|
|
|
|
|
<tr>
|
|
<td style="width: 25px;">Family Plannig History: <u> <?php echo $family_planning_history ?></u></td>
|
|
<td style="width: 25px;"><label for=""></label></td>
|
|
<td style="width: 25px;"><label for=""></label></td>
|
|
</tr>
|
|
|
|
</table>
|
|
<hr>
|
|
<table style="width: 80%;">
|
|
<tr>
|
|
<td style="width: 33px;">Diet: <u><?php echo $diet ?></u> </td>
|
|
|
|
<td style="width: 33px;"><label for=""><b>Habits:</b></label>Smoking/Tobacco : <u><?php echo $smoking_tobacco ?></u> </td>
|
|
|
|
<td style="width: 33px;">Since: <u> <?php echo $since_1 ?></u></td>
|
|
|
|
</tr>
|
|
</table>
|
|
<br>
|
|
|
|
<table>
|
|
<tr>
|
|
<td style="width: 25px;">Alcohol: <u> <?php echo $alcohol_2 ?></u></td>
|
|
<td style="width: 25px;"><label for=""></label></td>
|
|
<td style="width: 25px;"><label for=""></label></td>
|
|
|
|
|
|
</tr>
|
|
</table>
|
|
|
|
|
|
<table style="width: 100%;">
|
|
<tr>
|
|
<td style="width: 80%;"></td>
|
|
<td style="width: 10%;">Yes</td>
|
|
<td style="width: 10%;">No</td>
|
|
</tr>
|
|
<tr>
|
|
<td style="width: 80%;">H/o. Diarrhoea/Vomiting, Fever during Last Seven Days</td>
|
|
<td style="width: 10%;"><input <?php if ($h_o_diarrhoea_vomiting_fever_during_last_seven_days == '6') { ?> checked <?php } ?> type="checkbox" name="" id=""></td>
|
|
<td style="width: 10%;"><input <?php if ($h_o_diarrhoea_vomiting_fever_during_last_seven_days == '5') { ?> checked <?php } ?> type="checkbox" name="" id=""></td>
|
|
</tr>
|
|
<tr>
|
|
<td style="width: 80%;">H/o. Boils/Styes/Septic Fingers At Present</td>
|
|
<td style="width: 10%;"><input <?php if ($h_o_boils_styes_septic_fingers_at_present == '6') { ?> checked <?php } ?> type="checkbox" name="" id=""></td>
|
|
<td style="width: 10%;"><input <?php if ($h_o_boils_styes_septic_fingers_at_present == '5') { ?> checked <?php } ?> type="checkbox" name="" id=""></td>
|
|
</tr>
|
|
<tr>
|
|
<td style="width: 80%;">H/o. Skin/Ear Infection in the past</td>
|
|
<td style="width: 10%;"><input input <?php if ($h_o_skin_ear_infection_in_the_past == '6') { ?> checked <?php } ?> type="checkbox" name="" id=""></td>
|
|
<td style="width: 10%;"><input input <?php if ($h_o_skin_ear_infection_in_the_past == '5') { ?> checked <?php } ?> type="checkbox" name="" id=""></td>
|
|
</tr>
|
|
<tr>
|
|
<td style="width: 80%;">H/o. Contact with person having Jaundice/Typhoid during last 3 weeks.</td>
|
|
<td style="width: 10%;"><input <?php if ($h_o_contact_with_person_having_jaundice_typhoid_during_last_three_weeks == '6') { ?> checked <?php } ?> type="checkbox" name="" id=""></td>
|
|
<td style="width: 10%;"><input <?php if ($h_o_contact_with_person_having_jaundice_typhoid_during_last_three_weeks == '5') { ?> checked <?php } ?> type="checkbox" name="" id=""></td>
|
|
</tr>
|
|
</table>
|
|
|
|
|
|
<h2 style="font-size: 12px;">GENERAL EXAMINATION</h2>
|
|
<table border="1" width="80%" cellspacing="0">
|
|
<tr>
|
|
<td style="width: 60%;"></td>
|
|
<td style="width: 20%;" colspan="2">DATE: <?php echo $exa_date ?></td>
|
|
|
|
</tr>
|
|
<tr>
|
|
|
|
<td style="width: 60%;">AGE</td>
|
|
<td style="width: 20%;" colspan="2"><?php echo $age ?></td>
|
|
|
|
</tr>
|
|
<tr>
|
|
<td style="width: 60%;">HEIGHT cms</td>
|
|
<td style="width: 20%;" colspan="2"><?php echo $height_3; ?></td>
|
|
|
|
</tr>
|
|
<tr>
|
|
<td style="width: 60%;">WEIGHT Kg</td>
|
|
<td style="width: 20%;" colspan="2"><?php echo $weight_3; ?></td>
|
|
|
|
</tr>
|
|
<tr>
|
|
<td style="width: 60%;">FEVER</td>
|
|
<td style="width: 20%;" colspan="2"><?php echo $fever; ?></td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
<td style="width: 60%;">JAUNDICE</td>
|
|
<td style="width: 20%;" colspan="2"><?php echo $jaundice; ?></td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
<td style="width: 60%;">SKIN INFECTION ON HANDS, ARMS, FACE</td>
|
|
<td style="width: 20%;" colspan="2"><?php echo $skin_infection_on_hands_arms_face; ?></td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
<td style="width: 60%;">BOILS, STYES OR SEPTIC FINGER</td>
|
|
<td style="width: 20%;" colspan="2"><?php echo $boils_styes_or_septic_finger; ?></td>
|
|
|
|
</tr>
|
|
<tr>
|
|
<td style="width: 60%;">DISCHARGE FROM EYE, EAR OR GUMS/MOUTH</td>
|
|
<td style="width: 20%;" colspan="2"><?php echo $discharge_from_eye_ear_or_gums_mouth; ?></td>
|
|
|
|
</tr>
|
|
<tr>
|
|
<td style="width: 60%;">HERNIA</td>
|
|
<td style="width: 20%;" colspan="2"><?php echo $hernia_1; ?></td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
<td style="width: 60%;">HYDROCELE</td>
|
|
<td style="width: 20%;" colspan="2"><?php echo $hydocele_1; ?></td>
|
|
|
|
</tr>
|
|
<tr>
|
|
<td style="width: 60%;">YEAR</td>
|
|
<td style="width: 20%;" colspan="2"><?php echo $exa_year ?></td>
|
|
|
|
</tr>
|
|
<tr>
|
|
<td style="width: 60%;">EYES</td>
|
|
<td style="width: 10%;" colspan="1">D</td>
|
|
<td style="width: 10%;" colspan="1">N</td>
|
|
|
|
</tr>
|
|
<tr>
|
|
<td style="width: 60%;">Rt</td>
|
|
<td style="width: 10%;" colspan="1"><?php echo $distant_vision_rt_eye; ?></td>
|
|
<td style="width: 10%;" colspan="1"><?php echo $near_vision_rt_eye ?></td>
|
|
|
|
|
|
</tr>
|
|
<tr>
|
|
<td style="width: 60%;">Lt</td>
|
|
<td style="width: 10%;" colspan="1"><?php echo $distant_vision_lt_eye; ?></td>
|
|
<td style="width: 10%;" colspan="1"><?php echo $near_vision_lt_eye ?></td>
|
|
|
|
</tr>
|
|
</table>
|
|
|
|
<div class="page-break"></div>
|
|
<br>
|
|
|
|
|
|
|
|
|
|
<table border="1" width="80%" cellspacing="0">
|
|
<tr>
|
|
<td style="width: 60%;">SYSTEMIC EXAM</td>
|
|
<td style="width: 20%;">DATE:</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
<td style="width: 60%;">PULSE /min</td>
|
|
<td style="width: 20%;"><?php echo $pulse_2; ?></td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
<td style="width: 60%;">BP mm of Hg </td>
|
|
<td style="width: 20%;"><?php echo $blood_pressure_2; ?></td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
<td style="width: 60%;">CVS</td>
|
|
<td style="width: 20%;"><?php echo $cvs; ?></td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
<td style="width: 60%;">ABDOMEN</td>
|
|
<td style="width: 20%;"><?php echo $abdomen; ?></td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
<td style="width: 60%;">RESP SYSTEM</td>
|
|
<td style="width: 20%;"><?php echo $resp_system; ?></td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
<td style="width: 60%;">C.N.S.</td>
|
|
<td style="width: 20%;"><?php echo $c_n_s; ?></td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
<td style="width: 60%; padding: 15px;"><b>INVESTIGATIONS</b></td>
|
|
<td style="width: 20%;"></td>
|
|
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
<td style="width: 60%;">Hb gm %</td>
|
|
<td style="width: 20%;"><?php echo $hb_1; ?></td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
<td style="width: 60%;">TLC</td>
|
|
<td style="width: 20%;"><?php echo $tlc_wbc_count_1; ?></td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
<td style="width: 60%;">ESR mm</td>
|
|
<td style="width: 20%;"><?php echo $esr; ?></td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
<td style="width: 60%;">Polymorphs</td>
|
|
<td style="width: 20%;"><?php echo $polymorphs ?></td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
<td style="width: 60%;">Lymphocytes</td>
|
|
<td style="width: 20%;"><?php echo $lymphocytes; ?></td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
<td style="width: 60%;">Eosinophils</td>
|
|
<td style="width: 2-%;"><?php echo $eosinophils_1 ?></td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
<td style="width: 60%;">Monocytes</td>
|
|
<td style="width: 20%;"><?php echo $monocytes_1 ?></td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
<td style="width: 60%;">Basophils</td>
|
|
<td style="width: 20%;"><?php echo $basophils_1; ?></td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
<td style="width: 60%;">BLOOD SUGAR (R)</td>
|
|
<td style="width: 20%;"><?php echo $blood_sugar_r; ?></td>
|
|
|
|
</tr>
|
|
|
|
|
|
|
|
<tr>
|
|
<td style="width: 60%;">SGPT</td>
|
|
<td style="width: 20%;"><?php echo $sgpt_2; ?></td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
<td style="width: 60%;">WIDAL TEST</td>
|
|
<td style="width: 20%;"><?php echo $widal_test; ?></td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
<td style="width: 60%;">ANTI HAV-IgM</td>
|
|
<td style="width: 20%;"><?php echo $anti_hav_igm; ?></td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
<td style="width: 60%;">HIV TEST</td>
|
|
<td style="width: 60%;"><?php echo $hiv_test; ?></td>
|
|
|
|
</tr>
|
|
<tr>
|
|
<td style="width: 60%;">Stool Examination</td>
|
|
<td style="width: 20%;"><?php echo $stool_examination; ?></td>
|
|
|
|
</tr>
|
|
<tr>
|
|
<td style="width: 60%;">X-Ray Chest</td>
|
|
<td style="width: 20%;"><?php echo $x_ray_chest_pa_view_once_in_year; ?></td>
|
|
|
|
</tr>
|
|
</table>
|
|
<br>
|
|
<table border="1" width="98%" align="center" cellspacing="0">
|
|
<tr>
|
|
<td style="width: 33%;">TYPHOID VACCINATION</td>
|
|
<td style="width: 33%;">DATE:</td>
|
|
<td style="width: 33%;">Batch No</td>
|
|
</tr>
|
|
<tr>
|
|
<td style="width: 33%; padding: 10px;"></td>
|
|
<td style="width: 33%;"><?php echo $date_of_vaccination ?></td>
|
|
<td style="width: 33%;"><?php echo $batch_no ?></td>
|
|
</tr>
|
|
<tr>
|
|
<td style="width: 33%;">Deworming Date </td>
|
|
<td style="width: 33%;"><?php echo $deworming_date ?></td>
|
|
<td style="width: 33%;"></td>
|
|
|
|
</tr>
|
|
</table>
|
|
|
|
<hr>
|
|
<div class="outer-border">
|
|
<table style="width: 98%;">
|
|
<tr>
|
|
<td>I hereby confirm that Mr./Ms./Mrs <?php echo $patient_name ?>had undergone</td>
|
|
</tr>
|
|
<tr>
|
|
<td>medical examination and found to be:</td>
|
|
</tr>
|
|
<tr>
|
|
<td>1. Healthy and fit to work as food handlers</td>
|
|
</tr>
|
|
<tr>
|
|
<td>2. Unhealthy and not fit to work as food handler</td>
|
|
</tr>
|
|
<tr>
|
|
<td>3. Unhealthy but can return to work on</td>
|
|
</tr>
|
|
<tr>
|
|
<td style="text-align: right;">...........................</td>
|
|
</tr>
|
|
</table>
|
|
</div>
|
|
<br>
|
|
<?php
|
|
$query = "select e.emp_sign,e.image_type,e.registration_no 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: 20%;"><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>
|
|
|
|
|
|
<tr>
|
|
<td>Date:<?php echo $exa_date ?></td>
|
|
</tr>
|
|
<tr>
|
|
<td>
|
|
Registration Number :<?php echo $registration_no; ?>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td>
|
|
Medical Officer:...................
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
|
|
|
|
|
|
|
|
</body>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
</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>
|