Attachment 147172 Details for Bug 33040 – Bug 33040: Add "Date published (text)" to serials tab on record view (detail.pl)

[patch] Bug 33040: Add "Date published (text)" to serials tab on record view (detail.pl)

Bug-33040-Add-Date-published-text-to-serials-tab-o.patch (text/plain), 2.80 KB, created by Kyle M Hall (khall) on 2023-02-22 16:10:31 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Kyle M Hall (khall)

Created: 2023-02-22 16:10:31 UTC

Size: 2.80 KB

patch

obsolete

>From 1c031ed7b3cc9b463c45b296f23135508146b5dc Mon Sep 17 00:00:00 2001
>From: Kyle Hall <kyle@bywatersolutions.com>
>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.
>                     <th>Issue #</th>
>                     <th>Date arrived</th>
>                     <th>Date published</th>
>+                    <th>Date published (text)</th>
>                     <th>Status</th>
>                     <th>Note</th>
>                 </tr>
>@@ -805,6 +806,7 @@ Note that permanent location is a code, and location may be an authval.
>                     <td>[% latestserial.serialseq | html %]</td>
>                     <td data-order="[% latestserial.planneddate | html %]">[% latestserial.planneddate | $KohaDates %]</td>
>                     <td data-order="[% latestserial.publisheddate | html %]">[% latestserial.publisheddate | $KohaDates %]</td>
>+                    <td>[% latestserial.publisheddatetext | html %]</td>
>                     <td>
>                       [% IF ( latestserial.status1 ) %]<span>Expected</span>[% END %]
>                       [% IF ( latestserial.status2 ) %]<span>Arrived</span>[% END %]
>-- 
>2.30.2

Actions: View | Diff | Splinter Review

Attachments on bug 33040: 147172 | 147177 | 149111