@extends('layouts.app')

@section('content')
<div class="max-w-7xl mx-auto px-6 py-8">
    <div class="mb-6 flex justify-between items-center">
        <div>
            <h1 class="text-3xl font-extrabold text-orange-700">Pending Cost Requests</h1>
            <p class="mt-2 text-orange-500">List of import requests that have not been assigned a cost.</p>
        </div>
        <a href="{{ route('import_reports.index') }}" class="text-indigo-600 hover:text-indigo-900 font-medium">
            &larr; Back to Reports
        </a>
    </div>

    @if(session('error'))
        <div class="bg-red-100 border border-red-400 text-red-700 px-4 py-3 rounded relative mb-4" role="alert">
            <span class="block sm:inline">{{ session('error') }}</span>
        </div>
    @endif

    {{-- Results Table --}}
    <div class="bg-white rounded shadow p-4 border border-orange-200">
        <h2 class="text-lg font-semibold text-gray-800 mb-4">Requests Missing Cost ({{ $importRequests->count() }})</h2>
        
        @if($importRequests->count() > 0)
            <!-- Top Scrollbar -->
            <div id="top-scrollbar" class="overflow-x-auto mb-2 hidden">
                <div id="top-scrollbar-content" class="h-1"></div>
            </div>

            <div class="overflow-x-auto" id="table-container">
                <table id="pendingCostTable" class="min-w-full border whitespace-nowrap display">
                    <thead>
                        <tr class="bg-orange-50 border-b border-orange-200">
                            <th class="px-6 py-4 text-left font-medium text-orange-800">ID</th>
                            <th class="px-6 py-4 text-left font-medium text-orange-800">Date</th>
                            <th class="px-6 py-4 text-left font-medium text-orange-800">Created By</th>
                            <th class="px-6 py-4 text-left font-medium text-orange-800">Contact Name</th>
                            <th class="px-6 py-4 text-left font-medium text-orange-800">Company</th>
                            <th class="px-6 py-4 text-left font-medium text-orange-800">Courier</th>
                            <th class="px-6 py-4 text-left font-medium text-orange-800">AWB#</th>
                            <th class="px-6 py-4 text-left font-medium text-orange-800">Action</th>
                        </tr>
                        <!-- Filter Row -->
                        <tr class="bg-orange-50 border-b border-orange-200 filter-row">
                            <th class="px-2 py-2"><input type="text" class="w-full border border-gray-300 rounded px-2 py-1 text-sm font-normal" placeholder="Filter ID" /></th>
                            <th class="px-2 py-2"><input type="text" class="w-full border border-gray-300 rounded px-2 py-1 text-sm font-normal" placeholder="Filter Date" /></th>
                            <th class="px-2 py-2"><input type="text" class="w-full border border-gray-300 rounded px-2 py-1 text-sm font-normal" placeholder="Filter Creator" /></th>
                            <th class="px-2 py-2"><input type="text" class="w-full border border-gray-300 rounded px-2 py-1 text-sm font-normal" placeholder="Filter Contact" /></th>
                            <th class="px-2 py-2"><input type="text" class="w-full border border-gray-300 rounded px-2 py-1 text-sm font-normal" placeholder="Filter Company" /></th>
                            <th class="px-2 py-2"><input type="text" class="w-full border border-gray-300 rounded px-2 py-1 text-sm font-normal" placeholder="Filter Courier" /></th>
                            <th class="px-2 py-2"><input type="text" class="w-full border border-gray-300 rounded px-2 py-1 text-sm font-normal" placeholder="Filter AWB#" /></th>
                            <th class="px-2 py-2"></th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach($importRequests as $request)
                        <tr class="border-b hover:bg-orange-50 transition">
                            <td class="px-6 py-4">{{ $request->id }}</td>
                            <td class="px-6 py-4">{{ $request->created_at->format('Y-m-d / H:i') }}</td>
                            <td class="px-6 py-4">{{ $request->creator->name ?? 'N/A' }}</td>
                            <td class="px-6 py-4">{{ $request->shipper->contact_name ?? 'N/A' }}</td>
                            <td class="px-6 py-4">{{ $request->shipper->company_name ?? 'N/A' }}</td>
                            <td class="px-6 py-4">{{ $request->courier_service ?? '-' }}</td>
                            <td class="px-6 py-4">{{ $request->awb_no ?? '-' }}</td>
                            <td class="px-6 py-4">
                                <div x-data="{ 
                                        open: false, 
                                        position: { top: 0, left: 0 },
                                        toggle() {
                                            if (this.open) { this.open = false; return; }
                                            let rect = $refs.btn.getBoundingClientRect();
                                            this.position = {
                                                top: (rect.bottom + window.scrollY) + 'px',
                                                left: (rect.right - 192 + window.scrollX) + 'px' // w-48 is 192px
                                            };
                                            this.open = true;
                                        }
                                    }" 
                                    @scroll.window="open = false" 
                                    class="relative">
                                    <button x-ref="btn" @click="toggle()" @click.away="open = false" class="text-gray-500 hover:text-gray-700 focus:outline-none">
                                        <svg class="w-6 h-6" fill="none" stroke="currentColor" viewBox="0 0 24 24" xmlns="http://www.w3.org/2000/svg">
                                            <path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M12 5v.01M12 12v.01M12 19v.01M12 6a1 1 0 110-2 1 1 0 010 2zm0 7a1 1 0 110-2 1 1 0 010 2zm0 7a1 1 0 110-2 1 1 0 010 2z"></path>
                                        </svg>
                                    </button>
                                    <template x-teleport="body">
                                        <div x-show="open" 
                                             :style="`top: ${position.top}; left: ${position.left};`"
                                             class="fixed w-48 bg-white rounded-md shadow-lg z-50 border border-gray-200" 
                                             style="display: none;" 
                                             @click.outside="open = false">
                                            <a href="{{ route('import_requests.show', $request->id) }}" class="flex items-center px-4 py-2 text-sm text-gray-700 hover:bg-gray-100">
                                                <svg class="w-4 h-4 mr-2" fill="none" stroke="currentColor" viewBox="0 0 24 24" xmlns="http://www.w3.org/2000/svg"><path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M15 12a3 3 0 11-6 0 3 3 0 016 0z"></path><path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M2.458 12C3.732 7.943 7.523 5 12 5c4.478 0 8.268 2.943 9.542 7-1.274 4.057-5.064 7-9.542 7-4.477 0-8.268-2.943-9.542-7z"></path></svg>
                                                View
                                            </a>
                                            @if(!$request->awb_no)
                                            <a href="{{ route('import_requests.edit', $request->id) }}" class="flex items-center px-4 py-2 text-sm text-gray-700 hover:bg-gray-100">
                                                <svg class="w-4 h-4 mr-2" fill="none" stroke="currentColor" viewBox="0 0 24 24" xmlns="http://www.w3.org/2000/svg"><path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M15.232 5.232l3.536 3.536m-2.036-5.036a2.5 2.5 0 113.536 3.536L6.5 21.036H3v-3.572L16.732 3.732z"></path></svg>
                                                Edit
                                            </a>
                                            @endif
                                            @hasanyrole('ImPex|Admin')
                                            <a href="{{ route('import_requests.details.edit', $request->id) }}" class="flex items-center px-4 py-2 text-sm text-gray-700 hover:bg-gray-100">
                                                <svg class="w-4 h-4 mr-2" fill="none" stroke="currentColor" viewBox="0 0 24 24" xmlns="http://www.w3.org/2000/svg"><path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-3 7h3m-3 4h3m-6-4h.01M9 16h.01"></path></svg>
                                                Other Details
                                            </a>
                                            @endhasanyrole
                                        </div>
                                    </template>
                                </div>
                            </td>
                        </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        @else
            <div class="text-center py-8 text-green-600 bg-green-50 rounded-lg border border-dashed border-green-300">
                <p class="font-semibold">Great! All import requests have costs assigned.</p>
            </div>
        @endif
    </div>
</div>
@endsection

@section('scripts')
<!-- DataTables Buttons CSS -->
<link rel="stylesheet" href="https://cdn.datatables.net/buttons/2.4.2/css/buttons.dataTables.min.css">
<!-- DataTables Buttons JS -->
<script src="https://cdn.datatables.net/buttons/2.4.2/js/dataTables.buttons.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.10.1/jszip.min.js"></script>
<script src="https://cdn.datatables.net/buttons/2.4.2/js/buttons.html5.min.js"></script>

<style>
    /* Styling for the DT Buttons */
    .dt-buttons .dt-button {
        background-color: #f97316 !important; /* Tailwind orange-500 */
        color: white !important;
        border: none !important;
        border-radius: 0.375rem !important; /* Tailwind rounded-md */
        padding: 0.5rem 1rem !important;
        font-weight: 500 !important;
        margin-bottom: 1rem !important;
    }
    .dt-buttons .dt-button:hover {
        background-color: #ea580c !important; /* Tailwind orange-600 */
    }
    .dataTables_wrapper .dataTables_filter {
        margin-bottom: 1rem;
    }
    thead input {
        width: 100%;
        padding: 3px;
        box-sizing: border-box;
    }
</style>

<script>
    $(document).ready(function() {
        if ($('#pendingCostTable').length > 0) {
            
            var table = $('#pendingCostTable').DataTable({
                dom: 'Bfrtip',
                buttons: [
                    {
                        extend: 'excelHtml5',
                        text: '<i class="fas fa-file-excel mr-2"></i> Export to Excel',
                        title: 'Pending Cost Requests - Imports',
                        className: 'btn btn-success',
                        exportOptions: {
                            columns: [ 0, 1, 2, 3, 4, 5, 6 ] // Exclude 'Action' column
                        }
                    }
                ],
                orderCellsTop: true,
                fixedHeader: true,
                pageLength: 25,
                // Apply the search
                initComplete: function () {
                    var api = this.api();
 
                    // For each column
                    api
                        .columns()
                        .eq(0)
                        .each(function (colIdx) {
                            if (colIdx === 7) return; // Skip Action column
                            
                            // Get the filter input for this column
                            var cell = $('.filter-row th').eq(
                                $(api.column(colIdx).header()).index()
                            );
                            var input = $('input', cell);
 
                            // On every keypress in this input
                            $(input)
                                .off('keyup change')
                                .on('change', function (e) {
                                    // Get the search value
                                    $(this).attr('title', $(this).val());
                                    var regexr = '({search})'; 
 
                                    var cursorPosition = this.selectionStart;
                                    // Search the column for that value
                                    api
                                        .column(colIdx)
                                        .search(
                                            this.value != ''
                                                ? regexr.replace('{search}', '(((' + this.value + ')))')
                                                : '',
                                            this.value != '',
                                            this.value == ''
                                        )
                                        .draw();
                                })
                                .on('keyup', function (e) {
                                    e.stopPropagation();
                                    
                                    var cursorPosition = this.selectionStart;
                                    var val = $.fn.dataTable.util.escapeRegex($(this).val());
                                    api.column(colIdx).search(val ? val : '', true, false).draw();
                                    
                                    $(this)
                                        .focus()[0]
                                        .setSelectionRange(cursorPosition, cursorPosition);
                                });
                        });
                },
            });

            // Make the top scrollbar visible and sync it
            $('#top-scrollbar').removeClass('hidden');
            
            const topScrollbar = document.getElementById('top-scrollbar');
            const topScrollbarContent = document.getElementById('top-scrollbar-content');
            const tableContainer = document.getElementById('table-container');
            const tableEl = tableContainer.querySelector('table');

            function syncScrollWidth() {
                if (tableEl && topScrollbarContent) {
                    topScrollbarContent.style.width = tableEl.offsetWidth + 'px';
                }
            }

            // Initial sync
            setTimeout(syncScrollWidth, 500); // Give DT time to render

            // Sync on resize
            window.addEventListener('resize', syncScrollWidth);
            // Sync on DT draw
            table.on('draw', syncScrollWidth);

            // Sync scroll positions
            topScrollbar.addEventListener('scroll', () => {
                tableContainer.scrollLeft = topScrollbar.scrollLeft;
            });

            tableContainer.addEventListener('scroll', () => {
                topScrollbar.scrollLeft = tableContainer.scrollLeft;
            });
        }
    });
</script>
@endsection