Needs Status Report

@if (session()->has('message'))

@endif

About This Report

What data is displayed:

This report shows active assignment files that need attention. Specifically, it displays files that:

Are active (not cancelled, closed, completed, files submitted, or passed audit)
Have no recent communication - either no messages at all, or the last message was more than the selected hours threshold ago (default: 24 hours)

How the filters work:

From Date / To Date: Filter files by the date range when they were created. Leave blank to see all dates.
Offices: Select one or more offices to view files from specific locations. Leave blank to see all offices (based on your access level).
Hours Threshold: Select how many hours (24, 48, 72, or 96) must pass without messages or updates for a file to appear in this report.
Clear Filters: Click to reset all filters and view the default data set.

What this data is for:

This report helps identify files that may need follow-up or status updates. Files appearing here have not had recent communication within the selected hours threshold (default: 24 hours) and are still active, making them candidates for review, status updates, or client communication. You can add notes directly to any file by clicking in the Notes column.

Filters

From Date

To Date

Offices

Hours Threshold

Records per page:

@forelse($assignments as $assignment) @empty @endforelse

File Number @if($sortBy === 'a.file_no') @endif	Claim Number @if($sortBy === 'a.claim_number') @endif	Insurance Company Name @if($sortBy === 'ic.company_name') @endif	Date File Was Created @if($sortBy === 'a.created_date') @endif	Office Working File @if($sortBy === 'f.company_name') @endif	Current Stage @if($sortBy === 'gs.status') @endif	Last Status/Message	Appraiser Name @if($sortBy === 'u.name') @endif	Notes
{{ $assignment->file_no }}	{{ $assignment->claim_number ?? '' }}	{{ $assignment->insurance_company_name ?? '' }}	{{ $assignment->created_date ? \Carbon\Carbon::parse($assignment->created_date)->format('m/d/Y') : '' }}	{{ $assignment->office_name ?? '' }}	{{ $assignment->current_stage ?? '' }}	@if(isset($assignment->last_message)) {{ $assignment->last_message->subject ?? 'No Subject' }} {{ Str::limit($assignment->last_message->message ?? '', 100) }} {{ \Carbon\Carbon::parse($assignment->last_message->created_at)->format('m/d/Y H:i') }} @else No messages or activity @endif	{{ $assignment->appraiser_name ?? '' }}	@if($editingNoteId == $assignment->id) @else {{ $assignment->assignment_notepad ? Str::limit($assignment->assignment_notepad, 50) : 'Click to add notes...' }} @endif
No data found.