@php
$sectionNo = 1;
$levelOneLedgers = $ledgers->where('level',1);
@endphp
@foreach ($levelOneLedgers as $levelOneLedger)
| {{$levelOneLedger->name.'['.$levelOneLedger->code.']'}} |
|
|
@php
$levelTwoLedgers = $ledgers->where('level',2)->where('parentId',$levelOneLedger->id);
@endphp
@foreach ($levelTwoLedgers as $levelTwoLedger)
| 2{{str_repeat(' ', 2*2).$levelTwoLedger->name.'['.$levelTwoLedger->code.']'}} |
|
{{number_format($cfyR->where('ledgerId',$levelTwoLedger->id)->sum('balance'),2)}} |
@php
$levelThreeLedgers = $ledgers->where('level',3)->where('parentId',$levelTwoLedger->id);
@endphp
@foreach ($levelThreeLedgers as $levelThreeLedger)
| 3{{str_repeat(' ', 3*2).$levelThreeLedger->name.'['.$levelThreeLedger->code.']'}} |
|
{{number_format($cfyR->where('ledgerId',$levelThreeLedger->id)->sum('balance'),2)}} |
@php
$levelFourLedgers = $ledgers->where('level',4)->where('parentId',$levelThreeLedger->id);
@endphp
@foreach ($levelFourLedgers as $levelFourLedger)
| 4{{str_repeat(' ', 4*2).$levelFourLedger->name.'['.$levelFourLedger->code.']'}} |
|
{{number_format($cfyR->where('ledgerId',$levelFourLedger->id)->sum('balance'),2)}} |
@php
$levelFiveLedgers = $ledgers->where('level',5)->where('parentId',$levelFourLedger->id);
@endphp
@foreach ($levelFiveLedgers as $levelFiveLedger)
| 5{{str_repeat(' ', 5*2).$levelFiveLedger->name.'['.$levelFiveLedger->code.']'}} |
|
{{number_format($cfyR->where('ledgerId',$levelFiveLedger->id)->sum('balance'),2)}} |
@endforeach{{-- level 5 --}}
@endforeach{{-- level 4 --}}
@endforeach{{-- level 3 --}}
@endforeach{{-- level 2 --}}
@if ($sectionNo==1)
| TOTAL INCOME |
@elseif($sectionNo==2)
TOTAL EXPENSE |
@endif
|
{{number_format($cfyR->where('ledgerId',$levelOneLedger->id)->sum('balance'),2)}} |
@php
$sectionNo++;
@endphp
@endforeach{{-- level 1 --}}