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
