Changeset 0b72bfd

Timestamp:

Oct 13, 2011, 1:46:58 AM (14 years ago)

Author:

Alex Dehnert <adehnert@…>

Branches:

master, space-access, stable, stage, test-hooks

Children:

e1f5425

Parents:

8dfd3db

git-author:

Alex Dehnert <adehnert@…> (10/13/11 01:46:58)

git-committer:

Alex Dehnert <adehnert@…> (10/13/11 01:46:58)

Message:

Add report on group activity confirmation problems

Location:

asadb

Files:

• forms/views.py (modified) (4 diffs)
• urls.py (modified) (1 diff)

asadb/forms/views.py

@@ -4 +4 @@
 import settings
 
-from django.contrib.auth.decorators import user_passes_test, login_required
+from django.contrib.auth.decorators import user_passes_test, login_required, permission_required
 from django.views.generic import list_detail, ListView, DetailView
 from django.shortcuts import render_to_response, get_object_or_404
@@ -10 +10 @@
 from django.template import Context, Template
 from django.template.loader import get_template
-from django.http import Http404, HttpResponseRedirect
+from django.http import Http404, HttpResponseRedirect, HttpResponse
 from django.core.urlresolvers import reverse
 from django.core.mail import EmailMessage, mail_admins
@@ -19 +19 @@
 from django.db.models import Q, Count
 
+import csv
 import datetime
+import StringIO
 
 #################
@@ -444 +446 @@
     #        context['title'] = "Recent Changes"
     #    return context
+
+
+@permission_required('groups.view_group_private_info')
+def group_confirmation_issues(request, ):
+    active_groups = groups.models.Group.active_groups
+    group_updates = forms.models.GroupMembershipUpdate.objects.all()
+    people_confirmations = forms.models.PersonMembershipUpdate.objects.filter(
+        deleted__isnull=True,
+        valid__gt=0,
+    )
+
+    buf = StringIO.StringIO()
+    output = csv.writer(buf)
+    output.writerow(['group_id', 'group_name', 'issue', 'num_confirm', 'officer_email', ])
+
+    q_present = Q(id__in=group_updates.values('group'))
+    missing_groups = active_groups.filter(~q_present)
+    #print len(list(group_updates))
+    for group in missing_groups:
+        num_confirms = len(people_confirmations.filter(groups=group))
+        output.writerow([
+            group.id,
+            group.name,
+            'unsubmitted',
+            num_confirms,
+            group.officer_email,
+        ])
+
+    for group_update in group_updates:
+        group = group_update.group
+        num_confirms = len(people_confirmations.filter(groups=group))
+        if num_confirms < 5:
+            output.writerow([
+                group.id,
+                group.name,
+                'confirmations',
+                num_confirms,
+                group.officer_email,
+            ])
+
+
+    return HttpResponse(buf.getvalue(), mimetype='text/plain', )

asadb/urls.py

@@ -38 +38 @@
     ),
     url(r'^membership/submitted/$', forms.views.View_GroupMembershipList.as_view(), name='membership-submitted', ),
+    url(r'^membership/admin/issues.csv$', forms.views.group_confirmation_issues, name='membership-issues', ),
 
     # Group list