@extends('admin.layout')
@section('title', 'Database')

@section('content')

@php
    $fmt    = fn($n)  => number_format((float) $n, 0, ',', '.');
    $mb     = fn($n)  => number_format($n / 1024 / 1024, 2) . ' MB';
    $uptime = fn($s)  => sprintf('%dd %dh %dm', $s/86400, ($s%86400)/3600, ($s%3600)/60);

    $sc = fn($label, $value, $color='gray', $sub='') =>
        "<div class='bg-white rounded-lg border border-gray-100 px-3 py-2.5'>
            <p class='text-[11px] text-gray-400 uppercase tracking-wide leading-none mb-1'>{$label}</p>
            <p class='text-xl font-bold text-{$color}-600 leading-none'>{$value}</p>" .
            ($sub ? "<p class='text-[11px] text-gray-400 mt-0.5'>{$sub}</p>" : '') .
        "</div>";
@endphp

@include('admin.partials.server-database')

{{-- ── Flash-berichten ─────────────────────────────────────────────────── --}}
@if (session('success'))
    <div class="mt-4 px-4 py-2.5 rounded-lg bg-emerald-50 border border-emerald-200 text-xs text-emerald-700">
        ✓ {{ session('success') }}
    </div>
@endif
@if (session('error'))
    <div class="mt-4 px-4 py-2.5 rounded-lg bg-red-50 border border-red-200 text-xs text-red-700">
        ✗ {{ session('error') }}
    </div>
@endif

{{-- ── Integriteitscontrole ────────────────────────────────────────────── --}}
@php
    $groups   = collect($integrity)->groupBy('cat');
    $totalBad = collect($integrity)->sum(fn($c) => max(0, $c['count']));
    $isAdmin  = auth()->user()->isAdmin();
@endphp

<div class="mt-4 bg-white rounded-lg border border-gray-100">

    {{-- Header --}}
    <div class="flex items-center justify-between px-4 py-3 border-b border-gray-100">
        <div class="flex items-center gap-2">
            <p class="text-xs font-semibold text-gray-500 uppercase tracking-wide">Integriteitscontrole</p>
            @if ($totalBad > 0)
                <span class="inline-flex items-center justify-center px-1.5 py-0.5 rounded text-[11px] font-bold bg-red-100 text-red-600">
                    {{ $totalBad }} probleem{{ $totalBad !== 1 ? 'en' : '' }}
                </span>
            @else
                <span class="inline-flex items-center gap-1 px-1.5 py-0.5 rounded text-[11px] font-semibold bg-emerald-50 text-emerald-600">
                    ✓ Alles in orde
                </span>
            @endif
        </div>
        <div class="flex items-center gap-3">
            @if ($isAdmin && $totalBad > 0)
                <form method="POST" action="{{ route('admin.database.fix', 'all') }}"
                      onsubmit="return confirm('Alle automatische fixes uitvoeren? Dit past {{ $totalBad }} rij(en) aan.')">
                    @csrf
                    <button type="submit"
                            class="text-[11px] font-semibold px-2.5 py-1 rounded bg-red-600 hover:bg-red-700 text-white transition">
                        Herstel alles
                    </button>
                </form>
            @endif
            <a href="{{ route('admin.database') }}"
               class="text-[11px] text-gray-400 hover:text-gray-600 transition flex items-center gap-1">
                <svg xmlns="http://www.w3.org/2000/svg" class="h-3 w-3" fill="none" viewBox="0 0 24 24" stroke="currentColor" stroke-width="2">
                    <path stroke-linecap="round" stroke-linejoin="round" d="M4 4v5h.582m15.356 2A8.001 8.001 0 004.582 9m0 0H9m11 11v-5h-.581m0 0a8.003 8.003 0 01-15.357-2m15.357 2H15"/>
                </svg>
                Ververs
            </a>
        </div>
    </div>

    {{-- Checks gegroepeerd per categorie --}}
    <div class="divide-y divide-gray-50">
        @foreach ($groups as $catName => $catChecks)
            <div class="px-4 py-3">
                <p class="text-[11px] font-semibold uppercase tracking-widest text-gray-400 mb-2">{{ $catName }}</p>
                <div class="space-y-1">
                    @foreach ($catChecks as $check)
                        @php
                            $bad     = $check['count'] > 0;
                            $failed  = $check['count'] === -1;
                            $hasRows = ! empty($check['rows']);
                        @endphp

                        @if ($hasRows)
                        {{-- Uitklapbaar wanneer er problemen zijn --}}
                        <details class="group">
                            <summary class="flex items-center justify-between gap-3 py-1.5 cursor-pointer list-none select-none">
                                <div class="flex items-center gap-2 min-w-0">
                                    <span class="shrink-0 text-sm">❌</span>
                                    <span class="text-xs text-gray-700 truncate">{{ $check['label'] }}</span>
                                    <span class="shrink-0 text-[11px] text-gray-400 hidden sm:inline">— {{ $check['hint'] }}</span>
                                </div>
                                <div class="flex items-center gap-2 shrink-0">
                                    <span class="text-xs font-semibold text-red-600">{{ $check['count'] }}</span>
                                    <svg xmlns="http://www.w3.org/2000/svg" class="h-3 w-3 text-gray-300 transition-transform group-open:rotate-180" fill="none" viewBox="0 0 24 24" stroke="currentColor" stroke-width="2">
                                        <path stroke-linecap="round" stroke-linejoin="round" d="M19 9l-7 7-7-7"/>
                                    </svg>
                                </div>
                            </summary>

                            <div class="ml-6 mt-1 mb-2">
                                {{-- Voorbeeldrijen --}}
                                <div class="overflow-x-auto rounded border border-red-100 bg-red-50 mb-2">
                                    <table class="w-full text-[11px]">
                                        <thead>
                                            <tr class="text-gray-400 border-b border-red-100">
                                                @foreach (array_keys((array) $check['rows'][0]) as $col)
                                                    <th class="px-3 py-1.5 text-left font-semibold uppercase tracking-wide">{{ $col }}</th>
                                                @endforeach
                                            </tr>
                                        </thead>
                                        <tbody class="divide-y divide-red-100">
                                            @foreach ($check['rows'] as $row)
                                                <tr>
                                                    @foreach ((array) $row as $val)
                                                        <td class="px-3 py-1.5 text-gray-700 font-mono whitespace-nowrap">{{ $val ?? '·' }}</td>
                                                    @endforeach
                                                </tr>
                                            @endforeach
                                        </tbody>
                                    </table>
                                    @if ($check['count'] > 5)
                                        <p class="px-3 py-1.5 text-[11px] text-red-400 border-t border-red-100">
                                            + {{ $check['count'] - 5 }} meer niet getoond
                                        </p>
                                    @endif
                                </div>

                                {{-- Herstel-knop (alleen admins) --}}
                                @if ($isAdmin)
                                    <form method="POST"
                                          action="{{ route('admin.database.fix', $check['slug']) }}"
                                          onsubmit="return confirm('Fix \'{{ addslashes($check['label']) }}\' uitvoeren op {{ $check['count'] }} rij(en)?')">
                                        @csrf
                                        <button type="submit"
                                                class="text-[11px] font-semibold px-2.5 py-1 rounded bg-red-600 hover:bg-red-700 text-white transition">
                                            Herstel ({{ $check['count'] }} rij{{ $check['count'] !== 1 ? 'en' : '' }})
                                        </button>
                                    </form>
                                @endif
                            </div>
                        </details>
                        @else
                        {{-- OK of query mislukt --}}
                        <div class="flex items-center justify-between gap-3 py-1.5">
                            <div class="flex items-center gap-2 min-w-0">
                                <span class="shrink-0 text-sm">
                                    @if ($failed) ⚠️ @else ✅ @endif
                                </span>
                                <span class="text-xs text-gray-700 truncate">{{ $check['label'] }}</span>
                                <span class="shrink-0 text-[11px] text-gray-400 hidden sm:inline">— {{ $check['hint'] }}</span>
                            </div>
                            <span class="text-xs font-semibold shrink-0 {{ $failed ? 'text-orange-400' : 'text-gray-300' }}">
                                {{ $failed ? '?' : '0' }}
                            </span>
                        </div>
                        @endif
                    @endforeach
                </div>
            </div>
        @endforeach
    </div>
</div>

{{-- ── Tabellenoverzicht ───────────────────────────────────────────────── --}}
<div class="mt-4 bg-white rounded-lg border border-gray-100 overflow-hidden">
    <div class="px-4 py-3 border-b border-gray-100">
        <p class="text-xs font-semibold text-gray-500">
            {{ $dbTotals['tables'] }} tabellen ·
            Data: {{ $dbTotals['data_mb'] }} MB ·
            Index: {{ $dbTotals['index_mb'] }} MB ·
            ~{{ $fmt($dbTotals['total_rows']) }} rijen
        </p>
    </div>
    <div class="overflow-x-auto">
        <table class="w-full text-xs">
            <thead class="bg-gray-50 text-gray-400 uppercase tracking-wide">
                <tr>
                    <th class="px-4 py-2 text-left">Tabel</th>
                    <th class="px-4 py-2 text-right">Rijen</th>
                    <th class="px-4 py-2 text-right">Data</th>
                    <th class="px-4 py-2 text-right">Index</th>
                    <th class="px-4 py-2 text-right">Totaal</th>
                    <th class="px-4 py-2 text-left" style="width:25%">Grootte</th>
                </tr>
            </thead>
            <tbody class="divide-y divide-gray-50">
                @php $maxSize = max(collect($tables)->max('total_size'), 1); @endphp
                @foreach ($tables as $t)
                    <tr class="hover:bg-gray-50 transition">
                        <td class="px-4 py-2 font-mono text-gray-700">{{ $t->table_name }}</td>
                        <td class="px-4 py-2 text-right text-gray-500">{{ $fmt($t->table_rows) }}</td>
                        <td class="px-4 py-2 text-right text-gray-500">{{ $mb($t->data_length) }}</td>
                        <td class="px-4 py-2 text-right text-gray-500">{{ $mb($t->index_length) }}</td>
                        <td class="px-4 py-2 text-right font-medium text-gray-700">{{ $mb($t->total_size) }}</td>
                        <td class="px-4 py-2">
                            <div style="height:6px; border-radius:3px; background:#e5e7eb">
                                <div style="height:6px; border-radius:3px; width:{{ round($t->total_size / $maxSize * 100) }}%;
                                            background:rgb(var(--a6,99 102 241))"></div>
                            </div>
                        </td>
                    </tr>
                @endforeach
            </tbody>
        </table>
    </div>
</div>

@endsection