@php
    $byCategory = $items->groupBy(fn ($row) => $row['product']->category->name ?? 'Uncategorized')
        ->map(fn ($group) => $group->sum('stock_value'))
        ->sortDesc();
@endphp

<x-app-layout>
    <x-slot name="header">
        <h2 class="font-semibold text-xl text-gray-800 dark:text-gray-200 leading-tight">
            {{ __('Dead Stock Report') }}
        </h2>
    </x-slot>

    <div class="py-12">
        <div class="max-w-6xl mx-auto sm:px-6 lg:px-8 space-y-6">
            <form method="GET" action="{{ route('reports.dead-stock') }}" class="flex items-end gap-3">
                <div>
                    <x-input-label for="lookback_days" :value="__('No sales within (days)')" />
                    <x-text-input id="lookback_days" name="lookback_days" type="number" min="1" class="mt-1" :value="$lookbackDays" />
                </div>
                <x-secondary-button type="submit">{{ __('View') }}</x-secondary-button>
            </form>

            <div class="grid grid-cols-1 sm:grid-cols-2 gap-4">
                <div class="bg-white dark:bg-gray-800 shadow-sm sm:rounded-lg p-4">
                    <div class="text-xs text-gray-500 dark:text-gray-400 uppercase">{{ __('Items') }}</div>
                    <div class="text-2xl font-semibold text-gray-900 dark:text-gray-100 tabular-nums">{{ $items->count() }}</div>
                </div>
                <div class="bg-white dark:bg-gray-800 shadow-sm sm:rounded-lg p-4">
                    <div class="text-xs text-gray-500 dark:text-gray-400 uppercase">{{ __('Total Value Tied Up') }}</div>
                    <div class="text-2xl font-semibold text-red-600 dark:text-red-400 tabular-nums">{{ number_format($items->sum('stock_value'), 2) }}</div>
                </div>
            </div>

            @if ($byCategory->isNotEmpty())
                <div class="bg-white dark:bg-gray-800 shadow-sm sm:rounded-lg p-4">
                    <h3 class="font-medium text-gray-800 dark:text-gray-200 mb-3">{{ __('Dead Stock Value by Category') }}</h3>
                    <canvas id="categoryChart" height="80"></canvas>
                </div>
            @endif

            <div class="bg-white dark:bg-gray-800 shadow-sm sm:rounded-lg overflow-hidden">
                <table class="min-w-full divide-y divide-gray-200 dark:divide-gray-700">
                    <thead class="bg-gray-50 dark:bg-gray-900/40">
                        <tr>
                            <th class="px-4 py-3 text-left text-xs font-medium text-gray-500 dark:text-gray-400 uppercase tracking-wider">{{ __('Product') }}</th>
                            <th class="px-4 py-3 text-left text-xs font-medium text-gray-500 dark:text-gray-400 uppercase tracking-wider">{{ __('Warehouse') }}</th>
                            <th class="px-4 py-3 text-right text-xs font-medium text-gray-500 dark:text-gray-400 uppercase tracking-wider">{{ __('Qty') }}</th>
                            <th class="px-4 py-3 text-right text-xs font-medium text-gray-500 dark:text-gray-400 uppercase tracking-wider">{{ __('Value') }}</th>
                            <th class="px-4 py-3 text-left text-xs font-medium text-gray-500 dark:text-gray-400 uppercase tracking-wider">{{ __('Last Sale') }}</th>
                        </tr>
                    </thead>
                    <tbody class="bg-white dark:bg-gray-800 divide-y divide-gray-200 dark:divide-gray-700">
                        @forelse ($items as $row)
                            <tr>
                                <td class="px-4 py-3 text-sm text-gray-900 dark:text-gray-100">{{ $row['product']->name }}</td>
                                <td class="px-4 py-3 text-sm text-gray-500 dark:text-gray-400">{{ $row['warehouse']->name }}</td>
                                <td class="px-4 py-3 text-sm text-right tabular-nums text-gray-500 dark:text-gray-400">{{ number_format($row['quantity']) }}</td>
                                <td class="px-4 py-3 text-sm text-right tabular-nums text-gray-900 dark:text-gray-100">{{ number_format($row['stock_value'], 2) }}</td>
                                <td class="px-4 py-3 text-sm text-gray-500 dark:text-gray-400">{{ $row['last_sale_at'] ? \Illuminate\Support\Carbon::parse($row['last_sale_at'])->format('Y-m-d') : __('Never sold') }}</td>
                            </tr>
                        @empty
                            <tr>
                                <td colspan="5" class="px-4 py-6 text-center text-sm text-gray-500 dark:text-gray-400">{{ __('No dead stock found - everything has sold recently.') }}</td>
                            </tr>
                        @endforelse
                    </tbody>
                </table>
            </div>
        </div>
    </div>

    @if ($byCategory->isNotEmpty())
        @push('scripts')
            @vite('resources/js/reports.js')
            <script>
                document.addEventListener('DOMContentLoaded', () => {
                    new Chart(document.getElementById('categoryChart'), {
                        type: 'bar',
                        data: {
                            labels: @json($byCategory->keys()),
                            datasets: [{ label: 'Value', data: @json($byCategory->values()), backgroundColor: '#ef4444' }],
                        },
                        options: { indexAxis: 'y', responsive: true, plugins: { legend: { display: false } } },
                    });
                });
            </script>
        @endpush
    @endif
</x-app-layout>