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