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/');
}
