def pregnancy(request):
context = {'category': 'credos', 'subcategory': 'pregnancy'}
periods = all_periods(MonthPeriod)
indicators = []
evol_data = {'fe': {'label': u"Total femmes enceintes", 'values': {}},
'ae': {'label': u"Accouchement enregistrés", 'values': {}},
'gi': {'label': u"Grossesses interrompues", 'values': {}},
'av': {'label': u"Grossesses avec enfants vivants",
'values': {}},
'mn': {'label': u"Grossesses avec morts nées", 'values': {}}}
for month in periods:
indicator = sum_month(month)
indicators.append(indicator)
indicator['rate_fe'] = rate_cal(indicator['fe'], indicator['fe'])
indicator['rate_ae'] = rate_cal(indicator['ae'], indicator['fe'])
indicator['rate_gi'] = rate_cal(indicator['gi'], indicator['fe'])
indicator['rate_av'] = rate_cal(indicator['av'], indicator['fe'])
indicator['rate_mn'] = rate_cal(indicator['mn'], indicator['fe'])
evol_data['fe']['values'][month.pid] = {'value': indicator['fe']}
evol_data['ae']['values'][month.pid] = {'value': indicator['ae']}
evol_data['gi']['values'][month.pid] = {'value': indicator['gi']}
evol_data['av']['values'][month.pid] = {'value': indicator['av']}
evol_data['mn']['values'][month.pid] = {'value': indicator['mn']}
context.update({'indicators': indicators, 'evol_data': evol_data.items(),
'periods': periods})
return render(request, 'pregnancy.html', context)
def excel_export(request):
indicators = []
periods = all_periods(MonthPeriod)
evol_data = {'birth': {'label': u"Total naissance", 'values': {}},
'residence': {'label': u"Domicile", 'values': {}},
'center': {'label': u"Centre", 'values': {}},
'other': {'label': u"Ailleurs", 'values': {}},
'male': {'label': u"Sexe masculin", 'values': {}},
'female': {'label': u"Sexe feminin", 'values': {}},
'alive': {'label': u"Né vivant",
'values': {}},
'stillborn': {'label': u"Mort-né", 'values': {}}}
for month in periods:
indicator = sum_month(month)
indicator['rate_birth'] = rate_cal(indicator['birth'],
indicator['birth'])
indicator['rate_residence'] = rate_cal(indicator['residence'],
indicator['birth'])
indicator['rate_center'] = rate_cal(indicator['center'],
indicator['birth'])
indicator['rate_other'] = rate_cal(indicator['other'],
indicator['birth'])
indicator['rate_male'] = rate_cal(indicator['male'],
indicator['birth'])
indicator['rate_female'] = rate_cal(indicator['female'],
indicator['birth'])
indicator['rate_alive'] = rate_cal(indicator['alive'],
indicator['birth'])
indicator['rate_stillborn'] = rate_cal(indicator['stillborn'],
indicator['birth'])
evol_data['birth']['values'][month.pid] = {'value': indicator['birth']}
evol_data['residence']['values'][month.pid] = \
{'value': indicator['residence']}
evol_data['center']['values'][month.pid] = \
{'value': indicator['center']}
evol_data['other']['values'][month.pid] = \
{'value': indicator['other']}
evol_data['male']['values'][month.pid] = \
{'value': indicator['male']}
evol_data['female']['values'][month.pid] = \
{'value': indicator['female']}
evol_data['alive']['values'][month.pid] = \
{'value': indicator['alive']}
evol_data['stillborn']['values'][month.pid] = \
{'value': indicator['stillborn']}
indicators.append(indicator)
file_name = 'Rapports mensuels de naissances.xls'
file_content = birth_as_excel(indicators).getvalue()
response = HttpResponse(file_content, \
content_type='application/vnd.ms-excel')
response['Content-Disposition'] = 'attachment; filename="%s"' % file_name
response['Content-Length'] = len(file_content)
return response
def birth(request):
context = {'category': 'credos', 'subcategory': 'birth'}
indicators = []
periods = all_periods(MonthPeriod)
evol_data = {'birth': {'label': u"Total naissance", 'values': {}},
'residence': {'label': u"Domicile", 'values': {}},
'center': {'label': u"Centre", 'values': {}},
'other': {'label': u"Ailleurs", 'values': {}},
'male': {'label': u"Sexe masculin", 'values': {}},
'female': {'label': u"Sexe feminin", 'values': {}},
'alive': {'label': u"Né vivant",
'values': {}},
'stillborn': {'label': u"Mort-né", 'values': {}}}
for month in periods:
indicator = sum_month(month)
indicator['rate_birth'] = rate_cal(indicator['birth'],
indicator['birth'])
indicator['rate_residence'] = rate_cal(indicator['residence'],
indicator['birth'])
indicator['rate_center'] = rate_cal(indicator['center'],
indicator['birth'])
indicator['rate_other'] = rate_cal(indicator['other'],
indicator['birth'])
indicator['rate_male'] = rate_cal(indicator['male'],
indicator['birth'])
indicator['rate_female'] = rate_cal(indicator['female'],
indicator['birth'])
indicator['rate_alive'] = rate_cal(indicator['alive'],
indicator['birth'])
indicator['rate_stillborn'] = rate_cal(indicator['stillborn'],
indicator['birth'])
evol_data['birth']['values'][month.pid] = {'value': indicator['birth']}
evol_data['residence']['values'][month.pid] = \
{'value': indicator['residence']}
evol_data['center']['values'][month.pid] = \
{'value': indicator['center']}
evol_data['other']['values'][month.pid] = \
{'value': indicator['other']}
evol_data['male']['values'][month.pid] = \
{'value': indicator['male']}
evol_data['female']['values'][month.pid] = \
{'value': indicator['female']}
evol_data['alive']['values'][month.pid] = \
{'value': indicator['alive']}
evol_data['stillborn']['values'][month.pid] = \
{'value': indicator['stillborn']}
indicators.append(indicator)
context.update({'indicators': indicators,
'evol_data': evol_data.items(),
'periods': periods})
return render(request, 'birth.html', context)
def death(request):
context = {'category': 'credos', 'subcategory': 'death'}
indicators = []
periods = all_periods(MonthPeriod)
evol_data = {'ntd': {'label': u"Total décès", 'values': {}},
'dd': {'label': u"Domicile", 'values': {}},
'dc': {'label': u"Centre", 'values': {}},
'da': {'label': u"Ailleurs", 'values': {}},
'sm': {'label': u"Sexe masculin", 'values': {}},
'sf': {'label': u"Sexe feminin", 'values': {}}}
for month in periods:
indicator = sum_month(month)
indicators.append(indicator)
indicator['rate_ntd'] = rate_cal(indicator['ntd'], indicator['ntd'])
indicator['rate_dd'] = rate_cal(indicator['dd'], indicator['ntd'])
indicator['rate_dc'] = rate_cal(indicator['dc'], indicator['ntd'])
indicator['rate_da'] = rate_cal(indicator['da'], indicator['ntd'])
indicator['rate_sm'] = rate_cal(indicator['sm'], indicator['ntd'])
indicator['rate_sf'] = rate_cal(indicator['sf'], indicator['ntd'])
evol_data['ntd']['values'][month.pid] = {'value': indicator['ntd']}
evol_data['dd']['values'][month.pid] = {'value': indicator['dd']}
evol_data['dc']['values'][month.pid] = {'value': indicator['dc']}
evol_data['da']['values'][month.pid] = {'value': indicator['da']}
evol_data['sm']['values'][month.pid] = {'value': indicator['sm']}
evol_data['sf']['values'][month.pid] = {'value': indicator['sf']}
context.update({'indicators': indicators,
'evol_data': evol_data.items(),
'periods': periods})
return render(request, 'death.html', context)
def excel_export(request):
periods = all_periods(MonthPeriod)
indicators = []
evol_data = {'fe': {'label': u"Total femmes enceintes", 'values': {}},
'ae': {'label': u"Accouchement enregistrés", 'values': {}},
'gi': {'label': u"Grossesses interrompues", 'values': {}},
'av': {'label': u"Grossesses avec enfants vivants",
'values': {}},
'mn': {'label': u"Grossesses avec morts nées", 'values': {}}}
for month in periods:
indicator = sum_month(month)
indicators.append(indicator)
indicator['rate_fe'] = rate_cal(indicator['fe'], indicator['fe'])
indicator['rate_ae'] = rate_cal(indicator['ae'], indicator['fe'])
indicator['rate_gi'] = rate_cal(indicator['gi'], indicator['fe'])
indicator['rate_av'] = rate_cal(indicator['av'], indicator['fe'])
indicator['rate_mn'] = rate_cal(indicator['mn'], indicator['fe'])
evol_data['fe']['values'][month.pid] = {'value': indicator['fe']}
evol_data['ae']['values'][month.pid] = {'value': indicator['ae']}
evol_data['gi']['values'][month.pid] = {'value': indicator['gi']}
evol_data['av']['values'][month.pid] = {'value': indicator['av']}
evol_data['mn']['values'][month.pid] = {'value': indicator['mn']}
file_name = 'Rapports mensuels de grossesses.xls'
file_content = pregnancy_as_excel(indicators).getvalue()
response = HttpResponse(file_content, \
content_type='application/vnd.ms-excel')
response['Content-Disposition'] = 'attachment; filename="%s"' % file_name
response['Content-Length'] = len(file_content)
return response
def excel_export(request):
indicators = []
periods = all_periods(MonthPeriod)
evol_data = {'ntd': {'label': u"Total décès", 'values': {}},
'dd': {'label': u"Domicile", 'values': {}},
'dc': {'label': u"Centre", 'values': {}},
'da': {'label': u"Ailleurs", 'values': {}},
'sm': {'label': u"Sexe masculin", 'values': {}},
'sf': {'label': u"Sexe feminin", 'values': {}}}
for month in periods:
indicator = sum_month(month)
indicators.append(indicator)
indicator['rate_ntd'] = rate_cal(indicator['ntd'], indicator['ntd'])
indicator['rate_dd'] = rate_cal(indicator['dd'], indicator['ntd'])
indicator['rate_dc'] = rate_cal(indicator['dc'], indicator['ntd'])
indicator['rate_da'] = rate_cal(indicator['da'], indicator['ntd'])
indicator['rate_sm'] = rate_cal(indicator['sm'], indicator['ntd'])
indicator['rate_sf'] = rate_cal(indicator['sf'], indicator['ntd'])
evol_data['ntd']['values'][month.pid] = {'value': indicator['ntd']}
evol_data['dd']['values'][month.pid] = {'value': indicator['dd']}
evol_data['dc']['values'][month.pid] = {'value': indicator['dc']}
evol_data['da']['values'][month.pid] = {'value': indicator['da']}
evol_data['sm']['values'][month.pid] = {'value': indicator['sm']}
evol_data['sf']['values'][month.pid] = {'value': indicator['sf']}
file_content = death_as_excel(indicators).getvalue()
file_name = 'Rapports mensuels de décès infantile.xls'
response = HttpResponse(file_content, \
content_type='application/vnd.ms-excel')
response['Content-Disposition'] = 'attachment; filename="%s"' % file_name
response['Content-Length'] = len(file_content)
return response
