{{-- resources/views/admin/keuangan/transaksi-siswa/rekap.blade.php --}}
@extends('layouts.admin')
@section('title', 'Rekap Keuangan Siswa')

@section('content')
<div class="page-inner">
  <div class="d-flex align-items-left align-items-md-center flex-column flex-md-row pt-2 pb-3">
    <div>
      <h3 class="fw-bold mb-1">Manajemen Keuangan: Rekapitulasi</h3>
      <h6 class="op-7 mb-2">Laporan akumulasi target tagihan, pemasukan, dan sisa piutang.</h6>
    </div>
    <div class="ms-md-auto py-2 py-md-0">
        <a href="{{ route('admin.transaksi-siswa.index') }}" class="btn btn-secondary btn-round shadow-sm">
          <i class="fa fa-arrow-left me-1"></i> Kembali ke Pembayaran
        </a>
    </div>
  </div>

  <div class="card card-round shadow-sm border-0 bg-dark text-white mb-4">
    <div class="card-header border-bottom border-secondary pb-3 pt-4">
        <div class="d-flex align-items-center">
            <div class="icon-preview border border-warning rounded-circle d-flex justify-content-center align-items-center me-3 shadow-sm" style="width: 50px; height: 50px; background: rgba(255, 193, 7, 0.15);">
                <i class="fas fa-globe text-warning fs-4"></i>
            </div>
            <div>
                <h4 class="fw-bold mb-0 text-white">Akumulasi Keseluruhan (All Time)</h4>
                <small class="text-white-50">Data mencakup seluruh tahun ajaran dan semester yang tercatat pada sistem.</small>
            </div>
        </div>
    </div>
    <div class="card-body p-0">
        <div class="table-responsive">
            <table class="table table-dark table-borderless align-middle mb-0">
                <thead class="text-center text-white-50 border-bottom border-secondary">
                    <tr>
                        <th width="20%" class="py-3">Total Seluruh Siswa</th>
                        <th width="25%" class="py-3">Total Tagihan (Target)</th>
                        <th width="25%" class="py-3">Total Terbayar (Masuk)</th>
                        <th width="30%" class="py-3">Total Kekurangan (Piutang)</th>
                    </tr>
                </thead>
                <tbody>
                    <tr>
                        <td class="text-center py-4 border-end border-secondary">
                            <span class="fs-2 fw-bold text-white">{{ isset($allTimeTotalSiswa) ? number_format($allTimeTotalSiswa, 0, ',', '.') : '0' }}</span><br>
                            <small class="text-white-50 fw-bold">Siswa Terdaftar</small>
                        </td>
                        <td class="text-center py-4 border-end border-secondary">
                            <span class="fs-3 fw-bold text-warning">Rp {{ isset($allTimeTotalTagihan) ? number_format($allTimeTotalTagihan, 0, ',', '.') : '0' }}</span>
                        </td>
                        <td class="text-center py-4 border-end border-secondary">
                            <span class="fs-3 fw-bold text-success">Rp {{ isset($allTimeTotalTerbayar) ? number_format($allTimeTotalTerbayar, 0, ',', '.') : '0' }}</span>
                        </td>
                        <td class="text-center py-4">
                            @php
                                $tagihan = $allTimeTotalTagihan ?? 0;
                                $terbayar = $allTimeTotalTerbayar ?? 0;
                                $sisa = $tagihan - $terbayar;
                                $allTimePersentase = $tagihan > 0 ? round(($terbayar / $tagihan) * 100, 1) : 0;
                            @endphp
                            <span class="fs-3 fw-bold text-danger">Rp {{ number_format($sisa, 0, ',', '.') }}</span>
                            <div class="progress mt-3 mx-auto shadow-sm" style="height: 10px; width: 70%; background-color: rgba(255,255,255,0.1); border-radius: 10px;">
                                <div class="progress-bar bg-success" role="progressbar" style="width: {{ $allTimePersentase }}%; border-radius: 10px;"></div>
                            </div>
                            <small class="text-white-50 d-block mt-2 fw-bold">Total Capaian: {{ $allTimePersentase }}%</small>
                        </td>
                    </tr>
                </tbody>
            </table>
        </div>
    </div>
  </div>

  <div class="card border-0 shadow-sm rounded-4 mb-4">
    <div class="card-body p-3">
        <div class="row g-3 align-items-end justify-content-center">
          <div class="col-md-5">
            <label class="form-label fw-bold small text-muted mb-1"><i class="fas fa-calendar-check me-1"></i> Filter Tahun Ajaran</label>
            <select class="form-select border-primary-subtle bg-light fw-bold" onchange="window.location.href=this.value">
                @foreach($tahunAjarans as $ta)
                    @php $url = request()->fullUrlWithQuery(['tahun_ajaran' => $ta->id]); @endphp
                    <option value="{{ $url }}" {{ $selectedTahunId == $ta->id ? 'selected' : '' }}>
                        {{ $ta->tahun_ajaran }} {{ $ta->is_active ? '(Aktif)' : '' }}
                    </option>
                @endforeach
            </select>
          </div>
          <div class="col-md-5">
            <label class="form-label fw-bold small text-muted mb-1"><i class="fas fa-clock me-1"></i> Filter Semester</label>
            <select class="form-select border-primary-subtle bg-light fw-bold" onchange="window.location.href=this.value">
                @foreach($semesters as $semester)
                    @php $url = request()->fullUrlWithQuery(['semester' => $semester->id]); @endphp
                    <option value="{{ $url }}" {{ $selectedSemesterId == $semester->id ? 'selected' : '' }}>
                        Semester {{ $semester->semester }}
                    </option>
                @endforeach
            </select>
          </div>
        </div>
    </div>
  </div>

  <div class="card card-round shadow-sm border-0 mb-4">
    <div class="card-header bg-white py-3 border-bottom">
        <div class="d-flex align-items-center">
            <div class="icon-preview border border-primary rounded-circle d-flex justify-content-center align-items-center me-3 shadow-sm" style="width: 45px; height: 45px; background: #e8f1ff;">
                <i class="fas fa-filter text-primary fs-5"></i>
            </div>
            <div>
                <h5 class="fw-bold mb-0 text-dark">Data Berdasarkan Periode Kelas</h5>
                <small class="text-muted">Rincian tabel di bawah telah menyesuaikan dengan panel filter periode.</small>
            </div>
        </div>
    </div>
    
    <div class="card-body p-0">
        <div class="table-responsive">
            <table class="table table-striped table-hover align-middle mb-0">
                <thead class="table-dark text-center align-middle">
                    <tr>
                        <th width="5%" class="py-3">No</th>
                        <th width="20%" class="text-start px-4">Tingkat Kelas</th>
                        <th width="15%">Jumlah Siswa</th>
                        <th width="20%">Total Tagihan (Target)</th>
                        <th width="20%">Total Terbayar (Masuk)</th>
                        <th width="20%">Kekurangan (Sisa Piutang)</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach ($rekapData as $index => $data)
                        <tr class="bg-white text-center">
                            <td class="fw-bold">{{ $index + 1 }}</td>
                            
                            <td class="text-start px-4">
                                <span class="fw-bold text-primary fs-6"><i class="fa fa-layer-group me-1 opacity-50"></i> {{ $data['level'] }}</span>
                            </td>
                            
                            <td>
                                <span class="badge bg-secondary shadow-sm px-3 py-2 fs-6">
                                    {{ number_format($data['jumlah_siswa'], 0, ',', '.') }} Siswa
                                </span>
                            </td>
                            
                            <td class="text-end fw-bold px-4 text-dark fs-6">
                                Rp {{ number_format($data['total_tagihan'], 0, ',', '.') }}
                            </td>
                            
                            <td class="text-end fw-bold text-success px-4 fs-6">
                                Rp {{ number_format($data['total_terbayar'], 0, ',', '.') }}
                            </td>
                            
                            <td class="text-end fw-bold text-danger px-4">
                                <span class="fs-6">Rp {{ number_format($data['sisa_tagihan'], 0, ',', '.') }}</span>
                                @php
                                    $persentase = $data['total_tagihan'] > 0 
                                        ? round(($data['total_terbayar'] / $data['total_tagihan']) * 100, 1) 
                                        : 0;
                                @endphp
                                <div class="progress mt-2 shadow-sm" style="height: 6px; border-radius: 5px;">
                                    <div class="progress-bar bg-success" role="progressbar" style="width: {{ $persentase }}%; border-radius: 5px;"></div>
                                </div>
                                <small class="text-muted d-block mt-1 fw-bold" style="font-size: 0.75rem;">Capaian: {{ $persentase }}%</small>
                            </td>
                        </tr>
                    @endforeach
                </tbody>
                <tfoot class="table-light border-top border-2 border-secondary">
                    <tr>
                        <th colspan="2" class="text-end py-4 fs-5 text-dark">TOTAL PERIODE INI:</th>
                        <th class="text-center py-4 fs-5 text-dark">{{ number_format($grandTotalSiswa, 0, ',', '.') }}</th>
                        <th class="text-end py-4 fs-5 px-4 text-dark">Rp {{ number_format($grandTotalTagihan, 0, ',', '.') }}</th>
                        <th class="text-end py-4 fs-5 text-success px-4">Rp {{ number_format($grandTotalTerbayar, 0, ',', '.') }}</th>
                        <th class="text-end py-4 fs-5 text-danger px-4">Rp {{ number_format($grandTotalTagihan - $grandTotalTerbayar, 0, ',', '.') }}</th>
                    </tr>
                </tfoot>
            </table>
        </div>
    </div>
  </div>

</div>
@endsection