Changeset 532a8e9 for asadb

Timestamp:

Dec 26, 2012, 5:12:22 AM (13 years ago)

Author:

Alex Dehnert <adehnert@…>

Branches:

master, space-access, stable, stage

Children:

c80e9a2

Parents:

213dd57

git-author:

Alex Dehnert <adehnert@…> (12/26/12 05:12:22)

git-committer:

Alex Dehnert <adehnert@…> (12/26/12 05:12:22)

Message:

Generate a CSV version of the constitutions page

This is a CSV counterpart to /groups/constitutions/, for easier analysis in a
spreadsheet program or use with mail-merge. This can be view as progress
towards fixing ASA-#6.

Location:

asadb

Files:

• groups/urls.py (modified) (1 diff)
• groups/views.py (modified) (1 diff)
• template/groups/groups_constitutions.html (modified) (1 diff)

asadb/groups/urls.py

@@ -25 +25 @@
     url(r'^signatories/$', groups.views.view_signatories, name='signatories', ),
     url(r'^constitutions/$', groups.views.downloaded_constitutions, name='constitutions', ),
+    url(r'^constitutions/status.csv$', groups.views.downloaded_constitutions_csv, name='constitutions-csv', ),
     url(r'^account_lookup/$', groups.views.account_lookup, name='account-lookup', ),
 )

asadb/groups/views.py

@@ -1044 +1044 @@
 
 
+@permission_required('groups.view_group_private_info')
+def downloaded_constitutions_csv(request, ):
+    active_groups = groups.models.Group.active_groups.all()
+    constitutions = groups.models.GroupConstitution.objects.filter(group__in=active_groups)
+    constitutions = constitutions.order_by('failure_reason', 'status_msg', 'failure_date', 'group__name', ).select_related('group', 'group__group_status')
+
+    response = HttpResponse(mimetype='text/csv')
+    writer = csv.writer(response)
+
+    writer.writerow([
+        'failure_date',
+        'status_msg',
+        'name', 'id', 'group_status', 'officer_email',
+        'constitution_url',
+    ])
+    for const in constitutions:
+        writer.writerow([
+            const.failure_date,
+            const.status_msg,
+            const.group.name,
+            const.group.pk,
+            const.group.group_status.slug,
+            const.group.officer_email,
+            const.source_url,
+        ])
+    return response
+
+
 
 #######################

asadb/template/groups/groups_constitutions.html

@@ -5 +5 @@
 
 <h1>Constitutions</h1>
+
+<p>See also the <a href='{% url groups:constitutions-csv %}'>CSV version</a> (which contains active groups only).</p>
 
 <h2>Summary</h2>