--- a/event/views.py Wed Apr 21 21:58:16 2010 +0530
+++ b/event/views.py Thu Apr 22 00:36:08 2010 +0530
@@ -1,3 +1,4 @@
+from django.db.models import Sum
from django.http import Http404
from django.shortcuts import render_to_response, redirect
@@ -6,6 +7,7 @@
from offline.event.models import Event
from offline.event.forms import EventCreateForm
+from offline.quiz.models import Quiz
from offline.quiz.utils import correct_quiz
num2name = {"11" : "Day 1 Quiz 1",
@@ -122,3 +124,26 @@
return render_to_response("close_quiz.html", {"admin_key":ADMIN_KEY, "quiz_name":num2name[quiz_num]})
+def list_toppers(request, admin_key, quiz_num):
+ """ check for admin key
+ Then check for quiz_num in ['11', ..]
+ then give appropriate response.
+ """
+
+ if not admin_key == ADMIN_KEY:
+ raise Http404
+
+ try:
+ event = Event.objects.all()[0]
+ except IndexError:
+ return redirect('/event/create/%s'%ADMIN_KEY)
+
+ if quiz_num not in ["11", "12", "21"]:
+ raise Http404
+
+ quizzes = Quiz.objects.filter(event=event,quiz_num=quiz_num)
+ quizzes_with_scores = quizzes.annotate(score=Sum('que_answered__is_correct'))
+ sorted_quizzes = quizzes_with_scores.order_by("score").reverse()
+
+ return render_to_response("list_toppers.html", {"sorted_quizzes":sorted_quizzes, "event":event, "quiz_name":num2name[quiz_num]})
+