public function warningEmailForAbuse($post_id) { if ($post_id != null) { if ($this->postExist($post_id)) { $post = Postjob::with('induser', 'corpuser')->where('id', '=', $post_id)->first(); $fname = null; $email = null; if ($post->induser != null) { $fname = $post->induser->fname; $email = $post->induser->email; } else { if ($post->corpuser != null) { $fname = $post->corpuser->firm_name; $email = $post->corpuser->firm_email; } } if ($fname != null && $email != null) { if ($this->postAbuseActionTaken($post_id) == false) { Mail::send('emails.report-abuse-warning', array('fname' => $fname, 'post' => $post), function ($message) use($email, $fname) { $message->to($email, $fname)->subject('Warning Email for Abusive post!')->from('*****@*****.**', 'JobTip'); }); $action = new ReportAbuseAction(); $action->post = $post_id; $action->action_taken_by = Auth::user()->id; $action->warning_email_sent = 1; $tz = new \DateTimeZone('Asia/Kolkata'); $today = \Carbon\Carbon::now($tz); $action->email_dtTime = $today; $action->save(); ReportAbuse::where('post_id', '=', $post_id)->update(['action_taken' => $action->id]); } else { $tz = new \DateTimeZone('Asia/Kolkata'); $today = \Carbon\Carbon::now($tz); ReportAbuseAction::where('id', '=', $this->postAbuseActionTaken($post_id))->update(['warning_email_sent' => 1, 'email_dtTime' => $today]); } } } } return redirect('/report-abuse'); // return $post; }
public function home() { if (Auth::check()) { $title = 'home'; if (Auth::user()->identifier == 1) { $sort_by = " "; $sort_by_skill = " "; $searchskill = ["css", "php"]; // $searchskill = implode(',', $searchskill); // $searchskill = explode(',', $searchskill); $skills = Skills::lists('name', 'name'); $submitFilter = " "; $filter = Filter::where('post_type', '=', 'job')->where('from_user', '=', Auth::user()->id)->first(); $skillfilter = Filter::where('post_type', '=', 'skill')->where('from_user', '=', Auth::user()->id)->first(); // $mobileReg = User::where('induser_id', '=', Auth::user()->induser_id) // ->where('mobile', '=', '9686458736') // ->first(['mobile']); // return $mobileReg; $jobPosts = Postjob::orderBy('id', 'desc')->with('indUser', 'corpUser', 'postActivity', 'taggedUser', 'taggedGroup', 'preferLocations')->where('post_type', '=', 'job')->where('individual_id', '!=', Auth::user()->induser_id)->where('inactive', '=', 0)->whereRaw('postjobs.id in (select pm.id from postjobs pm where pm.id in ( select p.id from postjobs p LEFT JOIN post_group_taggings pgt on pgt.post_id = p.id left join groups_users gu on gu.group_id = pgt.group_id left join indusers ind on ind.id = gu.user_id left join indusers indg on indg.id = pgt.tag_share_by where ind.id = ' . Auth::user()->induser_id . ' union select p.id from postjobs p left join post_user_taggings put on put.post_id = p.id left join indusers ind on ind.id = put.user_id left join indusers inds on inds.id = put.tag_share_by where ind.id = ' . Auth::user()->induser_id . ' ) union select pm.id from postjobs pm where pm.id not in ( select distinct pgt.post_id from post_group_taggings pgt union select distinct put.post_id from post_user_taggings put )) ')->orWhere('corporate_id', '>', 0)->paginate(5); $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'); $skillPosts = Postjob::orderBy('id', 'desc')->with('indUser', 'corpUser', 'postActivity', 'taggedUser', 'taggedGroup', 'preferLocations')->where('post_type', '=', 'skill')->where('individual_id', '!=', Auth::user()->induser_id)->where('inactive', '=', 0)->whereRaw('postjobs.id in (select pm.id from postjobs pm where pm.id in ( select p.id from postjobs p LEFT JOIN post_group_taggings pgt on pgt.post_id = p.id left join groups_users gu on gu.group_id = pgt.group_id left join indusers ind on ind.id = gu.user_id left join indusers indg on indg.id = pgt.tag_share_by where ind.id = ' . Auth::user()->induser_id . ' union select p.id from postjobs p left join post_user_taggings put on put.post_id = p.id left join indusers ind on ind.id = put.user_id left join indusers inds on inds.id = put.tag_share_by where ind.id = ' . Auth::user()->induser_id . ' ) union select pm.id from postjobs pm where pm.id not in ( select distinct pgt.post_id from post_group_taggings pgt union select distinct put.post_id from post_user_taggings put )) ')->paginate(5); $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); 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) { $userSkills = Induser::where('id', '=', Auth::user()->induser_id)->first(['linked_skill']); $userSkills = array_map('trim', explode(',', $userSkills->linked_skill)); unset($userSkills[count($userSkills) - 1]); } 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'); } // return $searchskill; return view('pages.home', compact('jobPosts', 'skillPosts', 'groups', 'title', 'links', 'following', 'userSkills', 'skills', 'linksApproval', 'linksPending', 'share_links', 'share_groups', 'sort_by', 'sort_by_skill', 'filter', 'skillfilter', 'submitFilter')); // return $skillPosts; } elseif (Auth::user()->identifier == 2) { $sort_by = " "; $sort_by_skill = " "; $skills = Skills::lists('name', 'name'); $filter = Filter::where('post_type', '=', 'job')->where('from_user', '=', Auth::user()->id)->first(); $skillfilter = Filter::where('post_type', '=', 'skill')->where('from_user', '=', Auth::user()->id)->first(); $skillPosts = Postjob::orderBy('id', 'desc')->with('indUser', 'corpUser', 'postActivity', 'taggedUser', 'taggedGroup')->where('post_type', '=', 'skill')->where('inactive', '=', 0)->paginate(5); 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); } return view('pages.home_corporate', compact('jobPosts', 'skillPosts', 'title', 'following', 'skills', 'sort_by', 'sort_by_skill', 'filter', 'skillfilter')); } elseif (Auth::user()->identifier == 3) { $reportAbuseCount = ReportAbuse::count(); $feedbackCount = Feedback::count(); $expFeedCounts = DB::select(DB::raw(' select (select count(experience) from feedbacks f where f.experience = 5) as five, (select count(experience) from feedbacks f where f.experience = 4) as four, (select count(experience) from feedbacks f where f.experience = 3) as three, (select count(experience) from feedbacks f where f.experience = 2) as two, (select count(experience) from feedbacks f where f.experience = 1) as one from dual; ')); $useFeedCounts = DB::select(DB::raw(' select (select count(usability) from feedbacks f where f.usability = "Hard") as hard, (select count(usability) from feedbacks f where f.usability = "Okay") as okay, (select count(usability) from feedbacks f where f.usability = "Easy") as easy from dual; ')); return view('pages.dashboard', compact('title', 'reportAbuseCount', 'feedbackCount', 'expFeedCounts', 'useFeedCounts')); } } else { return redirect('login'); } }