{{-- resources/views/filament/pages/import-stocks.blade.php --}}
<x-filament-panels::page>
    @if (session('status'))
        <div class="mb-4 rounded border border-green-300 bg-green-50 p-3 text-green-800">
            {{ session('status') }}
        </div>
    @endif

    @if ($errors->any())
        <div class="mb-4 rounded border border-red-300 bg-red-50 p-3 text-red-800">
            <div class="font-semibold mb-1">Erreur :</div>
            <ul class="list-disc pl-6">
                @foreach ($errors->all() as $err)
                    <li>{{ $err }}</li>
                @endforeach
            </ul>
        </div>
    @endif

    <form method="POST"
          action="{{ url('/admin/import/preview') }}"
          enctype="multipart/form-data"
          class="space-y-4">
        @csrf

        <div>
            <label for="file" class="block text-sm font-medium mb-1">
                Fichier Excel (.xlsx / .xls)
            </label>
            <input id="file" type="file" name="file" accept=".xlsx,.xls" required
                   class="block w-full rounded border p-2" />
        </div>

        <x-filament::button type="submit">Afficher l’aperçu</x-filament::button>
    </form>

   @php
    $uid = optional(auth()->user())->id ?? 'guest';
    $preview    = cache()->get('stock_preview:' . $uid);
    $headers    = $preview['headers_raw']  ?? [];
    $headersSql = $preview['headers_sql']  ?? [];
    $rows       = $preview['sample']       ?? [];
    $missing    = $preview['missing_in_db']?? [];
    $extra      = $preview['extra_in_db']  ?? [];
@endphp


    @if (!empty($preview))
        <hr class="my-6" />

        @if (count($missing) || count($extra))
            <div class="mb-4 rounded border border-amber-300 bg-amber-50 p-3 text-amber-900">
                <div class="font-semibold mb-1">Attention colonnes :</div>

                @if (count($missing))
                    <div class="mb-1"><strong>À ajouter en base</strong> :</div>
                    <code class="block mb-2">{{ implode(', ', $missing) }}</code>
                @endif

                @if (count($extra))
                    <div class="mb-1"><strong>En base mais absentes du fichier</strong> :</div>
                    <code class="block">{{ implode(', ', $extra) }}</code>
                @endif
            </div>
        @endif

        <h2 class="text-xl font-semibold mb-2">
            Aperçu ({{ count($rows) }} lignes)
        </h2>

        <div class="overflow-auto border rounded">
            <table class="min-w-full text-sm">
                <thead class="bg-gray-50">
                    <tr>
                        @foreach ($headers as $h)
                            <th class="px-2 py-1 text-left font-medium">
                                {{ $h }}
                                <div class="text-xs text-gray-500">
                                    {{ $headersSql[$loop->index] ?? '' }}
                                </div>
                            </th>
                        @endforeach
                    </tr>
                </thead>
                <tbody>
                    @foreach ($rows as $row)
                        <tr class="border-t">
                            @foreach ($headers as $h)
                                <td class="px-2 py-1">{{ $row[$h] ?? '' }}</td>
                            @endforeach
                        </tr>
                    @endforeach
                </tbody>
            </table>
        </div>
    @endif
	@if (session()->has('stock_preview'))
  <div class="mt-2 text-xs text-green-700">[debug] Aperçu prêt.</div>
@endif
</x-filament-panels::page>