/** * Show Cv information * * @param int $id * @return Response */ public function show($id) { $positions = Position::all(); $employee = Employee::find($id); $educations = Education::where('employee_id', '=', $employee->id)->get(); $employee_skills = EmployeeSkill::where('employee_id', '=', $employee->id)->get(); $experiences = WorkingExperience::where('employee_id', '=', $employee->id)->get(); $taken_projects = TakenProject::where('employee_id', '=', $employee->id)->get(); $nationalities = Nationality::all(); $category_skill = CategorySkill::all(); return view('printpreview.printpreview', compact('taken_projects', 'position', 'employee_skills', 'nationalities', 'employee', 'educations', 'experiences', 'category_skill')); }
/** * Show and Export CV information * * @param [int] $id * @return Response */ public function show($id) { $positions = Position::all(); $employee = Employee::find($id); $educations = Education::where('employee_id', '=', $employee->id)->get(); $employee_skills = EmployeeSkill::where('employee_id', '=', $employee->id)->get(); $experiences = WorkingExperience::where('employee_id', '=', $employee->id)->get(); $taken_projects = TakenProject::where('employee_id', '=', $employee->id)->get(); $nationalities = Nationality::all(); $category_skill = CategorySkill::all(); $parameterr = array(); $parameter['employee'] = $employee; $parameter['educations'] = $educations; $parameter['category_skill'] = $category_skill; $parameter['employee_skills'] = $employee_skills; $parameter['taken_projects'] = $taken_projects; $parameter['experiences'] = $experiences; $parameter['nationalities'] = $nationalities; $pdf = \PDF::loadView('welcome', $parameter)->setPaper('a4')->setOrientation('landscape')->setWarnings(false); return $pdf->download('cv.pdf'); }
/** * Store a newly profile * * @param [int] $id * @return Response */ public function store(AddEditEmployeeRequest $request) { $positions = Position::all(); $employee = Auth::user()->employee()->get()->first(); $img = Request::get('imageup'); $requestdata = Request::all(); $requestdata['date_of_birth'] = $this->convert_datepicker_to_datetimesql(Request::input('dateofbirth')); if ($img != "") { $requestdata['avatar'] = 'avatar/' . $requestdata['avatar']; $img = str_replace('data:image/png;base64,', '', $img); $img = str_replace(' ', '+', $img); $data = base64_decode($img); $file = public_path() . "/avatar/" . Request::input('avatar'); $bytes_written = File::put($file, $data); } else { $requestdata['avatar'] = $requestdata['avatar_save']; } $employee->update($requestdata); $educations = Education::where('employee_id', '=', $employee->id)->get(); $employee->date_of_birth = $this->convert_datepicker_to_datetimesql($employee->date_of_birth); foreach ($educations as $k_edu => $k_val) { $yearstart = Request::input('edu_yearstart' . $k_val->id); if ($yearstart == null) { Education::destroy($k_val->id); continue; } $yearend = Request::input('edu_yearend' . $k_val->id); $education = Request::input('edu_education' . $k_val->id); $edu = Education::find($k_val->id); $edu->update(['year_start' => $yearstart, 'year_end' => $yearend, 'education' => $education]); } $yearstart_new = Request::input('edu_yearstart'); $yearend_new = Request::input('edu_yearend'); $education_new = Request::input('edu_education'); if ($yearstart_new != null && $yearstart_new[0] != "") { foreach ($yearstart_new as $k_n => $v_n) { $user = Education::create(array('employee_id' => $employee->id, 'year_start' => $yearstart_new[$k_n], 'year_end' => $yearend_new[$k_n], 'education' => $education_new[$k_n])); } } $educations = Education::where('employee_id', '=', $employee->id)->get(); $nationalities = Nationality::all(); $working_experience = WorkingExperience::where('employee_id', '=', $employee->id)->delete(); $company = Request::input('company'); $startdate = Request::input('startdate'); $enddate = Request::input('enddate'); $position = Request::input('position'); $mainduties = Request::input('mainduties'); if (!empty($startdate)) { foreach ($startdate as $key => $value) { $startdate[$key] = $this->convert_datepicker_to_datetimesql($value); } foreach ($enddate as $key => $value) { $enddate[$key] = $this->convert_datepicker_to_datetimesql($value); } } if (!empty($company)) { foreach ($company as $key => $value) { if ($value == "") { continue; } $companys = WorkingExperience::create(array('employee_id' => $employee->id, 'company' => $value, 'year_start' => $startdate[$key], 'year_end' => $enddate[$key], 'position' => $position[$key], 'main_duties' => $mainduties[$key])); } } $taken_project = TakenProject::where('employee_id', '=', $employee->id)->delete(); $projectname = Request::input('projectname'); $customername = Request::input('customername'); $role = Request::input('role'); $numberpeople = Request::input('numberpeople'); $projectdescription = Request::input('projectdescription'); $projectperiod = Request::input('projectperiod'); $skillset = Request::input('skillset'); if (!empty($projectname)) { foreach ($projectname as $key => $value) { if ($value == "") { continue; } //dd($numberpeople[$key]); $projects = TakenProject::create(array('employee_id' => $employee->id, 'project_name' => $value, 'customer_name' => $customername[$key], 'number_people' => $numberpeople[$key], 'role' => $role[$key], 'project_description' => $projectdescription[$key], 'project_period' => $projectperiod[$key], 'skill_set_ultilized' => $skillset[$key])); } } $skill = array(); $experience = array(); $skill = Request::input('skill'); $experience = Request::input('month_experience'); EmployeeSkill::where("employee_id", "=", $employee->id)->delete(); foreach ($skill as $key => $value) { if ($value < 0) { unset($experience[$key]); unset($skill[$key]); } else { if ($experience[$key] < 0) { $experience[$key] = 0; } $employeeskill = EmployeeSkill::create(array("employee_id" => $employee->id, "skill_id" => $value, "month_experience" => $experience[$key])); } } $request->session()->flash('flagMessage', 'true'); return redirect()->route('profiles.index'); }
/** * Delete employee * @param [int] $id * @return [Reponse] */ public function delete($id) { $employee = Employee::find($id); WorkingExperience::where('employee_id', '=', $employee->id)->delete(); TakenProject::where('employee_id', '=', $employee->id)->delete(); EmployeeSkill::where('employee_id', '=', $employee->id)->delete(); Education::where('employee_id', '=', $employee->id)->delete(); User::where('employee_id', '=', $employee->id)->delete(); $employee->delete(); return redirect()->route('employee.index')->with('messageDelete', 'Delete employee successfully!'); }