/** * Bootstrap the application services. * * @return void */ public function boot() { view()->composer('includes-update.header', function ($view) { $thanksCount = 0; $followCount = 0; if (Auth::user()->identifier == 1 || Auth::user()->identifier == 3) { $user = Induser::where('id', '=', Auth::user()->induser_id)->first(); $favourites = Postactivity::with('user')->where('fav_post', '=', 1)->where('user_id', '=', Auth::user()->id)->orderBy('id', 'desc')->get(['id', 'fav_post', 'fav_post_dtTime', 'user_id', 'post_id']); $thanksCount = Postactivity::with('user', 'post')->join('postjobs', 'postjobs.id', '=', 'postactivities.post_id')->where('postjobs.individual_id', '=', Auth::user()->induser_id)->where('postactivities.thanks', '=', 1)->orderBy('postactivities.id', 'desc')->sum('postactivities.thanks'); $linksCount = Connections::where('user_id', '=', Auth::user()->induser_id)->where('status', '=', 1)->orWhere('connection_user_id', '=', Auth::user()->induser_id)->where('status', '=', 1)->count('id'); $linkrequestCount = Connections::where('connection_user_id', '=', Auth::user()->induser_id)->where('status', '=', 0)->count('id'); $groupCount = Groups_users::where('user_id', '=', Auth::user()->induser_id)->count('id'); $postCount = Postjob::where('individual_id', '=', Auth::user()->induser_id)->count('id'); $profilePer = 0; if (Auth::user()->induser->fname != null) { $profilePer = $profilePer + 1; } if (Auth::user()->induser->lname != null) { $profilePer = $profilePer + 1; } if (Auth::user()->induser->email != null) { $profilePer = $profilePer + 1; } if (Auth::user()->induser->mobile != null) { $profilePer = $profilePer + 1; } if (Auth::user()->induser->dob != null) { $profilePer = $profilePer + 1; } if (Auth::user()->induser->city != null) { $profilePer = $profilePer + 1; } if (Auth::user()->induser->fb_page != null) { $profilePer = $profilePer + 1; } if (Auth::user()->induser->in_page != null) { $profilePer = $profilePer + 1; } if (Auth::user()->induser->gender != null) { $profilePer = $profilePer + 1; } if (Auth::user()->induser->about_individual != null) { $profilePer = $profilePer + 1; } if (Auth::user()->induser->education != null) { $profilePer = $profilePer + 1; } if (Auth::user()->induser->experience != null) { $profilePer = $profilePer + 1; } if (Auth::user()->induser->working_status != null) { $profilePer = $profilePer + 1; } if (Auth::user()->induser->working_at != null) { $profilePer = $profilePer + 1; } if (Auth::user()->induser->role != null) { $profilePer = $profilePer + 1; } if (Auth::user()->induser->linked_skill != null) { $profilePer = $profilePer + 1; } if (Auth::user()->induser->resume != null) { $profilePer = $profilePer + 1; } if (Auth::user()->induser->prefered_location != null) { $profilePer = $profilePer + 1; } if (Auth::user()->induser->prefered_jobtype != null) { $profilePer = $profilePer + 1; } if (Auth::user()->induser->profile_pic != null) { $profilePer = $profilePer + 1; } $profilePer = round($profilePer / 20 * 100); } else { if (Auth::user()->identifier == 2 || Auth::user()->identifier == 3) { $user = Corpuser::where('id', '=', Auth::user()->corpuser_id)->first(); $followCount = Follow::where('corporate_id', '=', 1)->orWhere('individual_id', '=', 1)->count('id'); $linksCount = ""; $linkrequestCount = ""; $groupCount = ""; $postCount = Postjob::where('corporate_id', '=', Auth::user()->corpuser_id)->count('id'); $favourites = Postactivity::with('user')->where('fav_post', '=', 1)->where('user_id', '=', Auth::user()->id)->orderBy('id', 'desc')->get(['id', 'fav_post', 'fav_post_dtTime', 'user_id', 'post_id']); $profilePer = 0; if (Auth::user()->corpuser->firm_name != null) { $profilePer = $profilePer + 1; } if (Auth::user()->corpuser->username != null) { $profilePer = $profilePer + 1; } if (Auth::user()->corpuser->firm_type != null) { $profilePer = $profilePer + 1; } if (Auth::user()->corpuser->emp_count != null) { $profilePer = $profilePer + 1; } if (Auth::user()->corpuser->working_as != null) { $profilePer = $profilePer + 1; } if (Auth::user()->corpuser->slogan != null) { $profilePer = $profilePer + 1; } if (Auth::user()->corpuser->firm_email_id != null) { $profilePer = $profilePer + 1; } if (Auth::user()->corpuser->logo_status != null) { $profilePer = $profilePer + 1; } if (Auth::user()->corpuser->about_firm != null) { $profilePer = $profilePer + 1; } if (Auth::user()->corpuser->firm_address != null) { $profilePer = $profilePer + 1; } if (Auth::user()->corpuser->operating_since != null) { $profilePer = $profilePer + 1; } if (Auth::user()->corpuser->linked_skill != null) { $profilePer = $profilePer + 1; } if (Auth::user()->corpuser->website_url != null) { $profilePer = $profilePer + 1; } if (Auth::user()->corpuser->firm_phone != null) { $profilePer = $profilePer + 1; } if (Auth::user()->corpuser->industry != null) { $profilePer = $profilePer + 1; } if (Auth::user()->corpuser->role != null) { $profilePer = $profilePer + 1; } if (Auth::user()->corpuser->city != null) { $profilePer = $profilePer + 1; } $profilePer = round($profilePer / 17 * 100); } } $view->with('session_user', $user)->with('favourites', $favourites)->with('thanksCount', $thanksCount)->with('followCount', $followCount)->with('profilePer', $profilePer)->with('linkrequest', $linkrequestCount)->with('linkCount', $linksCount)->with('groupCount', $groupCount)->with('postCount', $postCount); }); view()->composer('includes-update.header', function ($view) { if (Auth::user()->identifier == 1 || Auth::user()->identifier == 2 || Auth::user()->identifier == 3) { $applications = Postactivity::with('user', 'post')->join('postjobs', 'postjobs.id', '=', 'postactivities.post_id')->where('postjobs.individual_id', '=', Auth::user()->induser_id)->where('postactivities.apply', '=', 1)->orderBy('postactivities.id', 'desc')->take(5)->get(['postactivities.id', 'postjobs.unique_id', 'postactivities.apply', 'postactivities.apply_dtTime', 'postactivities.user_id', 'postactivities.post_id']); $thanks = Postactivity::with('user', 'post')->join('postjobs', 'postjobs.id', '=', 'postactivities.post_id')->where('postjobs.individual_id', '=', Auth::user()->induser_id)->where('postactivities.thanks', '=', 1)->orderBy('postactivities.id', 'desc')->take(5)->get(); $favourites = Postactivity::with('user')->where('fav_post', '=', 1)->where('user_id', '=', Auth::user()->id)->orderBy('id', 'desc')->get(['id', 'fav_post', 'fav_post_dtTime', 'user_id', 'post_id']); $thanksCount = Postactivity::with('user', 'post')->join('postjobs', 'postjobs.id', '=', 'postactivities.post_id')->where('postjobs.individual_id', '=', Auth::user()->induser_id)->where('postactivities.thanks', '=', 1)->orderBy('postactivities.id', 'desc')->sum('postactivities.thanks'); $applicationsCount = Postactivity::with('user', 'post')->join('postjobs', 'postjobs.id', '=', 'postactivities.post_id')->where('postjobs.individual_id', '=', Auth::user()->induser_id)->where('postactivities.apply', '=', 1)->orderBy('postactivities.id', 'desc')->sum('postactivities.apply'); $notifications = Notification::with('fromUser', 'toUser')->where('to_user', '=', Auth::user()->id)->orderBy('id', 'desc')->take(5)->get(); $notificationsCount = Notification::where('to_user', '=', Auth::user()->id)->where('view_status', '=', 0)->count(); } $view->with('applications', $applications)->with('thanks', $thanks)->with('favourites', $favourites)->with('thanksCount', $thanksCount)->with('applicationsCount', $applicationsCount)->with('notifications', $notifications)->with('notificationsCount', $notificationsCount); }); }
public function edit_view() { if (Auth::user()->identifier == 1) { $title = 'indprofile_edit'; $user = User::where('id', '=', Auth::user()->id)->with('induser')->first(); $skills = Skills::lists('name', 'name'); $thanks = Postactivity::with('user', 'post')->join('postjobs', 'postjobs.id', '=', 'postactivities.post_id')->where('postjobs.individual_id', '=', Auth::user()->induser_id)->where('postjobs.inactive', '=', 0)->where('postactivities.thanks', '=', 1)->orderBy('postactivities.id', 'desc')->sum('postactivities.thanks'); $posts = Postjob::where('individual_id', '=', Auth::user()->induser_id)->count('id'); $linksCount = Connections::where('user_id', '=', Auth::user()->induser_id)->where('status', '=', 1)->orWhere('connection_user_id', '=', Auth::user()->induser_id)->where('status', '=', 1)->count('id'); $educationList = Education::orderBy('level')->orderBy('name')->where('name', '!=', '0')->get(); $location = Induser::where('id', '=', Auth::user()->induser_id)->first(['prefered_location']); // $loc = explode(',', $location); $farearoleList = Functional_area_role_mapping::orderBy('id')->get(); $acc_id = ""; $profilePer = 0; if (Auth::user()->induser->fname != null) { $profilePer = $profilePer + 1; } if (Auth::user()->induser->lname != null) { $profilePer = $profilePer + 1; } if (Auth::user()->induser->email != null) { $profilePer = $profilePer + 1; } if (Auth::user()->induser->mobile != null) { $profilePer = $profilePer + 1; } if (Auth::user()->induser->dob != null) { $profilePer = $profilePer + 1; } if (Auth::user()->induser->city != null) { $profilePer = $profilePer + 1; } if (Auth::user()->induser->fb_page != null) { $profilePer = $profilePer + 1; } if (Auth::user()->induser->in_page != null) { $profilePer = $profilePer + 1; } if (Auth::user()->induser->gender != null) { $profilePer = $profilePer + 1; } if (Auth::user()->induser->about_individual != null) { $profilePer = $profilePer + 1; } if (Auth::user()->induser->education != null) { $profilePer = $profilePer + 1; } if (Auth::user()->induser->experience != null) { $profilePer = $profilePer + 1; } if (Auth::user()->induser->working_status != null) { $profilePer = $profilePer + 1; } if (Auth::user()->induser->working_at != null) { $profilePer = $profilePer + 1; } if (Auth::user()->induser->role != null) { $profilePer = $profilePer + 1; } if (Auth::user()->induser->linked_skill != null) { $profilePer = $profilePer + 1; } if (Auth::user()->induser->resume != null) { $profilePer = $profilePer + 1; } if (Auth::user()->induser->prefered_location != null) { $profilePer = $profilePer + 1; } if (Auth::user()->induser->prefered_jobtype != null) { $profilePer = $profilePer + 1; } if (Auth::user()->induser->profile_pic != null) { $profilePer = $profilePer + 1; } $profilePer = round($profilePer / 20 * 100); return view('pages.professional_page', compact('user', 'acc_id', 'title', 'skills', 'educationList', 'location', 'farearoleList', 'thanks', 'linksCount', 'posts', 'profilePer')); } else { if (Auth::user()->identifier == 2) { $title = 'corpprofile_edit'; $user = User::where('id', '=', Auth::user()->id)->with('corpuser')->first(); $skills = Skills::lists('name', 'name'); $acc_id = ""; return view('pages.firm_details', compact('user', 'title', 'skills', 'acc_id')); } } }
public function postedByCorp($id) { if (Auth::check()) { $title = 'postByCorporate'; $groups = array(); $postCorp = Corpuser::find($id); $filter = Filter::where('post_type', '=', 'job')->where('from_user', '=', Auth::user()->id)->first(); $skillfilter = Filter::where('from_user', '=', Auth::user()->id)->where('post_type', '=', 'skill')->first(); $jobPosts = Postjob::orderBy('id', 'desc')->with('indUser', 'corpUser', 'postActivity', 'taggedUser', 'taggedGroup')->where('post_type', '=', 'job')->where('corporate_id', '=', $id)->where('inactive', '=', 0)->paginate(15); $skillPosts = Postjob::orderBy('id', 'desc')->with('indUser', 'corpUser', 'postActivity', 'taggedUser', 'taggedGroup')->where('post_type', '=', 'skill')->where('individual_id', '!=', Auth::user()->induser_id)->where('inactive', '=', 0)->paginate(15); $links = DB::select('select id from indusers where indusers.id in ( select connections.user_id as id from connections where connections.connection_user_id=? and connections.status=1 union select connections.connection_user_id as id from connections where connections.user_id=? and connections.status=1 )', [Auth::user()->induser_id, Auth::user()->induser_id]); $links = collect($links); $linksPending = DB::select('select id from indusers where indusers.id in ( select connections.connection_user_id as id from connections where connections.user_id=? and connections.status=0 )', [Auth::user()->induser_id]); $linksPending = collect($linksPending); $linksApproval = DB::select('select id from indusers where indusers.id in ( select connections.user_id as id from connections where connections.connection_user_id=? and connections.status=0 )', [Auth::user()->induser_id]); $linksApproval = collect($linksApproval); if (Auth::user()->identifier == 1) { $share_links = Induser::whereRaw('indusers.id in ( select connections.user_id as id from connections where connections.connection_user_id=? and connections.status=1 union select connections.connection_user_id as id from connections where connections.user_id=? and connections.status=1 )', [Auth::user()->induser_id, Auth::user()->induser_id])->get(['id', 'fname'])->lists('fname', 'id'); $share_groups = Group::leftjoin('groups_users', 'groups_users.group_id', '=', 'groups.id')->where('groups.admin_id', '=', Auth::user()->induser_id)->orWhere('groups_users.user_id', '=', Auth::user()->induser_id)->groupBy('groups.id')->get(['groups.id as id', 'groups.group_name as name'])->lists('name', 'id'); } $groups = Group::leftjoin('groups_users', 'groups_users.group_id', '=', 'groups.id')->where('groups.admin_id', '=', Auth::user()->induser_id)->orWhere('groups_users.user_id', '=', Auth::user()->induser_id)->groupBy('groups.id')->get(['groups.id as id'])->lists('id'); $skills = Skills::lists('name', 'id'); if (Auth::user()->induser_id != null) { $following = DB::select('select id from corpusers where corpusers.id in ( select follows.corporate_id as id from follows where follows.individual_id=? )', [Auth::user()->induser_id]); $following = collect($following); } if (Auth::user()->identifier == 1) { $userSkills = Induser::where('id', '=', Auth::user()->induser_id)->first(['linked_skill']); $userSkills = array_map('trim', explode(',', $userSkills->linked_skill)); unset($userSkills[count($userSkills) - 1]); } return view('pages.home', compact('jobPosts', 'share_links', 'share_groups', 'skillPosts', 'linksPending', 'linksApproval', 'title', 'links', 'groups', 'following', 'userSkills', 'skills', 'postCorp', 'filter', 'skillfilter')); // return $userSkills; } else { return redirect('login'); } }
public function getMypostMatchAttribute() { if (Auth::check()) { if (Auth::user()->identifier == 1) { $userSkills = Induser::where('id', '=', Auth::user()->induser_id)->first(['linked_skill']); $userSkills = array_map('trim', explode(',', $userSkills->linked_skill)); unset($userSkills[count($userSkills) - 1]); $postSkills = $this->attributes['linked_skill']; $postSkills = array_map('trim', explode(',', $this->attributes['linked_skill'])); unset($postSkills[count($postSkills) - 1]); $overlap = array_intersect($userSkills, $postSkills); $counts = array_count_values($overlap); if (count($counts) > 0) { $percentage = round(count($counts) / count($postSkills) * 100); } else { $percentage = 0; } return $percentage; } } else { return null; } }
public function deleteProfileAccount() { if (Auth::user()->identifier == 1) { $user = User::where('induser_id', '=', Auth::user()->induser_id)->first(); $induser = Induser::where('id', '=', Auth::user()->induser_id)->first(); $accountDetail = new Accountdetail(); $accountDetail->name = $user->name; $accountDetail->emailid = $user->email; $accountDetail->mobile = $user->mobile; $accountDetail->profile_created_date = $user->created_at; $accountDetail->reason = Input::get('reason'); $accountDetail->comments = Input::get('comments'); $accountDetail->save(); if ($accountDetail != null) { $user->delete(); $induser->delete(); } } elseif (Auth::user()->identifier == 2) { $user = User::where('corpuser_id', '=', Auth::user()->corpuser_id)->first(); $corpuser = Corpuser::where('id', '=', Auth::user()->corpuser_id)->first(); $accountDetail = new Accountdetail(); $accountDetail->name = $user->name; $accountDetail->emailid = $user->email; $accountDetail->mobile = $user->mobile; $accountDetail->profile_created_date = $user->created_at; $accountDetail->reason = Input::get('reason'); $accountDetail->comments = Input::get('comments'); $accountDetail->save(); if ($accountDetail != null) { $user->delete(); $corpuser->delete(); } } return redirect('/auth/logout'); }