@include('new_layouts.header')
<link href="https://cdn.datatables.net/1.13.6/css/jquery.dataTables.min.css" rel="stylesheet" />
<style>
    #loader {
        display: none;
    }

    .table thead th,
    table.dataTable thead th,
    .dataTable thead tr,
    .dataTable thead tr th {
        background-color: #1a73e8 !important;
        /* Blue color shown in your example */
        color: #fff !important;
        font-weight: normal;
        text-align: start;
        border-bottom: 0 !important;
    }

    /* Ensure header color persists */
    #tenderDataTable thead th {
        background-color: #1a73e8 !important;
        color: #fff !important;
    }

    /* Override any DataTables default styling */
    .table-responsive table.dataTable thead th,
    .table-responsive table.dataTable thead td {
        background-color: #1a73e8 !important;
    }

    /* For the entire header row */
    .table-responsive table.dataTable thead tr {
        background-color: #1a73e8 !important;
    }

    /* Fix for header in card */
    .card .card-header {
        background-color: white;
        /* Keep card header white */
    }

    /* DataTables specific overrides */
    .dataTables_wrapper .dataTables_paginate .paginate_button.current,
    .dataTables_wrapper .dataTables_paginate .paginate_button.current:hover {
        background-color: #1a73e8 !important;
        color: #fff !important;
    }
</style>
<div class="page-wrapper">
    <div class="card m-3">
        <div class="card-body">
            <div class="row">
                <div class="col-12">
                    <div class="card">
                        <div class="card-body table-border-style">
                            <div class="card-body">
                                <form id="importForm" enctype="multipart/form-data">
                                    @csrf
                                    <div class="row">
                                        <span>Upload a Excel of your Workdone File information. The following fields are
                                            required in the Xlsx: <strong>SUBGROUP, DIVISION, SUBDIVISION, COMPANY NAME,
                                                CONTACT PERSON, CONTACT NO, SC EMAIL TO, SC EMAIL CC.</strong></span>
                                        <br>
                                        <div class="col-md-6 mb-3">
                                            <div class="form-group">
                                                <label for="actionSelect">{{ __('Select Action') }}</label>
                                                <select id="actionSelect" class="form-control">
                                                    <option value="select">Select Type</option>
                                                    <option value="download">Download Excel</option>
                                                    <option value="import">Import Excel</option>
                                                </select>
                                            </div>

                                            <div id="importSection" style="display: none;">
                                                <div class="form-group">
                                                    <label for="file">{{ __('Choose File') }}</label>
                                                    <div class="input-group">
                                                        <input type="file" class="form-control" accept=".xlsx, .xls"
                                                            id="file" name="file">
                                                    </div>
                                                </div>
                                            </div>
                                        </div>

                                        <div class="col-md-6 mb-3 d-flex align-items-end">
                                            <div class="form-group ml-auto">
                                                <img src="{{ asset('admin/loader/ajax_loader.gif') }}" id="loader"
                                                    class="ml-3">
                                                <button class="btn btn-primary ml-3" type="submit" id="importsave"
                                                    style="display: none;">Save</button>
                                            </div>
                                        </div>

                                        <div class="input-group-append" id="downloadSection" style="display: none;">
                                            <a id="import_excel" href="{{ route('tender_excel_data_export') }}">
                                                <i class="fa fa-download"></i> Tender Import File
                                            </a>
                                        </div>
                                    </div>
                                </form>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

            <!-- DataTable Section -->
            <div class="row mt-4">
                <div class="col-12">
                    <div class="card">
                        <div class="card-header">
                            <h4>Tender Data</h4>
                        </div>
                        <div class="card-body">
                            <div class="table-responsive">
                                <table id="tenderDataTable" class="table table-vcenter card-table no-footer dataTable">
                                    <thead>
                                        <tr>
                                            <th>ID</th>
                                            <th>SUBGROUP</th>
                                            <th>DIVISION</th>
                                            <th>SUBDIVISION</th>
                                            <th>COMPANY NAME</th>
                                            <th>CONTACT PERSON</th>
                                            <th>CONTACT NO</th>
                                            <th>SC EMAIL TO</th>
                                            <th>SC EMAIL CC</th>
                                            <th>Actions</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

@include('new_layouts.footer')

<script>
    $(document).ready(function() {
        // Function to toggle visibility of import/download sections
        function toggleInputs() {
            const action = $('#actionSelect').val();

            if (action === 'download') {
                $('#importSection').hide();
                $('#downloadSection').show();
                $('#importsave').hide();
            } else if (action === 'import') {
                $('#importSection').show();
                $('#downloadSection').hide();
                $('#importsave').show();
            } else { // action === 'select'
                $('#importSection').hide();
                $('#downloadSection').hide();
                $('#importsave').hide();
            }
        }

        // Initialize the visibility on page load
        toggleInputs();

        // Add event listener for select change
        $('#actionSelect').on('change', function() {
            toggleInputs();
        });

        // Initialize DataTable with server-side processing
        function tender_data_table() {
            $('#tenderDataTable').dataTable().fnDestroy();
            $('#tenderDataTable').DataTable({
                processing: true,
                serverSide: true,
                pagingType: 'full_numbers',
                aaSorting: [],
                destroy: true,
                "language": {
                    "sLengthMenu": "{{ __('Records per page: _MENU_') }}",
                    "sZeroRecords": "{{ __('No data available in table') }}",
                    "sEmptyTable": "{{ __('No data available in table') }}",
                    "sInfo": "{{ __('Showing records _START_ to _END_ of a total of _TOTAL_ records') }}",
                    "sInfoFiltered": "{{ __('filtering of a total of _MAX_ records') }}",
                    "sSearch": "{{ __('Search by Subgroup, Company Name...') }}:",
                    "oPaginate": {
                        "sFirst": "{{ __('First') }}",
                        "sLast": "{{ __('Last') }}",
                        "sNext": "{{ __('Next') }}",
                        "sPrevious": "{{ __('Previous') }}"
                    },
                    "processing": '<i class="fa fa-spinner fa-spin fa-3x fa-fw"></i><span class="sr-only">Loading...</span>'
                },
                "ajax": {
                    "url": "{{ route('tender.data') }}",
                    "dataType": "json",
                    "type": "POST",
                    "data": function(d) {
                        d._token = "{{ csrf_token() }}";
                        // Add any filter parameters here if needed
                    }
                },
                deferRender: true,
                columnDefs: [{
                        orderable: false,
                        targets: 9 // action column
                    },
                    {
                        orderable: true,
                        targets: [0, 1, 2, 3, 4, 5, 6, 7, 8]
                    }
                ],
                pageLength: 10,
                lengthMenu: [
                    [10, 25, 50, 100, 500],
                    [10, 25, 50, 100, 500]
                ],
                searching: true,
                aoColumns: [{
                        data: "id"
                    },
                    {
                        data: "subgroup"
                    },
                    {
                        data: "division"
                    },
                    {
                        data: "subdivision"
                    },
                    {
                        data: "company_name"
                    },
                    {
                        data: "contact_person"
                    },
                    {
                        data: "contact_no"
                    },
                    {
                        data: "sc_email_to"
                    },
                    {
                        data: "sc_email_cc"
                    },
                    {
                        data: "action",
                        render: function(data, type, row) {
                            // Add delete button to action column
                            return data +
                                ' <button class="btn btn-sm btn-danger delete-btn" data-id="' +
                                row.id + '"><i class="fa fa-trash"></i> Delete</button>';
                        }
                    }
                ],
                dom: 'Bfrtip',
                buttons: [
                    'copy', 'csv', 'excel', 'pdf', 'print'
                ],
                drawCallback: function(settings) {
                    // Initialize any tooltips or popovers here
                    $('[data-toggle="tooltip"]').tooltip();

                    // Attach delete event handler
                    $('.delete-btn').on('click', function() {
                        var id = $(this).data('id');
                        deleteTenderData(id);
                    });
                }
            });
        }

        // Function to handle deletion
        function deleteTenderData(id) {
            swal.fire({
                title: "Delete?",
                icon: 'question',
                text: "Please ensure and then confirm!",
                type: "warning",
                showCancelButton: true,
                confirmButtonText: "Yes, delete it!",
                cancelButtonText: "No, cancel!",
                reverseButtons: true
            }).then(function(e) {
                if (e.value === true) {
                    var CSRF_TOKEN = $('meta[name="csrf-token"]').attr('content');
                    $.ajax({
                        type: 'POST',
                        url: "{{ route('delete_import') }}",
                        data: {
                            id: id,
                            _token: CSRF_TOKEN
                        },
                        dataType: 'JSON',
                        success: function(results) {
                            if (results.success === true) {
                                swal.fire("Done!", results.message, "success");
                                // Refresh the DataTable
                                tender_data_table();
                            } 
                        }
                    });
                }
            });
        }

        // Ensure we bind click events for dynamic content
        $(document).on('click', '.delete-btn', function() {
            var id = $(this).data('id');
            deleteTenderData(id);
        });

        // Call the function when document is ready
        $(document).ready(function() {
            tender_data_table();

            // Handle any filter changes if needed
            $('#actionSelect').on('change', function() {
                tender_data_table();
            });
        });
        // Handle form submission
        $('#importForm').on('submit', function(e) {
            e.preventDefault();

            var formData = new FormData(this);

            if ($('#actionSelect').val() === 'import') {
                if (!$('#file').val()) {
                    alert('Please select a file to import');
                    return false;
                }

                // Show loader
                $('#loader').show();

                $.ajax({
                    url: "{{ route('tender_excel_upload') }}",
                    type: "POST",
                    data: formData,
                    contentType: false,
                    processData: false,
                    success: function(response) {
                        $('#loader').hide();

                        if (response.success) {
                            toastr.success(response.success);

                            // Refresh the DataTable
                            tender_data_table();
                            // Reset form
                            $('#importForm')[0].reset();
                        } else if (response.error) {

                            toastr.error(response.error);
                        }
                    },
                    error: function(xhr) {
                        $('#loader').hide();

                        if (xhr.responseJSON && xhr.responseJSON.errors) {
                            let errorMessages = '';
                            $.each(xhr.responseJSON.errors, function(key, value) {
                                errorMessages += value[0] + '\n';
                            });
                            toastr.error(errorMessages);

                        } else {
                            toastr.error(
                                "An error occurred during import. Please try again");
                        }
                    }
                });
            }
        });
    });
</script>