def user_grade_details(module_title):
""" displays grades to the user by the requested module. """
modules_list = db.get_module_names()
# check url is valid
if module_title.lower() not in modules_list:
flash("Invalid module title.", "invalid")
return redirect(url_for('user_module_list'))
modules = db.get_module_info()
num_correct_answers = db.get_number_of_correct_answers(g.username, module_title)
number_of_questions = db.get_total_number_of_questions(module_title)
module_id = db.get_module_id_from_name(module_title)
quizzes = db.get_quiz_questions_by_module(module_id)
answers = db.get_quiz_answers()
correct_answers = db.get_correct_answers()
user_answers= db.get_quiz_answers_by_user(g.username)
stats = db.get_question_statistics()
for quiz in quizzes:
for stat in stats:
if stat['QUESTION_ID'] == quiz['QUESTION_ID']:
if ("SUCCESS" not in quiz or quiz['SUCCESS'] == 0):
quiz['SUCCESS'] = int(stat['PERCENT_SUCCESS'])
else:
if ("SUCCESS" not in quiz):
quiz['SUCCESS'] = 0
try:
percentage_correct = int((num_correct_answers /float( number_of_questions)) * 100)
except ZeroDivisionError:
percentage_correct = 0
if g.username not in g.admins:
return render_template('user_grades.html', name = g.user,
subtitle = "My Grades: " + module_title,
correct_answers = correct_answers, user_answers = user_answers,
num_correct_answers = num_correct_answers,
number_of_questions = number_of_questions,
percentage_correct = percentage_correct,
quizzes = quizzes, answers = answers,
module_title = module_title, modules = modules, is_admin = False)
return redirect(url_for('admin_dashboard'))
def user_grade_list():
""" displays grades to the user for all the modules they have completed. """
modules = db.get_module_info()
grades = completed_module_ids = db.modules_completed_by_user(g.username)
completed_modules = []
for module in modules:
if module['MODULE_ID'] in completed_module_ids:
number_of_questions = db.get_total_number_of_questions(module['NAME'])
correct_answers = db.get_number_of_correct_answers(g.username, module['NAME'])
module['GRADE'] = int(correct_answers / float(number_of_questions) * 100)
completed_modules.append(module)
if g.username not in g.admins:
return render_template('user_gradebook.html',
pagetitle = g.appname + " - My Grades",
subtitle = "My Grades",
name = g.user,
completed_modules = completed_modules,
is_admin = False)
return redirect(url_for('admin_dashboard'))
