<!--$patientId=$_GET['Billno'];-->
<?php
session_start();
include("dbConfig.php");
if(isset($_SESSION['username']) && isset($_SESSION['name']))
{
    $username=$_SESSION['username'];
    $name=$_SESSION['name'];
}
else
{
     echo '<META http-equiv="refresh" content="0;logout.php">';
}
if (isset($_GET['Billno'])) {
    $billno = $_GET['Billno'];

    // Fetch the PatientId using BillNo
    $billQuery = mysqli_query($db, "SELECT PatientId FROM finalbill WHERE FinalBillNo='$billno' And is_deleted=1 ");
    if (mysqli_num_rows($billQuery) == 0) {
        echo "<script>alert('Invalid Bill Number!')</script>";
        $url = "/Billing/FinaleBillId.php";
        echo "<meta http-equiv=\"refresh\" content=\"0;url=$url\" />";
    } else {
        // Get the PatientId from the Bill
        $billData = $billQuery->fetch_assoc();
        $patientId = $billData['PatientId'];

        // Fetch patient details using the PatientId
        $query = mysqli_query($db, "SELECT * FROM patientdetails WHERE PatId='$patientId'");
        if (mysqli_num_rows($query) == 0) {
            echo "<script>alert('Patient details not found for the provided Bill Number!')</script>";
            $url = "/Billing/FinaleBillId.php";
            echo "<meta http-equiv=\"refresh\" content=\"0;url=$url\" />";
        } else {
            // Retrieve patient information
            while ($row = $query->fetch_assoc()) {
                $patid = $row['PatId'];
                $title = $row['title'];
                $Pname = $row['Name'];
                $contact1 = $row['Contact'];
                $email = $row['Email'];
                $dob = $row['Dob'];
                $age = $row['Age'];
                $gender = $row['Gender'];
                $blood = $row['BloodGroup'];
                $Address = $row['Address'];
                $Consultant = $row['Consultant'];
                $PatientType = $row['PatientType'];
                $CaseType = $row['CaseType'];
                $AdmitDate = $row['AdmitDate'];
                $AdmitTime = $row['AdmitTime'];
                $discount = $row['DiscountAmount'];
            }

            // Calculate total advance amount
            $advanceAmount = 0;
            $advanceQuery = mysqli_query($db, "SELECT * FROM advance WHERE PatId='$patid'  And is_deleted=1 ");
            while ($row = $advanceQuery->fetch_assoc()) {
                $advanceAmount += $row['Amount'];
            }

            // Fetch bill details using the BillNo
            $qbill = mysqli_query($db, "SELECT * FROM finalbill WHERE FinalBillNo='$billno'  And is_deleted=1 ");
            while ($row = $qbill->fetch_assoc()) {
                $total = $row['TotalAmount'];
                $insuranceAmt = $row['insuranceAmt'];
                $fdiscount = $row['DiscountAmount'];
                $advance = $row['AdvanceAmount'];
                $payablef = $row['PayableAmount'];
                $distime = $row['DischargeTime'];
                $FinalBillno = $row['FinalBillNo'];
                $disdate = $row['DischargeDate'];
                $paymentmode = $row['PaymentMode'];
                $InsuranceName = $row['InsuranceName'];
                $InsuranceNo = $row['InsuranceNo'];
                $bank = $row['bank'];
                $cardno = $row['cardno'];
                $upi = $row['upi'];
                $cash = $row['cash'];
            }

            // Fetch the list of bills associated with the patient
            $res1 = mysqli_query($db, "SELECT * FROM bill WHERE PatientId='$patid'  And is_deleted=1 ");
            if (mysqli_num_rows($res1) != 0) {
                while ($row = $res1->fetch_assoc()) {
                    $BillNo[] = $row['BillNo'];
                }
            }
        }


?>
<!DOCTYPE html>
<html>
<head>
  <title>
    
  </title>
  <meta charset="UTF-8">
  <link href="assets/img/favicon.png" rel="icon">
  <link href="assets/img/apple-touch-icon.png" rel="apple-touch-icon">
  <script src='https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js'></script>
<script src='https://cdnjs.cloudflare.com/ajax/libs/jquery/3.2.1/jquery.min.js'></script>
<link href='https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.0.3/css/font-awesome.css'>
<link href='https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css'>
  <!-- Google Fonts -->
  <link href="https://fonts.googleapis.com/css?family=Open+Sans:300,300i,400,400i,700,700i|Raleway:300,400,500,700,800|Montserrat:300,400,700" rel="stylesheet">
<link href='https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css'>
<link href='https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.0.3/css/font-awesome.css'>

  <!-- Vendor CSS Files -->
  <link href="assets/vendor/bootstrap/css/bootstrap.min.css" rel="stylesheet">
  <link href="assets/vendor/ionicons/css/ionicons.min.css" rel="stylesheet">
  <link href="assets/vendor/animate.css/animate.min.css" rel="stylesheet">
  <link href="assets/vendor/font-awesome/css/font-awesome.min.css" rel="stylesheet">
  <link href="assets/vendor/venobox/venobox.css" rel="stylesheet">
  <link href="assets/vendor/owl.carousel/assets/owl.carousel.min.css" rel="stylesheet">
  <link href="assets/vendor/boxicons/css/boxicons.min.css" rel="stylesheet">
  <script src="https://code.jquery.com/jquery.min.js"></script>
  <script src="jquery.dependent.fields.js"></script>
  <!-- Template Main CSS File -->
  <link href="assets/css/style.css" rel="stylesheet">
  <script src="https://code.jquery.com/jquery.min.js"></script>
<script src="jquery.dependent.fields.js"></script>
<style type="text/css">
    .nav-menu a {
        padding: 3px 3px;
    }
    
    .patientde{
        border:1px solid black;
        }
        
        .patientamt{
            border:2px solid black;
        }
        
        .patientde tr td{
            border:1px solid black;
        }
        
        .patientamt tr td{
            border:2px solid black;
        }
        
        
        .patientde tr td{
            border:1px solid black;
        }
        
        .patientde thead th {
            vertical-align: bottom !important;
            border: 1px solid black !important;
        }
    
    
    .footer {
       position: fixed;
       left: 0;
       bottom: 0;
       width: 100%;
       background-color: #efe8e8;
       color: black;
       text-align: center;
       padding:4px;
       font-size:12px;
    }.footer a{
      font-weight: bold;
      color:#0c0c67;
    }
      .hide {
      display: none;
    }
    h4{
      padding-top: 5px;
      padding-bottom: 0px;
      color:#1abfbf;
      font-weight: bold;
    }
    hr{
      background-color:#1abfbf;
    }
     @media print {
                      #printPageButton {
                        display: none;
                      }
                    }
    .spanfont{
        font-size:25px;
    }
    table.patientamt th,
    table.patientamt td {
      border: 2px solid #000;
      text-align: left;
      padding: 8px;
    }
</style>

</head>
<body>
<div class="row" id="printPageButton" style="margin:5%;">
  <button  type="button" class="btn btn-primary" onclick="window.print()" >Print</button> &nbsp;&nbsp;&nbsp;
    <a href="index.php"><button type="button" class="btn btn-primary">Home</button></a>
</div>
  <section>
  <div class="row">
    <div class="col-md-1"></div>
    <div class="col-md-10">
     

  
    <div class="row">
      <div class="col-md-6 col-sm-6">
        <img src="assets/img/logo.png">
        <span class="spanfont"><b>Vidhyaranya Hospital PVT LTD.</b></span>
      </div>
     
      <div class="col-md-6 col-sm-6">
      <table>
      <tr>
        <td valign="top">Address</td>
          <td>:2876, 4th Cross, NS Road, Chamundipuram, Mysuru, Karnataka 570004</td>
      </tr>
     
      <tr>
        <td valign="top">Contact</td>
        <td>:+91-821 233 1655, +91-821 233 0555, +91 9035933963</td>
      </tr>
      <tr>
        <td>Unit</td>
        <td>:Mysore</td>
      </tr>

    </table>
      </div>
    </div>
    <div class="row mt-5">
        <div class="col-md-12 text-center">
            <? if($PatientType=="OPD"){
       echo '<label style="font-size:15pt"><b>OUT PATIENT PROVISIONAL BILL</b></label>';
      
            }
		elseif($PatientType=="IPD"){
		echo '<label style="font-size:15pt"><b>IN PATIENT FINAL BILL</b></label>';
		}
		else{
		echo '<label style="font-size:15pt"><b>PATIENT PROVISIONAL BILL</b></label>';
		}
        ?>
        </div>
    </div>
<hr>
<div class="row d-flex justify-content-between">
  <div class="col-md-6 col-sm-6 row1 text-left">
    <table>
    <tr>
      <td valign="top">Patient Id</td>
      <td valign="top">: <? echo $patid;?></td>
    </tr>
  <tr>
    <td valign="top">Name</td>
    <td valign="top">: <?php echo $title . ' ' . $Pname; ?></td>
  </tr>
  <tr>
    <td valign="top">Contact No.</td>
    <td valign="top">: <? echo $contact1;?></td>
  </tr>
  <?if($email!=""){?>
  <tr>
    <td valign="top">Email Id</td>
    <td valign="top">: <? echo $email;?></td>
  </tr>
  <?}?>
  <tr>
    <td valign="top">Address</td>
    <td valign="top">: <? echo $Address;?></td>
  </tr>
 <tr>
    <td valign="top">Gender/Age/Blood Group</td>
    <td valign="top">: <? echo $gender."/ ".$age." / ".$blood;?></td>
  </tr>

  <tr>
    <td valign="top">Consultant</td>
    <td valign="top">: <? echo $Consultant;?></td>
  </tr>
</table>
  </div>
  <div class="col-md-6 col-sm-6 row2 text-right">
    <table>   
 
  <tr>
    <td valign="top">Patient Type/Case Type</td>
    <td valign="top">: <? echo $PatientType."/ ".$CaseType;?></td>
  </tr>
  <tr>
    <td valign="top">Admit Date/Time</td>
    <td valign="top">: <? echo $AdmitDate.", ".$AdmitTime;?></td>
  </tr>
  <tr>
    <td valign="top">Payment Mode</td>
    <td valign="top">: <? echo  $paymentmode;?></td>
  </tr>
  <tr>
    <td valign="top">Discharge Date-Time</td>
    <td valign="top">: <? echo $disdate.", ".$distime;?></td>
  </tr>
  	<?
  	if($paymentmode=="Insurance"){
	echo "<tr><td>Insurance Name</td>";
	echo "<td>: $InsuranceName</td></tr>";
	echo "<tr><td>Number</td>";
	echo "<td>: $InsuranceNo</td></tr>";
	}
	
		if($paymentmode=="Card"){
	echo "<tr><td>Bank Name</td>";
	echo "<td>: $bank</td></tr>";
	echo "<tr><td>Card Number</td>";
	echo "<td>: $cardno</td></tr>";
	}
	
		if($paymentmode=="Cash and UPI"){
	echo "<tr><td>Cash Amount</td>";
	echo "<td>: $cash</td></tr>";
	echo "<tr><td>UPI Amount</td>";
	echo "<td>: $upi</td></tr>";
	}
	?>
  
    <tr>
    <td valign="top">Discharge Bill No</td>
    <td valign="top">: <? echo $FinalBillno;?></td>
  </tr>     
</table>
  </div>
</div>
<br>


<table class="table table-hover patientde">
  <thead>
    <th scope="col">Sl No.</th>
     <th scope="col">Particulars</th>
     <th scope="col">Consultant</th>
    <th scope="col">Quantity</th>
    <th scope="col">Price</th>
    <th scope="col">Amount</th>
  </thead>
  <tbody>
    <?
        $j=1;
        $total=0;
        for($bcount=0;$bcount<(sizeof($BillNo));$bcount++){
          $fetch=mysqli_query($db,"SELECT * FROM billparticulars where BillNo='$BillNo[$bcount]' ORDER BY Particulars");
          while($row=$fetch->fetch_assoc()){
        
            echo "<tr><td>".$j."</td>";
            echo "<td>".$row['Particulars']."</td>";
            echo "<td>".$row['consultant']."</td>";
            echo "<td>".$row['Quantity']."</td>";
            echo "<td>".$row['UnitPrice']."</td>";
            $amount=$row['Amount'];
            echo "<td>".$row['Amount']."</td>";
            echo "</tr>";
            $total+=$amount;
            $j++;
        }}
        if($advanceAmount!=0){
        $payable=$total-($advanceAmount+$discount);  
        }
        else{
          $payable=$total-$discount;
        }
    ?>

    <tr>
      <td></td>
      <td></td>
      <td></td>
      <td></td>
      <td>Sub Total</td>
      <td><? echo $total;?></td>
    </tr>
  </tbody>
</table>

<div class="row">
  <div class="col-md-6">
         <?php
// Initialize the total advance amount
$advanceAmount = 0;

// Fetch all advance records for the given patient ID
$advanceQuery = mysqli_query($db, "SELECT `BillNo`, `Amount`, `AdvanceDate`, `advanceTime`, `PaymentMode` FROM advance WHERE PatId='$patid' And  is_deleted=1");
$advances = [];

// Loop through the results and calculate the total advance amount
while ($row = $advanceQuery->fetch_assoc()) {
    $advances[] = $row;
    $advanceAmount += $row['Amount'];
}
?>

<table class="table table-bordered patientamt">
    <thead>
        <tr>
            <th>Bill Number</th>
            <th>Advance Date</th>
            <th>Time</th>
            <th>Payment Mode</th>
            
            <th>Advance Amount</th>
        </tr>
    </thead>
    <tbody>
        <?php
        // Check if there are any advances
        if (empty($advances)) {
            echo "<tr><td colspan='5'>No advance records found.</td></tr>";
        } else {
            // Display each advance record
            foreach ($advances as $advance) {
                echo "<tr>";
                echo "<td>" . htmlspecialchars($advance['BillNo']) . "</td>"; // Bill Number
             
                echo "<td>" . htmlspecialchars($advance['AdvanceDate']) . "</td>"; // Advance Date
                echo "<td>" . htmlspecialchars(date('h:i A', strtotime($advance['advanceTime']))) . "</td>"; // Advance Time
                echo "<td>" . htmlspecialchars($advance['PaymentMode']) . "</td>"; // Payment Mode
                   echo "<td>" . htmlspecialchars($advance['Amount']) . "</td>"; // Advance Amount
                echo "</tr>";
            }

            // Display the total advance amount in the last row
            echo "<tr>";
            echo "<td colspan='4'><strong>Grand Total</strong></td>";
            echo "<td><strong>" . htmlspecialchars($advanceAmount) . "</strong></td>";
            echo "</tr>";
        }
        ?>
    </tbody>
</table>

  </div>
  <div class="col-md-6">
    <?php 
        if($paymentmode=="Insurance"){
    ?>
    <table class="table table-bordered patientamt">
      <tr>
        <td>Total Bill Amount</td>
        <td><? echo $total;?></td>
      </tr>
      
      <tr>
        <td>Insurance Claim Amount</td>
        <td><? echo $insuranceAmt;?></td>
      </tr>
      <tr>
        <td>Discount Amount</td>
        <td><? echo $fdiscount;?></td>
      </tr>
      
      <tr>
        <td>Final Paid Amount</td>
        <td><? echo $finalamt =$payablef;?></td>
      </tr>
    </table>
   
    
    <?php }else{ ?>
    <table class="table table-bordered patientamt">
      <tr>
        <td>Total Bill Amount</td>
        <td><? echo $total;?></td>
      </tr>
        <tr>
        <td>Advance Amount</td>
        <td><? echo $advanceAmount;?></td>
      </tr>
      
      <tr>
        <td>Final Paid Amount</td>
        <td><? echo $payable;?></td>
      </tr>
    </table>
    
    
    <?php } ?>
      
    


  </div>
</div>
<br><br><br>
<!--<p>Prepared by <?echo $name?></p><br><br>-->


<div class="row d-flex justify-content-between">
  <div class="col-md-6 text-left"></div>
  <div class="col-md-6 text-right">
   <h6>Authorized Signatory</h6> <br>
  <h6> Prepared by <?echo $name?><h6>
  </div>
  <!--<div class="col-md-4">-->

    
  <!--</div>-->
</div>
<br><br><br><br>

    
    <div class="col-md-1"></div>
    
  </div>
</div>
    
    


</section>

 <script src='https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js'></script>
  <script src='https://cdnjs.cloudflare.com/ajax/libs/jquery/3.2.1/jquery.min.js'></script>
  <script src="assets/vendor/jquery/jquery.min.js"></script>
  <script src="assets/vendor/bootstrap/js/bootstrap.bundle.min.js"></script>
  <script src="assets/vendor/jquery.easing/jquery.easing.min.js"></script>
  <script src="assets/vendor/php-email-form/validate.js"></script>
  <script src="assets/vendor/wow/wow.min.js"></script>
  <script src="assets/vendor/venobox/venobox.min.js"></script>
  <script src="assets/vendor/owl.carousel/owl.carousel.min.js"></script>
  <script src="assets/vendor/jquery-sticky/jquery.sticky.js"></script>
  <script src="assets/vendor/superfish/superfish.min.js"></script>
  <script src="assets/vendor/hoverIntent/hoverIntent.js"></script>
  <script src="assets/vendor/isotope-layout/isotope.pkgd.min.js"></script>
  <script src="assets/js/main.js"></script>
</body>
</html>
<?

}}
?>