def user(username):
user = data.execute("SELECT * FROM Users WHERE username = ?", username)
user = user[0]
user = unnonify(user)
tours = data.execute("SELECT t_id, tour_name, year, type FROM Tours INNER JOIN Tours_tutors USING (t_id) WHERE username = ? ORDER BY YEAR DESC", username)
mentorteams = data.execute("SELECT m_id, mentor_names, year FROM Mentorteams INNER JOIN Mentors USING (m_id) WHERE username = ? ORDER BY YEAR DESC", username)
return render_template("usermanager/user.html", user=user, tours=tours, mentorteams=mentorteams)
def settings():
if request.method == "POST":
if 'cancel' in request.form:
flash(escape("Ændringer annulleret"))
return redirect(url_for('usermanager.overview'))
username = session["username"]
b = data.Bucket(request.form)
b.name
b.email
b.phone
b.address
b.zipcode
b.city
b.birthday = nonify(b.birthday)
b.driverslicence = "driverslicence" in request.form
b.diku_age
b.about_me # = request.form["about_me"]
b >> ("UPDATE Users $ WHERE username = ?", username)
return redirect(url_for('usermanager.user', username=username))
else:
user = data.execute("SELECT * FROM Users WHERE username = ?",
session["username"])
user = user[0]
user = unnonify(user)
birthday = user["birthday"]
if birthday == None:
birthday = ""
elif isinstance(birthday, datetime.date):
birthday = birthday.isoformat()
w = html.WebBuilder()
w.form()
w.formtable()
w.textfield("name", "Fulde navn")
w.textfield("email", "Email")
w.textfield("phone", "Telefonnummer")
w.textfield("address", "Adresse")
w.textfield("zipcode", "Postnummer")
w.textfield("city", "By")
w.calendar("birthday", "Fødselsdag")
w.checkbox("driverslicence", "Har du kørekort?")
w.textfield("diku_age", "Hvornår startede du på DIKU?")
w.textarea("about_me", "Lidt om mig")
form = w.create(user)
return render_template("form.html", form=form)
def settings():
if request.method == "POST":
if 'cancel' in request.form:
flash(escape("Ændringer annulleret"))
return redirect(url_for('usermanager.overview'))
username = session["username"]
b = data.Bucket(request.form)
b.name
b.email
b.phone
b.address
b.zipcode
b.city
b.birthday = nonify(b.birthday)
b.driverslicence = "driverslicence" in request.form
b.diku_age
b.about_me# = request.form["about_me"]
b >> ("UPDATE Users $ WHERE username = ?", username)
return redirect(url_for('usermanager.user', username=username))
else:
user = data.execute("SELECT * FROM Users WHERE username = ?", session["username"])
user = user[0]
user = unnonify(user)
birthday = user["birthday"]
if birthday == None:
birthday = ""
elif isinstance(birthday, datetime.date):
birthday = birthday.isoformat()
w = html.WebBuilder()
w.form()
w.formtable()
w.textfield("name", "Fulde navn")
w.textfield("email", "Email")
w.textfield("phone", "Telefonnummer")
w.textfield("address", "Adresse")
w.textfield("zipcode", "Postnummer")
w.textfield("city", "By")
w.calendar("birthday", "Fødselsdag")
w.checkbox("driverslicence", "Har du kørekort?")
w.textfield("diku_age", "Hvornår startede du på DIKU?")
w.textarea("about_me", "Lidt om mig")
form = w.create(user)
return render_template("form.html", form=form)
def user(username):
user = data.execute("SELECT * FROM Users WHERE username = ?", username)
user = user[0]
user = unnonify(user)
tours = data.execute(
"SELECT t_id, tour_name, year, type FROM Tours INNER JOIN Tours_tutors USING (t_id) WHERE username = ? ORDER BY YEAR DESC",
username)
mentorteams = data.execute(
"SELECT m_id, mentor_names, year FROM Mentorteams INNER JOIN Mentors USING (m_id) WHERE username = ? ORDER BY YEAR DESC",
username)
return render_template("usermanager/user.html",
user=user,
tours=tours,
mentorteams=mentorteams)
