@include('layouts.header')
<!-- /Header -->
@include('layouts.sidebar')
<style>
    .select2-container--default .select2-selection--single {
        
        border: 1px solid #e9edf6 !important;
        height:40px !important; 
       
    }
    .select2-container .select2-selection--single .select2-selection__arrow {
        height: 100% !important;
        position: absolute !important;
        top: 0 !important;
        right: 0 !important;
        width: 20px !important; 
        background-color: transparent !important;
        border-left: 1px solid #aaa !important; 
    }
    
    .select2-container .select2-selection__arrow b {
      
        border-width: 5px 5px 0 5px !important; 
        border-style: solid !important;
        display: inline-block !important;
        margin-top: 5px !important;
        vertical-align: middle !important;
    }
    
    .select2-container--default .select2-selection--single .select2-selection__arrow 
    {
        display: none !important;
    }
    .select2-selection__clear{
        display: none !important;
        /* color:#aaa; */
    }
    
    </style>
    
<div class="page-wrapper">
    <div class="content">
        <div class="page-header">
            <div class="add-item d-flex">
                <div class="page-title">
                    <h4>Edit New Order</h4>
                    <h6>Edit New  order</h6>
                </div>
            </div>
            <ul class="table-top-head">
                <li>
                    <div class="page-btn">
                        <a href="{{ route('orders') }}" class="btn btn-secondary"><i data-feather="arrow-left" class="me-2"></i>Back to Orders</a>
                    </div>
                </li>
            </ul>
        </div>

        @if(session()->has('success'))
            <div class="alert alert-success">{{ session()->get('success') }}</div>
        @endif
        @if(session()->has('error'))
            <div class="alert alert-danger">{{ session()->get('error') }}</div>
        @endif

        <form action="{{ route('update_new_order')}}" method="post">
            @csrf
            <input type="hidden" name="id" value="{{ $order_details['id']}}">
            <div class="card">
                <div class="card-body add-product pb-0">
                    <div class="accordion-card-one accordion" id="accordionExample">
                        <div class="accordion-item">
                            <div class="accordion-header" id="headingOne">
                                <div class="accordion-button" data-bs-toggle="collapse" data-bs-target="#collapseOne" aria-controls="collapseOne">
                                    {{-- <h5><i data-feather="info"></i><span>Add Purchase</span></h5> --}}
                                </div>
                            </div>
                            <div id="collapseOne" class="accordion-collapse collapse show" aria-labelledby="headingOne" data-bs-parent="#accordionExample">
                                <div class="accordion-body">
                                    <div class="row">
                                        <div class="col-lg-4 col-sm-6 col-12">
                                            <div class="mb-3 add-product">
                                                <label class="form-label">Order Number</label>
                                                <input type="text" name="order_code" class="form-control" value="{{ $order_details['order_code']}}" readonly>
                                            </div>
                                        </div>
                                        <div class="col-lg-4 col-sm-6 col-12">
                                            <div class="mb-3 add-product">
                                                <label class="form-label">Order Date</label>
                                                <input type="date" name="order_date" value="{{ $order_details['order_date']}}" class="form-control" >
                                            </div>
                                        </div>
                                        <div class="col-lg-4 col-sm-6 col-12">
                                            <div class="mb-3 add-product">
                                                <label class="form-label">Company</label>
                                                <select class="form-control" name="company_id" id="company_id">
                                                    <option value="">Select</option>
                                                    @foreach($companies as $row)
                                                        <option value="{{ $row->id }}" {{ $order_details['company_id'] == $row->id ? 'selected' : '' }}>{{ $row->company_name }}</option>
                                                    @endforeach
                                                </select>
                                            </div>
                                        </div>
                                        <div class="col-lg-4 col-sm-6 col-12">
                                            <div class="mb-3 add-product">
                                                <div class="add-newplus">
                                                <label class="form-label">Customer</label>
                                                <a href="javascript:void(0);" data-bs-toggle="modal" data-bs-target="#add-customer"><i data-feather="plus-circle" class="plus-down-add"></i><span>Add New</span></a>
                                                </div>  
                                                <select class="form-control" name="customer_id" id="customer_id">
                                                    <option value="">Select</option>
                                                    @foreach($customers as $row)
                                                        <option value="{{ $row->id }}" {{ $order_details['customer_id'] == $row->id ? 'selected' : '' }}>{{ $row->customer_name }}</option>
                                                    @endforeach
                                                </select>
                                            </div>
                                        </div>
                                          <div class="col-lg-4 col-sm-6 col-12">
                                            <div class="mb-3 add-product">
                                                <label class="form-label">Staff</label>
                                                <select class="form-control" name="staff_id" id="staff_id" required >
                                                    <option value="">Select</option>
                                                    @foreach($staffs as $row)
                                                        <option value="{{ $row->id }}" {{ $order_details['staff_id'] == $row->id ? 'selected' : '' }}>{{ $row->full_name }}</option>
                                                    @endforeach
                                                </select>
                                            </div>
                                        </div>
                                        <div class="col-lg-4 col-sm-6 col-12">
                                            <div class="mb-3 add-product">
                                                <label class="form-label">Transporter</label>
                                                <select class="form-control" name="transporter_id" id="transporter_id" >
                                                    <option value="">Select</option>
                                                    @foreach($transporters as $row)
                                                        <option value="{{ $row->id }}" {{ $order_details['transporter_id'] == $row->id ? 'selected' : '' }}>{{ $row->transporter_name }}</option>
                                                    @endforeach
                                                </select>
                                            </div>
                                        </div>

                                        
                                    </div>

                                    <div class="row mb-3">
                                        <div class="col-12">
                                            <h5>Order Items</h5>
                                            <div class="table-responsive">
                                                <table class="table table-bordered" id="order-items">
                                                    <thead>
                                                        <tr>
                                                            <th>Action</th>
                                                            <th>Product Name</th>
                                                            <th>Design/Varient No</th>
                                                             <th>Warehouse</th>
                                                            <th>Availability</th>
                                                             <th>Roll No</th>
                                                            <th>Unit </th>
                                                            <th>Quantity</th>
                                                            <th>Rate</th>
                                                            <th>Amount</th>
                                                        </tr>
                                                    </thead>
                                                    <tbody>
                                                        @foreach($order_details['items'] as $item)
                                                        <tr class="order-row">
                                                           <td>
                                                            <a href="#" class="btn btn-danger remove-item" style="color:white;background:red"><svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-minus-circle minus"><circle cx="12" cy="12" r="10"></circle><line x1="8" y1="12" x2="16" y2="12"></line></svg></a>
                                                           </td>
                                                               
                                                            <td>
                                                                <select name="product_id[]" class="form-control product-select" id="product_select" required>
                                                              
                                                                @foreach($products as $row)
                                                                <option value="{{ $row->product_id  }}" {{ $item->product_id == $row->product_id  ? 'selected' : '' }} >{{ $row->product_name}}</option>
                                                                @endforeach
                                                                </select>
                                                             <input type="hidden" class="gst-input" name="gst_rate[]" value="{{ $item->gst_percent}}" >
                                                                 <input type="hidden" class="hsncode" name="hsn_code[]" value="{{ $item->hsn_code}}" >
                                                              <input type="hidden" class="company_gst" name="company_gst[]" value="{{ $item->company_gst}}">

                                                            </td>

                                                            <td>
                                                                <select name="varient_id[]" class="form-control variant-select varient_id"  required>
                                                              
                                                                @foreach($varients as $row)
                                                                <option value="{{ $row->id }}" {{ $item->varient_id == $row->id ? 'selected' : '' }} >{{ $row->varient_name}}-{{ $row->varient_code}}</option>
                                                                @endforeach
                                                                </select>
                                                            </td>
                                                             <td>
                                                            <select name="warehouse_id[]" class="form-control warehouse-select warehouse_id" required>
                                                            <option value="">Select Warehouse</option>   
                                                            <option value="{{ $item->warehouse_id }}" selected>{{ $item->warehouse_name }}</option>
                                                            </select>
                                                        </td>

                                                            <td>
                                                                <input type="text" name="availability[]" value="{{ $item->availability }}"  class="form-control availability" readonly>
                                                            </td>
                                                             <td>
                                                                <input type="text" name="roll_no[]" class="form-control rollno" value="{{ $item->roll_no }}" readonly>
                                                            </td>
                                                             <td>
                                                                
                                                                <select name="uom[]" class="form-control uom" required>
                                                                    <option value="">Select Units</option>
                                                                    @foreach($units as $row)
                                                                        <option value="{{ $row->id }}" {{ $item->uom == $row->id ? 'selected' : '' }}>
                                                                            {{ $row->unit_name }}
                                                                        </option>
                                                                    @endforeach
                                                                </select>
                                                            </td>
                                                            <td><input type="text" name="quantity[]" value="{{ $item->quantity}}" oninput="this.value = this.value.replace(/[^0-9.]/g, '')"  class="form-control quantity" required></td>
                                                            <td><input type="text" name="rate[]" value="{{ $item->price }}" oninput="this.value = this.value.replace(/[^0-9.]/g, '')" class="form-control rate" required></td>
                                                          
                                                            
                                                            <td><input type="text" name="total[]" value="{{ $item->total}}" class="form-control total" readonly></td>
                                                        </tr>
                                                        
                                                        @endforeach
                                                    </tbody>
                                                </table>
                                            </div>
                                        </div>
                                    </div>

                                    <div class="row">
                                        <!-- Gross Total -->
                                        <div class="col-lg-4 offset-lg-8">
                                            <div class="d-flex align-items-center mb-3">
                                                <label class="form-label me-2 mb-0" style="white-space: nowrap;">Gross Total:</label>
                                                <input type="number" name="subtotal"  value="{{ $order_details['subtotal'] }}" class="form-control grosstotal" readonly>
                                            </div>
                                        </div>
                                        <div class="col-lg-4 offset-lg-8" style="display:none">
                                            <div class="d-flex align-items-center mb-3" >
                                                <label class="form-label me-2 mb-0" style="white-space: nowrap;">Sub Total:</label>
                                                <input type="number" name="subtotal_ex_gst" id="subtotal_ex_gst_display" class="form-control" value="{{ round($order_details['subtotal_ex_gst']),2 }}" readonly>
                                            </div>
                                        </div>
                                        
                                     
                                       
                                        <div class="col-lg-5 offset-lg-7" id="forwarding_section">
                                            <div class="d-flex align-items-center mb-3">
                                                <label class="form-label me-2 mb-0" style="white-space: nowrap;">Forwarding:</label>

                                                <!-- Forwarding Type Dropdown -->
                                                <select class="form-select forwarding_type" name="forwarding_type" style="width: 20%; margin-right: 10px;">
                                                    <option value="percentage" {{ $order->forwarding_type == 'percentage' ? 'selected' : '' }}>%</option>
                                                    <option value="fixed" {{ $order->forwarding_type == 'fixed' ? 'selected' : '' }}>Fixed</option>
                                                </select>

                                                <!-- Input for Forwarding -->
                                                <div class="input-group" style="width: 50%;">
                                                    <input type="text" class="form-control forwarding_input"  value="{{ $order->forwarding_percentage }}" name="forwarding_percentage" 
                                                        oninput="this.value = this.value.replace(/[^0-9.]/g, '')">
                                                    <span class="input-group-text forwarding_unit">%</span>
                                                </div>

                                                <!-- Forwarding Amount (calculated) -->
                                                <input type="text" name="forwarding_amount" 
                                                    class="form-control ms-3 forwarding_amount" 
                                                    style="width: 50%;background:var(--bs-tertiary-bg);" value="{{ $order->forwarding_amount }}" readonly>

                                                    <input type="hidden" name="forwarding_gst" class="forwarding_gst" value="{{ $order->forwarding_gst}}">

                                            </div>
                                        </div>

                                        


                                       <div class="col-lg-5 offset-lg-7" id="special_discount" style="display:block;">
                                        <div class="d-flex align-items-center mb-3">
                                            <label class="form-label me-2 mb-0" style="white-space: nowrap;">Special Discount:</label>

                                            <!-- Discount Type Dropdown -->
                                            <select class="form-select discount_type" style="width: 20%; margin-right: 10px;">
                                                <option value="percentage" {{ $order->discount_type == 'percentage' ? 'selected' : '' }}>%</option>
                                                <option value="fixed" {{ $order->discount_type == 'fixed' ? 'selected' : '' }}>₹</option>
                                            </select>

                                            <!-- Input for Discount -->
                                            <div class="input-group" style="width: 50%;">
                                                <input type="text" class="form-control disc_input" name="disc_percent" value="{{ $order->discount_percentage }}" oninput="this.value = this.value.replace(/[^0-9.]/g, '')">
                                                <span class="input-group-text discount_unit">{{ $order->discount_type == 'percentage' ? '%' : '₹' }}</span>
                                            </div>

                                            <!-- Discount Amount (calculated) -->
                                            <input type="text" name="discount_amount" class="form-control ms-3 discount_amount" value="{{ $order->customer_discount_amount }}" style="width: 50%;background:var(--bs-tertiary-bg);" readonly>
                                        </div>
                                    </div>

                                       <div class="col-lg-4 offset-lg-8">
                                            <div class="d-flex align-items-center mb-3">
                                                <label class="form-label me-2 mb-0" style="white-space: nowrap;margin-left:-10px">GST Amount (Item+Forwarding):</label>
                                                <input type="number" id="gst_total_input" class="form-control" readonly>
                                            </div>
                                        </div> 
                                        

                                        <!-- Final Amount -->
                                        <div class="col-lg-4 offset-lg-8">
                                            <div class="d-flex align-items-center">
                                                <label class="form-label me-2 mb-0" style="white-space: nowrap;margin-left:-12px">Final Amount:</label>
                                                <input type="number" name="grand_total"  value="{{ round($order_details['grandtotal']),2 }}" class="form-control" readonly>
                                            </div>
                                        </div>
                                    </div>
                                    
                                    
                                    <br>
                                    <div class="row">
                                        
                                        <div class="col-lg-12">
                                            <div class="d-flex align-items-center mb-2">
                                                <label class="form-label me-2">Note:</label>
                                                <input type="text" name="note" class="form-control" value="{{ $order->note}}" >
                                            </div>
                                        </div>
                                    </div>

                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

             <div class="mt-4">
                    <h5><strong>GST Summary</strong></h5><br>
                    <table class="table table-bordered" id="gst-summary-table">
                        <thead>
                            <tr>
                                <th>HSN Code</th>
                                <th>GST %</th>
                                <th>CGST %</th>
                                <th>SGST %</th>
                                <th>IGST %</th>
                                <th>Total GST Amount</th>
                            </tr>
                        </thead>
                        <tbody>
                           
                        </tbody>
                    </table>
                </div> <br>


            <div class="col-lg-12">
                <div class="btn-addproduct mb-4">
                    <button type="button" class="btn btn-cancel me-2">Cancel</button>
                    <button type="submit" class="btn btn-primary">Save</button>
                </div>
            </div>
        </form>
    </div>
</div>
<!--add customer modal -->
<div class="modal fade" id="add-customer">
    <div class="modal-dialog modal-dialog-centered custom-modal-two">
        <div class="modal-content">
            <div class="page-wrapper-new p-0">
                <div class="content">
                    <div class="modal-header border-0 custom-modal-header">
                        <div class="page-title">
                            <h4>Add New Customer</h4>
                        </div>
                        <button type="button" class="close" data-bs-dismiss="modal" aria-label="Close">
                            <span aria-hidden="true">&times;</span>
                        </button>
                    </div>
                    <div class="modal-body custom-modal-body">
                        <form id="addCustomerForm">
                        @csrf
                        <div class="mb-3">
                            <label class="form-label">Customer Name</label>
                            <input type="text" name="name" id="customer_name" class="form-control" required> 
                        </div>
                        <div class="mb-3">
                        <label class="form-label">Customer type </label>
                        <select class="form-control" name="customer_type" id="customer_type" required>
                            <option value="">select</option>
                            <option value="Retail">Retail</option>
                            <option value="Wholesale">Wholesale</option>
                        </select>
                    </div>
                        
                        <div class="modal-footer-btn">
                            <a href="javascript:void(0);" class="btn btn-cancel me-2" data-bs-dismiss="modal">Cancel</a>
                            <input type="submit" class="btn btn-submit" name="submit" value="Submit">
                        </div>
                    </form>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
<!--end modal-->

<!-- Warehouse Info Modal -->
<div class="modal fade" id="warehouseModal" tabindex="-1" aria-labelledby="warehouseModalLabel" aria-hidden="true">
  <div class="modal-dialog">
    <div class="modal-content">
      <div class="modal-header">
        <h5 class="modal-title" id="warehouseModalLabel">Roll Details</h5>
        <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
      </div>
      <div class="modal-body" id="warehouseModalBody">
        <!-- Content dynamically inserted here -->
      </div>
    </div>
  </div>
</div>

<!-- Roll Selection Modal -->
<div class="modal fade" id="rollModal" tabindex="-1" role="dialog" aria-labelledby="rollModalLabel" aria-hidden="true">
  <div class="modal-dialog modal-lg" role="document"> <!-- modal-lg for wide table -->
    <div class="modal-content">
      <div class="modal-header">
        <h5 class="modal-title" id="rollModalLabel">Select Roll</h5>
        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
          <span aria-hidden="true">&times;</span>
        </button>
      </div>
      <div class="modal-body" id="rollData">
        <!-- Dynamic table of rolls will be injected here -->
      </div>
    </div>
  </div>
</div>

<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
{{-- <link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet" />
<script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>  --}}

@include('layouts.footer')

<script>

$(document).ready(function () {

   updateGstSummary();
    // =========================
    // Company → Variant (global load for dropdowns shown already)
    // =========================
    const companySelect = $('#company_id');
    let previousCompanyId = $('#company_id').val(); // store initial value

    companySelect.on('change', function () {

        
    if (previousCompanyId && previousCompanyId !== companySelect) {
        // Show confirmation whenever changing company
        let confirmChange = confirm('Are you sure you want to change the company? This will remove all added items.');

        if (!confirmChange) {
            // User canceled, revert to previous value
            $(this).val(previousCompanyId);
            return;
        }

        // ✅ If confirmed: remove all rows except first
        $('#order-items tbody tr.order-row').not(':first').remove();

        // ✅ Reset first row fields
        let firstRow = $('#order-items tbody tr.order-row:first');
        firstRow.find('select.product-select').empty().append('<option value="">Select Product</option>').prop('disabled', true);
        firstRow.find('select.variant-select').empty().append('<option value="">Select Variant</option>').prop('disabled', true);
        firstRow.find('select.warehouse-select').empty().append('<option value="">Select Warehouse</option>').prop('disabled', true);
        firstRow.find('.availability, .rollno, .rate, .quantity, .total').val('');

        // ✅ Clear totals regardless of rows
        $('input[name="subtotal"], input[name="subtotal_ex_gst"], input[name="discount_amount"], input[name="grand_total"], input[name="grosstotal"]').val('');
    }

    // Update previous companyId for next change
    previousCompanyId = companyId;
    
        const companyid = $(this).val();

        if (companyid) {
            $.ajax({
                url: '/get-variants-by-company',
                method: 'GET',
                data: { companyid },
                success: function (response) {
                    const variantDropdown = $('.variant-select');
                    variantDropdown.empty().append('<option value="">Select Varient</option>');
                    if (response.length > 0) {
                        response.forEach(v => {
                            variantDropdown.append(
                                `<option value="${v.id}">${v.varient_name} - ${v.varient_code}</option>`
                            );
                        });
                    } else {
                        alert('No variants found for this company.');
                    }
                },
                error: function () {
                    alert('Failed to fetch variants. Please try again.');
                }
            });
        }

        const isCompanySelected = !!companyid;
        $('.variant-select').prop('disabled', !isCompanySelected);
    });

    // =========================
    // Remove Item
    // =========================
    $(document).on('click', '.remove-item', function (e) {
        e.preventDefault();
        $(this).closest('tr').remove();
        recalcSubtotals(); // update subtotals & grand total after row removal
        updateGstSummary();
    });


    
    // =========================
    // Variant change → (simple details fetch)
    // =========================
    // $(document).on('change', '.variant-select', function () {
    //     const variantId = $(this).val();
    //     const row = $(this).closest('tr');

    //     if (variantId) {
    //         $.ajax({
    //             url: '{{ route("getVariantDetails") }}',
    //             type: 'GET',
    //             data: { id: variantId },
    //             success: function (response) {
    //                 // You can map fields from response into row if needed
    //                 // row.find('.uom').val(response.uom_id);
    //             },
    //             error: function (xhr) {
    //                 console.error("Error fetching variant details: ", xhr.responseText);
    //             }
    //         });
    //     }
    // });

    // ✅ Initialize warehouses for existing rows on page load
$(document).ready(function () {
    $('.variant-select').each(function () {
        const variantId = $(this).val();
        const row = $(this).closest('tr');
        const selectedWarehouseId = row.find('.warehouse-select').val();

        if (variantId) {
            $.ajax({
                url: '{{ route("getVariantWarehouses") }}',
                type: 'GET',
                data: { variant_id: variantId },
                success: function (warehouseData) {
                    const warehouseSelect = row.find('.warehouse-select');
                    warehouseSelect.empty();
                    warehouseSelect.append('<option value="">Select Warehouse</option>');
                    $.each(warehouseData, function (key, w) {
                        warehouseSelect.append(
                            $('<option>', {
                                value: w.id,
                                text: w.warehouse_name,
                                selected: w.id == selectedWarehouseId
                            })
                        );
                    });
                },
                error: function (xhr) {
                    console.error("Error fetching warehouse data on load: ", xhr.responseText);
                }
            });
        }
    });
});


    // =========================
    // Track manual rate edits (so API price won't override)
    // =========================
    $(document).on('input', '.rate', function () {
        if ($(this).val().trim() !== '') {
            $(this).attr('data-user-edit', 'true');
        } else {
            $(this).removeAttr('data-user-edit');
        }
    });

    // =========================
    // Rate / Quantity input → check availability + row calc
    // =========================
         let usedRollQuantities = {}; // ✅ define only once at top

    $(document).on('input', '.rate, .quantity', function () {
        const row = $(this).closest('tr');
        const rateInput = row.find('.rate');
        const quantityInput = row.find('.quantity');
        const gstInput = row.find('.gst-input');
        const hsncode = row.find('.hsncode');
        const quantity = parseFloat(quantityInput.val()) || 0;
        const variantId = row.find('.varient_id').val();     // NOTE: your row uses .variant-select AND .varient_id hidden/select; keeping as-is
        const warehouseId = row.find('.warehouse_id').val();
        const availability = row.find('.availability').val();
        const rollno = row.find('.rollno').val();

        if (quantity > 0 && variantId) {
            $.ajax({
                url: '/check-availability/' + variantId,
                method: 'GET',
                data: {
                    quantity,
                    warehouse_id: warehouseId,
                    availability,
                    rollno
                },
                success: function (response) {
                    const availableQty = parseFloat(response.available);

                    // Only set API price if user hasn't typed rate
                    if (!rateInput.attr('data-user-edit') || rateInput.val().trim() === '') {
                        rateInput.val(response.warehouseprice);
                    }

                    if (quantity > availableQty) {
                        Swal.fire({
                            icon: 'warning',
                            title: 'Quantity exceeds stock!',
                            text: 'Available stock: ' + availableQty,
                            confirmButtonColor: '#d33'
                        });

                        // Reset fields for this row
                        quantityInput.val('');
                        rateInput.val('');
                        row.find('.total-ex-gst').remove();
                        row.find('.varient_id').val('');
                        row.find('.total').val('0.00');

                        // Reset totals
                        $('input[name="subtotal"]').val('0.00');
                         $('#subtotal_ex_gst_display').val('0.00');

                        $('input[name="grand_total"]').val('0.00');
                    } else {
                        recalcRow(row);
                        recalcSubtotals();
                        updateGstSummary();
                    }
                },
                error: function () {
                    Swal.fire({
                        icon: 'error',
                        title: 'Oops!',
                        text: 'Error checking availability.',
                        confirmButtonColor: '#d33'
                    });
                }
            });
        } else {
            // If qty is cleared to 0, still clear row totals and recalc
            recalcRow(row);
            recalcSubtotals();
            updateGstSummary();
        }
    });

    // =========================
    // Add-row button shown as first-only row
    // =========================
    $('#order-items tbody tr').each(function () {
        $(this).find('.add-item').replaceWith(
            '<a href="#" class="btn btn-danger remove-item" style="color:white;background:red">' +
            '<svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-minus-circle minus">' +
            '<circle cx="12" cy="12" r="10"></circle>' +
            '<line x1="8" y1="12" x2="16" y2="12"></line>' +
            '</svg></a>'
        );
    });

    const initialRow = `
        <tr class="add-row">
            <td>
                <a href="#" class="btn btn-success add-item" style="color: white;">
                    <svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-plus-circle plus">
                        <circle cx="12" cy="12" r="10"></circle>
                        <line x1="12" y1="8" x2="12" y2="16"></line>
                        <line x1="8" y1="12" x2="16" y2="12"></line>
                    </svg>
                </a>
            </td>
        </tr>`;
    $('#order-items tbody').append(initialRow);

    // Row template (matches your markup & classes)
    const addItemRow = function () {
        return `
        <tr class="order-row">
            <td>
                <a href="#" class="btn btn-danger remove-item" style="color:white;background:red">
                    <svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-minus-circle minus">
                        <circle cx="12" cy="12" r="10"></circle>
                        <line x1="8" y1="12" x2="16" y2="12"></line>
                    </svg>
                </a>
            </td>
            <td>
                <select name="product_id[]" class="form-control product-select" required>
                    <option value="">Select product</option>
                </select>
                <input type="hidden" class="gst-input" name="gst_rate[]" value="">
                 <input type="hidden" class="hsncode" name="hsn_code[]" value="" >
            </td>
            <td>
                <select name="varient_id[]" class="form-control variant-select varient_id" required>
                    <option value="">Select Varient</option>
                </select>
            </td>
            <td>
                <select name="warehouse_id[]" class="form-control warehouse-select warehouse_id" required>
                    <option value="">Select Warehouse</option>
                </select>
            </td>
            <td><input type="text" name="availability[]" class="form-control availability" readonly></td>
            <td><input type="text" name="rollno[]" class="form-control rollno" readonly></td>
            <td>
                <select name="" class="form-control uom" disabled>
                    <option value="">Select Units</option>
                    @foreach($units as $row)
                        <option value="{{ $row->id }}">{{ $row->unit_name}}</option>
                    @endforeach
                </select>
            </td>
            <td><input type="text" name="quantity[]" onkeypress="return event.charCode >= 48 && event.charCode <= 57" class="form-control quantity" required></td>
            <td><input type="text" name="rate[]" onkeypress="return event.charCode >= 48 && event.charCode <= 57" class="form-control rate" step="0.01" required></td>
            <td><input type="text" class="form-control total" name="total[]" readonly></td>
        </tr>`;
    };

    // =========================
    // Add Item
    // =========================
    $(document).on('click', '.add-item', function (e) {
        e.preventDefault();

        const companyId = $('#company_id').val();

        // 1) create and insert
        const newRow = $(addItemRow());
        $('.add-row').before(newRow);

        // 2) handle selects in this new row
        const productSelect = newRow.find('.product-select');
        const variantSelect = newRow.find('.variant-select');

        // 3) load products for selected company (only into this row)
      $.ajax({
    url: '/get-products-by-company',
    method: 'GET',
    data: { companyid: companyId },
    success: function (response) {
        // ✅ Set company GST number
        if (response.gst_no) {
            $('.company_gst').val(response.gst_no);
        }

        // ✅ Clear and append products
        productSelect.empty().append('<option value="">Select Product</option>');
        if (response.products && response.products.length > 0) {
            response.products.forEach(p => {
                productSelect.append(`<option value="${p.product_id}">${p.product_name}</option>`);
            });
        }
        productSelect.prop('disabled', false);

        // ✅ Reset variants
        variantSelect.empty().append('<option value="">Select Variant</option>').prop('disabled', true);
    },
    error: function () {
        alert('Failed to fetch products. Please try again.');
    }
});

       // setTimeout(recalcSubtotals, 50);
    });

    // =========================
    // Company change → load products into ALL rows
    // =========================
    $(document).on('change', '#company_id', function () {
        const companyId = $(this).val();

        if (companyId) {
            $.ajax({
                url: '/get-products-by-company',
                method: 'GET',
                data: { companyid: companyId },
                success: function (response) {
                    $('.product-select').each(function () {
                        const ps = $(this);
                        ps.empty().append('<option value="">Select Product</option>');
                        response.forEach(prod => {
                            ps.append(`<option value="${prod.product_id}">${prod.product_name}</option>`);
                        });
                        ps.prop('disabled', false);
                    });

                    // Clear all variants after company change
                    $('.variant-select').each(function () {
                        $(this).empty().append('<option value="">Select Variant</option>').prop('disabled', true);
                    });
                },
                error: function () {
                    alert('Failed to fetch products. Please try again.');
                }
            });
        }
    });

    // =========================
    // Product change (per row) → load variants for that product, set GST
    // =========================
    $(document).on('change', '.product-select', function () {
        const productId  = $(this).val();
        const row        = $(this).closest('tr');
        const variantSel = row.find('.variant-select');
        const gstInput   = row.find('.gst-input');
         const hsncode   = row.find('.hsncode');
        variantSel.empty().append('<option value="">Select Variant</option>');

        //     row.find('.gst-input').val('');
        //     row.find('.variant-select').val(''); // clear variant
        //     row.find('.warehouse-select').val('').empty().append('<option value="">Select Warehouse</option>');
        //     row.find('.availability').val('');
        //     row.find('.rollno').val('');
        //     row.find('.uom').val('');
        //     row.find('.quantity').val('');
        //     row.find('.rate').val('');
        //     row.find('.total').val('');

        // $('input[name="subtotal"], input[name="subtotal_ex_gst"],input[name="forwarding_percentage"],input[name="forwarding_amount"],input[name="disc_percent"], input[name="discount_amount"], input[name="grand_total"], input[name="grosstotal"]').val('');


        if (productId) {
            $.ajax({
                url: '/get-variants-by-product',
                method: 'GET',
                data: { product_id: productId },
                success: function (response) {
                    if (response.length > 0) {
                        response.forEach(v => {
                            variantSel.append(`<option value="${v.id}">${v.varient_name} - ${v.varient_code}</option>`);
                        });
                        variantSel.prop('disabled', false);
                        // set GST from first variant (as in your code)
                        if (response[0] && response[0].gst_rate !== undefined) {
                            gstInput.val(response[0].gst_rate);
                              hsncode.val(response[0].hsn_code);
                        }
                    } else {
                        variantSel.prop('disabled', true);
                        Swal.fire({
                            icon: 'info',
                            title: 'No Variants',
                            text: 'No variants found for selected product.',
                            confirmButtonColor: '#3085d6'
                        });
                    }
                },
                error: function () {
                    alert('Failed to fetch variants.');
                }
            });
        } else {
            variantSel.prop('disabled', true);
        }
    });

    // =========================
    // Variant change (per row) → load warehouses list; open rolls modal on warehouse change
    // =========================
    $(document).on('change', '.variant-select', function () {
        const variantId = $(this).val();
        const row = $(this).closest('tr');
        const selectedWarehouseId = row.find('.warehouse-select').val();

        if (!variantId) return;

        // 1) get variant details for row fields + uom
        $.ajax({
            url: '{{ route("getVariantDetailsorder") }}',
            type: 'GET',
            data: { id: variantId },
            success: function (response) {
                row.find('.uom').val(response.uom_id);

                // 2) get warehouses for the variant
                $.ajax({
                    url: '{{ route("getVariantWarehouses") }}',
                    type: 'GET',
                    data: { variant_id: variantId },
                    success: function (warehouseData) {
                        const warehouseSelect = row.find('.warehouse-select');
                        warehouseSelect.empty();
                        warehouseSelect.append('<option value="">Select Warehouse</option>');
                        $.each(warehouseData, function (key, w) {
                            warehouseSelect.append(
                                $('<option>', {
                                    value: w.id,
                                    text: w.warehouse_name,
                                    selected: w.id == selectedWarehouseId
                                })
                            );
                        });

                        // bind change to open rolls modal
                        warehouseSelect.off('change click').on('change click', function () {
                            $('#rollModal').data('activeRow', row); // store row reference

                            const selectedOption = $(this).find('option:selected');
                            const warehouseId = selectedOption.val();
                            const warehouseName = selectedOption.text();

                            if (!warehouseId) return;

                              if (!warehouseId) {
                                    return; // do nothing if no warehouse selected
                                }
                                
                       if (warehouseId) {
                       loadRolls(variantId, warehouseId, warehouseName);
                      }

                            // rolls for variant + warehouse
                            $.ajax({
                                url: '{{ route("getRollsByVariantWarehouse") }}',
                                type: 'GET',
                                data: { variant_id: variantId, warehouse_id: warehouseId },
                                success: function (rolls) {
                                    let html = `<p><strong>Warehouse:</strong> ${warehouseName}</p>`;
                                    if (rolls.length > 0) {
                                        html += `
                                            <table class="table table-bordered">
                                                <thead>
                                                    <tr>
                                                        <th>Action</th>
                                                        <th>Quantity</th>
                                                        <th>Roll No</th>
                                                    </tr>
                                                </thead>
                                                <tbody>`;

                                        rolls.forEach(function (roll) {
                                             const rollId = roll.id;
                                        const used = usedRollQuantities[rollId] || 0;
                                        const remaining = parseInt(roll.availability) - used;
                                            html += `
                                                <tr>
                                                    <td>
                                                        <button type="button" class="btn btn-primary select-roll"
                                                            data-roll-id="${roll.id}"
                                                            data-retail-price="${roll.retail_price}"
                                                            data-availability="${roll.availability}"
                                                            data-varient-code="${roll.varient_code}"
                                                            data-thickness="${roll.thickness}"
                                                            data-roll-no="${roll.id}">
                                                            <i class="fa fa-check"></i>
                                                        </button>
                                                    </td>
                                                    <td>${roll.varient_code}/${roll.thickness}/-${parseInt(roll.availability)}-${roll.retail_price}</td>
                                                    <td>${roll.id}</td>
                                                </tr>`;
                                        });

                                        html += `</tbody></table>`;
                                    } else {
                                        html += `<p>No rolls found for this variant and warehouse.</p>`;
                                    }

                                    $('#warehouseModalBody').html(html);
                                    $('#warehouseModal').modal('show');
                                },
                                error: function (xhr) {
                                    console.error("Error fetching rolls: ", xhr.responseText);
                                }
                            });
                        }); // end warehouse change
                    },
                    error: function (xhr) {
                        console.error("Error fetching warehouse data: ", xhr.responseText);
                    }
                });
            },
            error: function (xhr) {
                console.error("Error fetching variant details: ", xhr.responseText);
            }
        });
    });

    function loadRolls(variantId, warehouseId, warehouseName) {
       // alert(2);
    $.ajax({
        url: '{{ route("getRollsByVariantWarehouse") }}',
        type: 'GET',
        data: { variant_id: variantId, warehouse_id: warehouseId },
        success: function (rolls) {
            var html = `<p><strong>Warehouse:</strong> ${warehouseName}</p>`;

            if (rolls.length > 0) {
                html += `
                    <table class="table table-bordered">
                        <thead>
                            <tr>
                                <th>Action</th>
                                <th>Quantity</th>
                                <th>Roll No</th>
                            </tr>
                        </thead>
                        <tbody>`;

                rolls.forEach(function (roll) {
                    const rollId = roll.id;
                    const used = usedRollQuantities[rollId] || 0;
                    const remaining = parseInt(roll.availability) - used;
                    if (remaining <= 0) return;

                    html += `
                        <tr>
                            <td>
                                <button type="button" class="btn btn-primary select-roll"
                                    data-roll-id="${roll.id}"
                                    data-retail-price="${roll.retail_price}"
                                    data-availability="${remaining}"
                                    data-varient-code="${roll.varient_code}"
                                    data-thickness="${roll.thickness}"
                                    data-roll-no="${roll.id}">
                                    <i class="fa fa-check"></i>
                                </button>
                            </td>
                            <td>${roll.varient_code}/${roll.thickness}/-${remaining}-${roll.retail_price}</td>
                            <td>${roll.id}</td>
                        </tr>`;
                });

                html += `</tbody></table>`;
            } else {
                html += `<p>No rolls found for this variant and warehouse.</p>`;
            }

            $('#warehouseModalBody').html(html);
            $('#warehouseModal').modal('show');
        },
        error: function (xhr) {
            console.error("Error fetching rolls: ", xhr.responseText);
        }
    });
}



$(document).on('input', '.quantity', function () {
   
    const $row = $(this).closest('tr');
    const quantity = parseFloat($(this).val()) || 0;
    const rollId = parseFloat($row.find('.rollno').val());
    const originalAvailability = $row.data('original-availability');

    if (!rollId || !originalAvailability) return;

    let totalUsed = 0;

    $('.rollno').each(function () {
        const currentRow = $(this).closest('tr');
        const currentRollId = parseFloat($(this).val());

        if (currentRollId === rollId) {
            if (currentRow[0] === $row[0]) return;

            const rowQty = parseFloat(currentRow.find('.quantity').val()) || 0;
            totalUsed += rowQty;
        }
    });

    const finalUsed = totalUsed + quantity;

    if (finalUsed > originalAvailability) {
        alert('Total quantity used from this roll exceeds original availability.');
        $(this).val('');
        usedRollQuantities[rollId] = totalUsed;
        return;
    }

    usedRollQuantities[rollId] = finalUsed;

    const rate = parseFloat($row.find('.rate').val()) || 0;
    $row.find('.total').val((quantity * rate).toFixed(2));
});

    // =========================
    // Warehouse availability (if needed separately)
    // =========================
    $(document).on('change', '.warehouse-select', function () {
        const warehouseId = $(this).val();
        const row = $(this).closest('tr');
        const variantId = row.find('.variant-select').val();

        if (warehouseId && variantId) {
            $.ajax({
                url: '{{ route("getVariantWarehouseAvailability") }}',
                type: 'GET',
                data: { warehouse_id: warehouseId, variant_id: variantId },
                success: function (response) {
                    // row.find('.availability').val(response.availability);
                },
                error: function (xhr) {
                    console.error("Error fetching availability: ", xhr.responseText);
                }
            });
        }
    });

    // keep your existing .variant-select change code as-is

// 🔑 Add this global binding once, outside .variant-select
$(document).on('change click', '.warehouse-select', function () {
    const row = $(this).closest('tr');
    const variantId = row.find('.variant-select').val();
    const warehouseId = $(this).val();
    const warehouseName = $(this).find('option:selected').text();

    if (!variantId || !warehouseId) return;

    $('#rollModal').data('activeRow', row);

    loadRolls(variantId, warehouseId, warehouseName);
});



    // =========================
    // Select roll: fill availability + rollno into row
    // =========================
    $(document).on('click', '.select-roll', function () {
        const row = $('#rollModal').data('activeRow'); // row reference from data

        const availability = $(this).data('availability');
        const rollNo = $(this).data('roll-no');

        row.find('.availability').val(availability);
        row.find('.rollno').val(rollNo);

        // Hidden roll_no[] if you want to submit it
        if (!row.find('.roll-no').length) {
            row.append(`<input type="hidden" name="roll_no[]" class="roll-no" value="${rollNo}">`);
        } else {
            row.find('.roll-no').val(rollNo);
        }

        $('#rollModal').modal('hide');
    });

    // =========================
    // Totals Calculation (Single Source of Truth)
    // =========================
   // =========================
// Row Calculation
// =========================
function recalcRow(row) {
    const qty = parseFloat(row.find('.quantity').val()) || 0;
    const rate = parseFloat(row.find('.rate').val()) || 0;
    const gstRate = parseFloat(row.find('.gst-input').val()) || 0;

    // const totalExGST = qty * rate;
    // const totalInclGST = totalExGST * (1 + gstRate / 100);

      const totalInclGST = qty * rate;                               // INCL GST
        const divisor      = (1 + (gstRate / 100)) || 1;
        const totalExGST   = totalInclGST / divisor; 

    // Update visible total (incl GST)
    row.find('.total').val(totalInclGST.toFixed(2));

    // Update hidden Ex-GST total (create if missing)
    let exgstInput = row.find('.total-ex-gst');
    if (exgstInput.length) {
        exgstInput.val(totalExGST.toFixed(2));
    } else {
        row.append('<input type="hidden" class="total-ex-gst" value="' + totalExGST.toFixed(2) + '">');
    }
}

// =========================
// Subtotals Calculation
// =========================
function recalcSubtotals() {
    let subtotalExGST = 0;
    let subtotalInclGST = 0;

    $('#order-items tbody tr.order-row').each(function () {
        const row = $(this);
         recalcRow(row);
        const rowEx = parseFloat(row.find('.total-ex-gst').val()) || 0;
        const rowIn = parseFloat(row.find('.total').val()) || 0;

        subtotalExGST += rowEx;
        subtotalInclGST += rowIn;
    });

    // Update subtotal fields
    $('#subtotal_ex_gst_display').val(subtotalExGST.toFixed(2));
    $('input[name="subtotal"]').val(subtotalInclGST.toFixed(2));

    recalcGrandTotal();
}



    function recalcGrandTotal() {
        const subtotalExGST = parseFloat($('#subtotal_ex_gst_display').val()) || 0;
        const subtotalInclGST = parseFloat($('input[name="subtotal"]').val()) || 0;

        // Discount
        let discountType = $('.discount_type').val();
        let discountVal = parseFloat($('.disc_input').val()) || 0;
        if (discountType === 'percentage' && discountVal > 100) discountVal = 100;

        let discountAmt = (discountType === 'percentage')
            ? (subtotalExGST * discountVal / 100)
            : discountVal;
        if (discountAmt > subtotalExGST) discountAmt = subtotalExGST;
        $('.discount_amount').val(discountAmt.toFixed(2));

        // Forwarding
        let forwardingType = $('.forwarding_type').val();
        let forwardingVal = parseFloat($('.forwarding_input').val()) || 0;
        if (forwardingType === 'percentage' && forwardingVal > 100) forwardingVal = 100;

        let forwardingAmt = (forwardingType === 'percentage')
            ? (subtotalExGST * forwardingVal / 100)
            : forwardingVal;
        $('.forwarding_amount').val(forwardingAmt.toFixed(2));

        
            // ✅ Forwarding GST (fixed 18% here, change if needed)
            let forwardingGstRate = 18; 
            let forwardingGst = (forwardingAmt * forwardingGstRate) / 100;
            $('.forwarding_gst').val(forwardingGst.toFixed(2));

        // Grand Total (GST incl) - discount + forwarding
        let grandTotal = (subtotalInclGST - discountAmt) + forwardingAmt + forwardingGst;
        if (grandTotal < 0) grandTotal = 0;
        $('input[name="grand_total"]').val(grandTotal.toFixed(2));
    }

    // Bind: qty/rate → row+subtotals; add/remove handled elsewhere
    $(document).on('input', '.quantity, .rate', function () {
       // alert(1);
        const row = $(this).closest('tr');
        recalcRow(row);
        recalcSubtotals();
        updateGstSummary();
    });

    $(document).on('click', '.add-item', function () {
       // setTimeout(recalcSubtotals, 50);
    });

    // Discount/Forwarding → ONLY grand total
    $(document).on('change input', '.discount_type, .disc_input, .forwarding_type, .forwarding_input', function () {
        recalcGrandTotal();
        updateGstSummary();
    });


        // =========================
    // Initialize current rows
    // =========================
    // $('#order-items tbody tr.order-row').each(function () {
    //     recalcRow($(this));
    // });
   // recalcSubtotals();

     $('#order-items tbody tr.order-row').each(function () {
        const row = $(this);
        const qty     = parseFloat(row.find('.quantity').val()) || 0;
        const rate    = parseFloat(row.find('.rate').val()) || 0;
        const gstRate = parseFloat(row.find('.gst-input').val()) || 0;

        // use existing GST-incl total from backend if present
        const totalInclGST = parseFloat(row.find('.total').val()) || (qty * rate);
        const divisor      = (1 + (gstRate / 100)) || 1;
        const totalExGST   = totalInclGST / divisor;

        if (!row.find('.total-ex-gst').length) {
            row.append('<input type="hidden" class="total-ex-gst" value="' + totalExGST.toFixed(2) + '">');
        }
    });
    // ⚠️ Important: Do NOT call recalcSubtotals() here
    // so backend subtotal_ex_gst remains intact on first load

});

    // =========================
    // Select2
    // =========================
    $('#company_id').select2({ placeholder: "Select Company", allowClear: true, search: true });
    $('#customer_id').select2({ placeholder: "Select Customer", allowClear: true, search: true });
    $('#transporter_id').select2({ placeholder: "Select Transporter", allowClear: true, search: true });

    // =========================
    // Add Customer
    // =========================
    $('#addCustomerForm').submit(function (e) {
        e.preventDefault();
        const customerName = $('#customer_name').val();
        const customer_type = $('#customer_type').val();
        $.ajax({
            url: "{{ route('add_customer_dynamic') }}",
            method: 'POST',
            data: {
                _token: '{{ csrf_token() }}',
                name: customerName,
                customer_type: customer_type,
            },
            success: function (response) {
                if (response.success) {
                    $('#add-customer').modal('hide');
                    $('#addCustomerForm')[0].reset();
                    $('select[name="customer_id"]').append(
                        '<option value="' + response.customer.id + '" selected>' + response.customer.customer_name + '</option>'
                    );
                    alert('Customer added successfully!');
                } else {
                    alert('Failed to add customer!');
                }
            },
            error: function () {
                alert('An error occurred while adding the customer.');
            }
        });
    });


    function updateGstSummary() {
    let gstGroups = {};
    const subtotal = parseFloat($('#subtotal_ex_gst_display').val()) || 0;
    //console.log(subtotal);
    const forwardingTotal = parseFloat($('.forwarding_amount').val()) || 0;

    // Global Forwarding GST details
    const forwardingHSN = "5245";
    const forwardingGST = 18;

    let items = [];
    let totalTaxable = 0;

    // Step 1: Collect all items
    document.querySelectorAll('#order-items tbody tr').forEach(row => {
        let qty = parseFloat(row.querySelector('.quantity')?.value || 0);
        let rate = parseFloat(row.querySelector('.rate')?.value || 0);
        let gst = parseFloat(row.querySelector('.gst-input')?.value || 0);
        let hsncode = row.querySelector('.hsncode')?.value || '';
        let top = row.querySelector('.top')?.value || '';
        let company_gst = row.querySelector('.company_gst')?.value || '';
      
        if (qty === 0 || rate === 0 || !hsncode.trim()) return;

        //let amount = qty * rate;
        //totalTaxable += amount;

        let grossAmount = qty * rate;
        let amount = grossAmount / (1 + gst / 100);
        let gstAmount = grossAmount - amount;

        totalTaxable += amount;

        items.push({ amount, gst, hsncode, top,company_gst,gstAmount });
    });

    // Step 2: Normal items GST calculation
    items.forEach(item => {
        let itemGstAmount = (item.amount * item.gst) / 100;

        let key = item.hsncode + '_' + item.gst;
        if (!gstGroups[key]) {
            gstGroups[key] = {
                hsn: item.hsncode,
                gst: item.gst,
                taxable: 0,
                forwarding: 0,
                cgst: 0,
                sgst: 0,
                igst: 0,
                total: 0
            };
        }

        gstGroups[key].taxable += item.amount;

        // if (item.top === 'OMS') {
        //     gstGroups[key].igst += itemGstAmount;
        // } else {
        //     gstGroups[key].cgst += itemGstAmount / 2;
        //     gstGroups[key].sgst += itemGstAmount / 2;
        // }

         if (item.company_gst && item.company_gst.startsWith("27")) {
            // Maharashtra → CGST + SGST
            gstGroups[key].cgst += itemGstAmount / 2;
            gstGroups[key].sgst += itemGstAmount / 2;
        } else {
            // Other state → IGST
            gstGroups[key].igst += itemGstAmount;
        }

        gstGroups[key].total += itemGstAmount;
    });

    // Step 3: Forwarding cost GST calculation
    if (forwardingTotal > 0) {
        let fwdGstAmount = (forwardingTotal * forwardingGST) / 100;

        let fwdKey = forwardingHSN + '_' + forwardingGST;
        if (!gstGroups[fwdKey]) {
            gstGroups[fwdKey] = {
                hsn: forwardingHSN,
                gst: forwardingGST,
                taxable: 0,
                forwarding: 0,
                cgst: 0,
                sgst: 0,
                igst: 0,
                total: 0
            };
        }

        gstGroups[fwdKey].forwarding += forwardingTotal;
        gstGroups[fwdKey].cgst += fwdGstAmount / 2;
        gstGroups[fwdKey].sgst += fwdGstAmount / 2;
        gstGroups[fwdKey].total += fwdGstAmount;
    }

    // Step 4: Render GST Summary
    const gstTableBody = document.querySelector('#gst-summary-table tbody');
    gstTableBody.innerHTML = '';
    let totalGstSum = 0;
    let totalForwarding = 0;
    let totalCgst = 0, totalSgst = 0, totalIgst = 0;

    for (let key in gstGroups) {
        let data = gstGroups[key];
        if (data.total > 0 || data.forwarding > 0) {
            totalGstSum += data.total;
            totalForwarding += data.forwarding;
            totalCgst += data.cgst;
            totalSgst += data.sgst;
            totalIgst += data.igst;

            // Show HSN + Forwarding amount if present
            let hsnDisplay = data.hsn;
            if (data.forwarding > 0) {
               // hsnDisplay = `${data.hsn} (${data.forwarding.toFixed(2)})`;
                hsnDisplay = `${data.hsn} (Forwarding)`;
            }

            const row = document.createElement('tr');
            row.innerHTML = `
                <td>${hsnDisplay}</td>
                <td>${data.gst}%</td>
                <td>₹ ${data.cgst.toFixed(2)}</td>
                <td>₹ ${data.sgst.toFixed(2)}</td>
                <td>₹ ${data.igst.toFixed(2)}</td>
                <td>₹ ${data.total.toFixed(2)}</td>
            `;
            gstTableBody.appendChild(row);
        }
    }

    // Step 5: Add Total Row
    const totalRow = document.createElement('tr');
    totalRow.style.fontWeight = "bold";
    totalRow.innerHTML = `
        <td>Total</td>
        <td></td>
        <td>₹ ${totalCgst.toFixed(2)}</td>
        <td>₹ ${totalSgst.toFixed(2)}</td>
        <td>₹ ${totalIgst.toFixed(2)}</td>
        <td>₹ ${totalGstSum.toFixed(2)}</td>
    `;
    gstTableBody.appendChild(totalRow);

    // Step 6: Update total GST input
    document.getElementById('gst_total_input').value = totalGstSum.toFixed(2);
}





</script>