@extends('layouts.app')

@section('title', 'Laporan Buku Besar')

@section('content')

@php
function formatRp($value) {
// ubah menjadi float untuk memastikan operasi aman
$value = (float)$value;
if($value < 0){
return '(' . number_format(abs($value), 2, ',', '.') . ')';
}
return number_format($value, 2, ',', '.');
}
@endphp
<div class="nk-content nk-content-fluid">
    <div class="container-xl wide-xl">
        <div class="nk-content-inner">
            <div class="nk-content-body">
                <div class="nk-block-head nk-block-head-sm">
                    <div class="nk-block-between">
                        <div class="nk-block-head-content">
                            <h3 class="nk-block-title page-title">Laporan Buku Besar</h3>
                            <div class="nk-block-des text-soft">
                                <p>Menampilkan catatan transaksi per akun.</p>
                            </div>
                        </div>
                    </div>
                </div>

                {{-- Filter --}}
                <div class="card card-bordered mb-4">
                    <div class="card-inner">
                        <form action="{{ route('yayasan.laporan.buku-besar.index') }}" method="GET">
                            <div class="row g-3 align-items-end">
                                <div class="col-md-4">
                                    <div class="form-group">
                                        <label class="form-label">Akun</label>
                                        <div class="form-control-wrap">
                                            <select name="kode_akun" class="form-select select-akun">
                                                <option value="">Pilih Akun</option>
                                                @foreach ($akunList as $a)
                                                <option value="{{ $a->kode_akun }}" {{ request('kode_akun') == $a->kode_akun ? 'selected' : '' }}>
                                                    {{ $a->kode_akun }} - {{ $a->nama_akun }}
                                                </option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>
                                </div>
                                <div class="col-md-3">
                                    <div class="form-group">
                                        <label class="form-label">Bulan</label>
                                        <div class="form-control-wrap">
                                            <select class="form-select js-select2" id="bulan" name="bulan">
                                                <option value="">Semua Bulan</option>
                                                @foreach ($bulanList as $key => $bulan)
                                                <option value="{{ $key }}" {{ request('bulan') == $key ? 'selected' : '' }}>
                                                    {{ $bulan }}
                                                </option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>
                                </div>
                                <div class="col-md-3">
                                    <div class="form-group">
                                        <label class="form-label">Tahun</label>
                                        <div class="form-control-wrap">
                                            <select class="form-select js-select2" id="tahun" name="tahun">
                                                @foreach ($tahunList as $tahun)
                                                <option value="{{ $tahun }}" {{ (request()->has('tahun') ? request('tahun') : ($tahunAktif ?? date('Y'))) == $tahun ? 'selected' : '' }}>
                                                    {{ $tahun }}
                                                </option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>
                                </div>
                                <div class="col-md-2">
                                    <div class="form-group">
                                        <button type="submit" class="btn btn-primary w-100"><em class="icon ni ni-search me-1"></em> Tampilkan</button>
                                    </div>
                                </div>
                            </div>
                        </form>
                    </div>
                </div>

                @if ($transaksi->isNotEmpty())
                <div class="card card-preview">
                    <div class="card-inner border-bottom">
                        <div class="card-title-group">
                            <div class="card-title">
                                <h5 class="title">Buku Besar: {{ $akun->kode_akun }} - {{ $akun->nama_akun }}</h5>
                            </div>
                            <div class="card-tools">
                                <div class="drodown">
                                    <a href="#" class="dropdown-toggle btn btn-white btn-dim btn-outline-light" data-bs-toggle="dropdown"><em class="icon ni ni-download-cloud"></em><span>Export</span></a>
                                    <div class="dropdown-menu dropdown-menu-end">
                                        <ul class="link-list-opt no-bdr">
                                            <li><a href="{{ route('yayasan.laporan.buku-besar.cetak', array_merge(request()->all(), ['format' => 'pdf'])) }}" target="_blank"><span>PDF</span></a></li>
                                            <li><a href="{{ route('yayasan.laporan.buku-besar.cetak', array_merge(request()->all(), ['format' => 'excel'])) }}" target="_blank"><span>Excel</span></a></li>
                                        </ul>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="table-responsive">
                        <table class="table table-custom">
                            <thead>
                                <tr>
                                    <th>Tanggal</th>
                                    <th>No Ref</th>
                                    <th>Keterangan</th>
                                    <th class="text-end">Debit</th>
                                    <th class="text-end">Kredit</th>
                                    <th class="text-end">Saldo</th>
                                </tr>
                            </thead>
                            <tbody>
                                @php 
                                    $saldo = $saldoAwal ?? 0; 
                                @endphp
                                @if(request('bulan'))
                                <tr class="table-light fw-bold">
                                    <td colspan="5">Saldo Awal Bulan</td>
                                    <td class="text-end">
                                        {{ formatRp($saldo) }}
                                    </td>
                                </tr>
                                @endif
                                @foreach ($transaksi as $t)
                                @php
                                $saldo += $t->debit - $t->kredit;
                                @endphp
                                <tr>
                                    <td>{{ \Carbon\Carbon::parse($t->tanggal ?? $t->created_at)->format('d-m-Y') }}</td>
                                    <td><span class="badge badge-dim bg-outline-primary">{{ $t->no_referensi }}</span></td>
                                    <td>{{ $t->deskripsi_item ?? $t->deskripsi }}</td>
                                    <td class="text-end">
                                        {{ formatRp($t->debit) }}
                                    </td>
                                    <td class="text-end">
                                        {{ formatRp($t->kredit) }}
                                    </td>
                                    <td class="text-end fw-bold">
                                        {{ formatRp($saldo) }}
                                    </td>
                                </tr>
                                @endforeach
                            </tbody>
                        </table>
                    </div>
                </div>
                @else
                <div class="alert alert-warning">
                    <div class="alert-icon"><em class="icon ni ni-alert-circle"></em></div>
                    Tidak ada data transaksi untuk filter yang dipilih.
                </div>
                @endif
            </div>
        </div>
    </div>
</div>
@endsection

@push('scripts')
<script>
    $(document).ready(function() {
        $('.select-akun').select2({
            placeholder: "Pilih Akun",
            allowClear: true,
            width: '100%'
        });
    });
</script>
@endpush