Send email of locations / generators alerts to users

[pferrariuy]

Feature Request

Description

Generate a scheduler (execution at 6 am) that will retrieve all not send alert and will send them to the users, with their corresponding information. All alerts notifications must be send if all of the following conditions are meet:

• Client is enabled to send alerts by email
• Location / Generator is enabled to send alerts by email
• Alert has not been send by email before
• The alert must by seend to all users (with access to the client + location / generator) that are enabled to receive alerts by email

Use Case

Location / Generator data is imported in the system. The alert service calcualtes and determinates an issue with the data. An alert is generated in the database (the same alert that the user will see when accessing to the dashboard). The system detects and send the alert by email.

Expected Behavior

• Every day at 6 am, a series of emails are send email to each user with the corresponding alert information (1 email by alert).
• No alerts, then no email.

Additional Context

The content of the email must be in the language configured by the user.

Implementation Suggestions

Record the result of alerts notifications to users in the corresponding table:

• cli_gen_usr_alert
• cli_loc_usr_alert

Impact on Existing Features

No impact in other features.

Additional Information

Users might have access to different clients (cli_user) and locations (loc_user), so notifications must be send to users with access to those client / location. For the case of a generator alert, use the loc_user verification.

Related Issues

• Create translation service por labels and emails content generation #21

Pendings

• Adjusts email template to UI of app

[pferrariuy]

Added new flags to:

• Client:
  • FLAG_RECEIVE_ALERT_LOCATION_BY_EMAIL = 2
  • FLAG_RECEIVE_ALERT_GENERATOR_NBY_EMAIL = 3
• Location: FLAG_ENABLED_FOR_EMAIL_ALERT = 3
• Generator: FLAG_ENABLED_FOR_EMAIL_ALERT = 1
• Client Location Alert: FLAG_SEND_BY_EMAIL = 1
• Client Generator Alert: FLAG_SEND_BY_EMAIL = 1

Uses views (Renovus-Tech/solarec-db#15):

• vw_cli_gen_alert_to_send_by_email
• vw_cli_loc_alert_to_send_by_email

New email template:

• email_alert.html

New label added:

email.generator.alert.subject = SolaREC Notification alert
email.location.alert.subject = SolaREC Notification alert

New logback configuration:

    <appender name="email_daily_appender" class="ch.qos.logback.core.rolling.RollingFileAppender">
        <file>${logFilePath}/email/email.log</file>
        <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
            <fileNamePattern>${logFilePath}/email/email.%d{yyyy-MM-dd}.log</fileNamePattern>
            <maxHistory>7</maxHistory> <!-- Keep logs for 7 days -->
        </rollingPolicy>
        <encoder>
            <pattern>%d{HH:mm:ss.SSS} [%thread] %-5level %logger{36} - %msg%n</pattern>
        </encoder>
    </appender>

    <logger name="email" 		level="all" additivity="true"><appender-ref ref="email_daily_appender"/></logger>