Male and Female participants stats on website.
authorMadhusudan.C.S <madhusudancs@gmail.com>
Thu, 09 Dec 2010 19:49:27 +0530
changeset 350 baf939071b60
parent 349 4a07363689b5
child 351 defd9ea5f143
Male and Female participants stats on website.
project/scipycon/registration/views.py
project/templates/registration/regstats.html
--- a/project/scipycon/registration/views.py	Thu Dec 09 19:34:39 2010 +0530
+++ b/project/scipycon/registration/views.py	Thu Dec 09 19:49:27 2010 +0530
@@ -328,21 +328,61 @@
     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
--- a/project/templates/registration/regstats.html	Thu Dec 09 19:34:39 2010 +0530
+++ b/project/templates/registration/regstats.html	Thu Dec 09 19:49:27 2010 +0530
@@ -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/>