From db88e1be51e1e189ad05fb5e8bbb167d6683b68a Mon Sep 17 00:00:00 2001 From: David Gustafsson 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 "testing". 2) Create a new sql report, the query could be someting like: SELECT "" as `borrowernumber`, "to@example.com", as `email`, "from@example.com" as `from`; where "" is a valid borrowernumber. 3) Run patron_emailer.pl --report= --notice=TEST --module=members -commit where 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 Signed-off-by: David Nind --- 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