<?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>
                      <th>SR No</th>
                   <th>Admitted Under</th>
          <th>Patient Details</th>
                <th>Details </th>
               </tr>
   </table>
   
          <?php 
		session_start();
include("dbconnection.php");
include("header.php");
require_once('../../DBManager.php');
require_once('../../LoginManager.php');
$narayan=LoginManager::currentUser();
$usertype=LoginManager::getUserTypeByuname("$narayan");
	$sql19 ="SELECT * FROM site_users WHERE userno='$usertype'";
		$qsql19 = mysqli_query($con,$sql19);
	while($re12 = mysqli_fetch_array($qsql19))
		{
  $sql78="SELECT count('id') FROM discharge WHERE hospital_id='$re12[entered_by]'  AND typevisit='OPD' AND date(admissiondate) = '$_GET[dateid]' ";
$result45=mysqli_query($con,$sql78); 
$row1=mysqli_fetch_array($result45);
echo"Date : $_GET[dateid]";
if($row1[0]=='0')
{

    echo"<h1 align='center'>
  No Record Found</h1>";
}

echo "Total Patient : <b>$row1[0]</b>";
mysqli_close($con);
} 
	

?>
<table  class="order-table table table-bordered table-hover css-serial">
<?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[userno]'  AND typevisit='OPD' AND date(admissiondate) = '$_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='$rsr[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> $re91[name] 
                 <br><b>Under Doctor :</b> $rsdoctor[name]</td>
                 <td><b>UHID :</b> $rsr[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>