@extends('layouts.admin-master')
@section('title', 'Registration Report')
@section('style')
    @include('admin.style')
    <style>
        .filter-bar { display:flex; flex-wrap:wrap; align-items:flex-end; gap:14px; }
        .filter-bar .filter-field { display:flex; flex-direction:column; gap:6px; }
        .filter-bar .filter-label { font-size:11px; font-weight:600; text-transform:uppercase; letter-spacing:.4px; color:#9ca3af; }
        .filter-bar .form-control, .filter-bar .form-select { min-width:150px; font-size:13px; border-radius:8px; }
        .filter-bar .filter-actions { display:flex; align-items:flex-end; gap:8px; flex-wrap:wrap; margin-left:auto; }
    </style>
@endsection
@section('content')
<div id="preloader"><div class="spinner"></div></div>
<aside class="sidebar-nav-wrapper">@include('admin.sidenav')</aside>
<div class="overlay"></div>

<main class="main-wrapper">
    @include('admin.header')

    <section class="section">
        <div class="container-fluid">
            <div class="title-wrapper pt-30">
                <div class="row align-items-center">
                    <div class="col-md-6">
                        <div class="title"><h2>Registration Report</h2></div>
                      
                    </div>
                    <div class="col-md-6">
                    </div>
                </div>
            </div>

            <div class="row">
                <div class="col-lg-12">
                    <div class="card-style mb-30">
                        <form method="GET" class="filter-bar">
                            <div class="filter-field">
                                <label class="filter-label">Type</label>
                                <select name="type" class="form-select">
                                    <option value="farmer" {{ $type === 'farmer' ? 'selected' : '' }}>Farmer</option>
                                    <option value="vendor" {{ $type === 'vendor' ? 'selected' : '' }}>Vendor</option>
                                </select>
                            </div>
                            <div class="filter-field">
                                <label class="filter-label">Month</label>
                                <select name="month" class="form-select">
                                    <option value="">All Months</option>
                                    @for($m = 1; $m <= 12; $m++)
                                    <option value="{{ $m }}" {{ request('month') == $m ? 'selected' : '' }}>{{ date('F', mktime(0,0,0,$m,1)) }}</option>
                                    @endfor
                                </select>
                            </div>
                            <div class="filter-field">
                                <label class="filter-label">Year</label>
                                <input type="number" name="year" class="form-control" placeholder="e.g. 2026" value="{{ request('year') }}">
                            </div>
                            <div class="filter-field">
                                <label class="filter-label">District</label>
                                <input type="text" name="district" class="form-control" placeholder="District" value="{{ request('district') }}">
                            </div>
                            <div class="filter-actions">
                                <button type="submit" class="btn btn-primary"><i class="lni lni-funnel"></i> Filter</button>
                                <a href="{{ route('reports.registrations') }}" class="btn btn-outline-secondary">Reset</a>
                                <a href="{{ request()->fullUrlWithQuery(['export' => 'csv']) }}" class="action-btn" style="background:#d1e7dd;color:#0a5132;width:auto;padding:0 14px;border-radius:8px;font-size:13px;gap:6px;height:38px;" title="Export CSV">
                                    <i class="lni lni-download"></i> Export CSV
                                </a>
                            </div>
                        </form>
                    </div>
                </div>
            </div>

            <div class="row">
                <div class="col-lg-12">
                    <div class="card-style mb-30">
                        <div class="d-flex flex-wrap align-items-center justify-content-between gap-3 mb-20">
                            <h6 class="text-medium mb-0">{{ ucfirst($type) }} Registrations</h6>
                            <span class="text-sm text-gray">{{ $records->total() }} total</span>
                        </div>

                        <div class="table-responsive">
                            <table class="table top-selling-table">
                                <thead>
                                    <tr>
                                        <th><h6 class="text-sm text-medium">#</h6></th>
                                        @if($type === 'vendor')
                                        <th><h6 class="text-sm text-medium">Vendor Name</h6></th>
                                        <th><h6 class="text-sm text-medium">Business</h6></th>
                                        @else
                                        <th><h6 class="text-sm text-medium">First Name</h6></th>
                                        <th><h6 class="text-sm text-medium">Last Name</h6></th>
                                        @endif
                                        <th><h6 class="text-sm text-medium">Phone</h6></th>
                                        <th><h6 class="text-sm text-medium">Email</h6></th>
                                        <th><h6 class="text-sm text-medium">District</h6></th>
                                        <th><h6 class="text-sm text-medium">State</h6></th>
                                        <th><h6 class="text-sm text-medium">Status</h6></th>
                                        <th><h6 class="text-sm text-medium">Registered</h6></th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @forelse($records as $index => $record)
                                    <tr>
                                        <td class="text-sm">{{ ($records->firstItem() ?? 1) + $index }}</td>
                                        @if($type === 'vendor')
                                        <td class="text-sm fw-500">{{ $record->vendor_name }}</td>
                                        <td class="text-sm">{{ $record->business_name ?? 'N/A' }}</td>
                                        @else
                                        <td class="text-sm fw-500">{{ $record->first_name }}</td>
                                        <td class="text-sm">{{ $record->last_name }}</td>
                                        @endif
                                        <td class="text-sm">{{ $record->user->phone ?? 'N/A' }}</td>
                                        <td class="text-sm">{{ $record->user->email ?? 'N/A' }}</td>
                                        <td class="text-sm">{{ $record->user->addresses->first()->district ?? 'N/A' }}</td>
                                        <td class="text-sm">{{ $record->user->addresses->first()->state ?? 'N/A' }}</td>
                                        <td>
                                            @php $st = strtolower($record->status ?? 'pending'); @endphp
                                            <span class="badge-status
                                                @if($st === 'approved') badge-approved
                                                @elseif($st === 'suspended') badge-suspended
                                                @elseif($st === 'rejected') badge-rejected
                                                @else badge-pending @endif">
                                                {{ ucfirst($record->status ?? 'pending') }}
                                            </span>
                                        </td>
                                        <td class="text-sm">{{ $record->created_at->format('d M Y') }}</td>
                                    </tr>
                                    @empty
                                    <tr>
                                        <td colspan="10" class="text-center py-5 text-muted">
                                            <i class="lni lni-users" style="font-size:32px;opacity:.3;"></i>
                                            <p class="mt-2 mb-0">No records found</p>
                                        </td>
                                    </tr>
                                    @endforelse
                                </tbody>
                            </table>
                        </div>

                        <div class="pt-10 d-flex justify-content-between align-items-center flex-wrap gap-2">
                            <p class="text-sm text-gray mb-0">
                                Showing {{ $records->firstItem() ?? 0 }} – {{ $records->lastItem() ?? 0 }} of {{ $records->total() }} entries
                            </p>
                            {{ $records->appends(request()->query())->links('pagination::bootstrap-4') }}
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </section>

    @include('admin.footer')
</main>
@endsection

@section('script')
@include('admin.script')
@endsection