public function createOrGetUser(SocialUser $providerUser, $providerName)
{
$account = SocialAccount::whereProvider($providerName)->whereProviderUserId($providerUser->getId())->first();
if ($account) {
return $account->user;
}
$account = new SocialAccount(['provider_user_id' => $providerUser->getId(), 'provider' => $providerName]);
$user = User::whereEmail($providerUser->getEmail())->first();
if (!$user) {
$user = User::create(['email' => $providerUser->getEmail(), 'name' => $providerUser->getName()]);
}
$account->user()->associate($user);
$account->save();
return $user;
}
public function createOrGetUser(ProviderUser $providerUser)
{
// Cari akun di db
$account = SocialAccount::whereProvider('facebook')->whereProviderUserId($providerUser->getId())->first();
if ($account) {
// Kalo ada > return user
return $account->user;
} else {
// Kalo gaada > register
$account = new SocialAccount(['provider_user_id' => $providerUser->getId(), 'provider' => 'facebook']);
$user = User::whereEmail($providerUser->getEmail())->first();
if (!$user) {
$user = User::create(['email' => $providerUser->getEmail(), 'name' => $providerUser->getName()]);
}
$account->user()->associate($user);
$account->save();
return $user;
}
}
public function createOrGetUser(ProviderUser $providerUser)
{
$account = SocialAccount::whereProvider('facebook')->whereProviderUserId($providerUser->getId())->first();
if ($account) {
return $account->user;
} else {
$account = new SocialAccount(['provider_user_id' => $providerUser->getId(), 'provider' => 'facebook']);
$user = User::whereEmail($providerUser->getEmail())->first();
$email = "";
if ($providerUser->getEmail() == "") {
$email = $providerUser->getName();
} else {
$email = $providerUser->getEmail();
}
if (!$user) {
$user = User::create(['email' => $email, 'name' => $providerUser->getName()]);
}
$account->user()->associate($user);
$account->save();
return $user;
}
}
/**
* 社交登录回调
*/
public function getCallback()
{
$platform = Input::get('platform');
$info = Socialite::driver($platform)->user();
$socialAccount = SocialAccount::whereId($info->id)->wherePlatform($platform)->first();
if (!$socialAccount) {
$socialAccount = SocialAccount::from($info, $platform);
if (Auth::guest()) {
$user = User::create();
$user->nickname = $socialAccount->nickname;
$user->avatar = $socialAccount->avatar;
if ($platform == 'github') {
$user->email = $socialAccount->email;
}
} else {
$user = User::findOrNew(Auth::id());
}
$user->social()->save($socialAccount);
$user->save();
}
Auth::loginUsingId($socialAccount->user_id, true);
return Redirect::to('/');
}
public function search(Request $request, Facebook $fb)
{
$search = $request->search;
//dump($search);
$location = $request->location;
//dump($location);
$upah_max = $request->upah_max;
if (is_null($upah_max) || $upah_max === "") {
$upah_max = PHP_INT_MAX;
} else {
$upah_max = intval($upah_max);
}
//dump($upah_max);
$upah_min = $request->upah_min;
if (is_null($upah_min)) {
$upah_min = 0;
} else {
$upah_min = intval($upah_min);
}
//dump($upah_min);
$kategori = $request->category;
//dump($kategori);
$order = $request->order;
if (is_null($order) || $order === "") {
$order = "user_info.user_rating";
}
//dump($order);
$catList = DB::table('category')->select('kategori')->get();
//dump($catList);
$jobs = DB::table('job')->join('users', 'users.id', '=', 'job.freelancer_info_id')->join('user_info', 'user_info.user_id', '=', 'users.id')->join('job_category', 'job_category.job_id', '=', 'job.id')->join('category', 'category.id', '=', 'job_category.category_id')->select('user_info.user_id', 'users.name', 'user_info.alamat', 'job.judul', 'job.deskripsi', 'job.upah_max', 'job.upah_min', 'job.id', 'user_info.profile_picture_link', 'user_info.user_rating', 'job.freelancer_info_id')->where('judul', 'LIKE', '%' . $search . '%')->where('user_info.alamat', 'LIKE', '%' . $location . '%')->where('job.upah_max', '<=', $upah_max)->where('job.upah_min', '>=', $upah_min)->where('category.kategori', 'LIKE', '%' . $kategori . '%')->orderBy($order)->paginate(10);
//-> get();
//->get();
//dump(count($jobs)==0);
//dd($jobs);
$recomendedJobs = array();
$fbfriends = array();
if (Session::has('fb_user_access_token')) {
try {
$response = $fb->get('/me?fields=friends', Session::get('fb_user_access_token'));
} catch (\Facebook\Exceptions\FacebookSDKException $e) {
dd($e->getMessage());
}
$graphNode = $response->getGraphObject();
$fbfriends = json_decode($graphNode["friends"], true);
}
foreach ($fbfriends as $fbfriend) {
$friendSocAccs = SocialAccount::where('provider_user_id', $fbfriend['id'])->get();
foreach ($friendSocAccs as $friendSocAcc) {
$friendAccs = User::where('id', $friendSocAcc->user_id)->get();
foreach ($friendAccs as $friendAcc) {
foreach ($jobs as $job) {
if ($job->user_id == $friendAcc->id) {
array_push($recomendedJobs, $job);
$jobs->forget($jobs->search($job));
// $a = 'WKWK';
// dd($a);
}
}
}
}
}
$request->flash();
return View('search')->with('jobs', $jobs)->with('search', $search)->with('catList', $catList)->with('fbfriends', $fbfriends)->with('recomendedJobs', $recomendedJobs);
}
