@extends('layouts.admin')

@section('content')
    <div class="container">
        <h2>Application Reports</h2>

        <!-- 🔍 Filter Form -->
        <form method="GET" class="row g-3 mb-4">
            <div class="col-md-3">
                <select name="district_id" class="form-select">
                    <option value="">All Districts</option>
                    @foreach ($districts as $district)
                        <option value="{{ $district->id }}" @selected(request('district_id') == $district->id)>
                            {{ $district->district }}
                        </option>
                    @endforeach
                </select>
            </div>
            <div class="col-md-3">
                <select name="taluk_id" class="form-select">
                    <option value="">All Taluks</option>
                    @foreach ($taluks as $taluk)
                        <option value="{{ $taluk->id }}" @selected(request('taluk_id') == $taluk->id)>
                            {{ $taluk->taluk_name }}
                        </option>
                    @endforeach
                </select>
            </div>
            <div class="col-md-3">
                <select name="unit_id" class="form-select">
                    <option value="">All Units</option>
                    @foreach ($units as $unit)
                        <option value="{{ $unit->id }}" @selected(request('unit_id') == $unit->id)>
                            {{ $unit->name }}
                        </option>
                    @endforeach
                </select>
            </div>
            <div class="col-md-3">
                <button class="btn btn-primary w-100">Filter</button>
            </div>


        </form>
        <div class="mt-4">
            <a href="{{ route('admin.reports.applications.export.csv', request()->query()) }}"
                class="btn btn-outline-success">Export CSV</a>
            <a href="{{ route('admin.reports.applications.export.pdf', request()->query()) }}"
                class="btn btn-outline-danger">Export PDF</a>
        </div><br>


        <div class="row">
            <div class="col-12 col-xl-12">
                <div class="card">

                    <div class="table-responsive">
                        <table class="table">
                            <thead>
                                <tr>
                                    <th>#</th>
                                    <th>Application Number</th>
                                    <th>Applicant</th>
                                    <th>District</th>
                                    <th>Taluk</th>
                                    <th>Unit</th>
                                    <th>Society</th>
                                    <th>Status</th>
                                    <th>Submitted</th>

                                </tr>
                            </thead>
                            <tbody>


                                @if (count($applications) == 0)
                                    <tr>
                                        <td colspan="6">No Applications</td>
                                    </tr>
                                @endif

                                @foreach ($applications as $app)
                                    <tr>
                                        <td>{{ $loop->iteration }}</td>
                                        <td>{{ $app->application_number }}</td>
                                        <td>{{ $app->name }}</td>
                                        <td>{{ $app->society?->District?->district }}</td>
                                        <td>{{ $app->society?->Taluk?->taluk_name }}</td>
                                        <td>{{ $app->society?->Unit?->name }}</td>
                                        <td>{{ $app->society->name ?? 'N/A' }}<br><b
                                                style="color: #999; font-size:12px;">{{ $app->society->code ?? 'N/A' }}</b>
                                        </td>
                                        <td>{{ $app->applicationStatus?->status_name }}</td>
                                        <td>{{ optional($app->submitted_at)->format('Y-m-d') }}</td>
                                    </tr>
                                @endforeach

                            </tbody>
                        </table>

                        <div class="d-flex justify-content-center">
                            {{ $applications->links() }}
                        </div>
                    </div>

                </div>
            </div>
        </div>



    </div>
@endsection