716 lines
22 KiB
PHP
716 lines
22 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");
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
?>
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
<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;
|
||
|
|
}
|
||
|
|
|
||
|
|
.page-break {
|
||
|
|
page-break-before: always;
|
||
|
|
/* or use page-break-after: always; */
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
/* .tbl_tbl {
|
||
|
|
border: 1px solid black;
|
||
|
|
border-collapse: collapse;
|
||
|
|
} */
|
||
|
|
</style>
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
</head>
|
||
|
|
|
||
|
|
<?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);
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
$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);
|
||
|
|
$dob = getFieldFromTable('dob', 'patient_master', 'id', $emp_id);
|
||
|
|
|
||
|
|
$c = date('Y');
|
||
|
|
$y = date('Y', strtotime($dob));
|
||
|
|
$age = $c - $y;
|
||
|
|
?>
|
||
|
|
|
||
|
|
<?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>Occupational Health Centre</span> -->
|
||
|
|
<br> <br><span style="font-size: 16px;">MEDICAL EXAMINATION FOR CONFINED SPACE</span>
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
</b>
|
||
|
|
</center>
|
||
|
|
</div>
|
||
|
|
</td>
|
||
|
|
<td width="20%" align="right">
|
||
|
|
|
||
|
|
|
||
|
|
</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>
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
<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>
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
<?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'] == 'smoking_2') {
|
||
|
|
|
||
|
|
$smoking_2 = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
|
||
|
|
}
|
||
|
|
if ($rows_exa_key['checkup_form_key'] == 'alcohol_3') {
|
||
|
|
|
||
|
|
$alcohol_3 = 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_2') {
|
||
|
|
|
||
|
|
$tobacco_chewing_2 = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
|
||
|
|
}
|
||
|
|
if ($rows_exa_key['checkup_form_key'] == 'others_5') {
|
||
|
|
|
||
|
|
$others_5 = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
|
||
|
|
}
|
||
|
|
if ($rows_exa_key['checkup_form_key'] == 'dm_1') {
|
||
|
|
|
||
|
|
$dm_1 = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
|
||
|
|
}
|
||
|
|
if ($rows_exa_key['checkup_form_key'] == 'stroke_1') {
|
||
|
|
|
||
|
|
$stroke_1 = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
|
||
|
|
}
|
||
|
|
if ($rows_exa_key['checkup_form_key'] == 'htn') {
|
||
|
|
|
||
|
|
$htn = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
|
||
|
|
}
|
||
|
|
if ($rows_exa_key['checkup_form_key'] == 'tumor_1') {
|
||
|
|
|
||
|
|
$tumor_1 = 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_3') {
|
||
|
|
|
||
|
|
$heart_disease_3 = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
|
||
|
|
}
|
||
|
|
if ($rows_exa_key['checkup_form_key'] == 'epilepsy_2') {
|
||
|
|
|
||
|
|
$epilepsy_2 = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
|
||
|
|
}
|
||
|
|
if ($rows_exa_key['checkup_form_key'] == 'asthma_1') {
|
||
|
|
|
||
|
|
$asthma_1 = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
|
||
|
|
}
|
||
|
|
if ($rows_exa_key['checkup_form_key'] == 'acrophobia_height_phobia') {
|
||
|
|
|
||
|
|
$acrophobia_height_phobia = 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'] == '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'] == 'nails') {
|
||
|
|
|
||
|
|
$nails = $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'] == 'b_p_1') {
|
||
|
|
|
||
|
|
$b_p_1 = $rows_exa_key['checkup_form_value'];
|
||
|
|
}
|
||
|
|
if ($rows_exa_key['checkup_form_key'] == 'deformity') {
|
||
|
|
|
||
|
|
$deformity = $rows_exa_key['checkup_form_value'];
|
||
|
|
}
|
||
|
|
if ($rows_exa_key['checkup_form_key'] == 'spo2_1') {
|
||
|
|
|
||
|
|
$spo2_1 = $rows_exa_key['checkup_form_value'];
|
||
|
|
}
|
||
|
|
|
||
|
|
if ($rows_exa_key['checkup_form_key'] == 'near_lt_uncorrected_1') {
|
||
|
|
|
||
|
|
$near_lt_uncorrected_1 = 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_1') {
|
||
|
|
|
||
|
|
$near_rt_uncorrected_1 = 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_1') {
|
||
|
|
|
||
|
|
$near_rt_corrected_1 = 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_1') {
|
||
|
|
|
||
|
|
$near_lt_corrected_1 = 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_1') {
|
||
|
|
|
||
|
|
$distant_lt_corrected_1 = 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_1') {
|
||
|
|
|
||
|
|
$distant_rt_corrected_1 = 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_1') {
|
||
|
|
|
||
|
|
$distant_lt_uncorrected_1 = 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_uncorrected_1') {
|
||
|
|
|
||
|
|
$distant_rt_uncorrected_1 = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
|
||
|
|
}
|
||
|
|
if ($rows_exa_key['checkup_form_key'] == 'spo2_1') {
|
||
|
|
|
||
|
|
$spo2_1 = $rows_exa_key['checkup_form_value'];
|
||
|
|
}
|
||
|
|
if ($rows_exa_key['checkup_form_key'] == 'spo2_1') {
|
||
|
|
|
||
|
|
$spo2_1 = $rows_exa_key['checkup_form_value'];
|
||
|
|
}
|
||
|
|
if ($rows_exa_key['checkup_form_key'] == 'field_of_vision') {
|
||
|
|
|
||
|
|
$field_of_vision = $rows_exa_key['checkup_form_value'];
|
||
|
|
}
|
||
|
|
if ($rows_exa_key['checkup_form_key'] == 'colour_vision_by_ishihara_chart') {
|
||
|
|
|
||
|
|
$colour_vision_by_ishihara_chart = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $rows_exa_key['checkup_form_value']);
|
||
|
|
}
|
||
|
|
|
||
|
|
if ($rows_exa_key['checkup_form_key'] == 'resps_yptem') {
|
||
|
|
|
||
|
|
$resps_yptem = $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'] == 'cns') {
|
||
|
|
|
||
|
|
$cns = $rows_exa_key['checkup_form_value'];
|
||
|
|
}
|
||
|
|
if ($rows_exa_key['checkup_form_key'] == 'tandem_walking') {
|
||
|
|
|
||
|
|
$tandem_walking = $rows_exa_key['checkup_form_value'];
|
||
|
|
}
|
||
|
|
if ($rows_exa_key['checkup_form_key'] == 'rombergs_test') {
|
||
|
|
|
||
|
|
$rombergs_test = $rows_exa_key['checkup_form_value'];
|
||
|
|
}
|
||
|
|
if ($rows_exa_key['checkup_form_key'] == 'finger_nose_test') {
|
||
|
|
|
||
|
|
$finger_nose_test = $rows_exa_key['checkup_form_value'];
|
||
|
|
}
|
||
|
|
if ($rows_exa_key['checkup_form_key'] == 'higher_function') {
|
||
|
|
|
||
|
|
$higher_function = $rows_exa_key['checkup_form_value'];
|
||
|
|
}
|
||
|
|
if ($rows_exa_key['checkup_form_key'] == 'spine') {
|
||
|
|
|
||
|
|
$spine = $rows_exa_key['checkup_form_value'];
|
||
|
|
}
|
||
|
|
if ($rows_exa_key['checkup_form_key'] == 'gait_2') {
|
||
|
|
|
||
|
|
$gait_2 = $rows_exa_key['checkup_form_value'];
|
||
|
|
}
|
||
|
|
if ($rows_exa_key['checkup_form_key'] == 'higher_function') {
|
||
|
|
|
||
|
|
$higher_function = $rows_exa_key['checkup_form_value'];
|
||
|
|
}
|
||
|
|
if ($rows_exa_key['checkup_form_key'] == 'higher_function') {
|
||
|
|
|
||
|
|
$higher_function = $rows_exa_key['checkup_form_value'];
|
||
|
|
}
|
||
|
|
if ($rows_exa_key['checkup_form_key'] == 'higher_function') {
|
||
|
|
|
||
|
|
$higher_function = $rows_exa_key['checkup_form_value'];
|
||
|
|
}
|
||
|
|
if ($rows_exa_key['checkup_form_key'] == 'blood_gr') {
|
||
|
|
|
||
|
|
$blood_gr = $rows_exa_key['checkup_form_value'];
|
||
|
|
}
|
||
|
|
if ($rows_exa_key['checkup_form_key'] == 'rbs_3') {
|
||
|
|
|
||
|
|
$rbs_3 = $rows_exa_key['checkup_form_value'];
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
?>
|
||
|
|
<br>
|
||
|
|
|
||
|
|
|
||
|
|
<table style="width: 100%;">
|
||
|
|
<tr>
|
||
|
|
<td style="width: 80%;">NAME: <u><?php echo $patient_name; ?></u> </td>
|
||
|
|
<td style="width: 10%;">AGE:<?php echo $age ?></td>
|
||
|
|
<td style="width: 10%;">SEX. <u><?php if ($gender == 'M') {
|
||
|
|
echo 'Male';
|
||
|
|
} else if ($gender == 'F') {
|
||
|
|
echo 'Female';
|
||
|
|
} ?></u> </td>
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
</table>
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
<!-- <table style="width: 100%;">
|
||
|
|
<tr>
|
||
|
|
<td style="width: 25%;">Age:</td>
|
||
|
|
<td style="width: 25%;">Sex:</td>
|
||
|
|
<td style="width: 25%;">Male</td>
|
||
|
|
<td style="width: 25%;">Female</td>
|
||
|
|
</tr>
|
||
|
|
</table> -->
|
||
|
|
<br>
|
||
|
|
|
||
|
|
<table style="width: 100%;">
|
||
|
|
<tr>
|
||
|
|
<td style="width: 20%;"></td>
|
||
|
|
<td style="width: 80%;"><b>PRESENT HISTORY OF ILLNESS</b></td>
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td style="width: 20%;"></td>
|
||
|
|
<td style="width: 80%;"><u><?php echo $history_of_illness ?></u></td>
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td style="width: 20%;"></td>
|
||
|
|
<td style="width: 80%;">____________________________________</td>
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
</table>
|
||
|
|
<br>
|
||
|
|
|
||
|
|
<table style="width: 100%;">
|
||
|
|
<tr>
|
||
|
|
<td style="width: 20%;"> <b> PERSONAL HABITS:</b></td>
|
||
|
|
<td style="width: 20%;">SMOKING: <u> <?php echo $smoking_2; ?> </u> </td>
|
||
|
|
<td style="width: 15%;">ALCOHOL: <u> <?php echo $alcohol_3; ?> </u> </td>
|
||
|
|
<td style="width: 25%;">TOBACCO CHEWING: <u> <?php echo $tobacco_chewing_2; ?></u> </td>
|
||
|
|
<td style="width: 20%;">OTHERS: <u> <?php echo $others_5; ?></u> </td>
|
||
|
|
</tr>
|
||
|
|
</table>
|
||
|
|
<br>
|
||
|
|
|
||
|
|
<table style="width: 100%;">
|
||
|
|
<tr>
|
||
|
|
<td style="width: 25%;"><b>HISTORY OF KNOWN ILLNESS</b></td>
|
||
|
|
<td style="width: 25%;">DM: <u> <?php echo $dm_1; ?></u></td>
|
||
|
|
<td style="width: 25%;">STROKE: <u> <?php echo $stroke_1; ?></u></td>
|
||
|
|
<td style="width: 25%;">TB <u> <?php echo $tobacco_chewing_2; ?></u></td>
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td style="width: 25%;"></td>
|
||
|
|
<td style="width: 25%;">HTN: <u><?php echo $htn; ?></u></td>
|
||
|
|
<td style="width: 25%;">TUMOR: <u><?php echo $tumor_1; ?></u></td>
|
||
|
|
<td style="width: 25%;">HEART DISEASE: <u><?php echo $heart_disease_3; ?></u></td>
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td style="width: 25%;"></td>
|
||
|
|
<td style="width: 25%;">EPILEPSY: <u><?php echo $epilepsy_2; ?></u></td>
|
||
|
|
<td style="width: 25%;">ASTHMA: <u><?php echo $asthma_1; ?></u></td>
|
||
|
|
<td style="width: 25%;">OTHERS: <u><?php echo $htn; ?></u></td>
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td style="width: 25%;"></td>
|
||
|
|
<td style="width: 40%;">ACROPHOBIA (HEIGHT PHOBIA): <u> <?php echo $acrophobia_height_phobia ?></u></td>
|
||
|
|
<td style="width: 10%;"></td>
|
||
|
|
<td style="width: 25%;"></td>
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
</table>
|
||
|
|
<br>
|
||
|
|
|
||
|
|
|
||
|
|
<table style="width: 100%;">
|
||
|
|
<tr>
|
||
|
|
<td style="width: 25%;"><b>PAST HISTORY:</b></td>
|
||
|
|
<td style="width: 25%;">MAJOR ILLNESS : <?php echo $h_o_major_illness ?></td>
|
||
|
|
<td style="width: 25%;">ANY ACCIDENT : <?php echo $h_o_any_accident ?></td>
|
||
|
|
<td style="width: 25%;">ANY MAJOR OPERATION: <?php echo $h_o_any_major_operation ?></td>
|
||
|
|
</tr>
|
||
|
|
</table>
|
||
|
|
<br>
|
||
|
|
|
||
|
|
<h2 style="font-size: 12px;"><b>GENERAL EXAMINATION:</b></h2>
|
||
|
|
<table style="width: 100%;">
|
||
|
|
<tr>
|
||
|
|
<td style="width: 33%;">1. HEIGHT: <u><?php echo $height_3 ?></u> cms </td>
|
||
|
|
<td style="width: 33%;">2. WEIGHT: <u><?php echo $weight_3 ?></u> kg </td>
|
||
|
|
<td style="width: 33%;">3. NAILS: <u><?php echo $nails ?></u> </td>
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td style="width: 33%;">4. PULSE: <u><?php echo $pulse_2 ?></u> /Min</td>
|
||
|
|
<td style="width: 33%;">5. B.P. : <u><?php echo $b_p_1 ?></u> mm/Hg</td>
|
||
|
|
<td style="width: 33%;">6. DEFORMITY: <u><?php echo $deformity ?></u> </td>
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td style="width: 33%;">7. SPO2: <u><?php echo $spo2_1 ?></u> </td>
|
||
|
|
<td style="width: 33%;"></td>
|
||
|
|
<td style="width: 33%;"></td>
|
||
|
|
</tr>
|
||
|
|
</table>
|
||
|
|
|
||
|
|
<h2 style="font-size: 12px;"><b>VISION:</b></h2>
|
||
|
|
<table border="1" width="100%" 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_1 ?></td>
|
||
|
|
<td style="width: 16px;" colspan="1"><?php echo $distant_lt_uncorrected_1 ?></td>
|
||
|
|
<td style="width: 16px;" colspan="1"><?php echo $near_rt_uncorrected_1 ?></td>
|
||
|
|
<td style="width: 16px;" colspan="1"><?php echo $near_lt_uncorrected_1 ?></td>
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
|
||
|
|
<tr>
|
||
|
|
<td style="width: 33px;" colspan="1">Corrected</td>
|
||
|
|
|
||
|
|
<td style="width: 16px;" colspan="1"><?php echo $distant_lt_corrected_1 ?></td>
|
||
|
|
<td style="width: 16px;" colspan="1"><?php echo $distant_rt_corrected_1 ?></td>
|
||
|
|
<td style="width: 16px;" colspan="1"><?php echo $near_rt_corrected_1 ?></td>
|
||
|
|
<td style="width: 16px;" colspan="1"><?php echo $near_lt_corrected_1 ?></td>
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
|
||
|
|
|
||
|
|
</table>
|
||
|
|
|
||
|
|
<table style="width: 100%;">
|
||
|
|
<tr>
|
||
|
|
<td style="width: 100%;">COLOUR VISION: <u><?php echo $colour_vision_by_ishihara_chart
|
||
|
|
?></u></td>
|
||
|
|
<td style="width: 100%;">FIELD OF VISION: <u><?php echo $field_of_vision ?></u></td>
|
||
|
|
</tr>
|
||
|
|
|
||
|
|
</table>
|
||
|
|
|
||
|
|
<table style="width: 100%;">
|
||
|
|
<tr>
|
||
|
|
<td style="width: 50%;">A. CVS: <u><?php echo $cvs ?></u></td>
|
||
|
|
<td style="width: 50%;"></td>
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td style="width: 50%;">B. RESP SYSTEM : <u><?php echo $resps_yptem ?></u></td>
|
||
|
|
<td style="width: 50%;"></td>
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td style="width: 50%;">C. ABDOMEN : <u><?php echo $abdomen ?></u></td>
|
||
|
|
<td style="width: 50%;"></td>
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td style="width: 50%;">D. CNS: <u><?php echo $cns ?></u></td>
|
||
|
|
<td style="width: 50%;"></td>
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td style="width: 50%;">TANDEM WALKING : <u><?php echo $tandem_walking ?></td>
|
||
|
|
<td style="width: 50%;">FINGER NOSE TEST : <u><?php echo $finger_nose_test ?></td>
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td style="width: 50%;">ROMBERG'S TEST: <u><?php echo $rombergs_test ?></td>
|
||
|
|
<td style="width: 50%;">HIGHER FUNCTION: <u><?php echo $higher_function ?></td>
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td style="width: 50%;">GAIT: <u><?php echo $gait_2 ?></td>
|
||
|
|
<td style="width: 50%;">SPINE: <u><?php echo $spine ?></td>
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
</table>
|
||
|
|
<br>
|
||
|
|
<table style="width: 100%;">
|
||
|
|
<tr>
|
||
|
|
<td style=" width:33%;"><b> INVESTIGATIONS </b><u><?php ?></u></td>
|
||
|
|
<td style=" width:25%;">HAEMOGLOBIN :<u><?php echo strtoupper($haemoglobin_2) ?> gram %</u></td>
|
||
|
|
<td style=" width:25%;">BLOOD GR: <u><?php echo strtoupper($blood_gr) ?></u></td>
|
||
|
|
<td style=" width:25%;">RBS: <u><?php echo strtoupper($rbs_3) ?> mg/dL</u></td>
|
||
|
|
</tr>
|
||
|
|
</table>
|
||
|
|
<br>
|
||
|
|
|
||
|
|
<h2 style="font-size: 12px;">Remarks: Medically <?php echo $fit_unfit_status; ?></h2>
|
||
|
|
|
||
|
|
<div class="page-break"></div>
|
||
|
|
<table border="1" width="100%" cellspacing="0">
|
||
|
|
|
||
|
|
<tr>
|
||
|
|
<td style="width: 20%;">DATE</td>
|
||
|
|
<td style="width: 20%;">B.P</td>
|
||
|
|
<td style="width: 12%;">PULSE</td>
|
||
|
|
<td style="width: 12%;">SPO2</td>
|
||
|
|
<td style="width: 12%;">TEMP</td>
|
||
|
|
<td style="width: 12%;">FITNESS</td>
|
||
|
|
<td style="width: 12%;">SIGN</td>
|
||
|
|
</tr>
|
||
|
|
<?php
|
||
|
|
$vital_sql = "SELECT * FROM vital_signs_checkup where checkup_type = '49' and emp_id = '$emp_id'";
|
||
|
|
error_log($vital_sql);
|
||
|
|
|
||
|
|
$res_vital = mysqli_query($conn, $vital_sql);
|
||
|
|
$i = 1;
|
||
|
|
|
||
|
|
while ($rows_vital = mysqli_fetch_array($res_vital)) {
|
||
|
|
|
||
|
|
?>
|
||
|
|
<tr>
|
||
|
|
<td style="width: 20%;"><?php echo date('d-m-Y', strtotime($rows_vital['vital_date'])) ?></td>
|
||
|
|
<td style="width: 20%;"><?php echo $rows_vital['vital_bp'] ?>/ mm of Hg</td>
|
||
|
|
<td style="width: 12%;"><?php echo $rows_vital['vital_pulse'] ?> / min</td>
|
||
|
|
<td style="width: 12%;"><?php echo $rows_vital['vital_spo2'] ?> %</td>
|
||
|
|
<td style="width: 12%;"><?php echo $rows_vital['vital_temp'] ?> F</td>
|
||
|
|
<td style="width: 12%;"><?php echo $rows_vital['vital_fitness'] ?></td>
|
||
|
|
<td style="width: 12%;"></td>
|
||
|
|
</tr>
|
||
|
|
<?php } ?>
|
||
|
|
</table>
|
||
|
|
|
||
|
|
<?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>
|