def get_maternal_child_data(domain,
config,
show_test=False,
icds_feature_flag=False):
def get_data_for_child_health_monthly(date, filters):
age_filters = {
'age_tranche': 72
} if icds_feature_flag else {
'age_tranche__in': [0, 6, 72]
}
moderately_underweight = exclude_records_by_age_for_column(
{'age_tranche': 72}, 'nutrition_status_moderately_underweight')
severely_underweight = exclude_records_by_age_for_column(
{'age_tranche': 72}, 'nutrition_status_severely_underweight')
wasting_moderate = exclude_records_by_age_for_column(
age_filters, wasting_moderate_column(icds_feature_flag))
wasting_severe = exclude_records_by_age_for_column(
age_filters, wasting_severe_column(icds_feature_flag))
stunting_moderate = exclude_records_by_age_for_column(
age_filters, stunting_moderate_column(icds_feature_flag))
stunting_severe = exclude_records_by_age_for_column(
age_filters, stunting_severe_column(icds_feature_flag))
nutrition_status_weighed = exclude_records_by_age_for_column(
{'age_tranche': 72}, 'nutrition_status_weighed')
height_measured_in_month = exclude_records_by_age_for_column(
age_filters, hfa_recorded_in_month_column(icds_feature_flag))
weighed_and_height_measured_in_month = exclude_records_by_age_for_column(
age_filters, wfh_recorded_in_month_column(icds_feature_flag))
queryset = AggChildHealthMonthly.objects.filter(
month=date, **filters).values('aggregation_level').annotate(
underweight=(Sum(moderately_underweight) +
Sum(severely_underweight)),
valid=Sum(nutrition_status_weighed),
wasting=Sum(wasting_moderate) + Sum(wasting_severe),
stunting=Sum(stunting_moderate) + Sum(stunting_severe),
height_measured_in_month=Sum(height_measured_in_month),
weighed_and_height_measured_in_month=Sum(
weighed_and_height_measured_in_month),
low_birth_weight=Sum('low_birth_weight_in_month'),
bf_birth=Sum('bf_at_birth'),
born=Sum('born_in_month'),
weighed_and_born_in_month=Sum('weighed_and_born_in_month'),
ebf=Sum('ebf_in_month'),
ebf_eli=Sum('ebf_eligible'),
cf_initiation=Sum('cf_initiation_in_month'),
cf_initiation_eli=Sum('cf_initiation_eligible'))
if not show_test:
queryset = apply_exclude(domain, queryset)
return queryset
def get_data_for_deliveries(date, filters):
queryset = AggCcsRecordMonthly.objects.filter(
month=date, **filters).values('aggregation_level').annotate(
institutional_delivery=Sum('institutional_delivery_in_month'),
delivered=Sum('delivered_in_month'))
if not show_test:
queryset = apply_exclude(domain, queryset)
return queryset
current_month = datetime(*config['month'])
previous_month = datetime(*config['prev_month'])
del config['month']
del config['prev_month']
this_month_data = get_data_for_child_health_monthly(current_month, config)
prev_month_data = get_data_for_child_health_monthly(previous_month, config)
deliveries_this_month = get_data_for_deliveries(current_month, config)
deliveries_prev_month = get_data_for_deliveries(previous_month, config)
gender_label, age_label, chosen_filters = chosen_filters_to_labels(
config, default_interval=default_age_interval(icds_feature_flag))
return {
'records':
[[{
'label':
_('Underweight (Weight-for-Age)'),
'help_text':
underweight_children_help_text(),
'percent':
percent_diff('underweight', this_month_data, prev_month_data,
'valid'),
'color':
'red' if percent_diff('underweight', this_month_data,
prev_month_data, 'valid') > 0 else 'green',
'value':
get_value(this_month_data, 'underweight'),
'all':
get_value(this_month_data, 'valid'),
'format':
'percent_and_div',
'frequency':
'month',
'redirect':
'maternal_and_child/underweight_children'
}, {
'label':
_('Wasting (Weight-for-Height)'),
'help_text':
_(wasting_help_text(age_label)),
'percent':
percent_diff('wasting', this_month_data, prev_month_data,
'weighed_and_height_measured_in_month'),
'color':
'red' if percent_diff('wasting', this_month_data, prev_month_data,
'weighed_and_height_measured_in_month') > 0
else 'green',
'value':
get_value(this_month_data, 'wasting'),
'all':
get_value(this_month_data, 'weighed_and_height_measured_in_month'),
'format':
'percent_and_div',
'frequency':
'month',
'redirect':
'maternal_and_child/wasting'
}],
[{
'label':
_('Stunting (Height-for-Age)'),
'help_text':
_(stunting_help_text(age_label)),
'percent':
percent_diff('stunting', this_month_data, prev_month_data,
'height_measured_in_month'),
'color':
'red'
if percent_diff('stunting', this_month_data, prev_month_data,
'height_measured_in_month') > 0 else 'green',
'value':
get_value(this_month_data, 'stunting'),
'all':
get_value(this_month_data, 'height_measured_in_month'),
'format':
'percent_and_div',
'frequency':
'month',
'redirect':
'maternal_and_child/stunting'
}, {
'label':
_('Newborns with Low Birth Weight'),
'help_text':
_((new_born_with_low_weight_help_text(html=False))),
'percent':
percent_diff('low_birth_weight', this_month_data, prev_month_data,
'weighed_and_born_in_month'),
'color':
get_color_with_red_positive(
percent_diff('low_birth_weight', this_month_data,
prev_month_data, 'weighed_and_born_in_month')),
'value':
get_value(this_month_data, 'low_birth_weight'),
'all':
get_value(this_month_data, 'weighed_and_born_in_month'),
'format':
'percent_and_div',
'frequency':
'month',
'redirect':
'maternal_and_child/low_birth'
}],
[{
'label':
_('Early Initiation of Breastfeeding'),
'help_text':
early_initiation_breastfeeding_help_text(),
'percent':
percent_diff('bf_birth', this_month_data, prev_month_data,
'born'),
'color':
get_color_with_green_positive(
percent_diff('bf_birth', this_month_data, prev_month_data,
'born')),
'value':
get_value(this_month_data, 'bf_birth'),
'all':
get_value(this_month_data, 'born'),
'format':
'percent_and_div',
'frequency':
'month',
'redirect':
'maternal_and_child/early_initiation'
}, {
'label':
_('Exclusive Breastfeeding'),
'help_text':
exclusive_breastfeeding_help_text(),
'percent':
percent_diff('ebf', this_month_data, prev_month_data, 'ebf_eli'),
'color':
get_color_with_green_positive(
percent_diff('ebf', this_month_data, prev_month_data,
'ebf_eli')),
'value':
get_value(this_month_data, 'ebf'),
'all':
get_value(this_month_data, 'ebf_eli'),
'format':
'percent_and_div',
'frequency':
'month',
'redirect':
'maternal_and_child/exclusive_breastfeeding'
}],
[{
'label':
_('Children initiated appropriate Complementary Feeding'),
'help_text':
children_initiated_appropriate_complementary_feeding_help_text(),
'percent':
percent_diff('cf_initiation', this_month_data, prev_month_data,
'cf_initiation_eli'),
'color':
get_color_with_green_positive(
percent_diff('cf_initiation', this_month_data,
prev_month_data, 'cf_initiation_eli')),
'value':
get_value(this_month_data, 'cf_initiation'),
'all':
get_value(this_month_data, 'cf_initiation_eli'),
'format':
'percent_and_div',
'frequency':
'month',
'redirect':
'maternal_and_child/children_initiated'
}, {
'label':
_('Institutional Deliveries'),
'help_text':
institutional_deliveries_help_text(),
'percent':
percent_diff('institutional_delivery', deliveries_this_month,
deliveries_prev_month, 'delivered'),
'color':
get_color_with_green_positive(
percent_diff('institutional_delivery', deliveries_this_month,
deliveries_prev_month, 'delivered')),
'value':
get_value(deliveries_this_month, 'institutional_delivery'),
'all':
get_value(deliveries_this_month, 'delivered'),
'format':
'percent_and_div',
'frequency':
'month',
'redirect':
'maternal_and_child/institutional_deliveries'
}]]
}
def get_maternal_child_data(domain,
config,
show_test=False,
icds_feature_flag=False):
def get_data_for_child_health_monthly(date, filters):
age_filters = {
'age_tranche': 72
} if icds_feature_flag else {
'age_tranche__in': [0, 6, 72]
}
moderately_underweight = exclude_records_by_age_for_column(
{'age_tranche': 72}, 'nutrition_status_moderately_underweight')
severely_underweight = exclude_records_by_age_for_column(
{'age_tranche': 72}, 'nutrition_status_severely_underweight')
wasting_moderate = exclude_records_by_age_for_column(
age_filters, wasting_moderate_column(icds_feature_flag))
wasting_severe = exclude_records_by_age_for_column(
age_filters, wasting_severe_column(icds_feature_flag))
stunting_moderate = exclude_records_by_age_for_column(
age_filters, stunting_moderate_column(icds_feature_flag))
stunting_severe = exclude_records_by_age_for_column(
age_filters, stunting_severe_column(icds_feature_flag))
nutrition_status_weighed = exclude_records_by_age_for_column(
{'age_tranche': 72}, 'nutrition_status_weighed')
height_measured_in_month = exclude_records_by_age_for_column(
age_filters, hfa_recorded_in_month_column(icds_feature_flag))
weighed_and_height_measured_in_month = exclude_records_by_age_for_column(
age_filters, wfh_recorded_in_month_column(icds_feature_flag))
queryset = AggChildHealthMonthly.objects.filter(
month=date, **filters).values('aggregation_level').annotate(
underweight=(Sum(moderately_underweight) +
Sum(severely_underweight)),
valid=Sum(nutrition_status_weighed),
wasting=Sum(wasting_moderate) + Sum(wasting_severe),
stunting=Sum(stunting_moderate) + Sum(stunting_severe),
height_measured_in_month=Sum(height_measured_in_month),
weighed_and_height_measured_in_month=Sum(
weighed_and_height_measured_in_month),
low_birth_weight=Sum('low_birth_weight_in_month'),
bf_birth=Sum('bf_at_birth'),
born=Sum('born_in_month'),
weighed_and_born_in_month=Sum('weighed_and_born_in_month'),
ebf=Sum('ebf_in_month'),
ebf_eli=Sum('ebf_eligible'),
cf_initiation=Sum('cf_initiation_in_month'),
cf_initiation_eli=Sum('cf_initiation_eligible'))
if not show_test:
queryset = apply_exclude(domain, queryset)
return queryset
def get_data_for_deliveries(date, filters):
queryset = AggCcsRecordMonthly.objects.filter(
month=date, **filters).values('aggregation_level').annotate(
institutional_delivery=Sum('institutional_delivery_in_month'),
delivered=Sum('delivered_in_month'))
if not show_test:
queryset = apply_exclude(domain, queryset)
return queryset
current_month = datetime(*config['month'])
previous_month = datetime(*config['prev_month'])
del config['month']
del config['prev_month']
this_month_data = get_data_for_child_health_monthly(current_month, config)
prev_month_data = get_data_for_child_health_monthly(previous_month, config)
deliveries_this_month = get_data_for_deliveries(current_month, config)
deliveries_prev_month = get_data_for_deliveries(previous_month, config)
return {
'records':
[[{
'label':
_('Underweight (Weight-for-Age)'),
'help_text':
_(("Percentage of children between 0-5 years enrolled for Anganwadi Services with "
"weight-for-age less than -2 standard deviations of the WHO Child Growth Standards "
"median. Children who are moderately or severely underweight have a higher risk of "
"mortality.")),
'percent':
percent_diff('underweight', this_month_data, prev_month_data,
'valid'),
'color':
'red' if percent_diff('underweight', this_month_data,
prev_month_data, 'valid') > 0 else 'green',
'value':
get_value(this_month_data, 'underweight'),
'all':
get_value(this_month_data, 'valid'),
'format':
'percent_and_div',
'frequency':
'month',
'redirect':
'underweight_children'
}, {
'label':
_('Wasting (Weight-for-Height)'),
'help_text':
_(wasting_help_text(icds_feature_flag)),
'percent':
percent_diff('wasting', this_month_data, prev_month_data,
'weighed_and_height_measured_in_month'),
'color':
'red' if percent_diff('wasting', this_month_data, prev_month_data,
'weighed_and_height_measured_in_month') > 0
else 'green',
'value':
get_value(this_month_data, 'wasting'),
'all':
get_value(this_month_data, 'weighed_and_height_measured_in_month'),
'format':
'percent_and_div',
'frequency':
'month',
'redirect':
'wasting'
}],
[{
'label':
_('Stunting (Height-for-Age)'),
'help_text':
_(stunting_help_text(icds_feature_flag)),
'percent':
percent_diff('stunting', this_month_data, prev_month_data,
'height_measured_in_month'),
'color':
'red'
if percent_diff('stunting', this_month_data, prev_month_data,
'height_measured_in_month') > 0 else 'green',
'value':
get_value(this_month_data, 'stunting'),
'all':
get_value(this_month_data, 'height_measured_in_month'),
'format':
'percent_and_div',
'frequency':
'month',
'redirect':
'stunting'
}, {
'label':
_('Newborns with Low Birth Weight'),
'help_text':
_(("Percentage of newborns born with birth weight less than 2500 grams. Newborns with"
" Low Birth Weight are closely associated with foetal and neonatal mortality and "
"morbidity, inhibited growth and cognitive development, and chronic diseases later "
"in life")),
'percent':
percent_diff('low_birth_weight', this_month_data, prev_month_data,
'weighed_and_born_in_month'),
'color':
'red' if
percent_diff('low_birth_weight', this_month_data, prev_month_data,
'weighed_and_born_in_month') > 0 else 'green',
'value':
get_value(this_month_data, 'low_birth_weight'),
'all':
get_value(this_month_data, 'weighed_and_born_in_month'),
'format':
'percent_and_div',
'frequency':
'month',
'redirect':
'low_birth'
}],
[{
'label':
_('Early Initiation of Breastfeeding'),
'help_text':
_(("Percentage of children breastfed within an hour of birth. Early initiation of "
"breastfeeding ensure the newborn receives the 'first milk' rich in nutrients "
"and encourages exclusive breastfeeding practice")),
'percent':
percent_diff('bf_birth', this_month_data, prev_month_data,
'born'),
'color':
'green' if percent_diff('bf_birth', this_month_data,
prev_month_data, 'born') > 0 else 'red',
'value':
get_value(this_month_data, 'bf_birth'),
'all':
get_value(this_month_data, 'born'),
'format':
'percent_and_div',
'frequency':
'month',
'redirect':
'early_initiation'
}, {
'label':
_('Exclusive Breastfeeding'),
'help_text':
_(("Percentage of children between 0 - 6 months exclusively breastfed. An infant is "
"exclusively breastfed if they receive only breastmilk with no additional food, "
"liquids (even water) ensuring optimal nutrition and growth between 0 - 6 months"
)),
'percent':
percent_diff('ebf', this_month_data, prev_month_data, 'ebf_eli'),
'color':
'green' if percent_diff('ebf', this_month_data, prev_month_data,
'ebf_eli') > 0 else 'red',
'value':
get_value(this_month_data, 'ebf'),
'all':
get_value(this_month_data, 'ebf_eli'),
'format':
'percent_and_div',
'frequency':
'month',
'redirect':
'exclusive_breastfeeding'
}],
[{
'label':
_('Children initiated appropriate Complementary Feeding'),
'help_text':
_(("Percentage of children between 6 - 8 months given timely introduction to solid or "
"semi-solid food. Timely initiation of complementary feeding in addition to "
"breastmilk at 6 months of age is a key feeding practice to reduce malnutrition"
)),
'percent':
percent_diff('cf_initiation', this_month_data, prev_month_data,
'cf_initiation_eli'),
'color':
'green'
if percent_diff('cf_initiation', this_month_data, prev_month_data,
'cf_initiation_eli') > 0 else 'red',
'value':
get_value(this_month_data, 'cf_initiation'),
'all':
get_value(this_month_data, 'cf_initiation_eli'),
'format':
'percent_and_div',
'frequency':
'month',
'redirect':
'children_initiated'
}, {
'label':
_('Institutional Deliveries'),
'help_text':
_(("Percentage of pregnant women who delivered in a public or private medical facility "
"in the last month. Delivery in medical institutions is associated with a "
"decrease in maternal mortality rate")),
'percent':
percent_diff('institutional_delivery', deliveries_this_month,
deliveries_prev_month, 'delivered'),
'color':
'green' if
percent_diff('institutional_delivery', deliveries_this_month,
deliveries_prev_month, 'delivered') > 0 else 'red',
'value':
get_value(deliveries_this_month, 'institutional_delivery'),
'all':
get_value(deliveries_this_month, 'delivered'),
'format':
'percent_and_div',
'frequency':
'month',
'redirect':
'institutional_deliveries'
}]]
}
def get_awc_reports_maternal_child(domain,
config,
month,
prev_month,
show_test=False,
icds_feature_flag=False):
def get_data_for(date):
age_filters = {
'age_tranche': 72
} if icds_feature_flag else {
'age_tranche__in': [0, 6, 72]
}
moderately_underweight = exclude_records_by_age_for_column(
{'age_tranche': 72}, 'nutrition_status_moderately_underweight')
severely_underweight = exclude_records_by_age_for_column(
{'age_tranche': 72}, 'nutrition_status_severely_underweight')
wasting_moderate = exclude_records_by_age_for_column(
age_filters, wasting_moderate_column(icds_feature_flag))
wasting_severe = exclude_records_by_age_for_column(
age_filters, wasting_severe_column(icds_feature_flag))
stunting_moderate = exclude_records_by_age_for_column(
age_filters, stunting_moderate_column(icds_feature_flag))
stunting_severe = exclude_records_by_age_for_column(
age_filters, stunting_severe_column(icds_feature_flag))
nutrition_status_weighed = exclude_records_by_age_for_column(
{'age_tranche': 72}, 'nutrition_status_weighed')
height_measured_in_month = exclude_records_by_age_for_column(
age_filters, hfa_recorded_in_month_column(icds_feature_flag))
weighed_and_height_measured_in_month = exclude_records_by_age_for_column(
age_filters, wfh_recorded_in_month_column(icds_feature_flag))
queryset = AggChildHealthMonthly.objects.filter(
month=date,
**config).values('month', 'aggregation_level').annotate(
underweight=(Sum(moderately_underweight) +
Sum(severely_underweight)),
valid_weighed=Sum(nutrition_status_weighed),
immunized=(Sum('fully_immunized_on_time') +
Sum('fully_immunized_late')),
eligible=Sum('fully_immunized_eligible'),
wasting=Sum(wasting_moderate) + Sum(wasting_severe),
height_measured_in_month=Sum(height_measured_in_month),
weighed_and_height_measured_in_month=Sum(
weighed_and_height_measured_in_month),
stunting=Sum(stunting_moderate) + Sum(stunting_severe),
low_birth=Sum('low_birth_weight_in_month'),
birth=Sum('bf_at_birth'),
born=Sum('born_in_month'),
weighed_and_born_in_month=Sum('weighed_and_born_in_month'),
month_ebf=Sum('ebf_in_month'),
ebf=Sum('ebf_eligible'),
month_cf=Sum('cf_initiation_in_month'),
cf=Sum('cf_initiation_eligible'))
if not show_test:
queryset = apply_exclude(domain, queryset)
return queryset
def get_weight_efficiency(date):
queryset = AggAwcMonthly.objects.filter(month=date, **config).values(
'month', 'aggregation_level',
'awc_name').annotate(wer_weight=Sum('wer_weighed'),
wer_eli=Sum('wer_eligible'))
if not show_test:
queryset = apply_exclude(domain, queryset)
return queryset
def get_institutional_delivery_data(date):
queryset = AggCcsRecordMonthly.objects.filter(
month=date, **config).values(
'month', 'aggregation_level', 'awc_name').annotate(
institutional_delivery_in_month_sum=Sum(
'institutional_delivery_in_month'),
delivered_in_month_sum=Sum('delivered_in_month'))
if not show_test:
queryset = apply_exclude(domain, queryset)
return queryset
this_month_data = get_data_for(datetime(*month))
prev_month_data = get_data_for(datetime(*prev_month))
this_month_data_we = get_weight_efficiency(datetime(*month))
prev_month_data_we = get_weight_efficiency(datetime(*prev_month))
this_month_institutional_delivery_data = get_institutional_delivery_data(
datetime(*month))
prev_month_institutional_delivery_data = get_institutional_delivery_data(
datetime(*prev_month))
gender_label, age_label, chosen_filters = chosen_filters_to_labels(
config, default_interval=default_age_interval(icds_feature_flag))
return {
'kpi':
[[
{
'label':
_('Underweight (Weight-for-Age)'),
'help_text':
_(("Of the total children weighed, the percentage of children between 0-5 years who were "
"moderately/severely underweight in the current month. Children who are moderately or "
"severely underweight have a higher risk of mortality. ")),
'percent':
percent_diff('underweight', this_month_data, prev_month_data,
'valid_weighed'),
'color':
'red' if percent_diff('underweight', this_month_data,
prev_month_data, 'valid_weighed') > 0
else 'green',
'value':
get_value(this_month_data, 'underweight'),
'all':
get_value(this_month_data, 'valid_weighed'),
'format':
'percent_and_div',
'frequency':
'month'
},
{
'label':
_('Wasting (Weight-for-Height)'),
'help_text':
wasting_help_text(age_label),
'percent':
percent_diff('wasting', this_month_data, prev_month_data,
'weighed_and_height_measured_in_month'),
'color':
'red'
if percent_diff('wasting', this_month_data, prev_month_data,
'weighed_and_height_measured_in_month') > 0
else 'green',
'value':
get_value(this_month_data, 'wasting'),
'all':
get_value(this_month_data,
'weighed_and_height_measured_in_month'),
'format':
'percent_and_div',
'frequency':
'month'
},
],
[
{
'label':
_('Stunting (Height-for-Age)'),
'help_text':
stunting_help_text(age_label),
'percent':
percent_diff('stunting', this_month_data, prev_month_data,
'height_measured_in_month'),
'color':
'red'
if percent_diff('stunting', this_month_data, prev_month_data,
'height_measured_in_month') > 0 else 'green',
'value':
get_value(this_month_data, 'stunting'),
'all':
get_value(this_month_data, 'height_measured_in_month'),
'format':
'percent_and_div',
'frequency':
'month'
},
{
'label':
_('Weighing Efficiency'),
'help_text':
_("Of the children between the ages of 0-5 years who are enrolled for Anganwadi Services, "
"the percentage who were weighed in the given month. "),
'percent':
percent_diff('wer_weight', this_month_data_we,
prev_month_data_we, 'wer_eli'),
'color':
'green'
if percent_diff('wer_weight', this_month_data_we,
prev_month_data_we, 'wer_eli') > 0 else 'red',
'value':
get_value(this_month_data_we, 'wer_weight'),
'all':
get_value(this_month_data_we, 'wer_eli'),
'format':
'percent_and_div',
'frequency':
'month'
},
],
[
{
'label':
_('Newborns with Low Birth Weight'),
'help_text':
_("Of all the children born in the current month, the percentage that had a birth weight "
"less than 2500 grams. Newborns with Low Birth Weight are closely associated wtih foetal "
"and neonatal mortality and morbidity, inhibited growth and cognitive development, "
"and chronic diseases later in life."),
'percent':
percent_diff('low_birth', this_month_data, prev_month_data,
'weighed_and_born_in_month'),
'color':
'red'
if percent_diff('low_birth', this_month_data, prev_month_data,
'weighed_and_born_in_month') > 0 else 'green',
'value':
get_value(this_month_data, 'low_birth'),
'all':
get_value(this_month_data, 'weighed_and_born_in_month'),
'format':
'percent_and_div',
'frequency':
'month'
},
{
'label':
_('Early Initiation of Breastfeeding'),
'help_text':
_("Of the children born in the last month, the percentage whose "
"breastfeeding was initiated within 1 hour of delivery. Early initiation "
"of breastfeeding ensure the newborn recieves the \"first milk\" rich "
"in nutrients and encourages exclusive breastfeeding practice"
),
'percent':
percent_diff('birth', this_month_data, prev_month_data,
'born'),
'color':
'green'
if percent_diff('birth', this_month_data, prev_month_data,
'born') > 0 else 'red',
'value':
get_value(this_month_data, 'birth'),
'all':
get_value(this_month_data, 'born'),
'format':
'percent_and_div',
'frequency':
'month'
},
],
[
{
'label':
_('Exclusive breastfeeding'),
'help_text':
_("Of the total children between the ages of 0 to 6 months, the percentage that was "
"exclusively fed with breast milk. An infant is exclusively breastfed if they receive "
"only breastmilk with no additional food or liquids (even water), ensuring optimal "
"nutrition and growth between 0 - 6 months"),
'percent':
percent_diff('month_ebf', this_month_data, prev_month_data,
'ebf'),
'color':
'green'
if percent_diff('month_ebf', this_month_data, prev_month_data,
'ebf') > 0 else 'red',
'value':
get_value(this_month_data, 'month_ebf'),
'all':
get_value(this_month_data, 'ebf'),
'format':
'percent_and_div',
'frequency':
'month'
},
{
'label':
_('Children initiated appropriate Complementary Feeding'),
'help_text':
_("Of the total children between the ages of 6 to 8 months, the percentage that was "
"given a timely introduction to solid, semi-solid or soft food. Timely intiation of "
"complementary feeding in addition to breastmilk at 6 months of age is a key feeding "
"practice to reduce malnutrition"),
'percent':
percent_diff('month_cf', this_month_data, prev_month_data,
'cf'),
'color':
'green' if percent_diff('month_cf', this_month_data,
prev_month_data, 'cf') > 0 else 'red',
'value':
get_value(this_month_data, 'month_cf'),
'all':
get_value(this_month_data, 'cf'),
'format':
'percent_and_div',
'frequency':
'month'
},
],
[
{
'label':
_('Immunization Coverage (at age 1 year)'),
'help_text':
_(("Of the total number of children enrolled for Anganwadi Services who are over a year old, "
"the percentage of children who have received the complete immunization as per the "
"National Immunization Schedule of India that is required by age 1."
"<br/><br/> "
"This includes the following immunizations:<br/> "
"If Pentavalent path: Penta1/2/3, OPV1/2/3, BCG, Measles, VitA1<br/> "
"If DPT/HepB path: DPT1/2/3, HepB1/2/3, OPV1/2/3, BCG, Measles, VitA1"
)),
'percent':
percent_diff('immunized', this_month_data, prev_month_data,
'eligible'),
'color':
'green'
if percent_diff('immunized', this_month_data, prev_month_data,
'eligible') > 0 else 'red',
'value':
get_value(this_month_data, 'immunized'),
'all':
get_value(this_month_data, 'eligible'),
'format':
'percent_and_div',
'frequency':
'month'
},
{
'label':
_('Institutional Deliveries'),
'help_text':
_(("Of the total number of women who gave birth in the last month, the percentage who "
"delivered in a public or private medical facility. Delivery in medical instituitions "
"is associated with a decrease in maternal mortality rate"
)),
'percent':
percent_diff('institutional_delivery_in_month_sum',
this_month_institutional_delivery_data,
prev_month_institutional_delivery_data,
'delivered_in_month_sum'),
'color':
'green'
if percent_diff('institutional_delivery_in_month_sum',
this_month_institutional_delivery_data,
prev_month_institutional_delivery_data,
'delivered_in_month_sum') > 0 else 'red',
'value':
get_value(this_month_institutional_delivery_data,
'institutional_delivery_in_month_sum'),
'all':
get_value(this_month_institutional_delivery_data,
'delivered_in_month_sum'),
'format':
'percent_and_div',
'frequency':
'month'
},
]]
}
def get_maternal_child_data(domain, config, show_test=False, icds_feature_flag=False):
def get_data_for_child_health_monthly(date, filters):
age_filters = {'age_tranche': 72} if icds_feature_flag else {'age_tranche__in': [0, 6, 72]}
moderately_underweight = exclude_records_by_age_for_column(
{'age_tranche': 72},
'nutrition_status_moderately_underweight'
)
severely_underweight = exclude_records_by_age_for_column(
{'age_tranche': 72},
'nutrition_status_severely_underweight'
)
wasting_moderate = exclude_records_by_age_for_column(
age_filters,
wasting_moderate_column(icds_feature_flag)
)
wasting_severe = exclude_records_by_age_for_column(
age_filters,
wasting_severe_column(icds_feature_flag)
)
stunting_moderate = exclude_records_by_age_for_column(
age_filters,
stunting_moderate_column(icds_feature_flag)
)
stunting_severe = exclude_records_by_age_for_column(
age_filters,
stunting_severe_column(icds_feature_flag)
)
nutrition_status_weighed = exclude_records_by_age_for_column(
{'age_tranche': 72},
'nutrition_status_weighed'
)
height_measured_in_month = exclude_records_by_age_for_column(
age_filters,
hfa_recorded_in_month_column(icds_feature_flag)
)
weighed_and_height_measured_in_month = exclude_records_by_age_for_column(
age_filters,
wfh_recorded_in_month_column(icds_feature_flag)
)
queryset = AggChildHealthMonthly.objects.filter(
month=date, **filters
).values(
'aggregation_level'
).annotate(
underweight=(
Sum(moderately_underweight) + Sum(severely_underweight)
),
valid=Sum(nutrition_status_weighed),
wasting=Sum(wasting_moderate) + Sum(wasting_severe),
stunting=Sum(stunting_moderate) + Sum(stunting_severe),
height_measured_in_month=Sum(height_measured_in_month),
weighed_and_height_measured_in_month=Sum(weighed_and_height_measured_in_month),
low_birth_weight=Sum('low_birth_weight_in_month'),
bf_birth=Sum('bf_at_birth'),
born=Sum('born_in_month'),
weighed_and_born_in_month=Sum('weighed_and_born_in_month'),
ebf=Sum('ebf_in_month'),
ebf_eli=Sum('ebf_eligible'),
cf_initiation=Sum('cf_initiation_in_month'),
cf_initiation_eli=Sum('cf_initiation_eligible')
)
if not show_test:
queryset = apply_exclude(domain, queryset)
return queryset
def get_data_for_deliveries(date, filters):
queryset = AggCcsRecordMonthly.objects.filter(
month=date, **filters
).values(
'aggregation_level'
).annotate(
institutional_delivery=Sum('institutional_delivery_in_month'),
delivered=Sum('delivered_in_month')
)
if not show_test:
queryset = apply_exclude(domain, queryset)
return queryset
current_month = datetime(*config['month'])
previous_month = datetime(*config['prev_month'])
del config['month']
del config['prev_month']
this_month_data = get_data_for_child_health_monthly(current_month, config)
prev_month_data = get_data_for_child_health_monthly(previous_month, config)
deliveries_this_month = get_data_for_deliveries(current_month, config)
deliveries_prev_month = get_data_for_deliveries(previous_month, config)
gender_label, age_label, chosen_filters = chosen_filters_to_labels(
config,
default_interval=default_age_interval(icds_feature_flag)
)
return {
'records': [
[
{
'label': _('Underweight (Weight-for-Age)'),
'help_text': underweight_children_help_text(),
'percent': percent_diff(
'underweight',
this_month_data,
prev_month_data,
'valid'
),
'color': 'red' if percent_diff(
'underweight',
this_month_data,
prev_month_data,
'valid'
) > 0 else 'green',
'value': get_value(this_month_data, 'underweight'),
'all': get_value(this_month_data, 'valid'),
'format': 'percent_and_div',
'frequency': 'month',
'redirect': 'maternal_and_child/underweight_children'
},
{
'label': _('Wasting (Weight-for-Height)'),
'help_text': _(wasting_help_text(age_label)),
'percent': percent_diff(
'wasting',
this_month_data,
prev_month_data,
'weighed_and_height_measured_in_month'
),
'color': 'red' if percent_diff(
'wasting',
this_month_data,
prev_month_data,
'weighed_and_height_measured_in_month'
) > 0 else 'green',
'value': get_value(this_month_data, 'wasting'),
'all': get_value(this_month_data, 'weighed_and_height_measured_in_month'),
'format': 'percent_and_div',
'frequency': 'month',
'redirect': 'maternal_and_child/wasting'
}
],
[
{
'label': _('Stunting (Height-for-Age)'),
'help_text': _(stunting_help_text(age_label)),
'percent': percent_diff(
'stunting',
this_month_data,
prev_month_data,
'height_measured_in_month'
),
'color': 'red' if percent_diff(
'stunting',
this_month_data,
prev_month_data,
'height_measured_in_month'
) > 0 else 'green',
'value': get_value(this_month_data, 'stunting'),
'all': get_value(this_month_data, 'height_measured_in_month'),
'format': 'percent_and_div',
'frequency': 'month',
'redirect': 'maternal_and_child/stunting'
},
{
'label': _('Newborns with Low Birth Weight'),
'help_text': _((
new_born_with_low_weight_help_text(html=False)
)),
'percent': percent_diff(
'low_birth_weight',
this_month_data,
prev_month_data,
'weighed_and_born_in_month'
),
'color': 'red' if percent_diff(
'low_birth_weight',
this_month_data,
prev_month_data,
'weighed_and_born_in_month'
) > 0 else 'green',
'value': get_value(this_month_data, 'low_birth_weight'),
'all': get_value(this_month_data, 'weighed_and_born_in_month'),
'format': 'percent_and_div',
'frequency': 'month',
'redirect': 'maternal_and_child/low_birth'
}
],
[
{
'label': _('Early Initiation of Breastfeeding'),
'help_text': early_initiation_breastfeeding_help_text(),
'percent': percent_diff(
'bf_birth',
this_month_data,
prev_month_data,
'born'
),
'color': 'green' if percent_diff(
'bf_birth',
this_month_data,
prev_month_data,
'born'
) > 0 else 'red',
'value': get_value(this_month_data, 'bf_birth'),
'all': get_value(this_month_data, 'born'),
'format': 'percent_and_div',
'frequency': 'month',
'redirect': 'maternal_and_child/early_initiation'
},
{
'label': _('Exclusive Breastfeeding'),
'help_text': exclusive_breastfeeding_help_text(),
'percent': percent_diff(
'ebf',
this_month_data,
prev_month_data,
'ebf_eli'
),
'color': 'green' if percent_diff(
'ebf',
this_month_data,
prev_month_data,
'ebf_eli'
) > 0 else 'red',
'value': get_value(this_month_data, 'ebf'),
'all': get_value(this_month_data, 'ebf_eli'),
'format': 'percent_and_div',
'frequency': 'month',
'redirect': 'maternal_and_child/exclusive_breastfeeding'
}
],
[
{
'label': _('Children initiated appropriate Complementary Feeding'),
'help_text': children_initiated_appropriate_complementary_feeding_help_text(),
'percent': percent_diff(
'cf_initiation',
this_month_data,
prev_month_data,
'cf_initiation_eli'
),
'color': 'green' if percent_diff(
'cf_initiation',
this_month_data,
prev_month_data,
'cf_initiation_eli'
) > 0 else 'red',
'value': get_value(this_month_data, 'cf_initiation'),
'all': get_value(this_month_data, 'cf_initiation_eli'),
'format': 'percent_and_div',
'frequency': 'month',
'redirect': 'maternal_and_child/children_initiated'
},
{
'label': _('Institutional Deliveries'),
'help_text': institutional_deliveries_help_text(),
'percent': percent_diff(
'institutional_delivery',
deliveries_this_month,
deliveries_prev_month,
'delivered'
),
'color': 'green' if percent_diff(
'institutional_delivery',
deliveries_this_month,
deliveries_prev_month,
'delivered'
) > 0 else 'red',
'value': get_value(deliveries_this_month, 'institutional_delivery'),
'all': get_value(deliveries_this_month, 'delivered'),
'format': 'percent_and_div',
'frequency': 'month',
'redirect': 'maternal_and_child/institutional_deliveries'
}
]
]
}
def get_maternal_child_data(domain,
config,
show_test=False,
icds_feature_flag=False):
def get_data_for_child_health_monthly(date, filters):
age_filters = {
'age_tranche': 72
} if icds_feature_flag else {
'age_tranche__in': [0, 6, 72]
}
moderately_underweight = exclude_records_by_age_for_column(
{'age_tranche': 72}, 'nutrition_status_moderately_underweight')
severely_underweight = exclude_records_by_age_for_column(
{'age_tranche': 72}, 'nutrition_status_severely_underweight')
wasting_moderate = exclude_records_by_age_for_column(
age_filters, wasting_moderate_column(icds_feature_flag))
wasting_severe = exclude_records_by_age_for_column(
age_filters, wasting_severe_column(icds_feature_flag))
stunting_moderate = exclude_records_by_age_for_column(
age_filters, stunting_moderate_column(icds_feature_flag))
stunting_severe = exclude_records_by_age_for_column(
age_filters, stunting_severe_column(icds_feature_flag))
nutrition_status_weighed = exclude_records_by_age_for_column(
{'age_tranche': 72}, 'nutrition_status_weighed')
height_measured_in_month = exclude_records_by_age_for_column(
age_filters, hfa_recorded_in_month_column(icds_feature_flag))
weighed_and_height_measured_in_month = exclude_records_by_age_for_column(
age_filters, wfh_recorded_in_month_column(icds_feature_flag))
queryset = AggChildHealthMonthly.objects.filter(
month=date, **filters).values('aggregation_level').annotate(
underweight=(Sum(moderately_underweight) +
Sum(severely_underweight)),
valid=Sum(nutrition_status_weighed),
wasting=Sum(wasting_moderate) + Sum(wasting_severe),
stunting=Sum(stunting_moderate) + Sum(stunting_severe),
height_measured_in_month=Sum(height_measured_in_month),
weighed_and_height_measured_in_month=Sum(
weighed_and_height_measured_in_month),
low_birth_weight=Sum('low_birth_weight_in_month'),
bf_birth=Sum('bf_at_birth'),
born=Sum('born_in_month'),
weighed_and_born_in_month=Sum('weighed_and_born_in_month'),
ebf=Sum('ebf_in_month'),
ebf_eli=Sum('ebf_eligible'),
cf_initiation=Sum('cf_initiation_in_month'),
cf_initiation_eli=Sum('cf_initiation_eligible'))
if not show_test:
queryset = apply_exclude(domain, queryset)
return queryset
def get_data_for_deliveries(date, filters):
queryset = AggCcsRecordMonthly.objects.filter(
month=date, **filters).values('aggregation_level').annotate(
institutional_delivery=Sum('institutional_delivery_in_month'),
delivered=Sum('delivered_in_month'))
if not show_test:
queryset = apply_exclude(domain, queryset)
return queryset
current_month = datetime(*config['month'])
previous_month = datetime(*config['prev_month'])
del config['month']
del config['prev_month']
this_month_data = get_data_for_child_health_monthly(current_month, config)
prev_month_data = get_data_for_child_health_monthly(previous_month, config)
deliveries_this_month = get_data_for_deliveries(current_month, config)
deliveries_prev_month = get_data_for_deliveries(previous_month, config)
gender_label, age_label, chosen_filters = chosen_filters_to_labels(
config, default_interval=default_age_interval(icds_feature_flag))
return {
'records':
[[{
'label':
_('Underweight (Weight-for-Age)'),
'help_text':
_(("Of the total children enrolled for Anganwadi services and weighed, the percentage "
"of children between 0-5 years who were moderately/severely underweight in the current "
"month. Children who are moderately or severely underweight have a higher risk "
"of mortality. ")),
'percent':
percent_diff('underweight', this_month_data, prev_month_data,
'valid'),
'color':
'red' if percent_diff('underweight', this_month_data,
prev_month_data, 'valid') > 0 else 'green',
'value':
get_value(this_month_data, 'underweight'),
'all':
get_value(this_month_data, 'valid'),
'format':
'percent_and_div',
'frequency':
'month',
'redirect':
'underweight_children'
}, {
'label':
_('Wasting (Weight-for-Height)'),
'help_text':
_(wasting_help_text(age_label)),
'percent':
percent_diff('wasting', this_month_data, prev_month_data,
'weighed_and_height_measured_in_month'),
'color':
'red' if percent_diff('wasting', this_month_data, prev_month_data,
'weighed_and_height_measured_in_month') > 0
else 'green',
'value':
get_value(this_month_data, 'wasting'),
'all':
get_value(this_month_data, 'weighed_and_height_measured_in_month'),
'format':
'percent_and_div',
'frequency':
'month',
'redirect':
'wasting'
}],
[{
'label':
_('Stunting (Height-for-Age)'),
'help_text':
_(stunting_help_text(age_label)),
'percent':
percent_diff('stunting', this_month_data, prev_month_data,
'height_measured_in_month'),
'color':
'red'
if percent_diff('stunting', this_month_data, prev_month_data,
'height_measured_in_month') > 0 else 'green',
'value':
get_value(this_month_data, 'stunting'),
'all':
get_value(this_month_data, 'height_measured_in_month'),
'format':
'percent_and_div',
'frequency':
'month',
'redirect':
'stunting'
}, {
'label':
_('Newborns with Low Birth Weight'),
'help_text':
_((get_new_born_with_low_weight_help_text(html=False))),
'percent':
percent_diff('low_birth_weight', this_month_data, prev_month_data,
'weighed_and_born_in_month'),
'color':
'red' if
percent_diff('low_birth_weight', this_month_data, prev_month_data,
'weighed_and_born_in_month') > 0 else 'green',
'value':
get_value(this_month_data, 'low_birth_weight'),
'all':
get_value(this_month_data, 'weighed_and_born_in_month'),
'format':
'percent_and_div',
'frequency':
'month',
'redirect':
'low_birth'
}],
[{
'label':
_('Early Initiation of Breastfeeding'),
'help_text':
_(("Of the children born in the last month and enrolled for Anganwadi services, "
"the percentage whose breastfeeding was initiated within 1 hour of delivery. "
"Early initiation of breastfeeding ensure the newborn recieves the \"first milk\" "
"rich in nutrients and encourages exclusive breastfeeding practice"
)),
'percent':
percent_diff('bf_birth', this_month_data, prev_month_data,
'born'),
'color':
'green' if percent_diff('bf_birth', this_month_data,
prev_month_data, 'born') > 0 else 'red',
'value':
get_value(this_month_data, 'bf_birth'),
'all':
get_value(this_month_data, 'born'),
'format':
'percent_and_div',
'frequency':
'month',
'redirect':
'early_initiation'
}, {
'label':
_('Exclusive Breastfeeding'),
'help_text':
_(("Of the total children enrolled for Anganwadi services between the ages of 0 to 6 months, "
"the percentage that was exclusively fed with breast milk. An infant is exclusively "
"breastfed if they receive only breastmilk with no additional food or liquids "
"(even water), ensuring optimal nutrition and growth between 0 - 6 months"
)),
'percent':
percent_diff('ebf', this_month_data, prev_month_data, 'ebf_eli'),
'color':
'green' if percent_diff('ebf', this_month_data, prev_month_data,
'ebf_eli') > 0 else 'red',
'value':
get_value(this_month_data, 'ebf'),
'all':
get_value(this_month_data, 'ebf_eli'),
'format':
'percent_and_div',
'frequency':
'month',
'redirect':
'exclusive_breastfeeding'
}],
[{
'label':
_('Children initiated appropriate Complementary Feeding'),
'help_text':
_(("Of the total children enrolled for Anganwadi services between the ages of 6 to 8 months, "
"the percentage that was given a timely introduction to solid, semi-solid or soft food. "
"Timely intiation of complementary feeding in addition to breastmilk at 6 months of age "
"is a key feeding practice to reduce malnutrition")),
'percent':
percent_diff('cf_initiation', this_month_data, prev_month_data,
'cf_initiation_eli'),
'color':
'green'
if percent_diff('cf_initiation', this_month_data, prev_month_data,
'cf_initiation_eli') > 0 else 'red',
'value':
get_value(this_month_data, 'cf_initiation'),
'all':
get_value(this_month_data, 'cf_initiation_eli'),
'format':
'percent_and_div',
'frequency':
'month',
'redirect':
'children_initiated'
}, {
'label':
_('Institutional Deliveries'),
'help_text':
_(("Of the total number of women enrolled for Anganwadi services who gave birth in the last "
"month, the percentage who delivered in a public or private medical facility. Delivery "
"in medical instituitions is associated with a decrease in maternal mortality rate"
)),
'percent':
percent_diff('institutional_delivery', deliveries_this_month,
deliveries_prev_month, 'delivered'),
'color':
'green' if
percent_diff('institutional_delivery', deliveries_this_month,
deliveries_prev_month, 'delivered') > 0 else 'red',
'value':
get_value(deliveries_this_month, 'institutional_delivery'),
'all':
get_value(deliveries_this_month, 'delivered'),
'format':
'percent_and_div',
'frequency':
'month',
'redirect':
'institutional_deliveries'
}]]
}
def get_awc_reports_maternal_child(domain,
config,
month,
prev_month,
show_test=False,
icds_feature_flag=False):
def get_data_for(date):
age_filters = {
'age_tranche': 72
} if icds_feature_flag else {
'age_tranche__in': [0, 6, 72]
}
moderately_underweight = exclude_records_by_age_for_column(
{'age_tranche': 72}, 'nutrition_status_moderately_underweight')
severely_underweight = exclude_records_by_age_for_column(
{'age_tranche': 72}, 'nutrition_status_severely_underweight')
wasting_moderate = exclude_records_by_age_for_column(
age_filters, wasting_moderate_column(icds_feature_flag))
wasting_severe = exclude_records_by_age_for_column(
age_filters, wasting_severe_column(icds_feature_flag))
stunting_moderate = exclude_records_by_age_for_column(
age_filters, stunting_moderate_column(icds_feature_flag))
stunting_severe = exclude_records_by_age_for_column(
age_filters, stunting_severe_column(icds_feature_flag))
nutrition_status_weighed = exclude_records_by_age_for_column(
{'age_tranche': 72}, 'nutrition_status_weighed')
height_measured_in_month = exclude_records_by_age_for_column(
age_filters, 'height_measured_in_month')
weighed_and_height_measured_in_month = exclude_records_by_age_for_column(
age_filters, 'weighed_and_height_measured_in_month')
queryset = AggChildHealthMonthly.objects.filter(
month=date,
**config).values('month', 'aggregation_level').annotate(
underweight=(Sum(moderately_underweight) +
Sum(severely_underweight)),
valid_weighed=Sum(nutrition_status_weighed),
immunized=(Sum('fully_immunized_on_time') +
Sum('fully_immunized_late')),
eligible=Sum('fully_immunized_eligible'),
wasting=Sum(wasting_moderate) + Sum(wasting_severe),
height_measured_in_month=Sum(height_measured_in_month),
weighed_and_height_measured_in_month=Sum(
weighed_and_height_measured_in_month),
stunting=Sum(stunting_moderate) + Sum(stunting_severe),
low_birth=Sum('low_birth_weight_in_month'),
birth=Sum('bf_at_birth'),
born=Sum('born_in_month'),
weighed_and_born_in_month=Sum('weighed_and_born_in_month'),
month_ebf=Sum('ebf_in_month'),
ebf=Sum('ebf_eligible'),
month_cf=Sum('cf_initiation_in_month'),
cf=Sum('cf_initiation_eligible'))
if not show_test:
queryset = apply_exclude(domain, queryset)
return queryset
def get_weight_efficiency(date):
queryset = AggAwcMonthly.objects.filter(month=date, **config).values(
'month', 'aggregation_level',
'awc_name').annotate(wer_weight=Sum('wer_weighed'),
wer_eli=Sum('wer_eligible'))
if not show_test:
queryset = apply_exclude(domain, queryset)
return queryset
def get_institutional_delivery_data(date):
queryset = AggCcsRecordMonthly.objects.filter(
month=date, **config).values(
'month', 'aggregation_level', 'awc_name').annotate(
institutional_delivery_in_month_sum=Sum(
'institutional_delivery_in_month'),
delivered_in_month_sum=Sum('delivered_in_month'))
if not show_test:
queryset = apply_exclude(domain, queryset)
return queryset
this_month_data = get_data_for(datetime(*month))
prev_month_data = get_data_for(datetime(*prev_month))
this_month_data_we = get_weight_efficiency(datetime(*month))
prev_month_data_we = get_weight_efficiency(datetime(*prev_month))
this_month_institutional_delivery_data = get_institutional_delivery_data(
datetime(*month))
prev_month_institutional_delivery_data = get_institutional_delivery_data(
datetime(*prev_month))
return {
'kpi':
[[
{
'label':
_('Underweight (Weight-for-Age)'),
'help_text':
_(("Percentage of children between 0 - 5 years enrolled for Anganwadi Services with "
"weight-for-age less than -2 standard deviations of the WHO Child "
"Growth Standards median. Children who are moderately or severely underweight "
"have a higher risk of mortality. ")),
'percent':
percent_diff('underweight', this_month_data, prev_month_data,
'valid_weighed'),
'color':
'red' if percent_diff('underweight', this_month_data,
prev_month_data, 'valid_weighed') > 0
else 'green',
'value':
get_value(this_month_data, 'underweight'),
'all':
get_value(this_month_data, 'valid_weighed'),
'format':
'percent_and_div',
'frequency':
'month'
},
{
'label':
_('Wasting (Weight-for-Height)'),
'help_text':
wasting_help_text(icds_feature_flag),
'percent':
percent_diff('wasting', this_month_data, prev_month_data,
'weighed_and_height_measured_in_month'),
'color':
'red'
if percent_diff('wasting', this_month_data, prev_month_data,
'weighed_and_height_measured_in_month') > 0
else 'green',
'value':
get_value(this_month_data, 'wasting'),
'all':
get_value(this_month_data,
'weighed_and_height_measured_in_month'),
'format':
'percent_and_div',
'frequency':
'month'
},
],
[
{
'label':
_('Stunting (Height-for-Age)'),
'help_text':
stunting_help_text(icds_feature_flag),
'percent':
percent_diff('stunting', this_month_data, prev_month_data,
'height_measured_in_month'),
'color':
'red'
if percent_diff('stunting', this_month_data, prev_month_data,
'height_measured_in_month') > 0 else 'green',
'value':
get_value(this_month_data, 'stunting'),
'all':
get_value(this_month_data, 'height_measured_in_month'),
'format':
'percent_and_div',
'frequency':
'month'
},
{
'label':
_('Weighing Efficiency'),
'help_text':
_("Percentage of children (0 - 5 years) who have been weighed of total children "
"enrolled for Anganwadi Services"),
'percent':
percent_diff('wer_weight', this_month_data_we,
prev_month_data_we, 'wer_eli'),
'color':
'green'
if percent_diff('wer_weight', this_month_data_we,
prev_month_data_we, 'wer_eli') > 0 else 'red',
'value':
get_value(this_month_data_we, 'wer_weight'),
'all':
get_value(this_month_data_we, 'wer_eli'),
'format':
'percent_and_div',
'frequency':
'month'
},
],
[
{
'label':
_('Newborns with Low Birth Weight'),
'help_text':
_("Percentage of newborns born with birth weight less than 2500 grams. "
"Newborns with Low Birth Weight are closely associated with foetal and "
"neonatal mortality and morbidity, inhibited growth and cognitive development, "
"and chronic diseases later in life"),
'percent':
percent_diff('low_birth', this_month_data, prev_month_data,
'weighed_and_born_in_month'),
'color':
'red'
if percent_diff('low_birth', this_month_data, prev_month_data,
'weighed_and_born_in_month') > 0 else 'green',
'value':
get_value(this_month_data, 'low_birth'),
'all':
get_value(this_month_data, 'weighed_and_born_in_month'),
'format':
'percent_and_div',
'frequency':
'month'
},
{
'label':
_('Early Initiation of Breastfeeding'),
'help_text':
_("Percentage of children who were put to the breast within one hour of birth. "
"Early initiation of breastfeeding ensure the newborn receives the 'first milk' "
"rich in nutrients and encourages exclusive breastfeeding practice"
),
'percent':
percent_diff('birth', this_month_data, prev_month_data,
'born'),
'color':
'green'
if percent_diff('birth', this_month_data, prev_month_data,
'born') > 0 else 'red',
'value':
get_value(this_month_data, 'birth'),
'all':
get_value(this_month_data, 'born'),
'format':
'percent_and_div',
'frequency':
'month'
},
],
[
{
'label':
_('Exclusive breastfeeding'),
'help_text':
_("Percentage of infants 0-6 months of age who are fed exclusively with breast milk. "
"An infant is exclusively breastfed if they receive only breastmilk "
"with no additional food, liquids (even water) ensuring "
"optimal nutrition and growth between 0 - 6 months"),
'percent':
percent_diff('month_ebf', this_month_data, prev_month_data,
'ebf'),
'color':
'green'
if percent_diff('month_ebf', this_month_data, prev_month_data,
'ebf') > 0 else 'red',
'value':
get_value(this_month_data, 'month_ebf'),
'all':
get_value(this_month_data, 'ebf'),
'format':
'percent_and_div',
'frequency':
'month'
},
{
'label':
_('Children initiated appropriate Complementary Feeding'),
'help_text':
_("Percentage of children between 6 - 8 months given timely introduction to solid, "
"semi-solid or soft food. "
"Timely initiation of complementary feeding in addition to breastmilk "
"at 6 months of age is a key feeding practice to reduce malnutrition"
),
'percent':
percent_diff('month_cf', this_month_data, prev_month_data,
'cf'),
'color':
'green' if percent_diff('month_cf', this_month_data,
prev_month_data, 'cf') > 0 else 'red',
'value':
get_value(this_month_data, 'month_cf'),
'all':
get_value(this_month_data, 'cf'),
'format':
'percent_and_div',
'frequency':
'month'
},
],
[
{
'label':
_('Immunization Coverage (at age 1 year)'),
'help_text':
_(("Percentage of children 1 year+ who have received complete immunization as per "
"National Immunization Schedule of India required by age 1. "
"<br/><br/> "
"This includes the following immunizations:<br/> "
"If Pentavalent path: Penta1/2/3, OPV1/2/3, BCG, Measles, VitA1<br/> "
"If DPT/HepB path: DPT1/2/3, HepB1/2/3, OPV1/2/3, BCG, Measles, VitA1"
)),
'percent':
percent_diff('immunized', this_month_data, prev_month_data,
'eligible'),
'color':
'green'
if percent_diff('immunized', this_month_data, prev_month_data,
'eligible') > 0 else 'red',
'value':
get_value(this_month_data, 'immunized'),
'all':
get_value(this_month_data, 'eligible'),
'format':
'percent_and_div',
'frequency':
'month'
},
{
'label':
_('Institutional Deliveries'),
'help_text':
_(("Percentage of pregnant women who delivered in a public or private medical "
"facility in the last month. "
"Delivery in medical institutions is associated with a decrease maternal mortality rate"
)),
'percent':
percent_diff('institutional_delivery_in_month_sum',
this_month_institutional_delivery_data,
prev_month_institutional_delivery_data,
'delivered_in_month_sum'),
'color':
'green'
if percent_diff('institutional_delivery_in_month_sum',
this_month_institutional_delivery_data,
prev_month_institutional_delivery_data,
'delivered_in_month_sum') > 0 else 'red',
'value':
get_value(this_month_institutional_delivery_data,
'institutional_delivery_in_month_sum'),
'all':
get_value(this_month_institutional_delivery_data,
'delivered_in_month_sum'),
'format':
'percent_and_div',
'frequency':
'month'
},
]]
}