From 67859c0a5114982d976c53090748f990500ba447 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. Signed-off-by: Owen Leonard --- 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 93c8a759d9..1da5058801 100644 --- a/C4/Serials.pm +++ b/C4/Serials.pm @@ -1867,7 +1867,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 @@ -1885,7 +1885,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 9966c18f6b..7f9b5f964b 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 @@ -130,6 +131,7 @@ Issue number Status Since + Published on Claims count Claim date [% FOR field IN additional_fields_for_subscription %] @@ -167,6 +169,9 @@ [% missingissue.planneddate | html %] + + [% missingissue.publisheddate | $KohaDates %] + [% missingissue.claims_count | html %] [% missingissue.claimdate | html %] @@ -191,10 +196,11 @@ - - + + + [% FOR field IN additional_fields_for_subscription %] - + [% END %] -- 2.37.0