From 3dfc3502cfeebe3c8a6b9c8c3457fd0e95b13d88 Mon Sep 17 00:00:00 2001 From: Kathy Lussier Date: Thu, 6 Aug 2015 12:50:11 -0400 Subject: [PATCH] lp1479110 Provide more clarity for negative balance settings Update the descriptions for the negative balance settings so that users know how to use prohibit and interval settings in conjunction with each other. Signed-off-by: Kathy Lussier --- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 12 +++++----- ...ta.update_negative_balance_OUS_descriptions.sql | 26 ++++++++++++++++++++++ 2 files changed, 32 insertions(+), 6 deletions(-) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.data.update_negative_balance_OUS_descriptions.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 0ce75a4821..ad93db5865 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -5014,7 +5014,7 @@ INSERT into config.org_unit_setting_type 'coust', 'label'), oils_i18n_gettext( 'bill.prohibit_negative_balance_default', - 'Default setting to prevent negative balances (refunds) on circulation related bills', + 'Default setting to prevent negative balances (refunds) on circulation related bills. Set to "true" to prohibit negative balances at all times or, when used in conjunction with an interval setting, to prohibit negative balances after a set period of time. ', 'coust', 'description'), 'bool', null) ,( 'bill.prohibit_negative_balance_on_overdues', 'finance', @@ -5024,7 +5024,7 @@ INSERT into config.org_unit_setting_type 'coust', 'label'), oils_i18n_gettext( 'bill.prohibit_negative_balance_on_overdues', - 'Prevent negative balances (refunds) on bills for overdue materials', + 'Prevent negative balances (refunds) on bills for overdue materials. Set to "true" to prohibit negative balances at all times or, when used in conjunction with an interval setting, to prohibit negative balances after a set period of time.', 'coust', 'description'), 'bool', null) ,( 'bill.prohibit_negative_balance_on_lost', 'finance', @@ -5034,7 +5034,7 @@ INSERT into config.org_unit_setting_type 'coust', 'label'), oils_i18n_gettext( 'bill.prohibit_negative_balance_on_lost', - 'Prevent negative balances (refunds) on bills for lost/long overdue materials', + 'Prevent negative balances (refunds) on bills for lost/long overdue materials. Set to "true" to prohibit negative balances at all times or, when used in conjunction with an interval setting, to prohibit negative balances after an interval of time.', 'coust', 'description'), 'bool', null) ,( 'bill.negative_balance_interval_default', 'finance', @@ -5044,7 +5044,7 @@ INSERT into config.org_unit_setting_type 'coust', 'label'), oils_i18n_gettext( 'bill.negative_balance_interval_default', - 'Amount of time after which no negative balances (refunds) are allowed on circulation bills', + 'Amount of time after which no negative balances (refunds) are allowed on circulation bills. The "Prohibit negative balance on bills" setting must also be set to "true".', 'coust', 'description'), 'interval', null) ,( 'bill.negative_balance_interval_on_overdues', 'finance', @@ -5054,7 +5054,7 @@ INSERT into config.org_unit_setting_type 'coust', 'label'), oils_i18n_gettext( 'bill.negative_balance_interval_on_overdues', - 'Amount of time after which no negative balances (refunds) are allowed on bills for overdue materials', + 'Amount of time after which no negative balances (refunds) are allowed on bills for overdue materials. The "Prohibit negative balance on bills for overdue materials" setting must also be set to "true".', 'coust', 'description'), 'interval', null) ,( 'bill.negative_balance_interval_on_lost', 'finance', @@ -5064,7 +5064,7 @@ INSERT into config.org_unit_setting_type 'coust', 'label'), oils_i18n_gettext( 'bill.negative_balance_interval_on_lost', - 'Amount of time after which no negative balances (refunds) are allowed on bills for lost/long overdue materials', + 'Amount of time after which no negative balances (refunds) are allowed on bills for lost/long overdue materials. The "Prohibit negative balance on bills for lost materials" setting must also be set to "true".', 'coust', 'description'), 'interval', null) ; diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.update_negative_balance_OUS_descriptions.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.update_negative_balance_OUS_descriptions.sql new file mode 100644 index 0000000000..acfa2d002c --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.update_negative_balance_OUS_descriptions.sql @@ -0,0 +1,26 @@ +BEGIN; + +SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); + +UPDATE config.org_unit_setting_type + SET description = 'Default setting to prevent negative balances (refunds) on circulation related bills. Set to "true" to prohibit negative balances at all times or, when used in conjunction with an interval setting, to prohibit negative balances after a set period of time.' + WHERE name = 'bill.prohibit_negative_balance_default'; +UPDATE config.org_unit_setting_type + SET description = 'Prevent negative balances (refunds) on bills for overdue materials. Set to "true" to prohibit negative balances at all times or, when used in conjunction with an interval setting, to prohibit negative balances after a set period of time.' + WHERE name = 'bill.prohibit_negative_balance_on_overdues'; +UPDATE config.org_unit_setting_type + SET description = 'Prohibit negative balance on bills for lost materials. Set to "true" to prohibit negative balances at all times or, when used in conjunction with an interval setting, to prohibit negative balances after a set period of time.' + WHERE name = 'bill.prohibit_negative_balance_on_lost'; +UPDATE config.org_unit_setting_type + SET description = 'Amount of time after which no negative balances (refunds) are allowed on circulation bills. The "Prohibit negative balance on bills" setting must also be set to "true".' + WHERE name = 'bill.negative_balance_interval_default'; +UPDATE config.org_unit_setting_type + SET description = 'Amount of time after which no negative balances (refunds) are allowed on bills for overdue materials. The "Prohibit negative balance on bills for overdue materials" setting must also be set to "true".' + WHERE name = 'bill.negative_balance_interval_on_overdues'; +UPDATE config.org_unit_setting_type + SET description = 'Amount of time after which no negative balances (refunds) are allowed on bills for lost/long overdue materials. The "Prohibit negative balance on bills for lost materials" setting must also be set to "true".' + WHERE name = 'bill.negative_balance_interval_on_lost'; + +COMMIT; + + -- 2.11.0