def newcustomer(): if checkSession() == False: return redirect ('login') if request.form.get('First') is None: u = userList() u.set('First','') u.set('Last','') u.set('Email','') u.set('Password','') u.set('Type','') u.add() return render_template('newcustomer.html', title='New Customer',user=u.data[0]) else: u = userList() u.set('First',request.form.get('First')) u.set('Last',request.form.get('Last')) u.set('Email',request.form.get('Email')) u.set('Password',request.form.get('Password')) u.set('Type',request.form.get('Type')) u.add() if u.verifyNew(): u.insert() print(u.data) return render_template('savedcustomer.html', title='Customer Saved',user=u.data[0]) else: return render_template('newcustomer.html', title='Customer Not Saved',user=u.data[0],msg=u.errorList)
def newusercustomer(): #customer facing if request.form.get('userFName') is None: u = userList() u.set('userFName', '') u.set('userLName', '') u.set('userEmail', '') u.set('userPassword', '') u.set('userType', '') u.add() return render_template('user/newusercustomer.html', title='New User', user=u.data[0]) else: u = userList() u.set('userFName', request.form.get('userFName')) u.set('userLName', request.form.get('userLName')) u.set('userEmail', request.form.get('userEmail')) u.set('userPassword', request.form.get('userPassword')) u.set('userType', 'customer') u.add() if u.verifyNew(): u.insert() print(u.data) return render_template('user/saveduser.html', title='User Saved', user=u.data[0]) else: return render_template('user/newusercustomer.html', title='User Not Saved', user=u.data[0], msg=u.errorList)
def newuser(): if checkSession() == False: return redirect('login') if request.form.get('fname') is None: u = userList() u.set('fname', '') u.set('lname', '') u.set('email', '') u.set('password', '') u.set('subscribed', '') u.add() return render_template('newUser.html', title='New User', user=u.data[0]) else: u = userList() u.set('fname', request.form.get('fname')) u.set('lname', request.form.get('lname')) u.set('email', request.form.get('email')) u.set('password', request.form.get('password')) u.set('subscribed', request.form.get('subscribed')) u.add() if u.verifyNew(): u.insert() print(u.data) return render_template('saveduser.html', title='User Saved', user=u.data[0]) else: return render_template('newuser.html', title='User Not Saved', user=u.data[0], msg=u.errorList)
def newcontract(): # allow admin to create a new contract between a tenant and unit/landlord if checkAccess('admin') == True: # get list of tenants t = userList() t.getByField('Type', 'tenant') # get list of availible units u = unitList() u.getByField('HasRoom', 1) if request.form.get('MonthlyCharge') is None: # form unfilled, render with defaults c = contractList() c.set('StartDate', date.today().isoformat()) c.set('EndDate', date.today().isoformat()) c.set('MonthlyCharge', 0.0) c.set('Active', 1) c.set('TUserName', '') c.set('LUserName', '') c.set('TenantID', 0) c.set('LandlordID', 0) c.set('UID', 0) c.add() return render_template('newcontract.html', title="New Contract", contract=c.data[0], tenants=t.data, units=u.data) else: # form filled, get values c = contractList() u1 = unitList() u1.getById(request.form.get('UID')) t1 = userList() t1.getById(request.form.get('TenantID')) l1 = userList() l1.getById(u1.data[0]['LandlordID']) c.set('StartDate', request.form.get('StartDate')) c.set('EndDate', request.form.get('EndDate')) c.set('MonthlyCharge', float(request.form.get('MonthlyCharge'))) c.set('Active', 1) c.set('TUserName', t1.data[0]['Username']) c.set('LUserName', l1.data[0]['Username']) c.set('TenantID', request.form.get('TenantID')) c.set('LandlordID', u1.data[0]['LandlordID']) c.set('UID', request.form.get('UID')) c.add() if c.verifyNew(): # check values for new contract, if valid insert into db and redirect to contracts page c.insert() session['msg'] = 'Contract Saved.' return redirect(url_for('acontracts')) else: return render_template('newcontract.html', title='Contract Not Saved', contract=c.data[0], tenants=t.data, units=u.data) else: return redirect(url_for('home'))
def verifyNew(self,n=0): self.errorList = [] e = eventList() EventID = self.data[n]['EventID'] e.getById(EventID) EventName = e.data[0]['EventName'] u = userList() UserID = self.data[n]['UserID'] u.getById(UserID) UserFName = u.data[0]['UserFName'] UserLName = u.data[0]['UserLName'] comment = UserFName + ' ' + UserLName + '\'s record for' + ' ' + EventName + '\n' + 'Comment: ' if len(self.data[n]['UserEvaluation']) == 0: self.errorList.append("Evaluation body cannot be blank.") else: self.data[n]['UserEvaluation'] = comment + self.data[n]['UserEvaluation'] if len(self.errorList) > 0: return False else: return True
def login(): #check login #set session #redirect to menu #check session on login pages if request.form.get('email') is not None and request.form.get( 'password') is not None: u = userList() if u.tryLogin(request.form.get('email'), request.form.get('password')): print('login successful') session['user'] = u.data[0] session['active'] = time.time() if session['user']['userType'] == 'customer': return redirect('main') elif session['user']['userType'] == 'employee': return redirect('mainadmin') else: print('login failed') return render_template('login.html', title='Login', msg='Incorrect credentials') else: if 'msg' not in session.keys() or session['msg'] is None: m = 'Type your email and password to continue' else: m = session['msg'] session['msg'] = None return render_template('login.html', title='Login', msg=m)
def login(): if request.form.get('email') is not None and request.form.get( 'password') is not None: u = userList() if u.tryLogin(request.form.get('email'), request.form.get('password')): #print('Login Okay') session['user'] = u.data[0] session['active'] = time.time() o = orderList() o.getLast(session['user']['id']) if len(o.data) > 0: session['orderid'] = o.data[0]['oid'] else: now = datetime.now() o.set('createtime', str(now)) o.set('status', 'shopping') o.set('userid', session['user']['id']) o.add() o.insert() session['orderid'] = o.data[0]['oid'] print('oid', session['orderid']) return redirect('main') else: #print('Login Failed') return render_template('login.html', title='Login', msg='Incorrect username or password.') else: if 'msg' not in session.keys() or session['msg'] is None: m = 'Type your email and password to continue.' else: m = session['msg'] session['msg'] = None return render_template('login.html', title='Login', msg=m)
def newattendance(): if checkSession() == False: return redirect('login') allEvents = eventList() allEvents.getAll() allUsers = userList() allUsers.getAll() if request.form.get('UserEvaluation') is None: a = attendanceList() a.set('EventID','') a.set('UserID','') a.set('AttendanceStatus','') a.set('UserEvaluation','') a.add() return render_template('attendance/newattendance.html', title='New Attendance', attendance=a.data[0],el=allEvents.data,ul=allUsers.data) else: a = attendanceList() a.set('AttendanceID',request.form.get('AttendanceID')) a.set('EventID',request.form.get('EventID')) a.set('UserID',request.form.get('UserID')) a.set('AttendanceStatus',request.form.get('AttendanceStatus')) a.set('UserEvaluation',request.form.get('UserEvaluation')) a.add() if a.verifyNew(): a.insert() print(a.data) return render_template('attendance/savedattendance.html', title='Attendance Saved', attendance=a.data[0]) else: return render_template('attendance/newattendance.html', title='Attendance Not Saved', attendance=a.data[0],msg=a.errorList,el=allEvents.data,ul=allUsers.data)
def newissuedequipment(): if checkSession() == False: return redirect('login') allEquipment = equipmentList() allEquipment.getAll() allUsers = userList() allUsers.getAll() if request.form.get('EquipmentStatus') is None: i = issuedEquipmentList() i.set('EquipmentID','') i.set('UserID','') i.set('IssueDate','') i.set('ReturnDate','') i.set('DateReturned','') i.set('DateReplaced','') i.set('EquipmentStatus','') i.add() return render_template('issuedequipment/newissuedequipment.html', title='New Issued Equipment', issuedequipment=i.data[0],il=allEquipment.data,ul=allUsers.data) else: i = issuedEquipmentList() i.set('IssuedEquipmentID',request.form.get('IssuedEquipmentID')) i.set('EquipmentID',request.form.get('EquipmentID')) i.set('UserID',request.form.get('UserID')) i.set('IssueDate',request.form.get('IssueDate')) i.set('ReturnDate',request.form.get('ReturnDate')) i.set('DateReturned',request.form.get('DateReturned')) i.set('DateReplaced',request.form.get('DateReplaced')) i.set('EquipmentStatus',request.form.get('EquipmentStatus')) i.add() if i.verifyNew(): i.insert() return render_template('issuedequipment/savedissuedequipment.html', title='Issued Equipment Saved', issuedequipment=i.data[0]) else: return render_template('issuedequipment/newissuedequipment.html', title='Issued Equipment Not Saved', issuedequipment=i.data[0],msg=i.errorList,il=allEquipment.data,ul=allUsers.data)
def login(): ''' -check login -set session -redirect to menu -check session on login pages ''' print('-------------------------') if request.form.get('email') is not None and request.form.get('password') is not None: # if the form has been filled out, try login u = userList() if u.tryLogin(request.form.get('email'),request.form.get('password')): # if login is successful, set session and redirect to home session['UserID'] = u.data[0]['UserID'] session['Username'] = u.data[0]['Username'] session['active'] = time.time() session['access'] = u.data[0]['Type'] return redirect(url_for('home')) else: # if unsuccessful, display login page again return render_template('login.html', title='Login', msg='Incorrect login.') else: # if the login form has not been filled out, display login page if 'msg' not in session.keys() or session['msg'] is None: m = 'Type your email and password to continue.' else: m = session['msg'] session['msg'] = None return render_template('login.html', title='Login', msg=m)
def login(): ''' -check login -set session -redirect to menu -check session on login pages ''' print('-------------------------') email = request.form.get('email') password = request.form.get('password') if email != None and password != None: users = userList() is_ok, user_data = users.tryLogin(email, password) if is_ok: print('login ok') session['user'] = user_data session['active'] = time.time() return redirect('main') else: print('login failed') return render_template('login.html', title='Login', msg='Incorrect login.') else: if 'msg' not in session.keys() or session['msg'] is None: m = 'Type your email and password to continue.' else: m = session['msg'] session['msg'] = None return render_template('login.html', title='Login', msg=m)
def landlords(): # if user is admin, display list of all landlords if checkAccess('admin') == True: u = userList() u.getByField('type', 'landlord') return render_template('users.html', title='Landlords', users=u.data) else: return redirect(url_for('home'))
def deleteuser(): if checkSession() == False: return redirect('login') u = userList() u.deleteByID(request.form.get('id')) return render_template('deletedUser.html', title='User Deleted', msg='User deleted.')
def users(): if checkSession() == False: return redirect('login') u = userList() u.getAll() print(u.data) return render_template('users.html', title='User List', users=u.data)
def deleteuser(): if checkSession() == False: return redirect('login') print("ID:",request.form.get('UserID')) u = userList() u.deleteById(request.form.get('UserID')) return render_template('confirmaction.html', title='Cadet Deleted', msg='Cadet Deleted!')
def allusers(): # if admin, show all users if checkAccess('admin') == True: u = userList() u.getAll() return render_template('users.html', title='User List', users=u.data) else: return redirect(url_for('home'))
def deleteuser(): # if admin, get id and delete the user if checkAccess('admin') == False: return redirect(url_for('home')) print("User id:",request.form.get('id')) #return '' u = userList() u.deleteById(request.form.get('id')) return render_template('confirmaction.html', title='User Deleted', msg='User deleted.')
def customers(): if checkSession() == False: #check to make sure the user is logged in return redirect('login') u = userList() u.getAll() print(u.data) #return '' return render_template('customers.html', title='Customer List',users=u.data)
def deleteuser(): if checkSession() == False: return redirect('login') print("userID:",request.form.get('userID')) #return '' u = userList() u.deleteByID(request.form.get('userID')) return render_template('confirmaction.html', title='Customer Deleted', msg='Customer deleted.') '''
def newanimal(): if checkSession() == False: #check to make sure user is logged in return redirect('login') elif session['user']['userType'] == 'customer': return redirect('login') u = userList() u.getAll() if request.form.get('animalName') is None: a = animalList() a.set('animalName', '') a.set('animalType', '') a.set('animalBreed', '') a.set('animalAge', '') a.set('animalGender', '') a.set('animalSize', '') a.set('animalPhoto', '') a.set('animalStatus', '') a.set('userID', '') a.add() return render_template('animal/newanimal.html', title='New Animal', animal=a.data[0], users=u.data) else: a = animalList() a.set('animalName', request.form.get('animalName')) a.set('animalType', request.form.get('animalType')) a.set('animalBreed', request.form.get('animalBreed')) a.set('animalAge', request.form.get('animalAge')) a.set('animalGender', request.form.get('animalGender')) a.set('animalSize', request.form.get('animalSize')) a.set('animalPhoto', request.form.get('animalPhoto')) a.set('animalStatus', request.form.get('animalStatus')) a.set('userID', request.form.get('userID')) if request.form.get('animalPhoto') == '': a.set('animalPhoto', 'noPhoto.jpg') a.add() if a.verifyNew(): a.insert() print(a.data) return render_template('animal/savedanimal.html', title='Animal Saved', animal=a.data[0], users=u.data) else: return render_template('animal/newanimal.html', title='Animal Not Saved', animal=a.data[0], msg=a.errorList, users=u.data)
def user(username): # check if user is same as username or if an admin or landlord if checkUser(username) == False and checkAccess('landlord') == False: session['msg'] = "You are not authorized to view this page." return redirect(url_for('home')) u = userList() u.getByField('Username', username) if len(u.data) != 1: # show error if username is not found or duplicates are found return render_template('error.html', msg='User not found.') else: return render_template('user.html', title=u.data[0]['Username'], user=u.data[0])
def tenantsbyll(username): # if username is a landlord and the user is either username or admin, show the tenants who have a contract with username if getUserType(username) == 'landlord' and (checkUser(username) == True or checkAccess('admin')): u = userList() u.getTenants(username) if len(u.data) > 0: return render_template('users.html', title='Tenants', users=u.data) else: session['msg'] = 'No tenants to show.' return redirect(url_for('landlordmain')) else: return redirect(url_for('home'))
def users(): if checkSession() == False: #check to make sure user is logged in return redirect('login') elif session['user']['userType'] == 'customer': return redirect('login') u = userList() u.getAll() print(u.data) #return '' return render_template('user/users.html', title='User List', users=u.data)
def user(): if checkSession() == False: return redirect('login') u = userList() if request.args.get(u.pk) is None: return render_template('error.html', msg='No User ID given.') u.getById(request.args.get(u.pk)) if len(u.data) <= 0: return render_template('error.html', msg='User not found.') print(u.data) return render_template('user.html', title='User', user=u.data[0])
def createOrderByProduct(): if checkSession() == False: #check to make sure the user is logged in return redirect('login') allProducts = productList() allProducts.getAll() u = userList() o = orderList() p = productList() if request.form.get('productID') is None: o = orderList() #o.set('productID','') o.set('productName','') o.set('productSize','') o.set('Customer','') o.set('Address','') o.set('cardType','') o.add() return render_template('createOrderByProduct.html', title='New Order',order=o.data[0],product=p.data[0]) else: o = orderList() #o.set('productID',request.form.get('productID')) o.set('productName',request.form.get('productName')) o.set('productSize',request.form.get('productSize')) o.set('Customer',request.form.get('Customer')) o.set('Address',request.form.get('Address')) o.set('cardType',request.form.get('cardType')) o.add() #if o.verifyNew(): #o.insert() #print(o.data) #return render_template('savedorder.html', title='Order Saved',order=o.data[0]) #else: #return render_template('createOrder.html', title='Order Not Saved',order=o.data[0],msg=u.errorList) '''if request.args.get(p.pk) is None: return render_template('error.html', msg='No customer id given.') p.getById(request.args.get(p.pk)) if len(p.data) <= 0: return render_template('error.html', msg='Customer not found.') p.update() print(p.data) ''' #sneakerwelcome = 'Hello, ' + session['user']['First'] + ' ' + 'I hope you are ready to shop today. Welcome to our store!' return render_template('createOrderByProduct.html', title='Creating an order...',msg ='',order=o.data,product=p.data,user=u.data)
def newuser(): # allow admin to create a new user if checkAccess('admin') == False: return redirect(url_for('home')) if request.form.get('Username') is None: # form empty, render blank form u = userList() u.set('Username','') u.set('Email', '') u.set('Password','') u.set('FirstName','') u.set('LastName','') u.set('Type','tenant') u.set('Birthday', date.today().isoformat()) u.set('Phone', '') u.set('Balance', 0.0) u.set('Active', 0) u.add() return render_template('newuser.html', title='New User', user=u.data[0], today=date.today().isoformat()) else: # form filled, retrieve values u = userList() u.set('Username', request.form.get('Username')) u.set('Email', request.form.get('Email')) u.set('Password', request.form.get('Password')) u.set('FirstName', request.form.get('FirstName')) u.set('LastName', request.form.get('LastName')) u.set('Type', request.form.get('Type')) u.set('Birthday', request.form.get('Birthday')) u.set('Phone', request.form.get('Phone')) u.set('Balance', 0.0) u.set('Active', 0) u.add() if u.verifyNew() and u.passMatch(request.form.get('Password2')): # verify new user data and insert if valid u.insert() return render_template('saveduser.html', title='User Saved', user=u.data[0]) else: # if invalid, render form again return render_template('newuser.html', title='User Not Saved', user=u.data[0], msg=u.errorList, today=date.today().isoformat())
def newbill(username): # allow landlords to create a new bill for one of their tenants if checkUser(username) and getUserType(username) == 'landlord': # get list of valid tenants t = userList() t.getTenants(username) if request.form.get('AmntDue') is None: # form unfilled, render with defaults b = billList() b.set('AmntDue', 0) b.set('DateDue', date.today().isoformat()) b.set('BillerUserID', session.get('UserID')) b.add() return render_template('newbill.html', title='New Bill', bill=b.data, tenants=t.data, username=username) else: # form filled, get data from forms b = billList() t1 = userList() t1.getById(request.form.get('TenantID')) b.set('AmntDue', float(request.form.get('AmntDue'))) b.set('DateDue', request.form.get('DateDue')) b.set('BilledUserID', request.form.get('TenantID')) b.set('DateBilled', date.today().isoformat()) b.set('AmntPaid', 0) b.set('DatePaid', None) b.set('BillerUserID', session.get('UserID')) b.set('TUserName', t1.data[0]['Username']) b.set('LUserName', username) b.add() if b.verifyNew(): # if new data is valid, insert into database and redirect to bills screen b.insert() session['msg'] = "Bill Added." return redirect(url_for('bills', username=username)) else: # if invalid, try again return render_template('newbill.html', title='Bill Not Saved', bill=b.data, tenants=t.data, username=username) else: return redirect(url_for('home'))
def newuser(): if checkSession() == False: #check to make sure user is logged in return redirect('login') elif session['user']['userType'] == 'customer': return redirect('login') if request.form.get('userFName') is None: u = userList() u.set('userFName', '') u.set('userLName', '') u.set('userEmail', '') u.set('userPassword', '') u.set('userType', '') u.add() return render_template('user/newuser.html', title='New User', user=u.data[0]) else: u = userList() u.set('userFName', request.form.get('userFName')) u.set('userLName', request.form.get('userLName')) u.set('userEmail', request.form.get('userEmail')) u.set('userPassword', request.form.get('userPassword')) u.set('userType', request.form.get('userType')) u.add() if u.verifyNew(): u.insert() print(u.data) return render_template('user/saveduser.html', title='User Saved', user=u.data[0]) else: return render_template('user/newuser.html', title='User Not Saved', user=u.data[0], msg=u.errorList)
def brandnewuser(): if request.form.get('First') is None: u = userList() u.set('First','') u.set('Last','') u.set('Email','') u.set('Password','') u.set('Type','') u.add() return render_template('brandnewuser.html', title='New User', user=u.data[0]) else: u = userList() u.set('First',request.form.get('First')) u.set('Last',request.form.get('Last')) u.set('Email',request.form.get('Email')) u.set('Password',request.form.get('Password')) u.set('Type',request.form.get('Type')) u.add() if u.verifyNew(): u.insert() #print(u.data) return render_template('savednewcustomer.html', title='User Saved',user=u.data[0]) else: return render_template('brandnewuser.html', title='User Not Saved',user=u.data[0],msg=u.errorList)
def savecustomer(): if checkSession() == False: return redirect('login') u = userList() u.set('userID',request.form.get('userID')) u.set('First',request.form.get('First')) u.set('Last',request.form.get('Last')) u.set('Email',request.form.get('Email')) u.set('Password',request.form.get('Password')) u.set('Type',request.form.get('Type')) u.add() u.update() #u.insert() print(u.data) #return '' return render_template('savedcustomer.html', title='Customer Saved',user=u.data[0])