3 SELECT evergreen.upgrade_deps_block_check('1229', :eg_version);
6 INSERT into action_trigger.hook (key, core_type, description) VALUES (
7 'au.email.test', 'au', 'A test email has been requested for this user'
10 'au.sms_text.test', 'au', 'A test SMS has been requested for this user'
13 INSERT INTO action_trigger.event_definition (active, owner, name, hook, validator, reactor, delay, template)
15 't', 1, 'Send Test Email', 'au.email.test', 'NOOP_True', 'SendEmail', '00:01:00',
19 [%- lib = target.home_ou -%]
21 From: [%- helpers.get_org_setting(target.home_ou.id, 'org.bounced_emails') || lib.email || params.sender_email || default_sender %]
22 Date: [%- date.format(date.now, '%a, %d %b %Y %T -0000', gmt => 1) %]
23 Reply-To: [%- lib.email || params.sender_email || default_sender %]
24 Subject: Email Test Notification
25 Auto-Submitted: auto-generated
27 Dear [% user.first_given_name %] [% user.family_name %],
29 This is a test of the email associated with your account at [%- lib.name -%]. If you are receiving this message, your email information is correct.
34 Contact your library for more information:
37 [%- SET addr = lib.mailing_address -%]
38 [%- IF !addr -%] [%- SET addr = lib.billing_address -%] [%- END %]
39 [% addr.street1 %] [% addr.street2 %]
40 [% addr.city %], [% addr.state %]
45 INSERT INTO action_trigger.environment (event_def, path)
46 VALUES (currval('action_trigger.event_definition_id_seq'), 'home_ou'),
47 (currval('action_trigger.event_definition_id_seq'), 'home_ou.mailing_address'),
48 (currval('action_trigger.event_definition_id_seq'), 'home_ou.billing_address');
50 INSERT INTO action_trigger.event_definition (active, owner, name, hook, validator, reactor, delay, template)
52 't', 1, 'Send Test SMS', 'au.sms_text.test', 'NOOP_True', 'SendSMS', '00:01:00',
56 [%- lib = user.home_ou -%]
57 [%- sms_number = helpers.get_user_setting(target.id, 'opac.default_sms_notify') -%]
58 [%- sms_carrier = helpers.get_user_setting(target.id, 'opac.default_sms_carrier') -%]
59 From: [%- helpers.get_org_setting(target.home_ou.id, 'org.bounced_emails') || lib.email || params.sender_email || default_sender %]
60 To: [%- helpers.get_sms_gateway_email(sms_carrier,sms_number) %]
61 Subject: Test Text Message
63 This is a test confirming your mobile number for [% lib.name %] is correct.
68 Contact your library for more information:
71 [%- SET addr = lib.mailing_address -%]
72 [%- IF !addr -%] [%- SET addr = lib.billing_address -%] [%- END %]
73 [% addr.street1 %] [% addr.street2 %]
74 [% addr.city %], [% addr.state %]
79 INSERT INTO action_trigger.environment (event_def, path)
80 VALUES (currval('action_trigger.event_definition_id_seq'), 'home_ou'),
81 (currval('action_trigger.event_definition_id_seq'), 'home_ou.mailing_address'),
82 (currval('action_trigger.event_definition_id_seq'), 'home_ou.billing_address');