@extends('layouts.app')

@section('content')
<div class="container">
    <div class="d-flex align-items-center justify-content-between flex-wrap gap-2 mb-3">
        <h1 class="h4 mb-0">Admin Dashboard</h1>
        <div class="d-flex gap-2">
            <a class="btn btn-sm btn-outline-primary" href="{{ route('admin.users.index') }}">Users</a>
            <a class="btn btn-sm btn-outline-secondary" href="{{ route('admin.imports') }}">Imports</a>
        </div>
    </div>

    @if(session('success'))
        <div class="alert alert-success">{{ session('success') }}</div>
    @endif
    @if($errors->any())
        <div class="alert alert-danger">{{ collect($errors->all())->first() }}</div>
    @endif

    <div class="row g-3">
        <div class="col-md-4">
            <div class="card">
                <div class="card-body">
                    <div class="text-muted small">Patients (pt_configs)</div>
                    <div class="fs-4 fw-semibold">{{ number_format($stats['patients'] ?? 0) }}</div>
                    <div class="text-muted small">Updated: {{ $stats['pt_configs_updated_at'] ?? '—' }}</div>
                </div>
            </div>
        </div>
        <div class="col-md-4">
            <div class="card">
                <div class="card-body">
                    <div class="text-muted small">Follow-ups (art_followups)</div>
                    <div class="fs-4 fw-semibold">{{ number_format($stats['followups'] ?? 0) }}</div>
                    <div class="text-muted small">Latest visit: {{ $stats['last_followup_date'] ?? '—' }}</div>
                </div>
            </div>
        </div>
        <div class="col-md-4">
            <div class="card">
                <div class="card-body">
                    <div class="text-muted small">Follow-ups Updated</div>
                    <div class="fs-6 fw-semibold">{{ $stats['followups_updated_at'] ?? '—' }}</div>
                </div>
            </div>
        </div>
    </div>

    <div class="row g-3 mt-1">
        <div class="col-lg-6">
            <div class="card">
                <div class="card-header">Connection Status</div>
                <div class="card-body">
                    @php($c = $stats['connections'] ?? [])
                    <ul class="list-group">
                        @foreach($c as $name => $info)
                            <li class="list-group-item d-flex align-items-center justify-content-between">
                                <span class="text-muted">{{ $name }}</span>
                                @if(($info['ok'] ?? false) === true)
                                    <span class="badge bg-success">OK</span>
                                @else
                                    <span class="badge bg-danger">FAIL</span>
                                @endif
                            </li>
                        @endforeach
                    </ul>
                    @if(isset($c['MAM_NAP_tables']) && ($c['MAM_NAP_tables']['ok'] ?? false) !== true)
                        <div class="alert alert-warning mt-3 mb-0">
                            Missing tables on MAM_NAP: {{ implode(', ', $c['MAM_NAP_tables']['missing'] ?? []) }}
                        </div>
                    @endif
                </div>
            </div>
        </div>
        <div class="col-lg-6">
            <div class="card">
                <div class="card-header">Top Clinics (pt_configs)</div>
                <div class="card-body p-0">
                    <table class="table table-sm mb-0">
                        <thead>
                        <tr>
                            <th class="ps-3">Clinic</th>
                            <th class="text-end pe-3">Patients</th>
                        </tr>
                        </thead>
                        <tbody>
                        @forelse($perClinic as $row)
                            <tr>
                                <td class="ps-3">{{ $row->clinic_id ?? '—' }}</td>
                                <td class="text-end pe-3">{{ number_format((int) ($row->total ?? 0)) }}</td>
                            </tr>
                        @empty
                            <tr>
                                <td class="ps-3" colspan="2">No data (or DB not reachable).</td>
                            </tr>
                        @endforelse
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection