From 5bb1676bc8054373f50600bea1deb6cf6e342e56 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 9c9278a7f2..f64438c963 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