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