def columns(self): cols = [ DatabaseColumn("case", SimpleColumn('case'), format_fn=self.map_case, sortable=False) ] if self.group_by else [] return cols + [ DatabaseColumn('casesUpdatedInLastWeek', SumColumn('cases_updated'), sortable=False), DatabaseColumn('casesUpdatedInWeekPrior', SumColumn('cases_updated', filters=[ filters.GTE('date', '2weekago'), filters.LT('date', 'weekago') ], alias='casesUpdatedInWeekPrior'), sortable=False), AggregateColumn( 'averageDurationPerCase', _percentage, [SumColumn('duration'), AliasColumn('cases_updated')], sortable=False) ]
def columns(self): return [ DatabaseColumn(_("Location ID"), SimpleColumn("location_id")), DatabaseColumn( _("Number of pregnant women who registered for ANC (in CCT payment sites only) " ), SumColumn("women_registered_anc_total")), DatabaseColumn( _("Number of women who had 4 ANC visits (in CCT payment sites only)" ), SumColumn("women_having_4_anc_visits_total")), DatabaseColumn( _("Number of women who delivered at the facility (in CCT payment sites only)" ), SumColumn("women_delivering_at_facility_cct_total")), DatabaseColumn( _("Number of women who attended PNC within 6 weeks of delivery" ), SumColumn( "women_delivering_within_6_weeks_attending_pnc_total")), DatabaseColumn(_("Number of free sim cards given"), SumColumn("number_of_free_sims_given_total")), DatabaseColumn(_("Number of MTN MNO"), SumColumn("mno_mtn_total")), DatabaseColumn(_("Number of Etisalat MNO"), SumColumn("mno_etisalat_total")), DatabaseColumn(_("Number of GLO MNO"), SumColumn("mno_glo_total")), DatabaseColumn(_("Number of Airtel MNO"), SumColumn("mno_airtel_total")), ]
def columns(self): return [ DatabaseColumn(_("Location ID"), SimpleColumn("location_id")), DatabaseColumn(_("Number of pregnant women who registered for ANC (in CCT payment sites only) "), SumColumn("women_registered_anc_total")), DatabaseColumn(_("Number of women who had 4 ANC visits (in CCT payment sites only)"), SumColumn("women_having_4_anc_visits_total")), DatabaseColumn(_("Number of women who delivered at the facility (in CCT payment sites only)"), SumColumn("women_delivering_at_facility_cct_total")), DatabaseColumn(_("Number of women who attended PNC within 6 weeks of delivery"), SumColumn("women_delivering_within_6_weeks_attending_pnc_total")), ]
def columns(self): return [ DatabaseColumn( _("Newborns with low birth weight discharged - Total"), SumColumn("newborns_low_birth_weight_discharged_total")), DatabaseColumn( _("Newborns with low birth weight discharged - Male"), SumColumn("newborns_low_birth_weight_discharged_male_total")), DatabaseColumn( _("Newborns with low birth weight discharged - Female"), SumColumn( "newborns_low_birth_weight_discharged_female_total")), DatabaseColumn(_("Pregnant Mothers Referred out"), SumColumn("pregnant_mothers_referred_out_total")), DatabaseColumn(_("ANC Anemia test done"), SumColumn("anc_anemia_test_done_total")), DatabaseColumn(_("ANC Anemia test positive"), SumColumn("anc_anemia_test_positive_total")), DatabaseColumn(_("ANC Proteinuria Test done"), SumColumn("anc_proteinuria_test_done_total")), DatabaseColumn(_("ANC Proteinuria test positive"), SumColumn("anc_proteinuria_test_positive_total")), DatabaseColumn(_("HIV rapid antibody test done"), SumColumn("hiv_rapid_antibody_test_done_total")), DatabaseColumn( _("Deaths of women related to pregnancy"), SumColumn("deaths_of_women_related_to_pregnancy_total")), DatabaseColumn(_("Pregnant mothers tested positive for HIV"), SumColumn("pregnant_mothers_tested_for_hiv_total")), DatabaseColumn( _("Pregnant Mothers with confirmed Malaria"), SumColumn("pregnant_mothers_with_confirmed_malaria_total")), DatabaseColumn( _("ANC Women with previously known HIV status(at ANC)"), SumColumn("anc_women_previously_known_hiv_status_total")), DatabaseColumn( _("Pregnant women who received HIV counseling testing and received result at ANC" ), SumColumn( "pregnant_women_received_hiv_counseling_and_result_anc_total" )), DatabaseColumn( _("Pregnant women who received HIV counseling testing and received result at L&D" ), SumColumn( "pregnant_women_received_hiv_counseling_and_result_ld_total" )), DatabaseColumn( _("Partners of HIV positive women who tested HIV negative"), SumColumn( "partners_of_hiv_positive_women_tested_negative_total")), DatabaseColumn( _("Partners of HIV positive women who tested positive"), SumColumn( "partners_of_hiv_positive_women_tested_positive_total")), DatabaseColumn( _("Assessed for clinical stage eligibility"), SumColumn("assessed_for_clinical_stage_eligibility_total")), DatabaseColumn( _("Assessed for cd4-count eligibility"), SumColumn("assessed_for_clinical_cd4_eligibility_total")), DatabaseColumn( _("Pregnant HIV positive women who received ART prophylaxis for PMTCT (Triple)" ), SumColumn("pregnant_hiv_positive_women_received_art_total")), DatabaseColumn( _("Pregnant HIV positive woman who received ARV prophylaxis for PMTCT (AZT)" ), SumColumn("pregnant_hiv_positive_women_received_azt_total")), DatabaseColumn( _("Pregnant positive women who received ARV prophylaxis(SdNvP in Labor + (AZT + 3TC))" ), SumColumn( "pregnant_hiv_positive_women_received_mother_sdnvp_total") ), DatabaseColumn( _("Infants born to HIV infected women started on cotrimoxazole prophylaxis within 2 months" ), SumColumn( "infants_hiv_women_cotrimoxazole_lt_2_months_total")), DatabaseColumn( _("Infants born to HIV infected women started on cotrimoxazole prophylaxis 2 months & above" ), SumColumn( "infants_hiv_women_cotrimoxazole_gte_2_months_total")), DatabaseColumn( _("Infants born to HIV infected women who received an HIV test within two months of birth - (DNA -PCR)" ), SumColumn( "infants_hiv_women_received_hiv_test_lt_2_months_total")), DatabaseColumn( _("Infants born to HIV infected women who received an HIV test after two months of birth - (DNA - PCR)" ), SumColumn( "infants_hiv_women_received_hiv_test_gte_2_months_total")), DatabaseColumn( _("Infants born to HIV infected women who received an HIV test at 18 months - (HIV Rapid test)" ), SumColumn( "infants_hiv_women_received_hiv_test_lt_18_months_total")), DatabaseColumn( _("Infant born to HIV infected women who tested negative to HIV Rapid test at 18 months" ), SumColumn( "infants_hiv_women_received_hiv_test_gte_18_months_total") ), DatabaseColumn( _("HIV exposed infants breast feeding and receiving ARV prophylaxis" ), SumColumn( "hiv_exposed_infants_breast_feeding_receiving_arv_total")) ]
def columns(self): return [ DatabaseColumn(_("Location ID"), SimpleColumn("location_id")), DatabaseColumn(_("Eligible beneficiaries due to registration"), SumColumn("status_eligible_due_to_registration")), DatabaseColumn(_("Eligible beneficiaries due to 4th visit"), SumColumn("status_eligible_due_to_4th_visit")), DatabaseColumn(_("Eligible beneficiaries due to delivery"), SumColumn("status_eligible_due_to_delivery")), DatabaseColumn( _("Eligible beneficiaries due to immunization or PNC visit"), SumColumn("status_eligible_due_to_immun_or_pnc_visit")), DatabaseColumn(_("Reviewed beneficiaries due to registration"), SumColumn("status_reviewed_due_to_registration")), DatabaseColumn(_("Reviewed beneficiaries due to 4th visit"), SumColumn("status_reviewed_due_to_4th_visit")), DatabaseColumn(_("Reviewed beneficiaries due to delivery"), SumColumn("status_reviewed_due_to_delivery")), DatabaseColumn( _("Reviewed beneficiaries due to immunization or PNC visit"), SumColumn("status_reviewed_due_to_immun_or_pnc_visit")), DatabaseColumn(_("Approved beneficiaries due to registration"), SumColumn("status_approved_due_to_registration")), DatabaseColumn(_("Approved beneficiaries due to 4th visit"), SumColumn("status_approved_due_to_4th_visit")), DatabaseColumn(_("Approved beneficiaries due to delivery"), SumColumn("status_approved_due_to_delivery")), DatabaseColumn( _("Approved beneficiaries due to immunization or PNC visit"), SumColumn("status_approved_due_to_immun_or_pnc_visit")), DatabaseColumn(_("Paid beneficiaries due to registration"), SumColumn("status_paid_due_to_registration")), DatabaseColumn(_("Paid beneficiaries due to 4th visit"), SumColumn("status_paid_due_to_4th_visit")), DatabaseColumn(_("Paid beneficiaries due to delivery"), SumColumn("status_paid_due_to_delivery")), DatabaseColumn( _("Paid beneficiaries due to immunization or PNC visit"), SumColumn("status_paid_due_to_immun_or_pnc_visit")), DatabaseColumn( _("Rejected beneficiaries due to incorrect phone number"), SumColumn("status_rejected_due_to_incorrect_phone_number")), DatabaseColumn(_("Rejected beneficiaries due to double entry"), SumColumn("status_rejected_due_to_double_entry")), DatabaseColumn(_("Rejected beneficiaries due to other errors"), SumColumn("status_rejected_due_to_other_errors")) ]
def columns(self): return [ DatabaseColumn(_("Location ID"), SimpleColumn("location_id")), DatabaseColumn(_("Antenatal Attendance - Total"), SumColumn("attendance_total")), DatabaseColumn(_("Antenatal first Visit before 20wks"), SumColumn("attendance_before_20_weeks_total")), DatabaseColumn(_("Antenatal first Visit after 20wks"), SumColumn("attendance_after_20_weeks_total")), DatabaseColumn( _("Pregnant Women that attend antenatal clinic for 4th visit during the month" ), SumColumn("attendance_gte_4_visits_total")), DatabaseColumn(_("ANC syphilis test done"), SumColumn("anc_syphilis_test_done_total")), DatabaseColumn(_("ANC syphilis test positive"), SumColumn("anc_syphilis_test_positive_total")), DatabaseColumn(_("ANC syphilis case treated"), SumColumn("anc_syphilis_case_treated_total")), DatabaseColumn(_("Pregnant women who receive malaria IPT1"), SumColumn("pregnant_mothers_receiving_ipt1_total")), DatabaseColumn(_("Pregnant women who receive malaria IPT2"), SumColumn("pregnant_mothers_receiving_ipt2_total")), DatabaseColumn(_("Pregnant women who receive malaria LLIN"), SumColumn("pregnant_mothers_receiving_llin_total")), DatabaseColumn(_("Pregnant women who receive malaria Haematinics"), SumColumn("pregnant_mothers_receiving_ifa_total")), DatabaseColumn(_("Postanatal Attendance - Total"), SumColumn("postnatal_attendance_total")), DatabaseColumn( _("Postnatal clinic visit within 1 day of delivery"), SumColumn("postnatal_clinic_visit_lte_1_day_total")), DatabaseColumn( _("Postnatal clinic visit within 3 days of delivery"), SumColumn("postnatal_clinic_visit_lte_3_days_total")), DatabaseColumn( _("Postnatal clinic visit >= 7 days of delivery"), SumColumn("postnatal_clinic_visit_gte_7_days_total")) ]
def columns(self): return [ DatabaseColumn(_("Location ID"), SimpleColumn("location_id")), DatabaseColumn(_("OPV0 - birth "), SumColumn("opv_0_total")), DatabaseColumn(_("Hep.B0 - birth"), SumColumn("hep_b_0_total")), DatabaseColumn(_("BCG"), SumColumn("bcg_total")), DatabaseColumn(_("OPV1"), SumColumn("opv_1_total")), DatabaseColumn(_("HEP.B1"), SumColumn("hep_b_1_total")), DatabaseColumn(_("Penta.1"), SumColumn("penta_1_total")), DatabaseColumn(_("DPT1 (not when using Penta)"), SumColumn("dpt_1_total")), DatabaseColumn(_("PCV1"), SumColumn("pcv_1_total")), DatabaseColumn(_("OPV2"), SumColumn("opv_2_total")), DatabaseColumn(_("Hep.B2"), SumColumn("hep_b_2_total")), DatabaseColumn(_("Penta.2"), SumColumn("penta_2_total")), DatabaseColumn(_("DPT2 (not when using Penta)"), SumColumn("dpt_2_total")), DatabaseColumn(_("PCV2"), SumColumn("pcv_2_total")), DatabaseColumn(_("OPV3"), SumColumn("opv_3_total")), DatabaseColumn(_("Penta.3"), SumColumn("penta_3_total")), DatabaseColumn(_("DPT3 (not when using Penta)"), SumColumn("dpt_3_total")), DatabaseColumn(_("PCV3"), SumColumn("pcv_3_total")), DatabaseColumn(_("Measles 1"), SumColumn("measles_1_total")), DatabaseColumn(_("Fully Immunized (<1year)"), SumColumn("fully_immunized_total")), DatabaseColumn(_("Yellow Fever"), SumColumn("yellow_fever_total")), DatabaseColumn(_("Measles 2"), SumColumn("measles_2_total")), DatabaseColumn(_("Conjugate A CSM"), SumColumn("conjugate_csm_total")) ]
def columns(self): return [ DatabaseColumn(_("Location ID"), SimpleColumn("location_id")), DatabaseColumn(_("Deliveries - Total"), SumColumn("deliveries_total")), DatabaseColumn(_("Deliveries - SVD"), SumColumn("deliveries_svd_total")), DatabaseColumn(_("Deliveries - Assisted"), SumColumn("deliveries_assisted_total")), DatabaseColumn(_("Deliveries caesarean section"), SumColumn("deliveries_caesarean_section_total")), DatabaseColumn(_("Deliveries - Complications"), SumColumn("deliveries_complications_total")), DatabaseColumn(_("Deliveries - Preterm"), SumColumn("deliveries_preterm_total")), DatabaseColumn(_("Deliveries - HIV positive women"), SumColumn("deliveries_hiv_positive_women_total")), DatabaseColumn(_("LiveBirth - HIV positive women"), SumColumn("live_birth_hiv_positive_women_total")), DatabaseColumn( _("Deliveries - HIV positive booked women"), SumColumn("deliveries_hiv_positive_booked_women_total")), DatabaseColumn( _("Deliveries - HIV positive unbooked women"), SumColumn("deliveries_hiv_positive_unbooked_women_total")), # DatabaseColumn(_("Deliveries - Monitored using Partograph"), SumColumn("deliveries_monitored_using_partograph_total")), # DatabaseColumn(_("Deliveries taken by skilled birth attendant"), SumColumn("deliveries_skilled_birth_attendant_total")), DatabaseColumn(_("TT1"), SumColumn("tt1_total")), DatabaseColumn(_("TT2"), SumColumn("tt2_total")), DatabaseColumn(_("Live Births(Male, Female, < 2.5kg, >= 2.5k g)"), SumColumn("live_births_male_female_total")), DatabaseColumn(_("Male, < 2.5kg"), SumColumn("male_lt_2_5kg_total")), DatabaseColumn(_("Male, >= 2.5kg"), SumColumn("male_gte_2_5kg_total")), DatabaseColumn(_("Female, < 2.5kg"), SumColumn("female_lt_2_5kg_total")), DatabaseColumn(_("Female, >= 2.5kg"), SumColumn("female_gte_2_5kg_total")), DatabaseColumn(_("Still Births total"), SumColumn("still_births_total")), DatabaseColumn(_("Fresh Still Births"), SumColumn("fresh_still_births_total")), DatabaseColumn(_("Other still Births"), SumColumn("other_still_births_total")), DatabaseColumn(_("Abortion Induced"), SumColumn("abortion_induced_total")), DatabaseColumn(_("Other Abortions"), SumColumn("other_abortions_total")), DatabaseColumn(_("Total Abortions"), SumColumn("total_abortions_total")), DatabaseColumn(_("Birth Asphyxia - Total"), SumColumn("birth_asphyxia_total")), DatabaseColumn(_("Birth Asphyxia - Male"), SumColumn("birth_asphyxia_male_total")), DatabaseColumn(_("Birth Asphyxia - Female"), SumColumn("birth_asphyxia_female_total")), DatabaseColumn(_("Neonatal Sepsis - Total"), SumColumn("neonatal_sepsis_total")), DatabaseColumn(_("Neonatal Sepsis - Male"), SumColumn("neonatal_sepsis_male_total")), DatabaseColumn(_("Neonatal Sepsis - Female"), SumColumn("neonatal_sepsis_female_total")), DatabaseColumn(_("Neonatal Tetanus - Total"), SumColumn("neonatal_tetanus_total")), DatabaseColumn(_("Neonatal Tetanus - Male"), SumColumn("neonatal_tetanus_male_total")), DatabaseColumn(_("Neonatal Tetanus - Female"), SumColumn("neonatal_tetanus_female_total")), DatabaseColumn(_("Neonatal Jaundice - Total"), SumColumn("neonatal_jaundice_total")), DatabaseColumn(_("Neonatal Jaundice - Male"), SumColumn("neonatal_jaundice_male_total")), DatabaseColumn(_("Neonatal Jaundice - Female"), SumColumn("neonatal_jaundice_female_total")), DatabaseColumn(_("Low birth weight babies placed in KMC - Total"), SumColumn("low_birth_weight_babies_in_kmc_total")), DatabaseColumn( _("Low birth weight babies placed in KMC - Male"), SumColumn("low_birth_weight_babies_in_kmc_male_total")), DatabaseColumn( _("Low birth weight babies placed in KMC - Female"), SumColumn("low_birth_weight_babies_in_kmc_female_total")), # DatabaseColumn(_("Newborns with low birth weight discharged - Total"), SumColumn("newborns_low_birth_weight_discharged_total")), # DatabaseColumn(_("Newborns with low birth weight discharged - Male"), SumColumn("newborns_low_birth_weight_discharged_male_total")), # DatabaseColumn(_("Newborns with low birth weight discharged - Female"), SumColumn("newborns_low_birth_weight_discharged_female_total")), ]
def _generate_total_column(column_name, selectable): from sqlagg import SumColumn return SumColumn(column_name).sql_column.build_column(selectable)