<?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>Fee</th>
          <th>Patient Details</th>
                <th>Details </th>
               </tr>
   
   </table>
   
   

          <?php 
include("header.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))
		{
  $sql7="SELECT * FROM discharge  WHERE hospital_id='$re12[entered_by]' AND admissiondate='$_GET[from_date]'";
  	$qsql7 = mysqli_query($con,$sql7);
	while($re7 = mysqli_fetch_array($qsql7))
	 $sql78="SELECT count('id') FROM CovidChecklist  WHERE prescriptionid='$re7[prescriptionid]'";
$result45=mysqli_query($con,$sql78); 
$row1=mysqli_fetch_array($result45);
  $sql78="SELECT count('accessid') FROM accesspatient  WHERE adminid='$re12[entered_by]'   AND date(created_at) = '$_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');
$narayan=LoginManager::currentUser();
$usertype=LoginManager::getUserTypeByuname("$narayan");
$today = date('Y-m-d');
	$sql1 ="SELECT * FROM site_users WHERE userno='$usertype'";
		$qsql1 = mysqli_query($con,$sql1);
		if($re = mysqli_fetch_array($qsql1))
		{
		    $sql7="SELECT * FROM discharge  WHERE hospital_id='$re12[entered_by]' AND admissiondate='$_GET[from_date]'";
  	$qsql7 = mysqli_query($con,$sql7);
	while($re7 = mysqli_fetch_array($qsql7))
	{
		$sql2 ="SELECT * FROM CovidChecklist  WHERE prescriptionid='$re7[prescriptionid]'";
		$qsql2 = mysqli_query($con,$sql2);
		while($rs = mysqli_fetch_array($qsql2))
		{
	  	$sql9 ="SELECT * FROM site_users WHERE userno='$rs[entered_by]'";
		$qsql9 = mysqli_query($con,$sql9);
		while($re9 = mysqli_fetch_array($qsql9))
		{
	    $sql4 ="SELECT * FROM patient WHERE patientid='$rs[patientid]'";
		$qsql4 = mysqli_query($con,$sql4);
		while($rp = mysqli_fetch_array($qsql4))
		{
        echo " 
	                <tr>
               <td>&nbsp;&nbsp;</td>
                 <td><b>UHID :</B>$rp[patientid]
                 <br>
            <b>Patient Name </b><br>$rp[patientname]
            <br> <b>Age /Sex &nbsp; </b>$rp[dob] $rp[gendor] </td>
            <td> 	$rs[typevisit]-$rs[casetype]</td>
                <td> <b>Created At</b>	$rs[created_at]<br>
               <b>Created By</b> $re9[name]</td>
                                      						<td><div class='btn-group'>
	  <button type='button' class='btn btn-default dropdown-toggle' data-toggle='dropdown' aria-haspopup='true' aria-expanded='false'>
	    Action <span class='caret'></span>
	  </button>
	  <ul class='dropdown-menu'>
	 	      <li><a href='#'> <i class='glyphicon glyphicon-save'></i> Note</a></li>
	  </ul>
	</div></td>
          </tr>                   
         
          ";


}
		    
		}
		    
		}

	    
}
}
?>     
</table>