class View(User):
def __init__(self, currentUsername, currentPassword):
self.currentUsername = currentUsername
self.currentPassword = currentPassword
self.stdscr = None
self.n = 0
self.m = 0
self.c = 0
self.db = None
self.userId = None
def validateUser(self):
self.db = Database()
self.db.connect()
sql = "SELECT * FROM User WHERE name = '%s'" % (self.currentUsername)
results = self.db.query(sql)
if results is not None:
self.userId = results[0]
self.password = results[2]
self.email = results[3]
elif results is None:
sys.exit("Invalid Username")
if self.password != self.currentPassword:
sys.exit("Invalid Password")
def initView(self):
self.stdscr = curses.initscr()
q = databaseEvent()
# clear screen
self.stdscr.clear()
# turn off cursor
curses.curs_set(False)
# main menu program loop:
while self.n != ord('3'):
self.stdscr.clear()
self.stdscr.addstr('Welcome ' + self.currentUsername)
self.stdscr.addstr(2, 0, 'Enter a Number:')
self.stdscr.addstr(3, 2, '1 - View Schedule')
self.stdscr.addstr(4, 2, '2 - Cancel Appointment')
self.stdscr.addstr(5, 2, '3 - Exit')
self.stdscr.refresh()
self.n = self.stdscr.getch()
if self.n == ord('1'):
self.stdscr.clear()
self.stdscr.addstr('Schedule View - *Press Any Key for Main Menu*')
self.stdscr.addstr(2, 0, 'DATE')
self.stdscr.addstr(2, 15, 'TIME')
self.stdscr.addstr(2, 30, 'STUDENT')
self.stdscr.addstr(2, 50, 'STUDENT EMAIL')
sql = q.getApp(self.userId)
appts = self.db.queryall(sql)
row = 3
for app in appts:
#studentId = app[3]
studentName = str(app[4])
studentEmail = str(app[5])
time = str(app[6])
date = str(app[8])
status = str(app[9])
#location = app[5]
if status == "0":
self.stdscr.addstr(row, 0, date)
self.stdscr.addstr(row, 15, time)
self.stdscr.addstr(row, 30, studentName)
self.stdscr.addstr(row, 50, studentEmail)
row += 1
self.stdscr.refresh()
self.stdscr.getkey()
if self.n == ord('2'):
self.stdscr.clear()
self.stdscr.addstr('Cancel View - *Press "x" for Main Menu*')
self.stdscr.addstr(1, 0, 'Enter the ID number of the Appointment you would like to Cancel')
self.stdscr.addstr(3, 0, 'Appointment ID')
self.stdscr.addstr(3, 15, 'DATE')
self.stdscr.addstr(3, 30, 'STATUS')
self.stdscr.addstr(3, 50, 'STUDENT')
sql = q.getApp(self.userId)
appts2 = self.db.queryall(sql)
row = 4
for app2 in appts2:
appId = str(app2[0])
studentName = str(app2[4])
date = str(app2[8])
status = str(app2[9])
if status == "1":
status = "Canceled"
else:
status = "Active"
self.stdscr.addstr(row, 0, appId)
self.stdscr.addstr(row, 15, date)
self.stdscr.addstr(row, 30, status)
self.stdscr.addstr(row, 50, studentName)
row += 1
self.m = self.stdscr.getch()
if self.m != ord('x'):
for app2 in appts2:
if str(unichr(self.m)) == str(app2[0]):
self.stdscr.clear()
self.stdscr.addstr('Are you sure you would like to cancel this appointment? (y/n)')
self.stdscr.addstr(2, 0, 'Appointment ID')
self.stdscr.addstr(2, 15, 'DATE')
self.stdscr.addstr(2, 30, 'STUDENT')
appId = str(app2[0])
studentName = str(app2[4])
date = str(app2[8])
self.stdscr.addstr(3, 0, appId)
self.stdscr.addstr(3, 15, date)
self.stdscr.addstr(3, 30, studentName)
self.c = self.stdscr.getch()
if self.c == ord('y'):
sql = q.handleApp(app2[0])
self.db.update(sql)
self.stdscr.clear()
self.stdscr.addstr('Cancelled! - *Press any key for main menu*')
else:
self.stdscr.clear()
self.stdscr.addstr('Not cancelled - *Press any key for main menu*')
self.stdscr.refresh()
self.stdscr.getkey()
def initWrapper(self):
# curses wrapper initiates and exits window/curses
wrapper(self.initView())
class View(User):
def __init__(self, currentUsername, currentPassword):
self.currentUsername = currentUsername
self.currentPassword = currentPassword
self.stdscr = None
self.n = 0
self.m = 0
self.c = 0
self.db = None
self.userId = None
def validateUser(self):
self.db = Database()
self.db.connect()
sql = "SELECT * FROM User WHERE name = '%s'" % (self.currentUsername)
results = self.db.query(sql)
if results is not None:
self.userId = results[0]
self.password = results[2]
self.email = results[3]
elif results is None:
sys.exit("Invalid Username")
if self.password != self.currentPassword:
sys.exit("Invalid Password")
def initView(self):
self.stdscr = curses.initscr()
q = databaseEvent()
# clear screen
self.stdscr.clear()
# turn off cursor
curses.curs_set(False)
# main menu program loop:
while self.n != ord('3'):
self.stdscr.clear()
self.stdscr.addstr('Welcome ' + self.currentUsername)
self.stdscr.addstr(2, 0, 'Enter a Number:')
self.stdscr.addstr(3, 2, '1 - View Schedule')
self.stdscr.addstr(4, 2, '2 - Cancel Appointment')
self.stdscr.addstr(5, 2, '3 - Exit')
self.stdscr.refresh()
self.n = self.stdscr.getch()
if self.n == ord('1'):
self.stdscr.clear()
self.stdscr.addstr(
'Schedule View - *Press Any Key for Main Menu*')
self.stdscr.addstr(2, 0, 'DATE')
self.stdscr.addstr(2, 15, 'TIME')
self.stdscr.addstr(2, 30, 'STUDENT')
self.stdscr.addstr(2, 50, 'STUDENT EMAIL')
sql = q.getApp(self.userId)
appts = self.db.queryall(sql)
row = 3
for app in appts:
#studentId = app[3]
studentName = str(app[4])
studentEmail = str(app[5])
time = str(app[6])
date = str(app[8])
status = str(app[9])
#location = app[5]
if status == "0":
self.stdscr.addstr(row, 0, date)
self.stdscr.addstr(row, 15, time)
self.stdscr.addstr(row, 30, studentName)
self.stdscr.addstr(row, 50, studentEmail)
row += 1
self.stdscr.refresh()
self.stdscr.getkey()
if self.n == ord('2'):
self.stdscr.clear()
self.stdscr.addstr('Cancel View - *Press "x" for Main Menu*')
self.stdscr.addstr(
1, 0,
'Enter the ID number of the Appointment you would like to Cancel'
)
self.stdscr.addstr(3, 0, 'Appointment ID')
self.stdscr.addstr(3, 15, 'DATE')
self.stdscr.addstr(3, 30, 'STATUS')
self.stdscr.addstr(3, 50, 'STUDENT')
sql = q.getApp(self.userId)
appts2 = self.db.queryall(sql)
row = 4
for app2 in appts2:
appId = str(app2[0])
studentName = str(app2[4])
date = str(app2[8])
status = str(app2[9])
if status == "1":
status = "Canceled"
else:
status = "Active"
self.stdscr.addstr(row, 0, appId)
self.stdscr.addstr(row, 15, date)
self.stdscr.addstr(row, 30, status)
self.stdscr.addstr(row, 50, studentName)
row += 1
self.m = self.stdscr.getch()
if self.m != ord('x'):
for app2 in appts2:
if str(unichr(self.m)) == str(app2[0]):
self.stdscr.clear()
self.stdscr.addstr(
'Are you sure you would like to cancel this appointment? (y/n)'
)
self.stdscr.addstr(2, 0, 'Appointment ID')
self.stdscr.addstr(2, 15, 'DATE')
self.stdscr.addstr(2, 30, 'STUDENT')
appId = str(app2[0])
studentName = str(app2[4])
date = str(app2[8])
self.stdscr.addstr(3, 0, appId)
self.stdscr.addstr(3, 15, date)
self.stdscr.addstr(3, 30, studentName)
self.c = self.stdscr.getch()
if self.c == ord('y'):
sql = q.handleApp(app2[0])
self.db.update(sql)
self.stdscr.clear()
self.stdscr.addstr(
'Cancelled! - *Press any key for main menu*'
)
else:
self.stdscr.clear()
self.stdscr.addstr(
'Not cancelled - *Press any key for main menu*'
)
self.stdscr.refresh()
self.stdscr.getkey()
def initWrapper(self):
# curses wrapper initiates and exits window/curses
wrapper(self.initView())
# Create iCalendar object.
timecreated = time.strftime('%Y%m%dT%H%M%SZ', time.gmtime())
uid = timecreated + "@" + socket.gethostname()
timestart = appointment.getStartDateTime().strftime('%Y%m%dT%H%M%S')
timeend = appointment.getEndDateTime().strftime('%Y%m%dT%H%M%S')
calendarRequest = ""
mimeText = ""
##############################################
#############connect to database##############
##############################################
db = Database()
db.connect() #might not need
#queries
q = databaseEvent()
print "Check for cancelled."
if appointment.getCanceled():
# If the appointment email is a cancellation, get the original uid from the db so we can include it in
# the cancelation iCalendar event. Also, mark event as cancelled in db.
print "Request is a cancellation."
# Get info re: existing appointment from db.
class View(User):
def __init__(self, currentUsername, currentPassword):
self.currentUsername = currentUsername
self.currentPassword = currentPassword
self.stdscr = None
self.n = 0
self.m = 0
self.c = 0
self.db = None
self.userId = None
def validateUser(self):
self.db = Database()
self.db.connect()
results = databaseEvent().getInfo(self.db, self.currentUsername)
if results is not None:
self.userId = results[0]
self.userName = results[1]
self.password = results[2]
self.email = results[3]
elif results is None:
sys.exit("Invalid Username")
if self.password != self.currentPassword:
sys.exit("Invalid Password")
def initView(self):
self.stdscr = curses.initscr()
q = databaseEvent()
# clear screen
self.stdscr.clear()
# turn off cursor
curses.curs_set(False)
# main menu program loop:
while self.n != ord('3'):
self.stdscr.clear()
self.stdscr.addstr('Welcome ' + self.userName)
self.stdscr.addstr(2, 0, 'Enter a Number:')
self.stdscr.addstr(3, 2, '1 - View Schedule')
self.stdscr.addstr(4, 2, '2 - Cancel Appointment')
self.stdscr.addstr(5, 2, '3 - Exit')
self.stdscr.refresh()
self.n = self.stdscr.getch()
# view scheduled appts
if self.n == ord('1'):
self.stdscr.clear()
self.stdscr.addstr('Schedule View - *Press Any Key for Main Menu*')
self.stdscr.addstr(2, 0, 'DATE')
self.stdscr.addstr(2, 13, 'TIME')
self.stdscr.addstr(2, 30, 'STUDENT')
self.stdscr.addstr(2, 50, 'STUDENT EMAIL')
appts = q.getApp(self.db, self.userId)
row = 3
for app in appts:
studentName = str(app[4])
studentEmail = str(app[5])
startTime = app[6]
endTime = app[7]
time = self.formatTime(startTime, endTime)
status = str(app[10])
date = str(app[9])
if status == "0":
self.stdscr.addstr(row, 0, date)
self.stdscr.addstr(row, 13, time)
self.stdscr.addstr(row, 30, studentName)
self.stdscr.addstr(row, 50, studentEmail)
row += 1
if row == 3:
self.stdscr.addstr(3, 0, 'You currently have no appointments scheduled.')
self.stdscr.refresh()
self.stdscr.getkey()
# cancel a scheduled appointment
if self.n == ord('2'):
curses.curs_set(True)
self.stdscr.clear()
self.stdscr.addstr('Cancel View')
self.stdscr.addstr(1, 0, 'Enter ID number of Appointment you would like to Cancel or "exit" for Main Menu')
self.stdscr.addstr(2, 0, '::', curses.A_BOLD)
self.stdscr.addstr(4, 0, 'Appt ID')
self.stdscr.addstr(4, 10, 'DATE')
self.stdscr.addstr(4, 25, 'TIME')
self.stdscr.addstr(4, 45, 'STUDENT')
appts2 = q.getApp(self.db, self.userId)
row = 5
appIds = []
for app2 in appts2:
appIds.append(str(app2[0]))
appId = str(app2[0])
studentName = str(app2[4])
startTime = app2[6]
endTime = app2[7]
time = self.formatTime(startTime, endTime)
date = str(app2[9])
status = str(app2[10])
if status == "0":
self.stdscr.addstr(row, 1, appId)
self.stdscr.addstr(row, 10, date)
self.stdscr.addstr(row, 25, time)
self.stdscr.addstr(row, 45, studentName)
row += 1
# input verification
self.stdscr.move(2, 3)
self.m = self.stdscr.getstr()
while self.m not in appIds and self.m != "exit":
self.stdscr.addstr(3, 0, 'Not A Valid Appointment ID. Try Again.', curses.A_BOLD)
self.stdscr.move(2, 3)
self.stdscr.clrtoeol()
self.m = self.stdscr.getstr()
self.stdscr.addstr(6, 5, "good id")
# verify appointment cancellation
if self.m != "exit":
curses.curs_set(False)
for app2 in appts2:
if self.m == str(app2[0]):
self.stdscr.clear()
self.stdscr.addstr('Are you sure you would like to cancel this appointment? (y/n)')
self.stdscr.addstr(2, 0, 'Appt ID')
self.stdscr.addstr(2, 10, 'DATE')
self.stdscr.addstr(2, 25, 'TIME')
self.stdscr.addstr(2, 45, 'STUDENT')
appId = str(app2[0])
studentName = str(app2[4])
startTime = app2[6]
eStart = app2[6]
endTime = app2[7]
eEnd = app2[7]
time = self.formatTime(startTime, endTime)
date = str(app2[9])
eDate = app2[9]
studentEmail = str(app2[5])
self.stdscr.addstr(3, 1, appId)
self.stdscr.addstr(3, 10, date)
self.stdscr.addstr(3, 25, time)
self.stdscr.addstr(3, 45, studentName)
self.c = self.stdscr.getch()
if self.c == ord('y'):
q.handleApp(self.db, app2[0])
self.sendCancellation(self.userName, self.email, studentName, studentEmail, eDate, eStart, eEnd)
self.stdscr.clear()
self.stdscr.addstr('Cancelled! - *Press any key for main menu*')
self.stdscr.getkey()
else:
self.stdscr.clear()
self.stdscr.addstr('Not cancelled - *Press any key for main menu*')
self.stdscr.getkey()
else:
self.initView()
def initWrapper(self):
# curses wrapper initiates and exits window/curses
wrapper(self.initView())
def sendCancellation(self, name, email, student_name, student_email, date, startTime, endTime):
# sends a cancellation email when an appointment is cancelled
self.db = Database()
self.db.connect()
day = date.strftime('%d')
if day == "01" or day == "21" or day == "31":
dateStr = date.strftime('%A, %B %dst, %Y')
elif day == "02" or day == "22":
dateStr = date.strftime('%A, %B %dnd, %Y')
elif day == "03" or day == "23":
dateStr = date.strftime('%A, %B %drd, %Y')
else:
dateStr = date.strftime('%A, %B %dth, %Y')
time = self.formatTime(startTime, endTime)
userName = name.split()
lastName = userName[len(userName)-1]
firstName = ""
for i in range(len(userName) - 1):
firstName = firstName + " " + userName[i]
sendName = lastName + "," + firstName
fromAddr = '*****@*****.**'
toAddr = [student_email, email]
body = """\
Advising Signup with %s CANCELLED
Name: %s
Email: %s
Date: %s
Time: %s
Please contact [email protected] if you experience problems.
""" % (sendName, student_name, student_email, dateStr, time)
msg = MIMEText(body, 'plain')
msg['Subject'] = 'Advising Signup Cancellation'
msg['From'] = fromAddr
msg['To'] = student_email + "; " + email
s = smtplib.SMTP('mail.engr.oregonstate.edu')
s.sendmail(fromAddr, toAddr, msg.as_string())
s.quit()
def formatTime(self, start, end):
# formats datetime.timedelta to 12 hour time format/string
startPeriod = "am"
endPeriod = "am"
startHour = start.seconds // 3600
startMins = (start.seconds % 3600) // 60
if startHour >= 12:
startPeriod = "pm"
if startHour > 12:
startHour = startHour - 12
if startHour == 0:
startHour = 12
startPeriod = "am"
if startHour == 12:
startPeriod = "pm"
if startMins == 0:
startMins = "00"
startStr = str(startHour) + ":" + str(startMins) + startPeriod
endHour = end.seconds // 3600
endMins = (end.seconds % 3600) // 60
if endHour >= 12:
endPeriod = "pm"
if endHour > 12:
endHour = endHour - 12
if endHour == 0:
endHour = 12
endPeriod = "am"
if endMins == 0:
endMins = "00"
endStr = str(endHour) + ":" + str(endMins) + endPeriod
time = startStr + " - " + endStr
return time
__author__ = 'kkozee' import sys sys.path.append(os.getcwd()) from src.database.database import Database db = Database() db.connect()
