123 lines
3.8 KiB
PHP
123 lines
3.8 KiB
PHP
|
<?php
|
||
|
|
include('includes/functions.php');
|
||
|
|
include('pdf_header_reverse.php');
|
||
|
|
?>
|
||
|
|
<html>
|
||
|
|
<link href="includes/css-js/admin.css" rel="stylesheet" type="text/css" />
|
||
|
|
<style>
|
||
|
|
table {
|
||
|
|
text-align: center;
|
||
|
|
text-transform: uppercase;
|
||
|
|
}
|
||
|
|
</style>
|
||
|
|
|
||
|
|
<body>
|
||
|
|
<?php
|
||
|
|
include "pdf_ohc_header.php";
|
||
|
|
?>
|
||
|
|
<table width="100%">
|
||
|
|
<tr>
|
||
|
|
<div style="font-size:12px">
|
||
|
|
<td width="50%" align="center" style="font-size:15px"><strong>AUDIT DETAILS</strong></td>
|
||
|
|
</tr>
|
||
|
|
</table>
|
||
|
|
<br>
|
||
|
|
<table width="100%" border="1" style="text-aling: center;">
|
||
|
|
<?php
|
||
|
|
$i=1;
|
||
|
|
$sql="SELECT * from health_audit where id = '".$_REQUEST['flex_audit_id']."'";
|
||
|
|
$result = mysqli_query($conn,$sql);
|
||
|
|
while($fetchData=mysqli_fetch_array($result)){
|
||
|
|
$audit_name= $fetchData['audit_name'];
|
||
|
|
$audit_details= $fetchData['audit_details'];
|
||
|
|
$location= $fetchData['location'];
|
||
|
|
$start_date_time= $fetchData['start_date_time'];
|
||
|
|
$end_date_time= $fetchData['end_date_time'];
|
||
|
|
$auditor_name= $fetchData['auditor_name'];
|
||
|
|
$representative_name= $fetchData['representative_name'];
|
||
|
|
$audit_remarks= $fetchData['audit_remarks'];
|
||
|
|
|
||
|
|
}
|
||
|
|
?>
|
||
|
|
<tr bgcolor="#eeeeee">
|
||
|
|
<th width="10%" ;>AUDIT NAME</th>
|
||
|
|
<th width="10%" ;>AUDIT DETAILS</th>
|
||
|
|
<th width="10%" ;>LOCATION</th>
|
||
|
|
<th width="10%" ;>START DATE TIME</th>
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td><?php echo $audit_name ?></td>
|
||
|
|
<td><?php echo $audit_details ?></td>
|
||
|
|
<td><?php echo $location ?></td>
|
||
|
|
<td><?php echo $start_date_time ?></td>
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
|
||
|
|
</table>
|
||
|
|
<br>
|
||
|
|
|
||
|
|
<table width="100%" border="1" style="text-aling: center;">
|
||
|
|
<tr bgcolor="#eeeeee">
|
||
|
|
<th width="10%" ;>END DATE TIME</th>
|
||
|
|
<th width="10%" ;>AUDITOR NAME</th>
|
||
|
|
<th width="10%" ;>OHC REPRESENTATIVE NAME</th>
|
||
|
|
<th width="10%" ;>REMARKS</th>
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td><?php echo $end_date_time ?></td>
|
||
|
|
<td><?php echo $auditor_name?></td>
|
||
|
|
<td><?php echo $representative_name ?></td>
|
||
|
|
<td><?php echo $audit_remarks ?></td>
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
</table>
|
||
|
|
|
||
|
|
<br><br><br><br>
|
||
|
|
<table border="1" style="text-aling: center;">
|
||
|
|
<?php
|
||
|
|
$i=1;
|
||
|
|
$sql="SELECT * from health_audit_details where audit_id = '".$_REQUEST['flex_audit_id']."'";
|
||
|
|
//echo $sql;
|
||
|
|
|
||
|
|
$result = mysqli_query($conn,$sql);
|
||
|
|
//echo $result;
|
||
|
|
?>
|
||
|
|
<tr bgcolor="#eeeeee">
|
||
|
|
<th width="10%" ;>SR. NO</th>
|
||
|
|
<th width="10%" ;>FINDING TYPE </th>
|
||
|
|
<th width="10%" ;>FINDING DETAILS</th>
|
||
|
|
<th width="10%" ;>AUDITOR REMARK </th>
|
||
|
|
<th width="10%" ;>OHC REPRESENTATIVE REMARKS</th>
|
||
|
|
<th width="10%" ;>REMEDIATION STATUS</th>
|
||
|
|
<th width="10%" ;>TARGATE FIX DATE</th>
|
||
|
|
<th width="10%" ;>REMARKS</th>
|
||
|
|
</tr>
|
||
|
|
<?php
|
||
|
|
while($participate=mysqli_fetch_array($result)){?>
|
||
|
|
<tr style="text-align: center;">
|
||
|
|
<td><?php echo $i ?></td>
|
||
|
|
<?php $finding_type = getFieldFromTable('finding_type' , 'audit_finding_type_master' , 'id' , $participate['finding_type'] ); ?>
|
||
|
|
<td><?php echo $finding_type ?></td>
|
||
|
|
<td><?php echo $participate['finding_detail']?></td>
|
||
|
|
<td><?php echo $participate['auditor_remark']?></td>
|
||
|
|
<td><?php echo $participate['representative_remarks']?></td>
|
||
|
|
<?php $representative_status = getFieldFromTable('remediation_status ' , 'remediation_status_master' , 'id' , $participate['representative_status'] ); ?>
|
||
|
|
<td><?php echo $representative_status ?></td>
|
||
|
|
<td><?php echo $participate['target_fix_date']?></td>
|
||
|
|
<td><?php echo $participate['remarks']?></td>
|
||
|
|
</tr>
|
||
|
|
<?php
|
||
|
|
$i++;
|
||
|
|
}
|
||
|
|
?>
|
||
|
|
</table>
|
||
|
|
</body>
|
||
|
|
<link rel="stylesheet" href="css/select2.min.css">
|
||
|
|
|
||
|
|
</html>
|
||
|
|
<?php
|
||
|
|
include('pdf_footer.php');
|
||
|
|
?>
|