def qualifications(page): if request.method == 'POST': if 'submit' in request.form: command = request.form['submit'].split('-')[0] id = request.form['submit'].split('-')[1] if command == 'edit': redirect(url_for('qualifications')) elif command == 'delete': item = Qualification.query.filter_by(id=id).first() db.session.delete(item) db.session.commit() query = Qualification.query.order_by(Qualification.name, Qualification.year).all count = len(query()) qualifications = utilities.get_items_for_page(query, page) table_header = ['ID', 'Name', 'Locale', 'Year', 'Number of Students', 'Actions'] table_data = [[str(q.id), q.name, q.locale, q.year, q.num_students] for q in qualifications] if not qualifications and page != 1: abort(404) pagination = Pagination(query(), page, app.config['PER_PAGE'], count, qualifications) return render_template('data_display.html', user=current_user.name, user_role=current_user.role.name, table_header=table_header, table_data=table_data, pagination=pagination)
def qualifications(page): if request.method == 'POST': if 'submit' in request.form: command = request.form['submit'].split('-')[0] id = request.form['submit'].split('-')[1] if command == 'edit': redirect(url_for('qualifications')) elif command == 'delete': item = Qualification.query.filter_by(id=id).first() db.session.delete(item) db.session.commit() query = Qualification.query.order_by(Qualification.name, Qualification.year).all count = len(query()) qualifications = utilities.get_items_for_page(query, page) table_header = [ 'ID', 'Name', 'Locale', 'Year', 'Number of Students', 'Actions' ] table_data = [[str(q.id), q.name, q.locale, q.year, q.num_students] for q in qualifications] if not qualifications and page != 1: abort(404) pagination = Pagination(query(), page, app.config['PER_PAGE'], count, qualifications) return render_template('data_display.html', user=current_user.name, user_role=current_user.role.name, table_header=table_header, table_data=table_data, pagination=pagination)
def admin_users(page): if request.method == 'POST': if 'submit' in request.form: command = request.form['submit'].split('-')[0] email = request.form['submit'].split('-')[1] if command == 'disable': User.query.filter_by(email=email).first().is_live = False db.session.commit() elif command == 'enable': User.query.filter_by(email=email).first().is_live = True db.session.commit() query = User.query.all count = len(query()) users = utilities.get_items_for_page(query, page) table_header = ['ID', 'Name', 'Email Address', 'Role', 'Is Live?', 'Enable/Disable'] table_data = [[str(user.id), user.name, user.email, user.role.name, user.is_live] for user in users] if not users and page != 1: abort(404) pagination = Pagination(query(), page, app.config['PER_PAGE'], count, users) return render_template('admin_users.html', user=current_user.name, user_role=current_user.role.name, all_users_header=table_header, all_users_list=table_data, pagination=pagination)
def admin_users(page): if request.method == 'POST': if 'submit' in request.form: command = request.form['submit'].split('-')[0] email = request.form['submit'].split('-')[1] if command == 'disable': User.query.filter_by(email=email).first().is_live = False db.session.commit() elif command == 'enable': User.query.filter_by(email=email).first().is_live = True db.session.commit() query = User.query.all count = len(query()) users = utilities.get_items_for_page(query, page) table_header = [ 'ID', 'Name', 'Email Address', 'Role', 'Is Live?', 'Enable/Disable' ] table_data = [[ str(user.id), user.name, user.email, user.role.name, user.is_live ] for user in users] if not users and page != 1: abort(404) pagination = Pagination(query(), page, app.config['PER_PAGE'], count, users) return render_template('admin_users.html', user=current_user.name, user_role=current_user.role.name, all_users_header=table_header, all_users_list=table_data, pagination=pagination)