@extends('admin.layout', [
    'title' => 'Laporan Kampus',
    'heading' => 'Laporan Akademik, Keuangan, dan Alumni',
    'subheading' => 'Satukan ringkasan mahasiswa, KRS, presensi, pembayaran, dan alumni dalam satu panel monitoring.',
])

@section('admin-content')
    <div class="row">
        @foreach ($summaryCards as $card)
            <div class="col-lg-3 col-md-6">
                <div class="small-box {{ $card['color'] }}">
                    <div class="inner">
                        <h3>{{ $card['value'] }}</h3>
                        <p>{{ $card['label'] }}</p>
                    </div>
                    <div class="icon"><i class="{{ $card['icon'] }}"></i></div>
                </div>
            </div>
        @endforeach
    </div>

    <div class="card">
        <div class="card-header">
            <h3 class="card-title">Filter Laporan</h3>
        </div>
        <div class="card-body">
            <form method="GET">
                <div class="row">
                    <div class="col-md-4">
                        <select name="prodi_id" class="form-control">
                            <option value="">Semua Program Studi</option>
                            @foreach ($programs as $program)
                                <option value="{{ $program->id }}" @selected($programId === $program->id)>{{ $program->nama_prodi }}</option>
                            @endforeach
                        </select>
                    </div>
                    <div class="col-md-4">
                        <select name="tahun_akademik_id" class="form-control">
                            <option value="">Semua Tahun Akademik</option>
                            @foreach ($years as $year)
                                <option value="{{ $year->id }}" @selected($tahunAkademikId === $year->id)>{{ $year->tahun }} / {{ $year->semester }}</option>
                            @endforeach
                        </select>
                    </div>
                    <div class="col-md-4">
                        <div class="btn-group w-100">
                            <button type="submit" class="btn btn-primary">Tampilkan</button>
                            @if ($programId > 0 || $tahunAkademikId > 0)
                                <a href="{{ route('admin.reports.index') }}" class="btn btn-outline-secondary">Reset</a>
                            @endif
                        </div>
                    </div>
                </div>
            </form>

            <form method="GET" action="{{ route('admin.reports.export') }}" class="mt-3">
                <input type="hidden" name="prodi_id" value="{{ $programId }}">
                <input type="hidden" name="tahun_akademik_id" value="{{ $tahunAkademikId }}">
                <div class="row align-items-end">
                    <div class="col-md-4">
                        <label for="dataset" class="mb-1">Dataset Export Excel</label>
                        <select id="dataset" name="dataset" class="form-control">
                            <option value="programs">Kinerja Program Studi</option>
                            <option value="academic-summary">Rekap Akademik</option>
                            <option value="students">Status Mahasiswa</option>
                            <option value="finance">Ringkasan Keuangan</option>
                            <option value="attendance">Ringkasan Presensi</option>
                            <option value="alumni">Ringkasan Alumni</option>
                        </select>
                    </div>
                    <div class="col-md-8">
                        <div class="d-flex flex-wrap" style="gap: .5rem;">
                            <button type="submit" class="btn btn-success">
                                <i class="fas fa-file-excel mr-1"></i>
                                Export Excel
                            </button>
                            <a href="{{ route('admin.reports.print', ['prodi_id' => $programId, 'tahun_akademik_id' => $tahunAkademikId]) }}" class="btn btn-outline-dark" target="_blank">
                                <i class="fas fa-print mr-1"></i>
                                Cetak / PDF
                            </a>
                        </div>
                    </div>
                </div>
            </form>
        </div>
    </div>

    <div class="row">
        <div class="col-lg-4">
            <div class="card card-outline card-primary h-100">
                <div class="card-header">
                    <h3 class="card-title">Ringkasan Akademik</h3>
                </div>
                <div class="card-body">
                    <div class="row">
                        <div class="col-6 mb-3">
                            <div class="info-label">Total KRS</div>
                            <strong>{{ $academicSummary['krs_total'] }}</strong>
                        </div>
                        <div class="col-6 mb-3">
                            <div class="info-label">KRS Pending</div>
                            <strong>{{ $academicSummary['pending_krs'] }}</strong>
                        </div>
                        <div class="col-6 mb-3">
                            <div class="info-label">KRS Disetujui</div>
                            <strong>{{ $academicSummary['approved_krs'] }}</strong>
                        </div>
                        <div class="col-6 mb-3">
                            <div class="info-label">Data Nilai</div>
                            <strong>{{ $academicSummary['nilai_total'] }}</strong>
                        </div>
                        <div class="col-6">
                            <div class="info-label">Presensi</div>
                            <strong>{{ $academicSummary['attendance_total'] }}</strong>
                        </div>
                        <div class="col-6">
                            <div class="info-label">Kehadiran</div>
                            <strong>{{ $academicSummary['attendance_rate'] }}%</strong>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <div class="col-lg-4">
            <div class="card h-100">
                <div class="card-header">
                    <h3 class="card-title">Status Mahasiswa</h3>
                </div>
                <div class="card-body table-responsive p-0">
                    <table class="table table-hover mb-0">
                        <thead>
                            <tr>
                                <th>Status</th>
                                <th>Jumlah</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach ($studentStatusSummary as $item)
                                <tr>
                                    <td>{{ $item['label'] }}</td>
                                    <td>{{ $item['count'] }}</td>
                                </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
        </div>

        <div class="col-lg-4">
            <div class="card h-100">
                <div class="card-header">
                    <h3 class="card-title">Ringkasan Presensi</h3>
                </div>
                <div class="card-body table-responsive p-0">
                    <table class="table table-hover mb-0">
                        <thead>
                            <tr>
                                <th>Status</th>
                                <th>Jumlah</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach ($attendanceSummary as $item)
                                <tr>
                                    <td>{{ $item['label'] }}</td>
                                    <td>{{ $item['count'] }}</td>
                                </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>

    <div class="row">
        <div class="col-lg-6">
            <div class="card">
                <div class="card-header">
                    <h3 class="card-title">Ringkasan Keuangan</h3>
                </div>
                <div class="card-body table-responsive p-0">
                    <table class="table table-bordered table-hover mb-0">
                        <thead>
                            <tr>
                                <th>Status</th>
                                <th>Tagihan</th>
                                <th>Total Tagihan</th>
                                <th>Dibayar</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach ($financeStatusSummary as $item)
                                <tr>
                                    <td>{{ $item['label'] }}</td>
                                    <td>{{ $item['count'] }}</td>
                                    <td>Rp {{ number_format((float) $item['nominal'], 0, ',', '.') }}</td>
                                    <td>Rp {{ number_format((float) $item['approved'], 0, ',', '.') }}</td>
                                </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
        </div>

        <div class="col-lg-6">
            <div class="card">
                <div class="card-header">
                    <h3 class="card-title">Ringkasan Alumni per Tahun Lulus</h3>
                </div>
                <div class="card-body table-responsive p-0">
                    <table class="table table-bordered table-hover mb-0">
                        <thead>
                            <tr>
                                <th>Tahun Lulus</th>
                                <th>Total Alumni</th>
                                <th>Tracer Terisi</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse ($alumniYearSummary as $item)
                                <tr>
                                    <td>{{ $item['year'] }}</td>
                                    <td>{{ $item['count'] }}</td>
                                    <td>{{ $item['tracer_count'] }}</td>
                                </tr>
                            @empty
                                <tr>
                                    <td colspan="3" class="text-center text-muted">Belum ada data alumni.</td>
                                </tr>
                            @endforelse
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>

    <div class="card">
        <div class="card-header">
            <h3 class="card-title">Kinerja per Program Studi</h3>
        </div>
        <div class="card-body table-responsive">
            <table class="table table-bordered table-hover">
                <thead>
                    <tr>
                        <th>Program Studi</th>
                        <th>Mahasiswa</th>
                        <th>Dosen</th>
                        <th>Alumni</th>
                        <th>Tagihan</th>
                        <th>Pembayaran Disetujui</th>
                        <th>Kehadiran</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse ($programSummary as $item)
                        <tr>
                            <td>{{ $item['program']->nama_prodi }}</td>
                            <td>{{ $item['student_count'] }}</td>
                            <td>{{ $item['lecturer_count'] }}</td>
                            <td>{{ $item['alumni_count'] }}</td>
                            <td>{{ $item['payment_count'] }}</td>
                            <td>Rp {{ number_format((float) $item['approved_payment'], 0, ',', '.') }}</td>
                            <td>{{ $item['attendance_rate'] !== null ? $item['attendance_rate'].'%' : '-' }}</td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="7" class="text-center text-muted">Belum ada data program studi yang cocok dengan filter.</td>
                        </tr>
                    @endforelse
                </tbody>
            </table>
        </div>
    </div>

    <div class="card">
        <div class="card-header">
            <h3 class="card-title">Presensi Terakhir Tercatat</h3>
        </div>
        <div class="card-body table-responsive">
            <table class="table table-bordered table-hover">
                <thead>
                    <tr>
                        <th>Tanggal</th>
                        <th>Mahasiswa</th>
                        <th>Mata Kuliah</th>
                        <th>Status</th>
                        <th>Keterangan</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse ($recentAttendance as $item)
                        <tr>
                            <td>{{ $item->tanggal?->format('d M Y') ?? '-' }}</td>
                            <td>{{ $item->mahasiswa?->nama_mahasiswa ?? '-' }}</td>
                            <td>{{ $item->jadwalKuliah?->mataKuliah?->nama_mk ?? '-' }}</td>
                            <td>{{ ucfirst($item->status) }}</td>
                            <td>{{ $item->keterangan ?? '-' }}</td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="5" class="text-center text-muted">Belum ada data presensi.</td>
                        </tr>
                    @endforelse
                </tbody>
            </table>
        </div>
    </div>
@endsection