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));
}
}
