def get(self, code): """ Returns procurements for code prefix. """ return paginate( page_args, Procurement.query.filter( Procurement.budget_code.like(code + '%')).order_by( Procurement.order_date))
def get(self, code, year): """ Returns changes for code and year """ return paginate( page_args, Changes.query.filter(Changes.budget_code == code, Changes.year == year).order_by( Changes.year.desc(), Changes.date.desc()))
def get(self, kind, code): """ Returns supports for kind and code prefix. """ return paginate( page_args, Support.query.filter(Support.kind == kind, Support.code.like(code + '%'), func.length(Support.code) == len(code) + 2))
def get(self, leading_item, req_code, year): """ Returns changes by leading item, required code and year """ return paginate( page_args, Changes.query.filter(Changes.leading_item == leading_item, Changes.req_code == req_code, Changes.year == year).order_by( Changes.date.desc()))
def get(self, code, year): """ Returns supports for code prefix and year. """ return paginate( page_args, Support.query.filter(Support.code.like(code + '%'), Support.year == year).order_by( Support.recipient, Support.kind, Support.year))
def get(self, days): """ Returns exemptions since the last given 'days'. """ first_date = datetime.datetime.now() - datetime.timedelta(days=days + 1) return paginate(page_args, Exemption.query.filter( Exemption.last_update_date >= first_date).order_by(Exemption.last_update_date.desc))
def get(self): """ Returns exemption last updated. """ return paginate(page_args, Exemption.query.order_by(Exemption.last_update_date.desc))
def get(self, from_date, to_date): """ Returns exemptions updated between 'from' and 'to'. """ return paginate(page_args, Exemption.query.filter( Exemption.last_update_date >= from_date & Exemption.last_update_date <= to_date))
def get(self, code): """ Returns exemptions for budget code. """ return paginate(page_args, Exemption.query.filter(Exemption.budget_code == code))
def get(self, entity_id): """ Returns procurements for entity. """ return paginate( page_args, Procurement.query.filter(Procurement.entity_id == entity_id))
def get(self, code): """ Returns procurements for code. """ return paginate( page_args, Procurement.query.filter(Procurement.budget_code == code))
def get(self, kind): """ Returns supports for kind. """ return paginate(page_args, Support.query.filter(Support.kind == kind))
def get(self, entity_id): """ Returns supports for entity. """ return paginate( page_args, Support.query.filter(Support.entity_id == entity_id).order_by( Support.year.desc))
def get(self, code): """ Returns supports for code prefix. """ return paginate( page_args, Support.query.filter(Support.code.like(code + '%')).order_by( Support.year))