class ActivityAggregationFilter(ActivityFilter):
"""
Activity aggregation filter class
"""
sector_vocabulary = CommaSeparatedStickyCharFilter(
name='sector__vocabulary__code',
lookup_expr='in',
)
class TransactionAggregationFilter(TransactionFilter):
"""
Transaction aggregation filter class
"""
recipient_country = CommaSeparatedStickyCharFilter(
name='transactionrecipientcountry__country__code',
lookup_expr='in',
)
recipient_region = CommaSeparatedStickyCharFilter(
name='transactionrecipientregion__region__code',
lookup_expr='in',
)
sector = CommaSeparatedStickyCharFilter(
name='transactionsector__sector__code',
lookup_expr='in',
)
sector_vocabulary = CommaSeparatedStickyCharFilter(
name='transactionsector__sector__vocabulary__code',
lookup_expr='in',
)
transaction_recipient_country = CommaSeparatedStickyCharFilter(
name='transactionrecipientcountry__country__code',
lookup_expr='in',
)
transaction_recipient_region = CommaSeparatedStickyCharFilter(
name='transactionrecipientregion__region__code',
lookup_expr='in',
)
transaction_sector = CommaSeparatedStickyCharFilter(
name='transactionsector__sector__code',
lookup_expr='in',
)
policy_marker = CommaSeparatedStickyCharFilter(
name='activity__activitypolicymarker__code',
lookup_expr='in',
)
policy_marker_significance = CommaSeparatedStickyCharFilter(
name='activity__activitypolicymarker__significance',
lookup_expr='in',
)
class TransactionAggregationFilter(TransactionFilter):
"""
Transaction aggregation filter class
"""
recipient_country = CommaSeparatedStickyCharFilter(
field_name='transactionrecipientcountry__country__code',
lookup_expr='in',
)
recipient_region = CommaSeparatedStickyCharFilter(
field_name='transactionrecipientregion__region__code',
lookup_expr='in',
)
sector = CommaSeparatedStickyCharFilter(
field_name='transactionsector__sector__code',
lookup_expr='in',
)
sector_vocabulary = CommaSeparatedStickyCharFilter(
field_name='transactionsector__sector__vocabulary__code',
lookup_expr='in',
)
transaction_recipient_country = CommaSeparatedStickyCharFilter(
field_name='transactionrecipientcountry__country__code',
lookup_expr='in',
)
transaction_recipient_region = CommaSeparatedStickyCharFilter(
field_name='transactionrecipientregion__region__code',
lookup_expr='in',
)
transaction_sector = CommaSeparatedStickyCharFilter(
field_name='transactionsector__sector__code',
lookup_expr='in',
)
policy_marker = CommaSeparatedStickyCharFilter(
field_name='activity__activitypolicymarker__code',
lookup_expr='in',
)
policy_marker_significance = CommaSeparatedStickyCharFilter(
field_name='activity__activitypolicymarker__significance',
lookup_expr='in',
)
#
# Aggregated Budget values filters
#
total_budget_lte = NumberFilter(
lookup_expr='lte',
field_name='activity__activity_aggregation__budget_value')
total_budget_gte = NumberFilter(
lookup_expr='gte',
field_name='activity__activity_aggregation__budget_value')
class ResultFilter(TogetherFilterSet):
activity_id = CommaSeparatedCharFilter(
field_name='activity__iati_identifier', lookup_expr='in')
result_title = CommaSeparatedStickyCharFilter(
field_name='resulttitle__primary_name',
lookup_expr='in',
)
indicator_title = CommaSeparatedStickyCharFilter(
field_name='resultindicator__resultindicatortitle__primary_name',
lookup_expr='in',
)
indicator_period_actual_null = StickyBooleanFilter(
lookup_expr='isnull',
field_name='resultindicator__resultindicatorperiod__actual')
result_indicator_period_end_year = StickyCharFilter(
field_name='resultindicator__resultindicatorperiod__period_end',
lookup_expr='year')
# default filters
activity_scope = CommaSeparatedCharFilter(
field_name='activity__scope__code',
lookup_expr='in',
)
planned_start_date_lte = DateFilter(lookup_expr='lte',
field_name='activity__planned_start')
planned_start_date_gte = DateFilter(lookup_expr='gte',
field_name='activity__planned_start')
actual_start_date_lte = DateFilter(lookup_expr='lte',
field_name='activity__actual_start')
actual_start_date_gte = DateFilter(lookup_expr='gte',
field_name='activity__actual_start')
planned_end_date_lte = DateFilter(lookup_expr='lte',
field_name='activity__planned_end')
planned_end_date_gte = DateFilter(lookup_expr='gte',
field_name='activity__planned_end')
actual_end_date_lte = DateFilter(lookup_expr='lte',
field_name='activity__actual_end')
actual_end_date_gte = DateFilter(lookup_expr='gte',
field_name='activity__actual_end')
end_date_lte = DateFilter(lookup_expr='lte',
field_name='activity__end_date')
end_date_gte = DateFilter(lookup_expr='gte',
field_name='activity__end_date')
start_date_lte = DateFilter(lookup_expr='lte',
field_name='activity__start_date')
start_date_gte = DateFilter(lookup_expr='gte',
field_name='activity__start_date')
end_date_isnull = BooleanFilter(field_name='activity__end_date__isnull')
start_date_isnull = BooleanFilter(
field_name='activity__start_date__isnull')
activity_status = CommaSeparatedCharFilter(
lookup_expr='in',
field_name='activity__activity_status',
)
document_link_category = ToManyFilter(
main_fk='activity',
qs=DocumentLink,
fk='activity',
lookup_expr='in',
field_name='categories__code',
)
hierarchy = CommaSeparatedCharFilter(
lookup_expr='in',
field_name='activity__hierarchy',
)
collaboration_type = CommaSeparatedCharFilter(
lookup_expr='in',
field_name='activity__collaboration_type',
)
default_flow_type = CommaSeparatedCharFilter(
lookup_expr='in',
field_name='activity__default_flow_type',
)
default_aid_type = CommaSeparatedCharFilter(
lookup_expr='in',
field_name='activity__default_aid_type',
)
default_finance_type = CommaSeparatedCharFilter(
lookup_expr='in',
field_name='activity__default_finance_type',
)
default_tied_status = CommaSeparatedCharFilter(
lookup_expr='in',
field_name='activity__default_tied_status',
)
budget_period_start = DateFilter(
lookup_expr='gte',
field_name='activity__budget__period_start',
)
budget_period_end = DateFilter(lookup_expr='lte',
field_name='activity__budget__period_end')
recipient_country = ToManyFilter(
main_fk='activity',
qs=ActivityRecipientCountry,
lookup_expr='in',
field_name='country__code',
fk='activity',
)
recipient_region = ToManyFilter(
main_fk='activity',
qs=ActivityRecipientRegion,
lookup_expr='in',
field_name='region__code',
fk='activity',
)
sector = ToManyFilter(
main_fk='activity',
qs=ActivitySector,
lookup_expr='in',
field_name='sector__code',
fk='activity',
)
sector_vocabulary = ToManyFilter(
main_fk='activity',
qs=ActivitySector,
lookup_expr='in',
field_name='sector__vocabulary__code',
fk='activity',
)
sector_category = ToManyFilter(
main_fk='activity',
qs=ActivitySector,
lookup_expr='in',
field_name='sector__category__code',
fk='activity',
)
participating_organisation = ToManyFilter(
main_fk='activity',
qs=ActivityParticipatingOrganisation,
lookup_expr='in',
field_name='normalized_ref',
fk='activity',
)
participating_organisation_name = ToManyFilter(
main_fk='activity',
qs=ActivityParticipatingOrganisation,
lookup_expr='in',
field_name='primary_name',
fk='activity',
)
participating_organisation_role = ToManyFilter(
main_fk='activity',
qs=ActivityParticipatingOrganisation,
lookup_expr='in',
field_name='role__code',
fk='activity',
)
participating_organisation_type = ToManyFilter(
main_fk='activity',
qs=ActivityParticipatingOrganisation,
lookup_expr='in',
field_name='type__code',
fk='activity',
)
reporting_organisation_identifier = ToManyFilter(
main_fk='activity',
qs=ActivityReportingOrganisation,
lookup_expr='in',
field_name='organisation__organisation_identifier',
fk='activity',
)
related_activity_id = ToManyFilter(
main_fk='activity',
qs=RelatedActivity,
fk='current_activity',
lookup_expr='in',
field_name='ref_activity__iati_identifier',
)
total_incoming_funds_lte = NumberFilter(
lookup_expr='lte',
field_name='activity__activity_aggregation__incoming_funds_value')
total_incoming_funds_gte = NumberFilter(
lookup_expr='gte',
field_name='activity__activity_aggregation__incoming_funds_value')
class Meta:
model = Result
fields = '__all__'