get(['id','name']); $data = Http::get( route('getAvailAgent')); $agents = array_values($data['agents']); $agentsIds = collect($agents)->pluck('extension')->toArray(); foreach ($users as $user) { if(in_array($user->id, $agentsIds)){ $agentData = collect($agents)->firstWhere('extension', $user->id); $user->status = $agentData['status']['status']; }else { $user->status = 'Offline'; } } return response([ 'Server_IP' => url('/'), 'Server_Name' => config('app.name'), 'Server_Status' => 'Running', 'users' => $users ]); } function test() { // select the cdr data $cdrData = DB::table('asteriskcdrdb.cdr')->get(); return response([ 'data' => $cdrData ]); } }