From 5c72c2f4604f899680d05862aa32545652c1c939 Mon Sep 17 00:00:00 2001
From: erickson <erickson@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Date: Mon, 26 Oct 2009 13:57:38 +0000
Subject: [PATCH] seed data for sample pre-due notice. added delay age param
(1 day) to sample overdue notice
git-svn-id: svn://svn.open-ils.org/ILS/trunk@14600 dcc99617-32d9-48b4-a31d-7c20da2025e4
---
Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +-
Open-ILS/src/sql/Pg/950.data.seed-values.sql | 39 +++++++++++++++++++-
...54.data.action-trigger-predue-and-delay-age.sql | 42 ++++++++++++++++++++++
3 files changed, 81 insertions(+), 2 deletions(-)
create mode 100644 Open-ILS/src/sql/Pg/upgrade/0054.data.action-trigger-predue-and-delay-age.sql
diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql
index 643a70b3f1..a85f84f809 100644
--- a/Open-ILS/src/sql/Pg/002.schema.config.sql
+++ b/Open-ILS/src/sql/Pg/002.schema.config.sql
@@ -51,7 +51,7 @@ CREATE TABLE config.upgrade_log (
install_date TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW()
);
-INSERT INTO config.upgrade_log (version) VALUES ('0053'); -- miker
+INSERT INTO config.upgrade_log (version) VALUES ('0054'); -- berick
CREATE TABLE config.bib_source (
diff --git a/Open-ILS/src/sql/Pg/950.data.seed-values.sql b/Open-ILS/src/sql/Pg/950.data.seed-values.sql
index 65af80f3d5..7dcd9b2732 100644
--- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql
+++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql
@@ -1914,7 +1914,9 @@ INSERT INTO action_trigger.environment (event_def, path) VALUES
(1, 'usr'),
(1, 'billable_transaction.summary'),
(1, 'circ_lib.billing_address');
-
+
+INSERT INTO action_trigger.event_params (event_def, param, value) VALUES
+ (1, 'max_delay_age', '"1 day"');
-- Sample Mark Long-Overdue Item Lost --
@@ -2312,3 +2314,38 @@ INSERT INTO config.org_unit_setting_type ( name, label, description, datatype )
'bool'
);
+
+-- Sample Pre-due Notice --
+
+INSERT INTO action_trigger.event_definition (id, active, owner, name, hook, validator, reactor, delay, delay_field, group_field, template)
+ VALUES (6, 'f', 1, '3 Day Courtesy Notice', 'checkout.due', 'MaxPassiveDelayAge', 'SendEmail', '-3 days', 'due_date', 'usr',
+$$
+[%- USE date -%]
+[%- user = target.0.usr -%]
+To: [%- params.recipient_email || user.email %]
+From: [%- params.sender_email || default_sender %]
+Subject: Courtesy Notice
+
+Dear [% user.family_name %], [% user.first_given_name %]
+As a reminder, the following items are due in 3 days.
+
+[% FOR circ IN target %]
+ Title: [% circ.target_copy.call_number.record.simple_record.title %]
+ Barcode: [% circ.target_copy.barcode %]
+ Due: [% date.format(helpers.format_date(circ.due_date), '%Y-%m-%d') %]
+ Item Cost: [% helpers.get_copy_price(circ.target_copy) %]
+ Library: [% circ.circ_lib.name %]
+ Library Phone: [% circ.circ_lib.phone %]
+[% END %]
+
+$$);
+
+INSERT INTO action_trigger.environment (event_def, path) VALUES
+ (6, 'target_copy.call_number.record.simple_record'),
+ (6, 'usr'),
+ (6, 'circ_lib.billing_address');
+
+INSERT INTO action_trigger.event_params (event_def, param, value) VALUES
+ (6, 'max_delay_age', '"1 day"');
+
+
diff --git a/Open-ILS/src/sql/Pg/upgrade/0054.data.action-trigger-predue-and-delay-age.sql b/Open-ILS/src/sql/Pg/upgrade/0054.data.action-trigger-predue-and-delay-age.sql
new file mode 100644
index 0000000000..df9dd29119
--- /dev/null
+++ b/Open-ILS/src/sql/Pg/upgrade/0054.data.action-trigger-predue-and-delay-age.sql
@@ -0,0 +1,42 @@
+BEGIN;
+
+INSERT INTO config.upgrade_log (version) VALUES ('0054');
+
+-- Sample Pre-due Notice --
+
+INSERT INTO action_trigger.event_definition (id, active, owner, name, hook, validator, reactor, delay, delay_field, group_field, template)
+ VALUES (6, 'f', 1, '3 Day Courtesy Notice', 'checkout.due', 'CircIsOpen', 'SendEmail', '-3 days', 'due_date', 'usr',
+$$
+[%- USE date -%]
+[%- user = target.0.usr -%]
+To: [%- params.recipient_email || user.email %]
+From: [%- params.sender_email || default_sender %]
+Subject: Courtesy Notice
+
+Dear [% user.family_name %], [% user.first_given_name %]
+As a reminder, the following items are due in 3 days.
+
+[% FOR circ IN target %]
+ Title: [% circ.target_copy.call_number.record.simple_record.title %]
+ Barcode: [% circ.target_copy.barcode %]
+ Due: [% date.format(helpers.format_date(circ.due_date), '%Y-%m-%d') %]
+ Item Cost: [% helpers.get_copy_price(circ.target_copy) %]
+ Library: [% circ.circ_lib.name %]
+ Library Phone: [% circ.circ_lib.phone %]
+[% END %]
+
+$$);
+
+INSERT INTO action_trigger.environment (event_def, path) VALUES
+ (6, 'target_copy.call_number.record.simple_record'),
+ (6, 'usr'),
+ (6, 'circ_lib.billing_address');
+
+INSERT INTO action_trigger.event_params (event_def, param, value) VALUES
+ (6, 'max_delay_age', '"1 day"');
+
+-- also add the max delay age to the default overdue notice event def
+INSERT INTO action_trigger.event_params (event_def, param, value) VALUES
+ (1, 'max_delay_age', '"1 day"');
+
+COMMIT;
--
2.11.0