def confirm(id): room_id = request.form['room_id'] assigned_room = room_repository.select(room_id) reservation_repository.update_room(assigned_room, id) room_repository.capacity_in(id) reservation_repository.check_in(id) return redirect('/reservations')
def select(id): reservation = None sql = "SELECT * FROM reservations WHERE id = %s" values = [id] result = run_sql(sql, values)[0] if result is not None: guest = guest_repository.select(result['guest_id']) room = room_repository.select(result['room_id']) reservation = Reservation(guest, room, result['arrival_date'], result['departure_date'], result['status'], result['id']) return reservation
def select_all(): reservations = [] sql = "SELECT * FROM reservations ORDER BY status ASC, arrival_date" results = run_sql(sql) for row in results: guest = guest_repository.select(row['guest_id']) room = room_repository.select(row['room_id']) reservation = Reservation(guest, room, row['arrival_date'], row['departure_date'], row['status'], row['id']) reservations.append(reservation) return reservations
def in_house(): reservations = [] sql = "SELECT * FROM reservations WHERE status = %s ORDER BY departure_date, room_id" values = ["Checked In"] results = run_sql(sql, values) for row in results: guest = guest_repository.select(row['guest_id']) room = room_repository.select(row['room_id']) reservation = Reservation(guest, room, row['arrival_date'], row['departure_date'], row['status'], row['id']) reservations.append(reservation) return reservations
def arrivals(): reservations = [] sql = "SELECT * FROM reservations WHERE arrival_date = %s AND status = %s ORDER BY arrival_date ASC" values = [datetime.date.today(), "Arrival"] results = run_sql(sql, values) for row in results: guest = guest_repository.select(row['guest_id']) room = room_repository.select(row['room_id']) reservation = Reservation(guest, room, row['arrival_date'], row['departure_date'], row['status'], row['id']) reservations.append(reservation) return reservations
def select_from_today(date): reservations = [] sql = "SELECT * FROM reservations WHERE arrival_date >= %s ORDER BY arrival_date, status ASC" values = [date] results = run_sql(sql, values) for row in results: guest = guest_repository.select(row['guest_id']) room = room_repository.select(row['room_id']) reservation = Reservation(guest, room, row['arrival_date'], row['departure_date'], row['status'], row['id']) reservations.append(reservation) return reservations
def select(id): schedule = None sql = "SELECT * FROM schedules WHERE id = %s" values = [id] result = run_sql(sql, values)[0] if result is not None: instructor = instructor_repository.select(result['instructor_id']) gym_class = gym_class_repository.select(result['class_id']) room = room_repository.select(result['room_id']) schedule = Schedule(result['class_date'], result['start_time'], result['length_mins'], instructor, gym_class, room, result['id']) return schedule
def select_all(): schedules = [] sql = "SELECT * FROM schedules ORDER BY class_date" results = run_sql(sql) for row in results: instructor = instructor_repository.select(row['instructor_id']) gym_class = gym_class_repository.select(row['class_id']) room = room_repository.select(row['room_id']) schedule = Schedule(row['class_date'], row['start_time'], row['length_mins'], instructor, gym_class, room, row['id']) schedules.append(schedule) return schedules
def update_reservation(id): guest_id = request.form['guest_id'] guest = guest_repository.select(guest_id) room_id = request.form['room_id'] room = room_repository.select(room_id) arrival_date = request.form['arrival_date'] departure_date = request.form['departure_date'] status = request.form['status'] updated_reservation = Reservation(guest, room, arrival_date, departure_date, status, id) reservation_repository.update(updated_reservation) reservation_repository.arrival_status() return redirect('/reservations')
def add_schedule(): class_date = request.form['class_date'] start_time = request.form['start_time'] length_mins = request.form['length_mins'] instructor_id = request.form['instructor_id'] class_id = request.form['class_id'] room_id = request.form['room_id'] instructor = details_repository.select(instructor_id) gym_class = gym_class_repository.select(class_id) room = room_repository.select(room_id) schedule = Schedule(class_date, start_time, length_mins, instructor, gym_class, room, id) schedule_repository.save(schedule) return redirect('/schedule')
def select_dates(): schedules_list = [] sql = "SELECT * FROM schedules WHERE class_date = %s ORDER BY start_time" for index in range(7): schedules = [] values = [date.today() + timedelta(days=index)] results = run_sql(sql, values) if results is not None: for row in results: instructor = instructor_repository.select(row['instructor_id']) gym_class = gym_class_repository.select(row['class_id']) room = room_repository.select(row['room_id']) schedule = Schedule(row['class_date'], row['start_time'], row['length_mins'], instructor, gym_class, room, row['id']) schedules.append(schedule) else: schedule = None schedules.append(schedule) schedules_list.append(schedules) return schedules_list
def delete_room(id): room = room_repository.select(id) return render_template('rooms/delete.html', room=room)
def update_room(id): number = request.form['number'] cap = room_repository.select(id) updated_room = Room(number, cap.remaining_capacity, id) room_repository.update(updated_room) return redirect('/rooms')
def edit_room(id): room = room_repository.select(id) return render_template('rooms/edit.html', room=room)