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):
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):
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):
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):
cols = [
self.location_column,
dynamic_date_aggregation(DatabaseColumn(
"Resolved at CVSU",
SumColumn('resolution_resolved_at_cvsu_total',
filters=self.filters + [BETWEEN('mediation_provided_date', 'startdate', 'enddate')])
), date_column='mediation_provided_date'),
dynamic_date_aggregation(DatabaseColumn(
"Referred to TA",
SumColumn('resolution_referred_ta_total',
filters=self.filters + [
BETWEEN('date_reported_provided_mediated', 'startdate', 'enddate')])
), date_column='date_reported_provided_mediated'),
dynamic_date_aggregation(DatabaseColumn(
"Referred to TA Court",
SumColumn('resolution_referral_ta_court_total',
filters=self.filters + [
BETWEEN('date_reported_provided_mediated', 'startdate', 'enddate')])
), date_column='date_reported_provided_mediated'),
dynamic_date_aggregation(DatabaseColumn(
"Referred to Police",
SumColumn('resolution_referral_police_total',
filters=self.filters + [
BETWEEN('date_reported_provided_mediated', 'startdate', 'enddate')])
), date_column='date_reported_provided_mediated'),
dynamic_date_aggregation(DatabaseColumn(
"Referred to Social Welfare",
SumColumn('resolution_referral_social_welfare_total',
filters=self.filters + [
BETWEEN('date_reported_provided_mediated', 'startdate', 'enddate')])
), date_column='date_reported_provided_mediated'),
dynamic_date_aggregation(DatabaseColumn(
"Referred to NGO",
SumColumn('resolution_referral_ngo_total',
filters=self.filters + [
BETWEEN('date_reported_provided_mediated', 'startdate', 'enddate')])
), date_column='date_reported_provided_mediated'),
dynamic_date_aggregation(DatabaseColumn(
"Referred to Other",
SumColumn('resolution_referral_other_total',
filters=self.filters + [
BETWEEN('date_reported_provided_mediated', 'startdate', 'enddate')])
), date_column='date_reported_provided_mediated'),
dynamic_date_aggregation(DatabaseColumn(
"Unresolved",
SumColumn('resolution_unresolved_total',
filters=self.filters + [BETWEEN('mediation_provided_date', 'startdate', 'enddate')])
), date_column='mediation_provided_date'),
dynamic_date_aggregation(DatabaseColumn(
"Case Withdrawn",
SumColumn('resolution_case_withdrawn_total',
filters=self.filters + [BETWEEN('mediation_provided_date', 'startdate', 'enddate')])
), date_column='mediation_provided_date'),
dynamic_date_aggregation(DatabaseColumn(
"Other",
SumColumn('resolution_other_total',
filters=self.filters + [
BETWEEN('date_reported_provided_mediated', 'startdate', 'enddate')])
), date_column='mediation_provided_date'),
dynamic_date_aggregation(DatabaseColumn(
"Total",
SumColumn('resolution_total_total',
filters=self.filters + [
BETWEEN('date_reported_provided_mediated', 'startdate', 'enddate')])
), date_column='date_reported_provided_mediated'),
]
cols[0] = self.date_column
return cols
def columns(self):
cols = [
self.location_column,
dynamic_date_aggregation(DatabaseColumn(
"Resolved at CVSU",
SumColumn('resolution_resolved_at_cvsu_total',
filters=self.filters + [
BETWEEN('mediation_provided_date', 'startdate',
'enddate')
])),
date_column='mediation_provided_date'),
dynamic_date_aggregation(
DatabaseColumn(
"Referred to TA",
SumColumn('resolution_referred_ta_total',
filters=self.filters + [
BETWEEN('date_reported_provided_mediated',
'startdate', 'enddate')
])),
date_column='date_reported_provided_mediated'),
dynamic_date_aggregation(
DatabaseColumn(
"Referred to TA Court",
SumColumn('resolution_referral_ta_court_total',
filters=self.filters + [
BETWEEN('date_reported_provided_mediated',
'startdate', 'enddate')
])),
date_column='date_reported_provided_mediated'),
dynamic_date_aggregation(
DatabaseColumn(
"Referred to Police",
SumColumn('resolution_referral_police_total',
filters=self.filters + [
BETWEEN('date_reported_provided_mediated',
'startdate', 'enddate')
])),
date_column='date_reported_provided_mediated'),
dynamic_date_aggregation(
DatabaseColumn(
"Referred to Social Welfare",
SumColumn('resolution_referral_social_welfare_total',
filters=self.filters + [
BETWEEN('date_reported_provided_mediated',
'startdate', 'enddate')
])),
date_column='date_reported_provided_mediated'),
dynamic_date_aggregation(
DatabaseColumn(
"Referred to NGO",
SumColumn('resolution_referral_ngo_total',
filters=self.filters + [
BETWEEN('date_reported_provided_mediated',
'startdate', 'enddate')
])),
date_column='date_reported_provided_mediated'),
dynamic_date_aggregation(
DatabaseColumn(
"Referred to Other",
SumColumn('resolution_referral_other_total',
filters=self.filters + [
BETWEEN('date_reported_provided_mediated',
'startdate', 'enddate')
])),
date_column='date_reported_provided_mediated'),
dynamic_date_aggregation(DatabaseColumn(
"Unresolved",
SumColumn('resolution_unresolved_total',
filters=self.filters + [
BETWEEN('mediation_provided_date', 'startdate',
'enddate')
])),
date_column='mediation_provided_date'),
dynamic_date_aggregation(DatabaseColumn(
"Case Withdrawn",
SumColumn('resolution_case_withdrawn_total',
filters=self.filters + [
BETWEEN('mediation_provided_date', 'startdate',
'enddate')
])),
date_column='mediation_provided_date'),
dynamic_date_aggregation(DatabaseColumn(
"Other",
SumColumn('resolution_other_total',
filters=self.filters + [
BETWEEN('date_reported_provided_mediated',
'startdate', 'enddate')
])),
date_column='mediation_provided_date'),
dynamic_date_aggregation(
DatabaseColumn(
"Total",
SumColumn('resolution_total_total',
filters=self.filters + [
BETWEEN('date_reported_provided_mediated',
'startdate', 'enddate')
])),
date_column='date_reported_provided_mediated'),
]
cols[0] = self.date_column
return cols
