@include('layouts.header', ['title' => 'Agency Wise Projects'])
<!-- Begin page -->
<div class="wrapper">

    @include('layouts.navbar')
    @include('layouts.sidebar')

    <div class="content-page">
        <div class="content">
            <div class="container-fluid">

                <!-- Title -->
                <div class="row">
                    <div class="col-12">
                        <div class="page-title-box">
                            <h4 class="page-title">Agency Wise Projects</h4>
                            <div class="page-title-right"></div>
                        </div>
                    </div>
                </div>

                <!-- First Table: Summary -->
                <div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-header d-flex justify-content-between align-items-center">
                                <h4 class="header-title mb-0">For All Agencies</h4>
                            </div>
                            <div class="card-body">

                                <a href="{{ route('admin.mis.agency_wise_projects') }}?download_excel_1=1"
                                    class="btn btn-success me-2 mb-2">
                                    Download Excel
                                </a>

                                <a href="{{ route('admin.mis.agency_wise_projects') }}?download_pdf_1=1"
                                    class="btn btn-danger mb-2">
                                    Download PDF
                                </a>

                                <table class="table table-striped dt-responsive nowrap w-100">
                                    <thead>
                                        <tr>
                                            <th>Sl. No.</th>
                                            <th>Agency Name</th>
                                            <th>Total Projects</th>
                                            <th>BSES Completed</th>
                                            <th>Allotment Completed</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @forelse ($summary as $index => $row)
                                            <tr>
                                                <td>{{ $loop->iteration + ($summary->currentPage() - 1) * $summary->perPage() }}
                                                </td>
                                                <td>{{ $row['agency_name'] }}</td>
                                                <td>{{ $row['total_projects'] }}</td>
                                                <td>{{ $row['bses_completed'] }}</td>
                                                <td>{{ $row['allotment_completed'] }}</td>
                                            </tr>
                                        @empty
                                            <tr>
                                                <td colspan="5" class="text-center">No data available</td>
                                            </tr>
                                        @endforelse
                                    </tbody>
                                </table>

                                {{ $summary->withQueryString()->links('pagination::bootstrap-5') }}



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

                <!-- Second Table: Project Details for Selected Agency -->
                <div class="row">
                    <div class="col-12">
                        <form method="GET" action="{{ route('admin.mis.agency_wise_projects') }}">
                            <div class="mb-3">
                                <label for="agencySelect" class="form-label">Select Agency</label>
                                <select class="form-control" name="agency_id" id="agencySelect"
                                    onchange="this.form.submit()">
                                    <option value="">-- Select Agency --</option>
                                    @foreach ($allAgencies as $agency)
                                        <option value="{{ urlencode(encrypt($agency->id)) }}"
                                            {{ $selectedAgencyId == $agency->id ? 'selected' : '' }}>
                                            {{ $agency->name }}
                                        </option>
                                    @endforeach
                                </select>
                            </div>
                        </form>
                    </div>

                    @if ($selectedAgencyProjects && $selectedAgencyProjects->isNotEmpty())

                        <div class="col-12">
                            <div class="card">
                                <div class="card-header">
                                    <h4 class="header-title mb-0">Projects under Selected Agency</h4>
                                </div>
                                <div class="card-body">

                                    @php
                                        $encryptedAgencyId = urlencode(encrypt($selectedAgencyId));
                                    @endphp

                                    <a href="{{ route('admin.mis.agency_wise_projects') }}?agency_id={{ $encryptedAgencyId }}&download_excel_2=1"
                                        class="btn btn-success me-2 mb-2">
                                        Download Excel
                                    </a>

                                    <a href="{{ route('admin.mis.agency_wise_projects') }}?agency_id={{ $encryptedAgencyId }}&download_pdf_2=1"
                                        class="btn btn-danger mb-2">
                                        Download PDF
                                    </a>

                                    <table class="table table-striped dt-responsive nowrap w-100">
                                        <thead>
                                            <tr>
                                                <th>Sl. No.</th>
                                                <th>Project Name</th>
                                                <th>Status</th>
                                                <th>Total PAPs</th>
                                                <th>Residential PAPs</th>
                                                <th>Commercial PAPs</th>
                                                <th>Residential + <br>Commercial PAPs</th>
                                                <th>Other PAPs</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @foreach ($selectedAgencyProjects as $index => $project)
                                                <tr>
                                                    <td>{{ $loop->iteration + ($selectedAgencyProjects->currentPage() - 1) * $selectedAgencyProjects->perPage() }}
                                                    </td>
                                                    <td>{{ $project['name'] }}</td>
                                                    <td>{{ $project['status_name'] }}</td>
                                                    <td>{{ $project['pap_count'] }}</td>
                                                    <td>{{ $project['r'] }}</td>
                                                    <td>{{ $project['c'] }}</td>
                                                    <td>{{ $project['rc'] }}</td>
                                                    <td>{{ $project['o'] }}</td>
                                                </tr>
                                            @endforeach
                                        </tbody>
                                    </table>

                                    {{ $selectedAgencyProjects->withQueryString()->links('pagination::bootstrap-5') }}

                                </div>
                            </div>
                        </div>
                    @elseif ($selectedAgencyId)
                        <div class="col-12">
                            <div class="alert alert-warning">No projects found for this agency.</div>
                        </div>
                    @endif
                </div>

            </div> <!-- container -->
        </div> <!-- content -->

        @include('layouts.footer')
    </div>
</div>

<!-- Scripts -->
<script src="{{ asset('assets/js/vendor.min.js') }}"></script>
<script src="{{ asset('assets/js/app.min.js') }}"></script>
<script src="{{ asset('assets/js/datatable.js') }}"></script>
</body>

</html>