| {{ $ticket->ticket_number }} |
@if (!empty($ticket->assigned_staff_id))
@php
$assignedIds = explode(',', $ticket->assigned_staff_id);
$technicianNames = [];
foreach ($assignedIds as $assignedId) {
$assignedId = trim($assignedId);
if (!empty($assignedId)) {
$technician = $technicians->get($assignedId);
if ($technician) {
$technicianNames[] = $technician->user_name;
} else {
$fallbackTech = DB::table('users')
->where('user_id', $assignedId)
->whereIn('role', [3, 6, 7])
->first();
if ($fallbackTech) {
$technicianNames[] = $fallbackTech->user_name;
}
}
}
}
echo implode(', ', $technicianNames);
@endphp
@else
Unassigned
@endif
|
{{ $ticket->contact_number }} |
{{ $ticket->request_date ?? $ticket->created_at }} |
{{ date('Y-m-d H:i:s', strtotime($ticket->updated_at)) }} |
@php
$start = \Carbon\Carbon::parse($ticket->request_date ?? $ticket->created_at);
$end = \Carbon\Carbon::parse($ticket->updated_at);
$days = $start->diffInDays($end);
$hours = $start->diffInHours($end) % 24;
$minutes = $start->diffInMinutes($end) % 60;
$seconds = $start->diffInSeconds($end) % 60;
@endphp
{{ $days }}d {{ $hours }}:{{ $minutes }}:{{ $seconds }}
|
{{ $ticket->updated_by }} |
@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
|
@if ($ticket->issue_status != 5)
@if ($role == 2)
@endif
@endif
|
@endforeach
 }}){kind=logo}