Changeset ed4ccc7 for remit

Timestamp:

Mar 24, 2010, 5:13:25 AM (15 years ago)

Author:

Alex Dehnert <adehnert@…>

Branches:

master, client

Children:

3f1e074

Parents:

86817cf

git-author:

Alex Dehnert <adehnert@…> (03/24/10 05:13:25)

git-committer:

Alex Dehnert <adehnert@…> (03/24/10 05:13:25)

Message:

Add basic reporting (Trac #3)

Location:

remit

Files:

• finance_core/urls.py (modified) (1 diff)
• finance_core/views.py (modified) (1 diff)
• media/style/style.css (modified) (1 diff)
• remit_templates/base.html (modified) (1 diff)
• remit_templates/finance_core/reporting.html (added)

remit/finance_core/urls.py

@@ -4 +4 @@
 urlpatterns = patterns('',
     (r'^display_accounts', finance_core.views.display_tree),
+    url(r'reporting/', finance_core.views.reporting, name='reporting', ),
 )

remit/finance_core/views.py

@@ -1 +1 @@
 from django.http import HttpResponse
 import finance_core.models
+from django.contrib.auth.decorators import user_passes_test
+from django.shortcuts import render_to_response, get_object_or_404
+from django.template import RequestContext
+from django.http import Http404, HttpResponseRedirect
+from django.db.models import Q, Sum
+from decimal import Decimal
 
 def display_tree(request):
     root = finance_core.models.BudgetArea.get_by_path(['Accounts'])
     return HttpResponse(root.dump_to_html())
+
+def reporting(request):
+    line_items = finance_core.models.LineItem.objects.all()
+    term_name = 'All'
+    if 'term' in request.REQUEST:
+        term_obj = get_object_or_404(finance_core.models.BudgetTerm, slug=request.REQUEST['term'])
+        term_name = term_obj.name
+        line_items = line_items.filter(budget_term=term_obj)
+    if 'area' in request.REQUEST:
+        base_area_obj = get_object_or_404(finance_core.models.BudgetArea, pk=request.REQUEST['area'])
+    else:
+        base_area_obj = finance_core.models.BudgetArea.get_by_path(['Accounts'])
+    line_items = line_items.filter(budget_area__in=base_area_obj.get_descendants())
+    base_area_depth = base_area_obj.depth
+    print base_area_obj
+
+    primary_name = 'Budget Areas'
+    primary_axis = [
+        (area.indented_name(base_area_depth), Q(budget_area=area), ) for area in base_area_obj.get_descendants()
+    ]
+    secondary_name = 'Layers'
+    secondary_axis = [ (finance_core.models.layer_name(layer), Q(layer=finance_core.models.layer_num(layer)), ) for layer in finance_core.models.layers ]
+
+    primary_axis.append(('Total', Q(), ))
+    secondary_axis.append(('Total', Q(), ))
+
+    primary_labels = [ primary[0] for primary in primary_axis ]
+    secondary_labels = [ secondary[0] for secondary in secondary_axis ]
+
+    zero = Decimal('0.00')
+    def total_amount(queryset):
+        amount = queryset.aggregate(Sum('amount'))['amount__sum']
+        if amount is None: return zero
+        else: return amount
+    table = [ # Primary axis
+            [ # Secondary axis
+                total_amount(line_items.filter(primary[1], secondary[1]))
+            for secondary in secondary_axis]
+        for primary in primary_axis]
+
+    debug = False
+    if debug:
+        from django.db import connection
+        print connection.queries
+        print "Number of queries:\t%d" % (len(connection.queries),)
+        print "Table size:\t%dx%d" % (len(primary_labels), len(secondary_labels), )
+
+    context = {
+        'pagename':'reporting',
+        'term_name': term_name,
+        'area': base_area_obj,
+        'primary_name': primary_name,
+        'secondary_name': secondary_name,
+        'primary_labels': primary_labels,
+        'secondary_labels': secondary_labels,
+        'table': table,
+        'table_with_row_labels': zip(primary_labels, table),
+    }
+    return render_to_response('finance_core/reporting.html', context, context_instance=RequestContext(request), )

remit/media/style/style.css

@@ -78 +78 @@
     background: #F88;
 }
+
+table.money-table td
+{
+    text-align: right;
+}
+table.money-table th
+{
+    white-space: pre-wrap;
+    text-align: left;
+    font-weight: normal;
+}

remit/remit_templates/base.html

@@ -16 +16 @@
         <li{% ifequal pagename "list_requests" %} class='selected'{% endifequal %}><a href="{% url list_requests %}">List requests</a></li>
         {% endif %}
+        <li{% ifequal pagename "reporting" %} class='selected'{% endifequal %}><a href="{% url reporting %}">Reporting</a></li>
     </ul>
     <div id='content'>