search

googaa / django-reporting

Automatically exported from code.google.com/p/django-reporting
0 stars 0 forks source link

allow queryset.extra #16

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
attached is small patch to allow SQL instead of aggregate function.
example:

SQL_SUM_TON = '''(select SUM(transport_ton * transport_km * transport_price)
 from ... where ...)'''

annotate = ( # Annotation fields (tupples of field, func / SQL, title)
  ('delivery_by__effective_date', Min, u"От"),
  ('delivery_by__effective_date_', lambda
v:Max('delivery_by__effective_date'), u"До"),
  ('delivery_by__transport_ton', Sum, u"Общо [т]"),
  ('transport_v', SQL_SUM_TON, u"Обща стойност"),
)

Original issue reported on code.google.com by niki.spa...@gmail.com on 25 Feb 2010 at 8:49

Attachments: