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('/');
}
public function createNewReferenceTwo($request)
{
$refereetwo = new References();
$refereetwo->company_id = Auth::user()->company_id;
$refereetwo->first_name = $request->input('first_name');
$refereetwo->last_name = $request->input('surname');
$refereetwo->code = str_random(40);
$refereetwo->referee_name = $request->input('name2');
$refereetwo->referee_company = $request->input('company_name2');
$refereetwo->referee_email = $request->input('emailtwo');
$refereetwo->referee_contact = $request->input('contact2');
$refereetwo->completedtwo = 'No';
$refereetwo->save();
}
public function createNewReferenceTwo(ReferenceRequestEmail $event)
{
$refereetwo = new References();
$refereetwo->company_id = Auth::user()->company_id;
$refereetwo->first_name = $event->user['first_name'];
$refereetwo->last_name = $event->user['surname'];
$refereetwo->code = str_random(40);
$refereetwo->referee_name = $event->user['name2'];
$refereetwo->referee_company = $event->user['company_name2'];
$refereetwo->referee_email = $event->user['emailtwo'];
if (\Request::url() != url() . 'references/new') {
$refereetwo->referee_relationship = $event->user['relationship2'];
$refereetwo->referee_current_employer = $event->user['employer2'];
}
$refereetwo->referee_contact = $event->user['contact2'];
$refereetwo->completedtwo = 'No';
$refereetwo->app_only = 'true';
$refereetwo->save();
return $refereetwo;
}
