File Aged Report

Shows assignments open for at least this many days (excludes Completed, Closed, Cancelled, and Supplement statuses)
@forelse($report_data as $index => $data) statusdDays() <= 12 && $data->statusdDays() != null) style="background-color: lightgreen;" @endif @if ($data->statusdDays() > 3 && $data->statusdDays() <= 7) style="background-color: lightyellow;" @endif > @empty @endforelse
S.No File Office Insurance Adjuster Appraiser Date Open Status'd Stage Phase
{{ $report_data->firstItem() + $index }} {{ $data->file_no }} {{ $data->franchise->company_name ?? '' }} {{ $data->insurancecompany->company_name ?? '' }} {{ $data->adjuster->name ?? '' }} {{ $data->appraiser->name ?? '' }} {{ date('m-d-Y H:i:s' ,strtotime($data->created_date)) }} @php $statusMessage = $data->messages()->where('subject', 'like', '%Status Update%')->orderBy('id', 'desc')->first(); echo $statusMessage ? date('m-d-Y H:i:s', strtotime($statusMessage->created_at)) : ''; @endphp {{ $data->status->status ?? '' }} {{ $data->phase->phase ?? '' }}
No data found.
{{ $report_data->links() }}