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

            <form method="post" action="{{ url('/updatefactorysaleorder/' . $saleorder->Id) }}" id="saleOrderForm">
                @csrf
                @method('PUT')
                <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" value="{{ $saleorder->OrderDate }}">
                                    @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="{{ $saleorder->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 }}" {{ $saleorder->CustomerId == $cust->Id ? 'selected' : '' }}>
                                                {{ $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">
                                <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 }}" {{ $saleorder->WarehouseId == $wh->Id ? 'selected' : '' }}>
                                                {{ $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" {{ $saleorder->LocalExport == 1 ? 'selected' : '' }}>Local</option>
                                        <option value="2" {{ $saleorder->LocalExport == 2 ? 'selected' : '' }}>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" value="{{ $saleorder->DiscountValue }}" 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" {{ $saleorder->Status == 0 ? 'selected' : '' }}>Pending</option>
                                        <option value="1" {{ $saleorder->Status == 1 ? 'selected' : '' }}>Active</option>
                                        <option value="2" {{ $saleorder->Status == 2 ? 'selected' : '' }}>Inactive</option>
                                        <option value="3" {{ $saleorder->Status == 3 ? 'selected' : '' }}>Rejected</option>
                                        <option value="4" {{ $saleorder->Status == 4 ? 'selected' : '' }}>Cancelled</option>
                                        <option value="7" {{ $saleorder->Status == 7 ? 'selected' : '' }}>Finish</option>
                                    </select>
                                    @error('chkStatus')
                                        <span class="text-danger">{{ $message }}</span>
                                    @enderror
                                </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" {{ $saleorder->IsTaxable ? 'checked' : '' }}>
                                </div>
                            </div>
                            <div id="divTaxRate" class="col-lg-3 col-sm-6 col-12 taxRate" style="display: {{ $saleorder->IsTaxable ? 'block' : '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">{{ $saleorder->Note }}</textarea>
                                </div>
                            </div>
                        </div>

                        <!-- Product Input Section -->
                        <div class="row">
                            <div class="table-responsive">
                                <table class="table table-bordered">
                                    <thead>
                                        <tr>
                                            <th>{{ __('sitelabel.Product') }}</th>
                                            <th>{{ __('sitelabel.Name') }}</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 $prod)
                                                        <option value="{{ $prod->Id }}">{{ $prod->SKU }}-{{ $prod->Name }}</option>
                                                    @endforeach
                                                </select>
                                            </td>
                                            <td><input type="text" name="txtDescription" id="txtDescription" 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="hdTaxRate" id="hdTaxRate">
                                                <input type="hidden" class="form-control" name="hdTaxValue" id="hdTaxValue">
                                            </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" class="btn btn-my-primary">{{ __('sitelabel.Add') }}</button></td>
                                        </tr>
                                    </tbody>
                                </table>
                            </div>
                        </div>

                        <!-- Order Details Table -->
                        <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">
                                        <!-- Pre-populated rows will be added via JavaScript -->
                                    </tbody>
                                </table>
                                <table class="table">
                                    <thead>
                                        <tr>
                                            <th><strong>{{ __('sitelabel.SubTotal') }}</strong></th>
                                            <th class="text-end"><span id="spSubTotal">{{ number_format($saleorder->OrderTotal, 2) }}</span></th>
                                            <input type="hidden" name="hdMainSubTotal" id="hdMainSubTotal" value="{{ $saleorder->OrderTotal }}">
                                        </tr>
                                        <tr class="Discount">
                                            <th><strong>{{ __('sitelabel.Discount') }}</strong></th>
                                            <th class="text-end"><span id="spDiscount">{{ number_format($saleorder->DiscountTotal, 2) }}</span></th>
                                            <input type="hidden" name="hdMainDiscount" id="hdMainDiscount" value="{{ $saleorder->DiscountTotal }}">
                                        </tr>
                                        <tr class="Tax">
                                            <th><strong>{{ __('sitelabel.Tax') }}</strong></th>
                                            <th class="text-end"><span id="spTax">{{ number_format($saleorder->SalesTax, 2) }}</span></th>
                                            <input type="hidden" name="hdMainSaleTax" id="hdMainSaleTax" value="{{ $saleorder->SalesTax }}">
                                        </tr>
                                        <tr>
                                            <th><strong>{{ __('sitelabel.NetAmount') }}</strong></th>
                                            <th class="text-end"><span id="spTotal">{{ number_format($saleorder->NetAmount, 2) }}</span></th>
                                            <input type="hidden" name="hdMainNetTotal" id="hdMainNetTotal" value="{{ $saleorder->NetAmount }}">
                                        </tr>
                                    </thead>
                                </table>
                            </div>
                        </div>

                        <div class="col-lg-12">
                            <button type="submit" class="btn btn-primary">{{ __('sitelabel.Update') }}</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 = {{ $saleorder->OrderTotal }};
        var gDiscount = {{ $saleorder->DiscountTotal }};
        var gTax = {{ $saleorder->SalesTax }};
        var gNetAmount = {{ $saleorder->NetAmount }};
        var RowId = 1;

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

            // Pre-populate order details
            var saleOrderDetails = @json($saleorderdetails);
            saleOrderDetails.forEach(function(item, index) {
                addExistingItem(item, index);
                RowId = index + 2; // Update RowId for new items
            });

            // Handle tax checkbox
            $('#chkSaleTaxInvStatus').change(function() {
                $('#divTaxRate').toggle(this.checked);
                if (!this.checked) {
                    $('#cmbTaxRate').val('0').trigger('change');
                }
            });

            // 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('');
                }
            });

            // Product selection and add logic (similar to add form)
            $("#cmbProduct").change(function() {
                var productId = $(this).val();
                if (productId != -1) {
                    $.ajax({
                        type: "GET",
                        url: "/api/GetProductByIdandPriceList/" + productId,
                        success: function(data) {
                            if (data && data.length > 0 && data[0].length > 0) {
                                var product = data[0][0];
                                $("#hdProductId").val(product.Id);
                                $("#txtSalePrice").val(product.SalePrice);
                                $("#hdName").val(product.Name);
                                $("#txtDescription").val(product.Name);
                                $("#hdProductCode").val(product.SKU);
                                $("#hdTaxRate").val(product.TaxRate || 0);
                                $("#hdTaxValue").val(product.TaxValue || 0);
                                updateAvailableQuantity();
                                $("#txtQty").focus().select();
                            }
                        }
                    });
                }
            });

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

                if (!productId || !qty || !salePrice) {
                    alert("Please fill all required fields.");
                    return;
                }

                var subTotal = parseFloat(salePrice) * parseFloat(qty);
                var discountAmount = discount ? (subTotal * parseFloat(discount)) / 100 : 0;
                var taxRate = $("#chkSaleTaxInvStatus").is(':checked') ? parseFloat($("#hdTaxRate").val() || 0) : 0;
                var taxValue = taxRate ? ((subTotal - discountAmount) * taxRate) / 100 : 0;
                var netAmount = subTotal - discountAmount + taxValue;

                gSubTotal += subTotal;
                gDiscount += discountAmount;
                gTax += taxValue;
                gNetAmount = gSubTotal - gDiscount + gTax;

                updateTotals();

                var html = generateRowHtml(RowId, productId, $("#hdName").val(), $("#hdProductCode").val(), qty, salePrice, subTotal, discountAmount, discount, taxRate, taxValue, netAmount);
                $('#tdOrderDetailBody').append(html);

                RowId++;
                clearProductFields();
            });

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

        function addExistingItem(item, index) {
            var html = generateRowHtml(
                index + 1,
                item.ItemId,
                item.Name || 'Product ' + item.ItemId, // You might need to join with product table to get name
                item.SKU || 'SKU-' + item.ItemId,     // Same for SKU
                item.Quantity,
                item.SalePrice,
                item.TotalAmount,
                item.DiscountValue,
                item.DiscPerFlat,
                item.TaxRate,
                item.TaxValue,
                item.NetAmount
            );
            $('#tdOrderDetailBody').append(html);
        }

        function generateRowHtml(rowId, productId, name, code, qty, salePrice, subTotal, discountAmount, discountPercent, taxRate, taxValue, netAmount) {
            return `
                <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>${name}</h4>
                                <div class="productlinkset"><h5>${code}</h5></div>
                            </div>
                        </div>
                    </td>
                    <td>${name}</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="percent">
                        <input type="hidden" name="orderItems[${rowId-1}][discountPercent]" value="${discountPercent}">
                        ${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>
            `;
        }

        function updateTotals() {
            $("#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);
        }

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

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

            updateTotals();
            $("#tr" + rowId).remove();
        }

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

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

        function clearProductFields() {
            $("#hdProductId").val('');
            $("#txtSalePrice").val('');
            $("#hdName").val('');
            $("#txtDescription").val('');
            $("#hdProductCode").val('');
            $("#hdTaxRate").val(0);
            $("#hdTaxValue").val(0);
            $("#txtQty").val('');
            $("#txtDiscount").val('');
            $("#txtAvailableQuantity").val(0);
            $("#cmbProduct").val("-1").trigger('change');
        }
    </script>
@endsection