@php use App\Models\AccRekening; use App\Models\FinanceLedgerPG; $data_rekening = AccRekening::orderBy('kode_rekening', 'ASC')->get(); @endphp Laporan Komisi Marketing @foreach ($data_rekening as $rekening) @php $total_saldo = 0; $total_debit = 0; $total_kredit = 0; $saldo_awal = 0; $data_ledger = FinanceLedgerPG::where('trx_account_id', $rekening->id_acc_rekening) ->whereMonth('trx_date', 1) ->whereYear('trx_date', 2025) ->orderBy('trx_date', 'ASC') ->orderBy('id_ledger', 'ASC') ->get(); @endphp @foreach ($data_ledger as $transaksi) @php // Tentukan nilai debit dan kredit berdasarkan jenis transaksi $debit = $transaksi->trx_type == 'Debit' ? $transaksi->trx_amount : 0; $kredit = $transaksi->trx_type == 'Kredit' ? $transaksi->trx_amount : 0; // Hitung saldo akhir $saldo_akhir = $saldo_awal += $debit - $kredit; $total_saldo = $saldo_akhir; // Hitung total debit dan kredit $total_debit += $debit; $total_kredit += $kredit; @endphp @endforeach @endforeach

ACCOUNT : {{ $rekening->id_acc_rekening }} {{ $rekening->kode_rekening }} - {{ $rekening->nama_rekening }}
No. Date Notes Debit Kredit Balance
{{ $loop->iteration }} {{ acc_date($transaksi->trx_date) }} {{ $transaksi->trx_description }} from {{ $transaksi->trx_menu }} {{ number($debit != 0 ? $debit : '') }} {{ number($kredit != 0 ? $kredit : '') }} {{ number($saldo_akhir) }}