From 58afad953365b3a7a2380120a4b434e22525a03b Mon Sep 17 00:00:00 2001 From: Lucas Gass Date: Mon, 7 Feb 2022 19:02:53 +0000 Subject: [PATCH] Bug 30039: Add published on column to claims.pl To test: 1. Have a vendor setup 2. Go to serials and add a new serial w/ that vendor. 3. When creating a serial make this first issues sometime in the past. 4. Go to Claims, choose your vendor and load the table. 5. No published on column. 6. Apply patch 7. Try step 4 again and now you should see a published on column. --- C4/Serials.pm | 4 ++-- .../intranet-tmpl/prog/en/modules/serials/claims.tt | 12 +++++++++--- 2 files changed, 11 insertions(+), 5 deletions(-) diff --git a/C4/Serials.pm b/C4/Serials.pm index acc387f4f7..0cda137323 100644 --- a/C4/Serials.pm +++ b/C4/Serials.pm @@ -1863,7 +1863,7 @@ sub GetLateOrMissingIssues { serialid, aqbooksellerid, name, biblio.title, biblioitems.issn, planneddate, serialseq, serial.status, serial.subscriptionid, claimdate, claims_count, - subscription.branchcode + subscription.branchcode, serial.publisheddate FROM serial LEFT JOIN subscription ON serial.subscriptionid=subscription.subscriptionid LEFT JOIN biblio ON subscription.biblionumber=biblio.biblionumber @@ -1881,7 +1881,7 @@ sub GetLateOrMissingIssues { serialid, aqbooksellerid, name, biblio.title, planneddate, serialseq, serial.status, serial.subscriptionid, claimdate, claims_count, - subscription.branchcode + subscription.branchcode, serial.publisheddate FROM serial LEFT JOIN subscription ON serial.subscriptionid=subscription.subscriptionid LEFT JOIN biblio ON subscription.biblionumber=biblio.biblionumber diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/serials/claims.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/serials/claims.tt index 7f3615b458..46e4621ecd 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/serials/claims.tt +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/serials/claims.tt @@ -2,6 +2,7 @@ [% USE Asset %] [% USE AuthorisedValues %] [% USE Branches %] +[% USE KohaDates %] [% SET footerjs = 1 %] [% INCLUDE 'doc-head-open.inc' %] [% IF ( supplierid ) -%] Claims for [% suppliername | html %] [% END %] › Claims › Serials › Koha @@ -117,6 +118,7 @@ Issue number Status Since + Published on Claims count Claim date [% FOR field IN additional_fields_for_subscription %] @@ -134,10 +136,11 @@ - - + + + [% FOR field IN additional_fields_for_subscription %] - + [% END %] @@ -170,6 +173,9 @@ [% missingissue.planneddate | html %] + + [% missingissue.publisheddate | $KohaDates %] + [% missingissue.claims_count | html %] [% missingissue.claimdate | html %] -- 2.20.1