def columns(self): return [ DatabaseColumn( "Trimester 1", CountUniqueColumn('doc_id', alias="trimester_1", filters=self.filters + [GT('edd', "today_plus_196")])), DatabaseColumn( "Trimester 2", CountUniqueColumn('doc_id', alias="trimester_2", filters=self.filters + [ AND([ LTE('edd', "today_plus_196"), GT('edd', "today_plus_84") ]) ])), DatabaseColumn( "Trimester 3", CountUniqueColumn('doc_id', alias="trimester_3", filters=self.filters + [LTE('edd', 'today_plus_84')])) ]
def columns(self): columns = [ DatabaseColumn( "Total children with with birthweight known", CountUniqueColumn('doc_id', alias="total_birthweight_known", filters=self.filters + [NOTEQ('weight_birth', 'empty')])), ] columns.extend([ DatabaseColumn( "Birthweight < 2.5 kg", CountUniqueColumn( 'doc_id', alias="total_birthweight_lt_25", filters=self.filters + [ AND([ LT('weight_birth', 'weight_birth_25'), NOTEQ('weight_birth', 'empty') ]) ])), DatabaseColumn( "Birthweight >= 2.5 kg", CountUniqueColumn( 'doc_id', alias="total_birthweight_gte_25", filters=self.filters + [ AND([ GTE('weight_birth', 'weight_birth_25'), NOTEQ('weight_birth', 'empty') ]) ])) ]) return columns
def columns(self): columns = super(DeliveryPlaceDetailsExtended, self).columns additional_columns = [ DatabaseColumn( "Home deliveries", CountUniqueColumn('doc_id', alias="home_deliveries", filters=self.filters + [ OR([ EQ('place_of_birth', 'home'), EQ('place_of_birth', 'on_route') ]) ])), DatabaseColumn( "Other places", CountUniqueColumn('doc_id', alias="other_places", filters=self.filters + [ OR([ EQ('place_of_birth', 'empty'), EQ('place_of_birth', 'other') ]) ])) ] columns.extend(additional_columns) return columns
def columns(self): return [ DatabaseColumn( "Total Deliveries (with/without outcome)", CountUniqueColumn('doc_id', alias="total_delivery", filters=self.filters), ), DatabaseColumn( "Normal deliveries", CountUniqueColumn( 'doc_id', alias="normal_deliveries", filters=self.filters + [EQ('type_of_delivery', 'normal_delivery')])), DatabaseColumn( "Caesarean deliveries", CountUniqueColumn( 'doc_id', alias="caesarean_deliveries", filters=self.filters + [EQ('type_of_delivery', 'cesarean_delivery')])), DatabaseColumn( "Delivery type unknown", CountUniqueColumn( 'doc_id', alias="unknown", filters=self.filters + [ OR([ EQ('type_of_delivery', 'empty'), EQ('type_of_delivery', 'unknown_delivery') ]) ])) ]
def columns(self): self.config['mother_ids'] = tuple(DeliveryMothersIds(config=self.config).data.keys()) + ('',) columns = [ DatabaseColumn("Total children with with birthweight known", CountUniqueColumn('doc_id', alias="total_birthweight_known", filters=self.filters + [NOTEQ('weight_birth', 'empty')])), DatabaseColumn("Total births", CountUniqueColumn('doc_id', filters=[AND([IN('mother_id', get_INFilter_bindparams('mother_ids', self.config['mother_ids'])), OR([EQ('gender', 'female'), EQ('gender', 'male')])])], alias='total_births'))] columns.extend([ DatabaseColumn("Birthweight < 2.5 kg", CountUniqueColumn('doc_id', alias="total_birthweight_lt_25", filters=self.filters + [AND([LT('weight_birth', 'weight_birth_25'), NOTEQ('weight_birth', 'empty')])] ) ), DatabaseColumn("Birthweight >= 2.5 kg", CountUniqueColumn('doc_id', alias="total_birthweight_gte_25", filters=self.filters + [AND([GTE('weight_birth', 'weight_birth_25'), NOTEQ('weight_birth', 'empty')])] ) ) ]) return columns
def columns(self): self.config['mother_ids'] = tuple( DeliveryMothersIds(config=self.config).data.keys()) + ('', ) return [ DatabaseColumn( "Total births", CountUniqueColumn( 'doc_id', filters=[ AND([ IN( 'mother_id', get_INFilter_bindparams( 'mother_ids', self.config['mother_ids'])), OR([EQ('gender', 'female'), EQ('gender', 'male')]) ]) ], alias='total_births')), DatabaseColumn( "Newborn deaths (< 1 m)", CountUniqueColumn( 'doc_id', filters=self.filters + [ AND([ EQ('reason_for_child_closure', 'death'), EQ('type_of_child_death', 'newborn_death') ]) ], alias='newborn_death')), DatabaseColumn( "Infant deaths (< 1 y)", CountUniqueColumn( 'doc_id', filters=self.filters + [ AND([ EQ('reason_for_child_closure', 'death'), EQ('type_of_child_death', 'infant_death') ]) ], alias='infant_death')), DatabaseColumn( "Child deaths (2-5y)", CountUniqueColumn( 'doc_id', filters=self.filters + [ AND([ EQ('reason_for_child_closure', 'death'), EQ('type_of_child_death', 'child_death') ]) ], alias='child_death')), DatabaseColumn( "Total deaths", CountUniqueColumn('doc_id', filters=self.filters + [EQ('reason_for_child_closure', 'death')], alias='total_deaths')) ]
def columns(self): return [ DatabaseColumn("Live birth (Male)", CountUniqueColumn('doc_id', alias='girls', filters=self.filters + [EQ('gender', 'female')]) ), DatabaseColumn("Live birth (Female)", CountUniqueColumn('doc_id', alias='boys', filters=self.filters + [EQ('gender', 'male')]) ) ]
def columns(self): return [ DatabaseColumn("Early initiation of breastfeeding", CountUniqueColumn('doc_id', alias="colostrum_feeding", filters=self.filters + [EQ('breastfeed_1_hour', 'yes')])), DatabaseColumn("Early initiation of breastfeeding Total Eligible", CountUniqueColumn('doc_id', alias="colostrum_feeding_total_eligible", filters=self.filters + [NOTEQ('breastfeed_1_hour', 'empty')])), DatabaseColumn("Exclusive breastfeeding", CountUniqueColumn('doc_id', alias="exclusive_breastfeeding", filters=self.filters + [AND([EQ('exclusive_breastfeeding', "yes"), GTE('dob', "today_minus_183")])])), DatabaseColumn("Exclusive Breastfeeding (EBF) Total Eligible", CountUniqueColumn('doc_id', alias="exclusive_breastfeeding_total_eligible", filters=self.filters + [GTE('dob', 'today_minus_183')])), DatabaseColumn("Supplementary feeding", CountUniqueColumn('doc_id', alias="supplementary_feeding", filters=self.filters + [AND([EQ('supplementary_feeding_baby', 'yes'), GTE('dob', 'today_minus_182')])])), DatabaseColumn("Supplementary feeding Total Eligible", CountUniqueColumn('doc_id', alias="supplementary_feeding_total_eligible", filters=self.filters + [GTE('dob', 'today_minus_182')])), DatabaseColumn("Complementary feeding", CountUniqueColumn('doc_id', alias="complementary_feeding", filters=self.filters + [AND([EQ('comp_breastfeeding', 'yes'), LTE('dob', 'today_minus_183'), GTE('dob', 'today_minus_730')])])), DatabaseColumn("Complementary feeding Total Eligible", CountUniqueColumn('doc_id', alias="complementary_feeding_total_eligible", filters=self.filters + [AND([LTE('dob', 'today_minus_183'), GTE('dob', 'today_minus_730')])])) ]
def columns(self): return [ DatabaseColumn( "Deworming dose in last 6 months", CountUniqueColumn('doc_id', alias="deworming", filters=self.filters + [EQ('deworm', 'yes')])), DatabaseColumn( "Deworming Total Eligible", CountUniqueColumn('doc_id', alias="deworming_total_eligible", filters=self.filters + [LTE('dob', 'today_minus_365')])), ]
def columns(self): columns = [ DatabaseColumn("Total child registered ever", CountUniqueColumn('doc_id', alias="total")) ] if 'startdate' not in self.config and 'enddate' not in self.config or 'startdate' not in self.config \ and 'enddate' in self.config: columns.extend([ DatabaseColumn( "Total open children cases", CountUniqueColumn( 'doc_id', alias="no_date_opened", filters=self.filters + [EQ('closed_on', 'empty')] ) ), DatabaseColumn( "Total closed children cases", CountUniqueColumn( 'doc_id', alias="no_date_closed", filters=self.filters + [NOTEQ('closed_on', 'empty')] ) ), DatabaseColumn( "New registrations during last 30 days", CountUniqueColumn( 'doc_id', alias="no_date_new_registrations", filters=self.filters + [AND([GTE('opened_on', "last_month"), LTE('opened_on', "today")])] ) ) ]) else: columns.extend([ DatabaseColumn( "Children cases open at end period", CountUniqueColumn( 'doc_id', alias="opened", filters=self.filters + [AND([LTE('opened_on', "stred"), OR([EQ('closed_on', 'empty'), GT('closed_on', "stred")])])] ) ), DatabaseColumn( "Children cases closed during period", CountUniqueColumn( 'doc_id', alias="closed", filters=self.filters + [AND([GTE('closed_on', "strsd"), LTE('closed_on', "stred")])] ) ), DatabaseColumn( "Total children followed during period", CountUniqueColumn( 'doc_id', alias="followed", filters=self.filters + [AND([LTE('opened_on', "stred"), OR([EQ('closed_on', 'empty'), GTE('closed_on', "strsd")])])] ) ), DatabaseColumn( "New registrations during period", CountUniqueColumn( 'doc_id', alias="new_registrations", filters=self.filters + [AND([LTE('opened_on', "stred"), GTE('opened_on', "strsd")])] ) ) ]) return columns
def columns(self): return [ DatabaseColumn("Still births", SumColumn('number_of_children_born_dead_total') ), DatabaseColumn("Abortions", CountUniqueColumn('doc_id', alias="abortions", filters=self.filters + [EQ('reason_for_mother_closure', 'abortion')]), ), ]
def columns(self): return [ DatabaseColumn("EBF stopped between 0-1 month", CountUniqueColumn('doc_id', alias="stopped_0_1", filters=self.filters + [LTE('ebf_stop_age_month', '1')]) ), DatabaseColumn("EBF stopped between 1-3 month", CountUniqueColumn('doc_id', alias="stopped_1_3", filters=self.filters + [AND([GT('ebf_stop_age_month', '1'), LTE('ebf_stop_age_month', '3')])]) ), DatabaseColumn("EBF stopped between 3-5 month", CountUniqueColumn('doc_id', alias="stopped_3_5", filters=self.filters + [AND([GT('ebf_stop_age_month', '3'), LTE('ebf_stop_age_month', '5')])]) ), DatabaseColumn("EBF stopped between 5-6 month", CountUniqueColumn('doc_id', alias="stopped_5_6", filters=self.filters + [AND([GT('ebf_stop_age_month', '5'), LTE('ebf_stop_age_month', '6')])]) ) ]
def columns(self): return [ DatabaseColumn("Total child ill", CountUniqueColumn( 'doc_id', alias="total_child_ill", filters=self.filters + [OR([EQ('pneumonia_since_last_visit', 'yes'), EQ('has_diarrhea_since_last_visit', 'yes')])])), DatabaseColumn("ARI (Pneumonia)", CountUniqueColumn('doc_id', alias="ari_cases", filters=self.filters + [EQ('pneumonia_since_last_visit', 'yes')])), DatabaseColumn("Diarrhea", CountUniqueColumn('doc_id', alias="diarrhea_cases", filters=self.filters + [EQ('has_diarrhea_since_last_visit', 'yes')])), DatabaseColumn("ORS given during diarrhea", CountUniqueColumn('doc_id', alias="ors", filters=self.filters + [EQ('dairrhea_treated_with_ors', 'yes')])), DatabaseColumn("Zinc given during diarrhea", CountUniqueColumn('doc_id', alias="zinc", filters=self.filters + [EQ('dairrhea_treated_with_zinc', 'yes')])) ]
def columns(self): return [ DatabaseColumn( "Total Deliveries (with/without outcome)", CountUniqueColumn('doc_id', alias="total_delivery", filters=self.filters), ), DatabaseColumn( "Institutional deliveries", CountUniqueColumn( 'doc_id', alias="institutional_deliveries", filters=self.filters + [ OR([ EQ('place_of_birth', 'health_center'), EQ('place_of_birth', "hospital") ]) ])) ]
def columns(self): return [ DatabaseColumn( "VitA1", CountUniqueColumn('doc_id', alias="vita1", filters=self.filters + [EQ('vita1', 'yes')])), DatabaseColumn( "VitA2", CountUniqueColumn('doc_id', alias="vita2", filters=self.filters + [EQ('vita2', 'yes')])), DatabaseColumn( "DPT-OPT Booster", CountUniqueColumn('doc_id', alias="dpt_opv_booster", filters=self.filters + [EQ('dpt_opv_booster', 'yes')])), DatabaseColumn( "VitA3", CountUniqueColumn('doc_id', alias="vita3", filters=self.filters + [EQ('vita3', 'yes')])), DatabaseColumn( "VitA1 Total Eligible", CountUniqueColumn('doc_id', alias="vita1_eligible", filters=self.filters + [LTE('dob', 'days_273')])), DatabaseColumn( "VitA2 Total Eligible", CountUniqueColumn('doc_id', alias="vita2_eligible", filters=self.filters + [LTE('dob', 'days_547')])), DatabaseColumn( "DPT-OPT Booster Total Eligible", CountUniqueColumn('doc_id', alias="dpt_opv_booster_eligible", filters=self.filters + [LTE('dob', 'days_548')])), DatabaseColumn( "VitA3 Total Eligible", CountUniqueColumn('doc_id', alias="vita3_eligible", filters=self.filters + [LTE('dob', 'days_700')])) ]
def columns(self): return [ DatabaseColumn( "Trimester 1", CountUniqueColumn( 'doc_id', alias="trimester_1", filters=self.filters + [ AND([ LTE('lmp', "today"), GT('lmp', "first_trimester_start_date"), NOTEQ('lmp', 'empty') ]) ])), DatabaseColumn( "Trimester 2", CountUniqueColumn( 'doc_id', alias="trimester_2", filters=self.filters + [ AND([ LTE('lmp', "second_trimester_start_date"), GT('lmp', "second_trimester_end_date"), NOTEQ('lmp', 'empty') ]) ])), DatabaseColumn( "Trimester 3", CountUniqueColumn( 'doc_id', alias="trimester_3", filters=self.filters + [ AND([ LTE('lmp', 'third_trimester_start_date'), NOTEQ('lmp', 'empty') ]) ])) ]
def columns(self): return [ DatabaseColumn( "PNC in 48 hours", CountUniqueColumn('doc_id', alias="pnc_1", filters=self.filters + [EQ('pp_1_done', 'yes')]), ), DatabaseColumn( "PNC in 2-4 days", CountUniqueColumn('doc_id', alias="pnc_2", filters=self.filters + [EQ('pp_2_done', 'yes')]), ), DatabaseColumn( "PNC in 5-7", CountUniqueColumn('doc_id', alias="pnc_3", filters=self.filters + [EQ('pp_3_done', 'yes')]), ), DatabaseColumn( "PNC in 21-42 days", CountUniqueColumn('doc_id', alias="pnc_4", filters=self.filters + [EQ('pp_4_done', 'yes')]), ), DatabaseColumn( "PNC 1 visits Total Eligible", CountUniqueColumn('doc_id', alias="pnc_1_eligible", filters=self.filters + [AND([NOTEQ('delivery_date', 'empty'), LTE('delivery_date', 'today')])]), ), DatabaseColumn("PNC 2 visits Total Eligible", CountUniqueColumn('doc_id', alias="pnc_2_eligible", filters=self.filters + [AND([NOTEQ('delivery_date', 'empty'), LTE('delivery_date', 'today_minus_2')])]), ), DatabaseColumn("PNC 3 visits Total Eligible", CountUniqueColumn('doc_id', alias="pnc_3_eligible", filters=self.filters + [AND([NOTEQ('delivery_date', 'empty'), LTE('delivery_date', 'today_minus_25')])]), ), DatabaseColumn("PNC 4 visits Total Eligible", CountUniqueColumn('doc_id', alias="pnc_4_eligible", filters=self.filters + [AND([NOTEQ('delivery_date', 'empty'), LTE('delivery_date', 'today_minus_21')])]), ) ]
def columns(self): return [ DatabaseColumn("Month", SimpleColumn('month_of_death')), DatabaseColumn("Year", SimpleColumn('year_of_death')), DatabaseColumn("Number", CountUniqueColumn('doc_id')) ]
def columns(self): return [ DatabaseColumn("Reason", SimpleColumn('type_of_child_death')), DatabaseColumn("Number", CountUniqueColumn('doc_id')) ]
def columns(self): return [ DatabaseColumn("Method", SimpleColumn('fp_method')), DatabaseColumn("Number", CountUniqueColumn('doc_id')) ]
def columns(self): return [ DatabaseColumn("Reason", SimpleColumn('cause_of_death_maternal')), DatabaseColumn("Number", CountUniqueColumn('doc_id')) ]
def columns(self): return [ DatabaseColumn("Total pregnant", CountUniqueColumn('doc_id', alias="total_pregnant")), DatabaseColumn( "No ANC", CountUniqueColumn('doc_id', alias="no_anc", filters=self.filters + [NOTEQ('anc_1', 'yes')])), DatabaseColumn( "ANC1", CountUniqueColumn('doc_id', alias="anc_1", filters=self.filters + [EQ('anc_1', 'yes')])), DatabaseColumn( "ANC2", CountUniqueColumn('doc_id', alias="anc_2", filters=self.filters + [EQ('anc_2', 'yes')])), DatabaseColumn( "ANC3", CountUniqueColumn('doc_id', alias="anc_3", filters=self.filters + [EQ('anc_3', 'yes')])), DatabaseColumn( "ANC4", CountUniqueColumn('doc_id', alias="anc_4", filters=self.filters + [EQ('anc_4', 'yes')])), DatabaseColumn( "TT1", CountUniqueColumn('doc_id', alias="tt_1", filters=self.filters + [EQ('tt_1', 'yes')])), DatabaseColumn( "TT2", CountUniqueColumn('doc_id', alias="tt_2", filters=self.filters + [EQ('tt_2', 'yes')])), DatabaseColumn( "TT Booster", CountUniqueColumn('doc_id', alias="tt_booster", filters=self.filters + [EQ('tt_booster', 'yes')])), DatabaseColumn( "TT Complete", CountUniqueColumn( 'doc_id', alias="tt_completed", filters=self.filters + [OR([EQ('tt_2', 'yes'), EQ('tt_booster', 'yes')])])), DatabaseColumn( "IFA received", CountUniqueColumn('doc_id', alias="ifa_tablets", filters=self.filters + [EQ('iron_folic', 'yes')])), DatabaseColumn( "100 IFA consumed", CountUniqueColumn('doc_id', alias="100_tablets", filters=self.filters[1:-1] + [ AND([ EQ('completed_100_ifa', 'yes'), GTE('delivery_date', 'strsd'), LTE('delivery_date', 'stred') ]) ])), DatabaseColumn( "Clinically anemic mothers", CountUniqueColumn('doc_id', alias="clinically_anemic", filters=self.filters + [EQ('anemia_signs', 'yes')])), DatabaseColumn( "Number of pregnant mother referrals due to danger signs", CountUniqueColumn('doc_id', alias="danger_signs", filters=self.filters + [EQ('currently_referred', 'yes')])), DatabaseColumn( "Knows closest health facility", CountUniqueColumn('doc_id', alias="knows_closest_facility", filters=self.filters + [EQ('knows_closest_facility', 'yes')])), DatabaseColumn( "No ANC Total Eligible", CountUniqueColumn('doc_id', alias="no_anc_eligible", filters=self.filters + [LTE('edd', 'today_plus_196')])), DatabaseColumn( "ANC1 Total Eligible", CountUniqueColumn('doc_id', alias="anc_1_eligible", filters=self.filters + [LTE('edd', 'today_plus_196')])), DatabaseColumn( "ANC2 Total Eligible", CountUniqueColumn( 'doc_id', alias="anc_2_eligible", filters=self.filters + [AND([EQ('anc_1', 'yes'), LTE('edd', 'today_plus_112')])])), DatabaseColumn( "ANC3 Total Eligible", CountUniqueColumn( 'doc_id', alias="anc_3_eligible", filters=self.filters + [AND([EQ('anc_2', 'yes'), LTE('edd', 'today_plus_56')])])), DatabaseColumn( "ANC4 Total Eligible", CountUniqueColumn( 'doc_id', alias="anc_4_eligible", filters=self.filters + [AND([EQ('anc_3', 'yes'), LTE('edd', 'today_plus_35')])])), DatabaseColumn( "TT1 Total Eligible", CountUniqueColumn('doc_id', alias="tt_1_eligible", filters=self.filters + [NOTEQ('previous_tetanus', 'yes')])), DatabaseColumn( "TT2 Total Eligible", CountUniqueColumn('doc_id', alias="tt_2_eligible", filters=self.filters + [EQ('tt_1', 'yes')])), DatabaseColumn( "TT Booster Total Eligible", CountUniqueColumn('doc_id', alias="tt_booster_eligible", filters=self.filters + [EQ('previous_tetanus', 'yes')])), DatabaseColumn( "TT Completed (TT2 or Booster) Total Eligible", CountUniqueColumn( 'doc_id', alias="tt_completed_eligible", filters=self.filters + [OR([EQ('tt_1', 'yes'), EQ('previous_tetanus', 'yes')])])), DatabaseColumn( "Taking IFA tablets Total Eligible", CountUniqueColumn('doc_id', alias="ifa_tablets_eligible")), DatabaseColumn( "Completed 100 IFA tablets Total Eligible", CountUniqueColumn('doc_id', alias="100_tablets_eligible", filters=self.filters[1:-1] + [ AND([ GTE('delivery_date', 'strsd'), LTE('delivery_date', 'stred') ]) ])), DatabaseColumn( "Clinically anemic mothers Total Eligible", CountUniqueColumn('doc_id', alias="clinically_anemic_eligible")), DatabaseColumn( "Number of mother referrals due to danger signs Total Eligible", CountUniqueColumn('doc_id', alias="danger_signs_eligible")), DatabaseColumn( "Know closest health facility Total Eligible", CountUniqueColumn('doc_id', alias="knows_closest_facility_eligible")) ]
def columns(self): return [ DatabaseColumn("Reason for closure", SimpleColumn('reason_for_mother_closure')), DatabaseColumn("Number", CountUniqueColumn('doc_id')) ]
def columns(self): return [ DatabaseColumn( "BCG", CountUniqueColumn('doc_id', alias="bcg", filters=self.filters + [EQ('bcg', 'yes')])), DatabaseColumn( "OPV3", CountUniqueColumn('doc_id', alias="opv3", filters=self.filters + [EQ('opv3', 'yes')])), DatabaseColumn( "HEP3", CountUniqueColumn('doc_id', alias="hep3", filters=self.filters + [EQ('hepb3', 'yes')])), DatabaseColumn( "DPT3", CountUniqueColumn('doc_id', alias="dpt3", filters=self.filters + [EQ('dpt3', 'yes')])), DatabaseColumn( "Measles", CountUniqueColumn('doc_id', alias="measles", filters=self.filters + [EQ('measles', 'yes')])), DatabaseColumn( "Fully Immunized in 1st year", CountUniqueColumn('doc_id', alias="fully_immunized", filters=self.filters + [ AND([ EQ('bcg', 'yes'), EQ('opv0', 'yes'), EQ('hepb0', 'yes'), EQ('opv1', 'yes'), EQ('hepb1', 'yes'), EQ('dpt1', 'yes'), EQ('opv2', 'yes'), EQ('hepb2', 'yes'), EQ('dpt2', 'yes'), EQ('opv3', 'yes'), EQ('hepb3', 'yes'), EQ('dpt3', 'yes'), EQ('measles', 'yes') ]) ])), DatabaseColumn( "DPT-OPT Booster", CountUniqueColumn('doc_id', alias="dpt_opv_booster", filters=self.filters + [EQ('dpt_opv_booster', 'yes')])), DatabaseColumn( "VitA3", CountUniqueColumn('doc_id', alias="vita3", filters=self.filters + [EQ('vita3', 'yes')])), DatabaseColumn( "BCG Total Eligible", CountUniqueColumn('doc_id', alias="bcg_eligible"), ), DatabaseColumn( "OPV3 Total Eligible", CountUniqueColumn('doc_id', alias="opv3_eligible", filters=self.filters + [LTE('dob', 'today_minus_106')])), DatabaseColumn( "HEP3 Total Eligible", CountUniqueColumn('doc_id', alias="hep3_eligible", filters=self.filters + [LTE('dob', 'today_minus_106')])), DatabaseColumn( "DPT3 Total Eligible", CountUniqueColumn('doc_id', alias="dpt3_eligible", filters=self.filters + [LTE('dob', 'today_minus_106')])), DatabaseColumn( "Measles Total Eligible", CountUniqueColumn('doc_id', alias="measles_eligible", filters=self.filters + [LTE('dob', 'today_minus_273')])), DatabaseColumn( "Fully Immunized Total Eligible", CountUniqueColumn('doc_id', alias="fully_immunized_eligible", filters=self.filters + [LTE('dob', 'today_minus_273')])), DatabaseColumn( "DPT-OPT Booster Total Eligible", CountUniqueColumn('doc_id', alias="dpt_opv_booster_eligible", filters=self.filters + [LTE('dob', 'today_minus_548')])), DatabaseColumn( "VitA3 Total Eligible", CountUniqueColumn('doc_id', alias="vita3_eligible", filters=self.filters + [LTE('dob', 'today_minus_700')])) ]
def columns(self): return [ DatabaseColumn("Cause of death", SimpleColumn('cause_of_death_child')), DatabaseColumn("Number", CountUniqueColumn('doc_id')), ]
def columns(self): return [ DatabaseColumn( "Total pregnant", CountUniqueColumn('doc_id', alias="total_pregnant"), ), DatabaseColumn( "ANC3", CountUniqueColumn('doc_id', alias="anc_3", filters=self.filters + [EQ('anc_3', 'yes')]), ), DatabaseColumn( "TT Completed (TT2 or Booster)", CountUniqueColumn( 'doc_id', alias="tt_completed", filters=self.filters + [OR([EQ('tt_2', 'yes'), EQ('tt_booster', 'yes')])]), ), DatabaseColumn( "Taking IFA tablets", CountUniqueColumn('doc_id', alias="ifa_tablets", filters=self.filters + [EQ('iron_folic', 'yes')]), ), DatabaseColumn( "Completed 100 IFA tablets", CountUniqueColumn('doc_id', alias="100_tablets", filters=self.filters + [EQ('completed_100_ifa', 'yes')]), ), DatabaseColumn( "ANC3 Total Eligible", CountUniqueColumn( 'doc_id', alias="anc_3_eligible", filters=self.filters + [AND([EQ('anc_2', 'yes'), LTE('lmp', 'days_224')])]), ), DatabaseColumn( "TT Completed (TT2 or Booster) Total Eligible", CountUniqueColumn( 'doc_id', alias="tt_completed_eligible", filters=self.filters + [OR([EQ('tt_1', 'yes'), EQ('previous_tetanus', 'yes')])]), ), DatabaseColumn( "Taking IFA tablets Total Eligible", CountUniqueColumn('doc_id', alias="ifa_tablets_eligible"), ), DatabaseColumn( "Completed 100 IFA tablets Total Eligible", CountUniqueColumn('doc_id', alias="100_tablets_eligible", filters=self.filters + [LTE('lmp', 'days_195')]), ) ]
def columns(self): return [ DatabaseColumn("Total pregnant", CountUniqueColumn('doc_id', alias="total_pregnant")), DatabaseColumn( "ANC3", CountUniqueColumn('doc_id', alias="anc_3", filters=self.filters + [EQ('anc_3', 'yes')])), DatabaseColumn( "TT Completed (TT2 or Booster)", CountUniqueColumn( 'doc_id', alias="tt_completed", filters=self.filters + [OR([EQ('tt_2', 'yes'), EQ('tt_booster', 'yes')])])), DatabaseColumn( "Taking IFA tablets", CountUniqueColumn('doc_id', alias="ifa_tablets", filters=self.filters + [EQ('iron_folic', 'yes')])), DatabaseColumn( "Completed 100 IFA tablets", CountUniqueColumn('doc_id', alias="100_tablets", filters=self.filters[1:-1] + [ AND([ EQ('completed_100_ifa', 'yes'), GTE('delivery_date', 'strsd'), LTE('delivery_date', 'stred') ]) ])), DatabaseColumn( "ANC3 Total Eligible", CountUniqueColumn( 'doc_id', alias="anc_3_eligible", filters=self.filters + [AND([EQ('anc_2', 'yes'), LTE('edd', 'today_plus_56')])])), DatabaseColumn( "TT Completed (TT2 or Booster) Total Eligible", CountUniqueColumn( 'doc_id', alias="tt_completed_eligible", filters=self.filters + [OR([EQ('tt_1', 'yes'), EQ('previous_tetanus', 'yes')])])), DatabaseColumn( "Taking IFA tablets Total Eligible", CountUniqueColumn('doc_id', alias="ifa_tablets_eligible")), DatabaseColumn( "Completed 100 IFA tablets Total Eligible", CountUniqueColumn('doc_id', alias="100_tablets_eligible", filters=self.filters[1:-1] + [ AND([ GTE('delivery_date', 'strsd'), LTE('delivery_date', 'stred') ]) ])), ]
def columns(self): columns = super(ImmunizationDetailsFirstYear, self).columns del columns[6:8] del columns[-2:] cols1 = [ DatabaseColumn( "OPV0", CountUniqueColumn('doc_id', alias="opv0", filters=self.filters + [EQ('opv0', 'yes')])), DatabaseColumn( "HEP0", CountUniqueColumn('doc_id', alias="hep0", filters=self.filters + [EQ('hepb0', 'yes')])), DatabaseColumn( "OPV1", CountUniqueColumn('doc_id', alias="opv1", filters=self.filters + [EQ('opv1', 'yes')])), DatabaseColumn( "HEP1", CountUniqueColumn('doc_id', alias="hep1", filters=self.filters + [EQ('hepb1', 'yes')])), DatabaseColumn( "DPT1", CountUniqueColumn('doc_id', alias="dpt1", filters=self.filters + [EQ('dpt1', 'yes')])), DatabaseColumn( "OPV2", CountUniqueColumn('doc_id', alias="opv2", filters=self.filters + [EQ('opv2', 'yes')])), DatabaseColumn( "HEP2", CountUniqueColumn('doc_id', alias="hep2", filters=self.filters + [EQ('hepb2', 'yes')])), DatabaseColumn( "DPT2", CountUniqueColumn('doc_id', alias="dpt2", filters=self.filters + [EQ('dpt2', 'yes')])), ] cols2 = [ DatabaseColumn( "OPV0 Total Eligible", CountUniqueColumn('doc_id', alias="opv0_eligible", filters=self.filters)), DatabaseColumn( "HEP0 Total Eligible", CountUniqueColumn('doc_id', alias="hep0_eligible", filters=self.filters)), DatabaseColumn( "OPV1 Total Eligible", CountUniqueColumn('doc_id', alias="opv1_eligible", filters=self.filters + [LTE('dob', 'today_minus_40')])), DatabaseColumn( "HEP1 Total Eligible", CountUniqueColumn('doc_id', alias="hep1_eligible", filters=self.filters + [LTE('dob', 'today_minus_40')])), DatabaseColumn( "DPT1 Total Eligible", CountUniqueColumn('doc_id', alias="dpt1_eligible", filters=self.filters + [LTE('dob', 'today_minus_40')])), DatabaseColumn( "OPV2 Total Eligible", CountUniqueColumn('doc_id', alias="opv2_eligible", filters=self.filters + [LTE('dob', 'today_minus_75')])), DatabaseColumn( "HEP2 Total Eligible", CountUniqueColumn('doc_id', alias="hep2_eligible", filters=self.filters + [LTE('dob', 'today_minus_75')])), DatabaseColumn( "DPT2 Total Eligible", CountUniqueColumn('doc_id', alias="dpt2_eligible", filters=self.filters + [LTE('dob', 'today_minus_75')])) ] cols3 = [ DatabaseColumn( "VitA1", CountUniqueColumn('doc_id', alias="vita1", filters=self.filters + [EQ('vita1', 'yes')])) ] cols4 = [ DatabaseColumn( "VitA1 Total Eligible", CountUniqueColumn('doc_id', alias="vita1_eligible", filters=self.filters + [LTE('dob', 'today_minus_273')])) ] return columns[:1] + cols1 + columns[1:5] + cols3 + columns[5:-5] \ + cols2 + columns[-5:-1] + cols4 + columns[-1:]