def get_json_for_paging(request):
user = request.user
display_filter = None
start_index = None
length = None
try:
profile = FilterProfile.objects.get(user = user)
except ObjectDoesNotExist:
#make the new case profile
profile = FilterProfile()
profile.user = user
profile.filter = Filter.objects.all()[0]
profile.last_filter = Filter.objects.all()[0] #this is a nasty hack, as we're assuming id 1 is the reflexive one
if len(request.GET.items()) > 0:
for item in request.GET.items():
if item[0] == 'filter':
filter_id = item[1]
if item[0] == 'start':
start_index = item[1]
if item[0] == 'iDisplayLength':
length = item[1]
try:
display_filter = Filter.objects.get(id=filter_id)
except:
pass
else:
display_filter = profile.last_filter
profile.last_login = datetime.utcnow()
profile.last_login_from = request.META['REMOTE_ADDR']
profile.last_filter = display_filter
profile.save()
filter = display_filter
# add pagination later...
display_filter = display_filter.get_filter_queryset()
# add conditional to only work if display and start not null
# try:
# display_filter = display_filter.get_filter_queryset()[start_index:start_index + length]
# except:
# display_filter = display_filter.get_filter_queryset()[start_index:]
#build json_string with information from data
json_string = "{ \"aaData\": ["
#adding user
for case in display_filter:
careteam_url = reverse('view-careteam', kwargs={"careteam_id": case.careteam_set.get().id})
json_string += "["
json_string += "\"<a href = '%s'>%s</a>\"," % (careteam_url, case.careteam_set.get().patient.user.title())
for col in filter.gridpreference.get_display_columns:
table_entry = case_column_plain(case, col.name)
if len(table_entry) > 45:
table_entry = table_entry[0:45] + "..."
# terribly hardcoded...quick fix to add links
if (col.name == "description"):
json_string += "\"<a href = 'case/%s'>%s</a>\"," % (case.id, table_entry)
else:
json_string += "\"%s\"," % table_entry
json_string += "],"
#terribly inefficient, but quick fix to allow sorting of links....
# json_string += " ], \"aoColumns\": [ null,"
# for col in filter.gridpreference.display_columns.all():
# json_string += "{\"sType\": \"html\"},"
#closing json_string
json_string += "] }"
return HttpResponse(json_string)
def list_cases(request, template_name="carehqapp/list_cases.html"):
context = {}
user = request.user
########################
#get the logged in user's filter profile, if the profile doesn't exist, make a new FilterProfile and arbitrarily use the first case filter
# if it does exist, load up the last filter used, OR whatever the query string is saying it is.
display_filter = None
request.session['is_listing'] = 'something'
request.session['is_whatever'] = 'askldjqwoerwqer'
request.session.modified=True
try:
profile = FilterProfile.objects.get(user = user)
except ObjectDoesNotExist:
#make the new case profile
profile = FilterProfile()
profile.user = user
profile.filter = Filter.objects.all()[0]
profile.last_filter = Filter.objects.all()[0] #this is a nasty hack, as we're assuming id 1 is the reflexive one
display_filter = profile.last_filter
group_by_col = None
if 'filter' in request.GET:
filter_id = request.GET['filter']
display_filter = Filter.objects.get(id=filter_id)
else:
display_filter = profile.last_filter
group_by_col = request.GET.get('groupBy', None)
profile.last_login = datetime.utcnow()
profile.last_login_from = request.META['REMOTE_ADDR']
profile.last_filter = display_filter
profile.save()
split_headings = False
qset = display_filter.get_filter_queryset()
qset = filter_cases_for_user(qset, user)
if group_by_col and group_by_col.count('_date') > 0:
split_headings = False
qset.order_by(group_by_col)
elif group_by_col == 'description':
split_headings = False
qset.order_by('description')
elif group_by_col == 'assigned_to' or group_by_col == 'closed_by' or group_by_col == 'opened_by'\
or group_by_col == 'last_edit_by' or group_by_col == 'resolved_by' or group_by_col == 'last_event_by':
model_class = User
split_headings = True
elif group_by_col == 'patient':
model_class = Patient
split_headings = True
elif group_by_col == 'status':
model_class = Status
split_headings = True
elif group_by_col == 'priority':
model_class = Priority
split_headings = True
elif group_by_col == 'category':
model_class = Category
split_headings = True
qset_dict = {}
#If we are splitting the queryset up by the sorting category,
#we need to iterate over the distinct objects in the model class
if split_headings:
heading_keys = model_class.objects.all().distinct() #This is a bit inefficient as it does it over all the
for key in heading_keys:
#http://www.nomadjourney.com/2009/04/dynamic-django-queries-with-kwargs/
#dynamic django queries baby
if group_by_col == 'patient':
subq = qset.filter(careteam=key)
else:
kwargs = {str(group_by_col +"__id__endswith"): str(key.id), }
subq = qset.filter(**kwargs)
if subq.count() > 0:
qset_dict[key] = subq
else:
qset_dict[display_filter.description] = qset
context['qset_dict'] = qset_dict
context['profile'] = profile
context['filter'] = display_filter
#context['filter_cases'] = display_filter.get_filter_queryset()
context['gridpreference'] = context['filter'].gridpreference
############################
filter_columns = display_filter.gridpreference.get_display_columns.values_list('column__name', flat=True)
context['columns'] = display_filter.gridpreference.get_display_columns
return render_to_response(template_name, context, context_instance=RequestContext(request))
