224 lines
5.5 KiB
PHP
224 lines
5.5 KiB
PHP
<?php include('pdf_header_reverse.php');
|
|
include('includes/config/config.php');
|
|
include_once('includes/functions.php');
|
|
$from_date = $_REQUEST['startDate2'];
|
|
$to_date = $_REQUEST['endDate2'];
|
|
|
|
|
|
//include('pop_up_top.php');
|
|
?>
|
|
<link href="includes/css-js/admin.css" rel="stylesheet" type="text/css" />
|
|
<body>
|
|
<style>
|
|
.tbl2{
|
|
font-size:12px;
|
|
|
|
border: 1px solid black;
|
|
border-collapse: collapse;
|
|
|
|
}
|
|
.tbl2 td,th{
|
|
font-size:12px;
|
|
|
|
border: 1px solid black;
|
|
border-collapse: collapse;
|
|
|
|
padding: 4px;
|
|
}
|
|
</style>
|
|
<center><h3>FORM-17A</h3></center>
|
|
<table width="100%" class="tbl2">
|
|
<tr>
|
|
|
|
<td width="100%" align="center" style="font-size:25px"><strong>RECORD OF EYE EXAMINATION</strong></td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
<td align="center"><strong>[Prescribed under 49 of the West Bengal Factories Rules,1958]</strong></td>
|
|
</tr>
|
|
|
|
|
|
|
|
|
|
</table>
|
|
|
|
|
|
<br>
|
|
|
|
|
|
|
|
<table border="1" width="100%" class="tbl2">
|
|
<?php
|
|
$sql="SELECT a.*,b.patient_name,b.gender,b.dob,b.emp_code,b.dept_id,b.gender,b.designation_id,c.* FROM patient_master a left join medical_examination c on a.id = c.patient_id WHERE month(c.medical_entry_date)='$month' and year(c.medical_entry_date) and c.task = 'eye_check'";
|
|
|
|
error_log("FORM17".$sql);
|
|
|
|
$result = mysqli_query($conn,$sql);
|
|
|
|
?>
|
|
<tr>
|
|
<th >Serial No.</th>
|
|
<th >Department/works</th>
|
|
<th >Name of Worker</th>
|
|
|
|
<th >Sex</th>
|
|
<th >Age</th>
|
|
<th>Occupation</th>
|
|
<th>Date of Employment</th>
|
|
<th>Date of Examination</th>
|
|
|
|
|
|
</tr>
|
|
|
|
|
|
<tr>
|
|
<th>1</th>
|
|
<th>2</th>
|
|
<th>3</th>
|
|
<th>4</th>
|
|
<th>5</th>
|
|
<th>6</th>
|
|
<th>7</th>
|
|
<th>8</th>
|
|
</tr>
|
|
|
|
|
|
<?php
|
|
$count=0;
|
|
while ($row1= mysqli_fetch_assoc($result)){
|
|
extract($row1);
|
|
|
|
$department = getFieldFromTable('dept_name','department','dept_id',$row1['dept_id']);
|
|
|
|
$designation = getFieldFromTable('designation_name','designation','designation_id',$row1['designation_id']);
|
|
?>
|
|
|
|
<tr>
|
|
|
|
<td><?php echo $count++?></td>
|
|
<td><?php echo $department?></td>
|
|
<td><?php echo $row1['patient_name']?></td>
|
|
<td><?php if($row1['gender']=='M')
|
|
|
|
echo "Male";
|
|
|
|
elseif ($row1['gender']=='F')
|
|
|
|
echo "Female";?></td>
|
|
<td><?php
|
|
|
|
$from = new DateTime($row1['dob']);
|
|
|
|
$to = new DateTime('today');
|
|
|
|
echo $from->diff($to)->y;?></td>
|
|
<td><?php echo $designation?></td>
|
|
<td><?php echo $row1['doj']?></td>
|
|
<td><?php echo $row1['medical_entry_date']?></td>
|
|
|
|
|
|
</tr>
|
|
<?php
|
|
$count++;
|
|
}
|
|
?>
|
|
|
|
</table>
|
|
|
|
<br>
|
|
|
|
<table border="1" width="100%" class="tbl2">
|
|
<tr>
|
|
<td colspan="12" align="center"><b>Examination of Eye Sight</b></td>
|
|
<!-- <td></td> -->
|
|
</tr>
|
|
<tr>
|
|
<td colspan="10">
|
|
<div>
|
|
<b style="font-weight: 800;text-decoration: underline;">9.Result</b>
|
|
</div>
|
|
<br>
|
|
<div style="display: inline">
|
|
<b>Visual Activity</b>
|
|
<b>Without Glass: R.E: 6/ <?php echo $row1['dis_without_right_eye']?> </b>
|
|
<b>Without Glass: L.E: 6/ <?php echo $row1['dis_without_left_eye']?> </b>
|
|
</div>
|
|
<br>
|
|
<div style="display: inline">
|
|
|
|
<b>With Glass: R.E: 6/ <?php echo $row1['dis_with_right_eye']?> </b>
|
|
<b>With Glass: L.E: 6/ <?php echo $row1['dis_with_left_eye']?> </b>
|
|
</div>
|
|
</td>
|
|
|
|
<td colspan="1">
|
|
<b>10. Signature of Ophthalmologist</b>
|
|
</td>
|
|
|
|
<td colspan="1">
|
|
<b>11. Remarks</b>
|
|
</td>
|
|
</tr>
|
|
|
|
<tr>
|
|
<td colspan="10"><b>Color Vision:</b> <?php echo $row1['color_vision']?></td>
|
|
<td colspan="1" rowspan="5"><img
|
|
src="data:<?php echo $row1['doc_sign_image_type']?>;base64,<?php echo base64_encode( $row1['approving_doc_sign_img'])?>"
|
|
style="width: 200px; height: 61px;" /></td>
|
|
<td colspan="1" rowspan="5"><?php echo $row1['remarks']?></td>
|
|
</tr>
|
|
|
|
<tr>
|
|
<td colspan="2" rowspan="2" >Refractive Power</td>
|
|
<td colspan="4" align="center">Right eye</td>
|
|
<td colspan="4" align="center">Left eye</td>
|
|
</tr>
|
|
|
|
<tr>
|
|
<td>DSPH</td>
|
|
<td>DCYL</td>
|
|
<td>AXIS</td>
|
|
<td>VISION</td>
|
|
<td>DSPH</td>
|
|
<td>DCYL</td>
|
|
<td>AXIS</td>
|
|
<td>VISION</td>
|
|
</tr>
|
|
|
|
<tr>
|
|
<td colspan="2" >Distance</td>
|
|
<td><?php echo $row1['rd_dsph']?></td>
|
|
<td><?php echo $row1['rd_dcyl']?></td>
|
|
<td><?php echo $row1['rd_axis']?></td>
|
|
<td><?php echo $row1['rd_v']?></td>
|
|
<td><?php echo $row1['ld_dsph']?></td>
|
|
<td><?php echo $row1['ld_dcyl']?></td>
|
|
<td><?php echo $row1['ld_axis']?></td>
|
|
<td><?php echo $row1['ld_v']?></td>
|
|
</tr>
|
|
|
|
<tr>
|
|
<td colspan="2" >Near reading</td>
|
|
<td><?php echo $row1['rn_dsph']?></td>
|
|
<td><?php echo $row1['rn_dcyl']?></td>
|
|
<td><?php echo $row1['rn_axis']?></td>
|
|
<td><?php echo $row1['rn_v']?></td>
|
|
<td><?php echo $row1['ln_dsph']?></td>
|
|
<td><?php echo $row1['ln_dcyl']?></td>
|
|
<td><?php echo $row1['ln_axis']?></td>
|
|
<td><?php echo $row1['ln_v']?></td>
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
</tr>
|
|
</table>
|
|
</body>
|
|
|
|
<?php
|
|
include('pdf_footer.php');
|
|
?>
|
|
|
|
|