From a03bce36bb88726507396618127b50e4460e9dc2 Mon Sep 17 00:00:00 2001 From: Aleisha Amohia Date: Mon, 4 Oct 2021 17:21:14 +1300 Subject: [PATCH] Bug 31391: Recalled authorised value for hold cancellation Signed-off-by: David Signed-off-by: David Nind Signed-off-by: Pedro Amorim --- ..._HOLD_CANCELLATION-RECALLED_authorised_value.pl | 14 ++++++++++++++ installer/data/mysql/en/optional/auth_val.yml | 6 +++++- 2 files changed, 19 insertions(+), 1 deletion(-) create mode 100644 installer/data/mysql/atomicupdate/bug_31391_-_add_HOLD_CANCELLATION-RECALLED_authorised_value.pl diff --git a/installer/data/mysql/atomicupdate/bug_31391_-_add_HOLD_CANCELLATION-RECALLED_authorised_value.pl b/installer/data/mysql/atomicupdate/bug_31391_-_add_HOLD_CANCELLATION-RECALLED_authorised_value.pl new file mode 100644 index 00000000000..ad7aae45309 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_31391_-_add_HOLD_CANCELLATION-RECALLED_authorised_value.pl @@ -0,0 +1,14 @@ +use Modern::Perl; + +return { + bug_number => "31391", + description => "Add new RECALLED value to HOLD_CANCELLATION authorised value category", + up => sub { + my ($args) = @_; + my ( $dbh, $out ) = @$args{qw(dbh out)}; + + $dbh->do( + q{ INSERT IGNORE INTO authorised_values (category, authorised_value, lib) VALUES ('HOLD_CANCELLATION','RECALLED','Hold was converted to a recall') } + ); + }, +}; diff --git a/installer/data/mysql/en/optional/auth_val.yml b/installer/data/mysql/en/optional/auth_val.yml index 62197838f9a..15c58152b38 100644 --- a/installer/data/mysql/en/optional/auth_val.yml +++ b/installer/data/mysql/en/optional/auth_val.yml @@ -321,6 +321,10 @@ tables: authorised_value: "DAMAGED" lib: "Item was found to be too damaged to fill hold" + - category: "HOLD_CANCELLATION" + authorised_value: "RECALLED" + lib: "Hold was converted to a recall" + # article request cancellations - category: "AR_CANCELLATION" authorised_value: "NOT_FOUND" @@ -332,4 +336,4 @@ tables: - category: "AR_CANCELLATION" authorised_value: "OPAC" - lib: "Cancelled from the OPAC user page" + lib: "Cancelled from the OPAC user page" \ No newline at end of file -- 2.34.1