From 177b37f4650ba69d7d1bac07e78eb51bff786b37 Mon Sep 17 00:00:00 2001
From: Madhusudan.C.S
Date: Thu, 9 Dec 2010 19:49:27 +0530
Subject: Male and Female participants stats on website.

---
 project/scipycon/registration/views.py       | 42 +++++++++++++++++++++++++++-
 project/templates/registration/regstats.html | 12 ++++++++
 2 files changed, 53 insertions(+), 1 deletion(-)

diff --git a/project/scipycon/registration/views.py b/project/scipycon/registration/views.py
index 0db3fab..cad429d 100644
--- a/project/scipycon/registration/views.py
+++ b/project/scipycon/registration/views.py
@@ -328,21 +328,61 @@ def regstats(request, scope,
     male = acco_q.filter(sex='Male').count()
     female = acco_q.filter(sex='Female').count()
     acco_days = []
+    acco_male = []
+    acco_female= []
+
+    # Day 1 details
     acco_days.append(acco_q.filter(accommodation_on_1st=True).count())
+    acco_male.append(acco_q.filter(
+      accommodation_on_1st=True).filter(sex='Male').count())
+    acco_female.append(acco_q.filter(
+      accommodation_on_1st=True).filter(sex='Female').count())
+
+    # Day 2 details
     acco_days.append(acco_q.filter(accommodation_on_2nd=True).count())
+    acco_male.append(acco_q.filter(
+      accommodation_on_2nd=True).filter(sex='Male').count())
+    acco_female.append(acco_q.filter(
+      accommodation_on_2nd=True).filter(sex='Female').count())
+
+    # Day 3 details
     acco_days.append(acco_q.filter(accommodation_on_3rd=True).count())
+    acco_male.append(acco_q.filter(
+      accommodation_on_3rd=True).filter(sex='Male').count())
+    acco_female.append(acco_q.filter(
+      accommodation_on_3rd=True).filter(sex='Female').count())
+
+    # Day 4 details
     acco_days.append(acco_q.filter(accommodation_on_4th=True).count())
+    acco_male.append(acco_q.filter(
+      accommodation_on_4th=True).filter(sex='Male').count())
+    acco_female.append(acco_q.filter(
+      accommodation_on_4th=True).filter(sex='Female').count())
+
+    # Day 5 details
     acco_days.append(acco_q.filter(accommodation_on_5th=True).count())
+    acco_male.append(acco_q.filter(
+      accommodation_on_5th=True).filter(sex='Male').count())
+    acco_female.append(acco_q.filter(
+      accommodation_on_5th=True).filter(sex='Female').count())
+
+    # Day 6 details
     acco_days.append(acco_q.filter(accommodation_on_6th=True).count())
+    acco_male.append(acco_q.filter(
+      accommodation_on_6th=True).filter(sex='Male').count())
+    acco_female.append(acco_q.filter(
+      accommodation_on_6th=True).filter(sex='Female').count())
 
     return render_to_response(template_name, RequestContext(request,
         {'params': {'scope': scope},
          'conf_num': conf_num, 
          'tut_num': tut_num,
          'sprint_num': sprint_num,
-         'acco_days': acco_days,
          'male': male,
          'female':female,
+         'acco_days': acco_days,
+         'acco_male': acco_male,
+         'acco_female': acco_female,
          }))
 
 @login_required
diff --git a/project/templates/registration/regstats.html b/project/templates/registration/regstats.html
index 681e00d..6baf8ec 100644
--- a/project/templates/registration/regstats.html
+++ b/project/templates/registration/regstats.html
@@ -36,6 +36,18 @@
    <td>{{ acco }}</td>
   </tr>
  {% endfor %}
+ {% for acco_m in acco_male %}
+  <tr>
+   <td>Accommodation on {{ forloop.counter|add:"11" }}(Male)</td>
+   <td>{{ acco_m }}</td>
+  </tr>
+ {% endfor %}
+ {% for acco_f in acco_days %}
+  <tr>
+   <td>Accommodation on {{ forloop.counter|add:"11" }}(Female)</td>
+   <td>{{ acco_f }}</td>
+  </tr>
+ {% endfor %}
 </table>
 
 <br/><br/><br/>
-- 
cgit