From b36699603db32969f171f777b01ba23669d08c80 Mon Sep 17 00:00:00 2001 From: Jeff Godin Date: Tue, 6 Dec 2011 13:49:40 -0500 Subject: [PATCH] seed/upgrade for YAOUS: "forgive" lost billings seed and upgrade script for new OU settings, previously described: circ.forgive_overdue_on_lost circ.forgive_lost_on_checkin circ.forgive_lost_proc_fee_on_checkin Signed-off-by: Jeff Godin Signed-off-by: Jason Stephenson --- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 27 ++++++++++++++ .../Pg/upgrade/XXXX.data.lost_forgive_not_void.sql | 43 ++++++++++++++++++++++ 2 files changed, 70 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.data.lost_forgive_not_void.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 88051810eb..d626c1da40 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -3527,6 +3527,33 @@ INSERT into config.org_unit_setting_type 'coust', 'description'), 'bool', null) +,( 'circ.forgive_lost_on_checkin', 'circ', + oils_i18n_gettext('circ.forgive_lost_on_checkin', + 'Forgive lost item billing when returned', + 'coust', 'label'), + oils_i18n_gettext('circ.forgive_lost_on_checkin', + 'Forgive lost item billing when returned', + 'coust', 'description'), + 'bool', null) + +,( 'circ.forgive_lost_proc_fee_on_checkin', 'circ', + oils_i18n_gettext('circ.forgive_lost_proc_fee_on_checkin', + 'Forgive processing fee on lost item return', + 'coust', 'label'), + oils_i18n_gettext('circ.forgive_lost_proc_fee_on_checkin', + 'Forgive processing fee when lost item returned', + 'coust', 'description'), + 'bool', null) + +,( 'circ.forgive_overdue_on_lost', 'finance', + oils_i18n_gettext('circ.forgive_overdue_on_lost', + 'Forgive overdue fines when items are marked lost', + 'coust', 'label'), + oils_i18n_gettext('circ.forgive_overdue_on_lost', + 'Forgive overdue fines when items are marked lost', + 'coust', 'description'), + 'bool', null) + ,( 'circ.void_lost_on_checkin', 'circ', oils_i18n_gettext('circ.void_lost_on_checkin', 'Void lost item billing when returned', diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.lost_forgive_not_void.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.lost_forgive_not_void.sql new file mode 100644 index 0000000000..170064d4e9 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.lost_forgive_not_void.sql @@ -0,0 +1,43 @@ +-- Evergreen DB patch XXXX.data.lost_forgive_not_void.sql +-- +-- Insert new org unit settings for Forgive (not void) +-- regarding Lost items +-- +BEGIN; + + +-- check whether patch can be applied +SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); + +INSERT into config.org_unit_setting_type +( name, grp, label, description, datatype, fm_class ) VALUES + +( 'circ.forgive_lost_on_checkin', 'circ', + oils_i18n_gettext('circ.forgive_lost_on_checkin', + 'Forgive lost item billing when returned', + 'coust', 'label'), + oils_i18n_gettext('circ.forgive_lost_on_checkin', + 'Forgive lost item billing when returned', + 'coust', 'description'), + 'bool', null) + +,( 'circ.forgive_lost_proc_fee_on_checkin', 'circ', + oils_i18n_gettext('circ.forgive_lost_proc_fee_on_checkin', + 'Forgive processing fee on lost item return', + 'coust', 'label'), + oils_i18n_gettext('circ.forgive_lost_proc_fee_on_checkin', + 'Forgive processing fee when lost item returned', + 'coust', 'description'), + 'bool', null) + +,( 'circ.forgive_overdue_on_lost', 'finance', + oils_i18n_gettext('circ.forgive_overdue_on_lost', + 'Forgive overdue fines when items are marked lost', + 'coust', 'label'), + oils_i18n_gettext('circ.forgive_overdue_on_lost', + 'Forgive overdue fines when items are marked lost', + 'coust', 'description'), + 'bool', null) +; + +COMMIT; -- 2.11.0