def roomExists(myid): ''' Checks to see if the roomID corresponds to a valid room Returns True if the roomID exists, else False. ''' if getRoomByID(myid): return True return False
def checkout(self): if self.status == CONST.checkedout_status: return True else: myroom = getRoomByID(self.roomID) self.status = CONST.checkedout_status db.session.commit() myroom.set_status(CONST.unclean_status) return True
def checkin(self): if self.status == CONST.checkedin_status: return True else: myroom = getRoomByID(self.roomID) if myroom.status != CONST.ready_status: return False else: self.status = CONST.checkedin_status db.session.commit() myroom.set_status(CONST.occupied_status) return True
def page_reservation_wizard_3():
'''
Updates the reservation with the selected room.
Asks for the guest information
'''
formdata = request.form
res = getReservationByID(int(formdata['resID']))
room = getRoomByID(int(formdata['roomID']))
res.setRoom(room=room)
buildingName = getBuildingById(room.get_building_id()).get_name()
from RoomReserve.admin.guestsearch import form_SearchGuest
guestSearchForm = form_SearchGuest()
from RoomReserve.admin.guest import form_CreateGuest
createGuestForm = form_CreateGuest()
return render('reswizard/wizard3.html', guestSearchForm=guestSearchForm,\
room=getRoomByID(res.getRoomID()), buildingName=buildingName, resID=res.getID())
def page_create_all():
try:
db.drop_all()
db.create_all()
createDefaultAccounts()
db.session.add(Building(name="Miller", numfloors=8, status=CONST.ready_status, description="Contains numerous two person rooms and two elevators.", notes="This building is available for the summer."))
db.session.add(Building(name="Dieseth", numfloors=8, status=CONST.ready_status, description="Contains numerous two person rooms and a single elevator.", notes="This building is available for the summer."))
db.session.add(Building(name="Brandt", numfloors=5, status=CONST.ready_status, description="First year hall that has both three person and two person rooms.", notes="This building is used for parents for graduation and some camps."))
db.session.add(Building(name="Farwell", numfloors=8, status=CONST.ready_status, description="Rooms are set up and organized around central rooms.", notes="This building is available for the summer school students."))
db.session.add(Building(name="Larsen", numfloors=4, status=CONST.inactive_status, description="Larsen has heaters in each room and contains a wardrobe in each room as well.", notes="This building is unavailable."))
db.session.add(Building(name="Ylvisaker", numfloors=5, status=CONST.ready_status, description="First year hall that has numerous two person rooms. The hallways are a bit smaller here.", notes="This building is available for the summer."))
db.session.add(Building(name="Olson", numfloors=3, status=CONST.ready_status, description="Olson has many two person rooms and suites that are two person rooms with a central room between those two.", notes="This building is available for the summer."))
db.session.commit()
for j in range(1, 16):
db.session.add(Room(roomnumber= j, buildingID='3', capacity='2', description="Room in Brandt", status=CONST.ready_status, notes="Groud Floor"))
for i in range(1, 9):
for j in range(1, 31):
db.session.add(Room(roomnumber=(i * 100 + j), buildingID='1', capacity='2', description="Room in Miller", status=CONST.ready_status, notes=""))
db.session.add(Room(roomnumber=(i * 100 + j), buildingID='2', capacity='2', description="Room in Dieseth", status=CONST.ready_status, notes=""))
db.session.add(Room(roomnumber=(i * 100 + j), buildingID='4', capacity='2', description="Room in Farwell", status=CONST.ready_status, notes=""))
if i < 5:
db.session.add(Room(roomnumber=(i * 100 + j), buildingID='3', capacity='2', description="Room in Brandt", status=CONST.ready_status, notes=""))
db.session.add(Room(roomnumber=(i * 100 + j + 30), buildingID='3', capacity='3', description="Room in Brandt", status=CONST.ready_status, notes="Three person room"))
db.session.add(Room(roomnumber=(i * 100 + j), buildingID='5', capacity='2', description="Room in Larsen", status=CONST.inactive_status, notes=""))
if i != 4:
db.session.add(Room(roomnumber=(i * 100 + j), buildingID='7', capacity='4', description="Room in Olson", status=CONST.ready_status, notes=""))
db.session.add(Room(roomnumber=(i * 100 + j), buildingID='6', capacity='2', description="Room in Ylvi", status=CONST.ready_status, notes=""))
db.session.commit()
fnlist = ["Bruce", "Tom", "Harry", "David", "Henry", "Thomas", "Isaac", "Katie", "Susan", "Peter", "Kelly", "Emilay", "Alahna", "Morgan", "Neil", "Kierra", "Leah", "Lucia", "Marissa", "Melissa", "Aidan"]
lnlist = ["Bennett", "Dhondup", "Stekel", "Miller", "Lee", "Ranum", "Newton", "Smith", "Brown", "Davidson", "Robinson", "Schroeder", "Keil", "Mortenson", "Anderson", "Blackstad", "Williams", "Holte", "Wales", "Hrdlicka", "Cook"]
hatlist = ["Beanie", "Coonskin Hat", "Top Hat", "Sombrero", "Trucker Hat"]
for i in range(0, len(fnlist)):
for j in range(0, len(lnlist)):
db.session.add(Guest(fnlist[i], lnlist[j], lnlist[j][:4].lower() + fnlist[i][:2].lower() + "*****@*****.**", "563" + "-" + str(495-i*7) + "-" + str(9321 - j*17), str(i*100 + j * 10 + j%10) + " College Drive, Decorah IA", payment=(i * 10 + j), notes="Wears a " + hatlist[i%len(hatlist)]))
#still need to add reservations
db.session.commit()
from RoomReserve.admin.rooms import getRoomByID
myiter = 0
for i in range(1, len(fnlist)*len(lnlist)):
#change the month below to 5 for when we present
myiter += 1
while getRoomByID(myiter).status == CONST.inactive_status:
myiter += 1
x = int(i%20+1)
mydate = date(2016, 5, x)
mydate2 = mydate + timedelta(days=(randint(1, 30)))
if datetime.today().date() < mydate:
mystatus = CONST.ready_status
else:
if datetime.today().date() < mydate2:
mystatus = CONST.checkedin_status
getRoomByID(myiter).set_status(CONST.occupied_status)
else:
mystatus = CONST.checkedout_status
getRoomByID(myiter).set_status(CONST.unclean_status)
db.session.add(Reservation(i , 1, myiter, mydate, mydate2, mystatus, "Beds need lofting."))
db.session.commit()
return redirect(url_for("page_rooms"))
except:
print("Hit the except statement")
return render("basic.html", content=str(traceback.format_exc()).replace('\n', '<br>'))
def get_room(self): return getRoomByID(self.getRoomID())
