@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="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" id="myForm">
            @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 }}" data-com-state="{{ $row->top }}" {{ $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="{{ route('add_customer') }}" target="_blank"><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 }}" data-cust-state="{{ $row->top }}" {{ $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">
                                        <div class="col-lg-4 col-sm-6 col-12">
                                            <div class="mb-3 add-product">
                                                <div class="add-newplus">
                                                    <label class="form-label">Installer</label>
                                                    <a href="{{ route('add_installer') }}" target="_blank"><i data-feather="plus-circle" class="plus-down-add"></i><span>Add New</span></a>
                                                </div>  
                                                <select name="installer_id" class="form-control" id="installer_id" required>
                                                    <option value="">Select</option>
                                                    @foreach($installers as $row)
                                                        <option value="{{ $row->id }}" {{$row->id == $order_details['installer_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 me-2 mb-0">Apply Coupon</label>
                                                <select name="coupon" class="form-control" id="coupon">
                                                    <option value="0">Select Coupon</option>
                                                    @foreach($coupons as $row)
                                                    <option value="{{ $row->id}}" {{$row->id == $order_details['coupon_id'] ? 'selected':''}} data-coupon-type="{{$row->discount_type}}" data-coupon-amount="{{$row->discount_value}}">{{ $row->coupon_code}}</option>
                                                    @endforeach
                                                </select>
                                            </div>
                                        </div>
                                    </div>
                                    <input type='hidden' value="{{ $order_details['labour_gst_rate'] ?? '18'}}" id="labour_gst_rate" name="labour_gst_rate">
                                    <input type='hidden' value="{{ $order_details['labour_gst_code'] ?? '222'}}" id="labour_gst_code" name="labour_gst_code">


                                    <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</th>
                                                            <th style="width:7%;">Design/Varient No</th>
                                                             <th style="width:5%;">Warehouse</th>
                                                            <th style="width:5%;">Availability</th>
                                                             <th style="width:5%;">Roll</th>
                                                            <th>Unit </th>
                                                            <th>Quantity</th>
                                                            <th>Rate</th>
                                                            <th style="width:7%;">Labour</th>
                                                            <th style="width:5%;">Discount(%)</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_code}}-{{ $row->varient_name}}</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>
                                                            @php 
                                                                $discountAmount = 0; 
                                                                if($item->item_discount > 0){
                                                                    $discountAmount = $item->price_ex_discount * $item->item_discount /100;
                                                                }
                                                            @endphp
                                                            <td><input type="text" name="quantity[]" value="{{ $item->quantity}}" data-reserved="{{ $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="labourRate[]" value="{{ $item->labour_rate}}" data-labour-rate="{{ $item->labour_rate}}" class="form-control labourRate"></td>
                                                            <td><input type="text"  value="{{ $item->item_discount}}" oninput="this.value=this.value.replace(/[^0-9.]/g,'').replace(/(\..*)\./g,'$1')" name="item_discount[]" value="0" data-labour-rate="0" class="form-control item_discount"></td>
                                                            <td><input type="text" name="total[]" value="{{ $item->total}}" class="form-control total" readonly></td>
                                                            <input type="hidden" class="row_discount" name="row_discount[]" value="{{$discountAmount}}">
                                                            <input type="hidden" class="total_ex_discount" name="total_ex_discount[]" value="{{$item->price_ex_discount}}">
                                                        </tr>
                                                        
                                                        @endforeach
                                                    </tbody>
                                                </table>
                                            </div>
                                        </div>
                                    </div>

                                    <div class="row">
                                         <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;">Item Total:</label>
                                                <input type="number" style="background:var(--bs-tertiary-bg);" name="itemTotal" value="{{ $order_details['order_amount'] }}" class="form-control itemTotal" 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;">Discount Total:</label>
                                                <input type="text" style="background:var(--bs-tertiary-bg);" name="discount_total" value="{{ $order_details['discount'] }}" class="form-control discount_total" readonly>
                                            </div>
                                        </div>
                                        <!-- 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;">Sub Total:</label>
                                                <input type="number" name="subtotal" style="background:var(--bs-tertiary-bg);"  value="{{ $order_details['subtotal'] }}" class="form-control grosstotal" 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="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-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;">Labour Charges:</label>
                                                <input type="number" style="background:var(--bs-tertiary-bg);" name="labourRateTotal" value="{{ $order_details['labour_charges'] }}" class="form-control labourRateTotal" readonly>
                                            </div>
                                        </div>
                                        <div class="col-lg-6 offset-lg-6">
                                            <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+Labour+Forwarding):</label>
                                                <input type="number" style="background:var(--bs-tertiary-bg);" id="gst_total_input" name="gst_amount_data" value="{{ $order_details['subtotal_ex_gst'] }}" 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" style="background:var(--bs-tertiary-bg);"  value="{{ $order_details['grandtotal'] }}" 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" onclick="location.reload();">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>
//Unit Conversion Rule
function convertPrice(price, fromUnit, toUnit) {
	console.log("price",price,"fromUnit",fromUnit,"toUnit",toUnit);
    if (!price || fromUnit === toUnit) return price;

    fromUnit = fromUnit.toUpperCase();
    toUnit = toUnit.toUpperCase();

    // ✅ Conversion factors to SQFT (area base)
    const AREA = {
        SQFT: 1,
        'SQ FT': 1,
        SQM: 10.764,
        'TILE S': 1,
        'TILE M': 2.69,
        'TILE L': 4,
        'PLANK S': 1.5,
        'PLANK M': 2.25
    };

    // ✅ Conversion factors to FT (length base)
    const LENGTH = {
        FT: 1,
        MTR: 3.28
    };

    const DEFINABLE = ['BOX', 'ROLL'];

    // 🚫 Block BOX & ROLL conversion
    if (DEFINABLE.includes(fromUnit) || DEFINABLE.includes(toUnit)) {
        alert('Box/Roll cannot be converted. Please change labour cost.');
        return 0;
    }

    // =========================
    // ✅ AREA CONVERSION
    // =========================
    if (AREA[fromUnit] && AREA[toUnit]) {
        let pricePerSqFt = price / AREA[fromUnit]; // normalize
        let finalPrice = pricePerSqFt * AREA[toUnit];
        return +finalPrice.toFixed(2);
    }

    // =========================
    // ✅ LENGTH CONVERSION
    // =========================
    if (LENGTH[fromUnit] && LENGTH[toUnit]) {
        let pricePerFt = price / LENGTH[fromUnit];
        let finalPrice = pricePerFt * LENGTH[toUnit];
        return +finalPrice.toFixed(2);
    }

    // 🚫 Block mixing length & area
    if (
        (AREA[fromUnit] && LENGTH[toUnit]) ||
        (LENGTH[fromUnit] && AREA[toUnit])
    ) {
        alert('Unsupported conversion, Please change labour Cost');
        return 0;
    }

    alert('Unsupported conversion, Please change labour Cost');
    return 0;
}
// function convertPrice(price, fromUnit, toUnit) {

//     const MEASUREMENT = ['MTR', 'FT', 'SQM', 'SQFT'];
//     const DEFINABLE = ['ROLL', 'BOX', 'TILE'];

//     // Definable ↔ Definable → SAME PRICE
//     if (DEFINABLE.includes(fromUnit) && DEFINABLE.includes(toUnit)) {
//         return Number(price.toFixed(2));
//     }

//     // ❌ Block mixing measurement & definable
//     if (
//         (DEFINABLE.includes(fromUnit) && MEASUREMENT.includes(toUnit)) ||
//         (MEASUREMENT.includes(fromUnit) && DEFINABLE.includes(toUnit))
//     ) {
//         alert('Conversion between roll/box/tile is not allowed, Please change basic Cost');
//         return 0;
//     }

//     // SQM ↔ SQFT (normal area conversion)
//     if (fromUnit === 'SQM' && toUnit === 'SQFT') {
//         return +(price / 10.764).toFixed(2);
//     }
//     if (fromUnit === 'SQFT' && toUnit === 'SQM') {
//         return +(price * 10.764).toFixed(2);
//     }

//     // MTR ↔ FT (normal linear conversion)
//     if (fromUnit === 'MTR' && toUnit === 'FT') {
//         return +(price / 3.28).toFixed(2);
//     }
//     if (fromUnit === 'FT' && toUnit === 'MTR') {
//         return +(price * 3.28).toFixed(2);
//     }

//     // ✅ SPECIAL BUSINESS LOGIC
//     //SQFT - MTR
// 	if (fromUnit === 'SQFT' && toUnit === 'MTR') {
//          return +(price * 10.764).toFixed(2);
//     }
//     // SQM → MTR (square root)
//     if (fromUnit === 'SQM' && toUnit === 'MTR') {
//         return +(Math.sqrt(price)).toFixed(2);
//     }

//     // MTR → SQM (square)
//     if (fromUnit === 'MTR' && toUnit === 'SQM') {
//         return +Math.round(price * price).toFixed(2);
//     }
// 	if(fromUnit == toUnit){
// 		return price;
// 	}

//     alert('Unsupported conversion, Please change labour rate');
//     return 0;
// }
$(document).ready(function () {
    $("body").addClass('mini-sidebar');
    let customer_id = "{{$order_details['customer_id']}}";
    if (customer_id) {
        $.ajax({
            url: `/get-customerdetails/${customer_id}`,
            method: 'GET',
            data: { customerid: customer_id },
            success: function (response) {

                $('#special_discount').show();
                $('.disc_percent').val(response.customer_discount);
                
            },
            error: function () {
                $('.disc_percent').val('0');  
                $('.discount_amount').val('0');
                $('#special_discount').hide();
                    
                // alert('Failed to fetch customer. Please try again.');
            }
        });
    }else{
        
        $('.disc_percent').val('0');  
        $('.discount_amount').val('0');
        $('#special_discount').hide();
    }
    $('#myForm').on('submit', function(e) {
        e.preventDefault();
        let form = this;
        let formData = new FormData(form); 
        $('#global-loader').show();
        $.ajax({
            url: form.action,
            method: form.method,
            data: formData,
            processData: false,
            contentType: false,
            success: function(response) {
                console.log(response);
                $('#global-loader').hide();
                successMessage("Order Updated Successfully.","{{ route('orders') }}");
            },
            error: function(xhr) {
                $('#global-loader').hide();
                errorMessage();
            }
        });
    });
   onLoadUpdateGstSummary();
    // =========================
    // Company → Variant (global load for dropdowns shown already)
    // =========================
    const companySelect = $('#company_id');
    let previousCompanyId = $('#company_id').val(); // store initial value

    companySelect.on('change', function () {
        const companyid = $(this).val();
        
    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').val('').trigger('change');
        firstRow.find('select.variant-select').val('').trigger('change');
        firstRow.find('select.warehouse-select').val('').trigger('change');
        firstRow.find('.availability, .rollno, .rate, .quantity, .total, .labourRate').val('');
        $('#gst-summary-table tbody').html('');
        // ✅ Clear totals regardless of rows
         $('input[name="subtotal"], input[name="discount_amount"], input[name="grand_total"], input[name="grosstotal"], input[name="labourRateTotal"], input[name="applied_coupon_amount"], input[name="forwarding_amount"], #gst_total_input').val('');
    }

    // Update previous companyId for next change
    previousCompanyId = companyid;
        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_code} - ${v.varient_name}</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);
    });
let previousInstallerId = $('#installer_id').val(); // store initial value
console.log("previousInstallerId",previousInstallerId);
$(document).on('change', '#installer_id', async function() {
    let installer_id = $(this).val();
    if (previousInstallerId && previousInstallerId !== installer_id) {
        // Show confirmation whenever changing company
        let confirmChange = confirm('Are you sure you want to change the installer?');

        if (!confirmChange) {
            // User canceled, revert to previous value
            $(this).val(previousInstallerId);
            return;
        }
        $('#global-loader').show();
        var labourChargesTotal = 0;
        var result = await $('#order-items tbody tr.order-row').each(async function () {
            const row = $(this);
            const quantity = parseFloat(row.find('.quantity').val()) || 0;
            const product_id = parseFloat(row.find('.product-select option:selected').val()) || 0;
            const uom = row.find('.uom option:selected').text().toUpperCase().trim();
            await $.ajax({
                url: '/get-labour-rate',
                method: 'GET',
                data: { product_id: product_id, installerId: installer_id },
                success: function (response) {
                    console.log(response);
                    var rate = 0;
                    if(response){
                      rate = response.rate;
                    }
                    row.find('.labourRate').data('labour-rate',rate);
                    let totalLabourrate = 0;
                    if(rate > 0){
                        const convertedPrice = convertPrice(parseFloat(rate),'SQFT',uom);
                        console.log("converted Price",convertedPrice,"quantity->",quantity);
                        totalLabourrate = parseFloat(convertedPrice * quantity).toFixed(2);
                        labourChargesTotal += parseFloat(totalLabourrate);
                    }
                    console.log("totalLabourrate->",totalLabourrate,"labourChargesTotal->",labourChargesTotal);
                    row.find('.labourRate').val(totalLabourrate);
                },
                error: function () {
                    
                }
            });     
            recalcSubtotals();
            recalcGrandTotal();
            updateGstSummary();
        });
    }else{
        $('#global-loader').show();
        var labourChargesTotal = 0;
        var result = await $('#order-items tbody tr.order-row').each(async function () {
            const row = $(this);
            const quantity = parseFloat(row.find('.quantity').val()) || 0;
            const product_id = parseFloat(row.find('.product-select option:selected').val()) || 0;
            const uom = row.find('.uom option:selected').text().toUpperCase().trim();
            await $.ajax({
                url: '/get-labour-rate',
                method: 'GET',
                data: { product_id: product_id, installerId: installer_id },
                success: function (response) {
                    console.log(response);
                    var rate = 0;
                    if(response){
                      rate = response.rate;
                    }
                    row.find('.labourRate').data('labour-rate',rate);
                    let totalLabourrate = 0;
                    if(rate > 0){
                        const convertedPrice = convertPrice(parseFloat(rate),'SQFT',uom);
                        console.log("converted Price",convertedPrice,"quantity->",quantity);
                        totalLabourrate = parseFloat(convertedPrice * quantity).toFixed(2);
                        labourChargesTotal += parseFloat(totalLabourrate);
                    }
                    console.log("totalLabourrate->",totalLabourrate,"labourChargesTotal->",labourChargesTotal);
                    row.find('.labourRate').val(totalLabourrate);
                },
                error: function () {
                    
                }
            });     
            recalcSubtotals();
            recalcGrandTotal();
            updateGstSummary();
        });
    }
    // Update previous installer_id for next change
    previousInstallerId = installer_id;
    setTimeout(function(){
        $('#global-loader').hide();
    },2000);
})
    var previousCustId = $('#customer_id').val();
    const customerSelect = $('#customer_id');
    customerSelect.on('change', function () {
        customerid = $(this).val();
        if (previousCustId && previousCustId !== customerid) {
        // Show confirmation whenever changing company
        let confirmChange = confirm('Are you sure you want to change the customer? This will remove all added items.');

        if (!confirmChange) {
            // User canceled, revert to previous value
            $(this).val(previousCustId);
            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').val('').trigger('change');
        firstRow.find('select.variant-select').val('').trigger('change');
        firstRow.find('select.warehouse-select').val('').trigger('change');
        firstRow.find('.availability, .rollno, .rate, .quantity, .total, .labourRate').val('');
        $('#gst-summary-table tbody').html('');
        // ✅ Clear totals regardless of rows
        $('input[name="subtotal"], input[name="discount_amount"], input[name="grand_total"], input[name="grosstotal"], input[name="labourRateTotal"], input[name="applied_coupon_amount"], input[name="forwarding_amount"], #gst_total_input').val('');
    }
    

    // Update previous customerid for next change
    previousCustId = customerid;


        if (customerid) {
            $.ajax({
                url: `/get-customerdetails/${customerid}`,
                method: 'GET',
                data: { customerid: customerid },
                success: function (response) {

                    $('#special_discount').show();
                    $('.disc_percent').val(response.customer_discount);
                   
                },
                error: function () {
                    $('.disc_percent').val('0');  
                    $('.discount_amount').val('0');
                    $('#special_discount').hide();
                        
                    // alert('Failed to fetch customer. Please try again.');
                }
            });
        }else{
         
            $('.disc_percent').val('0');  
            $('.discount_amount').val('0');
            $('#special_discount').hide();
        }
    });

    // =========================
    // Remove Item
    // =========================
    $(document).on('click', '.remove-item', function (e) {
        e.preventDefault();
        $(this).closest('tr').remove();
        recalcSubtotals(); // update subtotals & grand total after row removal
        updateGstSummary();
    });
    $('#coupon').on('change', function() {
        $('#global-loader').show();
        let selectedOption = $(this).find(':selected');
        let value = parseFloat(selectedOption.data('coupon-amount') || 0);
        $('.item_discount').val(value);
        $('#order-items tbody tr').each(function () {
            let quantity = parseFloat($(this).find('.quantity').val()) || 0;
            let rate = parseFloat($(this).find('.rate').val()) || 0;
            let discount = parseFloat($(this).find('.item_discount').val()) || 0;
            let subTotal = rate * quantity; // 965
            let new_total = subTotal;
            let afterDiscount = 0;
            if(discount > 0){
                afterDiscount = subTotal * discount /100;
                new_total -= afterDiscount;
            }
            $(this).find('.total').val(new_total.toFixed(2)); // show in table
            $(this).find('.total_ex_discount').remove();
            $(this).append('<input type="hidden" class="total_ex_discount" name="total_ex_discount[]" value="'+subTotal.toFixed(2)+'">');
            // show in table

            // Total discount
            $(this).find('.row_discount').remove();
            $(this).append('<input type="hidden" class="row_discount" name="row_discount[]" value="'+afterDiscount.toFixed(2)+'">');
            recalcSubtotals();
            recalcGrandTotal();
            updateGstSummary();
            
        });  
        setTimeout(function(){
            $('#global-loader').hide();
        },2000);   
    });

    
    // =========================
    // 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).on('blur', '.item_discount', function () {
        let selectedOption = parseFloat($(this).val() || 0);
        console.log(selectedOption);
        let row = $(this).closest('tr');
        console.log("row",row);
        let rateInput = parseFloat(row.find('.rate').val() || 0);
        let quantityInput = parseFloat(row.find('.quantity').val() || 0);
        console.log(rateInput,"rateInput",quantityInput,"quantityInput");
        let subTotal = rateInput * quantityInput;
        let new_total = subTotal;
        let afterDiscount = 0;
        if(selectedOption > 0){
            afterDiscount = subTotal * selectedOption /100;
            new_total -= afterDiscount;
            console.log("afterDiscount",afterDiscount,"new_total",new_total);
        }
        console.log("new_total",new_total);
        row.find('.total').val(new_total.toFixed(2)); // show in table
        row.find('.total_ex_discount').remove();
        row.append('<input type="hidden" class="total_ex_discount" name="total_ex_discount[]" value="'+subTotal.toFixed(2)+'">');
        // Total discount
        row.find('.row_discount').remove();
        row.append('<input type="hidden" class="row_discount" name="row_discount[]" value="'+afterDiscount.toFixed(2)+'">');
        recalcSubtotals();
        updateGstSummary();
    });
$(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', '.labourRate', function () {
        recalcSubtotals();
        recalcGrandTotal();
        updateGstSummary();

    });
    $('.item_discount').on('input', function () {
        var item_discount_value = $(this).val();
        if (item_discount_value === '') return;
        let num = parseFloat(item_discount_value);
        if (num > 100){
            Swal.fire({
                icon: 'warning',
                title: 'Discount Warning',
                text: 'Discount should not be greater than 100',
                confirmButtonColor: '#d33'
            });
            $(this).val(100);
        } 
        if (num < 0){
            Swal.fire({
                icon: 'warning',
                title: 'Discount Warning',
                text: 'Discount should not be less than 0',
                confirmButtonColor: '#d33'
            });
            $(this).val(0);
        } 
    });
    $(document).on('input', '.rate', 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 reserved = row.find('.availability').data('reserved');
        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 (availability == 0 && reserved < quantity) {
                        Swal.fire({
                            icon: 'warning',
                            title: 'Quantity exceeds stock!',
                            text: 'Available stock: ' + availability,
                            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="" >
                 <input type="hidden" class="company_gst" name="company_gst[]">
            </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" data-original="" readonly></td>
            <td><input type="text" name="roll_no[]" class="form-control rollno" readonly></td>
            <td>
                <select name="uom[]" class="form-control uom">
                    <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[]" oninput="this.value = this.value.replace(/[^0-9.]/g, '')" class="form-control quantity" required></td>
            <td><input type="text" name="rate[]" oninput="this.value = this.value.replace(/[^0-9.]/g, '')" class="form-control rate" step="0.01" required></td>
            <td><input type="text" name="labourRate[]" value="" data-labour-rate="0" class="form-control labourRate"></td>
            <td><input type="text"  value="`+parseFloat($('#coupon').find(':selected').data('coupon-amount') || 0)+`" oninput="this.value=this.value.replace(/[^0-9.]/g,'').replace(/(\\..*)\\./g,'$1')" name="item_discount[]" value="0" data-labour-rate="0" class="form-control item_discount"></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');
         const installerId = $("#installer_id").val();
        variantSel.empty().append('<option value="">Select Variant</option>');
        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_code} - ${v.varient_name}</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);
        }
        if(installerId){
            $.ajax({
                url: '/get-labour-rate',
                method: 'GET',
                data: { product_id: productId, installerId: installerId },
                success: function (response) {
                    console.log(response);
                    var rate = 0;
                    if(response){
                      rate = response.rate;
                    }
                    row.find('.labourRate').data('labour-rate',rate);
                },
                error: function () {
                    
                }
            });

        }
    });

    // =========================
    // 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;
                                            let values = [];
                                            let duplicate = '';
                                            $('#order-items tbody tr.order-row .rollno').each(function(){
                                                if($(this).val())
                                                values.push($(this).val());
                                            });
                                            if(values.includes(String(rollId))){
                                                duplicate = 'disabled';
                                            }
                                        const remaining = parseInt(roll.availability) - used;
                                            html += `
                                                <tr>
                                                    <td>
                                                        <input ${duplicate} type="checkbox" class="form-checkbox 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}">
                                                    </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;
                    let values = [];
                    let duplicate = '';
                    $('#order-items tbody tr.order-row .rollno').each(function(){
                        if($(this).val())
                        values.push($(this).val());
                    });
                    if(values.includes(String(rollId))){
                        duplicate = 'disabled';
                    }
                    const remaining = parseInt(roll.availability) - used;
                    if (remaining <= 0) return;

                    html += `
                        <tr>
                            <td>
                                <input ${duplicate} type="checkbox" class="form-checkbox 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}">
                            </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);
            setTimeout(function(){
                $('#warehouseModal').modal('show');

            },1000)
        },
        error: function (xhr) {
            console.error("Error fetching rolls: ", xhr.responseText);
        }
    });
}

$('.availability').each(function () {
    $(this).attr('data-original', $(this).val());
});
$(document).on('blur', '.quantity', function () {
    const $row = $(this).closest('tr');
    let uom = $row.find('.uom option:selected').text().toUpperCase().trim();
    // console.log("uom-=>",uom);
    let labourRate = parseFloat($row.find('.labourRate').data('labour-rate') || 0);
    const reserved = parseFloat($(this).data('reserved')) || 0;
    const newQuantity = parseFloat($(this).val()) || 0;
    const originalAvailability = parseFloat(
        $row.find('.availability').attr('data-original')
    ) || 0;

    // 🔥 Calculate difference
    const difference = newQuantity - reserved;
    let newAvailable;

    if (difference > 0) {
        // User increased quantity → reduce availability
        if (difference > originalAvailability) {
            alert('Entered quantity exceeds available stock.');
            $(this).val(reserved);
            return;
        }

        newAvailable = originalAvailability - difference;

    } else if (difference < 0) {
        // User decreased quantity → increase availability
        newAvailable = originalAvailability + Math.abs(difference);

    } else {
        // No change
        newAvailable = originalAvailability;
    }

    $row.find('.availability').val(newAvailable);

    // ✅ Calculate total using full quantity
    let totalLabourrate = 0;
    if(labourRate > 0){
        const convertedPrice = convertPrice(parseFloat(labourRate),'SQFT',uom);
        // console.log("converted Price",convertedPrice);
        totalLabourrate = parseFloat(convertedPrice * newQuantity).toFixed(2);
    }
    $row.find('.labourRate').val(totalLabourrate);
    const rate = parseFloat($row.find('.rate').val()) || 0;
    let selectedOption = parseFloat($('#coupon').find(':selected').data('coupon-amount') || 0);
    let subTotal = newQuantity * rate;
    let new_total = subTotal;
    let afterDiscount = 0;
    if(selectedOption > 0){
        afterDiscount = subTotal * selectedOption /100;
        console.log("afterDiscount",afterDiscount,"new_total",new_total);
        new_total -= afterDiscount;
    }
    console.log("new_total",new_total);
    $row.find('.total').val(new_total.toFixed(2)); // show in table
    $row.find('.total_ex_discount').remove();
    $row.append('<input type="hidden" class="total_ex_discount" name="total_ex_discount[]" value="'+subTotal.toFixed(2)+'">');
    // Total discount
    $row.find('.row_discount').remove();
    $row.append('<input type="hidden" class="row_discount" name="row_discount[]" value="'+afterDiscount.toFixed(2)+'">');
    recalcSubtotals();
    updateGstSummary();
});
$(document).on('input', '.quantity', function () {

    const $row = $(this).closest('tr');

    const reserved = parseFloat($(this).data('reserved')) || 0;
    const enteredQty = parseFloat($(this).val()) || 0;

    const originalAvailability = parseFloat(
        $row.find('.availability').attr('data-original')
    ) || 0;

    // 🔥 Max allowed quantity
    const maxAllowed = reserved + originalAvailability;
    if (enteredQty > maxAllowed) {
        alert('Max allowed quantity is ' + maxAllowed);
        $(this).val(maxAllowed);
    }
});
// 🔑 Add this global binding once, outside .variant-select
$(document).on('change', '.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 () {

    let modal = $('#rollModal');

    let activeRow = modal.data('activeRow'); // original row
    let lastRow   = modal.data('lastRow');   // last row used for insertion

    // Get roll data
    let availability = $(this).data('availability');
    let rollNo = $(this).data('roll-no');

    // If this is first selection → fill active row
    if (activeRow.find('.rollno').val() == '') {
        activeRow.find('.availability').val(availability)
        .attr('data-original', availability);
        activeRow.find('.rollno').val(rollNo);

        let originalAvailability = availability + (usedRollQuantities[rollNo] || 0);
        activeRow.data('original-availability', originalAvailability);

        modal.data('lastRow', activeRow); // now lastRow becomes activeRow
    }
    else {
        // From second selection onward → clone lastRow
        let newRow = lastRow.clone(true);
        let activeProduct = activeRow.find('.product-select').val();
        let activeVariant = activeRow.find('.variant-select').val();
        let activeWarehouse = activeRow.find('.warehouse-select').val();
        let activeUnit = activeRow.find('.uom option:selected').val();
        // console.log(activeUnit,"activeUnit")
        newRow.find('.product-select').val(activeProduct);
        newRow.find('.variant-select').val(activeVariant);
        newRow.find('.warehouse-select').val(activeWarehouse);
        newRow.find('.uom').val(activeUnit);
        newRow.find('.availability').val(availability);
        newRow.find('.rollno').val(rollNo);


        // reset qty & totals
        newRow.find('.quantity').val('');
        newRow.find('.total').val('');

        let originalAvailability = availability + (usedRollQuantities[rollNo] || 0);
        newRow.data('original-availability', originalAvailability);

        // insert after lastRow
        lastRow.after(newRow);

        // update lastRow reference
        modal.data('lastRow', newRow);
    }

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

    // =========================
    // 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 total = qty * rate;                               // INCL GST
    let selectedOption = parseFloat(row.find('.item_discount').val() || 0);
    let new_total = total;
    let afterDiscount = 0;
    if(selectedOption > 0){
        afterDiscount = total * selectedOption /100;
        new_total -= afterDiscount;
    }
    row.find('.total').val(new_total.toFixed(2)); // show in table
    row.find('.total_ex_discount').remove();
    row.append('<input type="hidden" class="total_ex_discount" name="total_ex_discount[]" value="'+total.toFixed(2)+'">');
    // show in table
    // Total discount
    row.find('.row_discount').remove();
    row.append('<input type="hidden" class="row_discount" name="row_discount[]" value="'+afterDiscount.toFixed(2)+'">');
}

// =========================
// Subtotals Calculation
// =========================
function recalcSubtotals() {
    let subtotal = 0;
    let itemTotal = 0;
    let labourRateTotal = 0;
    let discountTotal = 0;

    $('#order-items tbody tr.order-row').each(function () {
        const row = $(this);
        recalcRow(row);
        const rowTotal = parseFloat($(this).find('.total').val()) || 0;
        let rowDiscount = parseFloat($(this).find('.row_discount').val()) || 0; //Row Discount
        let total_ex_discount = parseFloat($(this).find('.total_ex_discount').val()) || 0; // Without Discount
        const labour_rate = parseFloat($(this).find('.labourRate').val()) || 0;

        itemTotal += total_ex_discount;
        labourRateTotal += labour_rate;
        subtotal += rowTotal;
        discountTotal += rowDiscount;
        
    });

    // Update subtotal fields
    $('input[name="itemTotal"]').val(itemTotal.toFixed(2));
    $('input[name="discount_total"]').val(discountTotal.toFixed(2));
    $('input[name="labourRateTotal"]').val(labourRateTotal.toFixed(2));
    $('input[name="subtotal"]').val(subtotal.toFixed(2));
    recalcGrandTotal();
}



    function recalcGrandTotal() {
        var subTotal = parseFloat($('input[name="subtotal"]').val()) || 0;
        // Forwarding
        let forwardingType = $('.forwarding_type').val();
        let forwardingVal = parseFloat($('.forwarding_input').val()) || 0;
        console.log("forwardingVal->",forwardingVal);
        if (forwardingType === 'percentage' && forwardingVal > 100) forwardingVal = 100;

        let forwardingAmt = (forwardingType === 'percentage')
            ? (subTotal * 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 labourCharges = parseFloat($(".labourRateTotal").val() || 0);
        let grandTotal = subTotal + forwardingAmt + labourCharges;
        if (grandTotal < 0) grandTotal = 0;
        $('input[name="grand_total"]').val(Math.round(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_type').on('change', function () {
        let type = $(this).val();
        $('.discount_unit').text(type === 'percentage' ? '%' : '₹');
        $('.disc_input').val('');
        $('.discount_amount').val('');
        recalcGrandTotal();
        updateGstSummary();
       
    });
    $('.forwarding_type').on('change', function () {
        let type = $(this).val();
        $('.forwarding_unit').text(type === 'percentage' ? '%' : '₹');
        $('.forwarding_input').val('');
        $('.forwarding_amount').val('');
        recalcGrandTotal();
        updateGstSummary();
    });

    // Discount/Forwarding → ONLY grand total
    $(document).on('change input', '.disc_input, .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 forwardingTotal = parseFloat($('.forwarding_amount').val()) || 0;
    const labourTotal = parseFloat($('.labourRateTotal').val()) || 0;
    // Global Forwarding GST details
    const forwardingHSN = "5245";
    const forwardingGST = 18;
    const labourHSN = $('#labour_gst_code').val();
    const labourGST = parseFloat($('#labour_gst_rate').val());

    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 labour_rate = parseFloat(row.querySelector('.labourRate')?.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 || '';
        let total = parseFloat(row.querySelector('.total')?.value || 0);

        if (qty === 0 || rate === 0 || !hsncode.trim()) return;

        let grossAmount = total;
        let amount = grossAmount;
        let gstAmount = grossAmount;

        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,
                labour: 0,
                cgst: 0,
                sgst: 0,
                igst: 0,
                total: 0
            };
        }
        gstGroups[key].taxable += item.amount;
        let customerTop = $('#customer_id option:selected').data('cust-state');
        let companyTop = $('#company_id option:selected').data('com-state');
         console.log("Supplier TOP:", customerTop , companyTop);

        if ((customerTop === 'oms' && companyTop === 'oms') || (customerTop === 'ms' && companyTop === 'oms') || (customerTop === 'oms' && companyTop === 'ms')) {
            gstGroups[key].igst += itemGstAmount;
        }else{
            gstGroups[key].cgst += itemGstAmount / 2;
            gstGroups[key].sgst += itemGstAmount / 2;
        }
        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;
        let customerTop = $('#customer_id option:selected').data('cust-state');
        let companyTop = $('#company_id option:selected').data('com-state');
        console.log("Supplier TOP:", customerTop , companyTop);
         if ((customerTop === 'oms' && companyTop === 'oms') || (customerTop === 'ms' && companyTop === 'oms') || (customerTop === 'oms' && companyTop === 'ms')) {
            gstGroups[fwdKey].igst += fwdGstAmount;
        }else{
             gstGroups[fwdKey].cgst += fwdGstAmount / 2;
        gstGroups[fwdKey].sgst += fwdGstAmount / 2;
        }
        
        gstGroups[fwdKey].total += fwdGstAmount;
    }
    if (labourTotal > 0) {
        let fwdGstAmount = (labourTotal * labourGST) / 100;

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

        gstGroups[fwdKey].labour += labourTotal;
        let customerTop = $('#customer_id option:selected').data('cust-state');
        let companyTop = $('#company_id option:selected').data('com-state');
        console.log("Supplier TOP:", customerTop , companyTop);
         if ((customerTop === 'oms' && companyTop === 'oms') || (customerTop === 'ms' && companyTop === 'oms') || (customerTop === 'oms' && companyTop === 'ms')) {
            gstGroups[fwdKey].igst += fwdGstAmount;
        }else{
             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 totalLabour = 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;
            totalLabour += data.labour;
            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)`;
            }
            if (data.labour > 0) {
               // hsnDisplay = `${data.hsn} (${data.forwarding.toFixed(2)})`;
                hsnDisplay = `${data.hsn} (Labour)`;
            }

            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
    let grand_total = parseFloat($('input[name="grand_total"]').val() || 0);
    let sub_grand_total = grand_total + totalGstSum;
    console.log("grand_total",grand_total,"totalGstSum",totalGstSum);
    document.getElementById('gst_total_input').value = totalGstSum.toFixed(2);
   
    $('input[name="grand_total"]').val(Math.round(sub_grand_total.toFixed(2)));
}
 function onLoadUpdateGstSummary() {
    let gstGroups = {};
    //console.log(subtotal);
    const forwardingTotal = parseFloat($('.forwarding_amount').val()) || 0;
    const labourTotal = parseFloat($('.labourRateTotal').val()) || 0;

    // Global Forwarding GST details
    const forwardingHSN = "5245";
    const forwardingGST = 18;
    const labourHSN = $('#labour_gst_code').val();
    const labourGST = parseFloat($('#labour_gst_rate').val());

    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 labour_rate = parseFloat(row.querySelector('.labourRate')?.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 || '';
        let total = parseFloat(row.querySelector('.total')?.value || 0);
      
        if (qty === 0 || rate === 0 || !hsncode.trim()) return;

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

        let grossAmount = total;
        let amount = grossAmount;
        let gstAmount = grossAmount;

        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,
                labour: 0,
                cgst: 0,
                sgst: 0,
                igst: 0,
                total: 0
            };
        }

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

        let customerTop = $('#customer_id option:selected').data('cust-state');
        let companyTop = $('#company_id option:selected').data('com-state');
         console.log("Supplier TOP:", customerTop , companyTop);

        if ((customerTop === 'oms' && companyTop === 'oms') || (customerTop === 'ms' && companyTop === 'oms') || (customerTop === 'oms' && companyTop === 'ms')) {
            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;
        let customerTop = $('#customer_id option:selected').data('cust-state');
        let companyTop = $('#company_id option:selected').data('com-state');
        console.log("Supplier TOP:", customerTop , companyTop);
         if ((customerTop === 'oms' && companyTop === 'oms') || (customerTop === 'ms' && companyTop === 'oms') || (customerTop === 'oms' && companyTop === 'ms')) {
            gstGroups[fwdKey].igst += fwdGstAmount;
        }else{
             gstGroups[fwdKey].cgst += fwdGstAmount / 2;
        gstGroups[fwdKey].sgst += fwdGstAmount / 2;
        }
        
        gstGroups[fwdKey].total += fwdGstAmount;
    }
    if (labourTotal > 0) {
        let fwdGstAmount = (labourTotal * labourGST) / 100;

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

        gstGroups[fwdKey].labour += labourTotal;
        let customerTop = $('#customer_id option:selected').data('cust-state');
        let companyTop = $('#company_id option:selected').data('com-state');
        console.log("Supplier TOP:", customerTop , companyTop);
         if ((customerTop === 'oms' && companyTop === 'oms') || (customerTop === 'ms' && companyTop === 'oms') || (customerTop === 'oms' && companyTop === 'ms')) {
            gstGroups[fwdKey].igst += fwdGstAmount;
        }else{
             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 totalLabour = 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;
            totalLabour += data.labour;
            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)`;
            }
            if (data.labour > 0) {
               // hsnDisplay = `${data.hsn} (${data.forwarding.toFixed(2)})`;
                hsnDisplay = `${data.hsn} (Labour)`;
            }

            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
    let grand_total = parseFloat($('input[name="grand_total"]').val() || 0);
    let sub_grand_total = grand_total + totalGstSum;
    console.log("grand_total",grand_total,"totalGstSum",totalGstSum);
    document.getElementById('gst_total_input').value = totalGstSum.toFixed(2);
    // $('input[name="grand_total"]').val(sub_grand_total.toFixed(2));
}





</script>