326 |
326 |
327 acco_q = Accommodation.objects.all() |
327 acco_q = Accommodation.objects.all() |
328 male = acco_q.filter(sex='Male').count() |
328 male = acco_q.filter(sex='Male').count() |
329 female = acco_q.filter(sex='Female').count() |
329 female = acco_q.filter(sex='Female').count() |
330 acco_days = [] |
330 acco_days = [] |
|
331 acco_male = [] |
|
332 acco_female= [] |
|
333 |
|
334 # Day 1 details |
331 acco_days.append(acco_q.filter(accommodation_on_1st=True).count()) |
335 acco_days.append(acco_q.filter(accommodation_on_1st=True).count()) |
|
336 acco_male.append(acco_q.filter( |
|
337 accommodation_on_1st=True).filter(sex='Male').count()) |
|
338 acco_female.append(acco_q.filter( |
|
339 accommodation_on_1st=True).filter(sex='Female').count()) |
|
340 |
|
341 # Day 2 details |
332 acco_days.append(acco_q.filter(accommodation_on_2nd=True).count()) |
342 acco_days.append(acco_q.filter(accommodation_on_2nd=True).count()) |
|
343 acco_male.append(acco_q.filter( |
|
344 accommodation_on_2nd=True).filter(sex='Male').count()) |
|
345 acco_female.append(acco_q.filter( |
|
346 accommodation_on_2nd=True).filter(sex='Female').count()) |
|
347 |
|
348 # Day 3 details |
333 acco_days.append(acco_q.filter(accommodation_on_3rd=True).count()) |
349 acco_days.append(acco_q.filter(accommodation_on_3rd=True).count()) |
|
350 acco_male.append(acco_q.filter( |
|
351 accommodation_on_3rd=True).filter(sex='Male').count()) |
|
352 acco_female.append(acco_q.filter( |
|
353 accommodation_on_3rd=True).filter(sex='Female').count()) |
|
354 |
|
355 # Day 4 details |
334 acco_days.append(acco_q.filter(accommodation_on_4th=True).count()) |
356 acco_days.append(acco_q.filter(accommodation_on_4th=True).count()) |
|
357 acco_male.append(acco_q.filter( |
|
358 accommodation_on_4th=True).filter(sex='Male').count()) |
|
359 acco_female.append(acco_q.filter( |
|
360 accommodation_on_4th=True).filter(sex='Female').count()) |
|
361 |
|
362 # Day 5 details |
335 acco_days.append(acco_q.filter(accommodation_on_5th=True).count()) |
363 acco_days.append(acco_q.filter(accommodation_on_5th=True).count()) |
|
364 acco_male.append(acco_q.filter( |
|
365 accommodation_on_5th=True).filter(sex='Male').count()) |
|
366 acco_female.append(acco_q.filter( |
|
367 accommodation_on_5th=True).filter(sex='Female').count()) |
|
368 |
|
369 # Day 6 details |
336 acco_days.append(acco_q.filter(accommodation_on_6th=True).count()) |
370 acco_days.append(acco_q.filter(accommodation_on_6th=True).count()) |
|
371 acco_male.append(acco_q.filter( |
|
372 accommodation_on_6th=True).filter(sex='Male').count()) |
|
373 acco_female.append(acco_q.filter( |
|
374 accommodation_on_6th=True).filter(sex='Female').count()) |
337 |
375 |
338 return render_to_response(template_name, RequestContext(request, |
376 return render_to_response(template_name, RequestContext(request, |
339 {'params': {'scope': scope}, |
377 {'params': {'scope': scope}, |
340 'conf_num': conf_num, |
378 'conf_num': conf_num, |
341 'tut_num': tut_num, |
379 'tut_num': tut_num, |
342 'sprint_num': sprint_num, |
380 'sprint_num': sprint_num, |
343 'acco_days': acco_days, |
|
344 'male': male, |
381 'male': male, |
345 'female':female, |
382 'female':female, |
|
383 'acco_days': acco_days, |
|
384 'acco_male': acco_male, |
|
385 'acco_female': acco_female, |
346 })) |
386 })) |
347 |
387 |
348 @login_required |
388 @login_required |
349 def regstats_download(request, scope): |
389 def regstats_download(request, scope): |
350 """Sends a downloadable PDF for registration statistics |
390 """Sends a downloadable PDF for registration statistics |