325 sprint_num = reg_q.filter(sprint=True).count() |
325 sprint_num = reg_q.filter(sprint=True).count() |
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 = [] |
|
331 acco_male = [] |
|
332 acco_female= [] |
|
333 |
330 |
334 # Day 1 details |
331 # Day 1 details |
335 acco_days.append(acco_q.filter(accommodation_on_1st=True).count()) |
332 day1 = acco_q.filter(accommodation_on_1st=True) |
336 acco_male.append(acco_q.filter( |
333 acco_1 = { |
337 accommodation_on_1st=True).filter(sex='Male').count()) |
334 'total': day1.count(), |
338 acco_female.append(acco_q.filter( |
335 'male': day1.filter(sex='Male').count(), |
339 accommodation_on_1st=True).filter(sex='Female').count()) |
336 'female': day1.filter(sex='Female').count() |
|
337 } |
340 |
338 |
341 # Day 2 details |
339 # Day 2 details |
342 acco_days.append(acco_q.filter(accommodation_on_2nd=True).count()) |
340 day2 = acco_q.filter(accommodation_on_2nd=True) |
343 acco_male.append(acco_q.filter( |
341 acco_2 = { |
344 accommodation_on_2nd=True).filter(sex='Male').count()) |
342 'total': day2.count(), |
345 acco_female.append(acco_q.filter( |
343 'male': day2.filter(sex='Male').count(), |
346 accommodation_on_2nd=True).filter(sex='Female').count()) |
344 'female': day2.filter(sex='Female').count() |
|
345 } |
347 |
346 |
348 # Day 3 details |
347 # Day 3 details |
349 acco_days.append(acco_q.filter(accommodation_on_3rd=True).count()) |
348 day3 = acco_q.filter(accommodation_on_3rd=True) |
350 acco_male.append(acco_q.filter( |
349 acco_3 = { |
351 accommodation_on_3rd=True).filter(sex='Male').count()) |
350 'total': day3.count(), |
352 acco_female.append(acco_q.filter( |
351 'male': day3.filter(sex='Male').count(), |
353 accommodation_on_3rd=True).filter(sex='Female').count()) |
352 'female': day3.filter(sex='Female').count() |
|
353 } |
354 |
354 |
355 # Day 4 details |
355 # Day 4 details |
356 acco_days.append(acco_q.filter(accommodation_on_4th=True).count()) |
356 day4 = acco_q.filter(accommodation_on_4th=True) |
357 acco_male.append(acco_q.filter( |
357 acco_4 = { |
358 accommodation_on_4th=True).filter(sex='Male').count()) |
358 'total': day4.count(), |
359 acco_female.append(acco_q.filter( |
359 'male': day4.filter(sex='Male').count(), |
360 accommodation_on_4th=True).filter(sex='Female').count()) |
360 'female': day4.filter(sex='Female').count() |
|
361 } |
|
362 |
361 |
363 |
362 # Day 5 details |
364 # Day 5 details |
363 acco_days.append(acco_q.filter(accommodation_on_5th=True).count()) |
365 day5 = acco_q.filter(accommodation_on_5th=True) |
364 acco_male.append(acco_q.filter( |
366 acco_5 = { |
365 accommodation_on_5th=True).filter(sex='Male').count()) |
367 'total': day5.count(), |
366 acco_female.append(acco_q.filter( |
368 'male': day5.filter(sex='Male').count(), |
367 accommodation_on_5th=True).filter(sex='Female').count()) |
369 'female': day5.filter(sex='Female').count() |
|
370 } |
368 |
371 |
369 # Day 6 details |
372 # Day 6 details |
370 acco_days.append(acco_q.filter(accommodation_on_6th=True).count()) |
373 day6 = acco_q.filter(accommodation_on_6th=True) |
371 acco_male.append(acco_q.filter( |
374 acco_6 = { |
372 accommodation_on_6th=True).filter(sex='Male').count()) |
375 'total': day6.count(), |
373 acco_female.append(acco_q.filter( |
376 'male': day6.filter(sex='Male').count(), |
374 accommodation_on_6th=True).filter(sex='Female').count()) |
377 'female': day6.filter(sex='Female').count() |
|
378 } |
375 |
379 |
376 return render_to_response(template_name, RequestContext(request, |
380 return render_to_response(template_name, RequestContext(request, |
377 {'params': {'scope': scope}, |
381 {'params': {'scope': scope}, |
378 'conf_num': conf_num, |
382 'conf_num': conf_num, |
379 'tut_num': tut_num, |
383 'tut_num': tut_num, |
380 'sprint_num': sprint_num, |
384 'sprint_num': sprint_num, |
381 'male': male, |
385 'male': male, |
382 'female':female, |
386 'female':female, |
383 'acco_days': acco_days, |
387 'acco_days': [acco_1, acco_2, acco_3, acco_4, acco_5, acco_6], |
384 'acco_male': acco_male, |
|
385 'acco_female': acco_female, |
|
386 })) |
388 })) |
387 |
389 |
388 @login_required |
390 @login_required |
389 def regstats_download(request, scope): |
391 def regstats_download(request, scope): |
390 """Sends a downloadable PDF for registration statistics |
392 """Sends a downloadable PDF for registration statistics |