289 lines
11 KiB
PHP
289 lines
11 KiB
PHP
|
<?php session_start();
|
||
|
|
|
||
|
|
include('includes/config/config.php');
|
||
|
|
include_once("includes/functions.php");
|
||
|
|
include_once("log_entry.php");
|
||
|
|
mysqli_query($conn, 'SET character_set_results=utf8');
|
||
|
|
error_reporting(0);
|
||
|
|
|
||
|
|
$query = "select * from company_profile where company_id = 5";
|
||
|
|
$result = mysqli_query($conn, $query);
|
||
|
|
$row_for_company = mysqli_fetch_array($result);
|
||
|
|
@extract($row_for_company);
|
||
|
|
?>
|
||
|
|
<!doctype html>
|
||
|
|
<html lang="en">
|
||
|
|
|
||
|
|
<head>
|
||
|
|
<title>Medical Examination of Food HANDLERS</title>
|
||
|
|
<!-- Required meta tags -->
|
||
|
|
<meta charset="utf-8">
|
||
|
|
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
|
||
|
|
|
||
|
|
<!-- Bootstrap CSS -->
|
||
|
|
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css"
|
||
|
|
integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous">
|
||
|
|
|
||
|
|
<style>
|
||
|
|
.print {
|
||
|
|
position: absolute;
|
||
|
|
right: 11%;
|
||
|
|
}
|
||
|
|
|
||
|
|
.space {
|
||
|
|
padding-bottom: 10px;
|
||
|
|
}
|
||
|
|
|
||
|
|
@media print {
|
||
|
|
#printPageButton {
|
||
|
|
display: none;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
body {
|
||
|
|
font-family: Arial, Helvetica, sans-serif
|
||
|
|
}
|
||
|
|
|
||
|
|
.table_sign_2 {
|
||
|
|
left: 10%;
|
||
|
|
width: 100%;
|
||
|
|
}
|
||
|
|
|
||
|
|
.canteen {
|
||
|
|
background-color: #008080;
|
||
|
|
/* position: relative; */
|
||
|
|
left: 20%;
|
||
|
|
text-align: center;
|
||
|
|
padding-left: 10%;
|
||
|
|
padding-right: 10%;
|
||
|
|
color: white;
|
||
|
|
}
|
||
|
|
|
||
|
|
table {
|
||
|
|
border-collapse: collapse;
|
||
|
|
}
|
||
|
|
|
||
|
|
.table_2 {
|
||
|
|
text-align: center;
|
||
|
|
/* font-size: 10px; */
|
||
|
|
}
|
||
|
|
|
||
|
|
th,
|
||
|
|
td {
|
||
|
|
/* border: 1px solid black; */
|
||
|
|
height: 20px;
|
||
|
|
}
|
||
|
|
|
||
|
|
/*
|
||
|
|
td{
|
||
|
|
position: relative;
|
||
|
|
} */
|
||
|
|
.tt {
|
||
|
|
text-align: center;
|
||
|
|
}
|
||
|
|
|
||
|
|
.head {
|
||
|
|
background-color: #008080;
|
||
|
|
color: white;
|
||
|
|
}
|
||
|
|
</style>
|
||
|
|
</head>
|
||
|
|
|
||
|
|
<body>
|
||
|
|
|
||
|
|
<div class="container">
|
||
|
|
<div class="container">
|
||
|
|
<div class="container">
|
||
|
|
<?php
|
||
|
|
include "pdf_ohc_header.php";
|
||
|
|
?>
|
||
|
|
<button id="printPageButton" class="btn btn-success print" onClick="window.print();">Print</button>
|
||
|
|
|
||
|
|
<br><br>
|
||
|
|
<h3 class="canteen">PERFORMA FOR MEDICAL FITNESS CERTIFICATE FOR FOOD HANDLERS</h3>
|
||
|
|
|
||
|
|
|
||
|
|
<?php
|
||
|
|
|
||
|
|
$response_id = $_REQUEST['checkup_id'];
|
||
|
|
|
||
|
|
|
||
|
|
error_log("patient_id" . $patient_id . " response_id " . $response_id . " chs_no " . $chs_no);
|
||
|
|
|
||
|
|
$sql_patient = "select a.*,c.patient_name, c.dob , c.gender,c.employer_contractor_id, c.doj from checkup_form a left join patient_master c on a.emp_id = c.id where a.checkup_id='" . $response_id . "' ";
|
||
|
|
error_log("query " . $sql_patient);
|
||
|
|
|
||
|
|
$result_patient = mysqli_query($conn, $sql_patient);
|
||
|
|
|
||
|
|
$row_patient = mysqli_fetch_assoc($result_patient);
|
||
|
|
|
||
|
|
|
||
|
|
@extract($row_patient);
|
||
|
|
|
||
|
|
$y= date("Y", strtotime($row_patient['checkup_date']));
|
||
|
|
$date= date("d/m/Y", strtotime($row_patient['checkup_date']));
|
||
|
|
|
||
|
|
if ($row_patient['gender'] == 'M' || $row_patient['gender'] == 'm') {
|
||
|
|
$gender = "MALE";
|
||
|
|
} else if ($row_patient['gender'] == 'F' || $row_patient['gender'] == 'f') {
|
||
|
|
$gender = "FEMALE";
|
||
|
|
}
|
||
|
|
?>
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
<h6 align='center'><?php echo '( FOR THE YEAR '.$y.")"; ?></h6>
|
||
|
|
|
||
|
|
<br>
|
||
|
|
|
||
|
|
<h6 align='center'>( See Para No. 10.1.2, Part - II, Schedule - 4 of FSS Regulation, 2011 )</h6>
|
||
|
|
<br>
|
||
|
|
<br>
|
||
|
|
<br>
|
||
|
|
<br>
|
||
|
|
<br>
|
||
|
|
|
||
|
|
<p>It is Certified that Shri/Smt,/Miss <strong><?= $row_patient['patient_name'] ?></strong>
|
||
|
|
employed with M/s
|
||
|
|
<strong><?=getTableFieldValue('employer_contractor','employer_contractor_name','id',$row_patient['employer_contractor_id']) ?></strong>
|
||
|
|
coming in direct
|
||
|
|
contact
|
||
|
|
with food items
|
||
|
|
has been carefully examined* by me on date <strong><?= $date ?></strong>
|
||
|
|
Based on the medical examination conducted He/She found free from any infictious or communicable
|
||
|
|
diseases
|
||
|
|
and the person is Fit to work in the above mentioned food establishment.
|
||
|
|
</p>
|
||
|
|
|
||
|
|
<br><br><br>
|
||
|
|
<br>
|
||
|
|
<br>
|
||
|
|
|
||
|
|
<div align='right'>
|
||
|
|
|
||
|
|
<?php
|
||
|
|
|
||
|
|
$medical_officer = "select b.*,a.user_name,c.patient_name from tbl_users a left join employee_signature b on a.emp_id = b.emp_id left join patient_master c on a.emp_id = c.id where a.emp_id='" . $row_patient['doc_attend'] . "'";
|
||
|
|
error_log("PDF EMPI ". $row_patient['approval_user']."--". $medical_officer);
|
||
|
|
$sign_medical = @mysqli_query($conn, $medical_officer);
|
||
|
|
$sign_medical_officer = @mysqli_fetch_assoc($sign_medical);
|
||
|
|
@extract($sign_medical_officer);
|
||
|
|
?>
|
||
|
|
|
||
|
|
|
||
|
|
<div><img style=" width:150px; height:80px;" class="card-img-bottm"
|
||
|
|
src="data:<?= $sign_medical_officer['image_type']; ?>;base64,<?= base64_encode($sign_medical_officer['emp_sign']) ?>">
|
||
|
|
</div>
|
||
|
|
<p><?= '( '.$sign_medical_officer['patient_name'].' )'?></p>
|
||
|
|
|
||
|
|
<p><strong>Name and Signature with Seal</strong></p>
|
||
|
|
<p>of Registered Medical Practitioner /
|
||
|
|
Civil Surgeon</p>
|
||
|
|
|
||
|
|
</div>
|
||
|
|
|
||
|
|
<br><br>
|
||
|
|
<br>
|
||
|
|
<br>
|
||
|
|
|
||
|
|
<div align='left'>
|
||
|
|
<p><strong>* Medical Examination to be conducted :</strong></p>
|
||
|
|
<hr>
|
||
|
|
<p>1. Physical Examination.</p>
|
||
|
|
<p>2. Eye Test.</p>
|
||
|
|
<p>3. Skin Examination.</p>
|
||
|
|
<p>4. Compliance with schedule of Vaccine to be inoculated against enteric group of diseases.</p>
|
||
|
|
<p>5. Any test required to confirm any communicable or infectious disease which the person suspected
|
||
|
|
to be suffering from on clinical examination.</p>
|
||
|
|
|
||
|
|
|
||
|
|
</div>
|
||
|
|
|
||
|
|
<!-- <table class="table_sign_2" style="text-align: center;">
|
||
|
|
<tr>
|
||
|
|
<?php
|
||
|
|
if ($row_patient['survellance'] == null || $row_patient['survellance'] == '' ) {?>
|
||
|
|
<td style="height: 100px;" width="30%">
|
||
|
|
<span
|
||
|
|
style="position: relative; text-align: center; top: 30%; width: fit-content;">Signature
|
||
|
|
of Survellance :</span>
|
||
|
|
</td>
|
||
|
|
<?php }else{
|
||
|
|
|
||
|
|
$survellance = "select b.*,c.patient_name , a.user_name from tbl_users a left join employee_signature b on a.emp_id = b.emp_id left join patient_master c on a.emp_id = c.id where a.user_id='" . $row_patient['medical_attend'] . "'";
|
||
|
|
$sign_survellance = @mysqli_query($conn, $survellance);
|
||
|
|
error_log('pdf khs '. $survellance);
|
||
|
|
$sign_survellance_officer = @mysqli_fetch_assoc($sign_survellance);
|
||
|
|
@extract($sign_survellance_officer);
|
||
|
|
?>
|
||
|
|
<td>
|
||
|
|
|
||
|
|
<center><img style=" width:150px; height:80px;" class="card-img-bottm"
|
||
|
|
src="data:<?= $sign_survellance_officer['image_type']; ?>;base64,<?= base64_encode($sign_survellance_officer['emp_sign']) ?>">
|
||
|
|
</center>
|
||
|
|
<br>
|
||
|
|
<span><?= $sign_survellance_officer['user_name'];?></span>
|
||
|
|
<br>
|
||
|
|
<span class="" style="position: relative; text-align: left;">Signature of Survellance
|
||
|
|
:</span>
|
||
|
|
<?php
|
||
|
|
} ?>
|
||
|
|
<br>
|
||
|
|
</td>
|
||
|
|
<td style="height: 100px;">
|
||
|
|
<span style="position: relative; top: 30%; text-align: center;">Sign of Canteen
|
||
|
|
Supervisor/Admin Head :</span>
|
||
|
|
</td>
|
||
|
|
<?php
|
||
|
|
if ($row_patient['approval_user'] == null || $row_patient['approval_user'] == '' ) {?>
|
||
|
|
<td style="height: 100px;">
|
||
|
|
|
||
|
|
<span class="" style="position: relative; top: 30%;">Signature of Medical Officer
|
||
|
|
:</span>
|
||
|
|
</td>
|
||
|
|
|
||
|
|
<?php }else{
|
||
|
|
|
||
|
|
$medical_officer = "select b.*,a.user_name from tbl_users a left join employee_signature b on a.emp_id = b.emp_id left join patient_master c on a.emp_id = c.id where a.user_id='" . $row_patient['approval_user'] . "'";
|
||
|
|
error_log("PDF EMPI ". $row_patient['approval_user']."--". $medical_officer);
|
||
|
|
$sign_medical = @mysqli_query($conn, $medical_officer);
|
||
|
|
$sign_medical_officer = @mysqli_fetch_assoc($sign_medical);
|
||
|
|
@extract($sign_medical_officer);
|
||
|
|
?>
|
||
|
|
<td>
|
||
|
|
|
||
|
|
<center><img style=" width:150px; height:80px;" class="card-img-bottm"
|
||
|
|
src="data:<?= $sign_medical_officer['image_type']; ?>;base64,<?= base64_encode($sign_medical_officer['emp_sign']) ?>">
|
||
|
|
</center>
|
||
|
|
<br>
|
||
|
|
<span><?= $sign_medical_officer['user_name'];?></span>
|
||
|
|
<br>
|
||
|
|
|
||
|
|
<span class="" style="position: relative; text-align: left;">Signature of Medical
|
||
|
|
Officer
|
||
|
|
:</span>
|
||
|
|
<?php
|
||
|
|
} ?>
|
||
|
|
</td>
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
</table> -->
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
<div class="space"></div>
|
||
|
|
<!-- Optional JavaScript -->
|
||
|
|
<!-- jQuery first, then Popper.js, then Bootstrap JS -->
|
||
|
|
<script src="https://code.jquery.com/jquery-3.3.1.slim.min.js"
|
||
|
|
integrity="sha384-q8i/X+965DzO0rT7abK41JStQIAqVgRVzpbzo5smXKp4YfRvH+8abtTE1Pi6jizo" crossorigin="anonymous">
|
||
|
|
</script>
|
||
|
|
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js"
|
||
|
|
integrity="sha384-UO2eT0CpHqdSJQ6hJty5KVphtPhzWj9WO1clHTMGa3JDZwrnQq4sF86dIHNDz0W1" crossorigin="anonymous">
|
||
|
|
</script>
|
||
|
|
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js"
|
||
|
|
integrity="sha384-JjSmVgyd0p3pXB1rRibZUAYoIIy6OrQ6VrjIEaFf/nJGzIxFDsf4x0xIM+B07jRM" crossorigin="anonymous">
|
||
|
|
</script>
|
||
|
|
</body>
|
||
|
|
|
||
|
|
</html>
|