From 038ac93103a6a36d44738b28cfb1ccdd7a548023 Mon Sep 17 00:00:00 2001
From: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Date: Thu, 21 Dec 2023 15:57:41 +0000
Subject: [PATCH] Bug 32435: Add TICKET_RESOLUTION authorized value

Signed-off-by: David Nind <david@davidnind.com>
Signed-off-by: Ray Delahunty <lib-systems@arts.ac.uk>
Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Signed-off-by: Katrin Fischer <katrin.fischer@bsz-bw.de>
---
 installer/data/mysql/atomicupdate/bug_32435.pl   | 16 ++++++++++++++++
 installer/data/mysql/mandatory/auth_val_cat.sql  |  3 ++-
 .../prog/en/modules/admin/authorised_values.tt   |  2 ++
 3 files changed, 20 insertions(+), 1 deletion(-)
 create mode 100755 installer/data/mysql/atomicupdate/bug_32435.pl

diff --git a/installer/data/mysql/atomicupdate/bug_32435.pl b/installer/data/mysql/atomicupdate/bug_32435.pl
new file mode 100755
index 0000000000..5df61116f0
--- /dev/null
+++ b/installer/data/mysql/atomicupdate/bug_32435.pl
@@ -0,0 +1,16 @@
+use Modern::Perl;
+
+return {
+    bug_number  => "32435",
+    description => "Add ticket resolutions to catalog concerns",
+    up          => sub {
+        my ($args) = @_;
+        my ( $dbh, $out ) = @$args{qw(dbh out)};
+        $dbh->do(
+            q{
+            INSERT IGNORE INTO authorised_value_categories( category_name, is_system ) VALUES ('TICKET_RESOLUTION', 1);
+        }
+        );
+        say $out "Added TICKET_RESOLUTION authorised value category";
+    },
+};
diff --git a/installer/data/mysql/mandatory/auth_val_cat.sql b/installer/data/mysql/mandatory/auth_val_cat.sql
index a867be43da..be8ef55bff 100644
--- a/installer/data/mysql/mandatory/auth_val_cat.sql
+++ b/installer/data/mysql/mandatory/auth_val_cat.sql
@@ -99,4 +99,5 @@ VALUES
 -- For ticket statuses
 INSERT IGNORE INTO authorised_value_categories (category_name, is_system)
 VALUES
-    ('TICKET_STATUS', 1);
+    ('TICKET_STATUS', 1),
+    ('TICKET_RESOLUTION', 1);
diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/authorised_values.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/authorised_values.tt
index c93408efd1..74543db7f7 100644
--- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/authorised_values.tt
+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/authorised_values.tt
@@ -517,6 +517,8 @@
             <p>Terms to be used in Course Reserves module. Enter terms that will show in the drop down menu when setting up a Course reserve. (For example: Spring, Summer, Winter, Fall).</p>
         [% CASE 'TICKET_STATUS' %]
             <p>A list of custom status values for tickets that can be used in addition to the default values of "New" and "Resolved".</p>
+        [% CASE 'TICKET_RESOLUTION' %]
+            <p>A list of custom resolution values for tickets that can be used in addition to the standard "Resolved".</p>
         [% CASE 'UPLOAD' %]
             <p>Categories to be assigned to file uploads. Without a category an upload is considered temporary and may be removed during automated cleanup.</p>
         [% CASE 'VENDOR_TYPE' %]
-- 
2.39.5