def newevent():
if checkSession() == False:
return redirect('login')
allVenues = venueList()
allVenues.getAll()
if request.form.get('name') is None:
e = eventList()
e.set('VenueID', '')
e.set('name', '')
e.set('start', '')
e.set('end', '')
e.add()
return render_template('event/newevent.html',
title='New Event',
event=e.data[0],
vl=allVenues.data)
else:
e = eventList()
e.set('VenueID', request.form.get('VenueID'))
e.set('name', request.form.get('name'))
e.set('start', request.form.get('start'))
e.set('end', request.form.get('end'))
e.add()
if e.verifyNew():
e.insert()
return render_template('event/savedevent.html',
title='Event Saved',
event=e.data[0],
vl=allVenues.data)
else:
return render_template('event/newevent.html',
title='Event Not Saved',
event=e.data[0],
msg=e.errorList,
vl=allVenues.data)
def newevent():
if checkSession() == False:
return redirect('login')
if request.form.get('EventName') is None:
e = eventList()
e.set('EventName','')
e.set('EventStartDT','')
e.set('EventEndDT','')
e.set('EventStatus','')
e.set('EventSemester','')
e.add()
return render_template('event/newevent.html', title='New Event', event=e.data[0])
else:
e = eventList()
e.set('EventName',request.form.get('EventName'))
e.set('EventStartDT',request.form.get('EventStartDT'))
e.set('EventEndDT',request.form.get('EventEndDT'))
e.set('EventStatus',request.form.get('EventStatus'))
e.set('EventSemester',request.form.get('EventSemester'))
e.add()
if e.verifyNew():
e.insert()
print(e.data)
return render_template('event/savedevent.html', title='Event Saved', event=e.data[0])
else:
return render_template('event/newevent.html', title='Event Not Saved', event=e.data[0],msg=e.errorList)
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 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 adoptionSuccessful():
#cusomter facing
e = eventList()
return render_template('event/adoptionsuccessful.html',
title='event Saved',
event=e.data[0])
def deleteevent():
if checkSession() == False:
return redirect('login')
print("ID:",request.form.get('EventID'))
e = eventList()
e.deleteById(request.form.get('EventID'))
return render_template('event/deletedevent.html', title='Event Deleted', msg='Event Deleted!')
def events():
if checkSession() == False:
return redirect('login')
e = eventList()
e.getAll()
#print(e.data)
#return ''
return render_template('event/events.html', title='Event List', events=e.data)
def adoptionevent():
if checkSession() == False: #check to make sure user is logged in
return redirect('login')
an = animalList()
animalID = ''
animalID = request.args.get('animalID')
an.getById(animalID)
#print('a.data before :', an.data[0])
#print('USER:'******'user']['userID'])
if session['user']['userID'] <= 0:
return redirect('login')
an.data[0]['animalStatus'] = 'Adopted'
an.data[0]['userID'] = session['user']['userID']
an.add()
#print('an.data[0][animalStatus]', an.data[0]['animalStatus'])
'''
a.set('animalStatus','Adopted')
a.set('userID',session['user']['userID'])
a.add()
'''
#print('a.data after :', an.data[0])
an.update()
if len(an.data) <= 0:
return render_template('error.html', msg='Animal not found.')
t = transactionList()
transactionID = ''
transactionID = request.args.get('transactionID')
t.getById(transactionID)
if len(t.data) <= 0:
return render_template('error.html', msg='Transaction not found.')
e = eventList()
e.set('eventType', 'Adoption')
e.set('eventCompletedDate', 'n/a')
e.set('eventName', 'Adoption of ' + an.data[0]['animalName'])
e.set('eventResult', 'n/a')
e.set('animalID', an.data[0]['animalID'])
e.set('userID', session['user']['userID'])
e.set('transactionID', transactionID)
e.add()
if e.verifyNew():
e.insert()
print(e.data)
return render_template('event/adoptionsuccessful.html',
title='event Saved',
event=e.data[0])
else:
return render_template('event/adoptionevent.html',
title='event Not Saved',
event=e.data[0],
msg=e.errorList)
def deleteevent():
if checkSession() == False:
return redirect('login')
print("EID:", request.form.get('EID'))
#return ''
e = eventList()
e.deleteById(request.form.get('EID'))
return render_template('confirmaction.html',
title='Event Deleted',
msg='Event deleted.')
def customerevents():
allVenues = venueList()
allVenues.getAll()
e = eventList()
e.getAll()
#print(c.data)
#return ''
return render_template('event/customerevents.html',
title='Event List',
events=e.data,
vl=allVenues.data)
def customertickets():
allEvents = eventList()
allEvents.getAll()
t = ticketList()
t.getByCustomer(session['user']['UID'])
#print(c.data)
#return ''
return render_template('ticket/customertickets.html',
title='Ticket List',
tickets=t.data,
el=allEvents.data)
def events():
if checkSession() == False: #check to make sure user is logged in
return redirect('login')
elif session['user']['userType'] == 'customer':
return redirect('login')
e = eventList()
e.getAll()
#print(e.data)
return render_template('event/events.html',
title='Event List',
events=e.data)
def event():
if checkSession() == False:
return redirect('login')
e = eventList()
if request.args.get(e.pk) is None:
return render_template('error.html', msg='No event id given.')
e.getById(request.args.get(e.pk))
if len(e.data) <= 0:
return render_template('error.html', msg='Event not found.')
print(e.data)
return render_template('event/event.html', title='Event ', event=e.data[0])
def alltickets():
if checkSession() == False:
return redirect('login')
allEvents = eventList()
allEvents.getAll()
t = ticketList()
t.getAll()
print(t.data)
#return ''
return render_template('ticket/tickets.html',
title='My tickets',
tickets=t.data,
el=allEvents.data)
def admintickets():
if checkSession() == False:
return redirect('login')
allEvents = eventList()
allEvents.getAll()
t = ticketList()
t.getByCustomer(session['user']['UID'])
print(t.data)
#return ''
return render_template('ticket/mytickets.html',
title='My tickets',
tickets=t.data,
el=allEvents.data)
def saveevent():
if checkSession() == False:
return redirect('login')
e = eventList()
e.set('eid',request.form.get('eid'))
e.set('name',request.form.get('name'))
e.set('start',request.form.get('start'))
e.set('end',request.form.get('end'))
e.add()
if e.verifyChange():
e.update()
#print(e.data)
#return ''
return render_template('event/savedevent.html', title='Event Saved', event=e.data[0])
else:
return render_template('event/event.html', title='Event Not Saved', event=e.data[0],msg=e.errorList)
def saveevent():
if checkSession() == False:
return redirect('login')
else:
e = eventList()
e.set('VenueID', request.form.get('VenueID'))
e.set('EID', request.form.get('Event ID'))
e.set('name', request.form.get('Event Name'))
e.set('start', request.form.get('Event Start'))
e.set('end', request.form.get('Event End'))
e.add()
e.update()
print(e.data)
return render_template('event/savedevent.html',
title='Event Saved',
event=e.data[0])
def saveevent():
if checkSession() == False:
return redirect('login')
e = eventList()
e.set('EventID',request.form.get('EventID'))
e.set('EventName',request.form.get('EventName'))
e.set('EventStartDT',request.form.get('EventStartDT'))
e.set('EventEndDT',request.form.get('EventEndDT'))
e.set('EventStatus',request.form.get('EventStatus'))
e.set('EventSemester',request.form.get('EventSemester'))
e.add()
print(e.data)
if e.verifyChange():
e.update()
return render_template('event/savedevent.html', title='Event Saved', event=e.data[0])
else:
return render_template('event/event.html', title='Event Not Saved', event=e.data[0],msg=e.errorList)
def oneevent():
if checkSession() == False:
return redirect('login')
allVenues = venueList()
allVenues.getAll()
e = eventList()
if request.args.get('id') is None:
return render_template('error.html', msg='No event id given')
e.getById(request.args.get('id'))
if len(e.data) <= 0:
return render_template('error.html', msg='Event not found')
print(e.data)
return render_template('event/event.html',
title='Event',
event=e.data[0],
vl=allVenues.data)
def oneticket():
if checkSession() == False:
return redirect('login')
allEvents = eventList()
allEvents.getAll()
t = ticketList()
if request.args.get('id') is None:
return render_template('error.html', msg='No ticket id given')
t.getById(request.args.get('id'))
if len(t.data) <= 0:
return render_template('error.html', msg='Ticket not found')
print(t.data)
return render_template('ticket/ticket.html',
title='Ticket',
ticket=t.data[0],
el=allEvents.data)
def newcustomerticket():
if checkSession() == False:
return redirect('login')
allEvents = eventList()
allEvents.getAll()
if request.form.get('section') is None:
t = ticketList()
t.set('EventID', '')
t.set('section', '')
t.set('row', '')
t.set('available', '')
t.set('handicap', '')
t.set('type', '')
t.set('box', '')
t.set('UserID', '')
t.add()
return render_template('ticket/newticket.html',
title='New Ticket',
ticket=t.data[0],
el=allEvents.data)
else:
t = ticketList()
t.set('EventID', request.form.get('EventID'))
t.set('section', request.form.get('section'))
t.set('row', request.form.get('row'))
t.set('available', request.form.get('available'))
t.set('handicap', request.form.get('handicap'))
t.set('type', request.form.get('type'))
t.set('box', request.form.get('box'))
t.set('UserID', session['user']['UID'])
t.add()
if t.verifyNew():
t.insert()
return render_template('ticket/savedticket.html',
title='Ticket Saved',
ticket=t.data[0],
el=allEvents.data)
else:
return render_template('ticket/newticket.html',
title='Ticket Not Saved',
ticket=t.data[0],
msg=t.errorList,
el=allEvents.data)
def event():
if checkSession() == False: #check to make sure user is logged in
return redirect('login')
elif session['user']['userType'] == 'customer':
return redirect('login')
allAnimals = animalList()
allAnimals.getAll()
e = eventList()
if request.args.get(e.pk) is None:
return render_template('error.html', msg='No event id given.')
e.getById(request.args.get(e.pk))
if len(e.data) <= 0:
return render_template('error.html', msg='Event not found.')
#print(e.data)
return render_template('event/event.html',
title='Event Details',
event=e.data[0],
al=allAnimals.data)
def newreview():
if checkSession() == False:
return redirect('login')
allEvents = eventList()
allEvents.getAll()
if request.form.get('review') is None:
r = reviewList()
r.set('event_id','')
r.set('customer_id','')
r.set('review','')
r.add()
return render_template('review/newreview.html', title='New Review', review=r.data[0],el=allEvents.data)
else:
r = reviewList()
r.set('event_id',request.form.get('event_id'))
r.set('customer_id',session['user']['id'])
r.set('review',request.form.get('review'))
r.add()
if r.verifyNew():
r.insert()
print(r.data)
return render_template('review/savedreview.html', title='Review Saved', review=r.data[0])
else:
return render_template('review/newreview.html', title='Review Not Saved', review=r.data[0],msg=r.errorList,el=allEvents.data)
def saveevent():
#TODO unsure
e = eventList()
e.set('eventID', request.form.get('eventID'))
e.set('eventType', request.form.get('eventType'))
e.set('eventCompletedDate', request.form.get('eventCompletedDate'))
e.set('eventName', request.form.get('eventName'))
e.set('eventResult', request.form.get('eventResult'))
e.set('animalID', request.form.get('animalID'))
e.set('userID', session['user']['userID'])
e.set('transactionID', request.form.get('transactionID'))
e.add()
if e.verifyNew():
e.update()
print(e.data)
return render_template('event/savedevent.html',
title='event Saved',
event=e.data[0])
else:
return render_template('event/newevent.html',
title='event Not Saved',
event=e.data[0],
msg=e.errorList)
def newappointment():
#customer facing
if checkSession() == False: #check to make sure user is logged in
return redirect('login')
userID = session['user']['userID']
animals = animalList()
animals.getByField('userID', str(userID))
if request.form.get('eventType') is None:
t = transactionList()
t.set('transactionType', '')
t.set('transactionAmount', '')
t.set('userID', '')
t.add()
e = eventList()
e.set('eventType', '')
e.set('eventScheduleDate', '')
e.set('eventCompletedDate', '')
e.set('eventName', '')
e.set('eventResult', '')
e.set('animalID', '')
e.set('userID', '')
e.set('transactionID', '')
e.add()
allAnimals = animalList()
allAnimals.getAll()
return render_template('event/newappointment.html',
title='New Event',
event=e.data[0],
animals=animals.data,
user=session['user']['userFName'])
else:
t = transactionList()
t.set('transactionType', request.form.get('eventType'))
t.set('transactionAmount', 0)
t.set('userID', session['user']['userID'])
t.add()
e = eventList()
e.set('eventID', request.form.get('eventID'))
e.set('eventType', request.form.get('eventType'))
e.set('eventCompletedDate', request.form.get('eventCompletedDate'))
e.set('eventName', request.form.get('eventName'))
e.set('eventResult', request.form.get('eventResult'))
e.set('animalID', request.form.get('animalID'))
e.set('userID', session['user']['userID'])
#e.set('transactionID',request.form.get('transactionID'))
e.add()
if e.verifyNew():
t.verifyNew()
t.insert()
e.set('transactionID', t.data[0]['transactionID'])
e.add()
e.insert()
#print('eventdata:',e.data)
#print('transactiondata:',t.data)
return render_template('event/savedappointment.html',
title='event Saved',
event=e.data[0])
else:
return render_template('event/newappointment.html',
title='event Not Saved',
event=e.data[0],
msg=e.errorList,
user=session['user']['userFName'],
animals=animals.data)
