public function LoadmoreuserConnections() { $checkMsgLimit = KarmaHelper::CheckUserLinkedMgsLimit(); $user_info = Auth::user(); $location = ''; if (isset($user_info)) { $user_id = $user_info->id; $location = $user_info->location; } else { $user_id = 0; $location = ''; } $searchresult = ""; if (!empty($_REQUEST)) { $start = $_REQUEST['hitcount'] + 1; $perpage = 10; $getUserConnection = KarmaHelper::getLIMITEDUserConnection($user_id, $location, $start, $perpage); foreach ($getUserConnection as $key => $value) { $searchresult[$key]['fname'] = $value->fname; $searchresult[$key]['lname'] = $value->lname; $searchresult[$key]['linkedinurl'] = $value->linkedinurl; $searchresult[$key]['headline'] = $value->headline; $searchresult[$key]['location'] = $value->location; $searchresult[$key]['linkedinid'] = $value->networkid; $searchresult[$key]['piclink'] = $value->piclink; $searchresult[$key]['id'] = $value->id; $linkedinid = $value->networkid; $linkedinUserData = DB::table('users')->where('linkedinid', '=', $linkedinid)->first(); if (!empty($linkedinUserData)) { $tags = User::find($linkedinUserData->id)->Tags()->orderBy(DB::raw('RAND()'))->take(10)->get(); $searchresult[$key]['UserData'] = array(); $searchresult[$key]['Tags'] = array(); $searchresult[$key]['UserData'] = $linkedinUserData; $searchresult[$key]['Tags'] = $tags; } } $searchresult = array_values(array_sort($searchresult, function ($value) { if (!empty($value['UserData'])) { return $value['UserData']->karmascore; } })); $searchresult = array_reverse($searchresult); $totalCount = 0; if (!empty($searchresult)) { $totalCount = count($searchresult); } return View::make('ajax_loadmoreuserConnections', array('checkMsgLimit' => $checkMsgLimit, 'perpage' => $perpage, 'CurrentUser' => $user_info, 'searchresult' => $searchresult, 'totalResult' => $totalCount)); } }