<?php
session_start();
require_once("../dbconnection.php");
require_once('../DBManager.php');
require_once('../LoginManager.php');
?>
	      
	      	
<?php
include("dbconnection.php");
require_once('../DBManager.php');
require_once('../patientmanager.php');
include("header.php");
include("dashboarddocument.php");
?>
<?php
include("dbconnection.php");
if(isset($_GET[delid]))
{
	$sql ="DELETE FROM patient_invace WHERE invaceid='$_GET[delid]'";
	$qsql=mysqli_query($con,$sql);
	if(mysqli_affected_rows($con) == 1)
	{
		echo "<script>alert('Deleted successfully..');</script>";
	}
}
?>
 <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">

 <!-- /.card-header -->
              <div class="card-body">
                <table id="example2" class="table table-bordered table-hover">
                  <thead>
                  <tr>
             <th><strong>Created At <br>Created By</strong></th>
          <th><strong>Investigation & Charges</strong></th>
            <th><strong>Status</strong></th>
       <th><strong><section class="content-header">Action</section> </strong></th>             
        </tr>
      
                  </thead>
<?php
include("dbconnection.php");
$sql ="SELECT * FROM addaspatient WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
    	$sqlpatient2 = "SELECT * FROM patient_invace WHERE prescriptionid='$rs[prescriptionid]' AND 	discription='Investigation_charge'";
	$qsqlpatient2 = mysqli_query($con,$sqlpatient2);
	while($rsp2 = mysqli_fetch_array($qsqlpatient2))
	{
	    
	$sqlpatient1 = "SELECT * FROM site_users WHERE userno='$rs[entered_by]'";
	$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
	while($rsn = mysqli_fetch_array($qsqlpatient1))
	{
	    $pricedue=$rsp2[pricetotal];
            echo " <tbody>
            <tr>   <td>&nbsp;$rsp2[created_at] <br>$rsn[name]</td>
              		<td>&nbsp;
              		";
            	  if (is_numeric($rsp2[pagetype]))
{
$sql1 ="SELECT * FROM list_Investigation WHERE ivid='$rsp2[pagetype]'";
		$qsql1 = mysqli_query($con,$sql1);
	while($rh1 = mysqli_fetch_array($qsql1))
echo "$rh1[Investigation]";
}
            	 echo "<b>-$rsp2[pricetotal]&nbsp; </b></td>
              			<td>
              			";$usertype=$rsp2['status'];
if($usertype == 'Paid'){
    echo "Paid";
} else{
    echo "Due <b>$pricedue</b>";
}
         echo "</td>
              						<td><section class='content-header'><a href='$rsp2[link]&invaceid=$rsp2[invaceid]' >View</a> | <a href='edit_$rsp[link]'>Edit</a> <br> <a href='billingset.php?prescriptionid=$rsp2[prescriptionid]&patientid=$rsp2[patientid]&delid=$rsp2[invaceid]'>Delete</a></section></td>
          </tr>                   
          
          ";
}
}
}
?>    </tbody>
  <tfoot>
          </tfoot>
        </table>
        <br>
    <a href="#"><h1 Align="center"><i class="fa fa-file-pdf-o" aria-hidden="true"></i> View All </h1></h1></a>
      </div>