def columns(self): return [ DatabaseColumn('Product Name', SimpleColumn('product_name')), DatabaseColumn("Commandes", SumColumn('commandes_total')), DatabaseColumn("Recu", SumColumn('recus_total')) ]
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')) ]
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')), ]
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')) ]
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
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')) ]
def columns(self): return [ DatabaseColumn("User ID", SimpleColumn("user_id")), DatabaseColumn("Women registered", SumColumn("women_registered_total")), DatabaseColumn("Children registered", SumColumn("children_registered_total")) ]
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")), ]
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')), ]
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
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')]), ]
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')) ]
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')]), ]
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
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')), ]
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) ]
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): 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
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
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
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
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")), ]
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
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, )
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') ]), ]
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')) ]
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
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
def columns(self): return [DatabaseColumn('date', SimpleColumn("date"))] +\ [DatabaseColumn("", SumColumn(prop)) for prop in VHND_PROPERTIES]