def filters(self):
filters = [EQ('xmlns', 'xmlns')]
if 'age' in self.config and self.config['age']:
if len(self.config['age']) == 1:
filters.append(BETWEEN('age', 'age_start_0', 'age_end_0'))
else:
between_filters = []
for idx, age in enumerate(self.config['age']):
between_filters.append(BETWEEN('age', 'age_start_{}'.format(idx), 'age_end_{}'.format(idx)))
filters.append(OR(between_filters))
if 'district' in self.config and self.config['district']:
filters.append(IN('district', get_INFilter_bindparams('district', self.config['district'])))
if (
'visit_date_start' in self.config and self.config['visit_date_start'] and
'visit_date_end' in self.config and self.config['visit_date_end']
):
filters.append(BETWEEN('visit_date', 'visit_date_start', 'visit_date_end'))
if 'type_visit' in self.config and self.config['type_visit']:
filters.append(EQ('type_visit', 'type_visit'))
if 'activity_type' in self.config and self.config['activity_type']:
filters.append(EQ('activity_type', 'activity_type'))
if 'client_type' in self.config and self.config['client_type']:
filters.append(IN('client_type', get_INFilter_bindparams('client_type', self.config['client_type'])))
if 'user_id' in self.config and self.config['user_id']:
filters.append(IN('user_id', get_INFilter_bindparams('user_id', self.config['user_id'])))
if 'organization' in self.config and self.config['organization']:
filters.append(EQ('organization', 'organization'))
if 'want_hiv_test' in self.config and self.config['want_hiv_test']:
filters.append(EQ('want_hiv_test', 'want_hiv_test'))
return filters
def filters(self):
filters = []
if 'country' in self.config:
filters.append(
IN(
'country',
get_INFilter_bindparams('country',
self.__getattribute__("country"))))
if 'level_1' in self.config:
filters.append(
IN(
'level_1',
get_INFilter_bindparams('level_1',
self.__getattribute__("level_1"))))
if 'level_2' in self.config:
filters.append(
IN(
'level_2',
get_INFilter_bindparams('level_2',
self.__getattribute__("level_2"))))
if 'level_3' in self.config:
filters.append(
IN(
'level_3',
get_INFilter_bindparams('level_3',
self.__getattribute__("level_3"))))
if 'level_4' in self.config:
filters.append(
IN(
'level_4',
get_INFilter_bindparams('level_4',
self.__getattribute__("level_4"))))
return filters
def filters(self):
filters = [
EQ('xmlns', 'xmlns'),
IN('hiv_status', get_INFilter_bindparams('hiv_status', self.config['hiv_status']))
]
if (
'posttest_date_start' in self.config and self.config['posttest_date_start'] and
'posttest_date_end' in self.config and self.config['posttest_date_end']
):
filters.append(BETWEEN('posttest_date', 'posttest_date_start', 'posttest_date_end'))
if (
'hiv_test_date_start' in self.config and self.config['hiv_test_date_start'] and
'hiv_test_date_end' in self.config and self.config['hiv_test_date_end']
):
filters.append(BETWEEN('hiv_test_date', 'hiv_test_date_start', 'hiv_test_date_end'))
if 'age_range' in self.config and self.config['age_range']:
filters.append(IN('age_range', get_INFilter_bindparams('age_range', self.config['age_range'])))
if 'district' in self.config and self.config['district']:
filters.append(IN('district', get_INFilter_bindparams('district', self.config['district'])))
if 'client_type' in self.config and self.config['client_type']:
filters.append(IN('client_type', get_INFilter_bindparams('client_type', self.config['client_type'])))
if 'user_id' in self.config and self.config['user_id']:
filters.append(IN('user_id', get_INFilter_bindparams('user_id', self.config['user_id'])))
if 'organization' in self.config and self.config['organization']:
filters.append(EQ('organization', 'organization'))
return filters
def to_sql_filter(self):
if self._is_dyn_date():
return BasicBetweenFilter(
self.filter['field'],
get_INFilter_bindparams(self.filter['slug'],
['start_date', 'end_date']))
elif self._is_empty():
if self.filter.get('datatype') in [
DATA_TYPE_DATE, DATA_TYPE_DATETIME
]:
return ISNULLFilter(self.filter['field'])
else:
return ORFilter([
EQFilter(self.filter['field'], self.filter['slug']),
ISNULLFilter(self.filter['field']),
])
elif self._is_exists():
if self.filter.get('datatype') in [
DATA_TYPE_DATE, DATA_TYPE_DATETIME
]:
return NOTNULLFilter(self.filter['field'])
else:
# this resolves to != '', which also filters out null data in postgres
return NOTEQFilter(self.filter['field'], self.filter['slug'])
elif self._is_list():
return self._array_filter(
self.filter['field'],
get_INFilter_bindparams(self.filter['slug'],
self.value['operand']))
else:
return self._scalar_filter(self.filter['field'],
self.filter['slug'])
def filters(self):
filters = [EQ('xmlns', 'xmlns')]
if 'age' in self.config and self.config['age']:
if len(self.config['age']) == 1:
filters.append(BETWEEN('age', 'age_start_0', 'age_end_0'))
else:
between_filters = []
for idx, age in enumerate(self.config['age']):
between_filters.append(BETWEEN('age', 'age_start_{}'.format(idx), 'age_end_{}'.format(idx)))
filters.append(OR(between_filters))
if 'district' in self.config and self.config['district']:
filters.append(IN('district', get_INFilter_bindparams('district', self.config['district'])))
if (
'visit_date_start' in self.config and self.config['visit_date_start'] and
'visit_date_end' in self.config and self.config['visit_date_end']
):
filters.append(BETWEEN('visit_date', 'visit_date_start', 'visit_date_end'))
if 'type_visit' in self.config and self.config['type_visit']:
filters.append(EQ('type_visit', 'type_visit'))
if 'activity_type' in self.config and self.config['activity_type']:
filters.append(EQ('activity_type', 'activity_type'))
if 'client_type' in self.config and self.config['client_type']:
filters.append(
IN('client_type', get_INFilter_bindparams('client_type', self.config['client_type']))
)
if 'user_id' in self.config and self.config['user_id']:
filters.append(IN('user_id', get_INFilter_bindparams('user_id', self.config['user_id'])))
if 'organization' in self.config and self.config['organization']:
filters.append(
IN('organization', get_INFilter_bindparams('organization', self.config['organization'])))
if 'want_hiv_test' in self.config and self.config['want_hiv_test']:
filters.append(EQ('want_hiv_test', 'want_hiv_test'))
return filters
def filters(self):
filters = [EQ('xmlns', 'xmlns')]
if (
'posttest_date_start' in self.config and self.config['posttest_date_start'] and
'posttest_date_end' in self.config and self.config['posttest_date_end']
):
filters.append(BETWEEN('posttest_date', 'posttest_date_start', 'posttest_date_end'))
if (
'hiv_test_date_start' in self.config and self.config['hiv_test_date_start'] and
'hiv_test_date_end' in self.config and self.config['hiv_test_date_end']
):
filters.append(BETWEEN('hiv_test_date', 'hiv_test_date_start', 'hiv_test_date_end'))
if 'age_range' in self.config and self.config['age_range']:
filters.append(IN('age_range', get_INFilter_bindparams('age_range', self.config['age_range'])))
if 'district' in self.config and self.config['district']:
filters.append(IN('district', get_INFilter_bindparams('district', self.config['district'])))
if 'client_type' in self.config and self.config['client_type']:
filters.append(
IN('client_type', get_INFilter_bindparams('client_type', self.config['client_type']))
)
if 'user_id' in self.config and self.config['user_id']:
filters.append(IN('user_id', get_INFilter_bindparams('user_id', self.config['user_id'])))
if 'organization' in self.config and self.config['organization']:
filters.append(
IN('organization', get_INFilter_bindparams('organization', self.config['organization']))
)
return filters
def filters(self):
filters = [
EQ("domain", "domain"),
EQ("ppt_year", "ppt_year"),
AND([
NOTEQ("case_status", "duplicate"),
NOTEQ("case_status", "test")
])
]
for k, v in six.iteritems(self.geography_config):
if k in self.config and self.config[k]:
filters.append(
IN(k, get_INFilter_bindparams(k, self.config[k])))
if 'value_chain' in self.config and self.config['value_chain']:
filters.append(EQ("value_chain", "value_chain"))
if 'group_leadership' in self.config and self.config[
'group_leadership']:
filters.append(EQ('group_leadership', 'group_leadership'))
if 'cbt_name' in self.config and self.config['cbt_name']:
filters.append(
IN(
'owner_id',
get_INFilter_bindparams('cbt_name',
self.config['cbt_name'])))
if 'real_or_test' in self.config and self.config['real_or_test']:
filters.append(IEQ('real_or_test', 'real_or_test'))
for column_name in ['domains', 'practices', 'schedule']:
if column_name in self.config and self.config[
column_name] and self.config[column_name] != ('0', ):
filters.append(
IN(
column_name,
get_INFilter_bindparams(column_name,
self.config[column_name])))
return filters
def filters(self):
filters = []
if 'country' in self.config:
filters.append(IN('country', get_INFilter_bindparams('country', self.__getattribute__("country"))))
if 'level_1' in self.config:
filters.append(IN('level_1', get_INFilter_bindparams('level_1', self.__getattribute__("level_1"))))
if 'level_2' in self.config:
filters.append(IN('level_2', get_INFilter_bindparams('level_2', self.__getattribute__("level_2"))))
if 'level_3' in self.config:
filters.append(IN('level_3', get_INFilter_bindparams('level_3', self.__getattribute__("level_3"))))
if 'level_4' in self.config:
filters.append(IN('level_4', get_INFilter_bindparams('level_4', self.__getattribute__("level_4"))))
return filters
def filters(self):
filters = []
if 'district' in self.config and self.config['district']:
filters.append(IN('district', get_INFilter_bindparams('district', self.config['district'])))
if 'cbo' in self.config and self.config['cbo']:
filters.append(IN('cbo', get_INFilter_bindparams('cbo', self.config['cbo'])))
if 'clienttype' in self.config and self.config['clienttype']:
filters.append(IN('clienttype', get_INFilter_bindparams('clienttype', self.config['clienttype'])))
if 'userpl' in self.config and self.config['userpl']:
filters.append(IN('userpl', get_INFilter_bindparams('userpl', self.config['userpl'])))
if 'fiscal_year' in self.config and self.config['fiscal_year']:
filters.append(EQ('fiscal_year', 'fiscal_year'))
return filters
def filters(self):
filters = []
if 'district' in self.config and self.config['district']:
filters.append(IN('district', get_INFilter_bindparams('district', self.config['district'])))
if 'cbo' in self.config and self.config['cbo']:
filters.append(IN('cbo', get_INFilter_bindparams('cbo', self.config['cbo'])))
if 'clienttype' in self.config and self.config['clienttype']:
filters.append(IN('clienttype', get_INFilter_bindparams('clienttype', self.config['clienttype'])))
if 'userpl' in self.config and self.config['userpl']:
filters.append(IN('userpl', get_INFilter_bindparams('userpl', self.config['userpl'])))
if 'fiscal_year' in self.config and self.config['fiscal_year']:
filters.append(EQ('fiscal_year', 'fiscal_year'))
if 'organization' in self.config and self.config['organization']:
filters.append(EQ('organization', 'organization'))
return filters
def to_sql_filter(self):
if self._is_dyn_date():
return BasicBetweenFilter(
self.filter.field,
get_INFilter_bindparams(self.filter.slug, ['start_date', 'end_date'])
)
elif self._is_null():
return self._null_filter(self.filter.field)
elif self._is_list():
return self._array_filter(
self.filter.field,
get_INFilter_bindparams(self.filter.slug, self.value['operand'])
)
else:
return self._scalar_filter.sql(self.filter.field, self.filter.slug)
def to_sql_filter(self):
if self._is_dyn_date():
return BasicBetweenFilter(
self.filter.field,
get_INFilter_bindparams(self.filter.slug,
['start_date', 'end_date']))
elif self._is_null():
return self._null_filter(self.filter.field)
elif self._is_list():
return self._array_filter(
self.filter.field,
get_INFilter_bindparams(self.filter.slug,
self.value['operand']))
else:
return self._scalar_filter.sql(self.filter.field, self.filter.slug)
def filters(self):
filters = [EQ('xmlns', 'xmlns')]
if 'age' in self.config and self.config['age']:
filters.append(EQ('age', 'age'))
if 'district' in self.config and self.config['district']:
filters.append(EQ('district', 'district'))
if ('visit_date_start' in self.config
and self.config['visit_date_start']
and 'visit_date_end' in self.config
and self.config['visit_date_end']):
filters.append(
BETWEEN('visit_date', 'visit_date_start', 'visit_date_end'))
if 'type_visit' in self.config and self.config['type_visit']:
filters.append(EQ('type_visit', 'type_visit'))
if 'activity_type' in self.config and self.config['activity_type']:
filters.append(EQ('activity_type', 'activity_type'))
if 'client_type' in self.config and self.config['client_type']:
filters.append(EQ('client_type', 'client_type'))
if 'user_id' in self.config and self.config['user_id']:
filters.append(
IN('user_id',
get_INFilter_bindparams('user_id', self.config['user_id'])))
if 'organization' in self.config and self.config['organization']:
filters.append(EQ('organization', 'organization'))
return filters
def filters(self):
filters = [
EQ('xmlns', 'xmlns'),
NOT(EQ('date_last_vl_test', 'empty_date_last_vl_test'))
]
if 'hiv_status' in self.config and self.config['hiv_status']:
filters.append(EQ('hiv_status', 'hiv_status'))
if 'client_type' in self.config and self.config['client_type']:
filters.append(EQ('client_type', 'client_type'))
if 'age_range' in self.config and self.config['age_range']:
filters.append(EQ('age_range', 'age_range'))
if 'district' in self.config and self.config['district']:
filters.append(EQ('district', 'district'))
if ('date_last_vl_test_start' in self.config
and self.config['date_last_vl_test_start']
and 'date_last_vl_test_end' in self.config
and self.config['date_last_vl_test_end']):
filters.append(
BETWEEN('date_last_vl_test', 'date_last_vl_test_start',
'date_last_vl_test_end'))
if 'undetect_vl' in self.config and self.config['undetect_vl']:
filters.append(EQ('undetect_vl', 'undetect_vl'))
if 'user_id' in self.config and self.config['user_id']:
filters.append(
IN('user_id',
get_INFilter_bindparams('user_id', self.config['user_id'])))
if 'organization' in self.config and self.config['organization']:
filters.append(EQ('organization', 'organization'))
return filters
def filters(self):
filters = [
EQ('year', 'year'),
IN('owner_id', get_INFilter_bindparams('owner_id', self.config['users']))
]
location_filter(self.request, filters=filters)
return filters
def to_sql_filter(self):
if self.show_all:
return None
if self.is_null:
return ISNULLFilter(self.filter.field)
return INFilter(self.filter.field,
get_INFilter_bindparams(self.filter.slug, self.value))
def filters(self):
filters = [
EQ('year', 'year'),
IN('owner_id', get_INFilter_bindparams('owner_id', self.config['users']))
]
location_filter(self.request, filters=filters)
return filters
def filters(self):
filters = None
if 'enddate' not in self.config:
self.config['enddate'] = self.config['today']
self.config['stred'] = self.config['today']
if 'startdate' in self.config:
filters = [
AND([
LTE("date", "enddate"),
OR([
GTE('closed_on', "startdate"),
EQ('closed_on', 'empty')
])
])
]
else:
self.config['strsd'] = '0001-01-01'
filters = [LTE("date", "enddate")]
for k, v in six.iteritems(LOCATION_HIERARCHY):
if v['prop'] in self.config and self.config[v['prop']]:
filters.append(
IN(k, get_INFilter_bindparams(k, self.config[v['prop']])))
return filters
def filters(self):
filters = super(AggChildHealthMonthlyDataSource, self).filters
if not self.show_test:
filters.append(NOT(IN('state_id', get_INFilter_bindparams('excluded_states', self.excluded_states))))
if 'month' in self.config and self.config['month']:
filters.append(BETWEEN('month', 'two_before', 'month'))
return filters
def columns(self):
self.config['mother_ids'] = tuple(DeliveryMothersIds(config=self.config).data.keys()) + ('',)
columns = [
DatabaseColumn("Total children with with birthweight known",
CountUniqueColumn('doc_id', alias="total_birthweight_known",
filters=self.filters + [NOTEQ('weight_birth', 'empty')])),
DatabaseColumn("Total births",
CountUniqueColumn('doc_id',
filters=[AND([IN('mother_id', get_INFilter_bindparams('mother_ids', self.config['mother_ids'])),
OR([EQ('gender', 'female'), EQ('gender', 'male')])])],
alias='total_births'))]
columns.extend([
DatabaseColumn("Birthweight < 2.5 kg",
CountUniqueColumn('doc_id',
alias="total_birthweight_lt_25",
filters=self.filters + [AND([LT('weight_birth', 'weight_birth_25'), NOTEQ('weight_birth', 'empty')])]
)
),
DatabaseColumn("Birthweight >= 2.5 kg",
CountUniqueColumn('doc_id',
alias="total_birthweight_gte_25",
filters=self.filters + [AND([GTE('weight_birth', 'weight_birth_25'), NOTEQ('weight_birth', 'empty')])]
)
)
])
return columns
def columns(self):
self.config['mother_ids'] = tuple(DeliveryMothersIds(config=self.config).data.keys()) + ('',)
columns = [
DatabaseColumn("Total children with with birthweight known",
CountUniqueColumn('doc_id', alias="total_birthweight_known",
filters=self.filters + [NOTEQ('weight_birth', 'empty')])),
DatabaseColumn("Total births",
CountUniqueColumn('doc_id',
filters=[AND([IN('mother_id', get_INFilter_bindparams('mother_ids', self.config['mother_ids'])),
OR([EQ('gender', 'female'), EQ('gender', 'male')])])],
alias='total_births'))]
columns.extend([
DatabaseColumn("Birthweight < 2.5 kg",
CountUniqueColumn('doc_id',
alias="total_birthweight_lt_25",
filters=self.filters + [AND([LT('weight_birth', 'weight_birth_25'), NOTEQ('weight_birth', 'empty')])]
)
),
DatabaseColumn("Birthweight >= 2.5 kg",
CountUniqueColumn('doc_id',
alias="total_birthweight_gte_25",
filters=self.filters + [AND([GTE('weight_birth', 'weight_birth_25'), NOTEQ('weight_birth', 'empty')])]
)
)
])
return columns
def filters(self):
filters = [EQ("domain", "domain"), EQ("ppt_year", "ppt_year"), AND([NOTEQ("case_status", "duplicate"),
NOTEQ("case_status", "test")])]
for k, v in self.geography_config.iteritems():
if k in self.config and self.config[k]:
filters.append(IN(k, get_INFilter_bindparams(k, self.config[k])))
if 'value_chain' in self.config and self.config['value_chain']:
filters.append(EQ("value_chain", "value_chain"))
if 'group_leadership' in self.config and self.config['group_leadership']:
filters.append(EQ('group_leadership', 'group_leadership'))
if 'cbt_name' in self.config and self.config['cbt_name']:
filters.append(EQ('owner_id', 'cbt_name'))
for column_name in ['domains', 'practices', 'schedule']:
if column_name in self.config and self.config[column_name] and self.config[column_name] != ('0',):
filters.append(IN(column_name, get_INFilter_bindparams(column_name, self.config[column_name])))
return filters
def filters(self):
filters = super(AggChildHealthMonthlyDataSource, self).filters
if not self.show_test:
filters.append(NOT(IN('state_id', get_INFilter_bindparams('excluded_states', self.excluded_states))))
if 'month' in self.config and self.config['month']:
filters.append(BETWEEN('month', 'two_before', 'month'))
return filters
def columns(self):
self.config['mother_ids'] = tuple(
DeliveryMothersIds(config=self.config).data.keys()) + ('', )
return [
DatabaseColumn(
"Total births",
CountUniqueColumn(
'doc_id',
filters=[
AND([
IN(
'mother_id',
get_INFilter_bindparams(
'mother_ids', self.config['mother_ids'])),
OR([EQ('gender', 'female'),
EQ('gender', 'male')])
])
],
alias='total_births')),
DatabaseColumn(
"Newborn deaths (< 1 m)",
CountUniqueColumn(
'doc_id',
filters=self.filters + [
AND([
EQ('reason_for_child_closure', 'death'),
EQ('type_of_child_death', 'newborn_death')
])
],
alias='newborn_death')),
DatabaseColumn(
"Infant deaths (< 1 y)",
CountUniqueColumn(
'doc_id',
filters=self.filters + [
AND([
EQ('reason_for_child_closure', 'death'),
EQ('type_of_child_death', 'infant_death')
])
],
alias='infant_death')),
DatabaseColumn(
"Child deaths (2-5y)",
CountUniqueColumn(
'doc_id',
filters=self.filters + [
AND([
EQ('reason_for_child_closure', 'death'),
EQ('type_of_child_death', 'child_death')
])
],
alias='child_death')),
DatabaseColumn(
"Total deaths",
CountUniqueColumn('doc_id',
filters=self.filters +
[EQ('reason_for_child_closure', 'death')],
alias='total_deaths'))
]
def to_sql_filter(self):
if self.show_all:
return None
return INFilter(
self.filter.field,
get_INFilter_bindparams(self.filter.slug,
[None] if self.show_none else self.value))
def filters(self):
filters = [
EQ('aggregation_level', 'aggregation_level'),
EQ('month', 'previous_month')
]
if not self.show_test:
filters.append(NOT(IN('state_id', get_INFilter_bindparams('excluded_states', self.excluded_states))))
return filters
def to_sql_filter(self):
if self.show_all:
return None
if self.is_null:
return ISNULLFilter(self.filter.field)
return INFilter(
self.filter.field,
get_INFilter_bindparams(self.filter.slug, self.value)
)
def filters(self):
filters = [EQ('domain', 'domain')]
if 'is_active' in self.config and self.config['is_active']:
filters.append(EQ('is_active', 'is_active'))
if 'care_site' in self.config and self.config['care_site']:
filters.append(EQ('care_site', 'care_site'))
if 'owner_id' in self.config and self.config['owner_id']:
filters.append(IN('owner_id', get_INFilter_bindparams('owner_id', self.config['owner_id'])))
return filters
def filters(self):
self.config['mother_ids'] = tuple(
DeliveryMothersIds(config=self.config).data.keys()) + ('', )
return [
IN(
'mother_id',
get_INFilter_bindparams('mother_ids',
self.config['mother_ids']))
]
def filters(self):
filters = [EQ('xmlns', 'xmlns'), NOT(EQ('first_art_date', 'empty_first_art_date'))]
if 'hiv_status' in self.config and self.config['hiv_status']:
filters.append(IN('hiv_status', get_INFilter_bindparams('hiv_status', self.config['hiv_status'])))
if 'client_type' in self.config and self.config['client_type']:
filters.append(IN('client_type', get_INFilter_bindparams('client_type', self.config['client_type'])))
if 'age_range' in self.config and self.config['age_range']:
filters.append(IN('age_range', get_INFilter_bindparams('age_range', self.config['age_range'])))
if 'district' in self.config and self.config['district']:
filters.append(IN('district', get_INFilter_bindparams('district', self.config['district'])))
if (
'first_art_date_start' in self.config and self.config['first_art_date_start'] and
'first_art_date_end' in self.config and self.config['first_art_date_end']
):
filters.append(BETWEEN('first_art_date', 'first_art_date_start', 'first_art_date_end'))
if 'user_id' in self.config and self.config['user_id']:
filters.append(IN('user_id', get_INFilter_bindparams('user_id', self.config['user_id'])))
return filters
def filters(self):
for column_name in ['awc', 'gp', 'block']:
if self.config.get(column_name):
return [
IN(
column_name,
get_INFilter_bindparams(column_name,
self.config[column_name]))
]
return []
def to_sql_filter(self):
if self._is_dyn_date():
return BasicBetweenFilter(
self.filter['field'],
get_INFilter_bindparams(self.filter['slug'],
['start_date', 'end_date']))
elif self._is_empty():
return ORFilter([
EQFilter(self.filter['field'], self.filter['slug']),
ISNULLFilter(self.filter['field']),
])
elif self._is_list():
return self._array_filter(
self.filter['field'],
get_INFilter_bindparams(self.filter['slug'],
self.value['operand']))
else:
return self._scalar_filter(self.filter['field'],
self.filter['slug'])
def to_sql_filter(self):
if self.show_all:
return None
if self.is_null:
return ORFilter(
[ISNULLFilter(field) for field in self.filter.fields])
return ORFilter([
INFilter(field,
get_INFilter_bindparams(self.filter.slug, self.value))
for field in self.filter.fields
])
def filters(self):
filters = [
EQ('xmlns', 'xmlns'),
NOT(EQ('first_art_date', 'empty_first_art_date'))
]
if 'hiv_status' in self.config and self.config['hiv_status']:
filters.append(
IN(
'hiv_status',
get_INFilter_bindparams('hiv_status',
self.config['hiv_status'])))
if 'client_type' in self.config and self.config['client_type']:
filters.append(
IN(
'client_type',
get_INFilter_bindparams('client_type',
self.config['client_type'])))
if 'age_range' in self.config and self.config['age_range']:
filters.append(
IN(
'age_range',
get_INFilter_bindparams('age_range',
self.config['age_range'])))
if 'district' in self.config and self.config['district']:
filters.append(
IN(
'district',
get_INFilter_bindparams('district',
self.config['district'])))
if ('first_art_date_start' in self.config
and self.config['first_art_date_start']
and 'first_art_date_end' in self.config
and self.config['first_art_date_end']):
filters.append(
BETWEEN('first_art_date', 'first_art_date_start',
'first_art_date_end'))
if 'user_id' in self.config and self.config['user_id']:
filters.append(
IN('user_id',
get_INFilter_bindparams('user_id', self.config['user_id'])))
return filters
def filters(self):
filters = []
infilter_params = get_INFilter_bindparams('excluded_states', self.excluded_states)
if not self.show_test:
filters.append(NOT(IN('state_id', infilter_params)))
for key, value in six.iteritems(self.config):
if key == 'domain' or key in infilter_params or 'age' in key:
continue
filters.append(EQ(key, key))
return filters
def filters(self):
filters = []
infilter_params = get_INFilter_bindparams('excluded_states', self.excluded_states)
if not self.show_test:
filters.append(NOT(IN('state_id', infilter_params)))
for key, value in six.iteritems(self.config):
if key == 'domain' or key in infilter_params or 'age' in key:
continue
filters.append(EQ(key, key))
return filters
def filters(self):
filters = super(AggCCSRecordMonthlyDataSource, self).filters
if not self.show_test:
filters.append(
NOT(
IN(
'state_id',
get_INFilter_bindparams('excluded_states',
self.excluded_states))))
if 'month' in self.config and self.config['month']:
filters.append(EQ('month', 'month'))
return filters
def filters(self):
filters = [
BETWEEN('opened_on', 'start_date', 'end_date'),
]
locations_id = filter(lambda x: bool(x), self.config.locations_id)
if locations_id:
filters.append(
IN('person_owner_id',
get_INFilter_bindparams('locations_id', locations_id)))
return filters
def to_sql_filter(self):
if self.show_all:
return None
if self.is_null:
return ISNULLFilter(self.filter['field'])
in_filter = INFilter(
self.filter['field'],
get_INFilter_bindparams(self.filter['slug'], self.value))
if self._ancestor_filter:
return ANDFilter([self._ancestor_filter.sql_filter(), in_filter])
else:
return in_filter
def filters(self):
filters = [
AND([GTE('opened_on', 'start_date'), LT('opened_on', 'end_date')]),
]
locations_id = filter(lambda x: bool(x), self.config.locations_id)
if locations_id:
filters.append(
IN('person_owner_id', get_INFilter_bindparams('locations_id', locations_id))
)
return filters
def to_sql_filter(self):
if self.show_all:
return None
in_filter = INFilter(
self.filter['field'],
get_INFilter_bindparams(self.filter['slug'],
[None] if self.show_none else self.value))
if self._ancestor_filter:
return ANDFilter([self._ancestor_filter.sql_filter(), in_filter])
else:
return in_filter
def filters(self):
filters = []
if self.config['task_responsible']:
filters.append(EQ('task_responsible', 'task_responsible'))
if self.config['referenced_id']:
filters.append(EQ('referenced_id', 'referenced_id'))
if self.config['closed']:
filters.append(EQ('closed', 'closed'))
or_filter = []
if self.config['owner_ids']:
or_filter.append(IN('owner_id', get_INFilter_bindparams('owner_ids', self.config['owner_ids'])))
if or_filter:
or_filter.append(EQ('user_id', 'user_id'))
filters.append(OR(filters=or_filter))
return filters
def filters(self):
filters = []
if self.config['task_responsible']:
filters.append(EQ('task_responsible', 'task_responsible'))
if self.config['referenced_id']:
filters.append(EQ('referenced_id', 'referenced_id'))
if self.config['closed']:
filters.append(EQ('closed', 'closed'))
or_filter = []
if self.config['owner_ids']:
or_filter.append(IN('owner_id', get_INFilter_bindparams('owner_ids', self.config['owner_ids'])))
if or_filter:
or_filter.append(EQ('user_id', 'user_id'))
filters.append(OR(filters=or_filter))
return filters
def filters(self):
filters = []
if 'start_date' in self.config and 'end_date' in self.config:
filters.append(
BETWEEN("date_of_data_collection", "start_date", "end_date"))
if 'country' in self.config:
filters.append(
IN(
'country',
get_INFilter_bindparams('country',
self.__getattribute__("country"))))
if 'level_1' in self.config:
filters.append(
IN(
'level_1',
get_INFilter_bindparams('level_1',
self.__getattribute__("level_1"))))
if 'level_2' in self.config:
filters.append(
IN(
'level_2',
get_INFilter_bindparams('level_2',
self.__getattribute__("level_2"))))
if 'level_3' in self.config:
filters.append(
IN(
'level_3',
get_INFilter_bindparams('level_3',
self.__getattribute__("level_3"))))
if 'level_4' in self.config:
filters.append(
IN(
'level_4',
get_INFilter_bindparams('level_4',
self.__getattribute__("level_4"))))
return filters
def filters(self):
filters = None
if 'enddate' not in self.config:
self.config['enddate'] = self.config['today']
self.config['stred'] = self.config['today']
if 'startdate' in self.config:
filters = [AND([LTE("date", "enddate"), OR([GTE('closed_on', "startdate"), EQ('closed_on', 'empty')])])]
else:
self.config['strsd'] = '0001-01-01'
filters = [LTE("date", "enddate")]
for k, v in LOCATION_HIERARCHY.iteritems():
if v['prop'] in self.config and self.config[v['prop']]:
filters.append(IN(k, get_INFilter_bindparams(k, self.config[v['prop']])))
return filters
def columns(self):
self.config['mother_ids'] = tuple(DeliveryMothersIds(config=self.config).data.keys()) + ('',)
return [
DatabaseColumn("Total births",
CountUniqueColumn('doc_id',
filters=[AND([IN('mother_id', get_INFilter_bindparams('mother_ids', self.config['mother_ids'])),
OR([EQ('gender', 'female'), EQ('gender', 'male')])])],
alias='total_births')),
DatabaseColumn("Newborn deaths (< 1 m)",
CountUniqueColumn('doc_id', filters=self.filters + [AND(
[EQ('reason_for_child_closure', 'death'),
EQ('type_of_child_death', 'newborn_death')])], alias='newborn_death')),
DatabaseColumn("Infant deaths (< 1 y)",
CountUniqueColumn('doc_id', filters=self.filters + [AND(
[EQ('reason_for_child_closure', 'death'),
EQ('type_of_child_death', 'infant_death')])], alias='infant_death')),
DatabaseColumn("Child deaths (2-5y)",
CountUniqueColumn('doc_id', filters=self.filters + [AND(
[EQ('reason_for_child_closure', 'death'),
EQ('type_of_child_death', 'child_death')])], alias='child_death')),
DatabaseColumn("Total deaths",
CountUniqueColumn('doc_id', filters=self.filters + [EQ('reason_for_child_closure',
'death')], alias='total_deaths'))
]
def filters(self):
for column_name in ["awc", "gp", "block"]:
if self.config.get(column_name):
return [IN(column_name, get_INFilter_bindparams(column_name, self.config[column_name]))]
return []
def filters(self):
if not self.group_by_district:
users = tuple([user.user_id for user in self.users])
return[IN("user_id", get_INFilter_bindparams("users", users))]
return []
def filters(self):
return [
IN('awc_id', get_INFilter_bindparams('awc_id', self.awcs)),
EQ('month', 'month')
]
def _locations_filter(archived_locations):
return NOT(IN('location_id', get_INFilter_bindparams('archived_locations', archived_locations)))
def filters(self):
self.config['mother_ids'] = tuple(DeliveryMothersIds(config=self.config).data.keys()) + ('',)
return [IN('mother_id', get_INFilter_bindparams('mother_id', self.config['mother_ids']))]
def filters(self):
for column_name in ['awc', 'gp', 'block']:
if self.config.get(column_name):
return [IN(column_name, get_INFilter_bindparams(column_name, self.config[column_name]))]
return []
