Пример #1
0
 /**
  * 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);
     });
 }
Пример #2
0
    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'));
        }
    }
Пример #3
0
    /**
     * Show the form for editing the specified resource.
     *
     * @param  int  $id
     * @return Response
     */
    public function edit($id)
    {
        $title = 'job';
        $skills = Skills::lists('name', 'name');
        if (Auth::user()->identifier == 1) {
            $postjob = Postjob::where('unique_id', '=', $id)->where('individual_id', '=', Auth::user()->induser_id)->first();
            $connections = 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');
            $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');
            $education = Education::orderBy('level')->orderBy('name')->get();
            $farearoleList = Functional_area_role_mapping::orderBy('id')->get();
            return view('pages.postjob_edit', compact('title', 'skills', 'connections', 'groups', 'education', 'farearoleList', 'postjob'));
        } else {
            $postjob = Postjob::where('unique_id', '=', $id)->where('corporate_id', '=', Auth::user()->corpuser_id)->first();
            $education = Education::all();
            $farearoleList = Functional_area_role_mapping::orderBy('id')->get();
            return view('pages.postjob_edit', compact('title', 'skills', 'education', 'farearoleList', 'postjob'));
        }
    }
Пример #4
0
    public function searchLinks()
    {
        $keywords = Input::get('keywords');
        $groupId = Input::get('groupid');
        $users = 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
										union
										select groups.admin_id as id from groups
										where groups.id=?
									)', [Auth::user()->induser_id, Auth::user()->induser_id, $groupId])->where('fname', 'like', '%' . $keywords . '%')->orWhere('lname', 'like', '%' . $keywords . '%')->get(['id', 'fname', 'lname', 'working_at', 'city', 'state', 'profile_pic']);
        $groupAdmin = Induser::whereRaw('indusers.id in (select admin_id from groups where id=' . $groupId . ')')->get(['id']);
        $groupAdmin = collect($groupAdmin);
        $groupUsers = Induser::whereRaw('indusers.id in (select user_id from groups_users where group_id=' . $groupId . ' 
														  union
														 select groups.admin_id from groups where groups.id=' . $groupId . ' )')->get(['id']);
        $groupUsers = collect($groupUsers);
        return view('pages.search.searchUsersForGroup', compact('users', 'groupUsers', 'groupId', 'groupAdmin'));
        // return $users;
        // return $groupUsers;
    }
Пример #5
0
 public function createUserRequest(Request $request)
 {
     $skills = Skills::lists('name', 'name');
     $educationList = Education::orderBy('level')->orderBy('name')->where('name', '!=', '0')->get();
     $farearoleList = Functional_area_role_mapping::orderBy('id')->get();
     $indUser = new Induser();
     $indUser->fname = $request['fname'];
     $indUser->lname = $request['lname'];
     $indUser->gender = $request['gender'];
     $indUser->city = $request['city'];
     $indUser->about_individual = $request['about_individual'];
     $indUser->education = $request['education'];
     $indUser->experience = $request['experience'];
     $indUser->working_status = $request['working_status'];
     $indUser->working_at = $request['working_at'];
     $indUser->industry = $request['industry'];
     if ($request['role'] != null) {
         $farea_role = $request['role'];
         $temp = explode('-', $farea_role);
         $indUser->functional_area = $temp[0];
         $indUser->role = $temp[1];
     }
     if ($request['linked_skill_id'] != null) {
         $indUser->linked_skill = implode(', ', $request['linked_skill_id']);
     }
     if ($request['prefered_location'] != null) {
         $indUser->prefered_location = implode(', ', $request['prefered_location']);
     }
     $indUser->email = $request['email'];
     $indUser->mobile = $request['mobile'];
     $indUser->prefered_jobtype = $request['prefered_jobtype'];
     $indUser->save();
     $user = new User();
     $user->name = $request['fname'] . ' ' . $request['lname'];
     $user->email = $request['email'];
     $user->mobile = $request['mobile'];
     $user->password = md5(rand(111111, 999999));
     $user->identifier = 1;
     if ($request['email'] != null) {
         $vcode = 'A' . rand(1111, 9999);
         $user->email_vcode = $vcode;
     }
     if ($request['mobile'] != null) {
         $otp = rand(1111, 9999);
         $user->mobile_otp = $otp;
     }
     $resetCode = md5(rand(11111, 99999));
     $user->reset_code = $resetCode;
     $indUser->user()->save($user);
     $email = $request['email'];
     if ($request['email'] != null) {
         $email = $request['email'];
         $fname = $request['fname'];
         Mail::send('emails.auth.resetpassword', array('fname' => $fname, 'token' => $resetCode), function ($message) use($email, $fname) {
             $message->to($email, $fname)->subject('Jobtip - Profile Created!')->from('*****@*****.**', 'JobTip');
         });
     }
     return view('pages.create_users', compact('skills', 'educationList', 'farearoleList'))->withErrors(['errors' => 'Profile Created Successfully.']);
 }
Пример #6
0
 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'));
         }
     }
 }
Пример #7
0
 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;
     }
 }
Пример #8
0
    public function postFilter(Request $request)
    {
        $title = 'home';
        $sort_by = " ";
        $sort_by_skill = " ";
        $skillfilter = "";
        $skills = Skills::lists('name', 'name');
        $filter = Filter::where('from_user', '=', Auth::user()->id)->where('post_type', '=', 'job')->first();
        $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);
        $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);
        $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);
        $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');
        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()->corpuser_id != null) {
            $following = DB::select('select id from indusers
									 where indusers.id in (
										select follows.individual_id as id from follows
										where follows.corporate_id=?
								)', [Auth::user()->corpuser_id]);
            $following = collect($following);
        }
        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');
        }
        $skillPosts = Postjob::orderBy('id', 'desc')->with('indUser', 'corpUser', 'postActivity', 'taggedUser', 'taggedGroup')->where('post_type', '=', 'skill')->where('individual_id', '!=', Auth::user()->induser_id)->where('postjobs.inactive', '=', 0)->paginate(15);
        // $post_type = $request['post_type'];
        $post_title = $request['jobTitle'];
        $experience = $request['experience'];
        $time_for = $request['time_for'];
        $skill = $request['jobSkill'] != null ? implode(',', $request['jobSkill']) : null;
        $industry = $request['industry'];
        // return $skill;
        $jobPosts = Postjob::orderBy('postjobs.id', 'desc')->with('indUser', 'corpUser', 'postActivity', 'preferLocations')->leftjoin('post_preferred_locations', 'post_preferred_locations.post_id', '=', 'postjobs.id')->where('individual_id', '!=', Auth::user()->induser_id)->where('inactive', '=', 0);
        if ($time_for != null) {
            $jobPosts->whereIn('time_for', $time_for);
        }
        /*if($post_type == 'job'){
        			$jobPosts->where('post_type', '=', $post_type);
        		}*/
        if ($skill != null) {
            $jobPosts->where('linked_skill', 'like', '%' . $skill . '%');
        }
        if ($post_title != null) {
            $jobPosts->where('post_title', 'like', '%' . $post_title . '%')->whereRaw("(job_detail like '%" . $post_title . "%' or role like '%" . $post_title . "%' or linked_skill like '%" . $post_title . "%')");
        }
        if ($industry != null) {
            $jobPosts->where('industry', 'like', '%' . $industry . '%');
        }
        if ($experience != null) {
            $jobPosts->whereRaw("{$experience} between min_exp and max_exp");
        }
        $jobPosts = $jobPosts->groupBy('unique_id')->paginate(15);
        // return $jobPosts;
        return view('pages.homeFiltered', compact('jobPosts', 'skillPosts', 'linksApproval', 'linksPending', 'title', 'links', 'groups', 'following', 'userSkills', 'skills', 'share_links', 'share_groups', 'sort_by', 'sort_by_skill', 'filter', 'skillfilter', 'submitFilter'));
    }
Пример #9
0
 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');
 }