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 create_reservation():
guest_id = request.form['guest_id']
guest = guest_repository.select(guest_id)
room = room_repository.select_default()
arrival_date = request.form['arrival_date']
departure_date = request.form['departure_date']
status = request.form['status']
new_reservation = Reservation(guest, room, arrival_date, departure_date, status)
reservation_repository.save(new_reservation)
reservation_repository.arrival_status()
return redirect('/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 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 guest_preferences(id):
guest = guest_repository.select(id)
return render_template('guests/preference.html', guest=guest)
def delete_guest(id):
guest = guest_repository.select(id)
return render_template('guests/delete.html', guest=guest)
def edit_guest(id):
guest = guest_repository.select(id)
return render_template('guests/edit.html', guest=guest)
def check_in(id):
reservation = reservation_repository.select(id)
guest = guest_repository.select(reservation.guest.id)
rooms = room_repository.select_available()
stay_length = reservation_repository.stay_length(id)
return render_template('reservations/checkin.html', reservation=reservation, guest= guest, rooms=rooms, stay_length=stay_length)
def delete_reservation(id):
reservation = reservation_repository.select(id)
guest = guest_repository.select(reservation.guest.id)
return render_template('reservations/delete.html', reservation=reservation, guest= guest)