{{-- 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-4">
    <div>
      <h3 class="fw-bold mb-1">Rekap Keuangan Siswa</h3>
      <h6 class="op-7 mb-2">Laporan akumulasi tagihan dan penerimaan per Tingkat Kelas.</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" style="width: 45px; height: 45px; background: rgba(255, 193, 7, 0.2);">
                <i class="fas fa-globe text-warning fs-5"></i>
            </div>
            <div>
                <h5 class="fw-bold mb-0 text-white">Akumulasi Keseluruhan (All Time)</h5>
                <small class="text-white-50">Data mencakup seluruh tahun ajaran dan semester sejak awal</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 Seluruh Tagihan (Target)</th>
                        <th width="25%" class="py-3">Total Seluruh Terbayar (Masuk)</th>
                        <th width="30%" class="py-3">Total Kekurangan (Piutang Siswa)</th>
                    </tr>
                </thead>
                <tbody>
                    <tr>
                        <td class="text-center py-4 border-end border-secondary">
                            <span class="fs-3 fw-bold text-white">{{ isset($allTimeTotalSiswa) ? number_format($allTimeTotalSiswa, 0, ',', '.') : '0' }}</span><br>
                            <small class="text-white-50">Siswa Terdaftar</small>
                        </td>
                        <td class="text-center py-4 border-end border-secondary">
                            <span class="fs-4 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-4 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-4 fw-bold text-danger">Rp {{ number_format($sisa, 0, ',', '.') }}</span>
                            <div class="progress mt-2 mx-auto" style="height: 8px; width: 60%; background-color: rgba(255,255,255,0.1);">
                                <div class="progress-bar bg-success" role="progressbar" style="width: {{ $allTimePersentase }}%;" aria-valuenow="{{ $allTimePersentase }}" aria-valuemin="0" aria-valuemax="100"></div>
                            </div>
                            <small class="text-white-50 d-block mt-1">Total Capaian: {{ $allTimePersentase }}%</small>
                        </td>
                    </tr>
                </tbody>
            </table>
        </div>
    </div>
  </div>

  <div class="card card-round shadow-sm border-0 mb-4">
    <div class="card-header bg-white pb-3 pt-4 border-bottom">
        <div class="d-flex flex-column flex-md-row justify-content-between align-items-md-center">
            <div class="d-flex align-items-center mb-3 mb-md-0">
                <div class="icon-preview border border-primary rounded-circle d-flex justify-content-center align-items-center me-3" 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</h5>
                    <small class="text-muted">Menyesuaikan dengan filter di bawah</small>
                </div>
            </div>

            <div class="d-flex flex-column flex-sm-row gap-3">
                <div>
                    <label class="form-label fw-bold small text-muted mb-1"><i class="fa fa-calendar-alt me-1"></i> Tahun Ajaran</label>
                    <select class="form-select form-select-sm shadow-none border-primary fw-bold text-dark" onchange="window.location.href=this.value" style="min-width: 180px;">
                        @foreach($tahunAjarans as $ta)
                            @php
                                $url = request()->fullUrlWithQuery(['tahun_ajaran' => $ta->id]);
                                $isSelected = $selectedTahunId == $ta->id;
                            @endphp
                            <option value="{{ $url }}" {{ $isSelected ? 'selected' : '' }}>
                                {{ $ta->tahun_ajaran }} {{ $ta->is_active ? '(Aktif)' : '' }}
                            </option>
                        @endforeach
                    </select>
                </div>
                
                <div>
                    <label class="form-label fw-bold small text-muted mb-1"><i class="fa fa-clock me-1"></i> Semester</label>
                    <select class="form-select form-select-sm shadow-none border-primary fw-bold text-dark" onchange="window.location.href=this.value" style="min-width: 160px;">
                        @foreach($semesters as $semester)
                            @php
                                $url = request()->fullUrlWithQuery(['semester' => $semester->id]);
                                $isSelected = $selectedSemesterId == $semester->id;
                            @endphp
                            <option value="{{ $url }}" {{ $isSelected ? 'selected' : '' }}>
                                Semester {{ $semester->semester }}
                            </option>
                        @endforeach
                    </select>
                </div>
            </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">
                    <tr>
                        <th width="5%" class="py-3">No</th>
                        <th width="20%" class="py-3">Tingkatan Kelas</th>
                        <th width="15%" class="py-3">Jumlah Siswa</th>
                        <th width="20%" class="py-3">Total Tagihan (Target)</th>
                        <th width="20%" class="py-3">Total Terbayar (Masuk)</th>
                        <th width="20%" class="py-3">Kekurangan (Sisa)</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach ($rekapData as $index => $data)
                        <tr>
                            <td class="text-center fw-bold">{{ $index + 1 }}</td>
                            
                            <td class="fw-bold text-primary fs-6 px-4">
                                {{ $data['level'] }}
                            </td>
                            
                            <td class="text-center">
                                <span class="badge bg-secondary px-3 py-2 fs-6">
                                    {{ number_format($data['jumlah_siswa'], 0, ',', '.') }} Siswa
                                </span>
                            </td>
                            
                            <td class="text-end fw-bold px-4" style="color: #444;">
                                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">
                                Rp {{ number_format($data['sisa_tagihan'], 0, ',', '.') }}
                                @php
                                    $persentase = $data['total_tagihan'] > 0 
                                        ? round(($data['total_terbayar'] / $data['total_tagihan']) * 100, 1) 
                                        : 0;
                                @endphp
                                <div class="progress mt-2" style="height: 6px;">
                                    <div class="progress-bar bg-success" role="progressbar" style="width: {{ $persentase }}%;" aria-valuenow="{{ $persentase }}" aria-valuemin="0" aria-valuemax="100"></div>
                                </div>
                                <small class="text-muted" style="font-size: 0.7rem;">Capaian: {{ $persentase }}%</small>
                            </td>
                        </tr>
                    @endforeach
                </tbody>
                <tfoot class="table-light">
                    <tr>
                        <th colspan="2" class="text-end py-4 fs-5">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" style="color: #444;">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