Better filtering in reporting infrastructure

[adehnert]

​https://asa.mit.edu/groups/reporting/ currently has pretty wimpy filtering infrastructure --- you can filter by name, funding status, etc., but nothing that isn't part of the group object.

We need infrastructure for registering various filters from within the various components of the DB, and filters using it. Such filters might include:

• Membership confirmations: groups who haven't filled out the membership update form for the most recent cycle, or who haven't gotten at least five people to confirm in the most recent cycle
• People: groups whose President or Treasurer aren't students
• FYSM: Groups who have/have not filled out the FYSM
• Space: groups with space, or groups with space in [W20, Walker, W20 offices, W20 lockers]
• Constitutions: groups whose constitution is currently erroring, or any of the specific errors

This would make it much easier to update members of asa-list-of-group-lists, contact (possibly with mail merge) each group that some news or issue applies to, etc..

[adehnert]

See also RT #2332385 for thoughts.

[adehnert]

That RT ticket is ​https://help.mit.edu/Ticket/Display.html?id=2332385.

Right now, the suggestions are:

• ASA-#228
• office and storage space info (already written)
• what groups have been recognized in the past x months (but it's not clear this request is needed much, especially not with any particular value of x, and it's easy to do in a spreadsheet)

I think I'm currently leaning towards the membership confirmation ones and maybe the FYSM.

[adehnert]

Fixed by the branch merged in commit ff71c3a9a9c3e67794f77349dc9e4d58e7a5d78d:

Merge: e5c5180 b523fed
Author: Alex Dehnert <adehnert@mit.edu>
Date:   Tue Feb 11 02:57:15 2014 -0500

    Allow more flexible filtering in the reporting UI
    
    Merge branch 'filters'
    
    * filters:
      Reporting: Allow different name formats (ASA-#259)
      Comment out filter categories we don't use yet
      Filters: select by office/locker ownership
      Filters: use "category", not "group"
      Proof-of-concept reporting filters (ASA-#193)
    
    This resolves ASA-#193 (and ASA-#259).

commit d4f571c614058f0112c18facb9df44c6da4ebdeb
Author: Alex Dehnert <adehnert@mit.edu>
Date:   Tue Feb 11 02:26:09 2014 -0500

    Comment out filter categories we don't use yet

commit 256323025d8b1819cfbf59e1c9c79ff5aac1c604
Author: Alex Dehnert <adehnert@mit.edu>
Date:   Mon Apr 8 14:52:19 2013 -0400

    Filters: select by office/locker ownership

commit 62f73dffa5551f56f27ab1b88bf7074cae5f203a
Author: Alex Dehnert <adehnert@mit.edu>
Date:   Wed Feb 20 13:13:34 2013 -0500

    Filters: use "category", not "group"
    
    "Group" is a heavily overloaded term in the context of the ASA DB, so talk
    about "filter categories" instead of "filter groups". (Suggestion from geofft.)

commit d7557b86425217187920ee55cf49525e7178ce72
Author: Alex Dehnert <adehnert@mit.edu>
Date:   Sat Feb 9 01:53:21 2013 -0500

    Proof-of-concept reporting filters (ASA-#193)
    
    Add proof-of-concept support for extensible filtering of the reporting page,
    beyond just the fields on the Group object. At the moment, this is just a few
    space-related filters, but in the future this might include groups missing
    membership confirmations, groups whose presidents aren't students, groups who
    have filled out the FYSM, etc..

(Or, at least, the infrastructure is there. I'll leave adding more filters to later tickets.)