<?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">';
}

?>


<!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">
span{
    color:red;
}
.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;
}

</style>
<script type="text/javascript">
  function validateForm() {
  var x = document.forms["checkForm"]["PatientId"].value;
  var y = document.forms["checkForm"]["con"].value;
  if (x == "" && y=="") {
    alert("Patient ID or Phone Number must be filled out");
    return false;
  }
}
</script>
</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="OPDPatientsList.php">View OPD Patients Lists</a></li>
            <li><a href="OPDPatients.php">View OPD Patients Bills</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="examintaion.php">Add Examination</a>
      </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">

<!---->
<?php
// Assume database connection is included here
include("dbConfig.php");

// Retrieve data from GET parameters
$billNo = $_GET['billNo'] ?? '';
$patId = $_GET['PatId'] ?? '';
$amount = $_GET['amount'] ?? '';

// Initialize examinationData as an empty array
$examinationData = [];

// Fetch data for the specific BillNo and PatientId if needed
$examQuery = "SELECT * FROM examination WHERE BillNo = '$billNo' AND PatId = '$patId'";
$examResult = mysqli_query($db, $examQuery);

// Check if the query was successful and there are results
if ($examResult) {
    // Populate fields if data exists
    while ($row = $examResult->fetch_assoc()) {
        $examinationData[] = $row;
    }

    if (empty($examinationData)) {
        echo "<script>alert('No examination data found for the specified Bill No and Patient ID.');</script>";
    }
} else {
    echo "<script>alert('Error fetching examination data: " . mysqli_error($db) . "');</script>";
}
?>

<h2>Edit Examination Details</h2>
<form method="POST" action="">
    <input type="hidden" name="billNo" value="<?php echo htmlspecialchars($billNo, ENT_QUOTES); ?>">
    <input type="hidden" name="PatId" value="<?php echo htmlspecialchars($patId, ENT_QUOTES); ?>">
    
    <table class="table">
        <thead>
            <tr>
                <th>Particulars</th>
                <th>Quantity</th>
                <th>Unit Price</th>
                <th>Total</th>
                <th>Consultant</th>
                <th>Department</th>
            </tr>
        </thead>
        <tbody>
            <?php foreach ($examinationData as $data): ?>
            <tr>
                <td>
                    <input type="text" class="form-control" name="Particulars[]" value="<?php echo htmlspecialchars($data['Particulars'], ENT_QUOTES); ?>" readonly>
                </td>
                <td>
                    <input type="number" class="form-control" name="Quantity[]" value="<?php echo htmlspecialchars($data['Quantity'], ENT_QUOTES); ?>" oninput="calculateTotal(this)">
                </td>
                <td>
                    <input type="text" class="form-control" name="UnitPrice[]" value="<?php echo htmlspecialchars($data['UnitPrice'], ENT_QUOTES); ?>" oninput="calculateTotal(this)">
                </td>
                <td>
                    <input type="text" class="form-control total-field" value="<?php echo htmlspecialchars($data['Quantity'] * $data['UnitPrice'], ENT_QUOTES); ?>" readonly>
                </td>
                <td>
                    <input type="text" class="form-control" name="consultant[]" value="<?php echo htmlspecialchars($data['consultant'], ENT_QUOTES); ?>">
                </td>
                <td>
                    <input type="text" class="form-control" name="optionlab[]" value="<?php echo htmlspecialchars($data['optionlab'], ENT_QUOTES); ?>">
                </td>
            </tr>
            <?php endforeach; ?>
        </tbody>
    </table>

    <div class="form-group">
        <label for="totalAmount">Total Amount</label>
        <input type="text" class="form-control" name="totalAmount" id="totalAmount" value="<?php echo htmlspecialchars($amount, ENT_QUOTES); ?>" readonly>
    </div>

    <button type="submit" class="btn btn-primary">Save Changes</button>
</form>

<script>
function calculateTotal(element) {
    // Get the current row
    const row = element.closest('tr');
    
    // Get the quantity and unit price fields
    const quantityField = row.querySelector('input[name="Quantity[]"]');
    const unitPriceField = row.querySelector('input[name="UnitPrice[]"]');
    const totalField = row.querySelector('.total-field');

    // Calculate total for this row
    const quantity = parseFloat(quantityField.value) || 0;
    const unitPrice = parseFloat(unitPriceField.value) || 0;
    const total = quantity * unitPrice;

    // Update the total field for this row
    totalField.value = total.toFixed(2);

    // Calculate the overall total amount
    updateTotalAmount();
}

function updateTotalAmount() {
    const totalFields = document.querySelectorAll('.total-field');
    let grandTotal = 0;

    // Sum up all total fields
    totalFields.forEach(field => {
        grandTotal += parseFloat(field.value) || 0;
    });

    // Update the total amount input
    document.getElementById('totalAmount').value = grandTotal.toFixed(2);
}
</script>


<!---->
</div>
</div>
<div class="col-md-2"></div> 
</div>
  </section>
     
  <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>
    $(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">
  $("#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>
  <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 src="https://code.jquery.com/jquery-3.6.0.min.js"></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>
 <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>