Beispiel #1
0
 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')),
     ]
Beispiel #3
0
 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", )),
     ]
Beispiel #4
0
 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'))
     ]
Beispiel #5
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
Beispiel #6
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
Beispiel #7
0
 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'))
     ]
Beispiel #8
0
 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)
Beispiel #9
0
 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)
Beispiel #10
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(_(u"PPS Avec Données Soumises"),
                                      CountUniqueAndSumCustomColumn('location_id'),
                                      format_fn=lambda x: {'sort_key': long(x), 'html': long(x)})
        )
        return columns
Beispiel #11
0
    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
Beispiel #13
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"),
            CountColumn('total_stock_total'),
            format_fn=lambda x: 1 if x > 0 else 0
        ))
        return columns
Beispiel #14
0
 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'),
     ]
Beispiel #15
0
 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'))
     ]
Beispiel #16
0
 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')
     ]
Beispiel #18
0
 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
     ]
Beispiel #19
0
 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"))
     ]
Beispiel #20
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'))
     ]
Beispiel #21
0
    def columns(self):

        return [
            DatabaseColumn('Product Name', SimpleColumn('product_name')),
            DatabaseColumn("Commandes", SumColumn('commandes_total')),
            DatabaseColumn("Recu", SumColumn('recus_total'))
        ]
Beispiel #22
0
 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
Beispiel #23
0
    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
Beispiel #24
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(_("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
Beispiel #25
0
    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
        ]
Beispiel #26
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'))
        ]
Beispiel #27
0
 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)
     ]
Beispiel #28
0
 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"))
     ]
Beispiel #29
0
 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")),
     ]
Beispiel #30
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