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