From 60f035a0a5c4c8b536c0941b3f0d6008a219604d Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Wed, 17 Apr 2013 09:50:03 -0400 Subject: [PATCH] long-overdue : SQL seed data Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/upgrade/XXXX.data.long-overdue.sql | 10 ++++++++-- 1 file changed, 8 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.long-overdue.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.long-overdue.sql index dddaa83dc2..1d8bf85c0e 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.long-overdue.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.long-overdue.sql @@ -196,11 +196,17 @@ INSERT INTO action_trigger.reactor (module, description) VALUES ) ); +INSERT INTO action_trigger.validator (module, description) VALUES ( + 'PatronNotInCollections', + 'Event is valid if the linked patron is not in collections processing ' || + 'at the context org unit' +); + INSERT INTO action_trigger.event_definition (id, active, owner, name, hook, validator, reactor, delay, delay_field) VALUES ( 49, FALSE, 1, '6 Month Overdue Mark Long-Overdue', - 'checkout.due', 'CircIsOverdue', + 'checkout.due', 'PatronNotInCollections', 'MarkItemLongOverdue', '6 months', 'due_date' ); @@ -226,7 +232,7 @@ INSERT INTO action_trigger.hook (key,core_type,description) VALUES ( INSERT INTO action_trigger.event_definition (id, active, owner, name, hook, validator, reactor, group_field, template) VALUES ( - 50, FALSE, 1, '90 Day Overdue Mark Long Overdue Notice', + 50, FALSE, 1, '6 Month Long Overdue Notice', 'longoverdue.auto', 'NOOP_True', 'SendEmail', 'usr', $$ [%- USE date -%] -- 2.11.0