@if ($lastMonthBalance || auth()->activeBook()->bank_account_id) @endif @if (auth()->activeBook()->bank_account_id) @endif @if ($lastMonthBalance) @endif @php $key = 0; @endphp @foreach($incomeCategories->sortBy('id')->values() as $key => $incomeCategory) @endforeach @if ($groupedTransactions->has(1)) @foreach($groupedTransactions[1]->where('category_id', null) as $transaction) @endforeach @endif @foreach($spendingCategories->sortBy('id')->values() as $key => $spendingCategory) @endforeach @if ($groupedTransactions->has(0)) @foreach($groupedTransactions[0]->where('category_id', null) as $transaction) @endforeach @endif @if (!$groupedTransactions->isEmpty()) @if (auth()->activeBook()->bank_account_id) @else @endif @endif

{{ __('app.table_no') }}	{{ __('transaction.transaction') }}	{{ __('transaction.income') }}	{{ __('transaction.spending') }}	{{ __('transaction.balance') }}
{{ __('transaction.balance') }}
1	Saldo per {{ Carbon\Carbon::parse($lastBankAccountBalanceOfTheMonth->date)->isoFormat('D MMMM Y') }} di BANK	-	-	{{ format_number($lastBankAccountBalanceOfTheMonth->amount) }}
{{ auth()->activeBook()->bank_account_id ? '2' : '1' }}	Sisa saldo per {{ $lastMonthDate->isoFormat('D MMMM Y') }}			{{ format_number($lastMonthBalance) }}
{{ __('transaction.income') }}
{{ ++$key }}	{{ $incomeCategory->name }}	@if ($groupedTransactions->has(1)) {{ format_number($groupedTransactions[1]->where('category_id', $incomeCategory->id)->sum('amount')) }} @else 0 @endif	-
{{ ++$key }}	{!! $transaction->date_alert !!} {!! nl2br(htmlentities($transaction->description)) !!}	{{ format_number($transaction->amount) }}	-
{{ __('transaction.spending') }}
{{ ++$key }}	{{ $spendingCategory->name }}	-	@if ($groupedTransactions->has(0)) {{ format_number($groupedTransactions[0]->where('category_id', $spendingCategory->id)->sum('amount')) }} @else 0 @endif
{{ ++$key }}	{!! $transaction->date_alert !!} {!! nl2br(htmlentities($transaction->description)) !!}	-	{{ format_number($transaction->amount) }}
	{{ __('transaction.in_out') }} hingga {{ $currentMonthEndDate->isoFormat('D MMMM Y') }}	@php $currentMonthIncome = $groupedTransactions->has(1) ? $groupedTransactions[1]->sum('amount') : 0; @endphp {{ format_number($currentMonthIncome) }}	@php $currentMonthSpending = $groupedTransactions->has(0) ? $groupedTransactions[0]->sum('amount') : 0; @endphp {{ format_number($currentMonthSpending) }}	@php $currentMonthBalance = $currentMonthIncome - $currentMonthSpending; @endphp {{ format_number($currentMonthBalance) }}
	Saldo Kas hingga per {{ $currentMonthEndDate->isoFormat('D MMMM Y') }}			@php $currentMonthBalance = $lastMonthBalance + $currentMonthIncome - $currentMonthSpending; @endphp {{ format_number($currentMonthBalance) }}
	Saldo Kas + Saldo bank per {{ $currentMonthEndDate->isoFormat('D MMMM Y') }}			{{ format_number($currentMonthBalance + $lastBankAccountBalanceOfTheMonth->amount) }}
	Total saldo akhir per {{ $currentMonthEndDate->isoFormat('D MMMM Y') }}			@php $currentMonthBalance = $lastMonthBalance + $currentMonthIncome - $currentMonthSpending; @endphp {{ format_number($currentMonthBalance) }}