Project digest

[amberrignell]

User story

As a project user, I would like to receive a digest via email, so that I can get an update on how the workflows within my project are doing AND see the project activity.

Details

In the Digest column in project settings > collaboration (created by #588), allow a project user to select 'never', 'daily', 'weekly', 'monthly'.

Write a function that emails a user the following digest at the frequency selected:

Subject: ${frequency} digest for project ${project name} 

Body: 

Workflow A:
- 12 workorders correctly processed this ${month/day/week} 
-> sum of work orders that have a status of success, where the **last run** is in the past ${month/day/week} 
- 4 of these work orders initially failed,  but were rerun and eventually processed correctly
- 2 work orders failed and still need addressing

Implementation notes

Keep in mind we will be adding a feature which allows administrators to prevent any logs from being sent in emails.

Daily: send at 10am every day
Weekly: send on Monday at 10am
Monthly: send on the 1st of the month at 10am

Add a digest column to the project_users table. The default should be set to 'weekly'.
Add a Digest column to the collaboration page.

Release notes

• Configure project to receive daily/monthly/weekly digest

User acceptance criteria

• The default is set to 'never'
• Given a project user for project 'Sync OpenHIE' with digest set to 'weekly', I should receive an email on Monday at 10am with the subject: 'Weekly digest for project 'Sync OpenHIE'.

[amberrignell]

Updated phrasing in the email after request for clarification from Elias:
"4 of these work orders initially failed, but were rerun and eventually processed correctly"

[amberrignell]

When I change the project digect and alerts values in project settings, I don't get a flash confirmation message and the values aren't updated.

https://images.zenhubusercontent.com/454419290/8ccec269-7305-4d71-8254-4378e17f5cd3/screen_recording_2023_03_08_at_09_54_01.mov

[amberrignell]

closed. by #682