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

       	  
	  
<input type="search" data-table="order-table" placeholder="Search" />


 <table  class="order-table table table-bordered table-hover css-serial">
     
                  <tr>
                         <tr> <th>SR No</th>
          <th><div align="center">OT Details </div></th>
          <th><div align="center">Patient Details</div></th>
          <th><div align="center">Proposed Surgery  </div></th>
                  <th><div align="center">Details </div></th>
               </tr>
   

<?php
include("dbconnection.php");
require_once('../DBManager.php');
require_once('../LoginManager.php');
$narayan12=LoginManager::currentUser();
$usertype12=LoginManager::getUserTypeByuname("$narayan12");
$today = date('Y-m-d');
		       	$sql91 ="SELECT * FROM site_users WHERE userno='$usertype12'";
		$qsql91 = mysqli_query($con,$sql91);
		if($re91 = mysqli_fetch_array($qsql91))
		{
		    $sql2190 ="SELECT * FROM discharge WHERE hospital_id='$re91[entered_by]'";
		$qsql2190 = mysqli_query($con,$sql2190);
		while($rs = mysqli_fetch_array($qsql2190))
		{
		   
		    $sql3 ="SELECT * FROM potential WHERE  prescriptionid='$rs[prescriptionid]' AND date(operative_date) = '$_GET[dateid]'";
		$qsql3 = mysqli_query($con,$sql3);
		while($rsr = mysqli_fetch_array($qsql3))
		{
		 
	    $sql5 ="SELECT * FROM patient WHERE patientid='$rsr[patientid]'";
		$qsql5 = mysqli_query($con,$sql5);
		while($rp = mysqli_fetch_array($qsql5))
		{
        echo " 
        <tr>
                  <td>&nbsp;</td>
                 <td><b>Created at:</b> $rs[created_at]
                 <br><b>Created By:</b> $re[name] 
                 <br><b>Under Doctor :</b> $rsdoctor[name]</td>
                 <td><b>UHID :</b> $ra[patientid]
                 <br><b>Patient Name</b> $rp[patientname]<b>
                 <br>Age :</b> $rp[dob]<br>
                 <b>Gender :</b> $rp[gendor]<br><b>Guardian :</b>  $rp[HusbandName]</td>
                                                 						<td><a href='treatment_timline.php?prescriptionid=$rs[prescriptionid]&patientid=$rs[patientid]'>View</td>
                					  
          </tr>     
	                               
          ";


}
		    
		}
		    
	
	
}
}
}
?>  
</table>