public function searchJob(Request $request) { if (Auth::check()) { $searchValue = $request->input('searchValue'); $jobs = Jobs::join('job_keywords', 'jobs.id', '=', 'job_keywords.job_id')->where('title', 'LIKE', "%{$searchValue}%")->orWhere('keyword', 'LIKE', "%{$searchValue}%")->select("jobs.*")->groupBy('jobs.id')->get(); return view('pages.userJobSearch', array("jobs" => $jobs)); } else { return view('pages.home'); } }
public function getJobsJson() { $jobs = Jobs::join('users', 'users.id', '=', 'jobs.employer_id')->groupBy("jobs.employer_id")->get(); return $jobs->toJson(); }