1 -- Evergreen DB patch XXXX.schema.action-trigger.event_definition.sms_preminder.sql
3 -- New action trigger event definition: 3 Day Courtesy Notice by SMS
7 -- check whether patch can be applied
8 SELECT evergreen.upgrade_deps_block_check('1058', :eg_version); -- mccanna/csharp/gmcharlt
10 INSERT INTO action_trigger.event_definition (id, active, owner, name, hook,
11 validator, reactor, delay, max_delay, delay_field, group_field, template)
13 '3 Day Courtesy Notice by SMS',
15 'CircIsOpen', 'SendSMS', '-3 days', '-2 days', 'due_date', 'usr',
18 [%- user = target.0.usr -%]
19 [%- homelib = user.home_ou -%]
20 [%- sms_number = helpers.get_user_setting(user.id, 'opac.default_sms_notify') -%]
21 [%- sms_carrier = helpers.get_user_setting(user.id, 'opac.default_sms_carrier') -%]
22 From: [%- helpers.get_org_setting(homelib.id, 'org.bounced_emails') || homelib.email || params.sender_email || default_sender %]
23 To: [%- helpers.get_sms_gateway_email(sms_carrier,sms_number) %]
24 Subject: Library Materials Due Soon
26 You have items due soon:
28 [% FOR circ IN target %]
29 [%- copy_details = helpers.get_copy_bib_basics(circ.target_copy.id) -%]
30 [% copy_details.title FILTER ucfirst %] by [% copy_details.author FILTER ucfirst %] due on [% date.format(helpers.format_date(circ.due_date), '%m-%d-%Y') %]
36 INSERT INTO action_trigger.environment (event_def, path) VALUES
37 (54, 'circ_lib.billing_address'),
38 (54, 'target_copy.call_number'),