From 13435ac95905f090402d068a8bba8c640da04ce6 Mon Sep 17 00:00:00 2001 From: Jason Stephenson Date: Wed, 12 Oct 2011 10:50:53 -0400 Subject: [PATCH] Alter asset.acp_status_changed() function for restrict_copy_delete. Add a check for a change to the deleted field to true and then check if the new status restricts copy deletion. If so, set the deleted to FALSE in the NEW row. Signed-off-by: Jason Stephenson --- Open-ILS/src/sql/Pg/040.schema.asset.sql | 5 +++++ 1 file changed, 5 insertions(+) diff --git a/Open-ILS/src/sql/Pg/040.schema.asset.sql b/Open-ILS/src/sql/Pg/040.schema.asset.sql index f80b2d11fb..30c62a33c9 100644 --- a/Open-ILS/src/sql/Pg/040.schema.asset.sql +++ b/Open-ILS/src/sql/Pg/040.schema.asset.sql @@ -123,6 +123,11 @@ BEGIN NEW.active_date := now(); END IF; END IF; + IF NEW.deleted <> OLD.deleted AND NEW.deleted = TRUE THEN + IF NEW.status IN (SELECT id FROM config.copy_status WHERE restrict_copy_delete = TRUE) THEN + NEW.deleted := FALSE; + END IF; + END IF; RETURN NEW; END; $$ LANGUAGE plpgsql; -- 2.11.0