Create an alert under certain conditions

[torstesu]

If under conditions as described below are met, an alert is to be issued. The alert should have a unique ID that links to the volunteer SMS reports (#25) that triggered the alert as well as any other reports received while the alert is active.

The system should issue an alert if the number of cases reported within a certain timeframe within a specific geographical area exceeds the threshold value defined per event in [Admin] #54 (https://github.com/IFRCGo/cbs/projects/1).

When	What	Related issues	Message
Number of [health risk] exceed [threshold] within [location] within [time = 7 days]	Create alert ID: attribute all related reports to alert ID	#33 #42
Create alert ID: attribute all related reports to alert ID	Send Alert SMS with [Alert investigation form NEEDS TICKET] to [Validator]	# ALERT BASE #69	[Health Risk] has triggered an alert. Please follow up with: [FullName] [Phone] (repeating). (Requires form attachment).

Question: do we need a database for time series?

If there's already an active alert for the specific disease and geographical area, a new alert should not be issued but the cases should be linked to the active alert ID.

If an alert has previously been triggered, but later manually closed by a health coordinator, and new cases are reported that puts the system in a countionous alert state (continuously above threshold value), the previously closed alert ID should be reopened and the new cases linked to this alert ID.