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


?>

<?php
// Include database connection
include("dbconfig.php");

// Get the billno from the GET request
$billno = isset($_GET['billno']) ? $_GET['billno'] : '';

// Fetch bill details
$billQuery = "SELECT `BillId`, `BillNo`, `PatientId`, `PatientType`, `TotAmount`, `PaymentMode`, `BDate`, `BTime`, `PayableAmount`, `InsuranceName`, `InsuranceNo`, `bank`, `cardno`, `upi`, `cash`, `PreparedBy`, `upiid`, `cashamount`, `cardamount` FROM `bill` WHERE `BillNo` = '$billno'";
$billResult = mysqli_query($db, $billQuery);
$bill = mysqli_fetch_assoc($billResult);

// Fetch patient details
$patientQuery = "SELECT `SlNo`, `PatientId`, `title`, `Name`, `FHN`, `Contact`, `Email`, `Age`, `Gender`, `Address`, `Consultant`, `admitDate`, `AdmitTime`, `Createdat` FROM `opdpatientregister` WHERE `PatientId` = '{$bill['PatientId']}'";
$patientResult = mysqli_query($db, $patientQuery);
$patient = mysqli_fetch_assoc($patientResult);

// Fetch bill particulars
$particularQuery = "SELECT `SlNo`, `BillNo`, `PatId`, `Particulars`, `Quantity`, `UnitPrice`, `Amount`, `consultant` FROM `billparticulars` WHERE `BillNo` = '$billno' ORDER BY `Particulars`";
$particularResult = mysqli_query($db, $particularQuery);

?>
<!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>:vidhyaranyhospital.com</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">
           
      <label style="font-size:15pt"><b>OUT 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">: <?php echo $patient['PatientId']; ?></td>
      </tr>
      <tr>
        <td valign="top">Name</td>
        <td valign="top">: <?php echo $patient['title'] . ' ' . $patient['Name']; ?></td>
      </tr>
      <tr>
        <td valign="top">Contact No.</td>
        <td valign="top">: <?php echo $patient['Contact']; ?></td>
      </tr>
      <?php if ($patient['Email'] != "") { ?>
        <tr>
          <td valign="top">Email Id</td>
          <td valign="top">: <?php echo $patient['Email']; ?></td>
        </tr>
      <?php } ?>
      <tr>
        <td valign="top">Address</td>
        <td valign="top">: <?php echo $patient['Address']; ?></td>
      </tr>
      <tr>
        <td valign="top">Gender/Age/Blood Group</td>
        <td valign="top">: <?php echo $patient['Gender'] . " / " . $patient['Age']; ?></td>
      </tr>
      <tr>
        <td valign="top">Consultant</td>
        <td valign="top">: <?php echo $patient['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">: <?php echo $bill['PatientType']; ?></td>
      </tr>
      <tr>
        <td valign="top">Admit Date/Time</td>
        <td valign="top">: <?php echo $patient['admitDate'] . ", " . $patient['AdmitTime']; ?></td>
      </tr>
      <tr>
        <td valign="top">Payment Mode</td>
        <td valign="top">: <?php echo $bill['PaymentMode']; ?></td>
      </tr>
      <tr>
        <td valign="top">Discharge Date-Time</td>
        <td valign="top">: <?php echo $bill['BDate'] . ", " . $bill['BTime']; ?></td>
      </tr>
      <?php
        if ($bill['PaymentMode'] == "Insurance") {
          echo "<tr><td>Insurance Name</td><td>: " . $bill['InsuranceName'] . "</td></tr>";
          echo "<tr><td>Insurance No</td><td>: " . $bill['InsuranceNo'] . "</td></tr>";
        }
        if ($bill['PaymentMode'] == "Card") {
          echo "<tr><td>Bank Name</td><td>: " . $bill['bank'] . "</td></tr>";
          echo "<tr><td>Card Number</td><td>: " . $bill['cardno'] . "</td></tr>";
        }
        if ($bill['PaymentMode'] == "Cash and UPI") {
          echo "<tr><td>Cash Amount</td><td>: " . $bill['cashamount'] . "</td></tr>";
          echo "<tr><td>UPI Amount</td><td>: " . $bill['upiid'] . "</td></tr>";
        }
      ?>
      <tr>
        <td valign="top">Discharge Bill No</td>
        <td valign="top">: <?php echo $bill['BillNo']; ?></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>
    <?php
    $j = 1;
    $total = 0;
    while ($row = mysqli_fetch_assoc($particularResult)) {
      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>" . $amount . "</td>";
      echo "</tr>";
      $total += $amount;
      $j++;
    }

    // Calculate payable amount
    $payable = $total - ($bill['TotAmount'] + $bill['Discount']);  // Assuming Discount is available in the `bill` table

    ?>

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

<div class="row">
  <div class="col-md-6"></div>
  <div class="col-md-6">
    <?php 
    if ($bill['PaymentMode'] == "Insurance") {
    ?>
    <table class="table table-bordered patientamt">
      <tr>
        <td>Total Bill Amount</td>
        <td><?php echo $total; ?></td>
      </tr>
      <tr>
        <td>Insurance Claim Amount</td>
        <td><?php echo $bill['InsuranceAmount']; ?></td>
      </tr>
      <tr>
        <td>Discount Amount</td>
        <td><?php echo $bill['Discount']; ?></td>
      </tr>
      <tr>
        <td>Patient Payable Amount</td>
        <td><?php echo $payable; ?></td>
      </tr>
    </table>
    <?php } else { ?>
    <table class="table table-bordered patientamt">
      <tr>
        <td>Total Bill Amount</td>
        <td><?php echo $total; ?></td>
      </tr>
      <tr>
        <td>Advance Amount</td>
        <td><?php echo $bill['advanceAmount']; ?></td>
      </tr>
      <tr>
        <td>Patient Payable Amount</td>
        <td><?php 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>
<?

?>