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())