From 6fe995db0b7646949c12bbdce8115c723fa20145 Mon Sep 17 00:00:00 2001 From: erickson 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