@if(!isset($ticket_details) || $ticket_details->isEmpty()) @else @foreach($ticket_details as $ticket) @php // Calculate Turn Around Time $start = \Carbon\Carbon::parse($ticket->created_at); $end = \Carbon\Carbon::parse($ticket->updated_at); $dateInterval = $start->diff($end); $totalDays = $dateInterval->days; $totalSeconds = $dateInterval->s + ($dateInterval->i * 60) + ($dateInterval->h * 3600) + ($dateInterval->days * 86400); $totalHours = floor($totalSeconds / 3600); $totalMinutes = floor(($totalSeconds % 3600) / 60); $totalSeconds = $totalSeconds % 60; @endphp {{-- Raised by (ticket.name or updated_by) --}} {{-- Raised date (created_at) --}} {{-- Resolved by (technician_name) --}} {{-- Resolved date (updated_at) --}} {{-- Turn Around Time --}} {{-- ===== STATUS ===== --}} {{-- ===== ACTION BUTTONS ===== --}} @endforeach @endif

Ticket No	Raised by	Rasied date	Resolved by	Resloved date	Turn Around Time	Status	Actions
No tickets found.
{{ $ticket->ticket_number }}	{{ $ticket->name ?? $ticket->updated_by ?? 'N/A' }}	{{ $ticket->created_at }}	{{ $ticket->technician_name ?? 'N/A' }}	{{ $ticket->updated_at }}	{{ $totalDays }} days - {{ str_pad($totalHours, 2, '0', STR_PAD_LEFT) }}:{{ str_pad($totalMinutes, 2, '0', STR_PAD_LEFT) }}:{{ str_pad($totalSeconds, 2, '0', STR_PAD_LEFT) }}	@if($ticket->issue_status == 1) Acknowledged @elseif($ticket->issue_status == 2) Return with query @elseif($ticket->issue_status == 3) Mark Resolved @elseif($ticket->issue_status == 4) Return @elseif($ticket->issue_status == 5) cancel @endif