@extends('layouts.app')
@section('title', 'Order Performance Report')

@section('content')
    <div class="fixed-action-bar d-flex align-items-center justify-content-between">
        <div class="fw-semibold fixed-nav-title">Order Performance</div>
        <div class="d-flex align-items-center">
            <!-- Additional Actions (Left) -->
            
            <a href="{{ route('posm.reports.order-performance.excel', request()->all()) }}">
                <i class="fa-solid fa-file-excel fixed-nav-btn fixed-nav-btn-active p-1 d-inline-flex align-items-center justify-content-center mx-1" style="color: #28a745; cursor: pointer;"
                    data-toggle="tooltip" title="Export Excel"></i>
            </a>
            <i class="fa-solid fa-download fixed-nav-btn fixed-nav-btn-active p-1 d-inline-flex align-items-center justify-content-center mx-1 theme-yellow"
                onclick="exportToCSV()" data-toggle="tooltip" title="Export CSV" style="cursor: pointer;"></i>

            <div class="ms-auto d-flex align-items-center">
                <!-- Mandatory Action Set (Right) -->
                <!-- Add -->
                <i class="fa-regular fa-plus fixed-nav-btn p-1 d-inline-flex align-items-center justify-content-center mx-1" data-toggle="tooltip" title="Add" style="cursor: default;"></i>

                <!-- Save -->
                <i class="fa-regular fa-save fixed-nav-btn p-1 d-inline-flex align-items-center justify-content-center mx-1" data-toggle="tooltip" title="Save" style="cursor: default;"></i>

                <!-- Edit -->
                <i class="fa-regular fa-edit fixed-nav-btn p-1 d-inline-flex align-items-center justify-content-center mx-1" data-toggle="tooltip" title="Edit" style="cursor: default;"></i>

                <!-- Delete -->
                <i class="fa-regular fa-trash-can fixed-nav-btn p-1 d-inline-flex align-items-center justify-content-center mx-1" data-toggle="tooltip" title="Delete" style="cursor: default;"></i>

                <!-- Close -->
                <a href="{{ route('posm.reports.dashboard') }}">
                    <i class="fa-solid fa-xmark fixed-nav-btn fixed-nav-btn-active p-1 d-inline-flex align-items-center justify-content-center mx-1"
                        data-toggle="tooltip" title="Close"></i>
                </a>

                <!-- Column Visibility Dropdown Button -->
                <div class="dropdown d-inline-block mx-1">
                    <i class="fa-solid fa-columns fixed-nav-btn p-1 d-inline-flex align-items-center justify-content-center"
                        id="columnVisibilityDropdownOrderPerf" data-toggle="dropdown" aria-haspopup="true"
                        aria-expanded="false" title="Columns" style="cursor: pointer;"></i>
                    <div class="dropdown-menu dropdown-menu-right columns-menu"
                        aria-labelledby="columnVisibilityDropdownOrderPerf" style="min-width: 200px;">
                        <li><label class="dropdown-item"><input type="checkbox" class="columnCheckbox" data-column="order-no" checked> Order #</label></li>
                        <li><label class="dropdown-item"><input type="checkbox" class="columnCheckbox" data-column="outlet" checked> Outlet</label></li>
                        <li><label class="dropdown-item"><input type="checkbox" class="columnCheckbox" data-column="lsr" checked> LSR Agent</label></li>
                        <li><label class="dropdown-item"><input type="checkbox" class="columnCheckbox" data-column="status" checked> Status</label></li>
                        <li><label class="dropdown-item"><input type="checkbox" class="columnCheckbox" data-column="date" checked> Date</label></li>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- KPI Summary -->
    <div class="row g-4 mt-3 mb-4">
        <div class="col-md-4">
            <div class="card border-0 shadow-sm h-100 rounded-border">
                <div class="card-body p-4 d-flex align-items-center justify-content-between">
                    <div>
                        <h6 class="fw-bold mb-1 text-muted small uppercase">Total Orders</h6>
                        <h2 class="mb-0 fw-bold display-6 text-primary">{{ $total }}</h2>
                    </div>
                    <div class="avatar-lg bg-soft-primary text-primary rounded-circle d-flex align-items-center justify-content-center"
                        style="width: 56px; height: 56px;">
                        <i class="fa-solid fa-cart-flatbed fs-2"></i>
                    </div>
                </div>
            </div>
        </div>
        <div class="col-md-4">
            <div class="card border-0 shadow-sm h-100 rounded-border">
                <div class="card-body p-4 d-flex align-items-center justify-content-between">
                    <div>
                        <h6 class="fw-bold mb-1 text-muted small uppercase">Dispatch Rate</h6>
                        <h2 class="mb-0 fw-bold display-6 text-info">{{ $dispatchRate }}%</h2>
                    </div>
                    <div class="avatar-lg bg-soft-info text-info rounded-circle d-flex align-items-center justify-content-center"
                        style="width: 56px; height: 56px;">
                        <i class="fa-solid fa-truck-ramp-box fs-2"></i>
                    </div>
                </div>
            </div>
        </div>
        <div class="col-md-4">
            <div class="card border-0 shadow-sm h-100 rounded-border">
                <div class="card-body p-4 d-flex align-items-center justify-content-between">
                    <div>
                        <h6 class="fw-bold mb-1 text-muted small uppercase">Avg Delivery Time</h6>
                        <h2 class="mb-0 fw-bold display-6 text-success">{{ number_format($avgDeliveryHours, 1) }}h</h2>
                    </div>
                    <div class="avatar-lg bg-soft-success text-success rounded-circle d-flex align-items-center justify-content-center"
                        style="width: 56px; height: 56px;">
                        <i class="fa-solid fa-stopwatch fs-2"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <div class="card mt-3 rounded-border border-0 shadow-sm">
        <div class="card-body">
            <!-- Filters -->
            <form action="{{ route('posm.reports.order-performance') }}" method="GET">
                <div class="row align-items-end mb-4">
                    <div class="col-md-3 mb-3">
                        <label for="start_date" class="form-label fw-bold small text-muted uppercase">Start Date</label>
                        <input type="date" class="form-control" id="start_date" name="start_date"
                            value="{{ request('start_date') }}">
                    </div>
                    <div class="col-md-3 mb-3">
                        <label for="end_date" class="form-label fw-bold small text-muted uppercase">End Date</label>
                        <input type="date" class="form-control" id="end_date" name="end_date"
                            value="{{ request('end_date') }}">
                    </div>
                    <div class="col-md-3 mb-3">
                        <label for="lsr_id" class="form-label fw-bold small text-muted uppercase">Select LSR</label>
                        <select class="form-control" id="lsr_id" name="lsr_id">
                            <option value="">All LSRs</option>
                            @foreach($lsrs as $lsr)
                                <option value="{{ $lsr->id }}" {{ request('lsr_id') == $lsr->id ? 'selected' : '' }}>
                                    {{ $lsr->name }}
                                </option>
                            @endforeach
                        </select>
                    </div>
                    <div class="col-md-3 mb-3 d-grid">
                        <button type="submit" class="btn btn-primary rounded-pill fw-bold">
                            <i class="fa-solid fa-filter me-2"></i> Update Report
                        </button>
                    </div>
                </div>
            </form>

            <div class="table-responsive">
                <table class="table table-hover align-middle table-striped">
                    <thead class="bg-light text-muted uppercase fs-11 fw-bold">
                        <tr>
                            <th class="ps-4 py-3 order-no-index">Order #</th>
                            <th class="py-3 outlet-index">Outlet</th>
                            <th class="py-3 lsr-index">LSR Agent</th>
                            <th class="py-3 text-center status-index">Status</th>
                            <th class="py-3 date-index">Date</th>
                            <th class="py-3 text-end pe-4">Actions</th>
                        </tr>
                    </thead>
                    <tbody>
                        @forelse($orders as $order)
                            <tr>
                                <td class="ps-4 fw-bold order-no-index">
                                    <a href="{{ route('posm.orders.show', $order->id) }}"
                                        class="text-decoration-none text-dark">{{ $order->order_number }}</a>
                                </td>
                                <td class="outlet-index">
                                    <div class="fw-bold">{{ $order->outlet->name ?? 'N/A' }}</div>
                                    <div class="small text-muted">{{ $order->outlet->address ?? '' }}</div>
                                </td>
                                <td class="lsr-index">
                                    <div class="small fw-bold">{{ $order->lsr->name ?? 'Unassigned' }}</div>
                                </td>
                                <td class="text-center status-index">
                                    @php
                                        $statusConfig = [
                                            'pending' => ['bg-soft-warning', 'text-warning'],
                                            'ready_to_dispatch' => ['bg-soft-primary', 'text-primary'],
                                            'dispatched' => ['bg-soft-primary', 'text-primary'],
                                            'delivered' => ['bg-soft-success', 'text-success'],
                                            'cancelled' => ['bg-soft-danger', 'text-danger'],
                                        ];
                                        $config = $statusConfig[$order->status] ?? ['bg-light', 'text-muted'];
                                    @endphp
                                    <span
                                        class="badge {{ $config[0] }} {{ $config[1] }} rounded-pill px-3">{{ ucfirst($order->status) }}</span>
                                </td>
                                <td class="date-index">
                                    <div class="small text-muted">{{ $order->created_at->format('Y-m-d H:i') }}</div>
                                </td>
                                <td class="text-end pe-4">
                                    <a href="{{ route('posm.orders.show', $order->id) }}"
                                        class="btn btn-sm btn-light border rounded-circle shadow-none" data-toggle="tooltip"
                                        title="View Order">
                                        <i class="fa-solid fa-chevron-right text-muted"></i>
                                    </a>
                                </td>
                            </tr>
                        @empty
                            <tr>
                                <td colspan="6" class="text-center py-5">
                                    <div class="d-flex flex-column align-items-center">
                                        <i class="fa-solid fa-box-open text-muted opacity-25" style="font-size: 48px;"></i>
                                        <p class="text-muted mt-3 mb-0">No orders found.</p>
                                    </div>
                                </td>
                            </tr>
                        @endforelse
                    </tbody>
                </table>
            </div>

            <div class="d-flex justify-content-between mt-4 align-items-center">
                <div class="small text-muted">
                    Showing {{ $orders->firstItem() ?? 0 }} to {{ $orders->lastItem() ?? 0 }} of {{ $orders->total() }}
                    records
                </div>
                <div>
                    {{ $orders->appends(request()->query())->links() }}
                </div>
            </div>
        </div>
    </div>
@endsection

@push('js')
    <script>
        function exportToCSV() {
            const table = document.querySelector('table');
            let csv = [];
            const rows = table.querySelectorAll('tr');

            for (let i = 0; i < rows.length; i++) {
                const row = [],
                    cols = rows[i].querySelectorAll('td, th');

                for (let j = 0; j < cols.length - 1; j++) {
                    let data = cols[j].innerText.replace(/(\r\n|\n|\r)/gm, ' ').replace(/\s+/g, ' ').trim();
                    row.push('"' + data + '"');
                }

                csv.push(row.join(','));
            }

            const csvFile = new Blob([csv.join('\n')], {
                type: 'text/csv'
            });
            const downloadLink = document.createElement('a');
            downloadLink.download = 'order_performance_report_' + new Date().toISOString().split('T')[0] + '.csv';
            downloadLink.href = window.URL.createObjectURL(csvFile);
            downloadLink.style.display = 'none';
            document.body.appendChild(downloadLink);
            downloadLink.click();
            document.body.removeChild(downloadLink);
        }

        $(document).ready(function () {
            // Column Visibility logic
            $('.columnCheckbox').on('change', function () {
                const col = $(this).data('column');
                const isChecked = $(this).prop('checked');

                if (isChecked) {
                    $('.' + col + '-index').show();
                } else {
                    $('.' + col + '-index').hide();
                }
            });

            // Initialize visibility
            $('.columnCheckbox').each(function () {
                const col = $(this).data('column');
                if (!$(this).prop('checked')) {
                    $('.' + col + '-index').hide();
                }
            });
        });
    </script>
@endpush