@foreach($reportData as $rindex => $data)
|
{{ json_decode($data->contact_info)[0]->business_display_name }}
|
@foreach(json_decode($data->sales_info) as $infIndex => $sales)
| {{ $sales->invoice_and_statement_number }} |
{{ App\Http\Classes\Formatting\CustomDateFormat::displayDate($sales->recorded_date) }} |
{{ App\Http\Classes\Formatting\CustomDateFormat::displayDate($sales->due_date) }} |
@foreach($periods as $index => $period)
@php
$colName = 'total_collections_remaining_' . $index;
$remainings = $sales->$colName ?? 0;
@endphp
{{ App\Http\Classes\Formatting\CustomNumFormat::decimal($remainings) }}
|
@endforeach
@php
$sale_totals = [];
foreach($periods as $index => $period) {
$colName = 'total_collections_remaining_' . $index;
array_push($sale_totals, json_decode($data->sales_info)[$infIndex]->$colName);
}
@endphp
{{ App\Http\Classes\Formatting\CustomNumFormat::decimal(array_sum($sale_totals)) }} |
@endforeach
|
Totals for {{ json_decode($data->contact_info)[0]->business_display_name }}
|
@foreach($periods as $index => $period)
{{ collect(json_decode($data->sales_info))->sum('total_collections_remaining_' . $index) }}
|
@endforeach
@php
foreach($periods as $index => $period) {
$subTotals[$index] = collect(json_decode($data->sales_info))->sum('total_collections_remaining_' . $index);
}
@endphp
{{ App\Http\Classes\Formatting\CustomNumFormat::decimal(array_sum($subTotals)) }}
|
@endforeach
| Grand Total |
@foreach($periods as $index => $period)
@php
$periodTotals = collect($reportData)->pluck('sales_info')->map(function ($sales) use($index) {
return collect(json_decode($sales))->sum('total_collections_remaining_' . $index);
})->toArray();
$totals[] = array_sum($periodTotals);
@endphp
{{ App\Http\Classes\Formatting\CustomNumFormat::decimal(array_sum($periodTotals)) }}
|
@endforeach
{{ App\Http\Classes\Formatting\CustomNumFormat::decimal(array_sum($totals)) }}
|
| Totals Percentage |
@foreach($periods as $index => $period)
@php
$grandTotal = array_sum($totals);
$periodTotals = collect($reportData)->pluck('sales_info')->map(function ($sales) use($index) {
return collect(json_decode($sales))->sum('total_collections_remaining_' . $index);
})->toArray();
$percentage = App\Http\Classes\Formatting\CustomNumFormat::decimal(array_sum($periodTotals) / $grandTotal * 100, 2);
@endphp
@if(count($reportData))
{{ $percentage . '%' }}
@else
0%
@endif
|
@endforeach
100%
|