def columns(self): return [ DatabaseColumn('awc_id', SimpleColumn('awc_id')), DatabaseColumn('vhsnd_date_past_month', SimpleColumn('vhsnd_date_past_month')), DatabaseColumn('local_leader', SimpleColumn('local_leader')), DatabaseColumn('aww_present', SimpleColumn('aww_present')) ]
def columns(self): return [ DatabaseColumn('Doc Id', SimpleColumn('doc_id')), DatabaseColumn('Form name', SimpleColumn('form_name')), DatabaseColumn('Submitted By', SimpleColumn('username')), DatabaseColumn('Completed', SimpleColumn('date')), ]
def columns(self): return [ DatabaseColumn(_("Total number of ASHAs under the Facilitator"), SimpleColumn("doc_id", )), DatabaseColumn(_("ASHA name"), SimpleColumn("hv_asha_name", )), DatabaseColumn(_("Date of last for submission"), SimpleColumn("completed_on", )), ]
def columns(self): return [ DatabaseColumn('block', SimpleColumn('block')), DatabaseColumn('district', SimpleColumn('district')), DatabaseColumn('first_name', SimpleColumn('first_name')), DatabaseColumn('last_name', SimpleColumn('last_name')), DatabaseColumn('user_id', SimpleColumn('doc_id')) ]
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): 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): return [ DatabaseColumn('country', SimpleColumn('country')), DatabaseColumn('level_1', SimpleColumn('level_1')), DatabaseColumn('level_2', SimpleColumn('level_2')), DatabaseColumn('level_3', SimpleColumn('level_3')), DatabaseColumn('level_4', SimpleColumn('level_4')), DatabaseColumn('total_sprayers', MaxColumn('total_sprayers')) ]
def location_column(self): if self.group_by_district: return DatabaseColumn("Location", SimpleColumn('group_id'), format_fn=self.groupname, sort_type=None) else: return DatabaseColumn("Location", SimpleColumn('user_id'), format_fn=self.username, sort_type=None)
def headers(self): blocks = self.get_blocks_for_district() headers = [DataTablesColumnGroup('')] headers.extend([DataTablesColumnGroup(block) for block in self.get_blocks_for_district()]) columns = [DatabaseColumn(_("Percentage of ASHAs functional on " "(Number of functional ASHAs/total number of ASHAs) x 100"), SimpleColumn(''), header_group=headers[0])] for i, block in enumerate(blocks): columns.append(DatabaseColumn(_('%s of ASHAs') % '%', SimpleColumn(block), header_group=headers[i + 1])) columns.append(DatabaseColumn(_('Grade of Block'), SimpleColumn(block), header_group=headers[i + 1])) return DataTablesHeader(*headers)
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(_(u"PPS Avec Données Soumises"), CountUniqueAndSumCustomColumn('location_id'), format_fn=lambda x: {'sort_key': long(x), 'html': long(x)}) ) return columns
def columns(self): def format_pnc_count(*args): return sum([1 if arg == 'yes' else 0 for arg in args]) return [ DatabaseColumn("PP 1", SimpleColumn('pp_1_done', alias='pp_1_done')), DatabaseColumn("PP 2", SimpleColumn('pp_2_done', alias='pp_2_done')), DatabaseColumn("PP 3", SimpleColumn('pp_3_done', alias='pp_3_done')), DatabaseColumn("PP 4", SimpleColumn('pp_4_done', alias='pp_4_done')), AggregateColumn('PNC Count', format_pnc_count, [AliasColumn('pp_1_done'), AliasColumn('pp_2_done'), AliasColumn('pp_3_done'), AliasColumn('pp_4_done')])]
def get_columns_by_loc_level(self): columns = [ DatabaseColumn('State', SimpleColumn('state_name')) ] if self.loc_level > 1: columns.append(DatabaseColumn('District', SimpleColumn('district_name'), slug='district_name')) if self.loc_level > 2: columns.append(DatabaseColumn('Block', SimpleColumn('block_name'), slug='block_name')) if self.loc_level > 3: columns.append(DatabaseColumn('Supervisor', SimpleColumn('supervisor_name'), slug='supervisor_name')) if self.loc_level > 4: columns.append(DatabaseColumn('AWC', SimpleColumn('awc_name'), slug='awc_name')) 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( _("Stock total"), CountColumn('total_stock_total'), format_fn=lambda x: 1 if x > 0 else 0 )) return columns
def get_columns_by_loc_level(self): return [ DatabaseColumn('State', SimpleColumn('state_name')), DatabaseColumn('District', SimpleColumn('district_name'), slug='district_name'), DatabaseColumn('Block', SimpleColumn('block_name'), slug='block_name'), DatabaseColumn('Sector Name', SimpleColumn('supervisor_name'), slug='supervisor_name'), DatabaseColumn('Lady Supervisor User ID', SimpleColumn('supervisor_site_code'), slug='supervisor_site_code'), DatabaseColumn('Total No. of AWCs visited', SimpleColumn('awc_visits'), slug='awc_visits'), DatabaseColumn('Total No. of Beneficiaries Visited', SimpleColumn('beneficiary_vists'), slug='beneficiary_vists'), DatabaseColumn('Total No. of VHSNDs observed', SimpleColumn('vhnd_observed'), slug='vhnd_observed'), ]
def columns(self): return [ DatabaseColumn('awc_id', SimpleColumn('awc_id')), DatabaseColumn('where_housed', SimpleColumn('where_housed')), DatabaseColumn('provided_building', SimpleColumn('provided_building')), DatabaseColumn('other_building', SimpleColumn('other_building')), DatabaseColumn('kitchen', SimpleColumn('kitchen')), DatabaseColumn('toilet_facility', SimpleColumn('toilet_facility')), DatabaseColumn('type_toilet', SimpleColumn('type_toilet')), DatabaseColumn('preschool_kit_available', SimpleColumn('preschool_kit_available')), DatabaseColumn('preschool_kit_usable', SimpleColumn('preschool_kit_usable')) ]
def columns(self): return [ DatabaseColumn('doc_id', SimpleColumn('doc_id')), DatabaseColumn('awc', SimpleColumn('awc')), DatabaseColumn('awc_code', SimpleColumn('awc_code')), DatabaseColumn('bank_name', SimpleColumn('bank_name')), DatabaseColumn('ifs_code', SimpleColumn('ifs_code')), DatabaseColumn('account_number', SimpleColumn('account_number')), DatabaseColumn('gp', SimpleColumn('gp')), DatabaseColumn('block', SimpleColumn('block')), DatabaseColumn('village', SimpleColumn('village')) ]
def get_columns(self, filters): return [ DatabaseColumn('month', SimpleColumn('month')), AggregateColumn( 'Percent of pregnant women who are anemic in given month', lambda x, y, z: ((x or 0) + (y or 0)) * 100 / float(z or 1), [ SumColumn('anemic_moderate'), SumColumn('anemic_severe'), SumColumn('pregnant', alias='pregnant') ], slug='severe_anemic'), AggregateColumn( 'Percent tetanus complete', percent_num, [SumColumn('tetanus_complete'), AliasColumn('pregnant')], slug='tetanus_complete'), AggregateColumn( 'Percent women ANC 1 recieved by deliveryy', percent_num, [ SumColumn('anc1_received_at_delivery'), SumColumn('delivered_in_month', alias='delivered_in_month') ], slug='anc_1'), AggregateColumn('Percent women ANC 2 received by delivery', percent_num, [ SumColumn('anc2_received_at_delivery'), AliasColumn('delivered_in_month') ], slug='anc_2'), AggregateColumn('Percent women ANC 3 received by delivery', percent_num, [ SumColumn('anc3_received_at_delivery'), AliasColumn('delivered_in_month') ], slug='anc_3'), AggregateColumn('Percent women ANC 4 received by delivery', percent_num, [ SumColumn('anc4_received_at_delivery'), AliasColumn('delivered_in_month') ], slug='anc_4'), AggregateColumn('Percent women Resting during pregnancy', percent_num, [ SumColumn('resting_during_pregnancy'), AliasColumn('pregnant') ], slug='resting'), AggregateColumn('Percent eating extra meal during pregnancy', percent_num, [SumColumn('extra_meal'), AliasColumn('pregnant')], slug='extra_meal'), AggregateColumn( 'Percent trimester 3 women Counselled on immediate EBF during home visit', percent_num, [SumColumn('counsel_immediate_bf'), SumColumn('trimester_3')], slug='trimester') ]
def columns(self): return [ DatabaseColumn(header, SimpleColumn(header)) for header in set(self.headers_in_order + self.obligatory_table_names) if header in self.ucr_column_ids ]
def columns(self): return [ DatabaseColumn(_("Location ID"), SimpleColumn("location_id")), DatabaseColumn(_("Eligible clients due to registration"), SumColumn("status_eligible_due_to_registration")), DatabaseColumn(_("Eligible clients due to 4th visit"), SumColumn("status_eligible_due_to_4th_visit")), DatabaseColumn(_("Eligible clients due to delivery"), SumColumn("status_eligible_due_to_delivery")), DatabaseColumn(_("Eligible clients due to immunization or PNC visit"), SumColumn("status_eligible_due_to_immun_or_pnc_visit")), DatabaseColumn(_("Reviewed clients due to registration"), SumColumn("status_reviewed_due_to_registration")), DatabaseColumn(_("Reviewed clients due to 4th visit"), SumColumn("status_reviewed_due_to_4th_visit")), DatabaseColumn(_("Reviewed clients due to delivery"), SumColumn("status_reviewed_due_to_delivery")), DatabaseColumn(_("Reviewed clients due to immunization or PNC visit"), SumColumn("status_reviewed_due_to_immun_or_pnc_visit")), DatabaseColumn(_("Approved clients due to registration"), SumColumn("status_approved_due_to_registration")), DatabaseColumn(_("Approved clients due to 4th visit"), SumColumn("status_approved_due_to_4th_visit")), DatabaseColumn(_("Approved clients due to delivery"), SumColumn("status_approved_due_to_delivery")), DatabaseColumn(_("Approved clients due to immunization or PNC visit"), SumColumn("status_approved_due_to_immun_or_pnc_visit")), DatabaseColumn(_("Paid clients due to registration"), SumColumn("status_paid_due_to_registration")), DatabaseColumn(_("Paid clients due to 4th visit"), SumColumn("status_paid_due_to_4th_visit")), DatabaseColumn(_("Paid clients due to delivery"), SumColumn("status_paid_due_to_delivery")), DatabaseColumn(_("Paid clients due to immunization or PNC visit"), SumColumn("status_paid_due_to_immun_or_pnc_visit")), DatabaseColumn(_("Rejected clients due to incorrect phone number"), SumColumn("status_rejected_due_to_incorrect_phone_number")), DatabaseColumn(_("Rejected clients due to double entry"), SumColumn("status_rejected_due_to_double_entry")), DatabaseColumn(_("Rejected clients due to other errors"), SumColumn("status_rejected_due_to_other_errors")) ]
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): return [ DatabaseColumn('Product Name', SimpleColumn('product_name')), DatabaseColumn("Commandes", SumColumn('commandes_total')), DatabaseColumn("Recu", SumColumn('recus_total')) ]
def columns(self): registered_column = "registered_total_for_region" if 'district_id' in self.config: registered_column = 'registered_total_for_district' columns = [ DatabaseColumn( "No de PPS (number of PPS registered in that region)", MaxColumn(registered_column, alias='registered')), DatabaseColumn("No de PPS planifie (number of PPS planned)", MaxColumn('planned_total')), DatabaseColumn( "No de PPS avec livrasion cet mois (number of PPS visited this month)", CountUniqueColumn( 'location_id', alias="visited", )), AggregateColumn( "Taux de couverture (coverage ratio)", self.percent_fn, [AliasColumn('registered'), AliasColumn("visited")]), DatabaseColumn( "No de PPS avec donnees soumises (number of PPS which submitted data)", CountUniqueColumn( 'location_id', alias="submitted", )), AggregateColumn("Exhaustivite des donnees", self.percent_fn, [AliasColumn('visited'), AliasColumn('submitted')]), ] if self.config['startdate'].month != self.config['enddate'].month: columns.insert(0, DatabaseColumn('Mois', SimpleColumn('month'))) self.show_total = True return columns
def columns(self): div = lambda x, y: "%0.3f" % (float(x) / (float(y) or 1.0)) 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(_("Quantite produits entreposes au PPS"), MeanColumn('quantity_total', alias="quantity"), format_fn=self.format_data_and_cast_to_float)) columns.append(DatabaseColumn(_("CMM"), MeanColumn('cmm_total', alias="cmm"), format_fn=self.format_data_and_cast_to_float)) columns.append(AggregateColumn(_("Nombre mois stock disponible et utilisable"), div, [AliasColumn('quantity'), AliasColumn('cmm')])) 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(_("Consommation reelle"), MeanColumn('actual_consumption_total', alias="consumption"), format_fn=self.format_data_and_cast_to_float)) columns.append(DatabaseColumn(_("Stock apres derniere livraison"), MeanColumn('stock_total', alias="stock"), format_fn=self.format_data_and_cast_to_float)) columns.append(AggregateColumn(_("Taux consommation"), self.percent_fn, [AliasColumn('stock'), AliasColumn('consumption')])) return columns
def columns(self): fields = {c.slug for c in self._db_columns} return self._db_columns + [ DatabaseColumn('', SimpleColumn(field)) for field in self._defer_fields if field not in fields ]
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): 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(_("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( _("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): 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