Changeset 8708a86

Timestamp:

Mar 31, 2012, 3:12:55 PM (14 years ago)

Author:

Alex Dehnert <adehnert@…>

Branches:

master, space-access, stable, stage

Children:

747c960

Parents:

d1a4706

git-author:

Alex Dehnert <adehnert@…> (03/31/12 06:06:20)

git-committer:

Alex Dehnert <adehnert@…> (03/31/12 15:12:55)

Message:

Basic reporting functionality

• Allows picking your filter
• Allows picking your fields
• Does not allow displaying signatories
• Does not allow sorting
• Does not allow CSV output

Location:

asadb

Files:

• groups/models.py (modified) (1 diff)
• groups/urls.py (modified) (1 diff)
• groups/views.py (modified) (1 diff)
• template/groups/reporting.html (added)
• template/index.html (modified) (1 diff)

asadb/groups/models.py

@@ -97 +97 @@
     def __str__(self, ):
         return self.name
+
+    @classmethod
+    def reporting_fields(cls, ):
+        fields = cls._meta.fields
+        return [(f.name, f.verbose_name) for f in fields]
 
     class Meta:

asadb/groups/urls.py

@@ -18 +18 @@
     url(r'^recognize/nge/$', groups.views.recognize_nge, name='recognize-nge', ),
     url(r'^search/$', groups.views.search_groups, name='search', ),
+    url(r'^reporting/$', groups.views.reporting, name='reporting', ),
     url(r'^recent_changes/$', groups.views.GroupHistoryView.as_view(), name='manage-history', ),
     url(r'^signatories/$', groups.views.view_signatories, name='signatories', ),

asadb/groups/views.py

@@ -782 +782 @@
         return render_to_response('groups/group_search.html', context, context_instance=RequestContext(request), )
 
+class ReportingForm(form_utils.forms.BetterForm):
+    _basic_fields = groups.models.Group.reporting_fields()
+    basic_fields_labels = dict(_basic_fields) # name -> verbose_name
+    basic_fields = forms.fields.MultipleChoiceField(choices=_basic_fields, widget=forms.CheckboxSelectMultiple)
+
+    class Meta:
+        fieldsets = [
+            ('filter', {
+                'legend': 'Filter Groups',
+                'fields': ['name', 'abbreviation', 'activity_category', 'group_class', 'group_status', 'group_funding', ],
+            }),
+            ('display', {
+                'legend': 'Data to display',
+                'fields': ['basic_fields', ],
+            }),
+        ]
+
+    def __init__(self, *args, **kwargs):
+        super(ReportingForm, self).__init__(*args, **kwargs)
+
+class GroupReportingFilter(GroupFilter):
+    class Meta(GroupFilter.Meta):
+        form = ReportingForm
+
+    def __init__(self, data=None, *args, **kwargs):
+        if data is None: data = {}
+        else: data = data.copy()
+        #data.setdefault('basic_fields', ['id', 'name'], )
+        super(GroupReportingFilter, self).__init__(data, *args, **kwargs)
+
+@permission_required('groups.view_group_private_info')
+def reporting(request, ):
+    the_groups = groups.models.Group.objects.all()
+    groups_filterset = GroupReportingFilter(request.GET, the_groups)
+    form = groups_filterset.form
+
+    col_labels = []
+    report_groups = []
+    run_report = 'go' in request.GET and form.is_valid()
+    if run_report:
+        basic_fields = form.cleaned_data['basic_fields']
+        col_labels = [form.basic_fields_labels[field] for field in basic_fields]
+        for group in groups_filterset.qs:
+            group_data = [getattr(group, field) for field in basic_fields]
+            report_groups.append(group_data)
+    else:
+        pass
+
+    context = {
+        'form': form,
+        'run_report': run_report,
+        'column_labels': col_labels,
+        'report_groups': report_groups,
+        'pagename': 'groups',
+    }
+    return render_to_response('groups/reporting.html', context, context_instance=RequestContext(request), )
+
 
 class GroupHistoryView(ListView):

asadb/template/index.html

@@ -33 +33 @@
         <li><a href='{%url groups:list%}'>List of groups</a></li>
         {%if perms.groups.view_signatories %}<li><a href='{% url groups:signatories %}'>View Signatories</a></li>{%endif%}
+        {%if perms.groups.view_group_private_info %}<li><a href='{%url groups:reporting%}'>Reporting</a></li>{%endif%}
         <li><a href='{%url groups:account-lookup%}'>Account lookup</a></li>
     </ul></li>