<?php
     session_start();
require_once('../DBManager.php');
require_once('../LoginManager.php');

    include("../dbconnection.php");
		$sql2 ="SELECT * FROM ReportingError WHERE id='$_GET[id]'";
		$qsql2 = mysqli_query($con,$sql2);
		if($re1 = mysqli_fetch_array($qsql2))
		{
		    
		   	include 'dashboarddocument.php';
}
?>
	  

  <?php

include 'fileheader.php';
?>



<h3 align='center'>Reporting Error</h3>
<?php

	        echo"<h4>Doc.no : $_GET[id]</h4>";


?>  
<style>
table, th, td {
  border: 1px solid black;
}
</style>
<table id='example2' class='table table-bordered table-hover' border='1'>

<?php
  	$sql ="SELECT * FROM ReportingError WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND id='$_GET[id]'";
		$qsql = mysqli_query($con,$sql);
		if($rs = mysqli_fetch_array($qsql))
		{
		    echo"  <table  class='table table-bordered table-hover' border='1'>
		    <tr><td width='50%'>Reporting Error</td><td  width='50%'>$rs[ReportingError]</td></tr>
<tr><td width='50%'>ReportingError Native</td><td  width='50%'>$rs[ReportingError_Native]</td></tr>
<tr><td  width='50%'>ReportingError Corrective</td><td  width='50%'>$rs[ReportingError_Corrective]</td></tr>

<br>
    
	";
		}
		?>

</table>
<?php
  	$sql ="SELECT * FROM ReportingError WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND id='$_GET[id]'";
		$qsql = mysqli_query($con,$sql);
		while($rs = mysqli_fetch_array($qsql))
		{
	    $sql1 ="SELECT * FROM site_users WHERE userno='$rs[entered_by]'";
		$qsql1 = mysqli_query($con,$sql1);
		if($rs1 = mysqli_fetch_array($qsql1))
		{
		    
		 echo"<h5><b> Created & Updated </b><h5>
		 <table id='example2' class='table table-bordered table-hover'>
		 <tr><td width=50%><b>By :</b>$rs1[name] </b><td width='50%'><b>At :</b> $rs[created_at] </tr>";   
		    
		}
		}
		?>
		</table>
</div>