From f625baeef0afa1b3fecf673c79d6e48daf775d07 Mon Sep 17 00:00:00 2001
From: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Date: Tue, 7 May 2024 17:45:08 +0100
Subject: [PATCH] Bug 36758: Add TICKET_ASSIGNED notice

This patch adds a new default TICKET_ASSIGNED notice to be used with
catalog concerns to notice the assigned staff user when a ticket has
been assigned to them.

Test plan
1) Run the database update and confirm that the new notice has been
   added to the database (If on the sandboxes, skip to the next patch)

Signed-off-by: David Nind <david@davidnind.com>

Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
Signed-off-by: Katrin Fischer <katrin.fischer@bsz-bw.de>
---
 installer/data/mysql/atomicupdate/bug_36757.pl | 16 ++++++++++++++++
 .../data/mysql/en/mandatory/sample_notices.yml | 18 ++++++++++++++++++
 2 files changed, 34 insertions(+)
 create mode 100755 installer/data/mysql/atomicupdate/bug_36757.pl

diff --git a/installer/data/mysql/atomicupdate/bug_36757.pl b/installer/data/mysql/atomicupdate/bug_36757.pl
new file mode 100755
index 0000000000..00a531ff6b
--- /dev/null
+++ b/installer/data/mysql/atomicupdate/bug_36757.pl
@@ -0,0 +1,16 @@
+use Modern::Perl;
+
+return {
+    bug_number  => "36757",
+    description => "Notify assignee when a concern is assigned to them",
+    up          => sub {
+        my ($args) = @_;
+        my ( $dbh, $out ) = @$args{qw(dbh out)};
+
+        $dbh->do(
+            q{INSERT IGNORE INTO letter (module, code, branchcode, name, is_html, title, message_transport_type, lang, content) VALUES ("catalogue", "TICKET_ASSIGNED", "", "Concern assigned notification", 1, "Catalog concern assigned", "email", "default", "[%- PROCESS 'html_helpers.inc' -%][%- USE Koha -%]Dear cataloger,<br>[%- INCLUDE 'patron-title.inc' patron => libraian -%] has assigned the following concern with <a href='[%- Koha.Preference('staffClientBaseURL') -%]/cgi-bin/koha/catalogue/detail.pl?biblionumber=[% ticket.biblio.biblionumber %]' >[%- INCLUDE 'biblio-title.inc' biblio=ticket.biblio link = 0 -%]</a> to you<br><br>[%- ticket.body -%]<br><br>You can action this concern from the <a href='[%- Koha.Preference('staffClientBaseURL') -%]/cgi-bin/koha/cataloguing/concerns.pl'>concern management page</a>.")}
+        );
+
+        say $out "Added notice 'TICKET_ASSIGNED'";
+    },
+};
diff --git a/installer/data/mysql/en/mandatory/sample_notices.yml b/installer/data/mysql/en/mandatory/sample_notices.yml
index 2b01624e7f..f075667e98 100644
--- a/installer/data/mysql/en/mandatory/sample_notices.yml
+++ b/installer/data/mysql/en/mandatory/sample_notices.yml
@@ -62,6 +62,24 @@ tables:
             - "<br>"
             - "Thank you"
 
+        - module: catalogue
+          code: TICKET_ASSIGNED
+          branchcode: ""
+          name: "Concern assigned notification"
+          is_html: 1
+          title: "Catalog concern assigned"
+          message_transport_type: email
+          lang: default
+          content:
+            - "[%- PROCESS 'html_helpers.inc' -%]"
+            - "[%- USE Koha -%]"
+            - "Dear cataloger,<br>"
+            - "[%- INCLUDE 'patron-title.inc' patron => libraian -%] has assigned the following concern with <a href='[%- Koha.Preference('staffClientBaseURL') -%]/cgi-bin/koha/catalogue/detail.pl?biblionumber=[% ticket.biblio.biblionumber %]' >[%- INCLUDE 'biblio-title.inc' biblio=ticket.biblio link = 0 -%]</a> to you<br>"
+            - "<br>"
+            - "[%- ticket.body -%]<br>"
+            - "<br>"
+            - "You can action this concern from the <a href='[%- Koha.Preference('staffClientBaseURL') -%]/cgi-bin/koha/cataloguing/concerns.pl'>concern management page</a>."
+
         - module: catalogue
           code: TICKET_RESOLVE
           branchcode: ""
-- 
2.39.5