@extends('layouts.app')
@section('title', app()->getLocale() === 'bn' ? 'পরিবার রিপোর্ট' : 'Family Report')
@section('page-title', app()->getLocale() === 'bn' ? 'পরিবার রিপোর্ট' : 'Family Report')
@section('content')
<div class="mb-4">
    <a href="{{ route('admin.reports.index') }}" class="text-green-600 hover:text-green-800 text-sm">&larr; {{ __('Back') }}</a>
</div>

{{-- Filters --}}
<div class="bg-white dark:bg-gray-800 rounded-xl shadow p-4 mb-6">
    <form method="GET" class="grid grid-cols-2 md:grid-cols-5 gap-3">
        <select name="division_id" class="rounded-lg border-gray-300 dark:border-gray-600 dark:bg-gray-700 text-sm">
            <option value="">{{ __('Division') }}</option>
            @foreach(\App\Models\Division::all() as $div)
                <option value="{{ $div->id }}" {{ request('division_id') == $div->id ? 'selected' : '' }}>{{ $div->name }}</option>
            @endforeach
        </select>
        <select name="status" class="rounded-lg border-gray-300 dark:border-gray-600 dark:bg-gray-700 text-sm">
            <option value="">{{ __('Status') }}</option>
            @foreach(['surveyed','pending_review','approved','active','suspended'] as $s)
                <option value="{{ $s }}" {{ request('status') == $s ? 'selected' : '' }}>{{ ucfirst(str_replace('_',' ',$s)) }}</option>
            @endforeach
        </select>
        <select name="quantile" class="rounded-lg border-gray-300 dark:border-gray-600 dark:bg-gray-700 text-sm">
            <option value="">{{ __('Quantile') }}</option>
            @foreach(['ultra_poor','poor','at_risk_lower','lower_middle','middle','upper'] as $q)
                <option value="{{ $q }}" {{ request('quantile') == $q ? 'selected' : '' }}>{{ ucfirst(str_replace('_',' ',$q)) }}</option>
            @endforeach
        </select>
        <button type="submit" class="bg-green-600 hover:bg-green-700 text-white rounded-lg text-sm font-semibold transition">{{ __('Filter') }}</button>
        <a href="{{ route('admin.reports.families') }}" class="bg-gray-200 dark:bg-gray-700 hover:bg-gray-300 text-center rounded-lg text-sm py-2 transition">{{ app()->getLocale() === 'bn' ? 'রিসেট' : 'Reset' }}</a>
    </form>
</div>

{{-- Results --}}
<div class="bg-white dark:bg-gray-800 rounded-xl shadow overflow-hidden">
    <div class="overflow-x-auto">
        <table class="w-full text-sm">
            <thead class="bg-gray-50 dark:bg-gray-700">
                <tr>
                    <th class="text-left py-3 px-4">{{ __('Family Code') }}</th>
                    <th class="text-left py-3 px-4">{{ __('Head of Family') }}</th>
                    <th class="text-left py-3 px-4">{{ __('Division') }}</th>
                    <th class="text-left py-3 px-4">{{ __('District') }}</th>
                    <th class="text-left py-3 px-4">{{ __('Upazila') }}</th>
                    <th class="text-left py-3 px-4">{{ __('Union') }}</th>
                    <th class="text-center py-3 px-4">{{ __('PMT Score') }}</th>
                    <th class="text-center py-3 px-4">{{ __('Status') }}</th>
                </tr>
            </thead>
            <tbody class="divide-y divide-gray-200 dark:divide-gray-700">
                @forelse($families as $f)
                    <tr>
                        <td class="py-3 px-4 font-mono text-xs">{{ $f->family_id_code }}</td>
                        <td class="py-3 px-4">{{ $f->head_name_bn }}</td>
                        <td class="py-3 px-4 text-xs">{{ $f->union?->upazila?->district?->division?->name }}</td>
                        <td class="py-3 px-4 text-xs">{{ $f->union?->upazila?->district?->name }}</td>
                        <td class="py-3 px-4 text-xs">{{ $f->union?->upazila?->name }}</td>
                        <td class="py-3 px-4 text-xs">{{ $f->union?->name }}</td>
                        <td class="py-3 px-4 text-center font-semibold">{{ $f->pmt_score }}</td>
                        <td class="py-3 px-4 text-center">
                            <span class="px-2 py-0.5 rounded text-xs font-semibold bg-gray-100 text-gray-800 dark:bg-gray-600 dark:text-gray-200">{{ ucfirst(str_replace('_',' ',$f->status)) }}</span>
                        </td>
                    </tr>
                @empty
                    <tr><td colspan="8" class="py-8 text-center text-gray-500">{{ __('No results found') }}</td></tr>
                @endforelse
            </tbody>
        </table>
    </div>
    <div class="px-4 py-3 border-t dark:border-gray-700 text-sm text-gray-500">
        {{ app()->getLocale() === 'bn' ? 'মোট' : 'Total' }}: {{ count($families) }} {{ app()->getLocale() === 'bn' ? 'টি পরিবার' : 'families' }}
    </div>
</div>
@endsection