<!-- /.card-header -->

         <table class="table table-bordered table-hover" id="myTable">
               
                  <tr>
             <th><strong>Date & Time <br> </strong></th>
          <th><strong> Towards</strong></th>
  <th><strong> Status</strong></th>
       <th><strong><section class="content-header">Action</section> </strong></th>             
        </tr> 
<?php
include("dbconnection.php");
$sql ="SELECT * FROM addaspatient WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]'";
$qsql = mysqli_query($con,$sql);
if($rs = mysqli_fetch_array($qsql))
{
	$sqlpatient = "SELECT * FROM patient_invace WHERE prescriptionid='$rs[prescriptionid]' AND 	discription='Admission_fees' OR prescriptionid='$rs[prescriptionid]' AND 	discription='Oxyzen_Billing'  AND pricetotal!='0'  OR prescriptionid='$rs[prescriptionid]' AND 	discription='Catheterization'  AND pricetotal!='0' OR prescriptionid='$rs[prescriptionid]' AND 	discription='Physiotherapy'  AND pricetotal!='0' OR prescriptionid='$rs[prescriptionid]' AND 	discription='Dietician'  AND pricetotal!='0' OR prescriptionid='$rs[prescriptionid]' AND 	discription='Tranfusion'  AND pricetotal!='0' OR prescriptionid='$rs[prescriptionid]' AND 	discription='Dialysis'  AND pricetotal!='0' OR prescriptionid='$rs[prescriptionid]' AND 	discription='Dressing Small'  AND pricetotal!='0' OR prescriptionid='$rs[prescriptionid]' AND 	discription='Dressing Medium'  AND pricetotal!='0' OR prescriptionid='$rs[prescriptionid]' AND 	discription='Dressing Large'  AND pricetotal!='0' OR prescriptionid='$rs[prescriptionid]' AND 	discription='Suction'  AND pricetotal!='0' OR prescriptionid='$rs[prescriptionid]' AND discription='BI-PAP'  AND pricetotal!='0' OR prescriptionid='$rs[prescriptionid]' AND discription='CPAP'  AND pricetotal!='0' OR prescriptionid='$rs[prescriptionid]' AND discription='Echo Charges'  AND pricetotal!='0' OR prescriptionid='$rs[prescriptionid]' AND discription='ECT'  AND pricetotal!='0' OR prescriptionid='$rs[prescriptionid]' AND discription='Intubation'  AND pricetotal!='0' OR prescriptionid='$rs[prescriptionid]' AND discription='PAC'  AND pricetotal!='0' OR prescriptionid='$rs[prescriptionid]' AND discription='RBS'  AND pricetotal!='0'";
	$qsqlpatient = mysqli_query($con,$sqlpatient);
	while($rsp = mysqli_fetch_array($qsqlpatient))
	{
	$sqlpatient1 = "SELECT * FROM site_users WHERE userno='$rsp[entered_by]'";
	$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
	while($rsn = mysqli_fetch_array($qsqlpatient1))
	{
	    $pricedue=$rsp[pricetotal];
            echo " <tbody>
            <tr>   <td>&nbsp;$rsp[created_at] </td>
              		<td>Bed Charges</td><td>";
              			$usertype=$rsp['status'];
if($usertype == 'Paid'){
    echo "Paid <input class='price4' id='price4' name='price$rsn[invaceid]' type='hidden'  value='$rsp[pricetotal]'/>";
} else{
    echo "Due <b>$pricedue</b>
    <input class='price5' id='price5' name='price$rsn[invaceid]' type='hidden'  value='$pricedue'/>
    ";
}echo "</td>
              		 
              						<td><section class='content-header'><a href='$rsp[link]&invaceid=$rsp[invaceid]' >Select</a> |
              						<a href='updateBedCharges.php?patientid=$_GET[patientid]&prescriptionid=$_GET[prescriptionid]'>Add <i class='fa fa-plus-circle' aria-hidden='true'></i></a>
          </tr>                   
          
          ";
}
}
}
?>

  <tr><td>Due Amount :- <i class='fa fa-inr'></i>   <b> <span align='right' id="val5"></span> /-</b></td></tr>
    <tr><td>Paid Amount :- <i class='fa fa-inr'></i>   <b> <span align='right' id="val4"></span> /-</b></td></tr>
        </table>
    <a href="#">
<script>
     var table = document.getElementById("myTable"), sumVal4 = 0, sumVal5 = 0;
            
            
          
       $(".price5").each(function() {
                    sumVal5 += Number($(this).val());
                    });
            document.getElementById("val5").innerHTML = "" + sumVal5;
            console.log(sumVal5);
              
       $(".price4").each(function() {
                    sumVal4 += Number($(this).val());
                    });
            document.getElementById("val4").innerHTML = "" + sumVal4;
            console.log(sumVal4);
                        

</script>