@extends('layouts.default')

@section('content')

<link href="css/plugins/dataTables/datatables.min.css" rel="stylesheet">

<div class="modal inmodal fade" id="ProductInfo" tabindex="-1" role="dialog" aria-hidden="true">
    <form id="product" method="POST" action="{{ route('add-product') }}">
        @csrf
        <div class="modal-dialog modal-lg">
            <div class="modal-content">
                <div class="modal-header">
                    <button type="button" class="close" data-dismiss="modal"><span
                            aria-hidden="true">&times;</span><span class="sr-only">Close</span></button>
                    <h4 class="modal-title">Product Information</h4>
                </div>

                <div class="modal-body">
                    <div id="success-message" class="alert alert-success" style="display: none;">
                        <span></span>
                    </div>

                    <div class="form-group row">
                        <label class="col-sm-2 col-form-label">Category <span class="text-danger">*</span></label>
                        <div class="col-sm-4">
                            <select class="form-control" id="product_category_id" name="category_id">
                                <option value="">Select Category</option>
                                @foreach($categories as $category)
                                    <option value="{{ $category->id }}">{{ $category->name }}</option>
                                @endforeach
                            </select>
                            <div class="invalid-feedback" id="error-category_id" style="display: none;">Category is required</div>
                        </div>
                        <label class="col-sm-2 col-form-label">Subcategory <span class="text-danger">*</span></label>
                        <div class="col-sm-4">
                            <select class="form-control" id="product_subcategory_id" name="subcategory_id">
                                <option value="">Select Category First</option>
                            </select>
                            <div class="invalid-feedback" id="error-subcategory_id" style="display: none;">Subcategory is required</div>
                        </div>
                    </div>

                    <div class="form-group row">
                        <label class="col-sm-2 col-form-label">Product Name <span class="text-danger">*</span></label>
                        <div class="col-sm-4">
                            <input type="text" class="form-control" id="product_name" name="name">
                            <div class="invalid-feedback" id="error-name" style="display: none;">Product name is required</div>
                        </div>
                        <label class="col-sm-2 col-form-label">Code</label>
                        <div class="col-sm-4">
                            <input type="text" class="form-control" id="product_code" name="code">
                            <div class="invalid-feedback" id="error-code" style="display: none;"></div>
                        </div>
                    </div>

                    <div class="form-group row">
                        <label class="col-sm-2 col-form-label">Description</label>
                        <div class="col-sm-10">
                            <textarea class="form-control" id="product_description" name="description" rows="3"></textarea>
                            <div class="invalid-feedback" id="error-description" style="display: none;"></div>
                        </div>
                    </div>

                    <div class="form-group row">
                        <label class="col-sm-2 col-form-label">Barcode</label>
                        <div class="col-sm-4">
                            <input type="text" class="form-control" id="product_barcode" name="barcode" maxlength="200">
                            <div class="invalid-feedback" id="error-barcode" style="display: none;"></div>
                        </div>
                        <label class="col-sm-2 col-form-label">Sale Price <span class="text-danger">*</span></label>
                        <div class="col-sm-4">
                            <input type="number" step="0.01" class="form-control" id="product_sale_price" name="sale_price" min="0">
                            <div class="invalid-feedback" id="error-sale_price" style="display: none;"></div>
                        </div>
                    </div>

                    <div class="form-group row">
                        <label class="col-sm-2 col-form-label">Weight</label>
                        <div class="col-sm-4">
                            <input type="number" step="0.01" class="form-control" id="product_weight" name="weight" min="0">
                            <div class="invalid-feedback" id="error-weight" style="display: none;"></div>
                        </div>
                        <label class="col-sm-2 col-form-label">UOM</label>
                        <div class="col-sm-4">
                            <select class="form-control" id="product_uom_id" name="uom_id">
                                <option value="">Select UOM</option>
                                @foreach($uoms as $uom)
                                    <option value="{{ $uom->id }}">{{ $uom->title }}</option>
                                @endforeach
                            </select>
                            <div class="invalid-feedback" id="error-uom_id" style="display: none;"></div>
                        </div>
                    </div>

                    <div class="form-group row">
                        <label class="col-sm-2 col-form-label">Sales Tax Rate</label>
                        <div class="col-sm-4">
                            <input type="number" step="0.01" class="form-control" id="product_sales_tax_rate" name="sales_tax_rate" min="0" max="100">
                            <div class="invalid-feedback" id="error-sales_tax_rate" style="display: none;"></div>
                        </div>
                        <label class="col-sm-2 col-form-label">Advance Sales Tax Rate</label>
                        <div class="col-sm-4">
                            <input type="number" step="0.01" class="form-control" id="product_advance_sales_tax_rate" name="advance_sales_tax_rate" min="0" max="100">
                            <div class="invalid-feedback" id="error-advance_sales_tax_rate" style="display: none;"></div>
                        </div>
                    </div>

                    <div class="form-group row">
                        <label class="col-sm-2 col-form-label">Discount (%)</label>
                        <div class="col-sm-4">
                            <input type="number" step="0.01" class="form-control" id="product_discount" name="discount" min="0" max="100" value="0">
                            <div class="invalid-feedback" id="error-discount" style="display: none;"></div>
                        </div>
                        <label class="col-sm-2 col-form-label">Status <span class="text-danger">*</span></label>
                        <div class="col-sm-4">
                            <select class="form-control" id="product_status" name="status">
                                <option value="Active" selected>Active</option>
                                <option value="Inactive">Inactive</option>
                            </select>
                            <div class="invalid-feedback" id="error-status" style="display: none;"></div>
                        </div>
                    </div>

                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-white" data-dismiss="modal">Close</button>
                    <button type="button" class="btn btn-primary" id="saveProduct"><i class="fa fa-check"></i>&nbsp;Save
                        Changes</button>
                </div>
            </div>
        </div>
    </form>
</div>
{{-- update product modal --}}
<div class="modal fade" id="EditProductInfo" tabindex="-1" role="dialog" aria-hidden="true">
    <form id="edit-product-form">
        @csrf
        <div class="modal-dialog modal-lg">
            <div class="modal-content">
                <div class="modal-header">
                    <button type="button" class="close" data-dismiss="modal">&times;</button>
                    <h4 class="modal-title">Edit Product Information</h4>
                </div>
                <div class="modal-body">
                    <div id="edit-success-message" class="alert alert-success" style="display: none;">
                        <span></span>
                    </div>
                    <div class="form-group row">
                        <label class="col-sm-2 col-form-label">Category <span class="text-danger">*</span></label>
                        <div class="col-sm-4">
                            <select class="form-control" id="edit_product_category_id" name="category_id">
                                <option value="">Select Category</option>
                                @foreach($categories as $category)
                                    <option value="{{ $category->id }}">{{ $category->name }}</option>
                                @endforeach
                            </select>
                            <div class="invalid-feedback" id="edit-error-category_id" style="display: none;">
                                Category is required
                            </div>
                        </div>
                        <label class="col-sm-2 col-form-label">Subcategory <span class="text-danger">*</span></label>
                        <div class="col-sm-4">
                            <select class="form-control" id="edit_product_subcategory_id" name="subcategory_id">
                                <option value="">Select Category First</option>
                            </select>
                            <div class="invalid-feedback" id="edit-error-subcategory_id" style="display: none;">Subcategory is required</div>
                        </div>
                    </div>

                    <div class="form-group row">
                        <label class="col-sm-2 col-form-label">Product Name <span class="text-danger">*</span></label>
                        <div class="col-sm-4">
                            <input type="text" class="form-control" id="edit_product_name" name="name">
                            <div class="invalid-feedback" id="edit-error-name" style="display: none;">
                                Product name is required
                            </div>
                        </div>
                        <label class="col-sm-2 col-form-label">Code</label>
                        <div class="col-sm-4">
                            <input type="text" class="form-control" id="edit_product_code" name="code">
                            <div class="invalid-feedback" id="edit-error-code" style="display: none;"></div>
                        </div>
                    </div>

                    <div class="form-group row">
                        <label class="col-sm-2 col-form-label">Description</label>
                        <div class="col-sm-10">
                            <textarea class="form-control" id="edit_product_description" name="description" rows="3"></textarea>
                            <div class="invalid-feedback" id="edit-error-description" style="display: none;"></div>
                        </div>
                    </div>

                    <div class="form-group row">
                        <label class="col-sm-2 col-form-label">Barcode</label>
                        <div class="col-sm-4">
                            <input type="text" class="form-control" id="edit_product_barcode" name="barcode" maxlength="200">
                            <div class="invalid-feedback" id="edit-error-barcode" style="display: none;"></div>
                        </div>
                        <label class="col-sm-2 col-form-label">Sale Price <span class="text-danger">*</span></label>
                        <div class="col-sm-4">
                            <input type="number" step="0.01" class="form-control" id="edit_product_sale_price" name="sale_price" min="0">
                            <div class="invalid-feedback" id="edit-error-sale_price" style="display: none;"></div>
                        </div>
                    </div>

                    <div class="form-group row">
                        <label class="col-sm-2 col-form-label">Weight</label>
                        <div class="col-sm-4">
                            <input type="number" step="0.01" class="form-control" id="edit_product_weight" name="weight" min="0">
                            <div class="invalid-feedback" id="edit-error-weight" style="display: none;"></div>
                        </div>
                        <label class="col-sm-2 col-form-label">UOM</label>
                        <div class="col-sm-4">
                            <select class="form-control" id="edit_product_uom_id" name="uom_id">
                                <option value="">Select UOM</option>
                                @foreach($uoms as $uom)
                                    <option value="{{ $uom->id }}">{{ $uom->title }}</option>
                                @endforeach
                            </select>
                            <div class="invalid-feedback" id="edit-error-uom_id" style="display: none;"></div>
                        </div>
                    </div>

                    <div class="form-group row">
                        <label class="col-sm-2 col-form-label">Sales Tax Rate</label>
                        <div class="col-sm-4">
                            <input type="number" step="0.01" class="form-control" id="edit_product_sales_tax_rate" name="sales_tax_rate" min="0" max="100">
                            <div class="invalid-feedback" id="edit-error-sales_tax_rate" style="display: none;"></div>
                        </div>
                        <label class="col-sm-2 col-form-label">Advance Sales Tax Rate</label>
                        <div class="col-sm-4">
                            <input type="number" step="0.01" class="form-control" id="edit_product_advance_sales_tax_rate" name="advance_sales_tax_rate" min="0" max="100">
                            <div class="invalid-feedback" id="edit-error-advance_sales_tax_rate" style="display: none;"></div>
                        </div>
                    </div>

                    <div class="form-group row">
                        <label class="col-sm-2 col-form-label">Discount (%)</label>
                        <div class="col-sm-4">
                            <input type="number" step="0.01" class="form-control" id="edit_product_discount" name="discount" min="0" max="100" value="0">
                            <div class="invalid-feedback" id="edit-error-discount" style="display: none;"></div>
                        </div>
                        <label class="col-sm-2 col-form-label">Status <span class="text-danger">*</span></label>
                        <div class="col-sm-4">
                            <select class="form-control" id="edit_product_status" name="status">
                                <option value="Active">Active</option>
                                <option value="Inactive">Inactive</option>
                            </select>
                            <div class="invalid-feedback" id="edit-error-status" style="display: none;"></div>
                        </div>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-white" data-dismiss="modal">Close</button>
                    <button type="button" class="btn btn-primary" id="updateProduct"><i class="fa fa-check"></i> Update Product</button>
                </div>
            </div>
        </div>
    </form>
</div>

{{-- Upload Product Data Modal --}}
<div class="modal fade" id="UploadProductData" tabindex="-1" role="dialog" aria-hidden="true">
    <form id="upload-product-form" enctype="multipart/form-data">
        @csrf
        <div class="modal-dialog modal-lg">
            <div class="modal-content">
                <div class="modal-header">
                    <button type="button" class="close" data-dismiss="modal"><span
                            aria-hidden="true">&times;</span><span class="sr-only">Close</span></button>
                    <h4 class="modal-title">Upload Product Data</h4>
                </div>
                <div class="modal-body">
                    <div id="upload-success-message" class="alert alert-success" style="display: none;">
                        <span></span>
                    </div>
                    <div id="upload-error-message" class="alert alert-danger" style="display: none;">
                        <span></span>
                    </div>
                    <div class="form-group row">
                        <label class="col-sm-3 col-form-label">Select Excel File <span class="text-danger">*</span></label>
                        <div class="col-sm-9">
                            <input type="file" class="form-control" id="product_excel_file" name="excel_file" accept=".xlsx,.xls">
                            <small class="form-text text-muted">Please upload an Excel file (.xlsx or .xls) matching the sample format.</small>
                            <div class="invalid-feedback" id="error-excel_file" style="display: none;"></div>
                        </div>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-white" data-dismiss="modal">Close</button>
                    <button type="button" class="btn btn-primary" id="uploadProductExcel"><i class="fa fa-upload"></i>&nbsp;Upload</button>
                </div>
            </div>
        </div>
    </form>
</div>

<div class="wrapper wrapper-content animated fadeInRight">
    <div class="row mb-3">
        <div class="col-lg-12">
            <button class="btn btn-primary " type="button" id="addNewProduct"><i class="fa fa-plus"></i>&nbsp;New
                Product</button>
            <a href="{{ asset('files/products_data.xlsx') }}" class="btn btn-success" download><i class="fa fa-download"></i>&nbsp;Sample Excel File</a>
            <button class="btn btn-info" type="button" id="uploadProductData"><i class="fa fa-upload"></i>&nbsp;Upload Product Data</button>
        </div>
    </div>

    <div class="row">
        <div class="col-lg-12">
            <table class="table table-striped table-bordered table-hover" style="width: 100%;" id="products-table">
                <thead>
                    <tr>
                        <th>ID</th>
                        <th>Name</th>
                        <th>Sale Price</th>
                        <th>Action</th>
                    </tr>
                </thead>
                <tbody>
                </tbody>
            </table>
        </div>
    </div>
</div>
@push('scripts')
<script>
    $("#addNewProduct").click(function(){
        // Reset form fields
        $('#product_category_id').val('');
        $('#product_subcategory_id').html('<option value="">Select Category First</option>');
        $('#product_name, #product_code, #product_description, #product_barcode').val('');
        $('#product_sale_price, #product_sales_tax_rate, #product_advance_sales_tax_rate, #product_weight, #product_discount').val('');
        $('#product_uom_id').val('');
        $('#product_status').val('Active');
        $('.form-control').removeClass('is-invalid');
        $('.invalid-feedback').hide();
        $('#success-message').hide();
        
        $("#ProductInfo").modal('show');
    });

    // Open upload modal
    $("#uploadProductData").click(function(){
        $('#product_excel_file').val('');
        $('#upload-success-message, #upload-error-message').hide();
        $("#UploadProductData").modal('show');
    });
    
    $(document).ready(function() {
        // Function to load subcategories based on selected category via AJAX
        function loadSubcategories(categoryId, targetSelect) {
            if (categoryId) {
                // Show loading state
                $(targetSelect).html('<option value="">Loading...</option>').prop('disabled', true);
                
                $.ajax({
                    url: `/products/subcategories/${categoryId}`,
                    type: 'GET',
                    success: function(response) {
                        // Clear and populate subcategories
                        $(targetSelect).html('<option value="">Select Subcategory</option>');
                        if (response.length > 0) {
                            $.each(response, function(index, subcategory) {
                                $(targetSelect).append(
                                    $('<option></option>')
                                        .attr('value', subcategory.id)
                                        .text(subcategory.name)
                                );
                            });
                        } else {
                            $(targetSelect).append(
                                $('<option></option>')
                                    .attr('value', '')
                                    .text('No subcategories found')
                            );
                        }
                        $(targetSelect).prop('disabled', false);
                    },
                    error: function() {
                        $(targetSelect).html('<option value="">Error loading subcategories</option>').prop('disabled', false);
                    }
                });
            } else {
                // Reset to default state
                $(targetSelect).html('<option value="">Select Category First</option>');
            }
        }

        // Load subcategories when category changes (Add modal)
        $('#product_category_id').on('change', function() {
            var categoryId = $(this).val();
            loadSubcategories(categoryId, '#product_subcategory_id');
        });

        // Load subcategories when category changes (Edit modal)
        $('#edit_product_category_id').on('change', function() {
            var categoryId = $(this).val();
            loadSubcategories(categoryId, '#edit_product_subcategory_id');
        });

        // Define the save button element
        const saveButton = $('#saveProduct');

        // Function to reset the button state
        function resetButtonState(button, text, disabled = false) {
            button.html(text).prop('disabled', disabled);
        }

        saveButton.on('click', function(e) {
            e.preventDefault();

            let productData = {
                category_id: $('#product_category_id').val(),
                subcategory_id: $('#product_subcategory_id').val(),
                name: $('#product_name').val(),
                code: $('#product_code').val(),
                description: $('#product_description').val(),
                barcode: $('#product_barcode').val(),
                sale_price: $('#product_sale_price').val(),
                discount: $('#product_discount').val(),
                sales_tax_rate: $('#product_sales_tax_rate').val(),
                advance_sales_tax_rate: $('#product_advance_sales_tax_rate').val(),
                weight: $('#product_weight').val(),
                uom_id: $('#product_uom_id').val(),
                status: $('#product_status').val()
            };
            let token = $('input[name="_token"]').val();

            // Change the button text to "Processing..."
            resetButtonState(saveButton,'<i class="fa fa-spinner fa-spin"></i> Processing...', true);

            // Clear previous validation messages
            $('.invalid-feedback').hide();
            $('.form-control').removeClass('is-invalid');

            $.ajax({
                url: "{{ route('add-product') }}",
                type: "POST",
                data: {
                    _token: token,
                    ...productData
                },
                success: function(response) {
                    if (response.success) {
                        // Clear input fields
                        $('#product_category_id').val('');
                        $('#product_subcategory_id').html('<option value="">Select Category First</option>');
                        $('#product_name, #product_code, #product_description, #product_barcode').val('');
                        $('#product_sale_price, #product_sales_tax_rate, #product_advance_sales_tax_rate, #product_weight, #product_discount').val('');
                        $('#product_uom_id').val('');
                        $('#product_status').val('Active');

                        // Show the success message
                        $('#success-message span').text('Product added successfully!');
                        $('#success-message').fadeIn();

                        // Refresh the DataTable
                        $('#products-table').DataTable().ajax.reload(null, false);

                        // Optionally hide the message after a few seconds
                        setTimeout(function() {
                            $('#success-message').fadeOut();
                        }, 3000);
                    }

                    // Reset button to "Save Changes"
                    resetButtonState(saveButton,'<i class="fa fa-check"></i> Save Changes');
                },
                error: function(errorResponse) {
                    // Reset button to "Save Changes"
                    resetButtonState(saveButton,'<i class="fa fa-check"></i> Save Changes');

                    if (errorResponse.status === 422) { // Laravel validation error
                        let errors = errorResponse.responseJSON.errors;
                        Object.keys(errors).forEach(function(key) {
                            let fieldId = 'product_' + key;
                            $('#' + fieldId).addClass('is-invalid');
                            $('#error-' + key).text(errors[key][0]).show();
                        });
                    } else {
                        alert('An error occurred. Please try again.');
                    }
                }
            });
        });

        $(document).on('click', '.edit-button', function() {

            let productId = $(this).data('id');

            // Fetch product details from the database
            $.ajax({
                url: `/products/${productId}`,
                type: 'GET',
                success: function(data) {
                    // Populate the edit form with the fetched data
                    $('#edit_product_category_id').val(data.category_id);
                    
                    // Load subcategories for the selected category first
                    if (data.category_id) {
                        loadSubcategories(data.category_id, '#edit_product_subcategory_id');
                        
                        // Wait for subcategories to load, then set the subcategory value
                        setTimeout(function() {
                            $('#edit_product_subcategory_id').val(data.subcategory_id);
                        }, 500);
                    }
                    
                    $('#edit_product_name').val(data.name);
                    $('#edit_product_code').val(data.code);
                    $('#edit_product_description').val(data.description);
                    $('#edit_product_barcode').val(data.barcode);
                    $('#edit_product_sale_price').val(data.sale_price);
                    $('#edit_product_discount').val(data.discount || 0);
                    $('#edit_product_sales_tax_rate').val(data.sales_tax_rate);
                    $('#edit_product_advance_sales_tax_rate').val(data.advance_sales_tax_rate);
                    $('#edit_product_weight').val(data.weight);
                    $('#edit_product_uom_id').val(data.uom_id || '');
                    $('#edit_product_status').val(data.status);

                    // Store product ID in a data attribute for later
                    $('#edit-product-form').data('product-id', productId);

                    // Open the Edit modal
                    $('#EditProductInfo').modal('show');
                },
                error: function() {
                    Swal.fire('Error', 'Could not fetch product details.', 'error');
                }
            });
        });   
        
        $(document).on('click', '#updateProduct', function () {
            let productId = $('#edit-product-form').data('product-id');
            let productData = {
                category_id: $('#edit_product_category_id').val(),
                subcategory_id: $('#edit_product_subcategory_id').val(),
                name: $('#edit_product_name').val(),
                code: $('#edit_product_code').val(),
                description: $('#edit_product_description').val(),
                barcode: $('#edit_product_barcode').val(),
                sale_price: $('#edit_product_sale_price').val(),
                discount: $('#edit_product_discount').val() || 0,
                sales_tax_rate: $('#edit_product_sales_tax_rate').val(),
                advance_sales_tax_rate: $('#edit_product_advance_sales_tax_rate').val(),
                weight: $('#edit_product_weight').val(),
                uom_id: $('#edit_product_uom_id').val(),
                status: $('#edit_product_status').val()
            };
            let token = $('input[name="_token"]').val();

            // Get the update button reference
            let updateButton = $('#updateProduct');

            // Set the button to "Processing..." state
            resetButtonState(updateButton, '<i class="fa fa-spinner fa-spin"></i> Processing...', true);

            // Clear validation messages
            $('.form-control').removeClass('is-invalid');
            $('.invalid-feedback').hide();

            $.ajax({
                url: `/products/update/${productId}`,
                type: 'PUT',
                data: {
                    _token: token,
                    ...productData
                },
                success: function (response) {
                    if (response.success) {
                        // Close the modal
                        $('#EditProductInfo').modal('hide');

                        // Refresh the DataTable
                        $('#products-table').DataTable().ajax.reload(null, false);

                        // Show success alert
                        Swal.fire('Success', 'Product updated successfully!', 'success');
                    }

                    // Reset the button back to "Update Product"
                    resetButtonState(updateButton, '<i class="fa fa-check"></i> Update Product');
                },
                error: function (errorResponse) {
                    // Reset the button back to "Update Product"
                    resetButtonState(updateButton, '<i class="fa fa-check"></i> Update Product');

                    if (errorResponse.status === 422) {
                        let errors = errorResponse.responseJSON.errors;
                        Object.keys(errors).forEach(function(key) {
                            $('#edit_product_' + key).addClass('is-invalid');
                            $('#edit-error-' + key).text(errors[key][0]).show();
                        });
                    } else {
                        Swal.fire('Error', 'Could not update product.', 'error');
                    }
                },
            });
        });     

        $('#products-table').DataTable({
            processing: true,
            serverSide: true,
            info: false,
            lengthChange: false,
            ajax: '{{ route('products.data') }}',
            columns: [
                { data: 'id', name: 'products.id' },
                { data: 'name', name: 'products.name' },
                { data: 'sale_price', name: 'products.sale_price', render: function(data) {
                    return parseFloat(data).toFixed(2);
                }},
                {
                    data: null,
                    render: function (data, type, row) {
                        return `
                            <button class="btn btn-info btn-circle edit-button" type="button" data-id="${row.id}"><i class="fa fa-edit"></i></button>
                            <button class="btn btn-danger btn-circle delete-button" type="button" data-id="${row.id}"><i class="fa fa-times"></i></button>
                        `;
                    },
                    width: '150px', orderable: false, searchable: false
                }
            ],
            order: [[1, 'asc']]
        });

        // Delete button function
        $(document).on('click', '.delete-button', function() {
            let rowId = $(this).data('id'); // Get the ID of the record

            // Confirm deletion using SweetAlert
            Swal.fire({
                title: 'Are you sure?',
                text: "You want to delete this record?",
                icon: 'warning',
                showCancelButton: true,
                confirmButtonColor: '#d33',
                cancelButtonColor: '#3085d6',
                confirmButtonText: 'Yes, delete it!'
            }).then((result) => {
                if (result.isConfirmed) {
                    $.ajax({
                        url: `{{ url('products/delete') }}/${rowId}`,
                        type: 'DELETE',
                        data: {
                            _token: '{{ csrf_token() }}'
                        },
                        success: function(response) {
                            if (response.success) {
                                // Refresh DataTable after deletion
                                $('#products-table').DataTable().ajax.reload();

                                // Success alert
                                Swal.fire({
                                    title: 'Deleted!',
                                    text: 'Record deleted successfully!',
                                    icon: 'success',
                                    timer: 2000,
                                    showConfirmButton: false
                                });
                            } else {
                                // Error alert for failed deletion
                                Swal.fire({
                                    title: 'Error!',
                                    text: 'Failed to delete the record.',
                                    icon: 'error'
                                });
                            }
                        },
                        error: function() {
                            // General error alert
                            Swal.fire({
                                title: 'Error!',
                                text: 'An error occurred while deleting the record.',
                                icon: 'error'
                            });
                        }
                    });
                }
            });
        });

        // Upload Excel file handler
        $(document).on('click', '#uploadProductExcel', function() {
            let uploadButton = $(this);
            let formData = new FormData();
            let fileInput = $('#product_excel_file')[0];
            
            if (!fileInput.files || fileInput.files.length === 0) {
                $('#upload-error-message span').text('Please select an Excel file.');
                $('#upload-error-message').show();
                return;
            }

            formData.append('excel_file', fileInput.files[0]);
            formData.append('_token', '{{ csrf_token() }}');

            // Reset messages
            $('#upload-success-message, #upload-error-message').hide();
            
            // Change button to processing state
            uploadButton.html('<i class="fa fa-spinner fa-spin"></i> Processing...').prop('disabled', true);

            $.ajax({
                url: '{{ route("products.upload-excel") }}',
                type: 'POST',
                data: formData,
                processData: false,
                contentType: false,
                success: function(response) {
                    if (response.success) {
                        $('#upload-success-message span').text(response.message || 'Products imported successfully!');
                        $('#upload-success-message').show();
                        
                        // Clear file input
                        $('#product_excel_file').val('');
                        
                        // Refresh DataTable
                        $('#products-table').DataTable().ajax.reload(null, false);
                        
                        // Close modal after 2 seconds
                        setTimeout(function() {
                            $('#UploadProductData').modal('hide');
                        }, 2000);
                    } else {
                        $('#upload-error-message span').text(response.message || 'Failed to import products.');
                        $('#upload-error-message').show();
                    }
                    uploadButton.html('<i class="fa fa-upload"></i>&nbsp;Upload').prop('disabled', false);
                },
                error: function(xhr) {
                    let errorMessage = 'An error occurred while uploading the file.';
                    if (xhr.responseJSON && xhr.responseJSON.message) {
                        errorMessage = xhr.responseJSON.message;
                    } else if (xhr.responseJSON && xhr.responseJSON.errors) {
                        let errors = xhr.responseJSON.errors;
                        errorMessage = Object.values(errors).flat().join('<br>');
                    }
                    $('#upload-error-message span').html(errorMessage);
                    $('#upload-error-message').show();
                    uploadButton.html('<i class="fa fa-upload"></i>&nbsp;Upload').prop('disabled', false);
                }
            });
        });
    });   
</script>
@endpush
@endsection