rubyforgood / growhaus_stats Goto Github PK

Design a dashboard for Production that shows a summary about recent metrics, and includes something to click which will begin the process of recording new metrics.

Admin should be able to make other users into admin.

Admin should be able to assign users to a department.

As a user, I want to record metrics for cooking classes entitled “Cosechando Salud”.

A weekly metric is the Number of Families Served, classified as: “Zone 1” or “Outside”. The sum of Zone 1 and Outside families should be the Total Families Served. There is an additional subdivision, Mobile. The number of those is not included in the count of Total Families.

As a user, once per week on Monday morning I want to receive an email reminding me to enter my weekly department metrics.

We’re already including it via the asset pipeline, we just need to tweak the class names we’re using (because the Materialize gem is a little out of date).

I’m speaking of this link tag.

As a user, if I have not entered my metrics by Tuesday at noon, I want to receive another email reminder to enter my weekly department metrics.

As a user, I want to export any metrics report as a CSV file.

As a user, I want to record metrics for Food Boxes.

A weekly metric is the Number of Boxes, classified by: Zone (1, 2, or 3) and Type. The current types are “Basic”, “Family”, and “Neighborhood”, but those types are expected to change. Therefore, the Type should be something that I can enter myself rather than a selectable list. The sum of the zone boxes should equal the sum of the type boxes. That sum should be the Total Boxes.

A monthly metric is Revenue generated by food boxes.

Design a dashboard for Distribution that shows a summary about recent metrics, and includes something to click which will begin the process of recording new metrics.

As a user who is not logged in, I want to enter a username and password at the login page. When I login, I should see a dashboard.

The system should be able to read data from the google spreadsheet, i.e. to find the latest date for entries and thus decide if the form is up to date, or needs an email reminder to be sent

Set up capistrano and deployment.

As a user, I want to record metrics for the Hydroponic Farm entitled “Hidro Huerto”.

A weekly metric is the Number of Seedlings Harvested, classified by Type (Bibb, Asian Greens, Kale, Flowers & Herbs, and Other). The sum of all types other than Flowers & Herbs is the Total.

A monthly metric is Revenue generated by the farm.

As a user, I want to edit any metrics that I have already entered.

App is expected to run in resource-constrained environment. Fix deployment config to compile assets locally and push them up.

As a user, instead of entering a type for the food box each time, I should have a list of available types where I can edit, add to, or remove existing types. Then, when I’m recording food box metrics, I can choose from those types.

As a user, I want to navigate between the department dashboards - Distribution, Production, and Education - using a navigational menu.

Generate an SSL cert (unsigned for now) that we can use for the time being.

As a user who is not logged in, I want to navigate to the web application and be presented with a login page. I should not be able to see any other section of the application.

As a user, when I record a metric in any department, I want to specify the period of time for that metric. I should be able to enter a date range for the metrics I’m recording.

The token belonging to the owner of the sheet being read from eventually expires, and no one can view it until the user logs in again. Find a solution to either refresh the token or cache the relevant data.

As a logged in administrator, I want to be able to create, delete, and view user accounts.

As a user who is not logged in, I want to be able to log in using a 3rd party service such as Google.

Implement the comps for the main dashboard/navbar.

As a user, I want to record weekly metrics for Education.

A week can have multiple entries. Each entry has the following fields: Type, Number of Participants, and Comments.

Each entry is associated with a number of Hours. The Hours may be classified as: Zone 1-2, or Zone 3. The sum of all hours for the entry is the Total Hours.

As an administrator, once per week on Wednesday, I want to receive an email with an aggregate report of the department statistics that were entered for the week.

As a logged in administrator, I want to be able to reset a user’s password when the user forgets it.

As a user, I want to record metrics for the Food Market.

A weekly metric is the Number of Customers, classified as: “Zone 1” or “Outside”. The sum of Zone 1 and Outside customers served is the Total Customers Served.

A monthly metric is Revenue generated by the Food Market.

Do some intelligent caching of the Drive files. Expiration doesn't have to be too long for now.

As a user, I cannot edit the metrics that other users have entered.

As an administrator, I want to mark date ranges of metrics as “finalized” so they cannot be edited by users after that point in time.

As a user, when I create an entry for educational metrics, I want to select the Type from a list of available options.

As a user, I want to create, edit, and delete Types.

As a user, before I’ve created any custom Types, the following Types should be pre-populated when I’m creating metrics: Cosechando Salud, Food Boxes, Service Learning, Internship Program, Volunteer Days, Special Event, Other.

Design a dashboard for Education that shows a summary about recent metrics, and includes something to click which will begin the process of recording new metrics.

As a user, I want to record a monthly metric for Revenue generated by Education.

Deal with remaining production setup for sending emails.