From c11acdd76770154aa3aba49e7231a9d05d0f4c87 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Thu, 3 Dec 2015 14:20:38 -0500 Subject: [PATCH] support the LOST_AND_PAID status added in LP#1198475 Signed-off-by: Galen Charlton Signed-off-by: Galen Charlton --- Open-ILS/src/sql/Pg/040.schema.asset.sql | 3 +++ Open-ILS/src/sql/Pg/upgrade/XXXX.schema.copy_alerts.sql | 3 +++ 2 files changed, 6 insertions(+) diff --git a/Open-ILS/src/sql/Pg/040.schema.asset.sql b/Open-ILS/src/sql/Pg/040.schema.asset.sql index 0bf70a5ead..d17dcfaa9c 100644 --- a/Open-ILS/src/sql/Pg/040.schema.asset.sql +++ b/Open-ILS/src/sql/Pg/040.schema.asset.sql @@ -1002,6 +1002,8 @@ BEGIN RETURN 'MISSING'; ELSIF the_copy.status = 14 THEN -- Damaged RETURN 'DAMAGED'; + ELSIF the_copy.status = 17 THEN -- Lost and paid + RETURN 'LOST_AND_PAID'; END IF; SELECT stop_fines INTO last_circ_stop @@ -1026,6 +1028,7 @@ $$ LANGUAGE PLPGSQL; CREATE TYPE config.copy_alert_type_state AS ENUM ( 'NORMAL', 'LOST', + 'LOST_AND_PAID', 'MISSING', 'DAMAGED', 'CLAIMSRETURNED', diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.copy_alerts.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.copy_alerts.sql index 054e365480..db4cd25cc0 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.copy_alerts.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.copy_alerts.sql @@ -15,6 +15,8 @@ BEGIN RETURN 'MISSING'; ELSIF the_copy.status = 14 THEN -- Damaged RETURN 'DAMAGED'; + ELSIF the_copy.status = 17 THEN -- Lost and paid + RETURN 'LOST_AND_PAID'; END IF; SELECT stop_fines INTO last_circ_stop @@ -39,6 +41,7 @@ $$ LANGUAGE PLPGSQL; CREATE TYPE config.copy_alert_type_state AS ENUM ( 'NORMAL', 'LOST', + 'LOST_AND_PAID', 'MISSING', 'DAMAGED', 'CLAIMSRETURNED', -- 2.11.0