@if ($reportData != null)

@if($subDataType == "detaild") @foreach($levels as $level) @endforeach {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} @if(!empty($reportData)) @forelse($reportData as $ticket) @php $lastAction = $ticket->ticketActions()->where('department_id','!=',0)->latest()->first(); /* $NewAction = $ticket->ticketActions()->where('action','New Ticket')->first(); $RedirectAction = $ticket->ticketActions()->where('action','Redirect')->first(); $ResolveAction = $ticket->ticketActions()->where('action','Resolved')->first(); $ReopenAction = $ticket->ticketActions()->where('action','Reopen')->first(); $PendingAction = $ticket->ticketActions()->where('action','Reopen')->first(); $CloseAction = $ticket->ticketActions()->where('action','Closed')->first(); $categories = $ticket->ticketCategories()->where('ticket_action_id',$lastAction->id)->get();*/ @endphp {{-- @dd($categories)--}} {{-- --}} {{-- @endforeach --}} @forelse($ticket->ticketCategories()->limit($levels->count())->get() as $cat) @empty @endforelse {{--

Ticket ID	Channel	Type	Customer Name	Status	Department	Priority	Country	Language	{{$level->label}}	User	Date	Pending		Reopen		Redirect		Close
User	Date	User	Date	User	Date	User	Date	User	Date	User	Date
{{$ticket->id}}	{{$ticket->ticketInfo->channel}}	{{$ticket->ticketInfo->type}}	{{isset($ticket->ticketCustomer) ?$ticket->ticketCustomer->display_name : '-'}}	{{$ticket->status}}	{{$lastAction->department->name}}	{{$ticket->ticketActions[0]->user->first_name}}	{{$ticket->ticketInfo->priority}}	{{$ticket->ticketInfo->country}}	{{$ticket->ticketInfo->language}}	--}} {{-- @foreach($categories as $category)	{{$category->category->name}}	{{$cat->category->name}}

--}} {{-- @foreach($ticket->ticketActions as $action)--}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- @endforeach--}} {{--

--}} {{-- {{$ticket->ticketActions()->latest()->first()->action}}--}} {{-- {{$action->action}}--}} {{--

--}} {{-- {{$action->department_id !=0 ?$action->department->name :$action->user->first_name}}--}} {{--

--}} {{-- {{$ticket->ticketActions()->where('department_id','!=',0)->latest()->first()->department->name}}--}} {{----}} {{-- --}} {{$lastAction ? $lastAction->user != null ? $lastAction->user->first_name." " .$lastAction->user->last_name : "-" : " - "}} {{$lastAction ? $lastAction->updated_at->format('M d, y H:i:s') : " - "}} {{-- {{$NewAction ? $NewAction->user->first_name." " .$NewAction->user->last_name : " - "}}--}} {{-- {{$NewAction ? $NewAction->updated_at->format('M d, y H:i:s') : " - "}}--}} {{-- {{$ResolveAction ? $ResolveAction->user->first_name." " .$NewAction->user->last_name : " - "}}--}} {{-- {{$ResolveAction ? $ResolveAction->updated_at->format('M d, y H:i:s') : " - "}}--}} {{-- {{$PendingAction ? $PendingAction->user->first_name." " .$NewAction->user->last_name : " - "}}--}} {{-- {{$PendingAction ? $PendingAction->updated_at->format('M d, y H:i:s') : " - "}}--}} {{-- {{$ReopenAction ? $ReopenAction->user->first_name." " .$NewAction->user->last_name : " - "}}--}} {{-- {{$ReopenAction ? $ReopenAction->updated_at->format('M d, y H:i:s') : " - "}}--}} {{-- {{$RedirectAction ? $RedirectAction->user->first_name." " .$NewAction->user->last_name : " - "}}--}} {{-- {{$RedirectAction ? $RedirectAction->updated_at->format('M d, y H:i:s') : " - "}}--}} {{-- {{$CloseAction ? $CloseAction->user->first_name." " .$NewAction->user->last_name : " - "}}--}} {{-- {{$CloseAction ? $CloseAction->updated_at->format('M d, y H:i:s') : " - "}}--}} {{-- {{$ticket->status != 'New' ?$ticket->updated_at->format('M d, y H:i:s') : '-'}}--}} @empty There is no data found @endforelse @else There is no data found @endif @elseif($subDataType == "statuses") @foreach($inProgressFields = \App\Models\Tenant\ActionField::where('status_type','In Progress')->orderBy('ordering','asc')->get() as $data) @endforeach @foreach($resolvedFields = \App\Models\Tenant\ActionField::where('status_type','Resolved')->orderBy('ordering','asc')->get() as $data) @endforeach @foreach($pendingFields = \App\Models\Tenant\ActionField::where('status_type','Pending')->orderBy('ordering','asc')->get() as $data) @endforeach @foreach($reopenFields = \App\Models\Tenant\ActionField::where('status_type','Reopen')->orderBy('ordering','asc')->get() as $data) @endforeach @foreach($redirectFields = \App\Models\Tenant\ActionField::where('status_type','Redirect')->orderBy('ordering','asc')->get() as $data) @endforeach @foreach($reassignFields = \App\Models\Tenant\ActionField::where('status_type','Reassign')->orderBy('ordering','asc')->get() as $data) @endforeach @foreach($forwardFields = \App\Models\Tenant\ActionField::where('status_type','Forward')->orderBy('ordering','asc')->get() as $data) @endforeach @foreach($closedFields = \App\Models\Tenant\ActionField::where('status_type','Closed')->orderBy('ordering','asc')->get() as $data) @endforeach @if(!empty($reportData)) @forelse($reportData as $ticket) @php $lastAction = $ticket->ticketActions()->where('department_id','!=',0)->latest()->first(); $NewAction = $ticket->ticketActions()->where('action','New Ticket')->first(); $RedirectAction = $ticket->ticketActions()->where('action','Redirect')->first(); $ResolveAction = $ticket->ticketActions()->where('action','Resolved')->first(); $ReopenAction = $ticket->ticketActions()->where('action','Reopen')->first(); $PendingAction = $ticket->ticketActions()->where('action','Pending')->first(); $inAction = $ticket->ticketActions()->where('action','In Progress')->first(); $ReassignAction = $ticket->ticketActions()->where('action','Reassign')->first(); $ForwardAction = $ticket->ticketActions()->where('action','Forward')->first(); $CloseAction = $ticket->ticketActions()->where('action','Closed')->first(); $categories = $ticket->ticketCategories()->where('ticket_action_id',$lastAction->id)->get(); @endphp {{-- @dd($categories)--}} {{-- --}} @foreach($inProgressFields as $data) @if($inAction && isset(json_decode($inAction->fields, true)[$data->slug])) @else @endif @endforeach @foreach($resolvedFields as $data) @if($ResolveAction && isset(json_decode($ResolveAction->fields, true)[$data->slug])) @else @endif @endforeach @foreach($pendingFields as $data) @if($PendingAction && isset(json_decode($PendingAction->fields, true)[$data->slug])) @else @endif @endforeach @foreach($reopenFields as $data) @if($ReopenAction && isset(json_decode($ReopenAction->fields, true)[$data->slug])) @else @endif @endforeach @foreach($redirectFields as $data) @if($RedirectAction && isset(json_decode($RedirectAction->fields, true)[$data->slug])) @else @endif @endforeach @foreach($reassignFields as $data) @if($ReassignAction && isset(json_decode($ReassignAction->fields, true)[$data->slug])) @else @endif @endforeach @foreach($forwardFields as $data) @if($ForwardAction && isset(json_decode($ForwardAction->fields, true)[$data->slug])) @else @endif @endforeach @foreach($closedFields as $data) @if($CloseAction && isset(json_decode($CloseAction->fields, true)[$data->slug])) @else @endif @endforeach @empty @endforelse @else @endif

Ticket ID	Channel	Type	Customer Name	Status	Department	Priority	Country	Language	New		In Progress	Resolved	Pending	Reopen	Redirect	Reassign	Forward	Closed
Ticket ID	Channel	Type	Customer Name	Status	Department	Priority	Country	Language	User	Date	User	Date	{{$data->label}}	User	Date	{{$data->label}}	User	Date	{{$data->label}}	User	Date	{{$data->label}}	User	Date	{{$data->label}}	User	Date	{{$data->label}}	User	Date	{{$data->label}}	User	Date	{{$data->label}}
{{$ticket->id}}	{{$ticket->ticketInfo->channel}}	{{$ticket->ticketInfo->type}}	{{isset($ticket->ticketCustomer) ?$ticket->ticketCustomer->display_name : '-'}}	{{$ticket->status}}	{{$lastAction->department->name}}	{{$ticket->ticketActions[0]->user->first_name}}	{{$ticket->ticketInfo->priority}}	{{$ticket->ticketInfo->country}}	{{$ticket->ticketInfo->language}}	{{$NewAction ? $NewAction->user->first_name." " .$NewAction->user->last_name : " - "}}	{{$NewAction ? $NewAction->updated_at->format('M d, y H:i:s') : " - "}}	{{$inAction ? $inAction->user->first_name." " .$inAction->user->last_name : " - "}}	{{$inAction ? $inAction->updated_at->format('M d, y H:i:s') : " - "}}	{{ $inAction->fields != null && $inAction->fields != [] ? json_decode($inAction->fields, true)[$data->slug] : '-'}}	-	{{$ResolveAction ? $ResolveAction->user->first_name." " .$ResolveAction->user->last_name : " - "}}	{{$ResolveAction ? $ResolveAction->updated_at->format('M d, y H:i:s') : " - "}}	{{ $ResolveAction->fields != null && $ResolveAction->fields != [] ? json_decode($ResolveAction->fields, true)[$data->slug] : '-'}}	-	{{$PendingAction ? $PendingAction->user->first_name." " .$PendingAction->user->last_name : " - "}}	{{$PendingAction ? $PendingAction->updated_at->format('M d, y H:i:s') : " - "}}	{{ $PendingAction->fields != null && $PendingAction->fields != [] ? json_decode($PendingAction->fields, true)[$data->slug] : '-'}}	-	{{$ReopenAction ? $ReopenAction->user->first_name." " .$ReopenAction->user->last_name : " - "}}	{{$ReopenAction ? $ReopenAction->updated_at->format('M d, y H:i:s') : " - "}}	{{ $ReopenAction->fields != null && $ReopenAction->fields != [] ? json_decode($ReopenAction->fields, true)[$data->slug] : '-'}}	-	{{$RedirectAction ? $RedirectAction->user->first_name." " .$RedirectAction->user->last_name : " - "}}	{{$RedirectAction ? $RedirectAction->updated_at->format('M d, y H:i:s') : " - "}}	{{ $RedirectAction->fields != null && $RedirectAction->fields != [] ? json_decode($RedirectAction->fields, true)[$data->slug] : '-'}}	-	{{$ReassignAction ? $ReassignAction->user->first_name." " .$ReassignAction->user->last_name : " - "}}	{{$ReassignAction ? $ReassignAction->updated_at->format('M d, y H:i:s') : " - "}}	{{ $ReassignAction->fields != null && $ReassignAction->fields != [] ? json_decode($ReassignAction->fields, true)[$data->slug] : '-'}}	-	{{$ForwardAction ? $ForwardAction->user->first_name." " .$ForwardAction->user->last_name : " - "}}	{{$ForwardAction ? $ForwardAction->updated_at->format('M d, y H:i:s') : " - "}}	{{ $ForwardAction->fields != null && $ForwardAction->fields != [] ? json_decode($ForwardAction->fields, true)[$data->slug] : '-'}}	-	{{$CloseAction ? $CloseAction->user->first_name." " .$CloseAction->user->last_name : " - "}}	{{$CloseAction ? $CloseAction->updated_at->format('M d, y H:i:s') : " - "}}	{{ $CloseAction->fields != null && $CloseAction->fields != [] ? json_decode($CloseAction->fields, true)[$data->slug] : '-'}}	-
There is no data found
There is no data found

@elseif($subDataType == 'life_cycle') @if(!empty($reportData)) @forelse ($reportData as $ticket) @php $latestAction = $ticket->ticketActions ->sortByDesc('created_at') ->first(); @endphp @php $initialComment = $ticket->ticketActions[0]; @endphp @php $actions = [ 'Redirect' => $ticket->ticketActions->firstWhere( 'action', 'Redirect', ), 'Pending' => $ticket->ticketActions->firstWhere( 'action', 'Pending', ), 'Reopen' => $ticket->ticketActions->firstWhere( 'action', 'Reopen', ), 'Resolved' => $ticket->ticketActions->firstWhere( 'action', 'Resolved', ), 'Closed' => $ticket->ticketActions->firstWhere( 'action', 'Closed', ), ]; @endphp @foreach ($actions as $actionName => $action) @endforeach @empty @endforelse @else @endif

Ticket ID	Status	Received At	Created At	Created By	Created Comment	Reassigned At	Reassigned By	Reassigned Comment	Pending At
{{ $ticket->id }}	{{ $ticket->status }}	{{ $ticket->ticketInfo->created_at }}	{{ $ticket->ticketInfo->created_at }}	{{ $latestAction && $latestAction->user ? $latestAction->user->first_name . ' ' . $latestAction->user->last_name : '-' }}	{{ $initialComment ? $initialComment->comment : '-' }}	{{ $action ? $action->created_at : '-' }}	{{ $action && $action->user ? $action->user->first_name . ' ' . $action->user->last_name : '-' }}	{{ $action ? $action->comment : '-' }}	@php $latestAction = $ticket->ticketActions ->sortByDesc('created_at') ->first(); @endphp {{ $latestAction && $latestAction->department ? $latestAction->department->name : '-' }}
There is no data found
There is no data found

@elseif($subDataType == "performance") @if(!empty($reportData)) @if(isset($reportData['total_created'])) @endif @else @endif

Total Created	Total Resloved	Total Closed	Total Redirected	Total In Progress	Average Resolution Time	Average FRT	Average Handling Time	Escalation Rate	Abandon Rate	Total Transferred to the 2nd	Total Transferred to the 3nd	Total Transferred to the 4nd	Total Transferred to the 5nd	SLA	Volume by channel
Total Created	Total Resloved	Total Closed	Total Redirected	Total In Progress	Average Resolution Time	Average FRT	Average Handling Time	Escalation Rate	Abandon Rate	Total Transferred to the 2nd	Total Transferred to the 3nd	Total Transferred to the 4nd	Total Transferred to the 5nd	SLA	Voice	Facebook	Instagram	Whatsapp	Livechat	Email	LinkedIn	Google Reviews	Youtube	Bot	API
{{$reportData['total_created']}}	{{$reportData['total_resolved']}}	{{$reportData['total_closed']}}	{{$reportData['total_redirect']}}	{{$reportData['total_progress']}}	{{$reportData['avg_resolution_time']}}	{{$reportData['avg_frt']}}	{{$reportData['avg_handling_time']}}	{{$reportData['escalation_rate']}}	{{$reportData['abandon_rate']}}	{{$reportData['_2nd']}}	{{$reportData['_3nd']}}	{{$reportData['_4nd']}}	{{$reportData['_5nd']}}	{{$reportData['SLA']}}	{{$reportData['Voice']}}	{{$reportData['Facebook']}}	{{$reportData['Instagram']}}	{{$reportData['Whatsapp']}}	{{$reportData['Livechat']}}	{{$reportData['Email']}}	{{$reportData['LinkedIn']}}	{{$reportData['Google']}}	{{$reportData['Youtube']}}	{{$reportData['bot']}}	{{$reportData['api']}}
There is no data found

@elseif($subDataType == "performance-per-user") @if(!empty($reportData)) {{-- @dd($reportData)--}} {{-- @if(isset($reportData[0]['total_created']))--}} @foreach($reportData as $reportData2) @endforeach {{-- @endif--}} @else @endif

User	Name	Total New	Total Resloved	Total Closed	Total Redirected	Total In Progress
User	Name	Total New	Total Resloved	Total Closed	Total Redirected	Total In Progress	{{$reportData2['user_id']}}	{{$reportData2['user_name']}}	{{$reportData2['total_created']}}	{{$reportData2['total_resolved']}}	{{$reportData2['total_closed']}}	{{$reportData2['total_redirect']}}	{{$reportData2['total_progress']}}
There is no data found

@elseif($subDataType == "kpis") @if(!empty($reportData)) @forelse($reportData as $ticket) @if(isset($ticket['ticket_id'])) @endif @empty @endforelse @else @endif

Ticket ID	Resolution Time	First Response Time	Volume of Ticket Response	Ticket Wait Time	Escalation Level
{{$ticket['ticket_id']}}	{{$ticket['resolution_time']}}	{{$ticket['frt']}}	{{$ticket['volume_of_ticket_response']}}	{{$ticket['ticket_ait_ime']}}	{{$ticket['escalation_level']}}
There is no data found
There is no data found

@elseif($subDataType == "historical") @foreach($levels as $level) @endforeach {{-- @foreach($levels as $level)--}} {{-- --}} {{-- @endforeach--}} @if(!empty($reportData)) @forelse($reportData as $ticket) @foreach($ticket->ticketActions as $action) @forelse($ticket->ticketCategories()->limit($levels->count())->get() as $cat) @empty @endforelse {{-- @forelse($action->categories as $cat)--}} {{-- --}} {{-- @empty--}} {{-- @foreach($levels as $level)--}} {{-- --}} {{-- @endforeach--}} {{-- @endforelse--}} @endforeach @empty @endforelse @else @endif

Ticket ID	Channel	Type	Customer Name	Status	User	Department	Priority	Country	Language	{{$level->label}}	{{$level->label}}	Date	Comment
{{$ticket->id}}	{{$ticket->ticketInfo->channel}}	{{$ticket->ticketInfo->type}}	{{isset($ticket->ticketCustomer) ?$ticket->ticketCustomer->display_name : '-'}}	{{$action->action == "New Ticket"? "New": $action->action }}	{{$action->user != null ? $action->user->first_name . " " .$action->user->last_name : "-"}}	{{$action->department ? $action->department->name :"-"}}	{{$ticket->ticketInfo->priority}}	{{$ticket->ticketInfo->country}}	{{$ticket->ticketInfo->language}}	{{$cat->category->name}}	{{$cat->category->name}}	-	{{$action->created_at->format('M d, y H:i:s') }}	{{$action->comment}}
There is no data found
There is no data found

@elseif($subDataType == "overdue") {{-- --}} @forelse($reportData as $ticket) {{-- --}} @empty @endforelse

Ticket ID	Department	Customer Name	Status	User Name	Date Time
{{$ticket['ticket_id']}}	{{$ticket['department'] ? $ticket['department'] :"-"}}	{{$ticket['customer_name']}}	{{$ticket['status'] == "New Ticket"? "New": $ticket['status'] }}	{{$ticket['user_name']}}	{{ \Carbon\Carbon::parse($ticket['date_time'])->format('Y/m/d H:i:s') }}
There is no data found

@elseif($subDataType == "complaints_en" || $subDataType == "complaints_ar" || $subDataType == "requests_en" || $subDataType == "requests_ar")

@foreach($levels ?? [] as $level) @if ($level->level == 1)

@elseif(!empty($category_array[$level->id - 1]))

@else

@endif @endforeach

@if($subDataType == "complaints_en" || $subDataType == "requests_en") @elseif ($subDataType == "complaints_ar" || $subDataType == "requests_ar") @endif @forelse($reportData ?? [] as $ticket) {{-- @php $ticketCategory = $ticket->ticketCategories()->where('category_level_id', 1)->first(); $categoryName = optional($ticketCategory->category)->name; @endphp @if($subDataType == "complaints_en" || $subDataType == "complaints_ar") @continue($categoryName != 'Complaints') @elseif ($subDataType == "requests_en" || $subDataType == "requests_ar") @continue($categoryName != 'Requests') @endif --}} @php if($ticket->status == 'Closed'){ $day = $ticket->created_at->diffInDays($ticket->updated_at); }else{ $day = $ticket->created_at->diffInDays(now()); } @endphp @if($subDataType == "complaints_en" || $subDataType == "complaints_ar") @elseif ($subDataType == "requests_en" || $subDataType == "requests_ar") @endif @empty @endforelse

Costomer care											Business Development		Complaints Management
Ticket number	Customer name	Customer account	Customer contact number	creation Date	The sevirity	Sub cateogry of transaction	Product Category	Customer description	TransactionChannel	ID number	The root cause	Remarks Department	The final resolution	action date/time	Received employee	Responsible function	Escalation	Estimated time for resolution	Status
عناية العملاء											الادارة المسؤولة		إدارة قسم الشكاوى
رقم المعاملة	اسم العميل	رقم حساب العميل	رقم جوال العميل	تاريخ انشاء المعاملة	تصنيف المعاملة	نوع المنتج	فئة المنتج	تفاصيل تذكرة العميل	القناة المستلمة للمعاملة	رقم بطاقة الأحوال/ الإقامة	السبب الجذري للمعاملة	تعليقات القسم	الرد النهائي للعميل	وقت وتاريخ تغيير الحالة	تم استلام المعاملة من الموظف	القسم	التصعيد	تاريخ الحل المتوقع للمعاملة	حالة المعاملة
{{$ticket->id}}	{{$ticket->ticketCustomer->display_name ?? ''}}		@php // Decode the JSON fields to an associative array $fieldsArray = json_decode($ticket->ticketFiled->fields, true); // Check if 'contact-number' is set in the decoded array if (isset($fieldsArray['contact-number'])) { // If 'contact-number' is set, use it $contactNumber = $fieldsArray['contact-number']; } else { // Otherwise, fall back to the mobile number $contactNumber = $ticket->ticketCustomer->mobile_number; } @endphp {{$contactNumber ?? '-'}}	{{$ticket->created_at->format('Y/m/d H:i:s')}}	{{$ticket->ticketInfo->priority}}	{{ optional($ticket->ticketCategories()->where('category_level_id', 2)->first()->category)->name }}	{{ optional($ticket->ticketCategories()->where('category_level_id', 1)->first()->category)->name }}	@php echo optional( $ticket->ticketActions() ->orderBy('created_at', 'asc') ->first() )->comment ?? ''; @endphp	{{$ticket->ticketInfo->channel}}		{{ optional($ticket->ticketCategories()->where('category_level_id', 1)->first()->category)->name }}	@php $id = optional($ticket->ticketActions()->where('department_id', 4)->first())->id ?? '' ; if($id){ echo optional($ticket->ticketActions()->where('id','>', $id)->first())->comment ?? '' ; } @endphp	{{ optional($ticket->ticketActions()->latest()->first())->comment ?? '' }}	{{$ticket->updated_at->format('Y/m/d H:i:s')}}	@php $latestTicketAction = $ticket->ticketActions()->latest()->first(); @endphp {{ optional($latestTicketAction->user)->first_name ?? '' }} {{ optional($latestTicketAction->user)->last_name ?? '' }}	{{ optional($ticket->ticketCategories()->where('category_level_id', 1)->first()->category)->name }}	{{ $day }}	10 Days	{{ $day }}	3 Days	{{$ticket->status}}
There is no data found

@elseif($subDataType == "complaints_request_details_en")

@foreach($levels ?? [] as $level) @if ($level->level == 1)

@elseif(!empty($category_array[$level->id - 1]))

@else

@endif @endforeach

Fields

@foreach ($filter_fields as $field) @endforeach @forelse($reportData ?? [] as $ticket) @php if($ticket->status == 'Closed'){ $day = $ticket->created_at->diffInDays($ticket->updated_at); }else{ $day = $ticket->created_at->diffInDays(now()); } @endphp {{-- @if($subDataType == "complaints_en" || $subDataType == "complaints_ar") --}} {{-- @elseif ($subDataType == "requests_en" || $subDataType == "requests_ar") @endif --}} @foreach ($filter_fields as $field) @php if (!empty($ticket->ticketFiled) && isset($ticket->ticketFiled)) { // Decode the JSON object $fields = json_decode($ticket->ticketFiled->fields); // Check if $fields is an object and has the property if (is_object($fields) && isset($fields->$field)) { $value = $fields->$field; } else { $value = "-"; } } else { $value = "-"; } @endphp @endforeach @empty @endforelse

Costomer care											Business Development		Complaints Management							Ticket Fields
Ticket number	Customer name	Customer account	Customer contact number	creation Date	The sevirity	Sub cateogry of transaction	Product Category	Customer description	TransactionChannel	ID number	The root cause	Remarks Department	The final resolution	action date/time	Received employee	Responsible function	Escalation	Estimated time for resolution	Status	{{\App\Models\Tenant\FormField::where('slug',$field)->first()->label}}
{{$ticket->id}}	{{$ticket->ticketCustomer->display_name ?? ''}}		@php // Decode the JSON fields to an associative array $fieldsArray = json_decode($ticket->ticketFiled->fields, true); // Check if 'contact-number' is set in the decoded array if (isset($fieldsArray['contact-number'])) { // If 'contact-number' is set, use it $contactNumber = $fieldsArray['contact-number']; } else { // Otherwise, fall back to the mobile number $contactNumber = $ticket->ticketCustomer->mobile_number; } @endphp {{$contactNumber ?? '-'}}	{{$ticket->created_at->format('Y/m/d H:i:s')}}	{{$ticket->ticketInfo->priority}}	{{ optional($ticket->ticketCategories()->where('category_level_id', 2)->first()->category)->name }}	{{ optional($ticket->ticketCategories()->where('category_level_id', 1)->first()->category)->name }}	@php echo optional( $ticket->ticketActions() ->orderBy('created_at', 'asc') ->first() )->comment ?? ''; @endphp	{{$ticket->ticketInfo->channel}}		{{ optional($ticket->ticketCategories()->where('category_level_id', 1)->first()->category)->name }}	@php $id = optional($ticket->ticketActions()->where('department_id', 4)->first())->id ?? '' ; if($id){ echo optional($ticket->ticketActions()->where('id','>', $id)->first())->comment ?? '' ; } @endphp	{{ optional($ticket->ticketActions()->latest()->first())->comment ?? '' }}	{{$ticket->updated_at->format('Y/m/d H:i:s')}}	@php $latestTicketAction = $ticket->ticketActions()->latest()->first(); @endphp {{ optional($latestTicketAction->user)->first_name ?? '' }} {{ optional($latestTicketAction->user)->last_name ?? '' }}	{{ optional($ticket->ticketCategories()->where('category_level_id', 1)->first()->category)->name }}	{{ $day }}	10 Days	{{ $day }}	3 Days	{{$ticket->status}}	{{ $value }}
There is no data found

@else

@endif

Type

Sub Type