akvo.rsr.models.model_querysets.project module

class akvo.rsr.models.model_querysets.project.ProjectQuerySet(model=None, query=None, using=None, hints=None)[source]

Bases: AkvoTreeQuerySet

all_partners()[source]
all_updates()[source]

Return ProjectUpdates for self, newest first.

budget_sum()[source]

aggregates the budgets of all the projects in the QS n.b. non-chainable, doesn’t return a QS

countries()[source]

Returns a Country queryset of the countries of these projects

extending_partners()[source]
field_partners()[source]
funding_partners()[source]
funds_needed_sum()[source]

aggregates the funds of all the projects in the QS n.b. non-chainable, doesn’t return a QS

funds_sum()[source]

aggregates the funds of all the projects in the QS n.b. non-chainable, doesn’t return a QS

get_actual_sanitation_calc()[source]

how many have gotten improved sanitation

get_actual_water_calc()[source]

how many have gotten improved water

get_largest_value_sum(benchmarkname, cats=None)[source]
get_planned_sanitation_calc()[source]

how many will get improved sanitation

get_planned_water_calc()[source]

how many will get improved water

has_location()[source]
keywords()[source]
of_partner(organisation)[source]

return projects that have organisation as partner

of_partners(organisations)[source]

Return projects that have one of the organisations as partner.

NOTE: If any of the organisations has one or more ProjectHierarchies, include all the projects in the hierarchies.

paying_partners()[source]
private()[source]
public()[source]
published()[source]
publishingstatuses()[source]
sectors()[source]
sponsor_partners()[source]
status_active()[source]
status_archived()[source]
status_cancelled()[source]
status_complete()[source]
status_none()[source]
status_not_archived()[source]
status_not_cancelled()[source]
status_not_complete()[source]
status_not_post_complete()[source]
status_onhold()[source]
status_post_complete()[source]
support_partners()[source]
unpublished()[source]