Hi,
I wanted a "sum" of a particular column being listed in the admin list
page. I looked it up and did it the following way. Is this the correct
way of doing it?
I modified the admin.py to do the calculation:
class CollectionAdmin(admin.ModelAdmin):
list_display = ('supplier', 'collected_date', 'tonnage',)
list_filter = ('collected_date',)
def changelist_view(self, request, extra_context=None):
from django.contrib.admin.views.main import ChangeList
from django.db.models import Sum
if extra_context is None:
extra_context = {}
mycl = ChangeList(request, self.model, list(self.list_display),
self.list_display_links, self.list_filter, self.date_hierarchy,
self.search_fields, self.list_select_related, self.list_per_page,
self.list_editable, self)
fieldsum = mycl.get_query_set().aggregate(Sum('tonnage'))
extra_context['tonnage__sum'] = fieldsum['tonnage__sum']
return super(CollectionAdmin, self).changelist_view(request,
extra_context=extra_context)
then i added the following line to change_list.html:
{% if tonnage__sum %}Total tonnage: {{ tonnage__sum }}{% endif
%}
Am I doing something bad in the changelist_view function above? Or is
it the right way to do this?
the reason I want to use the admin list is because I like the
filtering option, and I can then see directly the sum of the column
based on whatever is currently filtered.
Thanks.
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-us...@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
