@extends('master')
@section('content')
    <div class="page-wrapper">
        <div class="content">
            <div class="page-header">
                <div class="page-title">
                    <h4>{{ __('sitelabel.AddNewFactorySaleOrder') }}</h4>
                    <h6>{{ __('sitelabel.CreatenewFactorySaleOrder') }}</h6>
                </div>
            </div>

            <form method="post" action="{{ url('/factorysaleorderprocess') }}" id="saleOrderForm">
                @csrf
                <div class="card">
                    <div class="card-body">
                        <div class="row">
                            <div class="col-lg-3 col-sm-6 col-12">
                                <div class="form-group">
                                    <label>{{ __('sitelabel.OrderDate') }} <span class="text-danger">*</span></label>
                                    <input type="date" class="form-control" name="txtOrderDate" id="txtOrderDate"
                                        value="{{ $defaultDate }}">
                                    @error('txtOrderDate')
                                        <span class="text-danger">{{ $message }}</span>
                                    @enderror
                                </div>
                            </div>
                            <div class="col-lg-3 col-sm-6 col-12">
                                <div class="form-group">
                                    <label>{{ __('sitelabel.BillNo') }} <span class="text-danger">*</span></label>
                                    <input type="text" class="form-control" name="txtBillNo" value="{{ $billNo }}"
                                        readonly>
                                    @error('txtBillNo')
                                        <span class="text-danger">{{ $message }}</span>
                                    @enderror
                                </div>
                            </div>
                            <div class="col-lg-3 col-sm-6 col-12">
                                <div class="form-group">
                                    <label>{{ __('sitelabel.Customer') }} <span class="text-danger">*</span></label>
                                    <select class="form-control" name="cmbCustomer" id="cmbCustomer">
                                        <option value="">{{ __('sitelabel.SelectCustomer') }}</option>
                                        @foreach ($customer as $cust)
                                            <option value="{{ $cust->Id }}">{{ $cust->CustomerName }}</option>
                                        @endforeach
                                    </select>
                                    @error('cmbCustomer')
                                        <span class="text-danger">{{ $message }}</span>
                                    @enderror
                                </div>
                            </div>
                            <div class="col-lg-3 col-sm-6 col-12 Price-List">
                                <div class="form-group">
                                    <label>{{ __('sitelabel.PriceList') }}</label>
                                    <select class="form-select" name="cmbPriceList" id="cmbPriceList">
                                        <option value="-1">{{ __('sitelabel.SelectCustomerFirst') }}</option>
                                    </select>
                                </div>
                            </div>

                            <div class="col-lg-3 col-sm-6 col-12">
                                <div class="form-group">
                                    <label>{{ __('sitelabel.Warehouse') }}</label>
                                    <select class="form-control" name="cmbWarehouse">
                                        <option value="">{{ __('sitelabel.SelectWarehouse') }}</option>
                                        @foreach ($warehouse as $wh)
                                            <option value="{{ $wh->Id }}">{{ $wh->Name }}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>
                            <div class="col-lg-3 col-sm-6 col-12">
                                <div class="form-group">
                                    <label for="cmbOption">Select Option <span class="text-danger">*</span></label>
                                    <select class="form-control" name="cmbOption" id="cmbOption">
                                        <option value="">Select Option</option>
                                        <option value="1">Local</option>
                                        <option value="2">Export</option>
                                    </select>
                                    @error('cmbOption')
                                        <span class="text-danger">{{ $message }}</span>
                                    @enderror
                                </div>
                            </div>
                            <div class="col-lg-3 col-sm-6 col-12">
                                <div class="form-group">
                                    <label>{{ __('sitelabel.DiscountValue') }}</label>
                                    <input type="text" class="form-control" id="txtDiscountValue" name="txtDiscountValue"
                                        readonly>
                                </div>
                            </div>
                            <div class="col-lg-3 col-sm-6 col-12">
                                <div class="form-group">
                                    <label>{{ __('sitelabel.CreditLimit') }}</label>
                                    <input type="text" class="form-control" id="txtCreditLimit" name="txtCreditLimit"
                                        readonly>
                                </div>
                            </div>
                            <div class="col-lg-3 col-sm-6 col-12">
                                <div class="form-group">
                                    <label>{{ __('sitelabel.CustomerClosingBalance') }}</label>
                                    <input type="text" class="form-control" id="txtCustomerClosingBalance"
                                        name="txtCustomerClosingBalance" readonly>
                                </div>
                            </div>
                            <div class="col-lg-3 col-sm-6 col-12">
                                <div class="form-group">
                                    <label>{{ __('sitelabel.Status') }} <span class="text-danger">*</span></label>
                                    <select class="form-control" id="chkStatus" name="chkStatus" required>
                                        <option value="0" {{ old('chkStatus') == 0 ? 'selected' : '' }}>Pending
                                        </option>
                                        <option value="1"
                                            {{ old('chkStatus') == 1 || !old('chkStatus') ? 'selected' : '' }}>Active
                                        </option>
                                        <option value="2" {{ old('chkStatus') == 2 ? 'selected' : '' }}>Inactive
                                        </option>
                                        <option value="3" {{ old('chkStatus') == 3 ? 'selected' : '' }}>Rejected
                                        </option>
                                        <option value="4" {{ old('chkStatus') == 4 ? 'selected' : '' }}>Cancelled
                                        </option>
                                        <option value="7" {{ old('chkStatus') == 7 ? 'selected' : '' }}>Finish
                                        </option>
                                    </select>
                                    @error('chkStatus')
                                        <span class="text-danger">{{ $message }}</span>
                                    @enderror
                                </div>
                            </div>
                            <div class="col-lg-3 col-sm-6">
                                <div class="form-group">
                                    <label>{{ __('sitelabel.GenerateInvoice') }}</label>
                                    <input type="checkbox" name="chkInvoice" id="chkInvoice">
                                </div>
                            </div>
                            <div class="col-lg-3 col-sm-6 Tax">
                                <div class="form-group">
                                    <label>{{ __('sitelabel.IsTaxable') }}</label>
                                    <input type="checkbox" name="chkSaleTaxInvStatus" id="chkSaleTaxInvStatus">
                                </div>
                            </div>
                            <div id="divTaxRate" class="col-lg-3 col-sm-6 col-12 taxRate" style="display: none">
                                <div class="form-group">
                                    <label>{{ __('sitelabel.TaxTreatment') }}</label>
                                    <select class="form-select" name="cmbTaxRate" id="cmbTaxRate">
                                        <option value="0">{{ __('sitelabel.SeleactTaxRate') }}</option>
                                        @foreach ($taxrate as $item)
                                            <option value="{{ $item->Id }}">{{ $item->Name }}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>
                        </div>
                        <div class="row">
                            <div class="col-lg-12">
                                <div class="form-group">
                                    <label>{{ __('sitelabel.Note') }}</label>
                                    <textarea class="form-control" name="txtNote"></textarea>
                                </div>
                            </div>
                        </div>

                        {{-- L --}}
                        <div class="row">
                            <div class="table-responsive">
                                <table class="table table-bordered">
                                    <thead>
                                        <tr>
                                            <th>{{ __('sitelabel.Product') }}</th>
                                            <th>{{ __('sitelabel.Name') }}</th>
                                            <th class="Bar-Code">{{ __('sitelabel.ScanBarCode') }}</th>
                                            <th>{{ __('sitelabel.SalePrice') }}</th>
                                            <th class="Discount">{{ __('sitelabel.Discount') }}</th>
                                            <th>{{ __('sitelabel.Quantity') }}</th>
                                            <th>{{ __('sitelabel.AvailableQuantity') }}</th>
                                            <th>{{ __('sitelabel.Action') }}</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <tr>
                                            <td>
                                                <select class="form-select" name="cmbProduct" id="cmbProduct">
                                                    <option value="-1">{{ __('sitelabel.SeleactMainProduct') }}
                                                    </option>
                                                    @foreach ($product as $product)
                                                        <option value="{{ $product->Id }}">
                                                            {{ $product->SKU }}-{{ $product->Name }}</option>
                                                    @endforeach
                                                </select>
                                            </td>
                                            <td>
                                                <input type="text" name="txtDescription" id="txtDescription"
                                                    class="form-control">
                                            </td>
                                            <td class="Bar-Code">
                                                <input type="text" name="txtBarCode" id="txtBarCode"
                                                    class="form-control">
                                            </td>
                                            <td>
                                                <input type="hidden" class="form-control" name="hdProductId"
                                                    id="hdProductId">
                                                <input type="number" class="form-control" name="txtSalePrice"
                                                    id="txtSalePrice" step="0.01">
                                                <input type="hidden" class="form-control" name="hdName"
                                                    id="hdName">
                                                <input type="hidden" class="form-control" name="hdProductCode"
                                                    id="hdProductCode">
                                                <input type="hidden" class="form-control" name="hdPurchasePrice"
                                                    id="hdPurchasePrice">
                                                <input type="hidden" class="form-control" name="hdWholeSalePrice"
                                                    id="hdWholeSalePrice">
                                                <input type="hidden" class="form-control" name="hdTaxRate"
                                                    id="hdTaxRate">
                                                <input type="hidden" class="form-control" name="hdTaxValue"
                                                    id="hdTaxValue">
                                                <input type="hidden" class="form-control" name="hdProductCode"
                                                    id="hdPicturePath">
                                            </td>
                                            <td class="Discount">
                                                <input type="number" class="form-control" id="txtDiscount"
                                                    name="txtDiscount">
                                            </td>
                                            <td>
                                                <input type="number" class="form-control" id="txtQty" name="txtQty"
                                                    min="0">
                                            </td>
                                            <td>
                                                <input type="text" class="form-control" id="txtAvailableQuantity"
                                                    name="txtAvailableQuantity" value="0" readonly>
                                            </td>
                                            <td>
                                                <button id="btnAdd" type="button" name="btnAdd"
                                                    class="btn btn-my-primary">{{ __('sitelabel.Add') }}</button>
                                            </td>
                                        </tr>
                                    </tbody>
                                </table>

                            </div>
                        </div>

                        <div class="row">
                            <div class="table-responsive">
                                <table class="table">
                                    <thead>
                                        <tr>
                                            <th>{{ __('sitelabel.SerialNumber') }}</th>
                                            <th>{{ __('sitelabel.Product') }}</th>
                                            <th>{{ __('sitelabel.Name') }}</th>
                                            <th>{{ __('sitelabel.Qty') }}</th>
                                            <th>{{ __('sitelabel.SalePrice') }}</th>
                                            <th>{{ __('sitelabel.SubTotal') }}</th>
                                            <th class="Discount">{{ __('sitelabel.Disc') }}</th>
                                            <th class="Tax">{{ __('sitelabel.STax') }}</th>
                                            <th>{{ __('sitelabel.NetAmt') }}</th>
                                            <th>{{ __('sitelabel.Action') }}</th>
                                        </tr>
                                    </thead>
                                    <tbody id="tdOrderDetailBody">
                                        {{-- Rows Will Be Populated By Js --}}
                                    </tbody>
                                </table>
                                <table class="table">
                                    <thead>
                                        <tr>
                                            <th>&nbsp;</th>
                                            <th>
                                                <strong>{{ __('sitelabel.SubTotal') }}</strong>
                                            </th>
                                            <th>&nbsp;</th>
                                            <th>&nbsp;</th>
                                            <th>&nbsp;</th>
                                            <th>&nbsp;</th>
                                            <th>&nbsp;</th>
                                            <th>&nbsp;</th>
                                            <th>&nbsp;</th>
                                            <th>&nbsp;</th>
                                            <th>&nbsp;</th>
                                            <th class="text-end">
                                                <strong>
                                                    <span id="spSubTotal"></span>
                                                    <input type="hidden" class="form-control" name="hdMainSubTotal"
                                                        id="hdMainSubTotal">
                                                </strong>
                                            </th>
                                            <th></th>
                                        </tr>
                                        <tr class="Discount">
                                            <th>&nbsp;</th>
                                            <th>
                                                <strong>{{ __('sitelabel.Discount') }}</strong>
                                            </th>
                                            <th>&nbsp;</th>
                                            <th>&nbsp;</th>
                                            <th>&nbsp;</th>
                                            <th>&nbsp;</th>
                                            <th>&nbsp;</th>
                                            <th>&nbsp;</th>
                                            <th>&nbsp;</th>
                                            <th>&nbsp;</th>
                                            <th>&nbsp;</th>
                                            <th class="text-end">
                                                <strong>
                                                    <span id="spDiscount"></span>
                                                    <input type="hidden" class="form-control" name="hdMainDiscount"
                                                        id="hdMainDiscount">
                                                </strong>
                                            </th>
                                            <th></th>
                                        </tr>
                                        <tr class="Tax">
                                            <th>&nbsp;</th>
                                            <th>
                                                <strong>{{ __('sitelabel.Tax') }}</strong>
                                            </th>
                                            <th>&nbsp;</th>
                                            <th>&nbsp;</th>
                                            <th>&nbsp;</th>
                                            <th>&nbsp;</th>
                                            <th>&nbsp;</th>
                                            <th>&nbsp;</th>
                                            <th>&nbsp;</th>
                                            <th>&nbsp;</th>
                                            <th>&nbsp;</th>
                                            <th class="text-end">
                                                <strong>
                                                    <span id="spTax"></span>
                                                    <input type="hidden" class="form-control" name="hdMainSaleTax"
                                                        id="hdMainSaleTax">
                                                </strong>
                                            </th>
                                            <th></th>
                                        </tr>
                                        <tr>
                                            <th>&nbsp;</th>
                                            <th>
                                                <strong>{{ __('sitelabel.NetAmount') }}</strong>
                                            </th>
                                            <th>&nbsp;</th>
                                            <th>&nbsp;</th>
                                            <th>&nbsp;</th>
                                            <th>&nbsp;</th>
                                            <th>&nbsp;</th>
                                            <th>&nbsp;</th>
                                            <th>&nbsp;</th>
                                            <th>&nbsp;</th>
                                            <th>&nbsp;</th>
                                            <th class="text-end">
                                                <strong>
                                                    <span id="spTotal"></span>
                                                    <input type="hidden" class="form-control" name="hdMainNetTotal"
                                                        id="hdMainNetTotal">
                                                </strong>
                                            </th>
                                            <th></th>
                                        </tr>
                                    </thead>
                                </table>
                            </div>
                        </div>

                        <div class="col-lg-12">
                            <button type="submit" class="btn btn-primary">{{ __('sitelabel.Save') }}</button>
                            <button type="button" onclick="javascript:window.location='{{ url('/factorysaleorder') }}';"
                                class="btn btn-dark">{{ __('sitelabel.Back') }}</button>
                        </div>
                    </div>
                </div>
            </form>
        </div>
    </div>
@endsection

@section('script')
    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>
    <script>
        var gSubTotal = 0;
        var gDiscount = 0;
        var gTax = 0;
        var gNetAmount = 0;

        $(document).ready(function() {
            var RowId = 1;
            var gTaxRate = 0;
            var gNetAmount = 0;
            var currentPriceListId = -1;

            // Initialize Select2
            $('#cmbCustomer, #cmbWarehouse, #cmbOption, #cmbTaxRate, #cmbProduct, #cmbPriceList, #chkStatus').select2({
                theme: "bootstrap-5",
                width: '100%'
            });

            // Handle tax checkbox change
            $('#chkSaleTaxInvStatus').change(function() {
                if ($(this).is(':checked')) {
                    $('#divTaxRate').show();
                } else {
                    $('#divTaxRate').hide();
                    $('#cmbTaxRate').val('0').trigger('change');
                }
            });

            // Tax rate change handler
            $("#cmbTaxRate").change(function() {
                var TaxRateId = $(this).val();
                if (TaxRateId != 0) {
                    $.ajax({
                        type: "GET",
                        url: "/api/GetTaxRateById/" + TaxRateId,
                        contentType: "application/json;charset=utf-8",
                        success: function(data) {
                            $.each(data, function(key, item) {
                                for (var index = 0; index < item.length; index++) {
                                    gTaxRate = item[index].TaxRate;
                                }
                            });
                        },
                        error: function(error) {
                            console.error("Error fetching tax rate:", error);
                            gTaxRate = 0;
                        }
                    });
                } else {
                    gTaxRate = 0;
                }
            });

            // Customer selection handler
            $('#cmbCustomer').change(function() {
                var customerId = $(this).val();
                var orderDate = $('#txtOrderDate').val();
                $('#txtCustomerName').val($('#cmbCustomer option:selected').text());

                if (customerId && customerId !== "-1") {
                    $.ajax({
                        type: "GET",
                        url: "/api/GetPriceListByCustomerId/" + customerId,
                        success: function(data) {
                            $('#cmbPriceList').empty();
                            $('#cmbPriceList').append(data).prop('disabled', false);
                        },
                        error: function(xhr, status, error) {
                            console.error("Error fetching price lists:", error);
                            $('#cmbPriceList').empty();
                            $('#cmbPriceList').append(
                                '<option value="-1">No price lists available</option>');
                            $('#cmbPriceList').prop('disabled', false);
                        }
                    });

                    // Fetch chart of account
                    $.ajax({
                        type: "GET",
                        url: "/api/GetCustomerById/" + customerId + "&odate=" + orderDate,
                        success: function(data) {
                            if (data && data.customer && data.customer.length > 0) {
                                var customer = data.customer[0];

                                $("#hdChartOfAccountId").val(customer.ChartOfAccountId || '');
                                $('#txtDiscountValue').val(customer.DiscountValue || 0);
                                $('#txtDiscount').val(customer.DiscountValue || 0);
                                $('#txtCreditLimit').val(customer.CreditLimit || 0);
                                $('#txtCustomerClosingBalance').val(data.closingBalance || 0);
                            } else {
                                $("#hdChartOfAccountId").val('');
                                $('#txtDiscountValue').val(0);
                                $('#txtDiscount').val(0);
                                $('#txtCreditLimit').val(0);
                                $('#txtCustomerClosingBalance').val(0);
                            }
                        },
                        error: function(xhr, status, error) {
                            console.error("Error fetching customer data:", error);
                        }
                    });
                } else {
                    $('#txtDiscountValue').val('0');
                    $('#txtDiscount').val('0');
                    $('#txtCreditLimit').val('0');
                    $('#txtCustomerClosingBalance').val('0');
                    $('#cmbPriceList').empty().append('<option value="-1">Select Customer First</option>')
                        .prop('disabled', true);
                    $("#hdChartOfAccountId").val('');
                }
            });

            // Price list change handler
            $("#cmbPriceList").change(function() {
                currentPriceListId = $(this).val();
                // If a product is already selected, update its price
                var currentProductId = $("#cmbProduct").val();
                if (currentProductId != -1) {
                    updateProductPrice(currentProductId);
                }
            });

            // Product selection handler
            $("#cmbProduct").change(function() {
                var productId = $(this).val();
                if (productId != -1) {
                    updateProductPrice(productId);
                } else {
                    clearProductFields();
                }
            });

            // Handle barcode input
            $("#txtBarCode").on('keydown', function(e) {
                if (e.keyCode === 13) { // Enter key
                    e.preventDefault();
                    var barcode = $(this).val().trim();
                    if (barcode) {
                        $.ajax({
                            type: "GET",
                            url: "/GetProductByBarcode",
                            data: {
                                barcode: barcode
                            },
                            success: function(data) {
                                if (data && data.Id) {
                                    // Set the product dropdown value and trigger change
                                    $("#cmbProduct").val(data.Id).trigger('change');
                                } else {
                                    alert("Product not found with barcode: " + barcode);
                                    $("#txtBarCode").val('').focus();
                                }
                            },
                            error: function(error) {
                                console.error("Error fetching product by barcode:", error);
                                alert("Error searching product. Please try again.");
                                $("#txtBarCode").val('').focus();
                            }
                        });
                    }
                }
            });

            // Warehouse selection handler
            $("#cmbWarehouse").change(function() {
                $('#txtWarehouseName').val($('#cmbWarehouse option:selected').text());
                updateAvailableQuantity();
            });

            // Option (Local/Export) selection handler  
            $("#cmbOption").change(function() {
                var optionVal = $(this).val();
                if (optionVal) {
                    $('#cmbLocalExport').val(optionVal);
                    // Show tax field for local sale (1) and hide for export (2)
                    if (optionVal == "1") {
                        $('.Tax').show();
                    } else {
                        $('.Tax').hide();
                        $('#chkSaleTaxInvStatus').prop('checked', false).trigger('change');
                    }
                }
            });

            // Function to fetch product by barcode
            function fetchProductByBarcode(barcode) {
                $.ajax({
                    type: "GET",
                    url: "/GetProductByBarcode",
                    data: {
                        barcode: barcode
                    },
                    success: function(data) {
                        if (data && data.Id) {
                            $("#cmbProduct").val(data.Id).trigger('change');
                        } else {
                            alert("Product not found with barcode: " + barcode);
                            $("#txtBarCode").val('').focus();
                        }
                    },
                    error: function(error) {
                        console.error("Error fetching product by barcode:", error);
                        alert("Error searching product. Please try again.");
                        $("#txtBarCode").val('').focus();
                    }
                });
            }

            function updateProductPrice(productId) {
                if (productId == -1) return;

                $.ajax({
                    type: "GET",
                    url: "/api/GetProductByIdandPriceList/" + productId,
                    data: {
                        priceListId: currentPriceListId
                    },
                    success: function(data) {
                        if (data && data.length > 0 && data[0].length > 0) {
                            var product = data[0][0];

                            // Log the entire product object to verify data
                            console.log("Product data:", product);

                            // Set all product fields
                            $("#hdProductId").val(product.Id);
                            $("#txtSalePrice").val(product.SalePrice || '');
                            $("#txtBundle").val(product.Bundle ||
                                ''); // Note: 'Bundle' isn’t in your response; might be a typo
                            $("#hdPicturePath").val(product.Thumbnai ||
                                ''
                            );
                            $("#hdTaxValue").val(product.TaxValue || 0);
                            $("#hdTaxRate").val(product.TaxRate || 0);
                            $("#hdWholeSalePrice").val(product.WholeSalePrice || 0);
                            $("#hdPurchasePrice").val(product.PurchasePrice || 0);
                            $("#hdProductCode").val(product.SKU || '');
                            $("#hdName").val(product.Name || '');
                            $("#txtDescription").val(product.Name || '');
                            $("#txtBarCode").val(product.BarCode || '');
                            $("#txtBarCode").trigger('change');
                            $("#txtBarCode").focus().blur();

                            updateAvailableQuantity();

                            // Set focus to quantity field
                            $("#txtQty").focus().select();
                        } else {
                            clearProductFields();
                            alert("Product details not found!");
                        }
                    },
                    error: function(error) {
                        console.error("Error fetching product details:", error);
                        clearProductFields();
                        alert("Error loading product details. Please try again.");
                    }
                });
            }

            // Function to update available quantity
            function updateAvailableQuantity() {
                var productId = $("#hdProductId").val();
                var warehouseId = $("#cmbWarehouse").val();

                if (productId && warehouseId) {
                    $.ajax({
                        type: "GET",
                        url: "/GetProductStock",
                        data: {
                            productId: productId,
                            warehouseId: warehouseId
                        },
                        success: function(data) {
                            $("#txtAvailableQuantity").val(data.quantity || 0);
                        },
                        error: function(error) {
                            console.error("Error fetching product stock:", error);
                            $("#txtAvailableQuantity").val(0);
                        }
                    });
                } else {
                    $("#txtAvailableQuantity").val(0);
                }
            }

            // Clear product fields
            function clearProductFields() {
                $("#hdProductId").val('');
                $("#txtSalePrice").val('');
                $("#txtBundle").val('');
                $("#hdPicturePath").val('');
                $("#hdTaxValue").val(0);
                $("#hdTaxRate").val(0);
                $("#hdWholeSalePrice").val(0);
                $("#hdPurchasePrice").val(0);
                $("#hdProductCode").val('');
                $("#hdName").val('');
                $("#txtDescription").val('');
                $("#txtBarCode").val('');
                $("#txtAvailableQuantity").val(0);
            }

            // Add button click handler
            $("#btnAdd").click(function() {
                var productId = $("#hdProductId").val();
                var qty = $("#txtQty").val();
                var salePrice = $("#txtSalePrice").val();
                var discount = $("#txtDiscount").val() || 0;

                // Validation
                if (!productId || productId == "-1") {
                    alert("Please select a valid product.");
                    return;
                }

                if (!qty || isNaN(qty) || parseFloat(qty) <= 0) {
                    alert("Please enter a valid quantity.");
                    $("#txtQty").focus();
                    return;
                }

                if (!salePrice || isNaN(salePrice) || parseFloat(salePrice) <= 0) {
                    alert("Please enter a valid sale price.");
                    $("#txtSalePrice").focus();
                    return;
                }

                // Get product details
                var productCode = $("#hdProductCode").val();
                var productName = $("#hdName").val();
                var description = $("#txtDescription").val();
                var bundle = $("#txtBundle").val() || '';

                // Calculate totals
                qty = parseFloat(qty);
                salePrice = parseFloat(salePrice);
                discount = parseFloat(discount);

                var subTotal = salePrice * qty;
                var discountAmount = 0;

                // Calculate discount
                if (discount > 0) {
                    discountAmount = (subTotal * discount) / 100;
                }

                // Calculate tax
                var taxRate = 0;
                var taxValue = 0;

                if ($("#chkSaleTaxInvStatus").is(':checked')) {
                    if (gTaxRate > 0) {
                        taxRate = gTaxRate;
                    } else {
                        taxRate = parseFloat($("#hdTaxRate").val() || 0);
                    }

                    if (taxRate > 0) {
                        taxValue = ((salePrice * taxRate) / 100) * qty;
                    }
                }

                // Calculate net amount
                var netAmount = subTotal - discountAmount + taxValue;

                // Update order totals
                gSubTotal += subTotal;
                gDiscount += discountAmount;
                gTax += taxValue;
                gNetAmount = gSubTotal - gDiscount + gTax;

                // Update UI
                $("#spSubTotal").html(formatNumber(gSubTotal));
                $("#hdMainSubTotal").val(gSubTotal);
                $("#spDiscount").html(formatNumber(gDiscount));
                $("#hdMainDiscount").val(gDiscount);
                $("#spTax").html(formatNumber(gTax));
                $("#hdMainSaleTax").val(gTax);
                $("#spTotal").html(formatNumber(gNetAmount));
                $("#hdMainNetTotal").val(gNetAmount);

                // Add row to table
                var html = `
                    <tr id="tr${RowId}">
                        <td>${RowId}</td>
                        <td>
                            <input type="hidden" name="orderItems[${RowId-1}][itemId]" value="${productId}">
                            <div class="productimg">
                                <div class="productcontet">
                                    <h4>${productName}</h4>
                                    <div class="productlinkset">
                                        <h5>${productCode}</h5>
                                    </div>
                                </div>
                            </div>
                        </td>
                        <td>
                            <input type="hidden" name="orderItems[${RowId-1}][description]" value="${description}">
                            ${description}
                        </td>
                        <td>
                            <input type="hidden" name="orderItems[${RowId-1}][quantity]" value="${qty}">
                            ${qty}
                        </td>
                        <td>
                            <input type="hidden" name="orderItems[${RowId-1}][salePrice]" value="${salePrice}">
                            ${formatNumber(salePrice)}
                        </td>
                        <td>
                            <input type="hidden" id="hdOrdSubTotal${RowId}" name="orderItems[${RowId-1}][totalAmount]" value="${subTotal}">
                            ${formatNumber(subTotal)}
                        </td>
                        <td class="Discount">
                            <input type="hidden" id="hdOrdDiscountTotal${RowId}" name="orderItems[${RowId-1}][discountValue]" value="${discountAmount}">
                            <input type="hidden" name="orderItems[${RowId-1}][discountType]" value="Per">
                            <input type="hidden" name="orderItems[${RowId-1}][discountPercent]" value="${discount}">
                            ${formatNumber(discountAmount)}
                        </td>
                        <td class="Tax">
                            <input type="hidden" id="hdOrdTaxRateTotal${RowId}" name="orderItems[${RowId-1}][taxRate]" value="${taxRate}">
                            <input type="hidden" id="hdOrdTaxValueTotal${RowId}" name="orderItems[${RowId-1}][taxValue]" value="${taxValue}">
                            ${formatNumber(taxValue)}
                        </td>
                        <td>
                            <input type="hidden" id="hdOrdNetTotal${RowId}" name="orderItems[${RowId-1}][netAmount]" value="${netAmount}">
                            ${formatNumber(netAmount)}
                        </td>
                        <td>
                            <a href="javascript:void(0);" class="delete-btn" data-row-id="${RowId}">
                                <img src="/admin/assets/img/icons/delete-2.svg" alt="img">
                            </a>
                        </td>
                    </tr>
                `;

                $('#tdOrderDetailBody').append(html);

                // Increment row counter and clear fields
                RowId++;
                clearProductFields();
                $("#txtQty").val('');
                $("#cmbProduct").val("-1").trigger('change');
            });

            // Add form submission handler
            $("#saleOrderForm").submit(function(e) {
                // Check if order has items
                if ($("#tdOrderDetailBody tr").length === 0) {
                    e.preventDefault();
                    alert("Please add at least one product to the order.");
                    return false;
                }

                // Set hidden fields before submit
                $("#txtOrderTotal").val(gSubTotal);
                $("#txtDiscountTotal").val(gDiscount);
                $("#txtSalesTax").val(gTax);
                $("#txtNetAmount").val(gNetAmount);

                return true;
            });
        });
        // Event delegation for delete button
        $('#tdOrderDetailBody').on('click', '.delete-btn', function() {
            var rowId = $(this).data('row-id');
            DeleteProduct(rowId);
        });

        // Format number with thousand separators
        function formatNumber(num) {
            return parseFloat(num).toFixed(2).replace(/\d(?=(\d{3})+\.)/g, '$&,');
        }

        function DeleteProduct(rowId) {
            var sSubTotal = "#hdOrdSubTotal" + rowId;
            var sDiscount = "#hdOrdDiscountTotal" + rowId;
            var sTax = "#hdOrdTaxValueTotal" + rowId;
            var sNetTotal = "#hdOrdNetTotal" + rowId;

            // Update global totals
            gSubTotal -= parseFloat($(sSubTotal).val() || 0);
            gDiscount -= parseFloat($(sDiscount).val() || 0);
            gTax -= parseFloat($(sTax).val() || 0);
            gNetAmount = gSubTotal - gDiscount + gTax;

            // Update UI
            $("#spSubTotal").html(formatNumber(gSubTotal));
            $("#hdMainSubTotal").val(gSubTotal);
            $("#spDiscount").html(formatNumber(gDiscount));
            $("#hdMainDiscount").val(gDiscount);
            $("#spTax").html(formatNumber(gTax));
            $("#hdMainSaleTax").val(gTax);
            $("#spTotal").html(formatNumber(gNetAmount));
            $("#hdMainNetTotal").val(gNetAmount);

            // Remove row immediately
            $("#tr" + rowId).remove();
        }
    </script>
@endsection