/** * POST /api/login */ public function login() { // Get all data send in post $loginFormData = Request::all(); // Create rules for the validator $validator = Validator::make($loginFormData, ['user_email' => 'required|email', 'user_password' => 'required']); // If validator fails return a 404 response if ($validator->fails()) { return Response::json(['status_code' => 404, 'errors' => $validator->errors()->all()], 404); } $user = User::where('email', '=', strtolower($loginFormData['user_email']))->first(); if (!$user) { return Response::json(['status_code' => 404, 'errors' => ['Votre compte est introuvable dans notre base de donnée.']], 404); } else { if ($user->activated == 0) { return Response::json(['status_code' => 404, 'errors' => ["Merci d'activer votre compte."]], 404); } else { if (!Hash::check($loginFormData['user_password'], $user->password)) { return Response::json(['status_code' => 404, 'errors' => ["Votre mot de passe est incorrect."]], 404); } } } $room = Room::find($user->room_id); $partner = User::find($user->is_partner ? $room->user_id : $room->partner_id); if ($partner->activated == 0) { return Response::json(['status_code' => 404, 'errors' => ["Le compte de votre partenaire n'a pas été activé."]], 404); } // Success return Response::json(['status_code' => 200, 'success' => "Login success", 'data' => ['me' => $user, 'partner' => $partner, 'room' => $room]]); }
public function saveReservation(Request $request) { $reservation = new Reservation(); if (!$request->input('locator_id') || !Locator::find($request->input('locator_id'))) { return response('Lokator nie został sprecyzowany', 500)->header('Content-Type', 'text/html; charset=utf-8'); } if (!$request->input('rooms')) { return response('Pokoje nie zostały sprecyzowane', 500)->header('Content-Type', 'text/html; charset=utf-8'); } foreach ($request->input('rooms') as $room) { if (!Room::find($room)) { return response('Pokój o numerze ' . $room . ' nie jest zdefiniowany w bazie danych.', 500)->header('Content-Type', 'text/html; charset=utf-8'); } } $reservation->locator_id = $request->input('locator_id'); $reservation->reservation_time = date('Y-m-d H:i:sZ', time()); $reservation->since = $request->input('since'); $reservation->till = $request->input('till'); $reservation->is_paid = $request->input('is_paid'); $reservation->dinners_count = $request->input('dinners_count'); $reservation->people_count = $request->input('people_count'); $reservation->save(); $reservation->rooms()->sync($request->input('rooms')); $reservation->save(); return response()->json($reservation); }
public function delete_room($room_id) { $room = Room::find($room_id); $url = "manage/bases/" . $room->base->id; $room->delete(); return redirect($url); }
/** * Execute the console command. * * @return mixed */ public function handle() { $this->info($this->argument('room')); $room = Room::find($this->argument('room')); $room->heatingsince = Carbon::now(); $room->save(); $process = new Process('php /var/www/artisan temperatures:check'); $process->run(); }
/** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response */ public function update(Request $request, $buildingId, $roomId) { $this->validate($request, ['name' => 'required|max:255', 'room_sn' => 'required|max:255', 'water_degree' => 'required|numeric', 'electric_degree' => 'required|numeric'], ['required' => 'The :attribute field is required', 'numeric' => 'The :attribute field must be numeric', 'max' => 'The length of :attribute can not bigger than 255']); // $room = Room::find($roomId); $input = $request->all(); $room->fill($input); if (!$room->save()) { abort(500, 'Could not save building'); } return $room; }
public function update($roomId) { $request = json_decode(request()->getContent()); $rules = array('name' => 'required', 'capacity' => 'required', 'status' => 'required'); $validation = Validator::make((array) $request, $rules); if ($validation->fails()) { return response()->json(array('error' => true, 'message' => $validation->errors()->all(), 200)); } $room = Room::find($roomId); $room->name = $request->name; $room->capacity = abs($request->capacity); $room->status = $request->status; $updated = $room->save(); return response()->json(array('error' => !$updated, 'rooms' => $room->toArray()), $updated ? 200 : 500); }
public function updateRoom(Request $request, $number) { $room = Room::find($number); if (!$room) { return response('Pokój nie został odnaleziony.', 404)->header('Content-Type', 'text/html; charset=utf-8'); } if ($request->input('number')) { $room->number = $request->input('number'); } if ($request->input('capacity')) { $room->capacity = $request->input('capacity'); } $room->save(); return response()->json($room); }
/** * Get the validation rules that apply to the request. * * @return array */ public function rules() { $room = Room::find($this->rooms); switch ($this->method()) { case 'GET': case 'DELETE': return []; case 'POST': return ['building_id' => 'required|integer', 'code' => 'required|unique:rooms|max:20', 'name' => 'required|max:254', 'capacity' => 'integer|min:5']; case 'PUT': case 'PATCH': return ['building_id' => 'required|integer', 'code' => "required|unique:rooms,code,{$room->id}|max:20", 'name' => 'required|max:254', 'capacity' => 'integer|min:5']; default: break; } }
/** * Store a newly created resource in storage. * * @return Response */ public function store(Request $request) { $input = $request->all(); $currentOccupants = []; $rooms = Room::all(); $reservations_count = Reservation::where('room_id', $input['room_id'])->where('status', 'accepted')->where('start_date', '<=', [$input['start_date']])->where('end_date', '>=', [$input['end_date']])->count(); $room = Room::find($input['room_id']); foreach ($rooms as $index => $roomz) { $currentOccupants[$index] = Reservation::where('room_id', $roomz->id)->where('status', 'accepted')->where('start_date', '<=', [$input['start_date']])->where('end_date', '>=', [$input['end_date']])->count(); } $all_table = Room::where('availability', 'vacant')->get(); if ($reservations_count == $room->pax) { return view('reservations.error')->with(compact('input', 'all_table', 'currentOccupants')); } $person = new Person(); $person->unique_id = $this->quickRandom(); $person->first_name = $request->input('first_name'); $person->last_name = $request->input('last_name'); $person->address = $request->input('address'); $person->email = $request->input('email'); $person->phone = $request->input('phone'); if ($person->save()) { $reservation = new Reservation(); $reservation->person_id = $person->id; $reservation->status = Reservation::STATUS_PENDING; $reservation->price = Room::find((int) $request->input('room_id'))->price; $reservation->notes = $request->input('notes'); $reservation->start_date = $request->input('start_date'); $reservation->end_date = $request->input('end_date'); $reservation->room_id = (int) $request->input('room_id'); if ($reservation->save()) { return view('reservations.confirmation'); //TODO redirect to a page with success message } else { return 'Fail reservation'; //TODO redirect to a page with error message } } else { return 'Fail Person'; //TODO redirect to a page with error message } }
public function updateTimeoff(Request $request, $number) { $timeoff = Timeoff::find($number); if (!$timeoff) { return response('Przerwa techniczna nie została odnaleziona.', 404)->header('Content-Type', 'text/html; charset=utf-8'); } if ($request->input('room_id') && !Room::find($request->input('room_id'))) { return response('Pokój, któgo przerwa dotyczy nie istnieje w bazie.', 500); } if ($request->input('room_id')) { $timeoff->room_id = $request->input('room_id'); } if ($request->input('since')) { $timeoff->since = $request->input('since'); } if ($request->input('till')) { $timeoff->till = $request->input('till'); } $timeoff->save(); return response()->json($timeoff); }
/** * Remove the specified resource from storage. * * @param int $id * @return \Illuminate\Http\Response */ public function destroy($id, Request $request) { $this->validate($request, ['room_id' => 'required|numeric', 'water_degree' => 'required|numeric', 'electric_degree' => 'required|numeric'], ['required' => 'The :attribute field is required', 'numeric' => 'The :attribute field must be numeric']); $deleteInput = $request->all(); $room = Room::find($deleteInput['room_id']); $contract = Contract::find($id); $feeplancount = FeePlan::where("rent_id", $id)->where('status', 0)->count(); if ($feeplancount > 0) { $ret['status'] = -1; $ret['desc'] = '该租户还有欠款为付清,无法终止合同。如中途退出,请联系主管,先走特殊费用终止流程!'; return $ret; } else { try { DB::beginTransaction(); $room['water_degree'] = $deleteInput['water_degree']; $room['electric_degree'] = $deleteInput['electric_degree']; if (!$room->save()) { abort(500, 'Destroy failed'); } $contract['end_water_degree'] = $deleteInput['water_degree']; $contract['end_electric_degree'] = $deleteInput['electric_degree']; $realendtime = new \DateTime(); $realEndTimeStr = $realendtime->format('Y-m-d'); $contract['real_end_time'] = $realEndTimeStr; if (!$contract->save()) { abort(500, 'Destroy failed'); } DB::commit(); } catch (Exception $exception) { DB::rollBack(); abort(500, 'Destroy failed'); } $ret['status'] = Contract::destroy($id); return $ret; } }
public function store_class(Requests\CreateClassFormRequest $request) { if ($request->id == -1) { $class = new StudyClass(); } else { $class = StudyClass::find($request->id); } $class->datestart = date('Y-m-d', strtotime($request->datestart)); $class->name = $request->name; $class->room_id = $request->room_id; $class->base_id = Room::find($class->room_id)->base->id; $class->description = $request->description; $class->gen_id = $request->gen_id; $class->target = $request->target; $class->regis_target = $request->regis_target; $class->course_id = $request->course_id; $class->teaching_assistant_id = $request->teaching_assistant_id; $class->teacher_id = $request->teacher_id; $class->study_time = $request->study_time; $class->status = $request->status == null ? 0 : 1; $class->save(); return redirect('manage/classes'); }
/** * Responds to requests to POST /rooms/delete/ */ public function postDoDelete(Request $request) { $this->validate($request, ['delete_id' => 'required|integer']); $user = \Auth::user(); $delete_room = \App\Room::find($request->delete_id); $reservations = \App\Reservation::where('room_id', $delete_room->id)->get(); $timeslots = \App\Timeslot::where('room_id', $delete_room->id)->get(); if ($user->user_role == 'admin') { foreach ($reservations as $reservation) { $reservation->delete(); } foreach ($timeslots as $timeslot) { $timeslot->delete(); } $delete_room->delete(); \Session::flash('flash_message', $delete_room->room_name . ' has been deleted.'); return redirect('/rooms'); } else { \Session::flash('flash_message', 'You don't have the previlege to delete this room.'); return redirect('/rooms'); } }
/** * Update the specified resource in storage. * * @param int $id * @return Response */ public function update($id) { // $v = Validator::make(Request::all(), ['name' => 'required|max:50', 'spot_id' => 'required', 'event_id' => 'required']); if ($v->fails()) { return redirect()->back()->withErrors($v->errors())->withInput(); } else { $id = Request::get('id'); $room = Room::find($id); $room->name = Request::get('name'); $room->desc = Request::get('desc'); $room->spot_id = Request::get('spot_id'); $room->event_id = Request::get('event_id'); $room->save(); return redirect('rooms'); } }
/** * save room update details * * @param Request $request */ public function admin_save_room_update_details(Request $request) { $room = Room::find($request->input('id')); $room->room_num = $request->input('rnum'); $room->room_size = $request->input('rsize'); //$room->sequence_num = $request->input('max'); $room->room_type_id = $request->input('rtype'); $room->status = $request->input('rstatus'); $room->remarks = $request->input('rremarks'); $room->save(); }
public static function saveCustomerReservationDetails($data) { //dd($data->all()); $getReferenceNumber = new Reservation(); $rooms = explode(',', $data->get('rooms')); $customer = Customer::whereEmail($data->get('email'))->first(); $total_capacity = 0; $total_person = $data->get('no_of_adult') + $data->get('no_of_child'); foreach ((array) $rooms as $rm) { $rms = Room::find($rm); $categories = Category::find($rms->category_id); if (count($categories) > 0) { $total_capacity += $categories->max_capacity; } } if ($total_capacity < $total_person) { return redirect()->back()->with('message', 'You exceeded the max capacity of the rooms'); } else { if (count($customer) == 0) { $customer = new Customer(); $customer->name = ucfirst(strtolower($data->get('first_name'))) . ' ' . ucfirst(strtolower($data->get('last_name'))); $customer->address = $data->get('address'); $customer->email = $data->get('email'); $customer->contact_number = $data->get('contact'); if ($customer->save()) { $reservation = new Reservation(); $reservation->customer_id = $customer->id; $reservation->reference_number = $getReferenceNumber->getReservationId(); $reservation->no_of_child = $data->get('no_of_child'); $reservation->no_of_adult = $data->get('no_of_adult'); $reservation->period = $data->get('period'); $reservation->status = 'RESERVED'; if ($reservation->save()) { foreach ((array) $rooms as $room) { $start_date = $data->get('start_date'); $end_date = $data->get('end_date'); # ROOM VISITOR $start_date = date("Y-m-d", strtotime($start_date)); while (strtotime($start_date) < strtotime($end_date)) { $reservation_room = new ReservationRoom(); $reservation_room->reservation_id = $reservation->id; $reservation_room->room_id = $room; $reservation_room->date_reserved = $start_date; $reservation_room->save(); $start_date = date("Y-m-d", strtotime("+1 day", strtotime($start_date))); } } } } Mail::send('emails.reservation_reference', ['customer' => $customer, 'reservation' => $reservation], function ($m) use($customer) { $m->from('*****@*****.**', 'Overlook Resort (noreply)'); $m->to($customer->email, $customer->full_name())->subject('Here\'s your RESERVATION ID'); }); return redirect()->back()->with('message', 'Reservation was successful. We sent your reservation reference in your e-mail'); } $reservation = new Reservation(); $reservation->customer_id = $customer->id; $reservation->reference_number = $reservation->getReservationId(); $reservation->no_of_child = $data->get('no_of_child'); $reservation->no_of_adult = $data->get('no_of_adult'); $reservation->period = $data->get('period'); $reservation->status = 'Not Paid'; if ($reservation->save()) { foreach ((array) $rooms as $room) { $start_date = $data->get('start_date'); $end_date = $data->get('end_date'); # ROOM VISITOR $start_date = date("Y-m-d", strtotime($start_date)); while (strtotime($start_date) < strtotime($end_date)) { $reservation_room = new ReservationRoom(); $reservation_room->reservation_id = $reservation->id; $reservation_room->room_id = $room; $reservation_room->date_reserved = $start_date; $reservation_room->save(); $start_date = date("Y-m-d", strtotime("+1 day", strtotime($start_date))); } } } Mail::send('emails.reservation_reference', ['customer' => $customer, 'reservation' => $reservation], function ($m) use($customer) { $m->from('*****@*****.**', 'Overlook Resort (noreply)'); $m->to($customer->email, $customer->full_name())->subject('Here\'s your RESERVATION ID'); }); return redirect()->back()->with('message', 'Reservation was successful. We sent your reservation reference in your e-mail'); } }
public function enregistrer() { if (\Request::ajax()) { $salle_id = \Input::get('salle_id'); $color = \Input::get('color'); $time = \Input::get('time'); $dayname = \Input::get('dayname'); $cr_id = \Input::get('cr_id'); $mat = \Input::get('matiere'); $matiere_id = \Input::get('matiere_id'); $ts = Timesheet::where('time', $time)->where('dayname', $dayname)->where('classroom_id', $cr_id)->where('user_id', \Auth::user()->id)->where('matter_id', '!=', 0)->first(); if (isset($salle_id) && !empty($salle_id)) { if ($ts) { $room = Room::find($salle_id); $yes = DB::table('matter_room')->where('matter_id', $ts->matter_id)->where('room_id', $salle_id)->first(); if (!$yes) { $room->matters()->attach([$ts->matter_id]); } } } $livingDaylights = ['lundi', 'mardi', 'mercredi', 'jeudi', 'vendredi', 'samedi']; $times = ['08:00:00', '09:00:00', '10:00:00', '11:00:00', '12:00:00', '13:00:00', '14:00:00', '15:00:00', '16:00:00', '17:00:00']; if ($dayname == 'lundi') { $ts = new Timesheet(); $ts->lundi = $dayname; $ts->classroom_id = $cr_id; $ts->user_id = \Auth::user()->id; $ts->time = $time; $ts->matiere = $mat; $ts->matter_id = $matiere_id; $ts->color = $color; $ts->dayname = $dayname; $ts->room_id = $salle_id ?: 0; $ts->school_year_id = SchoolYear::getSchoolYearId(); $ts->save(); } elseif ($dayname == 'mardi') { $ts = new Timesheet(); $ts->mardi = $dayname; $ts->classroom_id = $cr_id; $ts->user_id = \Auth::user()->id; $ts->time = $time; $ts->matiere = $mat; $ts->matter_id = $matiere_id; $ts->color = $color; $ts->dayname = $dayname; $ts->room_id = $salle_id ?: 0; $ts->school_year_id = SchoolYear::getSchoolYearId(); $ts->save(); } elseif ($dayname == 'mercredi') { $ts = new Timesheet(); $ts->mercredi = $dayname; $ts->classroom_id = $cr_id; $ts->user_id = \Auth::user()->id; $ts->time = $time; $ts->matiere = $mat; $ts->matter_id = $matiere_id; $ts->color = $color; $ts->dayname = $dayname; $ts->room_id = $salle_id ?: 0; $ts->school_year_id = SchoolYear::getSchoolYearId(); $ts->save(); } elseif ($dayname == 'jeudi') { $ts = new Timesheet(); $ts->jeudi = $dayname; $ts->classroom_id = $cr_id; $ts->user_id = \Auth::user()->id; $ts->time = $time; $ts->matiere = $mat; $ts->matter_id = $matiere_id; $ts->color = $color; $ts->dayname = $dayname; $ts->room_id = $salle_id ?: 0; $ts->school_year_id = SchoolYear::getSchoolYearId(); $ts->save(); } elseif ($dayname == 'vendredi') { $ts = new Timesheet(); $ts->vendredi = $dayname; $ts->classroom_id = $cr_id; $ts->user_id = \Auth::user()->id; $ts->time = $time; $ts->matiere = $mat; $ts->matter_id = $matiere_id; $ts->color = $color; $ts->dayname = $dayname; $ts->room_id = $salle_id ?: 0; $ts->school_year_id = SchoolYear::getSchoolYearId(); $ts->save(); } elseif ($dayname == 'samedi') { $ts = new Timesheet(); $ts->samedi = $dayname; $ts->classroom_id = $cr_id; $ts->user_id = \Auth::user()->id; $ts->time = $time; $ts->matiere = $mat; $ts->matter_id = $matiere_id; $ts->color = $color; $ts->dayname = $dayname; $ts->room_id = $salle_id ?: 0; $ts->school_year_id = SchoolYear::getSchoolYearId(); $ts->save(); } } }
/** * Responds to requests to GET /reservation/create */ public function getCreate($room_id) { $rooms_for_dropdown = \App\Room::roomsForDropdown(); $room = \App\Room::find($room_id); return view('reservations.create')->with('rooms_for_dropdown', $rooms_for_dropdown)->with('room', $room); }