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