Exemplo n.º 1
0
    def columns(self):

        return [
            DatabaseColumn('Product Name', SimpleColumn('product_name')),
            DatabaseColumn("Commandes", SumColumn('commandes_total')),
            DatabaseColumn("Recu", SumColumn('recus_total'))
        ]
Exemplo n.º 2
0
    def columns(self):
        diff = lambda x, y: (x or 0) - (y or 0)

        def get_prd_name(id):
            try:
                return SQLProduct.objects.get(product_id=id, domain=self.config['domain'],
                                              is_archived=False).name
            except SQLProduct.DoesNotExist:
                pass
        return [
            DatabaseColumn(_("Designations"), SimpleColumn('product_id'),
                           format_fn=lambda id: get_prd_name(id)),
            DatabaseColumn(_("Stock apres derniere livraison"), SumColumn('product_old_stock_total')),
            DatabaseColumn(_("Stock disponible et utilisable a la livraison"), SumColumn('product_total_stock')),
            DatabaseColumn(_("Livraison"), SumColumn('product_livraison')),
            DatabaseColumn(_("Stock Total"), SumColumn('product_display_total_stock', alias='stock_total')),
            DatabaseColumn(_("Precedent"), SumColumn('product_old_stock_pps')),
            DatabaseColumn(_("Recu hors entrepots mobiles"), SumColumn('product_outside_receipts_amount')),
            AggregateColumn(_("Non Facturable"), diff,
                            [AliasColumn('aconsumption'), AliasColumn("bconsumption")]),
            DatabaseColumn(_("Facturable"), SumColumn('product_billed_consumption', alias='bconsumption')),
            DatabaseColumn(_("Reelle"), SumColumn('product_actual_consumption', alias='aconsumption')),
            DatabaseColumn("Stock Total", AliasColumn('stock_total')),
            DatabaseColumn("PPS Restant", SumColumn('product_pps_restant')),
            DatabaseColumn("Pertes et Adjustement", SumColumn('product_loss_amt'))
        ]
Exemplo n.º 3
0
 def columns(self):
     return [
         DatabaseColumn('# of Beneficiaries Registered', SumColumn('beneficiaries_registered_total')),
         DatabaseColumn('# of Pregnant Women Registered', SumColumn('lmp_total')),
         DatabaseColumn('# of Mothers of Children Aged 3 Years and Below Registered', SumColumn('lactating_total')),
         DatabaseColumn('# of Children Between 0 and 3 Years of Age Registered', SumColumn('children_total')),
     ]
Exemplo n.º 4
0
 def columns(self):
     diff = lambda x, y: (x or 0) - (y or 0)
     return [
         DatabaseColumn(_("Designations"), SimpleColumn('product_name')),
         DatabaseColumn(_("Stock apres derniere livraison"),
                        SumColumn('product_old_stock_total')),
         DatabaseColumn(_("Stock disponible et utilisable a la livraison"),
                        SumColumn('product_total_stock')),
         DatabaseColumn(_("Livraison"), SumColumn('product_livraison')),
         DatabaseColumn(
             _("Stock Total"),
             SumColumn('product_display_total_stock', alias='stock_total')),
         DatabaseColumn(_("Precedent"), SumColumn('product_old_stock_pps')),
         DatabaseColumn(_("Recu hors entrepots mobiles"),
                        SumColumn('product_outside_receipts_amount')),
         AggregateColumn(
             _("Non Facturable"), diff,
             [AliasColumn('aconsumption'),
              AliasColumn("bconsumption")]),
         DatabaseColumn(
             _("Facturable"),
             SumColumn('product_billed_consumption', alias='bconsumption')),
         DatabaseColumn(
             _("Reelle"),
             SumColumn('product_actual_consumption', alias='aconsumption')),
         DatabaseColumn("Stock Total", AliasColumn('stock_total')),
         DatabaseColumn("PPS Restant", SumColumn('product_pps_restant')),
         DatabaseColumn("Pertes et Adjustement",
                        SumColumn('product_loss_amt'))
     ]
Exemplo n.º 5
0
    def columns(self):
        cols = [
            self.location_column,
            dynamic_date_aggregation(DatabaseColumn(
                "Incidents of Abuse",
                SumColumn('incidents_total',
                          filters=self.filters +
                          [BETWEEN('date_reported', 'startdate', 'enddate')] +
                          self.filters),
            ),
                                     date_column='date_reported'),
            dynamic_date_aggregation(DatabaseColumn(
                "Outreach activities",
                SumColumn('outreach_total',
                          filters=self.filters +
                          [BETWEEN('date', 'startdate', 'enddate')])),
                                     date_column='date'),
            dynamic_date_aggregation(DatabaseColumn(
                "IGA Reports",
                SumColumn('iga_total',
                          filters=self.filters +
                          [BETWEEN('start_date', 'startdate', 'enddate')])),
                                     date_column='start_date'),
            AggregateColumn("Total", self.sum, [
                AliasColumn('incidents_total'),
                AliasColumn('outreach_total')
            ]),
        ]

        cols[0] = self.date_column
        return cols
Exemplo n.º 6
0
 def columns(self):
     return [
         DatabaseColumn("Live birth (Male)",
                        SumColumn('number_of_boys_total', alias='girls')),
         DatabaseColumn("Live birth (Female)",
                        SumColumn('number_of_girls_total', alias='boys'))
     ]
Exemplo n.º 7
0
 def columns(self):
     return [
         DatabaseColumn("User ID", SimpleColumn("user_id")),
         DatabaseColumn("Women registered",
                        SumColumn("women_registered_total")),
         DatabaseColumn("Children registered",
                        SumColumn("children_registered_total"))
     ]
Exemplo n.º 8
0
 def columns(self):
     return [
         DatabaseColumn("Case ID", SimpleColumn("case_id")),
         DatabaseColumn("Growth Monitoring Total",
                        SumColumn("growth_monitoring_total")),
         DatabaseColumn("Service Forms Total",
                        SumColumn("service_forms_total")),
     ]
Exemplo n.º 9
0
 def columns(self):
     return [
         self.location_column,
         DatabaseColumn("Children per household experiencing abuse",
                        SumColumn('abuse_children_abused_total')),
         DatabaseColumn("Total number of children in household",
                        SumColumn('abuse_children_in_household_total')),
     ]
Exemplo n.º 10
0
 def columns(self):
     columns = [DatabaseColumn(_("District"), SimpleColumn('district_name'))]
     columns.append(DatabaseColumn(_(u"Montant dû"), SumColumn('payments_amount_to_pay')))
     columns.append(DatabaseColumn(_(u"Montant payé"), SumColumn('payments_amount_paid')))
     columns.append(DatabaseColumn(_(u"Payé dans le 30 jours"), SumColumn('payments_in_30_days')))
     columns.append(DatabaseColumn(_(u"Payé dans le 3 mois"), SumColumn('payments_in_3_months')))
     columns.append(DatabaseColumn(_(u"Payé dans l`annèe"), SumColumn('payments_in_year')))
     return columns
Exemplo n.º 11
0
 def columns(self):
     return [
         self.location_column,
         DatabaseColumn("Incidents of Abuse", SumColumn('incidents_total')),
         DatabaseColumn("Outreach activities", SumColumn('outreach_total')),
         DatabaseColumn("IGA Reports", SumColumn('iga_total')),
         AggregateColumn(
             "Total", self.sum,
             [AliasColumn('incidents_total'), AliasColumn('outreach_total')]),
     ]
Exemplo n.º 12
0
 def columns(self):
     return [
         DatabaseColumn(
             'Product Name',
             SimpleColumn('product_code'),
             format_fn=lambda code: SQLProduct.objects.get(
                 code=code, domain=self.config['domain'
                                               ], is_archived=False).name),
         DatabaseColumn("Commandes", SumColumn('commandes_total')),
         DatabaseColumn("Recu", SumColumn('recus_total'))
     ]
Exemplo n.º 13
0
 def columns(self):
     diff = lambda x, y: (x or 0) - (y or 0)
     return [
         DatabaseColumn(_("LISTE des PPS"), SimpleColumn('PPS_name')),
         DatabaseColumn(_("Consommation Reelle"),
                        SumColumn('actual_consumption_total', alias='actual_consumption')),
         DatabaseColumn(_("Consommation Facturable"),
                        SumColumn('billed_consumption_total', alias='billed_consumption')),
         AggregateColumn(_("Consommation Non Facturable"), diff,
                         [AliasColumn('actual_consumption'), AliasColumn('billed_consumption')]),
     ]
Exemplo n.º 14
0
    def columns(self):
        cols = [
            self.location_column,
            dynamic_date_aggregation(DatabaseColumn(
                "Counselling",
                SumColumn('service_counselling_total',
                          filters=self.filters +
                          [BETWEEN('date_reported', 'startdate', 'enddate')])),
                                     date_column='date_reported'),
            dynamic_date_aggregation(DatabaseColumn(
                "Psychosocial Support",
                SumColumn('service_psychosocial_support_total',
                          filters=self.filters +
                          [BETWEEN('date_reported', 'startdate', 'enddate')])),
                                     date_column='date_reported'),
            dynamic_date_aggregation(DatabaseColumn(
                "First Aid",
                SumColumn('service_first_aid_total',
                          filters=self.filters +
                          [BETWEEN('date_reported', 'startdate', 'enddate')])),
                                     date_column='date_reported'),
            dynamic_date_aggregation(DatabaseColumn(
                "Shelter",
                SumColumn('service_shelter_total',
                          filters=self.filters +
                          [BETWEEN('date_reported', 'startdate', 'enddate')])),
                                     date_column='date_reported'),
            dynamic_date_aggregation(DatabaseColumn(
                "Referral",
                SumColumn('service_referral_total',
                          filters=self.filters + [
                              BETWEEN('date_reported_mediated', 'startdate',
                                      'enddate')
                          ])),
                                     date_column='date_reported_mediated'),
            dynamic_date_aggregation(DatabaseColumn(
                "Mediation",
                SumColumn('service_mediation_total',
                          filters=self.filters +
                          [BETWEEN('date_reported', 'startdate', 'enddate')])),
                                     date_column='date_reported'),
            dynamic_date_aggregation(DatabaseColumn(
                "Other",
                SumColumn('service_other_total',
                          filters=self.filters +
                          [BETWEEN('date_reported', 'startdate', 'enddate')])),
                                     date_column='date_reported'),
            dynamic_date_aggregation(DatabaseColumn(
                "Total",
                SumColumn('service_total_total',
                          filters=self.filters + [
                              BETWEEN('date_reported_mediated', 'startdate',
                                      'enddate')
                          ])),
                                     date_column='date_reported_mediated'),
        ]

        cols[0] = self.date_column
        return cols
Exemplo n.º 15
0
 def columns(self):
     return [
         DatabaseColumn('# of Beneficiaries Attending VHND Monthly', SumColumn('vhnd_monthly_total')),
         DatabaseColumn('# of Pregnant Women Who Have Received at least 30 IFA Tablets', SumColumn('ifa_tablets_total')),
         DatabaseColumn('# of Pregnant Women Whose Weight Gain Was Monitored At Least Once', SumColumn('weight_once_total')),
         DatabaseColumn('# of Pregnant Women Whose Weight Gain Was Monitored Twice', SumColumn('weight_twice_total')),
         DatabaseColumn('# of Children Whose Weight Was Monitored at Birth', SumColumn('children_monitored_at_birth_total')),
         DatabaseColumn('# of Children Whose Birth Was Registered', SumColumn('children_registered_total')),
         DatabaseColumn('# of Children Who Have Attended At Least 1 Growth Monitoring Session', SumColumn('growth_monitoring_session_1_total')),
         DatabaseColumn('# of Children Who Have Attended At Least 2 Growth Monitoring Sessions', SumColumn('growth_monitoring_session_2_total')),
         DatabaseColumn('# of Children Who Have Attended At Least 3 Growth Monitoring Sessions', SumColumn('growth_monitoring_session_3_total')),
         DatabaseColumn('# of Children Who Have Attended At Least 4 Growth Monitoring Sessions', SumColumn('growth_monitoring_session_4_total')),
         DatabaseColumn('# of Children Who Have Attended At Least 5 Growth Monitoring Sessions', SumColumn('growth_monitoring_session_5_total')),
         DatabaseColumn('# of Children Who Have Attended At Least 6 Growth Monitoring Sessions', SumColumn('growth_monitoring_session_6_total')),
         DatabaseColumn('# of Children Who Have Attended At Least 7 Growth Monitoring Sessions', SumColumn('growth_monitoring_session_7_total')),
         DatabaseColumn('# of Children Who Have Attended At Least 8 Growth Monitoring Sessions', SumColumn('growth_monitoring_session_8_total')),
         DatabaseColumn('# of Children Who Have Attended At Least 9 Growth Monitoring Sessions', SumColumn('growth_monitoring_session_9_total')),
         DatabaseColumn('# of Children Who Have Attended At Least 10 Growth Monitoring Sessions', SumColumn('growth_monitoring_session_10_total')),
         DatabaseColumn('# of Children Who Have Attended At Least 11 Growth Monitoring Sessions', SumColumn('growth_monitoring_session_11_total')),
         DatabaseColumn('# of Children Who Have Attended At Least 12 Growth Monitoring Sessions', SumColumn('growth_monitoring_session_12_total')),
         DatabaseColumn('# of Children Whose Nutritional Status is Normal', SumColumn('nutritional_status_normal_total')),
         DatabaseColumn('# of Children Whose Nutritional Status is "MAM"', SumColumn('nutritional_status_mam_total')),
         DatabaseColumn('# of Children Whose Nutritional Status is "SAM"', SumColumn('nutritional_status_sam_total')),
         DatabaseColumn('# of Children Who Have Received ORS and Zinc Treatment if He/She Contracts Diarrhea', SumColumn('treated_total')),
         DatabaseColumn('# of Children Who Have Received ORS and Zinc Treatment if He/She Contracts Diarrhea', SumColumn('suffering_total')),
         DatabaseColumn('# of Mothers of Children Aged 3 Years and Below Who Reported to Have Exclusively Breastfed Their Children for First 6 Months', SumColumn('excbreastfed_total')),
         DatabaseColumn('# of Children Who Received Measles Vaccine', SumColumn('measlesvacc_total')),
     ]
Exemplo n.º 16
0
 def columns(self):
     cat_group = DataTablesColumnGroup("Category of abuse")
     return [
         self.location_column,
         DatabaseColumn("Physical",
                        SumColumn('abuse_category_physical_total'),
                        header_group=cat_group),
         DatabaseColumn("Sexual",
                        SumColumn('abuse_category_sexual_total'),
                        header_group=cat_group),
         DatabaseColumn("Emotional",
                        SumColumn('abuse_category_psychological_total'),
                        header_group=cat_group),
         DatabaseColumn("Neglect",
                        SumColumn('abuse_category_neglect_total'),
                        header_group=cat_group),
         DatabaseColumn("Exploitation",
                        SumColumn('abuse_category_exploitation_total'),
                        header_group=cat_group),
         DatabaseColumn("Other",
                        SumColumn('abuse_category_other_total'),
                        header_group=cat_group),
         DatabaseColumn("Total incidents reported",
                        SumColumn('abuse_category_total_total'),
                        header_group=cat_group)
     ]
Exemplo n.º 17
0
 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')]),
         ),
     ]
Exemplo n.º 18
0
    def columns(self):
        columns = []
        if 'region_id' in self.config:
            columns.append(DatabaseColumn(_("District"), SimpleColumn('district_name')))
        else:
            columns.append(DatabaseColumn(_("PPS"), SimpleColumn('PPS_name')))

        columns.append(DatabaseColumn(_("Stock total"), SumColumn('total_stock_total')))
        return columns
Exemplo n.º 19
0
    def columns(self):
        columns = []
        if 'region_id' in self.config:
            columns.append(DatabaseColumn(_("District"), SimpleColumn('district_name')))
        else:
            columns.append(DatabaseColumn(_("PPS"), SimpleColumn('PPS_name')))

        columns.append(DatabaseColumn(_("Consumption"), SumColumn('actual_consumption_total')))
        return columns
Exemplo n.º 20
0
 def columns(self):
     return [
         self.location_column,
         DatabaseColumn("Counselling", SumColumn('service_counselling_total')),
         DatabaseColumn("Psychosocial Support", SumColumn('service_psychosocial_support_total')),
         DatabaseColumn("First Aid", SumColumn('service_first_aid_total')),
         DatabaseColumn("Shelter", SumColumn('service_shelter_total')),
         DatabaseColumn("Referral", SumColumn('service_referral_total')),
         DatabaseColumn("Mediation", SumColumn('service_mediation_total')),
         DatabaseColumn("Other", SumColumn('service_other_total')),
         DatabaseColumn("Total", SumColumn('service_total_total')),
     ]
 def columns(self):
     columns = self.get_columns_by_loc_level
     agg_columns = [
         AggregateColumn(
             'Percentage AWCs reported clean drinking water',
             percent_or_not_entered, [
                 SumColumn('infra_clean_water'),
                 SumColumn('num_awc_infra_last_update', alias='awcs')
             ],
             slug='percent_with_drinking_water'),
         AggregateColumn(
             'Percentage AWCs reported functional toilet',
             percent_or_not_entered,
             [SumColumn('infra_functional_toilet'),
              AliasColumn('awcs')],
             slug='percent_with_functional_toilet'),
         AggregateColumn(
             'Percentage AWCs reported medicine kit',
             percent_or_not_entered,
             [SumColumn('infra_medicine_kits'),
              AliasColumn('awcs')],
             slug='percent_with_medicine_kit'),
         AggregateColumn('Percentage AWCs reported weighing scale: infants',
                         percent_or_not_entered, [
                             SumColumn('infra_infant_weighing_scale'),
                             AliasColumn('awcs')
                         ],
                         slug='percent_baby_scale'),
         AggregateColumn(
             'Percentage AWCs reported weighing scale: mother and child',
             percent_or_not_entered,
             [SumColumn('infra_adult_weighing_scale'),
              AliasColumn('awcs')],
             slug='percent_adult_scale')
     ]
     if self.beta:
         agg_columns += [
             AggregateColumn(
                 'Percentage AWCs reported Infantometer',
                 percent_or_not_entered,
                 [SumColumn('infantometer'),
                  AliasColumn('awcs')],
                 slug='percent_with_infantometer'),
             AggregateColumn(
                 'Percentage AWCs reported Stadiometer',
                 percent_or_not_entered,
                 [SumColumn('stadiometer'),
                  AliasColumn('awcs')],
                 slug='percent_with_stadiometer')
         ]
     return columns + agg_columns
Exemplo n.º 22
0
 def columns(self):
     columns = self.get_columns_by_loc_level
     agg_columns = [
         DatabaseColumn(
             'num_children_0_6mo_enrolled_for_services',
             SumColumn('valid_in_month',
                       filters=self.filters + [
                           OR([
                               RawFilter("age_tranche = '0'"),
                               RawFilter("age_tranche = '6'")
                           ])
                       ],
                       alias='num_children_0_6mo_enrolled_for_services'),
             slug='num_children_0_6mo_enrolled_for_services'),
         DatabaseColumn(
             'num_children_6mo3yr_enrolled_for_services',
             SumColumn('valid_in_month',
                       filters=self.filters + [
                           OR([
                               RawFilter("age_tranche = '12'"),
                               RawFilter("age_tranche = '24'"),
                               RawFilter("age_tranche = '36'")
                           ])
                       ],
                       alias='num_children_6mo3yr_enrolled_for_services'),
             slug='num_children_6mo3yr_enrolled_for_services'),
         DatabaseColumn(
             'num_children_3yr6yr_enrolled_for_services',
             SumColumn('valid_in_month',
                       filters=self.filters + [
                           OR([
                               RawFilter("age_tranche = '48'"),
                               RawFilter("age_tranche = '60'"),
                               RawFilter("age_tranche = '72'")
                           ])
                       ],
                       alias='num_children_3yr6yr_enrolled_for_services'),
             slug='num_children_3yr6yr_enrolled_for_services'),
     ]
     return columns + agg_columns
Exemplo n.º 23
0
 def columns(self):
     return [
         DatabaseColumn("Case ID", SimpleColumn("case_id")),
         DatabaseColumn("Bp1 Cash Total", SumColumn("bp1_cash_total")),
         DatabaseColumn("Bp2 Cash Total", SumColumn("bp2_cash_total")),
         DatabaseColumn("Child Followup Total", SumColumn("child_followup_total")),
         DatabaseColumn("Child Spacing Deliveries", SumColumn("child_spacing_deliveries")),
         DatabaseColumn("Delivery Total", SumColumn("delivery_total")),
         DatabaseColumn("Growth Monitoring Total", SumColumn("growth_monitoring_total")),
         DatabaseColumn("Service Forms Total", SumColumn("service_forms_total")),
     ]
Exemplo n.º 24
0
    def columns(self):
        case_table_name = '%s%s_%s' % (TABLE_PREFIX, self.domain.name,
                                       MAPPING_NAME_CASES)
        case_ownership_table_name = '%s%s_%s' % (
            TABLE_PREFIX, self.domain.name, MAPPING_NAME_CASE_OWNERSHIP)
        case_type_filters = [filters.NOTEQ('case_type', 'ccCaseType')]

        columns = [
            DatabaseColumn("case",
                           SimpleColumn('user_id'),
                           format_fn=self.get_user_case_id,
                           sortable=False),
            DatabaseColumn('formsSubmittedWeek0',
                           CountColumn('date', alias='formsSubmittedWeek0'),
                           sortable=False),
            DatabaseColumn('formsSubmittedWeek1',
                           CountColumn('date',
                                       filters=filters_week1,
                                       alias='formsSubmittedWeek1'),
                           sortable=False),
            DatabaseColumn('formsSubmittedMonth0',
                           CountColumn('date',
                                       filters=filters_month0,
                                       alias='formsSubmittedMonth0'),
                           sortable=False),
            DatabaseColumn('casesUpdatedMonth0',
                           CountUniqueColumn('case_id',
                                             table_name=case_table_name,
                                             filters=filters_month0 +
                                             case_type_filters,
                                             alias='casesUpdatedMonth0'),
                           sortable=False),
            DatabaseColumn('casesUpdatedMonth1',
                           CountUniqueColumn('case_id',
                                             table_name=case_table_name,
                                             filters=filters_month1 +
                                             case_type_filters,
                                             alias='casesUpdatedMonth1'),
                           sortable=False),
            DatabaseColumn('totalCases',
                           SumColumn('open_cases',
                                     table_name=case_ownership_table_name,
                                     filters=case_type_filters,
                                     alias='totalCases'),
                           sortable=False)
        ]

        columns.extend(self._get_custom_columns())

        return columns
Exemplo n.º 25
0
 def AggColumn(label, alias, sum_slug, slug, extended=False):
     return AggregateColumn(
         label,
         format_percent,
         [
             AliasColumn(alias),
             SumColumn(
                 sum_slug,
                 filters=self.wrapped_sum_column_filters_extended
                 if extended else self.wrapped_sum_column_filters),
         ],
         slug=slug,
         format_fn=ret_val,
     )
Exemplo n.º 26
0
 def columns(self):
     return [
         self.location_column,
         DatabaseColumn(
             "Incidents of Abuse",
             SumColumn('incidents_total',
                       filters=self.filters +
                       [BETWEEN('date_reported', 'startdate', 'enddate')])),
         DatabaseColumn(
             "Outreach activities",
             SumColumn('outreach_total',
                       filters=self.filters +
                       [BETWEEN('date', 'startdate', 'enddate')])),
         DatabaseColumn(
             "IGA Reports",
             SumColumn('iga_total',
                       filters=self.filters +
                       [BETWEEN('start_date', 'startdate', 'enddate')])),
         AggregateColumn("Total", self.sum, [
             AliasColumn('incidents_total'),
             AliasColumn('outreach_total')
         ]),
     ]
Exemplo n.º 27
0
 def columns(self):
     return [
         DatabaseColumn('target_kp_prev', SumColumn('target_kp_prev')),
         DatabaseColumn('target_htc_tst', SumColumn('target_htc_tst')),
         DatabaseColumn('target_htc_pos', SumColumn('target_htc_pos')),
         DatabaseColumn('target_care_new', SumColumn('target_care_new')),
         DatabaseColumn('target_tx_new', SumColumn('target_tx_new')),
         DatabaseColumn('target_tx_undetect', SumColumn('target_tx_undetect'))
     ]
Exemplo n.º 28
0
    def columns(self):
        user = DatabaseColumn("Username",
                              SimpleColumn("user"),
                              format_fn=self.username)
        i_a = DatabaseColumn("Indicator A",
                             SumColumn("indicator_a"),
                             format_fn=unity)
        i_b = DatabaseColumn("Indicator B",
                             SumColumn("indicator_b"),
                             format_fn=unity)

        agg_c_d = AggregateColumn(
            "C/D",
            combine_indicator,
            [SumColumn("indicator_c"),
             SumColumn("indicator_d")],
            format_fn=unity)

        aggregate_cols = [i_a, i_b, agg_c_d]

        if self.group_by:
            return [user] + aggregate_cols
        else:
            return aggregate_cols
Exemplo n.º 29
0
 def columns(self):
     columns = self.get_columns_by_loc_level
     agg_columns = [
         DatabaseColumn('num_households',
                        SumColumn('cases_household'),
                        slug='num_households'),
         DatabaseColumn('num_people',
                        SumColumn('cases_person_all'),
                        slug='num_people'),
         DatabaseColumn('beneficiary_persons',
                        SumColumn(self.person_is_beneficiary_column),
                        slug='beneficiary_persons'),
         DatabaseColumn('person_has_aadhaar',
                        SumColumn(self.person_has_aadhaar_column),
                        slug='person_has_aadhaar'),
         AggregateColumn('num_people_with_aadhar',
                         percent, [
                             AliasColumn(self.person_has_aadhaar_column),
                             AliasColumn(self.person_is_beneficiary_column)
                         ],
                         slug='num_people_with_aadhar'),
         DatabaseColumn('num_pregnant_women',
                        SumColumn('cases_ccs_pregnant_all'),
                        slug='num_pregnant_women'),
         DatabaseColumn('num_pregnant_women_enrolled_for_services',
                        SumColumn('cases_ccs_pregnant'),
                        slug='num_pregnant_women_enrolled_for_services'),
         DatabaseColumn('num_lactating_women',
                        SumColumn('cases_ccs_lactating_all'),
                        slug='num_lactating_women'),
         DatabaseColumn('num_lactating_women_enrolled_for_services',
                        SumColumn('cases_ccs_lactating'),
                        slug='num_lactating_women_enrolled_for_services'),
         DatabaseColumn('num_children_0_6years',
                        SumColumn('cases_child_health_all'),
                        slug='num_children_0_6years'),
         DatabaseColumn('num_children_0_6years_enrolled_for_services',
                        SumColumn('cases_child_health'),
                        slug='num_children_0_6years_enrolled_for_services'),
         DatabaseColumn(
             'num_adolescent_girls_11yr14yr_v2',
             SumColumn('cases_person_adolescent_girls_11_14_all_v2'),
             slug='num_adolescent_girls_11yr14yr_v2'),
         DatabaseColumn(
             'num_adolescent_girls_15yr18yr',
             SumColumn('cases_person_adolescent_girls_15_18_all'),
             slug='num_adolescent_girls_15yr18yr'),
         DatabaseColumn(
             'num_adolescent_girls_11yr14yr_oos',
             SumColumn('cases_person_adolescent_girls_11_14_out_of_school'),
             slug='num_adolescent_girls_11yr14yr_oos'),
         DatabaseColumn(
             'num_adolescent_girls_15yr18yr_enrolled_for_services',
             SumColumn('cases_person_adolescent_girls_15_18'),
             slug='num_adolescent_girls_15yr18yr_enrolled_for_services')
     ]
     return columns + agg_columns
Exemplo n.º 30
0
 def columns(self):
     return [DatabaseColumn('date', SimpleColumn("date"))] +\
            [DatabaseColumn("", SumColumn(prop)) for prop in VHND_PROPERTIES]