@include('sidebar')
View Assigned Tickets
Use the below form to edit or create tickets.
Entries
@forelse($tickets as $ticket) @empty @endforelse
Ticket No Assigned To Contact No Created Date Modified Date Turn Around Time Modified User Status Actions
{{ $ticket->ticket_number ?? 'N/A' }} @php $assignedStaffId = $ticket->assigned_staff_id ?? ''; $assignedIds = array_map('trim', explode(',', $assignedStaffId)); $assignedUsers = \Illuminate\Support\Facades\DB::table('users') ->whereIn('user_id', $assignedIds) ->get(['user_id', 'user_name', 'employee_id']); $names = $assignedUsers->pluck('user_name')->toArray(); @endphp @if (!empty($names)) {{ implode(', ', $names) }} @else Unassigned @endif {{ $ticket->contact_number ?? 'N/A' }} {{ \Carbon\Carbon::parse($ticket->created_at)->format('M d, Y H:i') }} {{ \Carbon\Carbon::parse($ticket->updated_at)->format('M d, Y H:i') }} @php try { $startDate = new \Carbon\Carbon($ticket->created_at); $endDate = new \Carbon\Carbon($ticket->updated_at); $diff = $endDate->diff($startDate); $days = $diff->days; $hours = $diff->h; $minutes = $diff->i; if ($days > 0) { echo "$days d, $hours h, $minutes m"; } else { echo "$hours h, $minutes m"; } } catch (\Exception $e) { echo 'N/A'; } @endphp @php $updatedByUserId = (int) $ticket->updated_by; $updatedByUserName = isset($allUsers[$updatedByUserId]) ? $allUsers[$updatedByUserId]->user_name : 'System'; @endphp {{ $updatedByUserName }} @if ($ticket->issue_status == 1) ACKNOWLEDGED @elseif($ticket->issue_status == 2) RETURN QUERY @elseif($ticket->issue_status == 3) RESOLVED @elseif($ticket->issue_status == 4) RETURN @elseif($ticket->issue_status == 5) CANCELLED @else UNKNOWN @endif
@if ($ticket->issue_status != 5) @endif @if ($role == 2) @endif
No tickets found
Create a new ticket or adjust your filters to see results
@include('footer')