From 0984389460bee8b895e437375827174748f8c113 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 Signed-off-by: Katrin Fischer Signed-off-by: Tomas Cohen Arazi (cherry picked from commit d8b63b05e938e58997950617e55af303a03b4ec3) Signed-off-by: Lucas Gass --- 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.39.5