From 1c031ed7b3cc9b463c45b296f23135508146b5dc Mon Sep 17 00:00:00 2001 From: Kyle Hall Date: Wed, 22 Feb 2023 10:55:41 -0500 Subject: [PATCH] Bug 33040: Add "Date published (text)" to serials tab on record view (detail.pl) Some libraries would like to see the "Date published (text)" in the serials tab on the "Normal" record view ( aka catalogue/detail.pl ). Test Plan: 1) View the serials tab on detail.pl for a subscription where the latest serial has a "Date published (text)" field populated. 2) Apply this patch 3) Restart all the thigns! 4) Browse to detail.pl for that record 5) View the Subscriptions tab 6) Note the "Date published (text)" column exists now! --- C4/Serials.pm | 2 +- koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/detail.tt | 2 ++ 2 files changed, 3 insertions(+), 1 deletion(-) diff --git a/C4/Serials.pm b/C4/Serials.pm index 0b4ab841f3..664ef6fc9c 100644 --- a/C4/Serials.pm +++ b/C4/Serials.pm @@ -749,7 +749,7 @@ sub GetLatestSerials { my $dbh = C4::Context->dbh; my $statuses = join( ',', ( ARRIVED, MISSING_STATUSES ) ); - my $strsth = "SELECT serialid,serialseq, status, planneddate, publisheddate, notes + my $strsth = "SELECT serialid,serialseq, status, planneddate, publisheddate, publisheddatetext, notes FROM serial WHERE subscriptionid = ? AND status IN ($statuses) diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/detail.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/detail.tt index 2e20d2e520..21c747e445 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/detail.tt +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/detail.tt @@ -797,6 +797,7 @@ Note that permanent location is a code, and location may be an authval. Issue # Date arrived Date published + Date published (text) Status Note @@ -805,6 +806,7 @@ Note that permanent location is a code, and location may be an authval. [% latestserial.serialseq | html %] [% latestserial.planneddate | $KohaDates %] [% latestserial.publisheddate | $KohaDates %] + [% latestserial.publisheddatetext | html %] [% IF ( latestserial.status1 ) %]Expected[% END %] [% IF ( latestserial.status2 ) %]Arrived[% END %] -- 2.30.2