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)