@extends('adminlte::page')

@section('title', 'Realisasi Perbulan | Smart Finance')

@section('content_header')
    <div class="d-flex justify-content-between align-items-center">
        <div>
            <h1 class="text-dark font-weight-bold mb-1">Laporan Realisasi Perbulan</h1>
            <p class="text-muted small mb-0">Rangkuman Pendapatan & Beban dari Januari s/d Desember.</p>
        </div>
        <button onclick="window.print()" class="btn btn-outline-primary shadow-sm no-print">
            <i class="fas fa-print mr-2"></i> Cetak Laporan
        </button>
    </div>
@stop

@section('content')
<div class="container-fluid px-0">
    {{-- 1. FILTER TAHUN & SEKOLAH --}}
    <div class="card border-0 shadow-sm mb-4 no-print">
        <div class="card-body py-3">
            <form action="{{ route('keuangan.finance.reports.realisasi-perbulan') }}" method="GET" class="form-row align-items-end">
                @if(isset($daftarSekolah) && count($daftarSekolah) > 0)
                <div class="col-md-4">
                    <label class="small font-weight-bold text-muted text-uppercase">Unit Sekolah</label>
                    <select name="sekolah_id" class="form-control select2bs4" onchange="this.form.submit()">
                        @foreach($daftarSekolah as $s)
                            <option value="{{ $s->id }}" {{ $sekolahId == $s->id ? 'selected' : '' }}>
                                {{ $s->nama_sekolah }}
                            </option>
                        @endforeach
                    </select>
                </div>
                @endif
                <div class="col-md-3">
                    <label class="small font-weight-bold text-muted text-uppercase">Tahun Anggaran</label>
                    <select name="year" class="form-control" onchange="this.form.submit()">
                        @for($i = date('Y'); $i >= date('Y') - 5; $i--)
                            <option value="{{ $i }}" {{ $tahun == $i ? 'selected' : '' }}>{{ $i }}</option>
                        @endfor
                    </select>
                </div>
            </form>
        </div>
    </div>

    {{-- 2. TABEL MATRIKS REALISASI --}}
    <div class="card border-0 shadow-lg" style="border-radius: 12px; overflow: hidden;">
        <div class="card-header bg-white pt-4 pb-3 border-0">
            <h4 class="text-center font-weight-bold text-uppercase mb-0">REALISASI PENDAPATAN & BIAYA TAHUN {{ $tahun }}</h4>
        </div>
        <div class="card-body p-0">
            <div class="table-responsive">
                <table class="table table-bordered table-hover table-sm text-nowrap mb-0" style="font-size: 0.85rem;">
                    <thead class="bg-dark text-white text-center">
                        <tr>
                            <th class="align-middle" width="250px">Keterangan Akun</th>
                            @php $namaBulan = ['Jan', 'Feb', 'Mar', 'Apr', 'Mei', 'Jun', 'Jul', 'Ags', 'Sep', 'Okt', 'Nov', 'Des']; @endphp
                            @foreach($namaBulan as $bln)
                                <th class="align-middle" width="80px">{{ $bln }}</th>
                            @endforeach
                            <th class="align-middle bg-primary" width="100px">TOTAL YTD</th>
                        </tr>
                    </thead>
                    <tbody>
                        @php 
                            $currentType = ''; 
                            $totalPerBulan = array_fill(1, 12, 0);
                            $grandTotalYTD = 0;
                        @endphp

                        @forelse($realisasi as $accId => $data)
                            {{-- Header Tipe Akun (Pendapatan / Beban) --}}
                            @if($currentType != $data['akun']->type)
                                @php $currentType = $data['akun']->type; @endphp
                                <tr class="bg-light">
                                    <td colspan="14" class="font-weight-bold text-uppercase pl-3 {{ $currentType == 'REVENUE' ? 'text-success' : 'text-danger' }}">
                                        {{ $currentType == 'REVENUE' ? 'I. PENDAPATAN (REVENUE)' : 'II. BEBAN & BIAYA (EXPENSES)' }}
                                    </td>
                                </tr>
                            @endif

                            {{-- Baris Data Akun --}}
                            <tr>
                                <td class="pl-4 text-truncate" style="max-width: 250px;" title="{{ $data['akun']->name }}">
                                    {{ $data['akun']->code }} - {{ $data['akun']->name }}
                                </td>
                                
                                @for($i = 1; $i <= 12; $i++)
                                    @php 
                                        $nilaiBulan = $data['bulanan'][$i]; 
                                        // Akumulasi total bawah (Pendapatan bertambah, Beban mengurang)
                                        if($currentType == 'REVENUE') {
                                            $totalPerBulan[$i] += $nilaiBulan;
                                        } else {
                                            $totalPerBulan[$i] -= $nilaiBulan;
                                        }
                                    @endphp
                                    <td class="text-right {{ $nilaiBulan == 0 ? 'text-muted' : '' }}">
                                        {{ $nilaiBulan == 0 ? '-' : number_format($nilaiBulan, 0, ',', '.') }}
                                    </td>
                                @endfor

                                {{-- Kolom Total Setahun --}}
                                @php 
                                    if($currentType == 'REVENUE') {
                                        $grandTotalYTD += $data['total_setahun'];
                                    } else {
                                        $grandTotalYTD -= $data['total_setahun'];
                                    }
                                @endphp
                                <td class="text-right font-weight-bold bg-light">
                                    {{ number_format($data['total_setahun'], 0, ',', '.') }}
                                </td>
                            </tr>
                        @empty
                            <tr>
                                <td colspan="14" class="text-center py-5 text-muted">
                                    <i class="fas fa-folder-open fa-2x mb-2 d-block"></i>
                                    Belum ada data transaksi Pendapatan/Beban di tahun ini.
                                </td>
                            </tr>
                        @endforelse

                        {{-- Baris Grand Total (Surplus/Defisit) --}}
                        @if(count($realisasi) > 0)
                        <tr class="bg-dark text-white font-weight-bold" style="font-size: 0.95rem;">
                            <td class="text-right pr-3 py-2">SURPLUS / (DEFISIT) BERSIH</td>
                            @for($i = 1; $i <= 12; $i++)
                                <td class="text-right py-2 {{ $totalPerBulan[$i] < 0 ? 'text-warning' : '' }}">
                                    {{ number_format($totalPerBulan[$i], 0, ',', '.') }}
                                </td>
                            @endfor
                            <td class="text-right py-2 bg-primary">
                                {{ number_format($grandTotalYTD, 0, ',', '.') }}
                            </td>
                        </tr>
                        @endif
                    </tbody>
                </table>
            </div>
        </div>
    </div>
</div>
@stop

@section('css')
<style>
    @media print { 
        .no-print { display: none !important; } 
        .main-sidebar, .main-header { display: none !important; } 
        .content-wrapper { margin-left: 0 !important; }
        /* Cetak landscape karena kolomnya ada 12 bulan */
        @page { size: landscape; margin: 10mm; } 
    }
</style>
@stop

@section('js')
<script>
    $(document).ready(function() {
        if ($('.select2bs4').length) {
            $('.select2bs4').select2({ theme: 'bootstrap4', width: '100%' });
        }
    });
</script>
@stop