def profile():
if not USER_SESSION in session:
return redirect(url_for("login"))
user = session[USER_SESSION]
accttype = db.get_account(user)
fullname = db.get_name(user)
if accttype == 'T':
return redirect(url_for("home"))
if request.method == "POST":
coursecode = request.form['classcode']
password = request.form['password']
if db.authorize_class(coursecode, password):
db.add_student(coursecode, user, fullname)
flash("Enrolled in class!")
else:
flash("Invalid credentials for class")
unexcused = db.count_unexcused(user)
excused = db.count_excused(user)
info = [unexcused, excused]
enrolled = {}
for each in db.get_studentclass(user):
print db.get_grade(each, user)
enrolled[each] = db.get_grade(each, user)
return render_template("profile.html", attendance=info, enrolled=enrolled, username=user, isLogged = (USER_SESSION in session), fullname = db.get_name(user), acct = accttype)
def student():
global stu_course
global stu_name
if not USER_SESSION in session:
return redirect(url_for("login"))
user = session[USER_SESSION]
accttype = db.get_account(user)
if accttype == 'S':
return redirect(url_for("profile"))
if accttype == 'L':
return redirect(url_for("attendance"))
classes = db.get_classes(user)
if request.method == "POST":
grade = request.form["grade"]
db.change_grade(stu_course, stu_name, int(grade))
flash("Updated grade for " + stu_name)
if request.method == "GET" and 'course' in request.args:
stu_course = request.args.get("course")
students = db.get_students(stu_course)
return render_template("student.html", students=students, course=stu_course, courses=classes, isLogged=(USER_SESSION in session), acct = accttype)
if request.method == "GET" and 'student' in request.args:
print 'yes'
stu_name = request.args.get('student')
return render_template("student.html", name=db.get_name(stu_name), grade=db.get_grade(stu_course, stu_name), user=stu_name, course=stu_course, courses=classes, isLogged=(USER_SESSION in session), searched=True, acct = accttype)
return render_template("student.html", courses=classes, isLogged = (USER_SESSION in session), acct = accttype)
def create():
if USER_SESSION in session:
user = session[USER_SESSION]
accttype = db.get_account(user)
if accttype == 'S':
return redirect(url_for("profile"))
if accttype == 'L':
return redirect(url_for("attendance"))
return redirect(url_for("home"))
if request.method == "POST":
username = request.form["username"].lower()
fullname = request.form["fullname"]
accttype = request.form["accttype"]
password = request.form["password"]
confirm_password = request.form["confirmPassword"]
admin_password = request.form["adminPassword"]
if not username.endswith("@stuy.edu"):
flash("Email must be your stuy.edu email")
elif is_null(username, fullname, password, confirm_password):
flash("A field was left empty")
elif password != confirm_password:
flash("Password and password confirmation do not match")
elif accttype == 'T' and admin_password == "":
flash("To create a teacher account, please enter admin password")
elif accttype == 'T' and admin_password and db.encrypt_password(admin_password) != 'ca978112ca1bbdcafac231b39a23dc4da786eff8147c4e72b9807785afee48bb':
flash("Admin password is incorrect")
elif not db.create_account(username, password, fullname, accttype):
flash("Username taken")
else:
return redirect(url_for("login"))
return render_template("create.html", isLogged = (USER_SESSION in session))
def classes():
if not USER_SESSION in session:
return redirect(url_for("login"))
user = session[USER_SESSION]
accttype = db.get_account(user)
if accttype == 'S':
return redirect(url_for("profile"))
if request.method == "POST":
code = request.form["newCode"]
password = request.form["newPassword"]
confirm_password = request.form["repeatPassword"]
if '-' not in code:
flash("Code must include section")
elif is_null(code, "placeholder", password, confirm_password):
flash("A field was left empty")
elif password != confirm_password:
flash("Password and password confirmation do not match")
elif not db.create_class(user, code, password):
flash("Course code taken")
else:
flash("Course Created!")
return render_template("class.html", isLogged = (USER_SESSION in session), acct = accttype)
def excuse():
global stu_course
global stu_name
if not USER_SESSION in session:
return redirect(url_for("login"))
user = session[USER_SESSION]
accttype = db.get_account(user)
if accttype == 'S':
return redirect(url_for("profile"))
classes = db.get_classes(user)
if request.method == "POST":
date = request.form["date"]
reason = request.form["reason"]
if not db.check_attendance(stu_name, date, stu_course):
flash('Excused absence for ' + stu_name)
db.add_attendance(stu_name, stu_course, date, 'E', reason)
else:
flash(stu_name + ' was present on '+date+ ' in '+stu_course)
if request.method == "GET" and 'course' in request.args:
stu_course = request.args.get("course")
students = db.get_students(stu_course)
return render_template("excuse.html", students=students, course=stu_course, courses=classes, isLogged=(USER_SESSION in session), acct = accttype)
if request.method == "GET" and 'student' in request.args:
print 'yes'
stu_name = request.args.get('student')
return render_template("excuse.html", name=db.get_name(stu_name), username=stu_name, course=stu_course, courses=classes, isLogged=(USER_SESSION in session), searched=True, acct = accttype)
return render_template("excuse.html", courses=classes, isLogged = (USER_SESSION in session), acct = accttype)
def home():
if not USER_SESSION in session:
return redirect(url_for("login"))
user = session[USER_SESSION]
accttype = db.get_account(user)
if accttype == 'S':
return redirect(url_for("profile"))
if accttype == 'L':
return redirect(url_for("attendance"))
if request.method == "POST":
coursecode = request.form['coursecode']
username = request.form['student'].lower()
if not coursecode in db.get_classes(user):
flash("Invalid coursecode")
elif not db.does_username_exist(username):
flash("Username does not exist")
elif username in db.get_leaders(coursecode):
flash(username + " is already a leader for this class")
elif not username in db.get_students(coursecode):
flash(username + " is not yet enrolled in the class")
else:
db.add_leader(coursecode, username)
flash(username + " added as leader for " + coursecode)
return render_template("home.html", isLogged = (USER_SESSION in session), acct = accttype)
def login():
if USER_SESSION in session:
user = session[USER_SESSION]
accttype = db.get_account(user)
if accttype == 'S':
return redirect(url_for("profile"))
if accttype == 'L':
return redirect(url_for("attendance"))
return redirect(url_for("home"))
elif (request.method == "GET"):
return render_template("login.html", isLogged = (USER_SESSION in session))
else:
username = request.form["username"].lower()
password = request.form["password"]
if add_session(username, password):
return redirect(url_for("root"))
return render_template("login.html", isLogged = (USER_SESSION in session))
def attendance():
global att_date
global att_course
if not USER_SESSION in session:
return redirect(url_for("login"))
user = session[USER_SESSION]
accttype = db.get_account(user)
if accttype == 'S':
return redirect(url_for("profile"))
classes = db.get_classes(user)
#coming back from excuse
if request.method == "POST":
allppl = len(request.form)
for each in request.form:
print each +': '+ request.form[each]
if each.endswith('@stuy.edu') and request.form[each] == 'A':
if db.check_attendance(each, att_date, att_course):
db.add_attendance(each, att_course, att_date, 'U', '')
if each.endswith('@stuy.edu') and request.form[each] == 'P':
if not db.check_attendance(each, att_date, att_course):
db.delete_attendance(each, att_date, att_course)
flash('Updated attendance for ' + att_course)
#search
if request.method == "GET" and 'date' in request.args:
att_date = request.args.get("date")
att_course = request.args.get("course")
enrolled = db.get_students(att_course)
students = {}
for each in enrolled:
students[each] = [db.get_name(each), db.student_present(each, att_date, att_course)]
return render_template("attendance.html", date=att_date, students=students, course=att_course, courses=classes, isLogged=(USER_SESSION in session), searched=True, acct = accttype)
return render_template("attendance.html", courses=classes, isLogged=(USER_SESSION in session), acct = accttype)