/**
* For Submitting and Editing the Career Map
*
* @param request $request
* @return Response
*/
public function editCareerMap($user_id, $employment, $company, $position, $start_date, $end_date, $job_type, $city, $country, $reason_for_leaving, $salary_type, $starting_salary, $final_salary, $reference_name, $reference_email, $reference_phone_number, $reference_position, $notes)
{
$career_map = DB::table('career_map')->select(DB::raw('count(*) as user_count'))->where('user_id', $user_id)->where('employment', $employment)->first();
if ($career_map->user_count == 0) {
CareerMap::create(['user_id' => $user_id, 'employment' => $employment, 'company' => $company, 'position' => $position, 'start_date' => $start_date, 'end_date' => $end_date, 'job_type' => $job_type, 'city' => $city, 'country' => $country, 'reason_for_leaving' => $reason_for_leaving, 'salary_type' => $salary_type, 'starting_salary' => $starting_salary, 'final_salary' => $final_salary, 'reference_name' => $reference_name, 'reference_email' => $reference_email, 'reference_phone_number' => $reference_phone_number, 'reference_position' => $reference_position, 'notes' => $notes]);
} else {
CareerMap::where('user_id', $user_id)->where('employment', $employment)->update(['company' => $company, 'position' => $position, 'start_date' => $start_date, 'end_date' => $end_date, 'job_type' => $job_type, 'city' => $city, 'country' => $country, 'reason_for_leaving' => $reason_for_leaving, 'salary_type' => $salary_type, 'starting_salary' => $starting_salary, 'final_salary' => $final_salary, 'reference_name' => $reference_name, 'reference_email' => $reference_email, 'reference_phone_number' => $reference_phone_number, 'reference_position' => $reference_position, 'notes' => $notes]);
}
//end if
return true;
}
