500 lines
20 KiB
PHP
500 lines
20 KiB
PHP
|
|
||
|
|
<script
|
||
|
|
src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
|
||
|
|
<link
|
||
|
|
rel="stylesheet"
|
||
|
|
href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
|
||
|
|
|
||
|
|
<link href="https://fonts.googleapis.com/css?family=Hind:400,700&subset=devanagari,latin-ext" rel="stylesheet">
|
||
|
|
<head>
|
||
|
|
|
||
|
|
<style>
|
||
|
|
|
||
|
|
.tbl1 {
|
||
|
|
border: 2px solid black;
|
||
|
|
border-collapse: collapse;
|
||
|
|
font-weight: 800;
|
||
|
|
padding: 15px;
|
||
|
|
}
|
||
|
|
div {
|
||
|
|
text-transform: uppercase;
|
||
|
|
}
|
||
|
|
</style>
|
||
|
|
|
||
|
|
</head>
|
||
|
|
<div id="medical_examination_form" style="display:none ">
|
||
|
|
<?php
|
||
|
|
include('includes/config/config.php');
|
||
|
|
include_once("includes/functions.php");
|
||
|
|
error_reporting(0);
|
||
|
|
|
||
|
|
$query = "select company_logo,image_type from company_profile where company_id =5 ";
|
||
|
|
//echo $query;
|
||
|
|
$result = mysqli_query($conn,$query);
|
||
|
|
$row = mysqli_fetch_array($result);
|
||
|
|
@extract($row);?>
|
||
|
|
|
||
|
|
|
||
|
|
<table width="100%" class="tbl1">
|
||
|
|
|
||
|
|
<tr>
|
||
|
|
<td rowspan="4"><img
|
||
|
|
src="data:image/jpeg;base64,<?php echo base64_encode( $row['company_logo'] )?>"
|
||
|
|
style="display: block; width: 134px; height: 60px;" /></td>
|
||
|
|
|
||
|
|
<td rowspan="4">MAIHAR IU</td>
|
||
|
|
<td>Department</td>
|
||
|
|
<td>OCCUPATIONAL HEALTH CENTRE</td>
|
||
|
|
</tr>
|
||
|
|
|
||
|
|
<tr >
|
||
|
|
<?php
|
||
|
|
|
||
|
|
$sql_patient_physical_parameters="select a.*,b.*,c.*,a.height,a.weight,a.bp from medical_examination a inner join patient_master b on b.id=a.patient_id inner join designation c on b.designation_id=c.designation_id where a.medical_exam_id='".$_REQUEST['medical_exam_id']."'";
|
||
|
|
//echo $sql_patient_physical_parameters;
|
||
|
|
$result_patient_physical_parameters= mysqli_query($conn,$sql_patient_physical_parameters);
|
||
|
|
$row_patient_physical_parameters= mysqli_fetch_assoc($result_patient_physical_parameters);
|
||
|
|
@extract($row_patient_physical_parameters);
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
?>
|
||
|
|
<td>Document No.</td>
|
||
|
|
<td>F-MED-11</td>
|
||
|
|
</tr>
|
||
|
|
|
||
|
|
<tr >
|
||
|
|
<td>Revision</td>
|
||
|
|
<td>0.0</td>
|
||
|
|
</tr>
|
||
|
|
|
||
|
|
<tr >
|
||
|
|
<td>Implementation Date</td>
|
||
|
|
|
||
|
|
<td>01.04.2016</td>
|
||
|
|
</tr>
|
||
|
|
<tr >
|
||
|
|
<td align="center" colspan="4">PERIODIC MEDICAL EXAMINATION CARD</td>
|
||
|
|
</tr>
|
||
|
|
|
||
|
|
</table>
|
||
|
|
|
||
|
|
<div style="margin-top: 20px">
|
||
|
|
<table width="100%" class="tbl2">
|
||
|
|
<tr>
|
||
|
|
<td width="20%" >Serial No</td>
|
||
|
|
<td width="20%" ><?php echo $serial_no?></td>
|
||
|
|
<td width="20%" >Name</td>
|
||
|
|
<td width="40%" ><?php echo $patient_name?></td>
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td width="20%" >Father Name</td>
|
||
|
|
<td width="20%" colspan="3" ><?php echo $father_name?></td>
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td>Age/Sex</td>
|
||
|
|
<td colspan="3"><?php
|
||
|
|
$from = new DateTime($dob);
|
||
|
|
$to = new DateTime('today');
|
||
|
|
echo $from->diff($to)->y;
|
||
|
|
if($gender=='M')
|
||
|
|
echo " Male";
|
||
|
|
elseif ($gender=='F')
|
||
|
|
echo " Female";
|
||
|
|
|
||
|
|
?></td>
|
||
|
|
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td>Dept./ Contractor Name</td>
|
||
|
|
<td colspan="3"><?php echo getTableFieldValue('department', 'dept_name','dept_id',$dept_id)?>(<?php echo getTableFieldValue('employer_contractor', 'employer_contractor_name','id',$employer_contractor_id)?>)</td>
|
||
|
|
</tr>
|
||
|
|
|
||
|
|
<tr>
|
||
|
|
<td>Tade</td>
|
||
|
|
<td colspan="3"><?php ?></td>
|
||
|
|
</tr>
|
||
|
|
|
||
|
|
|
||
|
|
<tr>
|
||
|
|
<td>Mobile.No.</td>
|
||
|
|
<td colspan="3"><?php echo $primary_phone?></td>
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td>Gate pass No./P No</td>
|
||
|
|
<td ><?php echo $emp_code?></td>
|
||
|
|
<td>Date</td>
|
||
|
|
<td><?php echo date_format(date_create($row_patient_physical_parameters['approval_date']),"d-M-Y ");?></td>
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td colspan="4" ><b>TO BE FILLED IN BY THE CANDIDATE</b></td>
|
||
|
|
</tr>
|
||
|
|
|
||
|
|
|
||
|
|
<?php $past_present_illness_array = explode(',', $past_present_illness);
|
||
|
|
|
||
|
|
|
||
|
|
$result_section = mysqli_query($conn,"SET NAMES utf8");
|
||
|
|
$sql_section = "select * from history_parameter where param_id in (1,2,3,4,5,7,9,11) order by param_id asc";
|
||
|
|
$count=1;
|
||
|
|
|
||
|
|
$result_section = mysqli_query($conn,$sql_section);
|
||
|
|
while ($row_section = mysqli_fetch_assoc($result_section)) {
|
||
|
|
if($count%2!=0){
|
||
|
|
?><tr><?php
|
||
|
|
|
||
|
|
}?>
|
||
|
|
<td colspan="2" width="50%">
|
||
|
|
<?php if(in_array($row_section['param_id'],$past_present_illness_array)){?>
|
||
|
|
|
||
|
|
<input type="checkbox" id="<?php echo $row_section['param_name']; ?>" <?php if(in_array($row_section['param_id'],$past_present_illness_array)) echo "checked"; ?> name="history_param" value="<?php echo $row_section['param_id']; ?>" >
|
||
|
|
<b> <?php echo $row_section['param_name'];
|
||
|
|
?></b>
|
||
|
|
|
||
|
|
<?php }else{?>
|
||
|
|
<input type="checkbox" id="<?php echo $row_section['param_name'];?>" name="history_param" value="<?php echo $row_section['param_id']; ?>" >
|
||
|
|
<b> <?php echo $row_section['param_name'];
|
||
|
|
?> </b><span style="margin-left:20px"><?php echo " X"; }?></span>
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
</td>
|
||
|
|
<?php if($count%2==0){
|
||
|
|
?></tr><?php
|
||
|
|
}
|
||
|
|
$count++;
|
||
|
|
|
||
|
|
}?>
|
||
|
|
|
||
|
|
|
||
|
|
<tr>
|
||
|
|
<td rowspan="2" colspan="2"> Present Complaint If any</td>
|
||
|
|
<td rowspan="2" colspan="2"><?php echo $present_complaint?></td>
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td rowspan="2" colspan="2">Are you on any regular medication</td>
|
||
|
|
<td rowspan="2" colspan="2"><?php echo $regular_medication?></td>
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
</tr>
|
||
|
|
|
||
|
|
|
||
|
|
</table>
|
||
|
|
<div style="margin-top: 10px" >
|
||
|
|
<table width="100%" class="tbl2">
|
||
|
|
<tr>
|
||
|
|
<td colspan="6" align="center">RECORD OF MEDICAL EXAMINATION</td>
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
|
||
|
|
<td colspan="2"> Height(cms)</td><td colspan="2"><?php echo $height ?></td>
|
||
|
|
|
||
|
|
<td colspan="1"> BP</td><td colspan="1"><?php echo $bp ?> mm of Hg</td>
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
|
||
|
|
|
||
|
|
<td width="30%" colspan="2"> Weight(kgs)</td><td width="20%" colspan="2"><?php echo $weight ?></td>
|
||
|
|
<td width="20%" >PULSE</td>
|
||
|
|
<td width="30%" ><?php echo $pulse ?></td>
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
|
||
|
|
|
||
|
|
<td colspan="2">BMI</td><td colspan="2"><?php echo $bmi ?></td>
|
||
|
|
<td ></td>
|
||
|
|
<td ></td>
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
|
||
|
|
|
||
|
|
<td colspan="4" align="center"><b>Vision</b></td>
|
||
|
|
<td ></td>
|
||
|
|
<td ></td>
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td ></td>
|
||
|
|
<td ></td>
|
||
|
|
<td >RT.EYE </td><td>LT.EYE</td>
|
||
|
|
<td rowspan="3">Findings of Chest Radiograph (done after every 03 year)</td><td rowspan="3"><?php echo $chest_radiograph ?></td>
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td ></td><td>Distant Vision</td>
|
||
|
|
<td>6/<?php echo $dis_without_right_eye?></td><td>6/<?php echo $dis_without_left_eye?></td>
|
||
|
|
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td ></td><td></td>
|
||
|
|
<td></td><td></td>
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td ></td><td>Near Vision</td>
|
||
|
|
<td>N/<?php echo $near_without_right_eye?></td><td>N/<?php echo $near_without_left_eye?></td>
|
||
|
|
|
||
|
|
<td rowspan="2">ECG Findings</td><td rowspan="2"><?php echo $ecg_findings ?></td>
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td ></td><td></td>
|
||
|
|
<td></td><td></td>
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
|
||
|
|
<tr>
|
||
|
|
|
||
|
|
<td colspan="2">COLOR VISION</td>
|
||
|
|
<td colspan="2"><?php echo $color_vision;?></td>
|
||
|
|
<td></td><td></td>
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
|
||
|
|
<tr>
|
||
|
|
<td colspan="6" align="center"><b style="font-weight: 800">RESULT OF SPIROMETRY Findings</b></td>
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td colspan="2">Parameters</td>
|
||
|
|
<td colspan="2">Performed Value</td>
|
||
|
|
<td colspan="2">Predicted Value</td>
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td colspan="2">Forced Vital Capacity (FVC)</td>
|
||
|
|
<td colspan="2"><?php echo $fvc_pre?></td>
|
||
|
|
<td colspan="2"><?php echo $fvc_post?></td>
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td colspan="2">Forced Expiratory Volume in 1 sec (FEV1)</td>
|
||
|
|
<td colspan="2"><?php echo $fev1_pre?></td>
|
||
|
|
<td colspan="2"><?php echo $fev1_post?></td>
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td colspan="2">FEV1/FVC</td>
|
||
|
|
<td colspan="2"><?php echo $fev1_fvc_pre?></td>
|
||
|
|
<td colspan="2"><?php echo $fev1_fvc_post?></td>
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td colspan="2">Peak Expiratory Flow</td>
|
||
|
|
<td colspan="2"><?php echo $peak_expiratory_flow_pre?></td>
|
||
|
|
<td colspan="2"><?php echo $peak_expiratory_flow_post?></td>
|
||
|
|
</tr>
|
||
|
|
</table>
|
||
|
|
<br>
|
||
|
|
<br>
|
||
|
|
<br>
|
||
|
|
<br>
|
||
|
|
<table width="100%" class="tbl2" >
|
||
|
|
<tr>
|
||
|
|
<td colspan="6" align="center"><b style="font-weight: 800">RESULT OF AUDIOMETRY FINDINGS</b></td>
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td width="30%" colspan="2">Conduction Type </td>
|
||
|
|
<td width="35%" colspan="2" align="center">Left Ear</td>
|
||
|
|
<td width="35%" colspan="2" align="center">Right Ear</td>
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td colspan="2">Air Conduction</td>
|
||
|
|
<td colspan="2"><?php echo $air_cond_left ?> </td>
|
||
|
|
<td colspan="2"> <?php echo $air_cond_right ?> </td>
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td colspan="2">Bone Conduction</td>
|
||
|
|
<td colspan="2"><?php echo $bone_cond_left ?></td>
|
||
|
|
<td colspan="2"><?php echo $bone_cond_right ?> </td>
|
||
|
|
</tr>
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
<tr >
|
||
|
|
<td colspan="6" align="center"><b style="font-weight: 800">INVESTIGATIONS</b></td>
|
||
|
|
</tr>
|
||
|
|
|
||
|
|
<tr>
|
||
|
|
<td align="center" colspan="6" ><b> Blood Group</b><span style="margin-left:20px"><?php echo getTableFieldValue('blood_group','type','id',$blood_group)?></span></td>
|
||
|
|
</tr>
|
||
|
|
|
||
|
|
<tr>
|
||
|
|
<td > Hb </td><td><?php echo $hb?></td>
|
||
|
|
<td >TLC</td><td><?php echo $tlc?></td>
|
||
|
|
<td > DLC-N</td><td><?php echo $dlc_n?></td>
|
||
|
|
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td > DLC-L </td><td><?php echo $dlc_l?></td>
|
||
|
|
<td > DLC-M</td><td><?php echo $dlc_m?></td>
|
||
|
|
<td > DLC-E</td><td><?php echo $dlc_e?></td>
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td > ESR</td><td><?php echo $esr?></td>
|
||
|
|
<td > S. Urea</td><td><?php echo $s_urea?></td>
|
||
|
|
<td >S.Creatinine</td><td><?php echo $s_creatinine?></td>
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td > Blood Sugar </td><td><?php echo $blood_sugar?></td>
|
||
|
|
|
||
|
|
<td > VDRL</td><td><?php echo $vdrl?></td>
|
||
|
|
<td ></td><td></td>
|
||
|
|
</tr>
|
||
|
|
<tr >
|
||
|
|
<td colspan="6" align="center"><b style="font-weight: 800">Urine RE/ME</b></td>
|
||
|
|
<tr>
|
||
|
|
<td >Albumin</td><td colspan="2" ><?php echo $albumin?></td>
|
||
|
|
<td >Sugar</td><td colspan="2"><?php echo $sugar?></td>
|
||
|
|
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td rowspan="2" colspan="2" > Stool RE/ME</td>
|
||
|
|
<td rowspan="2" colspan="4" ><?php echo $stool_re_me?></td>
|
||
|
|
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
<tr></tr>
|
||
|
|
|
||
|
|
<tr>
|
||
|
|
<td colspan="2">OPINION/ REMARKS (BY DOCTOR)</td>
|
||
|
|
<td colspan="4"><?php echo $opinion_remarks;?></td>
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
|
||
|
|
<tr>
|
||
|
|
<td rowspan="2" colspan="2">Signature/Left Thumb Impression of Employee</td>
|
||
|
|
<td rowspan="2" colspan="4"></td>
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
<tr></tr>
|
||
|
|
|
||
|
|
<tr>
|
||
|
|
<td rowspan="2" colspan="2">Signature of Medical Assistant</td>
|
||
|
|
<td rowspan="2" colspan="4">
|
||
|
|
<?php
|
||
|
|
if($sign_medical_ass=='add'){
|
||
|
|
$emp_id=getTableFieldValue('tbl_users','emp_id','user_id',$medical_attend);
|
||
|
|
$query_sign = "select * from employee_signature where emp_id='" .$emp_id. "' ";
|
||
|
|
//echo $query_emp_sign;
|
||
|
|
if (! $result_sign = @mysqli_query($conn,$query_sign)) {
|
||
|
|
exit(mysqli_error($conn));
|
||
|
|
} else {
|
||
|
|
$row_sign = @mysqli_fetch_array($result_sign);
|
||
|
|
@extract($row_sign);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
// echo $row_emp_sign['modified_by'];
|
||
|
|
?>
|
||
|
|
|
||
|
|
<span class="profile-picture" style="margin-left:170px;" >
|
||
|
|
<?php if(isset($row_sign['emp_sign']) && $row_sign['emp_sign']!=null){?>
|
||
|
|
<img class="editable img-responsive" id="avatar"
|
||
|
|
src="data:<?php echo $row_sign['image_type']?>;base64,<?php echo base64_encode( $row_sign['emp_sign'] )?>"
|
||
|
|
style="display: block; width: 180px; height: 25px;" />
|
||
|
|
<?php }?>
|
||
|
|
</span>
|
||
|
|
</td>
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
<tr></tr>
|
||
|
|
<tr>
|
||
|
|
<td rowspan="2" colspan="2">Signature of Medical Officer</td>
|
||
|
|
<td rowspan="2" colspan="4">
|
||
|
|
<?php
|
||
|
|
if($sign_medical_officer=='add'){
|
||
|
|
$emp_id=getTableFieldValue('tbl_users','emp_id','user_id',$approved_by);
|
||
|
|
$query_emp_sign = "select * from employee_signature where emp_id='" .$emp_id. "' ";
|
||
|
|
// echo $query_emp_sign;
|
||
|
|
if (! $result_emp_sign = @mysqli_query($conn,$query_emp_sign)) {
|
||
|
|
exit(mysqli_error($conn));
|
||
|
|
} else {
|
||
|
|
$row_emp_sign = @mysqli_fetch_array($result_emp_sign);
|
||
|
|
@extract($row_emp_sign);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
// echo $row_emp_sign['modified_by'];
|
||
|
|
?>
|
||
|
|
|
||
|
|
<span class="profile-picture" style="margin-left:170px;" >
|
||
|
|
<?php if(isset($row_emp_sign['emp_sign']) && $row_emp_sign['emp_sign']!=null){?>
|
||
|
|
<img class="editable img-responsive" id="avatar"
|
||
|
|
src="data:<?php echo $row_emp_sign['image_type']?>;base64,<?php echo base64_encode( $row_emp_sign['emp_sign'] )?>"
|
||
|
|
style="display: block; width: 180px; height: 25px;" />
|
||
|
|
<?php }?>
|
||
|
|
</span>
|
||
|
|
</td>
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
<tr></tr>
|
||
|
|
|
||
|
|
<tr>
|
||
|
|
<td colspan="2">Doctor Name</td>
|
||
|
|
<td colspan="4"><?php echo getTableFieldValue('patient_master','patient_name','id',$emp_id);?></td>
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td colspan="2">Qualification</td>
|
||
|
|
<td colspan="4"><?php echo $row_emp_sign['qualification']?></td>
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td colspan="2">Registration No</td>
|
||
|
|
<td colspan="4"><?php echo $row_emp_sign['registration_no']?></td>
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
</table>
|
||
|
|
|
||
|
|
</div>
|
||
|
|
|
||
|
|
|
||
|
|
</div>
|
||
|
|
|
||
|
|
<form id="medical_examination_form_pdf" action="" method="POST">
|
||
|
|
<input type="hidden" name="htmlText" id="htmlText" />
|
||
|
|
</form>
|
||
|
|
</div>
|
||
|
|
|
||
|
|
<script>
|
||
|
|
formSubmit();
|
||
|
|
function formSubmit(){
|
||
|
|
|
||
|
|
|
||
|
|
$("#htmlText").val($("#medical_examination_form").html());
|
||
|
|
document.forms['medical_examination_form_pdf'].action="pdf_dynamic.php";
|
||
|
|
document.forms['medical_examination_form_pdf'].method="post";
|
||
|
|
document.forms['medical_examination_form_pdf'].submit();
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
</script>
|