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))
