<!-- /.card-header -->
            
                <table class="table table-bordered table-hover" id="myTable">
               
                  <tr>
             <th><strong>Date & Time <br>Towards </strong></th>
          <th><strong>Admission fees <br> & Status</strong></th>
            <th><strong>Assisted by </strong></th>
       <th><strong><section class="content-header">Action</section> </strong></th>             
        </tr> 
<?php
include("dbconnection.php");
if(isset($_GET[invaceid]))
{

	    	$sql1 ="DELETE FROM patient_invace WHERE invaceid='$_GET[invaceid]'";
	$qsql1=mysqli_query($con,$sql1);
	if(mysqli_affected_rows($con) == 1)
	{
		echo "<script>alert('Deleted successfully..');</script>";
	}
}

$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='Nurse Note' OR prescriptionid='$rs[prescriptionid]' AND 	discription='Ryles tube' OR prescriptionid='$rs[prescriptionid]' AND 	discription='FFP Transfusion' OR prescriptionid='$rs[prescriptionid]' AND 	discription='Electrotherapy laser' OR prescriptionid='$rs[prescriptionid]' AND 	discription='Electrotherapy' OR prescriptionid='$rs[prescriptionid]' AND 	discription='csf' OR prescriptionid='$rs[prescriptionid]' AND 	discription='IVP' OR prescriptionid='$rs[prescriptionid]' AND 	discription='Ventilator' OR prescriptionid='$rs[prescriptionid]' AND 	discription='Nebulization' OR prescriptionid='$rs[prescriptionid]' AND 	discription='BIPAP' OR prescriptionid='$rs[prescriptionid]' AND 	discription='Admission_fees' OR prescriptionid='$rs[prescriptionid]' AND 	discription='Oxygen'  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='Blood 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 Records'  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] <br>$rsp[discription]</td>
              		<td>&nbsp;";?>
              	<?php	include('master_hospital_Course_durtion.php'); ?>
              		  
		
	  <?php  echo "<br>
              		<input class='price2' id='price2' name='price$rsn[invaceid]' type='hidden'  value='$z'/>
              			";
              			$usertype=$rsp['status'];
if($usertype == 'Paid'){
    echo "Paid <input class='price3' id='price3' name='price$rsn[invaceid]' type='hidden'  value='$z'/>";
} else{
    echo "Due <b>$z</b>
    	<input class='price1' id='price1' name='price$rsn[invaceid]' type='hidden'  value='$z'/>
    ";
}echo "</td>
              		 <td>&nbsp;$rsn[name]</td>
              						<td><section class='content-header'><a href='$rsp[link]&invaceid=$rsp[invaceid]' ><i class='fa fa-plus-circle' aria-hidden='true' style='font-size:20px;color:green'></i></a> | <a href='view_hospital_Course.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&invaceid=$rsp[invaceid]'><i class='fa fa-eye' aria-hidden='true' style='font-size:20px'></i>
</a> | <a href='edit_hospital_Course.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&invaceid=$rsp[invaceid]'><i class='fa fa-pencil-square-o' aria-hidden='true' style='font-size:20px'></i></a> | <a href='billingset.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&invaceid=$rsp[invaceid]''><i class='fa fa-trash-o' aria-hidden='true' style='font-size:20px;color:red'></i></a>
          </tr>                   
          
          ";
}
}
}
?>
 <tr><td>Total Amount :- <i class='fa fa-inr'></i>   <b> <span align='right' id="val2"></span> /-</b></td></tr>
  <tr><td>Due Amount :- <i class='fa fa-inr'></i>   <b> <span align='right' id="val1"></span> /-</b></td></tr>
    <tr><td>Paid Amount :- <i class='fa fa-inr'></i>   <b> <span align='right' id="val3"></span> /-</b></td></tr>
      <tr><td><a href='HospitalCoursePay.php?prescriptionid=<?php echo $_GET['prescriptionid'] ?>&patientid=<?php echo $_GET['patientid'] ?>' class='btn btn-info'>Select</a></td></tr>
        </table>
        <br>
      
    <a href="#">

     
 <script>
     
          var table = document.getElementById("myTable"), sumVal2 = 0, sumVal1 = 0, sumVal3 = 0;
            
            $(".price2").each(function() {
                    sumVal2 += Number($(this).val());
                    });
            document.getElementById("val2").innerHTML = "" + sumVal2;
            console.log(sumVal2);
            
          
       $(".price1").each(function() {
                    sumVal1 += Number($(this).val());
                    });
            document.getElementById("val1").innerHTML = "" + sumVal1;
            console.log(sumVal1);
              
            $(".price3").each(function() {
                    sumVal3 += Number($(this).val());
                    });
            document.getElementById("val3").innerHTML = "" + sumVal3;
            console.log(sumVal3);        

     
 </script>