get(); //$activities = Reservation::addSelect([ //'specialCall' => SpecialCall::select('sign') ////->whereColumn('reservations.specialCall', 'special_calls.id') //->whereColumn('specialCall', 'id') //->limit(1) //])->get(); return view('pages.activities', compact('activities')); } public function reserve(Request $request) { $signs = SpecialCall::all(); return view('pages.reserve', compact('signs')); } public function reserveForm(Request $request) { //$validatedData = $request->validate([ //'scall' => 'required|alphanum', //'sdate' => 'required|date', //'stime' => 'required', //'edate' => 'required|date', //'etime' => 'required', //'freqs' => 'required', //'modes' => 'required', //'ocall' => 'required|alphanum', //'oname' => 'required', //'email' => 'required|email', //'phone' => ['required', 'regex:/^[0-9 ]+$/'], //]); $rules = [ 'scall' => 'required|alphanum', 'sdate' => 'required|date', 'stime' => 'required', 'edate' => 'required|date', 'etime' => 'required', 'freqs' => 'required', 'modes' => 'required', 'ocall' => 'required|alphanum', 'oname' => 'required', 'email' => 'required|email', 'phone' => ['required', 'regex:/^[0-9 ]+$/'], ]; $messages = [ 'freqs.required' => 'You need to choose at least one frequency.', 'modes.required' => 'You need to choose at least one mode.', 'ocall.alphanum' => 'Callsigns must be alpha-numeric!', ]; $validator = Validator::make($request->all(), $rules, $messages); if ($validator->fails()) { return Redirect::back() ->withErrors($validator) ->withInput(); } $reservation = new Reservation(); $reservation->specialCall = $request->scall; $reservation->fromTime = $request->sdate . ' ' . $request->stime; $reservation->toTime = $request->edate . ' ' . $request->etime; $reservation->frequencies = implode(', ', $request->freqs); $reservation->modes = implode(', ', $request->modes); $reservation->operatorCall = $request->ocall; $reservation->operatorName = $request->oname; $reservation->operatorEmail = $request->email; $reservation->operatorPhone = $request->phone; $reservation->saveOrFail(); return redirect()->route('reserve')->with('status', 'Reservation submitted.'); } public function add(Request $request) { $data = SpecialCall::all(); return view('pages.callsigns', compact('data')); } public function addForm(Request $request) { $rules = [ 'sign' => 'required' ]; $messages = [ 'sign.required' => 'You need to provide a callsign!' ]; $validator = Validator::make($request->all(), $rules, $messages); if ($validator->fails()) { return Redirect::back() ->withErrors($validator) ->withInput(); } $newcall = new SpecialCall(); $newcall->sign = strtoupper($request->sign); $newcall->description = $request->description; $newcall->saveOrFail(); return Redirect::back()->with('status', 'Callsign added.'); } public function reservations(Request $request) { $data = Reservation::all(); return view('pages.reservations', compact('data')); } public function reservationsForm(Request $request) { return Redirect::back(); } }