From 3f969a0609aabdfd51d8a8525bb17aa6a044e639 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Wed, 1 Nov 2017 15:07:34 -0400 Subject: [PATCH] PINES already has 1058 --- .../Pg/version-upgrade/2.12.6-3.0.0-upgrade-db.sql | 63 +++++++++++----------- 1 file changed, 32 insertions(+), 31 deletions(-) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/2.12.6-3.0.0-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/2.12.6-3.0.0-upgrade-db.sql index 0587aa7c68..263223d990 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/2.12.6-3.0.0-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/2.12.6-3.0.0-upgrade-db.sql @@ -2622,37 +2622,38 @@ $$ LANGUAGE SQL STABLE ROWS 10; -- check whether patch can be applied SELECT evergreen.upgrade_deps_block_check('1058', :eg_version); -- mccanna/csharp/gmcharlt -INSERT INTO action_trigger.event_definition (id, active, owner, name, hook, - validator, reactor, delay, max_delay, delay_field, group_field, template) - VALUES (54, FALSE, 1, - '3 Day Courtesy Notice by SMS', - 'checkout.due', - 'CircIsOpen', 'SendSMS', '-3 days', '-2 days', 'due_date', 'usr', -$$ -[%- USE date -%] -[%- user = target.0.usr -%] -[%- homelib = user.home_ou -%] -[%- sms_number = helpers.get_user_setting(user.id, 'opac.default_sms_notify') -%] -[%- sms_carrier = helpers.get_user_setting(user.id, 'opac.default_sms_carrier') -%] -From: [%- helpers.get_org_setting(homelib.id, 'org.bounced_emails') || homelib.email || params.sender_email || default_sender %] -To: [%- helpers.get_sms_gateway_email(sms_carrier,sms_number) %] -Subject: Library Materials Due Soon - -You have items due soon: - -[% FOR circ IN target %] -[%- copy_details = helpers.get_copy_bib_basics(circ.target_copy.id) -%] -[% copy_details.title FILTER ucfirst %] by [% copy_details.author FILTER ucfirst %] due on [% date.format(helpers.format_date(circ.due_date), '%m-%d-%Y') %] - -[% END %] - -$$); - -INSERT INTO action_trigger.environment (event_def, path) VALUES - (54, 'circ_lib.billing_address'), - (54, 'target_copy.call_number'), - (54, 'usr'), - (54, 'usr.home_ou'); +-- PINES already has this +-- INSERT INTO action_trigger.event_definition (id, active, owner, name, hook, +-- validator, reactor, delay, max_delay, delay_field, group_field, template) +-- VALUES (54, FALSE, 1, +-- '3 Day Courtesy Notice by SMS', +-- 'checkout.due', +-- 'CircIsOpen', 'SendSMS', '-3 days', '-2 days', 'due_date', 'usr', +-- $$ +-- [%- USE date -%] +-- [%- user = target.0.usr -%] +-- [%- homelib = user.home_ou -%] +-- [%- sms_number = helpers.get_user_setting(user.id, 'opac.default_sms_notify') -%] +-- [%- sms_carrier = helpers.get_user_setting(user.id, 'opac.default_sms_carrier') -%] +-- From: [%- helpers.get_org_setting(homelib.id, 'org.bounced_emails') || homelib.email || params.sender_email || default_sender %] +-- To: [%- helpers.get_sms_gateway_email(sms_carrier,sms_number) %] +-- Subject: Library Materials Due Soon +-- +-- You have items due soon: +-- +-- [% FOR circ IN target %] +-- [%- copy_details = helpers.get_copy_bib_basics(circ.target_copy.id) -%] +-- [% copy_details.title FILTER ucfirst %] by [% copy_details.author FILTER ucfirst %] due on [% date.format(helpers.format_date(circ.due_date), '%m-%d-%Y') %] +-- +-- [% END %] +-- +-- $$); +-- +-- INSERT INTO action_trigger.environment (event_def, path) VALUES +-- (54, 'circ_lib.billing_address'), +-- (54, 'target_copy.call_number'), +-- (54, 'usr'), +-- (54, 'usr.home_ou'); -- check whether patch can be applied -- 2.11.0