<?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">
     
                
   
   </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))
		{
  $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"<h3 align='right'><b>Date :</b> $_GET[dateid]</h3>";
if($row1[0]=='0')
{

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

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

?>
  <table  class="order-table table table-bordered table-hover css-serial"> 
  
      <tr>
                      <th>SR No</th>
                <th>Patient <br> Details</th>
                <th>Towords </th>
                  <th>Note </th>
                    <th><section class="content-header">Action </section></th>
               </tr>
<?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))
		{
		    		     
		$sql2 ="SELECT * FROM accesspatient  WHERE adminid='$re[entered_by]' AND  date(created_at) = '$_GET[dateid]' ";
		$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] <br> <b>Created At</b>	$rs[created_at]<br>
               <b>Created By</b> $re9[name]</td>
         <td>"; $sql41 ="SELECT * FROM carrectivepreventive WHERE id='$rs[accessid]' AND toward='accesspatient'";
		$qsql41 = mysqli_query($con,$sql41);
		while($rp1 = mysqli_fetch_array($qsql41))
		{
		    echo"$rp1[note]
		    ";
		    }echo"</td>                             						<td><section class='content-header'><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='carrectivepreventive.php?toward=accesspatient&id=$rs[accessid]'> <i class='glyphicon glyphicon-save'></i> Note</a></li>
	  </ul>
	</div></section></td>
          </tr>                   
         
          ";


}
		    
		}
		    
		}

	    
}

?>     
</table>