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): return [ IN('awc_id', get_INFilter_bindparams('awc_id', self.awcs)), EQ('month', 'month') ]
def filters(self): self.config['mother_ids'] = tuple( DeliveryMothersIds(config=self.config).data.keys()) + ('', ) return [IN('mother_id', 'mother_ids')]
def _locations_filter(archived_locations): return NOT( IN('location_id', get_INFilter_bindparams('archived_locations', archived_locations)))
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): 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): 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): filters = super(NombreData, self).filters if 'archived_locations' in self.config: filters.append(NOT(IN('location_id', 'archived_locations'))) return filters
def filters(self): filter = super(TauxDeRuptures, self).filters filter.append("total_stock_total = 0") if 'archived_locations' in self.config: filter.append(NOT(IN('location_id', 'archived_locations'))) return filter