From 368e0f509c278346aff6dd4ab9b3ec2a7d8ca422 Mon Sep 17 00:00:00 2001
From: David Gustafsson <glasklas@gmail.com>
Date: Thu, 4 Mar 2021 17:54:22 +0100
Subject: [PATCH] Bug 27884: Add html support for report mails

To test:
1) Create a new notice, for example with Koha module "Patrons",
   name/code TEST and message body "<strong>testing<strong>".
2) Create a new sql report, the query could be someting like:
   SELECT "<number>" as `borrowernumber`, "to@example.com", as `email`, "from@example.com" as `from`;
   where "<number>" is a valid borrowernumber.
3) Run patron_emailer.pl --report=<id> --notice=TEST --module=members -commit
   where <id> is the report id.
4) Check the message_queue table that the content_type column has been
   set to text/html; charset="UTF-8".
5) Ideally process the message queue and veriy that the sent email is displayed
   as rendered html.
6) Run tests in t/db_dependent/Reports/Guided.t
---
 C4/Reports/Guided.pm | 1 +
 1 file changed, 1 insertion(+)

diff --git a/C4/Reports/Guided.pm b/C4/Reports/Guided.pm
index 6611393ca0..8a6964446b 100644
--- a/C4/Reports/Guided.pm
+++ b/C4/Reports/Guided.pm
@@ -1044,6 +1044,7 @@ sub EmailReport {
         message_transport_type => 'email',
     });
     $letter = $letter->unblessed;
+    $letter->{'content-type'} = 'text/html; charset="UTF-8"' if $letter->{'is_html'};
 
     my $report = Koha::Reports->find( $report_id );
     my $sql = $report->savedsql;
-- 
2.20.1