Changeset 213dd57 for asadb/groups/views.py

Timestamp:

Dec 25, 2012, 4:15:16 AM (13 years ago)

Author:

Alex Dehnert <adehnert@…>

Branches:

master, space-access, stable, stage

Children:

532a8e9

Parents:

14f594b

git-author:

Alex Dehnert <adehnert@…> (12/25/12 04:15:16)

git-committer:

Alex Dehnert <adehnert@…> (12/25/12 04:15:16)

Message:

Add page showing non-student group officers

Adds a page non-students holding positions that are required to be held by
students. This is a partial fix to ASA-#6, though the eventual solution should
probably be more integrated than this is.

File:

• asadb/groups/views.py (modified) (1 diff)

asadb/groups/views.py

@@ -1208 +1208 @@
     }
     return render_to_response('groups/reporting.html', context, context_instance=RequestContext(request), )
+
+
+@permission_required('groups.view_group_private_info')
+def show_nonstudent_officers(request, ):
+    student_roles  = groups.models.OfficerRole.objects.filter(require_student=True, )
+    year = datetime.datetime.now().year
+    account_classes = ["G"] + [str(yr) for yr in range(year-5, year+10)]
+    students = groups.models.AthenaMoiraAccount.active_accounts.filter(account_class__in=account_classes)
+    office_holders = groups.models.OfficeHolder.current_holders.order_by('group__name', 'role', )
+    office_holders = office_holders.filter(role__in=student_roles)
+    office_holders = office_holders.exclude(person__in=students.values('username'))
+    office_holders = office_holders.select_related('group', 'role')
+
+    msg = None
+    msg_type = ""
+    if 'sort' in request.GET:
+        if request.GET['sort'] == 'group':
+            office_holders = office_holders.order_by('group__name', 'role', 'person', )
+        elif request.GET['sort'] == 'role':
+            office_holders = office_holders.order_by('role', 'group__name', 'person', )
+        elif request.GET['sort'] == 'person':
+            office_holders = office_holders.order_by('person', 'group__name', 'role', )
+        else:
+            msg = 'Unknown sort key "%s".' % (request.GET['sort'], )
+            msg_type = 'error'
+
+    context = {
+        'pagename': 'groups',
+        'roles': student_roles,
+        'holders': office_holders,
+        'msg': msg,
+        'msg_type': msg_type,
+    }
+
+    return render_to_response('groups/reporting/non-students.html', context, context_instance=RequestContext(request), )
+
+