{{-- --}} @foreach($levels as $level) @endforeach @foreach ($filter_fields as $field) @endforeach @forelse($reportData as $resource) {{-- --}} @forelse($resource->resourceCategories()->limit($levels->count())->get() as $cat) @empty @foreach($levels as $level) @endforeach @endforelse @foreach ($filter_fields as $field) @php if (!empty($resource->resourceFields) && isset($resource->resourceFields[0])) { // Decode the JSON object $fields = json_decode($resource->resourceFields[0]->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

Source ID	Channel	Type	Account	Customer Username	Customer Name	Status	Assigned Username	Assigned Name	Assigned At	Opened At	FRT	{{$level->label}}	{{\App\Models\Tenant\FormField::where('slug',$field)->first()->label}}	New At	Resolved At	Closed At	Comment
{{$resource->id}}	{{$resource->resourceInfo->channel}}	{{$resource->resourceInfo->type}}	{{$resource->resourceInfo->account_name}}	{{isset($resource->resourceInfo->customer) ? $resource->resourceInfo->customer->username : '-'}}	{{isset($resource->resourceInfo->customer) ? $resource->resourceInfo->customer->display_name : '-'}}	{{$resource->status}}	{{$resource->user != null ? $resource->user->username: '-'}}	{{$resource->user != null ? $resource->user->first_name ." ".$resource->user->last_name : '-'}}	{{ $resource->assign_at != null ? $resource->assign_at : "-"}}	{{$resource->resourceInfo->read_at ? $resource->resourceInfo->read_at : '-'}}	{{$resource->resourceInfo->first_response_time ? $resource->resourceInfo->first_response_time : '-'}}	{{$cat->category->name}}	-	{{ $value }}	{{$resource->created_at->format('M d, y H:i:s')}}	{{$resource->resourceActions()->where('action','Resolved')->first() ? $resource->resourceActions()->where('action','Resolved')->first()->created_at->format('M d, y H:i:s') : "-"}}	{{$resource->resourceActions()->where('action','Closed')->first() ? $resource->resourceActions()->where('action','Closed')->first()->created_at->format('M d, y H:i:s') : "-"}}	{{ $resource->resourceActions ? $resource->resourceActions()->orderBy('id','desc')->first()->comment :"" }}
There is no data found