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)