<?php session_start();
require_once('../DBManager.php');
require_once('../LoginManager.php');
include 'header.php';
include("dbconnection.php");
?>
  	
  	
<?php
    include("dbconnection.php");
require_once('../DBManager.php');
require_once('../LoginManager.php');
$narayan=LoginManager::currentUser();
$usertype=LoginManager::getUserTypeByuname("$narayan");
	$sql1 ="SELECT * FROM site_users WHERE userno='$usertype'";
		$qsql1 = mysqli_query($con,$sql1);
		while($re = mysqli_fetch_array($qsql1))
		{
		$sql2 ="SELECT * FROM site_users WHERE entered_by='$re[entered_by]' AND usertype='Hospital'";
		$qsql2 = mysqli_query($con,$sql2);
		if($re1 = mysqli_fetch_array($qsql2))
		{
		    if(Hospital==$re1[usertype])
{
?>
	  <?php
	include 'dashboarddocument.php';
		?>
          <?php
}
}
		}
	?>
            <?php
    include("dbconnection.php");
require_once('../DBManager.php');
require_once('../LoginManager.php');
$narayan=LoginManager::currentUser();
$usertype=LoginManager::getUserTypeByuname("$narayan");
	$sql1 ="SELECT * FROM site_users WHERE userno='$usertype'";
		$qsql1 = mysqli_query($con,$sql1);
		while($re = mysqli_fetch_array($qsql1))
		{
		$sql2 ="SELECT * FROM site_users WHERE entered_by='$re[entered_by]' AND usertype='LABORATORY'";
		$qsql2 = mysqli_query($con,$sql2);
		if($re1 = mysqli_fetch_array($qsql2))
		{
		    if(LABORATORY==$re1[usertype])
{
?>

	  <?php
	include 'patient_menu.php';
		?>
          <?php
}
}
		}
	?>
		    
	

	
  	  	
  		<?php 
		session_start();
$DisplayForm=True;
	$sql ="SELECT * FROM investigation WHERE id='$_GET[id]'";
		$qsql = mysqli_query($con,$sql);
		if($rs = mysqli_fetch_array($qsql))
		{
$sql1 ="SELECT * FROM pathreportfinal WHERE requesttestid='$rs[id]'";
		$qsql1 = mysqli_query($con,$sql1);
		if($rh1 = mysqli_fetch_array($qsql1))
		{
	$DisplayForm=False;
echo "";
}
if($DisplayForm)
{
echo "<script>window.location='create_report.php?prescriptionid=$rs[prescriptionid]&patientid=$rs[patientid]&id=$rs[id]'</script>;</script>";
} else{
?> 



      <style>
       .center {
   border: 1px solid grey;
   text-align:;
}
    .center2 {
   border: 5px solid grey;
   text-align:;
}
</style>


<div class="content-wrapper">
    <!-- Content Header (Page header) -->
          <div class='center'>
	<table id='example2' class='table table-bordered table-hover'>
					     <tr>
					 <th>Test Description </th>
					 <th>Unit  </th>
					 <th>Result  </th>
					 <th>Normal Value  </th>
					 	 	 </tr>	 
					 	 	 	 <?php
					 	 	 	 session_start();
				include("dbconnection.php");
					$sql ="SELECT * FROM investigation WHERE id='$_GET[id]'";
		$qsql = mysqli_query($con,$sql);
		while($rs = mysqli_fetch_array($qsql))
		{
		    	$sql1 ="SELECT * FROM pathreportfinal WHERE requesttestid='$rs[id]'";
		$qsql1 = mysqli_query($con,$sql1);
		while($rsi = mysqli_fetch_array($qsql1))
		{
		  	$sql3 ="SELECT * FROM Test_Description_final WHERE testdesid='$rsi[testid]'";
		$qsql3 = mysqli_query($con,$sql3);
		while($rspi = mysqli_fetch_array($qsql3))
		{
		       $sql2 ="SELECT * FROM patient WHERE patientid='$rs[patientid]'";
		$qsql2 = mysqli_query($con,$sql2);
		while($rspi1 = mysqli_fetch_array($qsql2))
		{
		   
			echo" <tr> <td>$rspi[Test_Description]
		</td>
			      <td>$rsi[unit]</td>
			          <td>$rsi[result]</td>
			      <td>";echo"$rsi[min]-$rsi[max]
			     </td>
			      </tr>";
		}
		}
		}
		}
		?>
	
			
	</table>
	 
</div>
<?php
}
}
?>