<!-- /.card-header -->
            
                <table class="table table-bordered table-hover" id="myTable">
               
                  <tr>
             <th><strong>Date & Time <br>Towards </strong></th>
          <th><strong>Consultant 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");
$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='Consultant_fees' OR prescriptionid='$rs[prescriptionid]' AND 	discription='visit_fees' ";
	$qsqlpatient = mysqli_query($con,$sqlpatient);
	while($rsp = mysqli_fetch_array($qsqlpatient))
	{
	$sqlpatient1 = "SELECT * FROM site_users WHERE userno='$rs[entered_by]'";
	$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
	while($rsn = mysqli_fetch_array($qsqlpatient1))
	{
	    	$sqlpatient123 = "SELECT * FROM site_users WHERE userno='$rs[Admitted_Under]'";
	$qsqlpatient123 = mysqli_query($con,$sqlpatient123);
	while($rsn123 = mysqli_fetch_array($qsqlpatient123))
	{
	    
	    $pricedue=$rsp[pricetotal];
            echo " <tbody>
            <tr>   <td>&nbsp;$rsp[created_at] <br>$rsp[discription]</td>
              		<td>$rsn123[name]<br>
              			";
              			$usertype=$rsp['status'];
if($usertype == 'Paid'){
    echo "Paid  <input class='price6' id='price6' name='price$rsn[invaceid]' type='hidden'  value='$rsp[pricetotal]'/>";
} else{
    echo "Due <b>$pricedue <input class='price7' id='price7' name='price$rsn[invaceid]' type='hidden'  value='$pricedue'/></b>";
}echo "</td>
              		 <td>&nbsp;$rsn[name]</td>
              						<td><section class='content-header'><a href='$rsp[link]' >Select</a> 
          </tr>                   
          
          ";
}
}
}
}
?>
  <tr><td>Due Amount :- <i class='fa fa-inr'></i>   <b> <span align='right' id="val7"></span> /-</b></td></tr>
    <tr><td>Paid Amount :- <i class='fa fa-inr'></i>   <b> <span align='right' id="val6"></span> /-</b></td></tr>
        </table>
        <br>
    <a href="#">

     
 <script>
     var table = document.getElementById("myTable"), sumVal6 = 0, sumVal7 = 0;
            
            
          
       $(".price6").each(function() {
                    sumVal6 += Number($(this).val());
                    });
            document.getElementById("val6").innerHTML = "" + sumVal6;
            console.log(sumVal6);
              
       $(".price7").each(function() {
                    sumVal7 += Number($(this).val());
                    });
            document.getElementById("val7").innerHTML = "" + sumVal7;
            console.log(sumVal7);
                        

</script>