/** * Accept job from seeker * * @return Response */ public function acceptJob() { $job_id = Input::get('job_id'); $seeker_id = Input::get('seeker_id'); //accept job, create accepted_job $accepted_job = new AcceptedJob(); $accepted_job->job_id = $job_id; $accepted_job->seeker_id = $seeker_id; $accepted_job->save(); //delete request $job_request = JobRequest::find($job_id, $seeker_id); //$job_request->delete(); $query = "DELETE FROM job_request "; $query = $query . "WHERE job_id = " . $job_id . " and seeker_id = " . $seeker_id; DB::select(DB::raw($query)); // add notification to the freelacer $freelancer_id = User::find(FreelancerInfo::find(Job::find($job_id)->freelancer_info_id)->user_info_id)->id; $freelancer_name = User::find($freelancer_id)->name; $job_name = Job::find($job_id)->judul; $notification = new Notification(); $notification->user_id = $seeker_id; $notification->notif = "Tawaran job " . $job_name . " telah diterima oleh freelancer " . $freelancer_name; $notification->type = 2; $notification->save(); return Redirect::to('show-job-request/'); }