@php
$no = 1;
if(!$view || $detail == '0'){
$grand_prev_balance = 0;
$grand_debit = 0;
$grand_credit = 0;
$grand_outstanding = 0;
}
else{
$grand_prev_balance = 0;
$grand_debit = 0;
$grand_credit = 0;
$grand_ending_balance = 0;
}
$grand_days30 = 0;
$grand_days60 = 0;
$grand_days90 = 0;
$grand_over = 0;
@endphp
@if(count($aging_lists) > 0)
@if(!$view || $detail == '0')
@foreach($aging_lists as $header => $details)
@php
$no = 1;
//Jika Dari AR Aging With Detail Summary
if($detail == '0'){
$total_prev_balance = 0;
$total_debit = 0;
$total_credit = 0;
}
$total_outstanding = 0;
$total_days30 = 0;
$total_days60 = 0;
$total_days90 = 0;
$total_over90days = 0;
@endphp
| {{$header}} |
@foreach($details as $key => $aging_list)
@php
//Menghitung Breakdown Dari AR Aging Detail
if($detail == '0'){ //Jika Dari AR Aging with Previous Balance
$prev_balance = array_sum($aging_list['prev_balance']);
$debit = array_sum($aging_list['debit']);
$credit = array_sum($aging_list['credit']);
}
$outstanding = array_sum($aging_list['outstanding']);
$days30 = array_sum($aging_list['30days']);
$days60 = array_sum($aging_list['60days']);
$days90 = array_sum($aging_list['90days']);
$over90days = array_sum($aging_list['over90days']);
//Menghitung Total Dari Record per group
if($detail == '0'){ //Jika Dari Ar Aging With previous Balance
$total_prev_balance += $prev_balance;
$total_debit += $debit;
$total_credit += $credit;
}
$total_outstanding += $outstanding;
$total_days30 += $days30;
$total_days60 += $days60;
$total_days90 += $days90;
$total_over90days += $over90days;
//Menghitung total keseluruhan
if($detail == '0'){ //Jika dari AR Aging With Previous Balance
$grand_prev_balance += $prev_balance;
$grand_debit += $debit;
$grand_credit += $credit;
}
$grand_outstanding += $outstanding;
$grand_days30 += $days30;
$grand_days60 += $days60;
$grand_days90 += $days90;
$grand_over += $over90days;
@endphp
| {{$no}} |
{{$key}} |
@if($detail == '0')
{!! $prev_balance !!} |
{!! $debit !!} |
{!! $credit !!} |
@endif
{!! $outstanding !!} |
{!! $days30 !!} |
{!! $days60 !!} |
{!! $days90 !!} |
{!! $over90days !!} |
@php
$no++;
@endphp
@endforeach
|
Total: |
@if($detail == '0')
{!! $total_prev_balance !!} |
{!! $total_debit !!} |
{!! $total_credit !!} |
@endif
{!! $total_outstanding !!} |
{!! $total_days30 !!} |
{!! $total_days60 !!} |
{!! $total_days90 !!} |
{!! $total_over90days !!} |
|
Statistic Percentage (%): |
@if($detail == '0')
|
|
|
@endif
{{100}} |
{{$total_days30 == 0 ? 0 : ($total_days30/$total_outstanding) * 100}} |
{{$total_days60 == 0 ? 0 : ($total_days60/$total_outstanding) * 100}} |
{{$total_days90 == 0 ? 0 : ($total_days90/$total_outstanding) * 100}} |
{{$total_over90days == 0 ? 0 : ($total_over90days/$outstanding) * 100}} |
@endforeach
@else
@foreach($aging_lists as $key => $details)
@php
$no = 1;
if($view){
$total_prev_balance = 0;
$total_debit = 0;
$total_credit = 0;
}
$total_ending_balance = 0;
$total_days30 = 0;
$total_days60 = 0;
$total_days90 = 0;
$total_over90days = 0;
@endphp
| {{$key}} |
@foreach($details as $aging_list)
@php
if($view == 'withpreviousbalance'){
$prev_balance = $aging_list['prev_balance'];
$debit = $aging_list['debit'];
$credit = $aging_list['credit'];
}
$ending_balance = $aging_list['ending_balance'];
$days30 = $aging_list['30days'];
$days60 = $aging_list['60days'];
$days90 = $aging_list['90days'];
$over90days = $aging_list['over90days'];
if($view == 'withpreviousbalance'){
$total_prev_balance += $prev_balance;
$total_debit += $debit;
$total_credit += $credit;
}
$total_ending_balance += $ending_balance;
$total_days30 += $days30;
$total_days60 += $days60;
$total_days90 += $days90;
$total_over90days += $over90days;
if($view == 'withpreviousbalance'){
$grand_prev_balance += $prev_balance;
$grand_debit += $debit;
$grand_credit += $credit;
}
$grand_ending_balance += $ending_balance;
$grand_days30 += $days30;
$grand_days60 += $days60;
$grand_days90 += $days90;
$grand_over += $over90days;
@endphp
| {{ $no }} |
{{ $aging_list['customer_name'] }} |
{{ $aging_list['bill_date'] }} |
{{ $aging_list['bill_no'] }}
{{--
{{ $aging_list['id_bill'] }}
--}}
|
@if($view == 'withpreviousbalance')
{!! $prev_balance !!} |
{!! $debit !!} |
{!! $credit !!} |
@endif
{!! $ending_balance !!} |
{!! $days30 !!} |
{!! $days60 !!} |
{!! $days90 !!} |
{!! $over90days !!} |
@php
$no++;
@endphp
@endforeach
|
Total: |
@if($view == 'withpreviousbalance')
{!! $total_prev_balance !!} |
{!! $total_debit !!} |
{!! $total_credit !!} |
@endif
{!! $total_ending_balance !!} |
{!! $total_days30 !!} |
{!! $total_days60 !!} |
{!! $total_days90 !!} |
{!! $total_over90days !!} |
|
Statistic Percentage (%): |
@if($view == 'withpreviousbalance')
|
|
|
@endif
{{100}} |
{{$total_days30 == 0 ? 0 : ($total_days30/$total_ending_balance) * 100}} |
{{$total_days60 == 0 ? 0 : ($total_days60/$total_ending_balance) * 100}} |
{{$total_days90 == 0 ? 0 : ($total_days90/$total_ending_balance) * 100}} |
{{$total_over90days == 0 ? 0 : ($total_over90days/$total_ending_balance) * 100}} |
@endforeach
@endif
|
@if(!$view || $detail == '0')
Grand Total |
@if($detail == '0')
|
|
|
@endif
{!! $grand_outstanding !!} |
@php
$grandtotal = $grand_outstanding;
@endphp
@else
Grand Total |
@if($view == 'withpreviousbalance')
{!! $grand_prev_balance !!} |
{!! $grand_debit !!} |
{!! $grand_credit !!} |
@endif
{!! $grand_ending_balance !!} |
@php
$grandtotal = $grand_ending_balance;
@endphp
@endif
{!! $grand_days30 !!} |
{!! $grand_days60 !!} |
{!! $grand_days90 !!} |
{!! $grand_over !!} |
|
@if(!$view || $detail == '0')
Grand Total Percentage |
@if($detail == '0')
|
|
|
@endif
{{ 100 }} |
@else
Grand Total Percentage (%) |
@if($view == 'withpreviousbalance')
|
|
|
@endif
{{ 100 }} |
@endif
{{$grand_days30 == 0 ? 0 : ($grand_days30 / $grandtotal) * 100}} |
{{$grand_days60 == 0 ? 0 : ($grand_days60 / $grandtotal) * 100}} |
{{$grand_days90 == 0 ? 0 : ($grand_days90 / $grandtotal) * 100}} |
{{$grand_over == 0 ? 0 : ($grand_over / $grandtotal) * 100}} |
@else
@if($view == 'withpreviousbalance')
| Data not available |
@else
| Data not available |
@endif
@endif