public static function insertUserConnection($user) { $user_id = $user->id; $token = $user->token; $user_connection_data = "https://api.linkedin.com/v1/people/~/connections?id,first-name,last-name,headline,summary,industry,member-url-resources,picture-urls::(original),location,public-profile-url,site-standard-profile-request&format=json&oauth2_access_token={$token}"; //echo $user_connection_data;exit; $ch = curl_init($user_connection_data); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 1); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0); $data = curl_exec($ch); curl_close($ch); $user_connection = json_decode($data); Log::alert('User connection fetch'); /* for($i=0;$i<count($user_connection->person);$i++) { print_r($user_connection->person[$i]->{'first-name'}); } */ //echo "<pre>========="; print_r($user_connection); echo "</pre>========"; die; if (!empty($user_connection->values)) { $group = new Usersgroup(); $group->user_id = $user_id; $group->group_id = 1; $group->save(); Usersconnection::where('user_id', '=', $user_id)->delete(); foreach ($user_connection->values as $key => $value) { if (!empty($value->id) && $value->id != 'private') { if (!isset($value->publicProfileUrl) || $value->publicProfileUrl == '') { $publicProfileUrl = $value->siteStandardProfileRequest->url; } else { $publicProfileUrl = $value->publicProfileUrl; } $connection = new Connection(); $connection = Connection::firstOrCreate(array('networkid' => $value->id)); if ($connection['user_id'] != '') { $Connuser = User::find($connection['user_id']); /* $Connuser->fname = @$value->firstName; $Connuser->lname = @$value->lastName;*/ $Connuser->location = @$value->location->name; $Connuser->industry = @$value->industry; $Connuser->piclink = @$value->pictureUrl; $Connuser->linkedinurl = @$publicProfileUrl; $Connuser->headline = @$value->headline; $Connuser->save(); } $connection_id = $connection['id']; $connection = connection::find($connection_id); $connection->networktype = 'linkedin'; if ($connection->user_id == '') { $connection->fname = @$value->firstName; $connection->lname = @$value->lastName; } $connection->headline = @$value->headline; $connection->industry = @$value->industry; $connection->location = @$value->location->name; $connection->piclink = @$value->pictureUrl; $connection->linkedinurl = @$publicProfileUrl; $connection->save(); $users_connections = new Usersconnection(); $users_connections->user_id = $user_id; $users_connections->connection_id = $connection_id; $users_connections->save(); $userDetail = User::find($user_id); $userDetail->totalConnectionCount = $user_connection->_total; $userDetail->save(); } } } $userDetail = User::find($user_id); if (empty($userDetail->totalConnectionCount)) { $userDetail->totalConnectionCount = 0; $userDetail->save(); } $connection = new Connection(); $connection = Connection::firstOrCreate(array('networkid' => $user['linkedinid'])); $connection_id = $connection['id']; $connection = Connection::find($connection_id); $connection->networktype = 'linkedin'; if ($connection->user_id == '') { $connection->fname = @$user['fname']; $connection->lname = @$user['lname']; } $connection->headline = @$user['headline']; $connection->industry = @$user['industry']; $connection->location = @$user['location']; $connection->piclink = @$user['piclink']; $connection->linkedinurl = @$user['linkedinurl']; $connection->user_id = $user_id; $connection->save(); return true; }