public function friendLink($utype, $id)
    {
        $title = 'friendLink';
        if ($utype == 'ind') {
            $linkName = Induser::findOrFail($id);
            $linkFollow = Corpuser::leftjoin('follows', 'corpusers.id', '=', 'follows.corporate_id')->where('follows.individual_id', '=', $id)->get(['corpusers.id', 'corpusers.firm_name', 'corpusers.logo_status', 'corpusers.operating_since', 'corpusers.city', 'follows.corporate_id', 'follows.individual_id']);
            $followCount = Follow::Where('individual_id', '=', $id)->count('id');
            $connections = DB::select('select id,fname,lname,working_at,city,state,profile_pic 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
									)', [$id, $id]);
            $linksCount = Connections::where('user_id', '=', $id)->where('status', '=', 1)->orWhere('connection_user_id', '=', $id)->where('status', '=', 1)->count('id');
            return view('pages.friendlink', compact('linkName', 'title', 'linkFollow', 'connections', 'linksCount', 'followCount', 'utype'));
        } elseif ($utype == 'corp') {
            $followers = Corpuser::find($id)->followers;
            return view('pages.friendlink', compact('title', 'followers', 'utype'));
        }
    }
 /**
  * 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 followModal()
 {
     $puid = Input::get('puid');
     $linked = Input::get('linked');
     $utype = Input::get('utype');
     $status = 'unknown';
     if ($linked == 'no') {
         $receivedLinkedStatus = Connections::where('user_id', '=', $puid)->Where('connection_user_id', '=', Auth::user()->induser_id)->first(['status']);
         if ($receivedLinkedStatus != null && $receivedLinkedStatus->status == 0) {
             $status = 'received';
         }
         $sentLinkedStatus = Connections::where('user_id', '=', Auth::user()->induser_id)->Where('connection_user_id', '=', $puid)->first(['status']);
         if ($sentLinkedStatus != null && $sentLinkedStatus->status == 0) {
             $status = 'sent';
         }
     }
     return view('pages.links_follow', compact('puid', 'linked', 'utype', 'status'));
 }
 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'));
         }
     }
 }
Exemple #5
0
 public function accountDelete()
 {
     if (Auth::user()->identifier == 1) {
         $title = "AccountSetting";
         $acc_id = Input::get('account_id');
         $password = bcrypt(Input::get('password'));
         $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']);
         $farearoleList = Functional_area_role_mapping::orderBy('id')->get();
         $userDetail = User::where('induser_id', '=', Auth::user()->induser_id)->first();
         $token = 'AD' . rand(11111, 99999) . rand(11111, 99999);
         if (Hash::check(Input::get('password'), $userDetail->password)) {
             $user = User::with('induser')->where('id', '=', Auth::user()->id)->first();
             return view('pages.professional_page', compact('title', 'user', 'acc_id', 'skills', 'educationList', 'location', 'farearoleList', 'thanks', 'linksCount', 'posts'));
         } else {
             return redirect('/mypost');
         }
     } elseif (Auth::user()->identifier == 2) {
         $title = "AccountSetting";
         $acc_id = Input::get('account_id');
         $password = bcrypt(Input::get('password'));
         $skills = Skills::lists('name', 'name');
         $userDetail = User::where('corpuser_id', '=', Auth::user()->corpuser_id)->first();
         $token = 'AD' . rand(11111, 99999) . rand(11111, 99999);
         if (Hash::check(Input::get('password'), $userDetail->password)) {
             $user = User::with('corpuser')->where('id', '=', Auth::user()->id)->first();
             return view('pages.firm_details', compact('title', 'user', 'acc_id', 'skills'));
         } else {
             return redirect('/mypost');
         }
     }
 }