public function actionRegisterLinkedIn()
{
// if user canceled, redirect to home page
if (isset($_GET['oauth_problem'])) {
$problem = $_GET['oauth_problem'];
if ($problem == 'user_refused') {
$this->redirect('/JobFair/index.php');
}
}
if (!isset($_SESSION)) {
session_start();
}
//edit by Manuel making the link dynamic, using Yii
$config['base_url'] = 'http://' . Yii::app()->request->getServerName() . '/JobFair/index.php/user/auth1.php';
$config['callback_url'] = 'http://' . Yii::app()->request->getServerName() . '/JobFair/index.php/user/RegisterLinkedIn';
$config['linkedin_access'] = '2rtmn93gu2m4';
$config['linkedin_secret'] = 'JV0fYG9ls3rclP8v';
include_once Yii::app()->basePath . "/views/user/linkedin.php";
# First step is to initialize with your consumer key and secret. We'll use an out-of-band oauth_callback
$linkedin = new LinkedIn($config['linkedin_access'], $config['linkedin_secret'], $config['callback_url']);
//$linkedin->debug = true;
if (isset($_REQUEST['oauth_verifier'])) {
$_SESSION['oauth_verifier'] = $_REQUEST['oauth_verifier'];
$linkedin->request_token = unserialize($_SESSION['requestToken']);
$linkedin->oauth_verifier = $_SESSION['oauth_verifier'];
$linkedin->getAccessToken($_REQUEST['oauth_verifier']);
$_SESSION['oauth_access_token'] = serialize($linkedin->access_token);
header("Location: " . $config['callback_url']);
exit;
} else {
$linkedin->request_token = unserialize($_SESSION['requestToken']);
$linkedin->oauth_verifier = $_SESSION['oauth_verifier'];
$linkedin->access_token = unserialize($_SESSION['oauth_access_token']);
}
# You now have a $linkedin->access_token and can make calls on behalf of the current member
$xml_response = $linkedin->getProfile("~:(id,first-name,last-name,headline,picture-url,industry,email-address,languages,phone-numbers,skills,educations,location:(name),positions,picture-urls::(original))");
$data = simplexml_load_string($xml_response);
// get user by linkedinid
$model = new User();
$user = User::model()->findByAttributes(array('linkedinid' => $data->id));
// check if user exits in database, if so login
if ($user != null) {
if ($user->disable != 1) {
$identity = new UserIdentity($user->username, '');
if ($identity->authenticateOutside()) {
Yii::app()->user->login($identity);
}
$this->redirect("/JobFair/index.php/home/studenthome");
return;
} else {
$this->redirect("/JobFair/index.php/site/page?view=disableUser");
return;
}
// register
} else {
// print "<pre>"; print_r('user is null');print "</pre>";
// check that there is no duplicate user if so link to that account
$duplicateUser = User::model()->findByAttributes(array('email' => $data->{'email-address'}));
if ($duplicateUser != null) {
// get username and link the accounts
$username = $duplicateUser->username;
$user = User::model()->find("username=:username", array(':username' => $username));
$user->linkedinid = $data->{'id'};
$user->save(false);
$user_id = $user->id;
// ------------------BASIC INFO---------------
$basic_info = null;
$basic_info = BasicInfo::model()->findByAttributes(array('userid' => $user_id));
if ($basic_info == null) {
$basic_info = new BasicInfo();
}
$basic_info->userid = $user_id;
$basic_info->save(false);
// ------------------BASIC INFO -----------------
// -----------------EDUCATION ----------------------
// get number of educations to add
$educ_count = $data->educations['total'];
// delete current educations
$delete_educs = Education::model()->findAllByAttributes(array('FK_user_id' => $user_id));
foreach ($delete_educs as $de) {
$de->delete();
}
// add educations
for ($i = 0; $i < $educ_count; $i++) {
// first check if current education is in school table. if not, add it
$current_school_name = $data->educations->education[$i]->{'school-name'};
$school_exists = School::model()->findByAttributes(array('name' => $current_school_name));
if ($school_exists == null) {
$new_school = new School();
$new_school->name = $current_school_name;
$new_school->save();
$school_id = School::model()->findByAttributes(array('name' => $current_school_name))->id;
} else {
$school_id = $school_exists->id;
}
// now ready to add new education
$new_educ = new Education();
$new_educ->degree = $data->educations->education[$i]->degree;
$new_educ->major = $data->educations->education[$i]->{'field-of-study'};
// $model->admission_date=date('Y-m-d',strtotime($model->admission_date));
$new_educ->graduation_date = date('Y-m-d', strtotime($data->educations->education[$i]->{'end-date'}->year));
// print "<pre>"; print_r($new_educ->graduation_date);print "</pre>";return;
$new_educ->FK_school_id = $school_id;
$new_educ->FK_user_id = $user_id;
$new_educ->additional_info = $data->educations->education[$i]->notes;
$new_educ->save(false);
}
// -----------------EDUCATION ----------------------
// -----------------EXPERIENCE -------------------
// get number of educations to add
$pos_count = $data->positions['total'];
// delete current positions
$delete_pos = Experience::model()->findAllByAttributes(array('FK_userid' => $user_id));
foreach ($delete_pos as $de) {
$de->delete();
}
for ($i = 0; $i < $pos_count; $i++) {
$new_pos = new Experience();
$new_pos->FK_userid = $user_id;
$new_pos->company_name = $data->positions->position[$i]->company->name;
$new_pos->job_title = $data->positions->position[$i]->title;
$new_pos->job_description = $data->positions->position[$i]->summary;
$temp_start_date = $data->positions->position[$i]->{'start-date'}->month . '/01/' . $data->positions->position[$i]->{'start-date'}->year;
$new_pos->startdate = date('Y-m-d', strtotime($temp_start_date));
if ($data->positions->position[$i]->{'is-current'} == 'true') {
$new_pos->enddate = '';
} else {
$temp_end_date = $data->positions->position[$i]->{'end-date'}->month . '/01/' . $data->positions->position[$i]->{'end-date'}->year;
$new_pos->enddate = date('Y-m-d', strtotime($temp_end_date));
}
$new_pos->city = '';
$new_pos->state = '';
$new_pos->save(false);
}
// -----------------EXPERIENCE -------------------
// ----------------------SKILLS----------------------
// get number of educations to add
$linkedin_skill_count = $data->skills['total'];
for ($i = 0; $i < $linkedin_skill_count; $i++) {
// check if skill exists in skill set table, if not, add it to skill set table
if (Skillset::model()->findByAttributes(array('name' => $data->skills->skill[$i]->skill->name)) == null) {
$new_skill = new Skillset();
$new_skill->name = $data->skills->skill[$i]->skill->name;
$new_skill->save(false);
//echo 'New Skill ' . $new_skill->attributes;
}
// check if student has that skill, if not add it to student-skill-map table
if (StudentSkillMap::model()->findByAttributes(array('userid' => $user_id, 'skillid' => Skillset::model()->findByAttributes(array('name' => $data->skills->skill[$i]->skill->name))->id)) == null) {
$new_sdnt_skill = new StudentSkillMap();
$new_sdnt_skill->userid = $user_id;
$new_sdnt_skill->skillid = Skillset::model()->findByAttributes(array('name' => $data->skills->skill[$i]->skill->name))->id;
$new_sdnt_skill->ordering = $i + 1;
$new_sdnt_skill->save(false);
echo 'New Skill for student' . $new_sdnt_skill->attributes;
}
}
// ----------------------SKILLS----------------------
if ($duplicateUser->disable != 1) {
$identity = new UserIdentity($duplicateUser->username, '');
if ($identity->authenticateOutside()) {
Yii::app()->user->login($identity);
}
$mesg = "LinkedIn";
//get variables
$mesg = "LinkedIn";
$phone = $data->{'phone-numbers'}->{'phone-number'}->{'phone-number'};
if ($phone != null) {
$phone = strip_tags($data->{'phone-numbers'}->{'phone-number'}->{'phone-number'}->asXML());
}
$city = $data->location->name;
if ($city != null) {
$city = strip_tags($data->location->name->asXML());
}
$state = '';
$about_me = $data->headline;
if ($about_me != null) {
$about_me = strip_tags($data->headline->asXML());
}
$picture = $data->{'picture-urls'}->{'picture-url'}[0];
if ($picture != null) {
$picture = strip_tags($data->{'picture-urls'}->{'picture-url'}[0]->asXML());
}
$this->actionLinkTo($data->{'email-address'}, $data->{'first-name'}, $data->{'last-name'}, $picture, $mesg, $phone, $city, $state, $about_me);
return;
} else {
$this->redirect("/JobFair/index.php/site/page?view=disableUser");
return;
}
}
// Populate user attributes
$model->FK_usertype = 1;
$model->registration_date = new CDbExpression('NOW()');
$model->activation_string = 'linkedin';
$model->username = $data->{'email-address'}[0];
$model->first_name = $data->{'first-name'};
$model->last_name = $data->{'last-name'};
$model->email = $data->{'email-address'};
$model->image_url = $data->{'picture-urls'}->{'picture-url'}[0];
$model->linkedinid = $data->id;
//Hash the password before storing it into the database
$hasher = new PasswordHash(8, false);
$model->password = $hasher->HashPassword('tester');
$model->activated = 1;
$model->has_viewed_profile = 1;
$model->save(false);
// // ------------------BASIC INFO---------------
$basic_info = null;
$basic_info = BasicInfo::model()->findByAttributes(array('userid' => $model->id));
if ($basic_info == null) {
$basic_info = new BasicInfo();
}
$basic_info->userid = $model->id;
$basic_info->phone = $data->{'phone-numbers'}->{'phone-number'}->{'phone-number'};
$basic_info->city = $data->location->name;
$basic_info->state = '';
$basic_info->about_me = $data->headline;
$basic_info->save(false);
// ------------------BASIC INFO -----------------
// -----------------EDUCATION ----------------------
// get number of educations to add
$educ_count = $data->educations['total'];
// delete current educations
$delete_educs = Education::model()->findAllByAttributes(array('FK_user_id' => $model->id));
foreach ($delete_educs as $de) {
$de->delete();
}
// add educations
for ($i = 0; $i < $educ_count; $i++) {
// first check if current education is in school table. if not, add it
$current_school_name = $data->educations->education[$i]->{'school-name'};
$school_exists = School::model()->findByAttributes(array('name' => $current_school_name));
if ($school_exists == null) {
$new_school = new School();
$new_school->name = $current_school_name;
$new_school->save();
$school_id = School::model()->findByAttributes(array('name' => $current_school_name))->id;
} else {
$school_id = $school_exists->id;
}
// now ready to add new education
$new_educ = new Education();
$new_educ->degree = $data->educations->education[$i]->degree;
$new_educ->major = $data->educations->education[$i]->{'field-of-study'};
// $model->admission_date=date('Y-m-d',strtotime($model->admission_date));
$new_educ->graduation_date = date('Y-m-d', strtotime($data->educations->education[$i]->{'end-date'}->year));
// print "<pre>"; print_r($new_educ->graduation_date);print "</pre>";return;
$new_educ->FK_school_id = $school_id;
$new_educ->FK_user_id = $model->id;
$new_educ->additional_info = $data->educations->education[$i]->notes;
$new_educ->save(false);
}
// -----------------EDUCATION ----------------------
// -----------------EXPERIENCE -------------------
// get number of educations to add
$pos_count = $data->positions['total'];
// delete current positions
$delete_pos = Experience::model()->findAllByAttributes(array('FK_userid' => $model->id));
foreach ($delete_pos as $de) {
$de->delete();
}
for ($i = 0; $i < $pos_count; $i++) {
$new_pos = new Experience();
$new_pos->FK_userid = $model->id;
$new_pos->company_name = $data->positions->position[$i]->company->name;
$new_pos->job_title = $data->positions->position[$i]->title;
$new_pos->job_description = $data->positions->position[$i]->summary;
$temp_start_date = $data->positions->position[$i]->{'start-date'}->month . '/01/' . $data->positions->position[$i]->{'start-date'}->year;
$new_pos->startdate = date('Y-m-d', strtotime($temp_start_date));
if ($data->positions->position[$i]->{'is-current'} == 'true') {
$new_pos->enddate = '';
} else {
$temp_end_date = $data->positions->position[$i]->{'end-date'}->month . '/01/' . $data->positions->position[$i]->{'end-date'}->year;
$new_pos->enddate = date('Y-m-d', strtotime($temp_end_date));
}
$new_pos->city = '';
$new_pos->state = '';
$new_pos->save(false);
}
// -----------------EXPERIENCE -------------------
// ----------------------SKILLS----------------------
// get number of educations to add
$linkedin_skill_count = $data->skills['total'];
for ($i = 0; $i < $linkedin_skill_count; $i++) {
// check if skill exists in skill set table, if not, add it to skill set table
if (Skillset::model()->findByAttributes(array('name' => $data->skills->skill[$i]->skill->name)) == null) {
$new_skill = new Skillset();
$new_skill->name = $data->skills->skill[$i]->skill->name;
$new_skill->save(false);
//echo 'New Skill ' . $new_skill->attributes;
}
// check if student has that skill, if not add it to student-skill-map table
if (StudentSkillMap::model()->findByAttributes(array('userid' => $model->id, 'skillid' => Skillset::model()->findByAttributes(array('name' => $data->skills->skill[$i]->skill->name))->id)) == null) {
$new_sdnt_skill = new StudentSkillMap();
$new_sdnt_skill->userid = $model->id;
$new_sdnt_skill->skillid = Skillset::model()->findByAttributes(array('name' => $data->skills->skill[$i]->skill->name))->id;
$new_sdnt_skill->ordering = $i + 1;
$new_sdnt_skill->save(false);
}
}
// ----------------------SKILLS----------------------
// LOGIN
$user = User::model()->find("username=:username", array(':username' => $model->username));
$identity = new UserIdentity($user->username, 'tester');
if ($identity->authenticate()) {
Yii::app()->user->login($identity);
}
$this->redirect("/JobFair/index.php/user/ChangeFirstPassword");
}
}
public function actionFiuAuth()
{
########## Google Settings.. Client ID, Client Secret #############
//edit by Manuel, making the links dynamic, using Yii
//To access the google API console to be able to change the setting
//go to https://code.google.com/apis/console/?noredirect#project:44822970295:access
//E-mail: virtualjobfairfiu@gmail.com
//PASS: cis49112014
$google_client_id = '44822970295-ub8arp3hk5as3s549jdmgl497rahs6jl.apps.googleusercontent.com';
$google_client_secret = 'RsCRTYbGC4VZc40ppLR-4L5h';
$google_redirect_url = 'http://' . Yii::app()->request->getServerName() . '/JobFair/index.php/profile/fiuAuth/oauth2callback';
$google_developer_key = 'AIzaSyBRvfT7Djj4LZUrHqLdZfJRWBLubk51ARA';
//include google api files
require_once Yii::app()->basePath . "/fiu/Google_Client.php";
require_once Yii::app()->basePath . "/fiu/contrib/Google_Oauth2Service.php";
$gClient = new Google_Client();
$gClient->setApplicationName('Login to JobFair');
$gClient->setClientId($google_client_id);
$gClient->setClientSecret($google_client_secret);
$gClient->setRedirectUri($google_redirect_url);
$gClient->setDeveloperKey($google_developer_key);
$google_oauthV2 = new Google_Oauth2Service($gClient);
//If user wish to log out, we just unset Session variable
if (isset($_REQUEST['reset'])) {
unset($_SESSION['token']);
$gClient->revokeToken();
header('Location: ' . filter_var($google_redirect_url, FILTER_SANITIZE_URL));
}
if (isset($_GET['code'])) {
$gClient->authenticate($_GET['code']);
$_SESSION['token'] = $gClient->getAccessToken();
header('Location: ' . filter_var($google_redirect_url, FILTER_SANITIZE_URL));
return;
}
// if user canceled, redirect to home page
if (isset($_GET['error'])) {
$problem = $_GET['error'];
$this->redirect('/JobFair/index.php');
}
if (isset($_SESSION['token'])) {
$gClient->setAccessToken($_SESSION['token']);
}
if ($gClient->getAccessToken()) {
//Get user details if user is logged in
$user = $google_oauthV2->userinfo->get();
$user_id = $user['id'];
$user_name = filter_var($user['name'], FILTER_SANITIZE_SPECIAL_CHARS);
$email = filter_var($user['email'], FILTER_SANITIZE_EMAIL);
$_SESSION['token'] = $gClient->getAccessToken();
} else {
//get google login url
$authUrl = $gClient->createAuthUrl();
}
if (isset($authUrl)) {
$this->redirect($authUrl);
}
//link Fiu Account account to the current one
$currentUser = User::getCurrentUser();
if ($currentUser != null && $currentUser->FK_usertype == 1) {
// check that there is no duplicate id
$duplicateUser = User::model()->findByAttributes(array('fiu_account_id' => $user_id));
if ($duplicateUser != null) {
$this->actionDuplicationError();
return;
}
$username = Yii::app()->user->name;
$userLink = User::model()->find("username=:username", array(':username' => $username));
$userLink->fiu_account_id = $user_id;
$userLink->save(false);
//get variables
$mesg = "FIU Email";
$phone = null;
$city = null;
$state = null;
$about_me = null;
$this->actionLinkToo($email, $user['given_name'], $user['family_name'], $user['picture'], $mesg, $phone, $city, $state, $about_me);
return;
} else {
$userExists = User::model()->findByAttributes(array('fiu_account_id' => $user["id"]));
// if user exists with fiu_account_id, login
if ($userExists != null) {
if ($userExists->disable != 1) {
$identity = new UserIdentity($userExists->username, '');
if ($identity->authenticateOutside()) {
Yii::app()->user->login($identity);
}
$this->redirect("/JobFair/index.php/home/studenthome");
return;
} else {
$this->redirect("/JobFair/index.php/site/page?view=disableUser");
return;
}
} else {
// check that there is no duplicate user
$duplicateUser = User::model()->findByAttributes(array('email' => $user['email']));
if ($duplicateUser != null) {
//populate db
$duplicateUser->fiu_account_id = $user_id;
$duplicateUser->save(false);
if ($duplicateUser->disable != 1) {
$identity = new UserIdentity($duplicateUser->username, '');
if ($identity->authenticateOutside()) {
Yii::app()->user->login($identity);
}
//get variables
$mesg = "FIU Email";
$phone = null;
$city = null;
$state = null;
$about_me = null;
$this->actionLinkToo($email, $user['given_name'], $user['family_name'], $user['picture'], $mesg, $phone, $city, $state, $about_me);
return;
} else {
$this->redirect("/JobFair/index.php/site/page?view=disableUser");
return;
}
}
$model = new User();
//Populate user attributes
$model->FK_usertype = 1;
$model->registration_date = new CDbExpression('NOW()');
$model->activation_string = 'fiu';
$model->username = $user["email"];
$model->first_name = $user['given_name'];
$model->last_name = $user['family_name'];
$model->email = $user["email"];
$model->fiu_account_id = $user["id"];
$model->image_url = $user['picture'];
//Hash the password before storing it into the database
$hasher = new PasswordHash(8, false);
$model->password = $hasher->HashPassword('tester');
$model->activated = 1;
$model->save(false);
// LOGIN
$model2 = User::model()->find("username=:username", array(':username' => $model->email));
$identity = new UserIdentity($model2->username, 'tester');
if ($identity->authenticate()) {
Yii::app()->user->login($identity);
}
$this->redirect("/JobFair/index.php/user/ChangeFirstPassword");
}
}
}
