@include('layouts.header', ['title' => 'Division Wise Projects'])

<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">Division Wise Projects</h4>
                            <div class="page-title-right"></div>
                        </div>
                    </div>
                </div>

                <!-- Summary Table -->
                <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 Divisions</h4>
                            </div>
                            <div class="card-body">

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

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

                                <table class="table table-striped">
                                    <thead>
                                        <tr>
                                            <th>Sl. No.</th>
                                            <th>Division 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['division_name'] ?? 'Unknown Division' }}</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>

                <!-- Detail Table -->
                <div class="row">
                    <div class="col-12">
                        <form method="GET" action="{{ route('admin.mis.divison_wise_projects') }}">
                            <div class="mb-3">
                                <label class="form-label">Select Division</label>
                                <select class="form-control" name="project_belongs_to" onchange="this.form.submit()">
                                    <option value="">-- Select Division --</option>
                                    @foreach ($allProjectBelongsTo as $division)
                                        <option value="{{ $division->project_belongs_to ?? 'Unknown Division' }}"
                                            {{ $selectedBelongsTo == ($division->project_belongs_to ?? 'Unknown Division') ? 'selected' : '' }}>
                                            {{ $division->project_belongs_to ?? 'Unknown Division' }}
                                        </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 Division: {{ $divisionName }}</h4>
                                </div>
                                <div class="card-body">

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

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

                                    <table class="table table-striped">
                                        <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 ($selectedBelongsTo)
                        <div class="col-12">
                            <div class="alert alert-warning">No projects found for this division.</div>
                        </div>
                    @endif
                </div>

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

<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>