From c946b3c3ac4d1dbc8415ea6f7e95ea1e70c91a28 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Marc=20V=C3=A9ron?= Date: Fri, 7 Apr 2017 11:34:28 +0200 Subject: [PATCH] Bug 18397 - Sent notices for...: Display email addresses (sender / recipient) This patch adds the colums Sender and Recipient to the table of sent notices in Home > Patrons > Sent notices for... Related to Bug 18397 - Sent notices for...: Display email addresses (sender / recipient) To test: - Appply patch - Go to a patron's page for sent notices (members/notices.pl) - Verify that two new columns display sender and recipient - Use this patch to test 18397 --- C4/Letters.pm | 2 +- koha-tmpl/intranet-tmpl/prog/en/modules/members/notices.tt | 8 ++++++-- 2 files changed, 7 insertions(+), 3 deletions(-) diff --git a/C4/Letters.pm b/C4/Letters.pm index 74263f0..6c62f67 100644 --- a/C4/Letters.pm +++ b/C4/Letters.pm @@ -1113,7 +1113,7 @@ sub GetQueuedMessages { my $dbh = C4::Context->dbh(); my $statement = << 'ENDSQL'; -SELECT message_id, borrowernumber, subject, content, message_transport_type, status, time_queued +SELECT message_id, borrowernumber, subject, content, message_transport_type, status, time_queued, from_address, to_address FROM message_queue ENDSQL diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/members/notices.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/members/notices.tt index cea5b0d..381413f 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/members/notices.tt +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/members/notices.tt @@ -11,8 +11,8 @@ // Notice Type + Sender + Recipient Status Time @@ -69,6 +71,8 @@ [% ELSIF ( QUEUED_MESSAGE.message_transport_type == 'sms' ) %]sms [% ELSE %][% QUEUED_MESSAGE.message_transport_type %][% END %] + [% QUEUED_MESSAGE.from_address %] + [% QUEUED_MESSAGE.to_address %] [% IF ( QUEUED_MESSAGE.status == 'sent' ) %]sent [% ELSIF ( QUEUED_MESSAGE.status == 'pending' ) %]pending -- 2.1.4