| ASSET |
| Opening Balance |
|
@foreach ($openingBalanceColumns as $openingBalanceColumn)
{{ customNumnerFormat($openingBalanceColumn['openingBalance'], $decimal) }} |
@endforeach
@if ($numberOfColumn == 3)
|
@endif
| Cash |
|
@foreach ($openingBalanceColumns as $openingBalanceColumn)
{{ customNumnerFormat($openingBalanceColumn['cashOpeningBalance'], $decimal) }} |
@endforeach
@if ($numberOfColumn == 3)
|
@endif
| Bank |
|
@foreach ($openingBalanceColumns as $openingBalanceColumn)
{{ customNumnerFormat($openingBalanceColumn['bankOpeningBalance'], $decimal) }} |
@endforeach
@if ($numberOfColumn == 3)
|
@endif
{{-- Receipt --}}
| Receipt |
@foreach ($ledgerTree as $ledger)
@php
if ((!$withZero && $ledger->receipt_column_0 == 0 && @$ledger->receipt_column_1 == 0 && @$ledger->receipt_column_2 == 0) || ($depthLevel > 0 && $ledger->level > $depthLevel)) {
continue;
}
@endphp
|
{{ $ledger->name . ' [' . $ledger->code . ']' }} |
|
{{ customNumnerFormat($ledger->receipt_column_0, $decimal) }} |
@if ($numberOfColumn > 1)
{{ customNumnerFormat($ledger->receipt_column_1, $decimal) }} |
@endif
@if ($numberOfColumn > 2)
{{ customNumnerFormat($ledger->receipt_column_2, $decimal) }} |
@endif
@endforeach
| Total Receipt |
|
{{ customNumnerFormat($ledgerTree->where('level', 1)->sum('receipt_column_0'), $decimal) }} |
@if ($numberOfColumn > 1)
{{ customNumnerFormat($ledgerTree->where('level', 1)->sum('receipt_column_1'), $decimal) }} |
@endif
@if ($numberOfColumn > 2)
{{ customNumnerFormat($ledgerTree->where('level', 1)->sum('receipt_column_2'), $decimal) }} |
@endif
| Total |
|
{{ customNumnerFormat($ledgerTree->where('level', 1)->sum('receipt_column_0') + $openingBalanceColumns[0]['openingBalance'], $decimal) }}
|
@if ($numberOfColumn > 1)
{{ customNumnerFormat($ledgerTree->where('level', 1)->sum('receipt_column_1') + $openingBalanceColumns[1]['openingBalance'], $decimal) }}
|
@endif
@if ($numberOfColumn > 2)
{{ customNumnerFormat($ledgerTree->where('level', 1)->sum('receipt_column_2'), $decimal) }}
|
@endif
{{-- Payment --}}
| Payment |
@foreach ($ledgerTree as $ledger)
@php
if ((!$withZero && $ledger->payment_column_0 == 0 && @$ledger->payment_column_1 == 0 && @$ledger->payment_column_2 == 0) || ($depthLevel > 0 && $ledger->level > $depthLevel)) {
continue;
}
@endphp
|
{{ $ledger->name . ' [' . $ledger->code . ']' }} |
|
{{ customNumnerFormat($ledger->payment_column_0, $decimal) }} |
@if ($numberOfColumn > 1)
{{ customNumnerFormat($ledger->payment_column_1, $decimal) }} |
@endif
@if ($numberOfColumn > 2)
{{ customNumnerFormat($ledger->payment_column_2, $decimal) }} |
@endif
@endforeach
| Total Payment |
|
{{ customNumnerFormat($ledgerTree->where('level', 1)->sum('payment_column_0'), $decimal) }} |
@if ($numberOfColumn > 1)
{{ customNumnerFormat($ledgerTree->where('level', 1)->sum('payment_column_1'), $decimal) }} |
@endif
@if ($numberOfColumn > 2)
{{ customNumnerFormat($ledgerTree->where('level', 1)->sum('payment_column_2'), $decimal) }} |
@endif
| ASSET |
| Closing Balance |
|
{{ customNumnerFormat($closingBalanceColumns[0]['total'], $decimal) }} |
@if ($numberOfColumn > 1)
{{ customNumnerFormat($closingBalanceColumns[1]['total'], $decimal) }} |
@endif
@if ($numberOfColumn > 2)
{{ customNumnerFormat($closingBalanceColumns[2]['total'], $decimal) }} |
@endif
| CASH IN HAND |
|
{{ customNumnerFormat($closingBalanceColumns[0]['cash'], $decimal) }} |
@if ($numberOfColumn > 1)
{{ customNumnerFormat($closingBalanceColumns[1]['cash'], $decimal) }} |
@endif
@if ($numberOfColumn > 2)
{{ customNumnerFormat($closingBalanceColumns[2]['cash'], $decimal) }} |
@endif
| CASH AT BANK |
|
{{ customNumnerFormat($closingBalanceColumns[0]['bank'], $decimal) }} |
@if ($numberOfColumn > 1)
{{ customNumnerFormat($closingBalanceColumns[1]['bank'], $decimal) }} |
@endif
@if ($numberOfColumn > 2)
{{ customNumnerFormat($closingBalanceColumns[2]['bank'], $decimal) }} |
@endif
| Total |
|
{{ customNumnerFormat($ledgerTree->where('level', 1)->sum('payment_column_0') + $closingBalanceColumns[0]['total'], $decimal) }}
|
@if ($numberOfColumn > 1)
{{ customNumnerFormat($ledgerTree->where('level', 1)->sum('payment_column_1') + $closingBalanceColumns[1]['total'], $decimal) }}
|
@endif
@if ($numberOfColumn > 2)
{{ customNumnerFormat($ledgerTree->where('level', 1)->sum('payment_column_2') + $closingBalanceColumns[2]['total'], $decimal) }}
|
@endif