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

       	  

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




 
   
          <?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(*) medicine_charge WHERE hospital_Id='$re12[entered_by]'  AND status='1' AND date(saledate) = '$_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" id='myTable1'>
     
                   <tr>
               <th>SR No</th>
            <th>Towards</th>
             <th>Patient Details </th>
             <th>Amt</th>
        <th>Details  </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 medicine_charge WHERE hospital_Id='$re91[entered_by]'  AND status='1' AND date(saledate) = '$_GET[dateid]'";
		$qsql2190 = mysqli_query($con,$sql2190);
		while($rs1 = mysqli_fetch_array($qsql2190))
		{
		    $sql3 ="SELECT * FROM addaspatient WHERE  prescriptionid='$rs1[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))
		{
		    
		     $sql ="SELECT * FROM hco WHERE adminid='$rsdoctor[entered_by]'";
		$qsql = mysqli_query($con,$sql);
		if($rs = mysqli_fetch_array($qsql))
			{
		 $sql ="SELECT * FROM admin WHERE id='$rs[adminid]'";
		$qsql = mysqli_query($con,$sql);
		if($ra = mysqli_fetch_array($qsql))
		{
		    
		     $services ="SELECT * FROM `services` Where adminid='$ra[id]'";
		$qservices = mysqli_query($con,$services);
		if($rservices = mysqli_fetch_array($qservices))
		{ 
		 	    	
        echo " 
        <tr>
                  <td>&nbsp;</td>
                 <td><b>Created at:</b> $rs1[created_at]
                 <br><b>Created By:</b> $rservices[pharmacyName] 
                 <br><b>Status :</b> Sale<br><b>Medicine Name</b>: $rs1[MedicineName]
                 
                 <br><b>Payment mode</b>: $rs1[paymentmode]
                 </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> <b><i class='fa fa-inr' aria-hidden='true'></i></b> $rs1[FinalAmt]
                  <input type='hidden' name='amt' id='amt' class='amt' value='$rs1[FinalAmt]' />
                  </td>
                                                 						<td><a href='showpage_medicine_invoice.php?prescriptionid=$rs1[prescriptionid]&patientid=$rs1[patientid]&srno=$rs1[srno]'><i class='fa fa-eye' aria-hidden='true' style='font-size:20px; color:orange;padding:10px'></i></a></td>
                					  
          </tr>     
	                               
          ";


}
		    
		}
		    
	
	
}
}
} }}}
 
?>  

</table>
<span><b>Total Amt</b>    <b><i class='fa fa-inr'></i>  <span align='right' id='val1'></b></span></i> </span> 
<html>
<head>
	<title>Select only one checkbox at time</title>
	<script src="http://cdnjs.cloudflare.com/ajax/libs/jquery/2.1.3/jquery.min.js"></script>
</head>
<body>

</body>
</html>
    

  <script>
            
                  
var table = document.getElementById("myTable1"), sumVal1 = 0;

$(".amt").each(function() {
        sumVal1 += Number($(this).val());
       
     });
document.getElementById("val1").innerHTML = "" + sumVal1;
console.log(sumVal1);
          
        </script>

     <script src="https://code.jquery.com/jquery-3.5.1.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.0-beta1/dist/js/bootstrap.bundle.min.js"></script>