Design /reports

[aarontitus]

Design a page described in #486 that should include some the following reports relevant to government:
Teammates Invited & Active (Premium for government)

Type(s): Numbers that link to a table report showing details; Stacked Line or Bar Chart
Variables: X: Days. Y: Number of people. On Y axis, bottom section is a running total number of activated invitations, top section is total unactivated invitations.

Claimed, Open, Closed Worksites (Premium for government)

Type(s): Numbers that link to a table report showing details; Stacked Line or Bar Chart
Variables: X: Days. Y: Number of worksites. On Y axis, a stacked running total of open versus closed claimed worksites.

Est. Commercial Value of Services

Type(s):
Variables: X: Days. Y: Dollars. On Y axis, a stacked running

Average Wait Time to Completion

Type(s): Pie Chart with same variables as the line stacked bar/line chart.
Variables: Number of work sites, and number of days waiting (e.g. 0-3, 4-7, 8-14, etc.)

Longest Wait Time to Completion

Type(s): Pie Chart
Variables: Number of work sites, and number of days waiting (e.g. 0-3, 4-7, 8-14, etc.)

Shortest Wait Time to Completion

Type(s): Pie Chart
Variables: Number of work sites, and number of days waiting (e.g. 0-3, 4-7, 8-14, etc.)

Number of Open, unassigned worksites claimed for more than 6 days

Type(s): Numbers that link to a table report showing details; Stacked Line or Bar Chart
Variables:

Detailed Work Logs with Volunteer Hours (premium, only available after app is built)

Type(s): Sortable Table/ CSV; line or bar chart
Variables: A row for each volunteer check in/check out, location of check in, time checked in, duration of service, etc.

Download all cases

Type(s): Sortable Table/ CSV
Variables:

[aarontitus]

@BradenM, looks good. Couple of bugs and improvements:

1. Just to confirm, "Reports" only appears on organizations where legacy_organizations.government = true? And admins?
2. Please note that there are several menus, and you will need to update them all; otherwise the "Reports" menu item randomly appears and disappears depending on where you are in the app. crisiscleanup-2\app\views\layouts\menus
3. It looks like you made the CSV button on the map adapt as well! Great job!
4. Email contents: The email contents are great; just need one change. Instead of a "Contacts" section, please create a "Requested By" section with the full name and contact information of the user who clicked the link, and a separate "Contacts" section with the organization contacts.

Thanks a ton!