Mockups: Add admin data to facilitate event official/unofficial decision-making [8,8,1]

[stenington]

Related to #2392, the program team has asked for support (in the likely form of some platform tweaks) in determining whether events should be considered official or unofficial. It sounds like what they need to see is which teams/submissions are in which events, and how many of them have completed their submissions. The exact path for getting that information is TBD.

[stenington]

In the admin, it seems you can go to Teams and add "Event name" as a column, but can't get any submission information there. In Submissions you can filter for "Live, official event submissions" and either filter for "Yes, submitted" or otherwise see progress info, but you can't get any further information on the event a submission belongs to.

It seems to me like the shortest path to solving this one is to add bits of event data in "More columns" that let an admin tie everything together as needed, but I would want to confirm that that would work before building it.

[stenington]

The next step on this ticket could be mockups, or maybe just a conversation with the program team about what they would currently do, and what they'd like to see?

[stenington]

@rsgonzal proposed that the event detail view could also show info on the teams and their submission statuses, which would be another option here.

[hellafitz]

Deliverable: quick check w/ Program Team (Ophelie) on direction, then v1 mockups, subsequent feedback from program team, and v2 implementation ticket created

[stenington]

3rd option might be adding a counter cache to events that tracks the number of completed submissions and makes that available as a column. That might be combined with suggest #2 for a more detailed view.

Another possibility is that admins don't care nearly as much about seeing this info if a tool does it for them (#2419), so that should be asked about in the planning for this ticket.

[rsgonzal]

Going to check in at technovation meeting to see if we should pursue this. I'm guessing no, since all judging will be online and events are unofficial.

Or do we still want to work on this one for next year?

[stenington]

I've been emailing with Nick and Ophelie, and can update this ticket soon.

[stenington]

The current proposal, based heavily on feedback from @nickiredescent, is to build out the events page this way:

Currently collecting feedback on this proposal.

[stenington]

It would be helpful on the Events page to have additional optional columns of "Submitted count" and "Unsubmitted count" to help hone in on the teams that need investigating. Those would need to be implemented as counter caches to facilitate sorting.