<?php
session_start();
include("dbConfig.php");
if (isset($_SESSION['username']) && isset($_SESSION['name'])) {
  $username = $_SESSION['username'];
  $name = $_SESSION['name'];
}

$patid = $contact = $pname = $ptype = "";

if (isset($_GET['PatientID'])) {
  $patid = $_GET['PatientID'];
  $qu1 = mysqli_query($db, "SELECT * FROM patientdetails WHERE PatId='$patid'");

  if ($qu1 && mysqli_num_rows($qu1) > 0) {
    $row = $qu1->fetch_assoc();
    $contact = $row['Contact'];
    $pname = $row['Name'];
    $title = $row['title'];
    $ptype = "IPD";
  }
} elseif (isset($_GET['Contact'])) {
  $contact = $_GET['Contact'];
  $qu1 = mysqli_query($db, "SELECT * FROM patientdetails WHERE Contact='$contact'");

  if ($qu1 && mysqli_num_rows($qu1) > 0) {
    $row = $qu1->fetch_assoc();
    $patid = $row['PatId'];
    $title = $row['title'];
    $pname = $row['Name'];
    $ptype = "IPD";
  }
} elseif (isset($_GET['OPDpid'])) {
  $patid = $_GET['OPDpid'];
  $qu1 = mysqli_query($db, "SELECT * FROM opdpatientregister WHERE PatientId='$patid'");

  if ($qu1 && mysqli_num_rows($qu1) > 0) {
    $row = $qu1->fetch_assoc();
    $contact = $row['Contact'];
    $pname = $row['Name'];
    $title = $row['title'];
    $ptype = "OPD";
  }
} elseif (isset($_GET['OPDcon'])) {
  $contact = $_GET['OPDcon'];
  $qu1 = mysqli_query($db, "SELECT * FROM opdpatientregister WHERE Contact='$contact'");

  if ($qu1 && mysqli_num_rows($qu1) > 0) {
    $row = $qu1->fetch_assoc();
    $patid = $row['PatientId'];
    $title = $row['title'];
    $pname = $row['Name'];
    $ptype = "OPD";
  }
}
?>


<!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;
    }

    .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;
    }

    span {
      color: red;
    }
  </style>
</head>

<body>
  <div style="text-align: center">
    <img src="assets/img/logo.png" width="100px" height="100px">
  </div>
  <header id="header">

    <div class="container">
      <nav id="nav-menu-container">
        <ul class="nav-menu">
          <li class="menu-active">
            <a class="nav-link" style="padding:2;font-size:14px" href="index.php">Home</a>
          </li>
          <li class="menu-has-children">
            <a class="nav-link" style="padding:2;font-size:14px" href="#">IPD Patients</a>
            <ul>
              <li><a href="AddPatient.php">IPD Patient Registration</a></li>
              <li><a href="AddAdvance.php">IPD add Advance</a></li>
              <li><a href="UpdateWard.php">Update Ward</a></li>
              <li><a href="IPDPatients.php">View IPD Patients</a></li>

            </ul>
          </li>
          <li class="menu-has-children">
            <a class="nav-link" style="padding:2;font-size:14px" href="#">OPD Patients</a>
            <ul>
              <li><a href="OPDRegistration.php">OPD Patient Registration</a></li>
              <li><a href="OPDPatients.php">View OPD Patients</a></li>
            </ul>
          </li>
          <li class="menu-has-children">
            <a class="nav-link" style="padding:2;font-size:14px" href="#">Staff</a>
            <ul>
              <li><a href="AddStaff.php">Add Staff</a></li>
              <li><a href="StaffList.php">Staff List</a></li>
            </ul>
          </li>
          <li class="menu-has-children">
            <a class="nav-link" style="padding:2;font-size:14px" href="#">Billing</a>
            <ul>
              <li><a href="billingId.php">Generate Consolidate Bill</a></li>
              <li><a href="InvestigationId.php">Generate Investigation Bill</a></li>
              <li><a href="FinaleBillId.php">Generate Discharge Bill</a></li>
              <li><a href="SearchBill.php">Search Bill</a></li>
            </ul>
          </li>
          <li class="menu-has-children">
            <a class="nav-link" style="padding:2;font-size:14px" href="#">Particular</a>
            <ul>
              <li><a href="AddParticulars.php">Add Particulars</a></li>
              <li><a href="ViewParticulars.php">View Particulars</a></li>
            </ul>
          </li>
          <li class="menu-has-children">
            <a class="nav-link" style="padding:2;font-size:14px" href="#">Report</a>
            <ul>
              <li><a href="UploadReport.php">Upload Patient Report</a></li>
              <li><a href="DailyTrans.php">Transactions</a></li>
              <li><a href="userTrans.php">User Transactions</a></li>
              <li><a href="ViewReport.php">View Patient Reports</a></li>

            </ul>
          </li>
          <li class="menu-has-children">
            <a class="nav-link" style="padding:2;font-size:14px" href="#" style="font-size:15px"><? echo $name ?></a>
            <ul>
              <li><a href="logout.php">Logout</a></li>
              <li><a href="ResetPassword.php">Reset Password</a></li>
            </ul>
          </li>
        </ul>
      </nav><!-- #nav-menu-container -->
    </div>
  </header><!-- End Header -->
  <section>
    <div class="row">
      <div class="col-md-2"></div>
      <div class="col-md-8">
        <div class="shadow p-3 mb-5 bg-light rounded">






          <form method="POST" action="BillPreview.php">
            <h2 style="text-align: center;font-weight: bold;color:#fff;background-color: #1abfbf;padding:10px;">Generate Bill</h2>
            <h4>Patient Details</h4>
            <hr>

            <div class="col-md-10">
              <table class="table table-borderless">
                <tr>
                  <td>Patient Id</td>
                  <td>:<strong><?php echo $patid; ?></strong></td>
                  <td></td>
                  <td></td>
                  <td>Phone No</td>
                  <td>:<strong><?php echo $contact; ?></strong></td>
                  <input type="hidden" name="patid" value="<?php echo $patid; ?>">
                </tr>
                <tr>
                  <td>Patient Name</td>
                  <td>: <strong><?php echo $title . ' ' . $pname; ?></strong></td>

                  <td></td>
                  <td></td>
                  <td>Patient Type</td>
                  <td>:<strong><?php echo $ptype; ?></strong></td>
                </tr>
              </table>
            </div>

            <h4>Service Details</h4>
            <hr>
            <div class="row">
              <div class="form-group col">
                <label for="">Particulars<span>*</span></label>
                <select class="form-control" name="Particulars[]" required>
                  <option value="">Choose Option</option>
                  <?php
                  $qu2 = mysqli_query($db, "SELECT * FROM particulars ORDER BY Description ASC");
                  while ($row = $qu2->fetch_assoc()) {
                    $desp = $row['Description'];
                    // echo "<option value=\"$desp\">$desp</option>";
                    $price = $row['Price']; // Assuming 'Price' is a column in your particulars table
                    echo "<option value=\"$desp\" data-price=\"$price\">$desp</option>";
                  }
                  ?>
                </select>

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

                </select>
              </div>
              <div class="form-group col">
                <label for="">Quantity<span>*</span></label>
                <input class="form-control" type="text" name="Quantity[]" id="" required>
              </div>
              <div class="form-group col">
                <label for="">Consultant<span>*</span></label>
                <select class="form-control" name="consultant[]" required>
                  <option value="">Choose Option</option>
                  <?php
                  $qu2 = mysqli_query($db, "SELECT `doc_name` FROM `docotorslist`");
                  while ($row = $qu2->fetch_assoc()) {
                    $doc_name = $row['doc_name'];
                    $selected = ($doc_name == "VH") ? "selected" : "";
                    echo "<option value=\"$doc_name\" $selected>$doc_name</option>";
                  }
                  ?>
                </select>
              </div>



              <div class="form-group col">
                <label for="">Department<span></span></label>
                <select class="form-control" name="optionlab[]">
                  <option value="">Choose Option</option>
                  <option value="Radiology">Radiology </option>
                  <option value="Lab Test">Labouratory</option>
                  <option value="Cardiology">Cardiology</option>


                </select>
              </div>
              <!--<div class="form-group col">-->
              <!--</div>-->
            </div>
            <div class="input-group control-group after-add-more">
              <button class="btn btn-success add-more" type="button"><i class="glyphicon glyphicon-plus"></i>Add Particulars</button>
            </div><br>
            <!--<h4>Doctor Details</h4>
<hr>
<div class="row">
<div class="form-group col">
  <label for="">Doctor Name</label>
  <input  class="form-control" type="text" name="Doctor_name" id="">
</div>
<div class="form-group col">
</div>
</div>-->



            <br>
            <h4>Payment Details</h4>
            <hr>
            <div class="row">
              <div class="form-group col">
                <label for="">Bill Type<span>*</span></label>
                <select class="form-control" name="billtype" id="PaymentMode" required>
                  <option value="">Choose Option</option>
                  <option value="Cash">Cash</option>
                  <option value="Cash and UPI">Cash and UPI</option>
                  <option value="Card">Card</option>
                  <option value="UPI">UPI</option>
                  <option value="Cash and Card">Cash and Card</option>
                  <option value="Insurance">Insurance</option>
                  <option value="ABRK">ABARK</option>
                </select>
              </div>
            </div>
            <div class="row" id="InsDetails">
              <div class="form-group col">
                <label for="InsuranceName">Insurance Name<span>*</span></label>
                <input class="form-control" type="text" name="InsuranceName" id="InsuranceName">
              </div>
              <div class="form-group col">
                <label for="InsuranceNo">Insurance No<span>*</span></label>
                <input class="form-control" type="text" name="InsuranceNo" id="InsuranceNo">
              </div>

            </div>

            <div class="row" id="cardDetails">
              <div class="form-group col">
                <label for="bank">Bank Name<span>*</span></label>
                <input class="form-control" type="text" name="bank">
              </div>
              <div class="form-group col">
                <label for="cardno">Card No<span>*</span></label>
                <input class="form-control" type="text" name="cardno" id="cardno">
              </div>
            </div>
            <div class="row" id="upiCashDetails">
              <div class="form-group col">
                <label for="bank">Upi Amount<span></span></label>
                <input class="form-control" type="text" name="upi">
              </div>
              <div class="form-group col">
                <label for="cardno">Cash Amount<span></span></label>
                <input class="form-control" type="text" name="cash" id="cash">
              </div>

            </div>
             <div class="row" id="upiDetails">
              <div class="form-group col">
                <label for="upiid">UPI Transaction ID<span>*</span></label>
                <input class="form-control" type="text" name="upiid">
              </div>
              
            </div>

            <div class="row">
              <div class="form-group col">
                <label for="bdate">Date<span>*</span></label>
                <input class="form-control" type="date" name="bdate" id="bdate"  required>
              </div>
              <div class="form-group col">
                <label for="btime">Time<span>*</span></label>
                <input class="form-control" type="time" name="btime" id="btime" required>
              </div>
            </div>
            <!-- Add Total Amount Field -->
            <div class="row">
              <div class="form-group col">
                <label for="totalAmount">Total Amount</label>
                <input class="form-control" type="text" id="totalAmount" name="totalAmount" readonly>
              </div>
            </div>

            <div style="text-align: center">
              <button type="submit" class="btn btn-primary">Preview</button>
              <a href="invoice.php"><button type="button" class="btn btn-info">Cancel</button></a>
            </div>

          </form>
        </div>
      </div>
      <div class="col-md-2"></div>
    </div>
    <section>




      <div class="copy hide">
        <div class="control-group row">
          <div class="form-group col">
            <label for="">Particulars</label>
            <select class="form-control" name="Particulars[]">
              <option value="">Choose Option</option>
              <?php
              $qu2 = mysqli_query($db, "SELECT * FROM particulars");
              while ($row = $qu2->fetch_assoc()) {
                $desp = $row['Description'];
                // echo "<option value=\"$desp\">$desp</option>";
                $price = $row['Price']; // Assuming 'Price' is a column in your particulars table
                echo "<option value=\"$desp\" data-price=\"$price\">$desp</option>";
              }
              ?>
            </select>
          </div>
          <div class="form-group col">
            <label for="">Quantity</label>
            <input class="form-control" type="text" name="Quantity[]" id="">
          </div>
          <div class="form-group col">
            <label for="">Consultant</label>
            <select class="form-control" name="consultant[]">
            <option value="">Choose Option</option>
<?php
$qu2 = mysqli_query($db, "SELECT `doc_name` FROM `docotorslist`");
while ($row = $qu2->fetch_assoc()) {
    $doc_name = $row['doc_name'];
    $selected = ($doc_name == "VH") ? 'selected' : '';
    echo "<option value=\"$doc_name\" $selected>$doc_name</option>";
}
?>

            </select>
          </div>
          <div class="form-group col">
            <label for="">Radiology / Lab<span></span></label>
            <select class="form-control" name="optionlab[]">
              <option value="">Choose Option</option>
              <option value="Radiology">Radiology </option>
              <option value="Lab Test">Labouratory</option>
              <option value="Cardiology">Cardiology</option>

            </select>
          </div>
          <div class="input-group-btn col" style="margin-top:30px;">
            <button class="btn btn-danger remove" type="button"><i class="glyphicon glyphicon-remove"></i> Remove</button>
          </div>
        </div>
      </div>



    </section>

  </section>
  <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
  <script>
    $(document).ready(function() {
      // Function to calculate the total amount
      function calculateTotal() {
        var totalAmount = 0;

        // Loop through each set of Particulars and Quantity
        $('select[name="Particulars[]"]').each(function(index) {
          var price = $(this).find(':selected').data('price') || 0; // Get the price of the selected particular
          var quantity = $('input[name="Quantity[]"]').eq(index).val() || 0; // Get the corresponding quantity

          totalAmount += price * quantity; // Add to the total amount
        });

        // Update the total amount field
        $('#totalAmount').val(totalAmount.toFixed(2));
      }

      // Event listener for static and dynamically added Particulars or Quantity inputs
      $(document).on('change keyup', 'select[name="Particulars[]"], input[name="Quantity[]"]', function() {
        calculateTotal(); // Call the function on change or keyup event
      });

      calculateTotal();

    });
  </script>


  <script type="text/javascript">
    $(document).ready(function() {


      $(".add-more").click(function() {
        var html = $(".copy").html();
        $(".after-add-more").before(html);
      });


      $("body").on("click", ".remove", function() {
        $(this).parents(".control-group").remove();
      });


    });
  </script>
  <script type="text/javascript">
  $("#PaymentMode").change(function() {
  var paymentMode = $(this).val();

  // Hide all sections by default
  $('#InsDetails').hide();
  $('#cardDetails').hide();
  $('#upiCashDetails').hide();
  $('#upiDetails').hide();  // Hides UPI Amount section

  // Remove required attributes for all input fields
  $('#InsuranceName, #InsuranceNo').removeAttr('required');
  $('input[name="bank"], input[name="cardno"]').removeAttr('required');
  $('input[name="upi"], input[name="cash"]').removeAttr('required');
  $('input[name="upiid"]').removeAttr('required');  // Removes required from UPI Amount field

  if (paymentMode == "Insurance") {
    // Show insurance details and make fields required
    $('#InsDetails').show();
    $('#InsuranceName').attr('required', '');
    $('#InsuranceNo').attr('required', '');
  } else if (paymentMode == "Card") {
    // Show card details and make fields required
    $('#cardDetails').show();
    $('input[name="bank"]').attr('required', '');
    $('input[name="cardno"]').attr('required', '');
  } else if (paymentMode == "Cash and UPI") {
    // Show UPI and Cash details and make fields required
    $('#upiCashDetails').show();
    $('input[name="upi"]').attr('required', '');   // UPI ID required
    $('input[name="cash"]').attr('required', '');  // Cash amount required
  } else if (paymentMode == "UPI") {
    // Show only the UPI Amount section
    $('#upiDetails').show();  // Shows UPI Amount section
    $('input[name="upiid"]').attr('required', '');  // UPI Amount required
  }
});


    $("#PaymentMode").trigger("change");
  </script>
  <div class="footer">
    &copy; Copyright 2024 All Rights Reserved <strong>Vidyaranya Hospital PVt LTD.</strong>. | Designed by <a href="http://www.vatsinsoft.in/">Vatsin Soft</a>
  </div>
  <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>