Office access maintenance

[adehnert]

Appropriately authorized student group officers should be able to update a list of people who should get office access and submit it to CAC (ideally, maintaining the list would require usernames but /not/ student ID's, even if CAC requires student ID's). We should coordinate with CAC to see what would work best for them on this front.

[adehnert]

See also ​https://diswww.mit.edu/menelaus/asa-db/541.

[adehnert]

I discussed this with Geoff (-c asa, -i trac-#15, 2011-12-31 05:30 or so). The design I came out of that with (and I'm not sure how much Geoff agrees with it) is as follows.

Data model:

• A mapping (many-to-many) from groups to offices
• a list, for each office/group pair, of additional people who should have access

The correct people to have access to an office, then, is, for each office and group combination, the union of

• everyone who has the OfficerRole? "office-access" for that group
• everyone who is listed as having access to that office from the group

The former will be the "normal" case. The latter allows two exceptional cases:

• access to just one of several offices
• access to offices by "blank cards" or MIT ID holders with no Athena accounts

It's not really ideal for the latter, but I don't think that case is common enough to worry about (as long as it's possible).

[adehnert]

For most offices, from previous conversations, CAC wants a per-group access list. For the Small Activities Office (and maybe others?) they program the controllers with just one big list. I don't know if they'd like us to give them merged output, or if they're just as happy to do it themselves.

[adehnert]

Notes from discussion with CAC today in ​https://diswww.mit.edu/menelaus/asa-db/644.

Basically, they don't have any special formatting needs.

[adehnert]

See also #7.

[adehnert]

Fixed in

*   commit 0ac15a10c1e1e0a32b0aa43dd08929874b5a73b8 (HEAD, master)
|\  Merge: ffecc7f a9a8f3d
| | Author: Alex Dehnert <adehnert@mit.edu>
| | Date:   Thu Apr 5 01:12:37 2012 -0400
| | 
| |     Merge branch 'office-access'
[...]
| * | commit 568006584709dab45f49fbc0bde4a84ea656865f
| | | Author: Alex Dehnert <adehnert@mit.edu>
| | | Date:   Thu Mar 29 00:53:54 2012 -0400
| | | 
| | |     Make locker updates work
| | |     
| | |     I *think* this whole nasty pile of code may *finally* do what it's supposed to.
| | |     
| | |     Fixes ASA Trac #15 and #7, maybe?

Blorp...