public function seekerRequestDone() { $accepted_job_id = Input::get('accepted_job_id'); $accepted_job = AcceptedJob::find($accepted_job_id); $accepted_job->seeker_confirm_done = 1; $job = Job::find($accepted_job->job_id); $freelancer = User::find($job->freelancer_info_id); $seeker = User::find($accepted_job->seeker_id); //notif buat freelancer $notification = new Notification(); $notification->user_id = $freelancer->id; $notification->notif = "Proyek untuk job " . $job->judul . " yang direquest oleh " . $seeker->name . " telah selesai"; $notification->type = 4; $notification->save(); // kalo freelancer juga udah setuju done if ($accepted_job->freelancer_confirm_done == 1) { // ubah status accepted job ini menjadi done $accepted_job->status = 1; $accepted_job->waktu_selesai = DB::raw('CURRENT_TIMESTAMP'); $accepted_job->save(); } else { $accepted_job->save(); } return Redirect::to('seeker/accepted/' . $accepted_job_id); }
/** * 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/'); }