@extends('layouts.app')

@section('title', 'Rekap Daya Tampung Sekolah')

@section('content')
<div class="container-fluid">
    <div class="d-flex justify-content-between align-items-center mb-4">
        <div>
            <h2 class="mb-1">
                <i class="bi bi-clipboard-data text-primary"></i>
                Rekap Daya Tampung Sekolah
            </h2>
            <p class="text-muted mb-0">Monitoring kapasitas penerimaan siswa baru dari seluruh sekolah</p>
        </div>
    </div>

    @if(session('success'))
    <div class="alert alert-success alert-dismissible fade show" role="alert">
        <i class="bi bi-check-circle me-2"></i>{{ session('success') }}
        <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
    </div>
    @endif

    <!-- Filter Card -->
    <div class="card mb-4">
        <div class="card-header bg-light">
            <h5 class="mb-0"><i class="bi bi-funnel me-2"></i>Filter Data</h5>
        </div>
        <div class="card-body">
            <form method="GET" action="{{ route('superadmin.daya-tampung.index') }}">
                <div class="row g-3">
                    <div class="col-md-4">
                        <label class="form-label">Tahun Ajaran</label>
                        <select name="tahun_ajaran" class="form-select">
                            <option value="">Semua Tahun Ajaran</option>
                            @foreach($tahunAjaranList as $ta)
                                <option value="{{ $ta }}" {{ request('tahun_ajaran') == $ta ? 'selected' : '' }}>
                                    {{ $ta }}
                                </option>
                            @endforeach
                        </select>
                    </div>
                    <div class="col-md-4">
                        <label class="form-label">Jenjang</label>
                        <select name="level" class="form-select">
                            <option value="">Semua Jenjang</option>
                            <option value="SLB" {{ request('level') == 'SLB' ? 'selected' : '' }}>SLB</option>
                            <option value="SD" {{ request('level') == 'SD' ? 'selected' : '' }}>SD</option>
                            <option value="SMP" {{ request('level') == 'SMP' ? 'selected' : '' }}>SMP</option>
                            <option value="SMA" {{ request('level') == 'SMA' ? 'selected' : '' }}>SMA</option>
                            <option value="SMK" {{ request('level') == 'SMK' ? 'selected' : '' }}>SMK</option>
                        </select>
                    </div>
                    <div class="col-md-4 d-flex align-items-end">
                        <button type="submit" class="btn btn-primary me-2">
                            <i class="bi bi-search me-1"></i> Filter
                        </button>
                        <a href="{{ route('superadmin.daya-tampung.index') }}" class="btn btn-secondary">
                            <i class="bi bi-x-circle me-1"></i> Reset
                        </a>
                    </div>
                </div>
            </form>
        </div>
    </div>

    <!-- Info Alert -->
    <div class="alert alert-info border-0 mb-4">
        <i class="bi bi-info-circle me-2"></i>
        <strong>Keterangan:</strong>
        <ul class="mb-0 mt-2 small">
            <li><strong>Rombel Saat Ini ({{ $tahunAjaranAktif }}):</strong> Data rombel dan siswa yang sedang aktif</li>
            <li><strong>Daya Tampung ({{ $tahunAjaranBaru }}):</strong> Kapasitas penerimaan siswa baru untuk tahun ajaran mendatang</li>
        </ul>
    </div>

    <!-- Data Table Card -->
    <div class="card">
        <div class="card-header bg-white d-flex justify-content-between align-items-center">
            <h5 class="mb-0">
                <i class="bi bi-table me-2"></i>
                Data Daya Tampung per Sekolah
            </h5>
            <span class="badge bg-primary">{{ $schools->total() }} Sekolah</span>
        </div>
        <div class="card-body">
            @if($schools->count() > 0)
            <div class="table-responsive">
                <table class="table table-hover align-middle">
                    <thead class="table-light">
                        <tr>
                            <th width="4%" rowspan="2" class="align-middle">No</th>
                            <th width="18%" rowspan="2" class="align-middle">Sekolah</th>
                            <th width="8%" rowspan="2" class="align-middle text-center">NPSN</th>
                            <th width="8%" rowspan="2" class="align-middle text-center">Jenjang</th>
                            <th colspan="2" class="text-center bg-info bg-opacity-25">Rombel Saat Ini<br><small>({{ $tahunAjaranAktif }})</small></th>
                            <th colspan="3" class="text-center bg-success bg-opacity-25">Daya Tampung TA Baru<br><small>({{ $tahunAjaranBaru }})</small></th>
                            <th width="8%" rowspan="2" class="align-middle text-center">Aksi</th>
                        </tr>
                        <tr>
                            <th width="8%" class="text-center bg-info bg-opacity-10">Rombel</th>
                            <th width="8%" class="text-center bg-info bg-opacity-10">Siswa</th>
                            <th width="10%" class="text-center bg-success bg-opacity-10">Total</th>
                            <th width="10%" class="text-center bg-success bg-opacity-10">Rencana Rombel</th>
                            <th width="10%" class="text-center bg-success bg-opacity-10">Siswa/Rombel</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach($schools as $index => $school)
                        @php
                            // Get data for active academic year (Rombel Saat Ini)
                            $dataAktif = $school->dayaTampung->firstWhere('tahun_ajaran', $tahunAjaranAktif);
                            
                            // Get data for new academic year (Daya Tampung)
                            $dataBaru = $school->dayaTampung->firstWhere('tahun_ajaran', $tahunAjaranBaru);
                            
                            // Calculate totals
                            $totalRombel = $dataAktif->total_rombel ?? 0;
                            $totalSiswa = $dataAktif->total_siswa ?? 0;
                            
                            $totalDayaTampung = ($dataBaru->daya_tampung_tk ?? 0) + 
                                               ($dataBaru->daya_tampung_kelas_1 ?? 0) + 
                                               ($dataBaru->daya_tampung_kelas_7 ?? 0) + 
                                               ($dataBaru->daya_tampung_kelas_10 ?? 0);
                            
                            $totalRencanaRombel = ($dataBaru->rencana_rombel_tk ?? 0) + 
                                                 ($dataBaru->rencana_rombel_kelas_1 ?? 0) + 
                                                 ($dataBaru->rencana_rombel_kelas_7 ?? 0) + 
                                                 ($dataBaru->rencana_rombel_kelas_10 ?? 0);
                        @endphp
                        <tr>
                            <td>{{ $schools->firstItem() + $index }}</td>
                            <td>
                                <strong>{{ $school->name }}</strong><br>
                                <small class="text-muted">{{ $school->kabkota->name ?? '-' }}</small>
                            </td>
                            <td class="text-center">{{ $school->npsn }}</td>
                            <td class="text-center">
                                <span class="badge bg-info">{{ $school->level }}</span>
                            </td>
                            <td class="text-center bg-info bg-opacity-10">
                                <strong class="text-primary">{{ $totalRombel }}</strong>
                            </td>
                            <td class="text-center bg-info bg-opacity-10">
                                <strong class="text-info">{{ $totalSiswa }}</strong>
                            </td>
                            <td class="text-center bg-success bg-opacity-10">
                                <span class="badge bg-success fs-6">{{ $totalDayaTampung }}</span>
                            </td>
                            <td class="text-center bg-success bg-opacity-10">
                                <span class="text-success">{{ $totalRencanaRombel }}</span>
                            </td>
                            <td class="text-center bg-success bg-opacity-10">
                                <span class="text-muted">{{ $dataBaru->siswa_per_rombel ?? '-' }}</span>
                            </td>
                            <td class="text-center">
                                @if($dataBaru)
                                <a href="{{ route('superadmin.daya-tampung.show', $dataBaru->id) }}" 
                                   class="btn btn-sm btn-outline-primary" title="Lihat Detail">
                                    <i class="bi bi-eye"></i>
                                </a>
                                @else
                                <span class="text-muted">-</span>
                                @endif
                            </td>
                        </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
            
            <div class="mt-3">
                {{ $schools->links() }}
            </div>
            @else
            <div class="text-center py-5">
                <i class="bi bi-inbox display-1 text-muted"></i>
                <p class="text-muted mt-3">Belum ada data daya tampung</p>
            </div>
            @endif
        </div>
    </div>
</div>
@endsection