search

CrisisCleanup / crisiscleanup-2

[OLD] This version of the codebase was retired on March 27, 2020. Open Source Collaborative Disaster Recovery and Cleanup
https://www.crisiscleanup.org
Other
43 stars 24 forks source link

Design /reports #487

Open aarontitus opened 4 years ago

aarontitus commented 4 years ago

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 commented 4 years ago

@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!