CREDITOR'S REPORT AS OF {{\Carbon\Carbon::parse($date)->toFormattedDateString()}}

{{--*/ $total_amount = 0 /*--}} {{--*/ $amount_between_0_to_30 = 0 /*--}} {{--*/ $amount_between_31_to_60 = 0 /*--}} {{--*/ $amount_between_61_to_90 = 0 /*--}} {{--*/ $amount_above_90 = 0 /*--}} @foreach($vendors as $index=>$vendor) {{--*/ $total_amount +=$vendor->total_amount /*--}} {{--*/ $amount_between_0_to_30 +=$vendor->amount_between_0_to_30 /*--}} {{--*/ $amount_between_31_to_60 +=$vendor->amount_between_31_to_60 /*--}} {{--*/ $amount_between_61_to_90 +=$vendor->amount_between_61_to_90 /*--}} {{--*/ $amount_above_90 +=$vendor->amount_above_90 /*--}} @endforeach

S/N	Name	0 - 30 Days	31 - 60 Days	61 - 90 Days	90+ Days	Total
{{++$index}}	{{$vendor->name}}	{{number_format($vendor->amount_between_0_to_30)}}	{{number_format($vendor->amount_between_31_to_60)}}	{{number_format($vendor->amount_between_61_to_90)}}	{{number_format($vendor->amount_above_90)}}	{{number_format($vendor->total_amount)}}
TOTAL		{{number_format($amount_between_0_to_30,2)}}	{{number_format($amount_between_31_to_60,2)}}	{{number_format($amount_between_61_to_90,2)}}	{{number_format($amount_above_90,2)}}	{{number_format($total_amount,2)}}