<?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'];
        $is_died = $row['is_died'];
        $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">
                <?php 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">: <?php 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">: <?php echo $contact1; ?></td>
                  </tr>
                  <?php if ($email != "") { ?>
                    <tr>
                      <td valign="top">Email Id</td>
                      <td valign="top">: <?php echo $email; ?></td>
                    </tr>
                  <?php } ?>
                  <tr>
                    <td valign="top">Address</td>
                    <td valign="top">: <?php echo $Address; ?></td>
                  </tr>
                  <tr>
                    <td valign="top">Gender/Age/Blood Group</td>
                    <td valign="top">: <?php echo $gender . "/ " . $age . " / " . $blood; ?></td>
                  </tr>

                  <tr>
                    <td valign="top">Consultant</td>
                    <td valign="top">: <?php 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">: <?php echo $PatientType . "/ " . $CaseType; ?></td>
                  </tr>
                  <tr>
                    <td valign="top">Admit Date/Time</td>
                    <td valign="top">: <?php echo $AdmitDate . ", " . $AdmitTime; ?></td>
                  </tr>
                  <tr>
                    <td valign="top">Payment Mode</td>
                    <td valign="top">: <?php echo  $paymentmode; ?></td>
                  </tr>
                  <tr>
                    <td valign="top">Discharge Status</td>
                    <td valign="top">:
                      <b>
                        <?php
                        $status = ($is_died == 1) ? 'Expired' : 'Discharged';
                        $color = ($status == 'Expired') ? 'text-danger' : 'text-success';
                        echo '<span class="' . $color . '">' . $status . '</span>';
                        ?>
                      </b>
                    </td>
                  </tr>
                  <tr>
                    <td valign="top">Discharge Date-Time</td>
                    <td valign="top">: <?php echo $disdate . ", " . $distime; ?></td>
                  </tr>
                  <?php
                  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">: <?php 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>
                <?php
                $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><?php 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><?php echo $total; ?></td>
                    </tr>

                    <tr>
                      <td>Insurance Claim Amount</td>
                      <td><?php echo $insuranceAmt; ?></td>
                    </tr>
                    <tr>
                      <td>Discount Amount</td>
                      <td><?php echo $fdiscount; ?></td>
                    </tr>

                    <tr>
                      <td>Final Paid Amount</td>
                      <td><?php echo $finalamt = $payablef; ?></td>
                    </tr>
                    <?php
                    $qbill = mysqli_query($db, "SELECT * FROM finalbill WHERE PatientId='$patientId'  AND `is_deleted` = 1");

                    $row = $qbill->fetch_assoc();
                    // Check if Finalpaymentmode has a value
                    if (!empty($row['Finalpaymentmode'])) {
                      echo "<tr>";
                      echo "<td>Final Payment Mode</td>";
                      echo "<td>" . htmlspecialchars($row['Finalpaymentmode']) . "</td>";
                      echo "</tr>";

                      // Handling different payment types
                      $fbilltype = $row['Finalpaymentmode'];

                      if ($fbilltype == "Cash") {
                        echo "<tr><td>Cash Amount</td><td>" . htmlspecialchars($finalamt) . "</td></tr>";
                      } elseif ($fbilltype == "Card") {
                        echo "<tr><td>Bank Name</td><td>" . htmlspecialchars($row['Finalbank']) . "</td></tr>";
                        echo "<tr><td>Card Number</td><td>" . htmlspecialchars($row['Finalcardno']) . "</td></tr>";
                        echo "<tr><td>Card Amount</td><td>" . htmlspecialchars($finalamt) . "</td></tr>";
                      } elseif ($fbilltype == "UPI") {
                        echo "<tr><td>UPI ID</td><td>" . htmlspecialchars($row['Finalupiid']) . "</td></tr>";
                        echo "<tr><td>UPI Amount</td><td>" . htmlspecialchars(round($row['Finalupi'])) . "</td></tr>";
                      } elseif ($fbilltype == "Cash and Card") {
                        echo "<tr><td>Bank Name</td><td>" . htmlspecialchars($row['Finalbank']) . "</td></tr>";
                        echo "<tr><td>Card Number</td><td>" . htmlspecialchars($row['Finalcardno']) . "</td></tr>";
                        echo "<tr><td>Card Amount</td><td>" . htmlspecialchars($row['Finalcardamount']) . "</td></tr>";
                        echo "<tr><td>Cash Amount</td><td>" . htmlspecialchars($row['Finalcashamount']) . "</td></tr>";
                      } elseif ($fbilltype == "Cash and UPI") {
                        echo "<tr><td>UPI Amount</td><td>" . htmlspecialchars($row['Finalupi']) . "</td></tr>";
                        echo "<tr><td>Cash Amount</td><td>" . htmlspecialchars($row['Finalcash']) . "</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 $advanceAmount; ?></td>
                    </tr>

                    <tr>
                      <td>Final Paid Amount</td>
                      <td><?php echo $payable; ?></td>
                    </tr>
                  </table>


                <?php } ?>




              </div>
            </div>
            <br><br><br>
            <!--<p>Prepared by <?php 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 <?php 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>
<?php

  }
}
?>