@extends('layouts.app')

@section('title', 'Ringkasan & Traceability Kas Unit')

@section('content')
<div class="nk-content nk-content-fluid">
    <div class="container-xl wide-xl">
        <div class="nk-content-inner">
            <div class="nk-content-body">
                
                {{-- HEADER BLOCK --}}
                <div class="nk-block-head nk-block-head-sm mb-4">
                    <div class="nk-block-between align-items-center">
                        <div class="nk-block-head-content">
                            <h3 class="nk-block-title page-title">Ringkasan & Traceability Kas Unit</h3>
                            <div class="nk-block-des text-soft">
                                <p>Laporan audit penelusuran aliran dana droping, realisasi penggunaan belanja, dan sisa saldo kas per unit.</p>
                            </div>
                        </div>
                    </div>
                </div>

                {{-- FILTER FORM --}}
                <div class="card card-bordered mb-4">
                    <div class="card-inner">
                        <form method="GET" action="{{ route('yayasan.laporan.ringkasan-kas-unit.index') }}" class="row g-3 align-items-end">
                            <div class="col-md-4">
                                <div class="form-group">
                                    <label class="form-label" for="unit_id">Unit Sekolah / Kerja</label>
                                    <div class="form-control-wrap">
                                        <select name="unit_id" id="unit_id" class="form-select js-select2">
                                            <option value="">-- Semua Unit --</option>
                                            @foreach($unitList as $u)
                                                <option value="{{ $u->kode_unit }}" {{ (string)$selectedUnitId === (string)$u->kode_unit ? 'selected' : '' }}>
                                                    {{ $u->nama_unit }} ({{ $u->kode_unit }})
                                                </option>
                                            @endforeach
                                        </select>
                                    </div>
                                </div>
                            </div>
                            <div class="col-md-3">
                                <div class="form-group">
                                    <label class="form-label" for="tahun">Tahun Kalender</label>
                                    <div class="form-control-wrap">
                                        <select name="tahun" id="tahun" class="form-select js-select2">
                                            @foreach($tahunList as $t)
                                                <option value="{{ $t }}" {{ (string)$tahun === (string)$t ? 'selected' : '' }}>
                                                    Tahun {{ $t }}
                                                </option>
                                            @endforeach
                                        </select>
                                    </div>
                                </div>
                            </div>
                            <div class="col-md-5 d-flex gap-2 justify-content-start align-items-end">
                                <button type="submit" class="btn btn-primary px-3">
                                    <em class="icon ni ni-filter me-1"></em>
                                    <span>Tampilkan Laporan</span>
                                </button>
                                <a href="{{ route('yayasan.laporan.ringkasan-kas-unit.export-excel', ['unit_id' => $selectedUnitId, 'tahun' => $tahun]) }}" class="btn btn-success px-3">
                                    <em class="icon ni ni-file-xls me-1"></em>
                                    <span>Export Excel Rekonsiliasi</span>
                                </a>
                            </div>
                        </form>
                    </div>
                </div>

                {{-- SUMMARY CARDS --}}
                <div class="row g-gs mb-4">
                    {{-- Metric 1: Saldo Awal --}}
                    <div class="col-md-6 col-xxl-3">
                        <div class="card card-bordered card-full bg-light">
                            <div class="card-inner">
                                <div class="card-title-group align-start mb-1">
                                    <div class="card-title">
                                        <h6 class="subtitle text-soft">Saldo Kas Awal</h6>
                                    </div>
                                    <div class="card-tools">
                                        <em class="icon ni ni-wallet-fill fs-3 text-secondary"></em>
                                    </div>
                                </div>
                                <div class="card-amount">
                                    <span class="amount text-dark fs-4">
                                        Rp {{ number_format($grandTotalAwal, 0, ',', '.') }}
                                    </span>
                                </div>
                                <div class="text-soft small mt-1">Per 1 Januari {{ $tahun }}</div>
                            </div>
                        </div>
                    </div>

                    {{-- Metric 2: Total Droping Diterima --}}
                    <div class="col-md-6 col-xxl-3">
                        <div class="card card-bordered card-full bg-success-dim border-success">
                            <div class="card-inner">
                                <div class="card-title-group align-start mb-1">
                                    <div class="card-title">
                                        <h6 class="subtitle text-success">Total Droping Diterima</h6>
                                    </div>
                                    <div class="card-tools">
                                        <em class="icon ni ni-arrow-down-left fs-3 text-success"></em>
                                    </div>
                                </div>
                                <div class="card-amount">
                                    <span class="amount text-success fs-4">
                                        + Rp {{ number_format($grandTotalDroping, 0, ',', '.') }}
                                    </span>
                                </div>
                                <div class="text-success small mt-1">Penyaluran / Dana Masuk Kas Unit</div>
                            </div>
                        </div>
                    </div>

                    {{-- Metric 3: Total Realisasi Penggunaan --}}
                    <div class="col-md-6 col-xxl-3">
                        <div class="card card-bordered card-full bg-danger-dim border-danger">
                            <div class="card-inner">
                                <div class="card-title-group align-start mb-1">
                                    <div class="card-title">
                                        <h6 class="subtitle text-danger">Total Realisasi Belanja</h6>
                                    </div>
                                    <div class="card-tools">
                                        <em class="icon ni ni-arrow-up-right fs-3 text-danger"></em>
                                    </div>
                                </div>
                                <div class="card-amount">
                                    <span class="amount text-danger fs-4">
                                        - Rp {{ number_format($grandTotalRealisasi, 0, ',', '.') }}
                                    </span>
                                </div>
                                <div class="text-danger small mt-1">Penggunaan Kas Kegiatan Unit</div>
                            </div>
                        </div>
                    </div>

                    {{-- Metric 4: Sisa Saldo Kas Akhir --}}
                    <div class="col-md-6 col-xxl-3">
                        <div class="card card-bordered card-full bg-primary-dim border-primary">
                            <div class="card-inner">
                                <div class="card-title-group align-start mb-1">
                                    <div class="card-title">
                                        <h6 class="subtitle text-primary">Sisa Saldo Kas Real</h6>
                                    </div>
                                    <div class="card-tools">
                                        <em class="icon ni ni-coins fs-3 text-primary"></em>
                                    </div>
                                </div>
                                <div class="card-amount">
                                    <span class="amount text-primary fs-3 fw-bold">
                                        Rp {{ number_format($grandTotalAkhir, 0, ',', '.') }}
                                    </span>
                                </div>
                                <div class="text-primary small mt-1">Saldo Kas & Bank Terakhir</div>
                            </div>
                        </div>
                    </div>
                </div>

                {{-- TABEL 1: RINGKASAN SALDO PER UNIT --}}
                <div class="card card-bordered card-preview mb-4">
                    <div class="card-inner border-bottom bg-light">
                        <div class="card-title-group">
                            <div class="card-title">
                                <h6 class="title"><em class="icon ni ni-building mr-1"></em> Ringkasan Kas per Unit (Tahun {{ $tahun }})</h6>
                            </div>
                        </div>
                    </div>
                    <div class="card-inner p-0">
                        <div class="table-responsive">
                            <table class="table table-striped table-bordered mb-0">
                                <thead class="bg-lighter text-muted">
                                    <tr>
                                        <th class="text-center" style="width: 50px;">#</th>
                                        <th>Kode & Nama Unit</th>
                                        <th class="text-end">Saldo Awal</th>
                                        <th class="text-end text-success">Total Droping Diterima (+)</th>
                                        <th class="text-end text-danger">Total Realisasi Belanja (-)</th>
                                        <th class="text-end text-primary">Sisa Saldo Akhir</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @php $no = 1; @endphp
                                    @forelse($unitSummary as $uCode => $item)
                                        <tr>
                                            <td class="text-center">{{ $no++ }}</td>
                                            <td>
                                                <span class="fw-bold text-dark">{{ $item['nama_unit'] }}</span>
                                                <span class="badge bg-outline-light text-muted ms-1">Unit {{ $item['kode_unit'] }}</span>
                                            </td>
                                            <td class="text-end">
                                                Rp {{ number_format($item['saldo_awal'], 0, ',', '.') }}
                                            </td>
                                            <td class="text-end text-success fw-semibold">
                                                Rp {{ number_format($item['total_droping'], 0, ',', '.') }}
                                            </td>
                                            <td class="text-end text-danger fw-semibold">
                                                Rp {{ number_format($item['total_realisasi'], 0, ',', '.') }}
                                            </td>
                                            <td class="text-end text-primary fw-bold">
                                                Rp {{ number_format($item['saldo_akhir'], 0, ',', '.') }}
                                            </td>
                                        </tr>
                                    @empty
                                        <tr>
                                            <td colspan="6" class="text-center text-muted py-3">Tidak ada data unit.</td>
                                        </tr>
                                    @endforelse
                                </tbody>
                                <tfoot class="bg-light fw-bold">
                                    <tr>
                                        <td colspan="2" class="text-uppercase text-end">Grand Total All Unit:</td>
                                        <td class="text-end">Rp {{ number_format($grandTotalAwal, 0, ',', '.') }}</td>
                                        <td class="text-end text-success">Rp {{ number_format($grandTotalDroping, 0, ',', '.') }}</td>
                                        <td class="text-end text-danger">Rp {{ number_format($grandTotalRealisasi, 0, ',', '.') }}</td>
                                        <td class="text-end text-primary fs-15px">Rp {{ number_format($grandTotalAkhir, 0, ',', '.') }}</td>
                                    </tr>
                                </tfoot>
                            </table>
                        </div>
                    </div>
                </div>

                {{-- TABEL 2: TRACEABILITY / AUDIT RINCIAN MUTASI --}}
                <div class="card card-bordered card-preview">
                    <div class="card-inner border-bottom bg-light">
                        <div class="card-title-group">
                            <div class="card-title">
                                <h6 class="title"><em class="icon ni ni-list-check mr-1"></em> Rincian Transaksi Audit Traceability (Mutasi Kas Unit)</h6>
                                <p class="text-soft small mb-0">Rincian seluruh transaksi kas masuk (droping) dan kas keluar (realisasi) kronologis.</p>
                            </div>
                        </div>
                    </div>
                    <div class="card-inner p-0">
                        <div class="table-responsive" style="max-height: 550px; overflow-y: auto;">
                            <table class="table table-hover table-bordered mb-0 align-middle">
                                <thead class="bg-lighter text-muted sticky-top">
                                    <tr>
                                        <th class="text-center" style="width: 40px;">No</th>
                                        <th style="width: 100px;">Tanggal</th>
                                        <th style="width: 130px;">No. Referensi</th>
                                        <th style="width: 130px;">Unit</th>
                                        <th style="width: 180px;">Rekening Kas</th>
                                        <th>Uraian Transaksi</th>
                                        <th class="text-end text-success" style="width: 130px;">Masuk / Droping</th>
                                        <th class="text-end text-danger" style="width: 130px;">Keluar / Realisasi</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @php $rowNo = 1; @endphp
                                    @forelse($mutasiRows as $row)
                                        <tr>
                                            <td class="text-center fs-12px">{{ $rowNo++ }}</td>
                                            <td class="fs-12px">{{ date('d/m/Y', strtotime($row['tanggal'])) }}</td>
                                            <td>
                                                <span class="badge bg-light text-dark font-monospace fs-11px">{{ $row['no_referensi'] }}</span>
                                            </td>
                                            <td class="fs-12px fw-bold">{{ $row['unit_nama'] }}</td>
                                            <td class="fs-12px text-muted">{{ $row['akun_kas'] }}</td>
                                            <td class="fs-12px">
                                                <div>{{ $row['deskripsi'] }}</div>
                                                <span class="badge {{ $row['is_droping'] ? 'bg-success-dim text-success' : 'bg-danger-dim text-danger' }} fs-10px">
                                                    {{ $row['kategori'] }}
                                                </span>
                                            </td>
                                            <td class="text-end fw-semibold text-success fs-12px">
                                                {{ $row['debit_droping'] > 0 ? 'Rp ' . number_format($row['debit_droping'], 0, ',', '.') : '-' }}
                                            </td>
                                            <td class="text-end fw-semibold text-danger fs-12px">
                                                {{ $row['kredit_realisasi'] > 0 ? 'Rp ' . number_format($row['kredit_realisasi'], 0, ',', '.') : '-' }}
                                            </td>
                                        </tr>
                                    @empty
                                        <tr>
                                            <td colspan="8" class="text-center text-muted py-4">Tidak ada mutasi transaksi kas ditemukan untuk kriteria filter ini.</td>
                                        </tr>
                                    @endforelse
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>

            </div>
        </div>
    </div>
</div>
@endsection