@foreach($ticket_details as $ticket) {{-- Role Validation --}} @php $skip = false; if ($role == 4 || $role == 5) { if ($user_id != $ticket->user_id) { $skip = true; } } if (in_array($role, [3,6,7])) { $assigned_staff = explode(',', $ticket->assigned_staff_id); if (!in_array($user_id, $assigned_staff)) { $skip = true; } } if ($skip) continue; @endphp {{-- STATUS --}} {{-- Actions --}} @endforeach

Ticket No	Assigned To	Contact No	Created Date	Modified Date	Turn Around Time	Modified User	Status	Action
{{ $ticket->ticket_number }}	@php $technician = $ticket->technician; if (in_array($role, [1,2])) { $users = DB::table('users') ->whereIn('role', [3,6,7]) ->where('user_id', $technician) ->get(); } elseif (in_array($role, [4,3,6,5])) { $users = DB::table('users') ->where('role', 3) ->where('user_id', $technician) ->get(); } else { $users = DB::table('users') ->whereIn('role', [6,7]) ->where('user_id', $technician) ->get(); } @endphp @foreach($users as $u) {{ $u->user_name }} @endforeach	{{ $ticket->contact_number }}	{{ $ticket->created_at }}	{{ date('Y-m-d H:i:s', strtotime($ticket->updated_at)) }}	@php $start = \Carbon\Carbon::parse($ticket->created_at); $end = \Carbon\Carbon::parse($ticket->updated_at); $diffDays = $start->diffInDays($end); $diffHours = $start->diffInHours($end); $diffMin = $start->diffInMinutes($end) % 60; $diffSec = $start->diffInSeconds($end) % 60; echo "{$diffDays} days - {$diffHours}:{$diffMin}:{$diffSec}"; @endphp	{{ $ticket->updated_by }}	@switch($ticket->issue_status) @case(1) Acknowledged @break @case(2) Return with query @break @case(3) Mark Resolved @break @case(4) Return @break @case(5) Cancel @break @endswitch	@if($ticket->issue_status != 5) @if($role == 2) @endif @endif