From 6fe995db0b7646949c12bbdce8115c723fa20145 Mon Sep 17 00:00:00 2001
From: erickson <erickson@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Date: Mon, 21 Sep 2009 16:37:19 +0000
Subject: [PATCH] added various hold cancelation hooks for (eventually)
notifying patrons when a hold was cancelled for a given reason
git-svn-id: svn://svn.open-ils.org/ILS/trunk@14077 dcc99617-32d9-48b4-a31d-7c20da2025e4
---
Open-ILS/src/sql/Pg/950.data.seed-values.sql | 28 +++++++++++++++++++
.../0009.data.action-trigger-hold-cancel-hook.sql | 32 ++++++++++++++++++++++
2 files changed, 60 insertions(+)
create mode 100644 Open-ILS/src/sql/Pg/upgrade/0009.data.action-trigger-hold-cancel-hook.sql
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 120fd209f6..8b4dd5506a 100644
--- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql
+++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql
@@ -2220,3 +2220,31 @@ INSERT INTO config.org_unit_setting_type (name, label, description, datatype) VA
'bool'
);
+-- Hold cancel action/trigger hooks
+
+INSERT INTO action_trigger.hook (key,core_type,description) VALUES (
+ 'hold_request.cancel.expire_no_target',
+ 'ahr',
+ 'A hold is cancelled because no copies were found'
+);
+
+INSERT INTO action_trigger.hook (key,core_type,description) VALUES (
+ 'hold_request.cancel.expire_holds_shelf',
+ 'ahr',
+ 'A hold is cancelled becuase it was on the holds shelf too long'
+);
+
+INSERT INTO action_trigger.hook (key,core_type,description) VALUES (
+ 'hold_request.cancel.staff',
+ 'ahr',
+ 'A hold is cancelled becuase it was cancelled by staff'
+);
+
+INSERT INTO action_trigger.hook (key,core_type,description) VALUES (
+ 'hold_request.cancel.patron',
+ 'ahr',
+ 'A hold is cancelled by the patron'
+);
+
+
+
diff --git a/Open-ILS/src/sql/Pg/upgrade/0009.data.action-trigger-hold-cancel-hook.sql b/Open-ILS/src/sql/Pg/upgrade/0009.data.action-trigger-hold-cancel-hook.sql
new file mode 100644
index 0000000000..144bb3a165
--- /dev/null
+++ b/Open-ILS/src/sql/Pg/upgrade/0009.data.action-trigger-hold-cancel-hook.sql
@@ -0,0 +1,32 @@
+BEGIN;
+
+INSERT INTO config.upgrade_log (version) VALUES ('0009.data.action-trigger-hold-cancel-hook.sql');
+
+INSERT INTO action_trigger.hook (key,core_type,description) VALUES (
+ 'hold_request.cancel.expire_no_target',
+ 'ahr',
+ 'A hold is cancelled because no copies were found'
+);
+
+INSERT INTO action_trigger.hook (key,core_type,description) VALUES (
+ 'hold_request.cancel.expire_holds_shelf',
+ 'ahr',
+ 'A hold is cancelled becuase it was on the holds shelf too long'
+);
+
+INSERT INTO action_trigger.hook (key,core_type,description) VALUES (
+ 'hold_request.cancel.staff',
+ 'ahr',
+ 'A hold is cancelled becuase it was cancelled by staff'
+);
+
+INSERT INTO action_trigger.hook (key,core_type,description) VALUES (
+ 'hold_request.cancel.patron',
+ 'ahr',
+ 'A hold is cancelled by the patron'
+);
+
+
+COMMIT;
+
+
--
2.11.0