Service Requests Report

Total Requests {{ number_format($totalRequests) }}

Open/Active {{ number_format($openRequests) }}

Resolved {{ number_format($resolvedRequests) }}

SLA Breaches {{ number_format($slaBreachedCount) }}

SLA Compliance {{ $slaComplianceRate }}%

Avg Res. Time {{ $avgResolutionTime }}

Problem Categories Analysis

@foreach($byCategory as $cat) @endforeach

Category Name	Request Count	% of Total
{{ $cat['name'] }}	{{ $cat['count'] }}	{{ $totalRequests > 0 ? round(($cat['count'] / $totalRequests) * 100, 1) : 0 }}%

Recent Service Requests Detail

@foreach($requestsList->take(50) as $sr) @endforeach

ID	Title	Category	Outlet	Priority	Status	Created At
#{{ $sr->id }}	{{ $sr->title }}	{{ $sr->category->name ?? '-' }}	{{ $sr->outlet->name ?? '-' }}	@php $prioClass = 'bg-secondary'; if (strtolower($sr->priority) == 'critical') $prioClass = 'bg-danger'; elseif (strtolower($sr->priority) == 'high') $prioClass = 'bg-warning'; @endphp {{ strtoupper($sr->priority) }}	@php $statusClass = 'bg-primary'; if (in_array($sr->status, ['resolved', 'closed'])) $statusClass = 'bg-success'; elseif ($sr->status == 'cancelled') $statusClass = 'bg-secondary'; @endphp {{ strtoupper(str_replace('_', ' ', $sr->status)) }}	{{ $sr->created_at->format('Y-m-d') }}