@lang('accounting/reports/accounts/outlays-analysis.expense_analysis_year') {{ $current_year?->parseDateToCarbon('from')->year }}
@php
$table_options = [
'lang' => ['noAvailableData' =>__('noAvailableData.no_expenses_yet')],
'enableSumValuesOnColumns' => [2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14],
];
$monthly_totals = array_fill(1, 12, 0);
@endphp
| # |
@lang('accounting/reports/accounts/outlays-analysis.account') |
@for ($i = 1; $i <= 12; $i++)
@lang('accounting/reports/accounts/outlays-analysis.month') {{ $i }} |
@endfor
@lang('accounting/reports/accounts/outlays-analysis.total') |
@foreach ($accounts as $account)
| {{ $loop->iteration }} |
{{ $account->name }} |
@php
$months_balances = $account->statement_items->groupBy(fn($item) => $item->parseDateToCarbon('date')->month)->all();
$balance = 0;
@endphp
@for ($i = 1; $i <= 12; $i++)
@if (array_key_exists($i, $months_balances))
{{ dn($months_balances[$i]->sum('amount')) }}
@php
$monthly_totals[$i] += $months_balances[$i]->sum('amount');
$balance += $months_balances[$i]->sum('amount');
@endphp
@else
{{ dn('0.000') }}
@endif
|
@endfor
{{ dn($balance) }}
|
@endforeach
| @lang('accounting/reports/accounts/outlays-analysis.total') |
@for ($i = 1; $i <= 12; $i++)
{{ dn($monthly_totals[$i]) }} |
@endfor
{{ dn(array_sum($monthly_totals)) }} |