public function exportRefereeTwo(Request $request) { $profile = Applications::where('reference_two_id', $request->segment(4))->first(); $ref = References::where('id', '=', $request->segment(4))->first(); $settings = Fields::where('references_id', '=', $request->segment(4))->first(); $pdf = PDF::loadView('pdf.refereetwo', compact('profile', 'ref', 'settings', 'custom')); $name = $profile->first_name . '-' . $profile->surname . '-references-'; $pdfFilename = urlencode(strtolower($name . '-' . date('d-m-Y') . '.pdf')); return $pdf->download($pdfFilename); }
public function refereeSubmittedTwo(Request $request) { $code = $request->segment(2); $refTwo = References::where('id', $request->input('referee_id'))->first(); $refTwo->referee_name = $request->input('name'); $refTwo->referee_start_date = $request->input('applicant_started'); $refTwo->referee_end_date = $request->input('date_left'); $refTwo->referee_email = $request->input('email_address'); $refTwo->position = $request->input('position'); $refTwo->leaving = $request->input('reason_for_leaving'); $refTwo->completedtwo = 'Yes'; $refTwo->re_employ = $request->input('re_employ'); $refTwo->update(); $fields = Fields::create($request->except('_token', 're_employ', 'referee_id', 'first_name', 'middle_name', 'surname', 'name', 'phone', 'position', 'email_address', 'applicant_started', 'date_left', 'reason_for_leaving', 'code')); //$settings = Settings::create($request->only('label', 'label2', 'label3', 'label4', 'label5', 'label6', 'label7', 'label8', 'label9', 'label10', 'company_id')); $settings = Settings::where('id', $refTwo->settings_id)->first(); $settings->fields_id = $fields->id; $settings->update(); $apps = Applications::where('code', $code)->first(); $apps->reference_two_id = $refTwo->id; $apps->update(); $fields->settings_id = $settings->id; $fields->references_id = $refTwo->id; $fields->update(); $segment = \Request::url(); $search = ['http://', 'https://', '.madesimpleapp', '.co.uk/', \Request::segment(1) . '/', \Request::segment(2) . '/', \Request::segment(3)]; $replace = ['', '', '', '', '', '', '']; $output = str_replace($search, $replace, $segment); $company = Company::where('url', $output)->first(); $refTwo->settings_id = $settings->id; $refTwo->company_id = $company->id; $refTwo->applications_id = $apps->id; $refTwo->update(); flash()->success('Success', 'Thank you for submission'); return redirect('/'); }
/** * Export PDF * * @param Request $request * @return mixed */ public function export(Request $request) { $profile = References::where('company_id', Auth::user()->company_id)->first(); $ref = References::where('id', '=', $request->segment(3))->first(); $settings = Fields::where('references_id', '=', $request->segment(3))->first(); $pdf = PDF::loadView('references.pdf', compact('profile', 'ref', 'settings')); $name = ucwords($ref->first_name) . '-' . ucwords($ref->last_name) . ' references '; $pdfFilename = urlencode(strtolower($name . '-' . date('d-m-Y') . '.pdf')); return $pdf->download($pdfFilename); }