@php
$monthlyTotals = array_fill(1, 12, 0);
$gtotal = 0;
@endphp
@php
$startdate = request('start_date') ?: date('Y-m-01');
$monthYear = (new DateTime($startdate))->format('Y');
@endphp
{{ 'Account Receiveable Report' }} ({{ request('year') ? request('year') : $monthYear }})
{{ getAuthCompanyName() }}
{{ getAuthCarrierInfo()->BILL_TO }}
|
{{ date('m/d/Y h:i A') }}
|
30 Days: ${{ number_format($sum30,2) }}
60 Days: ${{ number_format($sum60,2) }}
90+ Days: ${{ number_format($sum90,2) }}
|
Total Amount : ${{$expenseQueryTotalAmount}}
|
|
VENDOR
|
DUE DATE
|
AMOUNT
|
@foreach($data as $index => $row)
@php
$date = \Carbon\Carbon::parse($row->TX_DUE);
$daysAgo = $date->diffInDays(now());
$bg = $index % 2 == 0 ? '#ffffff' : '#dddddd ';
@endphp
|
{{!empty($vendors[$row->VENDOR_ID]) ? strtoupper($vendors[$row->VENDOR_ID]) : '' }}
|
@if(!empty($row->TX_DUE))
@php
$date = \Carbon\Carbon::parse($row->TX_DUE);
$daysAgo = $date->diffInDays(now());
@endphp
{{ convertToMdy($date) }}
({{ $daysAgo }} days ago)
@endif
|
${{ number_format($row->ORIG_AMT,2) }}
|
@endforeach