def list_requests(request, begin=day_to_str(datetime.date.today()), end=None):
"""
List requests opened in a given date range
"""
requests = Request.objects \
.filter(requested_datetime__range=date_range(begin,end))
data = [item for item in requests.values()]
return data
def list_requests(request, begin=day_to_str(datetime.date.today()), end=None):
"""
List requests opened in a given date range
"""
requests = Request.objects \
.filter(requested_datetime__range=date_range(begin,end))
data = [item for item in requests.values()]
return data
def ticket_day(request, begin=day_to_str(datetime.date.today()), end=None):
"""
Get service_name stats for a range of dates.
"""
if end == None:
key = begin
else:
key = "%s - %s" % (begin, end)
# Request and group by service_name.
requests = Request.objects \
.filter(requested_datetime__range=date_range(begin, end)) \
.values('service_name').annotate(count=Count('service_name')) \
.order_by('-count')
data = {key: [item for item in requests]}
return data
def ticket_day(request, begin=day_to_str(datetime.date.today()), end=None):
"""
Get service_name stats for a range of dates.
"""
if end == None:
key = begin
else:
key = "%s - %s" % (begin, end)
# Request and group by service_name.
requests = Request.objects \
.filter(requested_datetime__range=date_range(begin, end)) \
.values('service_name').annotate(count=Count('service_name')) \
.order_by('-count')
data = {key: [item for item in requests]}
return data
def ticket_days(request, ticket_status="open", start=None, end=None,
num_days=None):
'''Returns JSON with the number of opened/closed tickets in a specified
date range'''
# If no start or end variables are passed, do the past 30 days. If one is
# passed, check if num_days and do the past num_days. If num_days isn't
# passed, just do one day. Else, do the range.
if start is None and end is None:
num_days = int(num_days) if num_days is not None else 29
end = datetime.date.today()
start = end - datetime.timedelta(days=num_days)
elif end is not None and num_days is not None:
num_days = int(num_days) - 1
end = str_to_day(end)
start = end - datetime.timedelta(days=num_days)
elif end is not None and start is None:
end = str_to_day(end)
start = end
else:
start = str_to_day(start)
end = str_to_day(end)
if ticket_status == "open":
request = Request.objects.filter(status="Open") \
.filter(requested_datetime__range=date_range(day_to_str(start),
day_to_str(end)))
stats = qsstats.QuerySetStats(request, 'requested_datetime')
elif ticket_status == "closed":
request = Request.objects.filter(status="Closed")
stats = qsstats.QuerySetStats(request, 'updated_datetime') \
.filter(requested_datetime__range=date_range(day_to_str(start),
day_to_str(end)))
elif ticket_status == "both":
request_opened = Request.objects.filter(status="Open") \
.filter(requested_datetime__range=date_range(day_to_str(start),
day_to_str(end)))
stats_opened = qsstats.QuerySetStats(request_opened,
'requested_datetime')
request_closed = Request.objects.filter(status="Closed") \
.filter(requested_datetime__range=date_range(day_to_str(start),
day_to_str(end)))
stats_closed = qsstats.QuerySetStats(request_closed,
'updated_datetime')
data = []
try:
raw_data = stats.time_series(start, end)
for row in raw_data:
temp_data = {'date': int(time.mktime(row[0].timetuple())), 'count': row[1]}
data.append(temp_data)
except:
opened_data = stats_opened.time_series(start, end)
closed_data = stats_closed.time_series(start, end)
for i in range(len(opened_data)):
temp_data = {
'date': int(time.mktime(opened_data[i][0].timetuple())),
'open_count': opened_data[i][1],
'closed_count': closed_data[i][1],
}
data.append(temp_data)
return data
def ticket_days(request,
ticket_status="open",
start=None,
end=None,
num_days=None):
'''Returns JSON with the number of opened/closed tickets in a specified
date range'''
# If no start or end variables are passed, do the past 30 days. If one is
# passed, check if num_days and do the past num_days. If num_days isn't
# passed, just do one day. Else, do the range.
if start is None and end is None:
num_days = int(num_days) if num_days is not None else 29
end = datetime.date.today()
start = end - datetime.timedelta(days=num_days)
elif end is not None and num_days is not None:
num_days = int(num_days) - 1
end = str_to_day(end)
start = end - datetime.timedelta(days=num_days)
elif end is not None and start is None:
end = str_to_day(end)
start = end
else:
start = str_to_day(start)
end = str_to_day(end)
if ticket_status == "open":
request = Request.objects.filter(status="Open") \
.filter(requested_datetime__range=date_range(day_to_str(start),
day_to_str(end)))
stats = qsstats.QuerySetStats(request, 'requested_datetime')
elif ticket_status == "closed":
request = Request.objects.filter(status="Closed")
stats = qsstats.QuerySetStats(request, 'updated_datetime') \
.filter(requested_datetime__range=date_range(day_to_str(start),
day_to_str(end)))
elif ticket_status == "both":
request_opened = Request.objects.filter(status="Open") \
.filter(requested_datetime__range=date_range(day_to_str(start),
day_to_str(end)))
stats_opened = qsstats.QuerySetStats(request_opened,
'requested_datetime')
request_closed = Request.objects.filter(status="Closed") \
.filter(requested_datetime__range=date_range(day_to_str(start),
day_to_str(end)))
stats_closed = qsstats.QuerySetStats(request_closed,
'updated_datetime')
data = []
try:
raw_data = stats.time_series(start, end)
for row in raw_data:
temp_data = {
'date': int(time.mktime(row[0].timetuple())),
'count': row[1]
}
data.append(temp_data)
except:
opened_data = stats_opened.time_series(start, end)
closed_data = stats_closed.time_series(start, end)
for i in range(len(opened_data)):
temp_data = {
'date': int(time.mktime(opened_data[i][0].timetuple())),
'open_count': opened_data[i][1],
'closed_count': closed_data[i][1],
}
data.append(temp_data)
return data