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)
