433 lines
13 KiB
PHP
433 lines
13 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 {
|
|
|
|
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;
|
|
}
|
|
|
|
table {
|
|
border-collapse: collapse;
|
|
width: 100%;
|
|
border: 2px solid black;
|
|
}
|
|
|
|
th,
|
|
td {
|
|
padding: 8px;
|
|
text-align: left;
|
|
|
|
}
|
|
|
|
|
|
|
|
.page-break {
|
|
page-break-before: always;
|
|
|
|
}
|
|
|
|
body {
|
|
text-transform: uppercase;
|
|
}
|
|
|
|
.no-border {
|
|
border: none;
|
|
}
|
|
|
|
.no-border-td {
|
|
border-bottom: none;
|
|
}
|
|
</style>
|
|
|
|
|
|
|
|
</head>
|
|
<?php
|
|
$queryc = "select * from company_profile ";
|
|
|
|
$resultc = mysqli_query($conn, $queryc);
|
|
|
|
$row_company = mysqli_fetch_array($resultc);
|
|
|
|
@extract($row_company);
|
|
?>
|
|
<?php
|
|
$checkup_id = $_REQUEST['checkup_id'];
|
|
$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)) {
|
|
|
|
$dataArray[$rows_exa_key['checkup_form_key']] = $rows_exa_key['checkup_form_value'];
|
|
}
|
|
|
|
|
|
$sql_employee_appointment = "SELECT * FROM checkup_form WHERE checkup_id = '" . $checkup_id . "' ";
|
|
|
|
|
|
error_log("sql injury pres:" . $sql_employee_appointment);
|
|
|
|
$res_emp_appoint = mysqli_query($conn, $sql_employee_appointment);
|
|
|
|
while ($rows_emp_appoint = mysqli_fetch_array($res_emp_appoint)) {
|
|
$emp_id = $rows_emp_appoint['emp_id'];
|
|
$ticket_no = $rows_emp_appoint['ticket_no'];
|
|
|
|
$date_a = $rows_emp_appoint['checkup_date'];
|
|
|
|
|
|
$appointment_date = date("d-m-Y", strtotime($date_a));
|
|
$time = date("H:i A", strtotime($date_a));
|
|
$fit_status = $rows_emp_appoint['fit_unfit_status'];
|
|
|
|
$patient_name = getFieldFromTable('patient_name', 'patient_master', 'id', $rows_emp_appoint['emp_id']);
|
|
$emp_code = getFieldFromTable('emp_code', 'patient_master', 'id', $rows_emp_appoint['emp_id']);
|
|
$patient_cat_id = getFieldFromTable('patient_cat_id', 'patient_master', 'id', $rows_emp_appoint['emp_id']);
|
|
|
|
$patient_cat_name = getFieldFromTable('patient_cat_name', 'patient_category', 'patient_cat_id', $patient_cat_id);
|
|
|
|
$primary_phone = getFieldFromTable('primary_phone', 'patient_master', 'id', $rows_emp_appoint['emp_id']);
|
|
$dob = getFieldFromTable('dob', 'patient_master', 'id', $rows_emp_appoint['emp_id']);
|
|
$gender = getFieldFromTable('gender', 'patient_master', 'id', $rows_emp_appoint['emp_id']);
|
|
$dept_id = getFieldFromTable('dept_id', 'patient_master', 'id', $rows_emp_appoint['emp_id']);
|
|
$dept_name = getFieldFromTable('dept_name', 'department', 'dept_id', $dept_id);
|
|
|
|
|
|
|
|
$c = date('Y');
|
|
$y = date('Y', strtotime($dob));
|
|
$age = $c - $y;
|
|
}
|
|
|
|
?>
|
|
|
|
<table class="no-border" width="100%" cellspacing="0">
|
|
<tr>
|
|
|
|
<td class="no-border-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 class="no-border-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']) ?>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
</b>
|
|
</center>
|
|
</div>
|
|
</td>
|
|
<!-- <td class="no-border-td" style="font-size: 12px;" width="20%" align="right">
|
|
<span>
|
|
DOM/OHC/PPL/03<br>
|
|
Eff. Dt. 01/01/97 <br>
|
|
Rev No 00
|
|
</span>
|
|
</td> -->
|
|
</tr>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
</table>
|
|
<br><br>
|
|
|
|
|
|
|
|
|
|
<table>
|
|
<thead>
|
|
<tr>
|
|
<th colspan="4">
|
|
<center>PRE-PLACEMENT MEDICAL EXAMINATION FOR EMPLOYEES HANDLING <br>(NITRO AMINO COMPOUND)</center>
|
|
</th>
|
|
|
|
</tr>
|
|
</thead>
|
|
</table><br>
|
|
<table>
|
|
<tbody>
|
|
<!-- <tr>
|
|
<td style="height: 25px;" colspan="3"></td>
|
|
|
|
<td style="height: 25px;">Time :- <?php echo $time ?></td>
|
|
</tr> -->
|
|
<tr>
|
|
<td style="height: 25px;" colspan="3">NAME:- <?php if ($patient_name) {
|
|
echo $patient_name;
|
|
} else { ?>________________________<?php } ?></td>
|
|
|
|
<td style="height: 25px;">Date :- <?php echo $appointment_date ?></td>
|
|
</tr>
|
|
<tr>
|
|
<td style="height: 25px;" colspan="2">CODE NO :- <?php echo $emp_code ?></td>
|
|
<td style="height: 25px;" colspan="2">CATEGORY :- <?php echo $patient_cat_name ?></td>
|
|
</tr>
|
|
<tr>
|
|
<td style="height: 25px;">AGE :- <?php echo $age ?></td>
|
|
<td style="height: 25px;">SEX :- <?php if ($gender == 'M') {
|
|
echo 'Male';
|
|
} else if ($gender == 'F') {
|
|
echo 'Female';
|
|
} ?></td>
|
|
<td style="height: 25px;" colspan="2">DEPT :- <?php echo $dept_name ?></td>
|
|
</tr>
|
|
|
|
|
|
</tbody>
|
|
|
|
</table><br>
|
|
<h5>GENERAL EXAMINATION</h5>
|
|
|
|
<table>
|
|
<tbody>
|
|
<tr>
|
|
<td style="height: 25px;">Body Temp :- <u><?php if ($dataArray['body_temp_2']) {
|
|
echo $dataArray['body_temp_2'];
|
|
} else { ?></u>________<?php } ?></td>
|
|
<td style="height: 25px;">Spo2 :- <u><?php if ($dataArray['spo2_7']) {
|
|
echo $dataArray['spo2_7'];
|
|
} else { ?></u> ______<?php } ?> %</td>
|
|
<td style="height: 25px;" colspan="2">Pulse :- <u><?php if ($dataArray['pulse_1']) {
|
|
echo $dataArray['pulse_1'];
|
|
} else { ?></u> ________<?php } ?> /Min</td>
|
|
</tr>
|
|
|
|
<tr>
|
|
<td style="height: 25px;" colspan="2">BP :- <u><?php if ($dataArray['blood_pressure_9']) {
|
|
echo $dataArray['blood_pressure_9'];
|
|
} else { ?></u> _________<?php } ?> mm of hg</td>
|
|
<td style="height: 25px;" colspan="2">Weight :- <u><?php if ($dataArray['weight_10']) {
|
|
echo $dataArray['weight_10'];
|
|
} else { ?></u> ________<?php } ?> Kg</td>
|
|
</tr>
|
|
<tr>
|
|
<td style="height: 25px;" colspan="2">Tongue :- <?php if ($dataArray['tongue_5']) {
|
|
echo $dataArray['tongue_5'];
|
|
} else { ?>_________<?php } ?></td>
|
|
<td style="height: 25px;" colspan="2">Nail :- <?php if ($dataArray['nails_6']) {
|
|
echo $dataArray['nails_6'];
|
|
} else { ?> ________<?php } ?></td>
|
|
</tr>
|
|
|
|
|
|
|
|
</tbody>
|
|
|
|
</table>
|
|
<br>
|
|
<h5>BLOOD EXAMINATION</h5>
|
|
|
|
|
|
<table>
|
|
<tbody>
|
|
<tr>
|
|
<td style="height: 25px;" colspan="4"><b>Investigations :</b></td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
<td style="height: 25px;" colspan="2">Hb :- <u><?php if ($dataArray['hemoglobin_8']) {
|
|
echo $dataArray['hemoglobin_8'];
|
|
} else { ?> </u>_________<?php } ?> gm%</td>
|
|
<td style="height: 25px;" colspan="2">G6PD :- <u><?php if ($dataArray['g6pd_1']) {
|
|
echo $dataArray['g6pd_1'];
|
|
} else { ?></u>________<?php } ?> UgHB%</td>
|
|
</tr>
|
|
|
|
</tbody>
|
|
|
|
</table><br><br>
|
|
|
|
<table style="width: 100%;">
|
|
<tbody>
|
|
<tr>
|
|
<th rowspan="2" style="width: 20%; padding: 20px;">Remarks:</th>
|
|
<th style="width: 80%; padding: 20px;">
|
|
<center> 1. MEDICALLY FIT TO WORK lN ANILINE (NITRO AMINO COMPOUND) <br>PLANT- <?php if($plant =='fit') {?><u><?php echo 'Yes' ?></u><?php }else{?> _____ <?php } ?></center>
|
|
</th>
|
|
|
|
</tr>
|
|
<tr>
|
|
|
|
<th style="width: 80%; padding: 20px;">
|
|
<center> 1. MEDICALLY UNFIT TO WORK lN ANILINE (NITRO AMINO COMPOUND) <br>PLANT- <?php if($plant=='ufit') {?><u><?php echo 'No' ?></u><?php }else{?> _____ <?php } ?> BECAUSE OF </center>
|
|
</th>
|
|
|
|
</tr>
|
|
|
|
|
|
|
|
</tbody>
|
|
|
|
</table>
|
|
<table class="no-border" style="width: 100%;">
|
|
<tr>
|
|
|
|
<td class="no-border-td" style="width: 50%;"><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 class="no-border" style="width: 100%;">
|
|
|
|
|
|
<tr>
|
|
<td class="no-border-td" style="width: 50%; ">Factory Medical Officer</td>
|
|
</tr>
|
|
|
|
|
|
</table>
|
|
<div class="page-break"></div>
|
|
|
|
|
|
<table border="1" width="100%" cellspacing="0">
|
|
<tr>
|
|
<td style="width: 5%;">SR.NO</td>
|
|
<td style="width: 10%;">DATE</td>
|
|
<td style="width: 5%;">TIME</td>
|
|
<td style="width: 12%;">COMPLAINTS</td>
|
|
<td style="width: 8%;">SPO2</td>
|
|
<td style="width: 8%;">NAILS</td>
|
|
<td style="width: 8%;">TONGUE</td>
|
|
<td style="width: 8%;">REMARKS</td>
|
|
</tr>
|
|
<?php
|
|
$vital_sql = "SELECT * FROM vital_signs_checkup where checkup_type in ('60','66') and emp_id = '$emp_id'";
|
|
|
|
$res_vital = mysqli_query($conn, $vital_sql);
|
|
$i =1 ;
|
|
|
|
while ($rows_vital = mysqli_fetch_array($res_vital)) {
|
|
|
|
?>
|
|
<tr>
|
|
<td style="width: 5%;"><?php echo $i;?></td>
|
|
<td style="width: 10%;"><?php echo date('d-m-Y', strtotime($rows_vital['vital_date']))?></td>
|
|
<td style="width: 5%;"><?php echo date('H:i:s', strtotime($rows_vital['vital_date']))?></td>
|
|
<td style="width: 12%;"><?php echo $rows_vital['vital_complaints']?></td>
|
|
<td style="width: 8%;"><?php echo $rows_vital['vital_spo2']?></td>
|
|
<td style="width: 8%;"><?php echo $rows_vital['vital_nails']?></td>
|
|
<td style="width: 8%;"><?php echo $rows_vital['vital_tongue']?></td>
|
|
<td style="width: 8%;"><?php echo $rows_vital['vital_remarks']?></td>
|
|
</tr>
|
|
<?php
|
|
$i++;
|
|
|
|
}
|
|
?>
|
|
|
|
|
|
</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);
|
|
|
|
?>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
</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>
|