3 SELECT evergreen.upgrade_deps_block_check('1178', :eg_version);
5 INSERT INTO action_trigger.event_definition (active, owner, name, hook, validator, reactor, delay, group_field, max_delay, template)
6 VALUES (false, 1, 'Fine Limit Exceeded', 'penalty.PATRON_EXCEEDS_FINES', 'NOOP_True', 'SendEmail', '00:05:00', 'usr', '1 day',
9 [%- user = target.usr -%]
11 To: [%- params.recipient_email || user.email %]
12 From: [%- params.sender_email || default_sender %]
13 Date: [%- date.format(date.now, '%a, %d %b %Y %T -0000', gmt => 1) %]
14 Subject: Fine Limit Exceeded
15 Auto-Submitted: auto-generated
17 Dear [% user.first_given_name %] [% user.family_name %],
20 Our records indicate your account has exceeded the fine limit allowed for the use of your library account.
22 Please visit the library to pay your fines and restore full access to your account.
27 INSERT INTO action_trigger.environment (event_def, path) VALUES
28 (currval('action_trigger.event_definition_id_seq'), 'usr'),
29 (currval('action_trigger.event_definition_id_seq'), 'usr.card');