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

 <table class="table table-borderd css-serial">
    
                  <tr>
               <th>SR No</th>
          <th>Created </th>
             <th>Patient Details</th>
        <th>Details </th>
               </tr>
    
<?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);
		if($re = mysqli_fetch_array($qsql1))
		{
		      $sql2190 ="SELECT * FROM discharge WHERE hospital_id='$re[entered_by]'  AND typevisit='OPD' AND updated_at='$_GET[dateid]' OR hospital_id='$re[entered_by]'  AND typevisit='Opd_Emergency' AND 	updated_at='$_GET[dateid]'";
		$qsql2190 = mysqli_query($con,$sql2190);
		while($rs = mysqli_fetch_array($qsql2190))
		{
		    $sql3 ="SELECT * FROM addaspatient WHERE  prescriptionid='$rs[prescriptionid]' "; 
		$qsql3 = mysqli_query($con,$sql3);
		while($rsr = mysqli_fetch_array($qsql3))
		{
		    
		    	$sqldoctor= "SELECT * FROM site_users WHERE userno='$rsr[Admitted_Under]'";
			$qsqldoctor = mysqli_query($con,$sqldoctor);
			while($rsdoctor = mysqli_fetch_array($qsqldoctor))
			{
			    $sql4 ="SELECT * FROM patient WHERE patientid='$rs[patientid]'";
		$qsql4 = mysqli_query($con,$sql4);
		while($rp = mysqli_fetch_array($qsql4))
		{
        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>