Exemplo n.º 1
0
 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');
     }
 }
Exemplo n.º 2
0
 public function getJobsJson()
 {
     $jobs = Jobs::join('users', 'users.id', '=', 'jobs.employer_id')->groupBy("jobs.employer_id")->get();
     return $jobs->toJson();
 }