Critical Operations Red Flags Report

Generated on {{ now()->format('Y-m-d H:i') }}

Overdue Audits
{{ $overdueAudits->count() }}
SLA Breached
{{ $slaBreachedSRs->count() }}
Stockouts
{{ $stockoutSRs->count() }}
Unvisited
{{ $unvisitedOutlets->count() }}
High Priority
{{ $pendingHighPrioritySRs->count() }}
{{-- Overdue Audits --}}

1. Overdue POSM Audits

@forelse($overdueAudits as $audit) @empty @endforelse
Outlet Assigned TM Due Date Days Overdue
{{ $audit->outlet->name ?? 'Unknown' }} {{ $audit->tm->name ?? 'Unassigned' }} {{ optional($audit->due_date)->format('Y-m-d') }} {{ optional($audit->due_date)->diffInDays(now()) }} Days
No overdue audits.
{{-- SLA Breached --}}

2. SLA Breached Service Requests

@forelse($slaBreachedSRs as $sr) @empty @endforelse
SR # Title Outlet SLA Due Breach
#{{ $sr->sr_number ?? $sr->id }} {{ $sr->title }} {{ $sr->outlet->name ?? '-' }} {{ optional($sr->sla_due_date)->format('Y-m-d H:i') }} {{ optional($sr->sla_due_date)->diffForHumans() }}
No SLA breaches.
{{-- Stockouts --}}

3. Must Have Base Stockouts

@forelse($stockoutSRs as $sr) @empty @endforelse
Outlet Brand / Item Reported By Reported At Status
{{ $sr->outlet->name ?? '-' }} {{ $sr->title }} {{ $sr->creator->name ?? 'System' }} {{ $sr->created_at->format('Y-m-d H:i') }} {{ ucfirst($sr->status) }}
No stockouts reported.
{{-- Unvisited --}}

4. Unvisited Outlets (> 30 Days)

@forelse($unvisitedOutlets as $outlet) @empty @endforelse
Outlet Name Territory Assigned LSR Last Visit
{{ $outlet->name }} {{ $outlet->territory->name ?? '-' }} {{ $outlet->lsr->name ?? 'Unassigned' }} @php $lastVisit = $outlet->visits()->latest('check_in_time')->first(); @endphp {{ $lastVisit ? $lastVisit->check_in_time->format('Y-m-d') : 'Never' }}
No unvisited outlets.
{{-- High Priority --}}

5. Pending High Priority Requests

@forelse($pendingHighPrioritySRs as $sr) @empty @endforelse
SR # Title Status Assigned To SLA Due
#{{ $sr->sr_number ?? $sr->id }} {{ $sr->title }} {{ ucfirst($sr->status) }} {{ $sr->assignee->name ?? 'Unassigned' }} {{ optional($sr->sla_due_date)->format('Y-m-d H:i') }}
No high priority requests.
Generated on {{ now()->format('Y-m-d H:i:s') }}