def date(obj): """ Take a datetime or datetime-like object and return a formatted date. """ if not obj: return None try: return notifications.format_date(obj) except: # Not a datetime object return notifications.format_date(datetime.strptime(obj, "%Y-%m-%dT%H:%M:%S.%f"))
def date(obj):
""" Take a datetime or datetime-like object and return a formatted date. """
if not obj:
return None
try:
return notifications.format_date(obj)
except: # Not a datetime object
return notifications.format_date(
datetime.strptime(obj, "%Y-%m-%dT%H:%M:%S.%f"))
def prepare_request_fields(results):
if current_user.is_anonymous():
return map(lambda r: {
"id": r.id, \
"text": helpers.clean_text(r.text), \
"date_received": helpers.format_datetime(r.date_received or r.date_created, '%b %d, %Y at %-I:%M %p'), \
"department": r.department_name(), \
"status": r.status, \
# The following two attributes are defined as model methods,
# and not regular SQLAlchemy attributes.
"contact_name": r.point_person_name(), \
"solid_status": r.solid_status()
}, results)
else:
return map(lambda r: {
"id": r.id, \
"text": helpers.clean_text(r.text), \
"date_received": helpers.date(r.date_received or r.date_created), \
"department": r.department_name(), \
"requester": r.requester_name(), \
"due_date": format_date(r.due_date), \
"status": r.status, \
# The following two attributes are defined as model methods,
# and not regular SQLAlchemy attributes.
"contact_name": r.point_person_name(), \
"solid_status": r.solid_status()
}, results)
def prepare_request_fields(results):
if current_user.is_anonymous():
return map(lambda r: {
"id": r.id, \
"text": helpers.clean_text(r.text), \
"date_received": helpers.format_datetime(r.date_received or r.date_created, '%b %d, %Y at %-I:%M %p'), \
"department": r.department_name(), \
"status": r.status, \
# The following two attributes are defined as model methods,
# and not regular SQLAlchemy attributes.
"contact_name": r.point_person_name(), \
"solid_status": r.solid_status()
}, results)
else:
return map(lambda r: {
"id": r.id, \
"text": helpers.clean_text(r.text), \
"date_received": helpers.date(r.date_received or r.date_created), \
"department": r.department_name(), \
"requester": r.requester_name(), \
"due_date": format_date(r.due_date), \
"status": r.status, \
# The following two attributes are defined as model methods,
# and not regular SQLAlchemy attributes.
"contact_name": r.point_person_name(), \
"solid_status": r.solid_status()
}, results)
def fetch_requests():
"""
Ultra-custom API endpoint for serving up requests.
Supports limit, search, and page parameters and returns json with an object that
has a list of results in the 'objects' field.
"""
user_id = get_user_id()
# Initialize database query
results = db.session.query(Request)
# Filters!
results = filter_department(department_name = request.args.get('department'), results = results)
results = filter_search_term(search_input = request.args.get('search'), results = results)
results = filter_status(request.args.get('is_closed'), results = results)
# due soon should only be an option for open requests
results = filter_due_soon(due_soon = request.args.get('due_soon'), results = results)
# overdue should be mutually exclusive with due soon, and should only be an option for open requests
results = filter_overdue(overdue = request.args.get('overdue'), results = results)
# Filters for agency staff only:
if user_id:
results = filter_my_requests(my_requests = request.args.get('my_requests'), results = results, user_id = user_id)
results = filter_requester_name(requester_name = request.args.get('requester_name'), results = results)
# min_date_created = datetime.strptime('May 1 2014', '%b %d %Y')
# max_date_created = datetime.strptime('May 20 2014', '%b %d %Y')
min_date_created = None
max_date_created = None
if min_date_created and max_date_created:
results = results.filter(Request.date_created >= min_date_created).filter(Request.date_created <= max_date_created)
# min_due_date = datetime.strptime('May 15 2014', '%b %d %Y')
# max__due_date = datetime.strptime('May 20 2014', '%b %d %Y')
min_due_date = None
max_due_date = None
if min_due_date and max_due_date:
results = results.filter(Request.due_date >= min_due_date).filter(Request.due_date <= max_due_date)
# Sorting!
sort_by = request.args.get('sort_by')
if sort_by and sort_by != '':
ascending = request.args.get('ascending')
app.logger.info("\n\nAscending? %s" % ascending)
app.logger.info("\n\nSort by? %s" % sort_by)
if ascending == "true":
results = results.order_by((getattr(Request, sort_by)).asc())
else:
results = results.order_by((getattr(Request, sort_by)).desc())
results = results.order_by(Request.id.desc())
# Pagination!
page_number = request.args.get('page') or 1
page_number = int(page_number)
limit = request.args.get('limit') or 15
offset = limit * (page_number - 1)
# Execute query
more_results = False
num_results = results.count()
start_index = 0
end_index = 0
if num_results != 0:
start_index = (page_number - 1) * limit
if start_index == 0:
start_index = 1
if num_results > (limit * page_number):
more_results = True
end_index = start_index + 14
else:
end_index = num_results
results = results.limit(limit).offset(offset).all()
# TODO([email protected]): This map is pretty kludgy, we should be detecting columns and auto
# magically making them fields in the JSON objects we return.
results = map(lambda r: { "id": r.id, \
"text": r.text, \
"date_created": helpers.date(r.date_received or r.date_created), \
"department": r.department_name(), \
"requester": r.requester_name(), \
"due_date": format_date(r.due_date), \
# The following two attributes are defined as model methods,
# and not regular SQLAlchemy attributes.
"contact_name": r.point_person_name(), \
"solid_status": r.solid_status(), \
"status": r.status
}, results)
matches = {
"objects": results,
"num_results": num_results,
"more_results": more_results,
"start_index": start_index,
"end_index": end_index
}
response = anyjson.serialize(matches)
return Response(response, mimetype = "application/json")
def fetch_requests():
"""
Ultra-custom API endpoint for serving up requests.
Supports limit, search, and page parameters and returns json with an object that
has a list of results in the 'objects' field.
"""
user_id = get_user_id()
# Initialize database query
results = db.session.query(Request)
# Filter by department
department = request.args.get('department')
if department and department != "All departments":
app.logger.info("\n\nDepartment filter:%s." %department)
department = Department.query.filter_by(name = department).first()
if department:
results = results.filter(Request.department_id == department.id)
else:
results = results.filter(Request.department == request.args.get('department'))
# Filter by search term
search_input = request.args.get('search')
if search_input:
app.logger.info("\n\nSEARCH: %s" % search_input)
search_terms = search_input.strip().split(" ") # Get rid of leading and trailing spaces and generate a list of the search terms
num_terms = len(search_terms)
# Set up the query
search_query = ""
if num_terms > 1:
for x in range(num_terms - 1):
search_query = search_query + search_terms[x] + ' & '
search_query = search_query + search_terms[num_terms - 1] + ":*" # Catch substrings
results = results.filter("to_tsvector(text) @@ to_tsquery('%s')" % search_query)
# Filter based on current request status
is_closed = request.args.get('is_closed')
if is_closed != None:
# if is_closed.lower() == "true":
# results = results.filter(Request.status.ilike("%closed%"))
if is_closed.lower() == "false":
results = results.filter(~Request.status.ilike("%closed%"))
# Filters for agency staff only:
if user_id:
# Filter based on owner's requests
my_requests = request.args.get('my_requests')
if my_requests != None:
if my_requests.lower() == "true":
results = results.filter(Request.id == Owner.request_id).filter(Owner.user_id == user_id).filter(Owner.active == True)
# Filter based on requester name
requester_name = request.args.get('requester_name')
if requester_name and requester_name != "":
results = results.join(Subscriber, Request.subscribers).join(User).filter(func.lower(User.alias).like("%%%s%%" % requester_name.lower()))
# status = request.args.get('status')
# # Filter by status
# if status and status != "All statuses":
# results = results.filter(Request.solid_status() == status.lower())
sort_by = request.args.get('sort_by')
if sort_by and sort_by != '':
ascending = request.args.get('ascending')
app.logger.info("\n\nAscending? %s" % ascending)
app.logger.info("\n\nSort by? %s" % sort_by)
if ascending == "true":
results = results.order_by((getattr(Request, sort_by)).asc())
else:
results = results.order_by((getattr(Request, sort_by)).desc())
results = results.order_by(Request.id.desc())
page_number = request.args.get('page') or 1
page_number = int(page_number)
limit = request.args.get('limit') or 15
offset = limit * (page_number - 1)
# Execute query
more_results = False
num_results = results.count()
start_index = 0
end_index = 0
if num_results != 0:
start_index = (page_number - 1) * limit
if start_index == 0:
start_index = 1
if num_results > (limit * page_number):
more_results = True
end_index = start_index + 14
else:
end_index = num_results
results = results.limit(limit).offset(offset).all()
# results = results.limit(limit).offset(offset).all()
# TODO([email protected]): This map is pretty kludgy, we should be detecting columns and auto
# magically making them fields in the JSON objects we return.
results = map(lambda r: { "id": r.id, \
"text": r.text, \
"date_created": r.date_created.isoformat(), \
"department": r.department_name(), \
"requester": r.requester_name(), \
"due_date": format_date(r.due_date), \
# The following two attributes are defined as model methods,
# and not regular SQLAlchemy attributes.
"contact_name": r.point_person_name(), \
"solid_status": r.solid_status(), \
"status": r.status
}, results)
matches = {
"objects": results,
"num_results": num_results,
"more_results": more_results,
"start_index": start_index,
"end_index": end_index
}
response = anyjson.serialize(matches)
return Response(response, mimetype = "application/json")
def fetch_requests():
"""
Ultra-custom API endpoint for serving up requests.
Supports limit, search, and page parameters and returns json with an object that
has a list of results in the 'objects' field.
"""
user_id = get_user_id()
results = db.session.query(Request)
# Filters!
results = filter_department(department_name = request.args.get('department'), results = results)
results = filter_search_term(search_input = request.args.get('search_term'), results = results)
# Accumulate status filters
status_filters = []
if str(request.args.get('open')).lower() == 'true':
status_filters.append(Request.open)
if str(request.args.get('closed')).lower() == 'true':
status_filters.append(Request.closed)
date_format = '%m/%d/%Y'
min_request_date = request.args.get('min_request_date')
max_request_date = request.args.get('max_request_date')
if min_request_date and max_request_date:
min_request_date = datetime.strptime(min_request_date, date_format)
max_request_date = datetime.strptime(max_request_date, date_format)
results = results.filter(and_(Request.date_created >= min_request_date, Request.date_created <= max_request_date))
app.logger.info('Request Date Bounding. Min: {0}, Max: {1}'.format(min_request_date, max_request_date))
min_due_date = request.args.get('min_due_date')
max_due_date = request.args.get('max_due_date')
if min_due_date and max_due_date:
min_due_date = datetime.strptime(min_due_date, date_format)
max_due_date = datetime.strptime(max_due_date, date_format)
results = results.filter(and_(Request.due_date >= min_due_date, Request.due_date <= max_due_date))
app.logger.info('Due Date Bounding. Min: {0}, Max: {1}'.format(min_due_date, max_due_date))
# Filters for agency staff only:
if user_id:
if str(request.args.get('due_soon')).lower() == 'true':
status_filters.append(Request.due_soon)
if str(request.args.get('overdue')).lower() == 'true':
status_filters.append(Request.overdue)
# Where am I the Point of Contact?
if str(request.args.get('mine_as_poc')).lower() == 'true':
results = results.filter(Request.id == Owner.request_id) \
.filter(Owner.user_id == user_id) \
.filter(Owner.is_point_person == True)
# Where am I just a Helper?
if str(request.args.get('mine_as_helper')).lower() == 'true':
results = results.filter(Request.id == Owner.request_id) \
.filter(Owner.user_id == user_id) \
.filter(Owner.active == True)
# Filter based on requester name
requester_name = request.args.get('requester_name')
if requester_name and requester_name != "":
results = results.join(Subscriber, Request.subscribers).join(User).filter(func.lower(User.alias).like("%%%s%%" % requester_name.lower()))
# Apply the set of status filters to the query.
# Using 'or', they're non-exclusive!
results = results.filter(or_(*status_filters))
app.logger.info(status_filters)
app.logger.info(str(results.statement.compile(dialect=postgresql.dialect())))
sort_by = request.args.get('sort_column')
if sort_by and sort_by != '':
ascending = request.args.get('sort_direction')
app.logger.info("Sort Direction: %s" % ascending)
app.logger.info("Sort Column: %s" % sort_by)
if ascending == "asc":
results = results.order_by((getattr(Request, sort_by)).asc())
else:
results = results.order_by((getattr(Request, sort_by)).desc())
results = results.order_by(Request.id.desc())
page_number = int(request.args.get('page_number') or 1)
limit = int(request.args.get('limit') or 15)
offset = limit * (page_number - 1)
app.logger.info("Page Number: {0}, Limit: {1}, Offset: {2}".format(page_number, limit, offset))
# Execute query
more_results = False
num_results = results.count()
start_index = 0
end_index = 0
if num_results != 0:
start_index = (page_number - 1) * limit
if start_index == 0:
start_index = 1
if num_results > (limit * page_number):
more_results = True
end_index = start_index + 14
else:
end_index = num_results
results = results.limit(limit).offset(offset).all()
# TODO([email protected]): This map is pretty kludgy, we should be detecting columns and auto
# magically making them fields in the JSON objects we return.
results = map(lambda r: {
"id": r.id, \
"text": helpers.clean_text(r.text), \
"date_created": helpers.date(r.date_received or r.date_created), \
"department": r.department_name(), \
"requester": r.requester_name(), \
"due_date": format_date(r.due_date), \
"status": r.status, \
# The following two attributes are defined as model methods,
# and not regular SQLAlchemy attributes.
"contact_name": r.point_person_name(), \
"solid_status": r.solid_status()
}, results)
matches = {
"objects": results,
"num_results": num_results,
"more_results": more_results,
"start_index": start_index,
"end_index": end_index
}
response = anyjson.serialize(matches)
return Response(response, mimetype = "application/json")
