/**
* Show the form for creating a new resource.
*
* @return \Illuminate\Http\Response
*/
public function create(Request $request)
{
$inquiry = DB::table('inquiries')->orderBy('stop', 'desc')->first();
$start = Carbon::parse($inquiry->stop)->format('Y-m-d');
$stop = Carbon::parse($inquiry->stop)->addWeek()->format('Y-m-d');
// echo $start;
// $inputData = $request->all();
// if ($start>$inputData['start'])
// {
// echo "start is kleiner";
// }
// echo $inputData['start'];
$this->validate($request, ['inquiry' => 'required|max:255', 'awnser' => 'required|max:255', 'option1' => 'required|max:255', 'option2' => 'required|max:255', 'option3' => 'required|max:255', 'start' => 'required|date:after:' . $start, 'stop' => 'required|date:after:' . $stop]);
$inputData = $request->all();
$inquiry = new Inquiry();
$inquiry->question = $inputData['inquiry'];
$inquiry->awnser = $inputData['awnser'];
$inquiry->option1 = $inputData['option1'];
$inquiry->option2 = $inputData['option2'];
$inquiry->option3 = $inputData['option3'];
$inquiry->start = $inputData['start'];
$inquiry->stop = $inputData['stop'];
$inquiry->save();
return redirect()->route('home');
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$start = Carbon::today();
$stop = Carbon::today()->addWeek();
$inquiry = new Inquiry();
$inquiry->question = "Who was the 3rd Doctor?";
$inquiry->awnser = "Jon Pertwee";
$inquiry->option1 = "Matt Smitt";
$inquiry->option2 = "That one British Guy!";
$inquiry->option3 = "David Tannent";
$inquiry->start = $start;
$inquiry->stop = $stop;
$inquiry->save();
}
/**
* save a customer inwuiry and send an email to admin email which is hardcoded
*
* @param Request $request
*/
public function saveinquiry(Request $request)
{
$inq = new Inquiry();
$inq->name = $request->input('fullname');
$inq->company = $request->input('company');
$inq->email = $request->input('email');
$inq->message = $request->input('message');
$inq->status = '1';
$inq->save();
// save notification to DB and to pusher
$newNotification = new Notifications();
$newNotification->notification = "New Customer Inquiry!";
$newNotification->body = 'New Customer Inquiry has been made.';
$newNotification->readStatus = '0';
$newNotification->save();
Pusher::trigger('notifications', 'new_backup_notification', ['message' => 'New Customer Inquiry has been made.']);
// get admin's email
$email = User::where('role', 'admin')->first()->email;
Mail::send('emails.inquiry', ['inq' => $inq], function ($message) use($email) {
$message->from(env('MAIL_FROM'), env('MAIL_NAME'));
//$message->to("*****@*****.**")->subject('Amalaya Reach Inquiry');
$message->to($email)->subject('Amalaya Reach Inquiry');
});
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
//
if ($request->edit != 0) {
return $this->update($request, $request->edit);
}
$validator = \Validator::make($request->all(), ['subject' => 'required']);
if ($validator->fails()) {
return response()->json(array('status' => 500, 'monolog' => array('title' => 'errors', 'message' => implode($validator->errors()->all(), '<br>'))));
}
DB::beginTransaction();
$inquiry = new Inquiry();
$inquiry->property_id = $request->property_id;
$inquiry->customer_id = $request->customer_id;
$inquiry->subject = $request->subject;
$inquiry->content = $request->content;
$inquiry->firstname = $request->firstname;
$inquiry->lastname = $request->lastname;
$inquiry->phone = $request->phone;
$inquiry->email = $request->email;
$inquiry->save();
DB::commit();
return response()->json(array('status' => 200, 'monolog' => array('title' => 'post success', 'message' => 'Post has been received')));
}
public function store(Request $request)
{
if (Auth::check()) {
$staff_id = Auth::user()->id;
$sfname = Auth::user()->fname;
$slname = Auth::user()->lname;
} else {
return redirect('auth/login');
}
$datedoc = Carbon::now(-6);
$yr = $datedoc->year;
$mo = $datedoc->month;
$dom = $datedoc->day;
$doy = $datedoc->dayOfYear;
//==== first we are going to create the record in ice in order to get the episode id
$fname = $request->input('fname');
$lname = $request->input('lname');
$existingcount = DB::table('inquiries')->where('eie', '!=', '1')->where('fname', '=', $fname)->where('lname', '=', $lname)->count();
if ($existingcount > 0) {
return redirect()->back()->withInput()->with('status', 'There is already an Inquiry using this name!');
}
$ice = new Ice();
$ice->fname = $request->input('fname');
$ice->lname = $request->input('lname');
$ice->callerfname = $request->input('callerfname');
$ice->callerlname = $request->input('callerlname');
$ice->staff_id = $staff_id;
$ice->sfname = $sfname;
$ice->slname = $slname;
$ice->isalias = 0;
//$ice->aliasfname = "";
// $ice->aliaslname = "";
$ice->poc = $request->input('poc');
$ice->precipevent = $request->input('precipevent');
$ice->dob = $request->input('dob');
$ice->callerhphone = $request->input('callerhphone');
$ice->callercphone = $request->input('callercphone');
$ice->hphone = $request->input('hphone');
$ice->cphone = $request->input('cphone');
$morechks = array('eie', 'dss');
foreach ($morechks as $morechk) {
$ice->setAttribute($morechk, Input::has($morechk) ? true : false);
}
$ice->client_id = 0;
// need to make this populate from ICE.
$ice->datedoc = $datedoc;
$ice->mrn = 0;
$ice->mo = $mo;
$ice->dom = $dom;
$ice->yr = $yr;
$ice->doy = $doy;
$ice->save();
$episode_id = $ice->id;
//================
$inquiry = new Inquiry();
$inquiry->fname = $request->input('fname');
$inquiry->lname = $request->input('lname');
$inquiry->callerfname = $request->input('callerfname');
$inquiry->callerlname = $request->input('callerlname');
$inquiry->staff_id = $staff_id;
$inquiry->sfname = $sfname;
$inquiry->slname = $slname;
$inquiry->isalias = 0;
//$inquiry->aliasfname = "";
// $inquiry->aliaslname = "";
$inquiry->poc = $request->input('poc');
$inquiry->precipevent = $request->input('precipevent');
$inquiry->dob = $request->input('dob');
$inquiry->callerhphone = $request->input('callerhphone');
$inquiry->callercphone = $request->input('callercphone');
$inquiry->hphone = $request->input('hphone');
$inquiry->cphone = $request->input('cphone');
$morechks = array('eie', 'dss');
foreach ($morechks as $morechk) {
$inquiry->setAttribute($morechk, Input::has($morechk) ? true : false);
}
$inquiry->client_id = 0;
// need to make this populate from ICE.
$inquiry->episode_id = $episode_id;
$inquiry->datedoc = $datedoc;
$inquiry->mrn = 0;
$inquiry->recordstatus_id = 1;
//we'll say that one means active.
$inquiry->mo = $mo;
$inquiry->dom = $dom;
$inquiry->yr = $yr;
$inquiry->doy = $doy;
$inquiry->save();
$inquiry_id = $inquiry->id;
$updateresult = DB::table('ice')->where('id', '=', $episode_id)->update(['inquiry_id' => $inquiry_id]);
return redirect()->route('inquiryview', $inquiry_id);
//return view('inquiry/index')->with('inquiry',$inquiry);
}
