UI for modifying email update

[regan-sarwas]

• Current

When a user want to start or stop getting a daily email with the latest animal locations, we need to add their email address and the project they are interested in to the reports list in email_updates.py. However this is done in the copy deployed on AIS in the AM folder of the local sql_proxy account. That is log into AIS as sql_proxy, and edit $HOME/AM/email_updates.py with the appropriate changes.

• Proposal

1. Move the report list from the python file to a database table in the animal movements database. The table would have two text columns email and project and one boolean (or char) field for active (default: true). Like most tables in AM, all users could query, but only the DBO could insert/update/delete.
2. Modify the python script to query the database for the report list of active emails, rather than having hardcoded in the script

• Advanced Proposal

1. Create add, update, and delete stored procedures, so any PI could add, update, or delete rows for only their project.
2. Add these stored procedures, as well as the table to the data model in Animal Movements app (in visual studio)
3. Add a new tab to the project dialog for "reports" in Animal Movements app
4. Add a section on the reports form for "Daily report of most recent locations sent to these emails addresses" with an editable table of email addresses. Adding, deleting or updating will modify the appropriate record in the database table.
5. Initially, all reports will be sent every day, but we could add a column to the email list for "Pause delivery", which would toggle the active column in the database, so they could keep the email in the list, but pause daily email if they are going on vacation, or the animal is hibernating, etc.

• Super Advanced Proposal

Expand the table and form so that the PI could pick from a menu of reports, and customize the delivery schedule,

[regan-sarwas]

See issue #40 for an example of another report type (i.e. map image of current locations)