@php
$grand_total_debit = 0;
$grand_total_credit = 0;
$allData = $data;
foreach($data as $groupKey => $groupData){
$group_total_debit =0;
$group_total_credit = 0;
foreach($groupData["accounts"] as $key => $account){
$total_debit = 0;
$total_credit = 0;
$total_balance = 0;
if(count($account["ledgers"])>1){
foreach ($account["ledgers"] as $ledgersKey => $ledgers){
$total_debit = $total_debit+(float)$ledgers->debit;
$total_credit = $total_credit+(float)$ledgers->credit;
$total_balance = (float)$ledgers->balance;
}
}
$group_total_debit = $group_total_debit+(float)$total_debit;
$group_total_credit = $group_total_credit+(float)$total_credit;
$data[$groupKey]["group_total_debit"] = $group_total_debit;
$data[$groupKey]["group_total_credit"] = $group_total_credit;
}
}
@endphp
@foreach($data as $groupKey => $groupData)
@if(count($groupData["accounts"])>1)
@if($data[$groupKey]["group_total_debit"] > 0 || $data[$groupKey]["group_total_credit"] > 0)
| {{ $groupData["groupname"] }} |
@else
| {{ $groupData["groupname"] }} |
@endif
@php
$group_total_debit = 0;
$group_total_credit = 0;
@endphp
@foreach($groupData["accounts"] as $key => $account)
@if(count($account["ledgers"])>1)
| {{ $account["accounttitle"] }} |
Debit |
Credit |
Balance |
@else
| {{ $account["accounttitle"] }} |
{{ number_format($account["ledgers"][0]->balance,2) }} |
@endif
@php
$total_debit = 0;
$total_credit = 0;
$total_balance = 0;
@endphp
@if(count($account["ledgers"])>1)
| Opening Balance |
{{ number_format($account["ledgers"][0]->balance,2) }} |
@foreach ($account["ledgers"] as $ledgersKey => $ledgers)
@php
$start_date = $_GET['start_date'];
if($ledgers->voucher_date > $start_date){
$total_debit = $total_debit+(float)$ledgers->debit;
$total_credit = $total_credit+(float)$ledgers->credit;
}
$total_balance = (float)$ledgers->balance;
@endphp
@if($ledgersKey>0)
| {{ $ledgers->voucher_number }} |
{{ $ledgers->voucher_date }} |
{{ $ledgers->detail_remarks }} |
{{ number_format($ledgers->debit,2) == 0 ? '-' : number_format($ledgers->debit,2) }} |
{{ number_format($ledgers->credit,2) == 0 ? '-' : number_format($ledgers->credit,2) }} |
{{ number_format($ledgers->balance,2) }} |
@endif
@endforeach
@endif
| Total |
@if($total_debit > 0)
{{ number_format($total_debit,2) }} |
@else
- |
@endif
@if($total_credit > 0)
{{ number_format($total_credit,2) }} |
@else
- |
@endif
{{ number_format($total_balance,2) }} |
@php
$group_total_debit = $group_total_debit+(float)$total_debit;
$group_total_credit = $group_total_credit+(float)$total_credit;
@endphp
@endforeach
| Group Total |
{{ number_format($group_total_debit,2) }} |
{{ number_format($group_total_credit,2) }} |
|
@php
$data[$groupKey]["group_total_debit"] = $group_total_debit;
$data[$groupKey]["group_total_credit"] = $group_total_credit;
$grand_total_debit = $grand_total_debit+(float)$group_total_debit;
$grand_total_credit = $grand_total_credit+(float)$group_total_credit;
@endphp
@endif
@endforeach
@php
@endphp
| Grand Total |
{{ number_format($grand_total_debit,2) }} |
{{ number_format($grand_total_credit,2) }} |
|