Filter

@foreach ($all_agents->get() as $agent) @php $first_name = $agent->first_name; $last_name = $agent->last_name; $full_name = $first_name . ' ' . $last_name; $username = $agent->username; @endphp @endforeach

Agent Username	Received Tickets	Handling Time	Resolved Ticket	Closed Tickets	Assigned Tickets
{{ $full_name }}	{{ \App\Models\Tenant\Resource::where('user_id',$agent->id)->count() }}	@php $previousTimestamp = '00:00:00'; $datda = \App\Models\Tenant\Resource::where('user_id',$agent->id)->where('status','New')->get(); foreach ($datda as $datd) { $totalTime = []; $previousTimestamp = null; $currentId = null; foreach ($datd->resourceActions as $sada) { $currentTimestamp = \Illuminate\Support\Carbon::parse($sada->created_at); $currentId = $sada->recource_id; } if ($previousTimestamp !== null ) { $diffInSeconds = $currentTimestamp->diffInSeconds($previousTimestamp); if (!isset($totalTime[$currentId])) { $totalTime[$currentId] = 0; } $totalTime[$currentId] += $diffInSeconds; } $previousTimestamp = $currentTimestamp; $previousId = $currentId; } @endphp {{ \Illuminate\Support\Carbon::parse($previousTimestamp)->format('H:i:s') }}	{{ \App\Models\Tenant\Resource::where('user_id',$agent->id)->where('status','Resolved')->count() }}	{{ \App\Models\Tenant\Resource::where('user_id',$agent->id)->where('status','Closed')->count() }}	{{ \App\Models\Tenant\Resource::where('user_id',$agent->id)->where('status','New')->count() }}