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'))