@forelse($tickets as $ticket) @php $colored = false; if ($ticket->status == "New") { $category = $ticket->ticketCategories()->orderBy('id','desc')->first(); if ($category){ $overdue = \App\Models\Tenant\Distribution::where('category_id',$category->category_id)->first(); } else{ $overdue = false; } if ($overdue){ // Retrieve the current time $currentDateTime = \Carbon\Carbon::now(); $timestamp = $currentDateTime->timestamp; // Calculate the due time based on the creation time of the ticket and the SLA $created_at = \Carbon\Carbon::parse($ticket->created_at); $dueDateTime = $created_at->addMinutes((int) $overdue->sla_per_minuets); $timestamp2 = $dueDateTime->timestamp; // Add minutes to the created_at time if ($timestamp2 < $timestamp) { $colored = true; }else{ $colored = false; } } } @endphp @empty @endforelse
{{ucfirst('Ticket ID')}} {{ucfirst('Ticket Owner')}} {{ucfirst('Department')}} {{ucfirst('Level')}} {{ucfirst('Source')}} {{ucfirst('type')}} {{ucfirst('Priority')}} {{ucfirst('Status')}} {{ucfirst('Country')}} {{ucfirst('Comment')}} {{ucfirst('Date')}}
#{{ $ticket->id }} mdo {{ $ticket->ticketCustomer ? $ticket->ticketCustomer->display_name : '-' }} {{$ticket->ticketActions()->where('department_id',"!=",0)->orderBy('id','desc')->first() ? $ticket->ticketActions()->where('department_id',"!=",0)->orderBy('id','desc')->first()->department ? $ticket->ticketActions()->where('department_id',"!=",0)->orderBy('id','desc')->first()->department->name : "-" : "-"}} {{$ticket->escalation_level}} @if ($ticket->ticketInfo->channel == 'Google') mdo @elseif ($ticket->ticketInfo->channel == 'Whatsapp') mdo @elseif ($ticket->ticketInfo->channel == 'Facebook') mdo @elseif ($ticket->ticketInfo->channel == 'Email') mdo @elseif ($ticket->ticketInfo->channel == 'Chat') mdo @elseif ($ticket->ticketInfo->channel == 'Voice') mdo @elseif ($ticket->ticketInfo->channel == 'Livechat') mdo @elseif ($ticket->ticketInfo->channel == 'Instagram') mdo @elseif ($ticket->ticketInfo->channel == 'Bot') mdo @elseif ($ticket->ticketInfo->channel == 'Api') mdo @else mdo @endif {{ $ticket->ticketInfo->channel }} {{ $ticket->ticketInfo->type }} @if($ticket->ticketInfo->priority == 'High') {{ $ticket->ticketInfo->priority }} @elseif($ticket->ticketInfo->priority == 'Medium') {{ $ticket->ticketInfo->priority }} @elseif($ticket->ticketInfo->priority == 'Low') {{ $ticket->ticketInfo->priority }} @elseif($ticket->ticketInfo->priority == 'Critical') {{ $ticket->ticketInfo->priority }} @endif @if($ticket->status == 'New') {{ $ticket->status }} @elseif($ticket->status == 'Reopen') {{ $ticket->status }} @elseif($ticket->status == 'Redirect') {{ $ticket->status }} @elseif($ticket->status == 'Resolved') {{ $ticket->status }} @elseif($ticket->status == 'Pending') {{ $ticket->status }} @elseif($ticket->status == 'Closed') {{ $ticket->status }} @elseif($ticket->status == 'In Progress') {{ $ticket->status }} @elseif($ticket->status == 'Forwarded') {{ $ticket->status }} @elseif($ticket->status == 'Reassigned') {{ $ticket->status }} @else {{ $ticket->status }} @endif {!! $ticket->ticketInfo->countryFlag !!} {{ $ticket->ticketInfo->country }} {{ \Illuminate\Support\Str::words($ticket->ticketInfo ? $ticket->ticketInfo->comment : '',4) }} {{ $ticket->ticketInfo->created_at->format('M d h:i:A') }}
No Ticket Found
{{ $tickets->links() }}