From a24f9eaa8bb0e8e5f511f4c5d07c1cba6f33fed3 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Tue, 6 Feb 2018 10:34:36 -0500 Subject: [PATCH] JBAS-1923 Add Outreach SI profile 1. New profile group under Outreach 2. checkout max set to 100 3. Add group to user editor Signed-off-by: Bill Erickson --- KCLS/sql/schema/deploy/outreach-si-profile.sql | 16 ++++++++++++++++ KCLS/sql/schema/revert/outreach-si-profile.sql | 12 ++++++++++++ KCLS/sql/schema/sqitch.plan | 1 + KCLS/sql/schema/verify/outreach-si-profile.sql | 7 +++++++ Open-ILS/web/js/ui/default/actor/user/register.js | 1 + 5 files changed, 37 insertions(+) create mode 100644 KCLS/sql/schema/deploy/outreach-si-profile.sql create mode 100644 KCLS/sql/schema/revert/outreach-si-profile.sql create mode 100644 KCLS/sql/schema/verify/outreach-si-profile.sql diff --git a/KCLS/sql/schema/deploy/outreach-si-profile.sql b/KCLS/sql/schema/deploy/outreach-si-profile.sql new file mode 100644 index 0000000000..4860b11b46 --- /dev/null +++ b/KCLS/sql/schema/deploy/outreach-si-profile.sql @@ -0,0 +1,16 @@ +-- Deploy kcls-evergreen:outreach-si-profile to pg +-- requires: at-purge-interval-data + +BEGIN; + +INSERT INTO permission.grp_tree (id, parent, name, description, perm_interval) + VALUES (1004, 18, 'Outreach SI Limit', 'Outreach Shut-In Limit', '2 years'); + +INSERT INTO permission.grp_penalty_threshold + (grp, org_unit, penalty, threshold) + VALUES (1004, 1, 3 /* PATRON_EXCEEDS_CHECKOUT_COUNT */, 100); + +-- Using hard-coded ID above. Manually bump the sequence. +SELECT SETVAL('permission.grp_tree_id_seq', 1004); + +COMMIT; diff --git a/KCLS/sql/schema/revert/outreach-si-profile.sql b/KCLS/sql/schema/revert/outreach-si-profile.sql new file mode 100644 index 0000000000..91ff88b805 --- /dev/null +++ b/KCLS/sql/schema/revert/outreach-si-profile.sql @@ -0,0 +1,12 @@ +-- Revert kcls-evergreen:outreach-si-profile from pg + +BEGIN; + +DELETE FROM permission.grp_penalty_threshold +WHERE grp = 1004 + AND penalty = 3 -- PATRON_EXCEEDS_CHECKOUT_COUNT + AND threshold = 100; + +DELETE FROM permission.grp_tree WHERE id = 1004; + +COMMIT; diff --git a/KCLS/sql/schema/sqitch.plan b/KCLS/sql/schema/sqitch.plan index f3f574a9d5..2c081f3c89 100644 --- a/KCLS/sql/schema/sqitch.plan +++ b/KCLS/sql/schema/sqitch.plan @@ -60,4 +60,5 @@ auth-prop-partial-matches [2.9-to-2.10-upgrade-reingest] 2017-09-29T15:47:04Z Bi at-purge-interval [2.9-to-2.10-upgrade-reingest] 2017-10-23T15:31:00Z Bill Erickson,,, # A/T Purge schema changes at-purge-interval-data [at-purge-interval] 2017-10-23T15:31:23Z Bill Erickson,,, # A/T Purge data cleanup hold-queue-pos-func [at-purge-interval-data] 2018-03-11T16:31:04Z Bill Erickson,,, # Hold queue position function +outreach-si-profile [at-purge-interval-data] 2018-02-06T15:18:44Z Bill Erickson,,, # New Outreach SI profile 2.10-to-2.12-upgrade [at-purge-interval-data] 2018-01-29T21:03:38Z Bill Erickson,,, # KCLS 2.10 to 2.12 SQL Upgrade diff --git a/KCLS/sql/schema/verify/outreach-si-profile.sql b/KCLS/sql/schema/verify/outreach-si-profile.sql new file mode 100644 index 0000000000..ff67bb3b38 --- /dev/null +++ b/KCLS/sql/schema/verify/outreach-si-profile.sql @@ -0,0 +1,7 @@ +-- Verify kcls-evergreen:outreach-si-profile on pg + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; diff --git a/Open-ILS/web/js/ui/default/actor/user/register.js b/Open-ILS/web/js/ui/default/actor/user/register.js index 0921463703..f12c2ecf50 100644 --- a/Open-ILS/web/js/ui/default/actor/user/register.js +++ b/Open-ILS/web/js/ui/default/actor/user/register.js @@ -1414,6 +1414,7 @@ function trimGrpTree(autoWidget) { 1003, //ADA Circulation 35, //Outreach Service 34, //Outreach Staff Only + 1004, //Outreach SI Limit 901, //Student Ecard 903, //Teacher Ecard 902, //Classroom Databases -- 2.11.0