<!--$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'])){
    
   $patientId=$_GET['Billno'];

    $query=mysqli_query($db,"SELECT * FROM patientdetails WHERE PatId='$patientId' OR Contact='$contact'");
    if(mysqli_num_rows($query)==0){
      echo "<script>alert('Incorrect Patient ID or Contact Number!')</script>"; 
        $url="/Billing/FinaleBillId.php";
    echo "<meta http-equiv=\"refresh\" content=\"0;url=$url\" />";
    }else{

    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'];
    
    }
    $advanceAmount=0;
    $advance=mysqli_query($db,"SELECT * FROM advance WHERE PatId='$patid'");
    while($row=$advance->fetch_assoc()){
        $advanceAmount+=$row['Amount'];
    }
    
    $qbill=mysqli_query($db,"SELECT * FROM finalbill WHERE PatientId='$patientId'");
    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'];
    }
    
    
    
    $res1=mysqli_query($db,"SELECT * FROM bill where PatientId='$patid'");
    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;
}
</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">Website</td>
        <td>:www.vidhyaranya</td>
      </tr>
      <tr>
        <td valign="top">Contact</td>
        <td>:+91-821 233 1655</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"></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>Patient Payable 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>Patient Payable 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>
<?

}}
?>