From 0984389460bee8b895e437375827174748f8c113 Mon Sep 17 00:00:00 2001
From: Lucas Gass <lucas@bywatersolutions.com>
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 <oleonard@myacpl.org>

Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
(cherry picked from commit d8b63b05e938e58997950617e55af303a03b4ec3)

Signed-off-by: Lucas Gass <lucas@bywatersolutions.com>
---
 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' %]
     <title>[% IF ( supplierid ) -%] Claims for [% suppliername | html %] &rsaquo; [% END %] Claims &rsaquo; Serials &rsaquo; Koha</title>
@@ -130,6 +131,7 @@
                                         <th>Issue number</th>
                                         <th>Status</th>
                                         <th>Since</th>
+                                        <th>Published on</th>
                                         <th>Claims count</th>
                                         <th>Claim date</th>
                                         [% FOR field IN additional_fields_for_subscription %]
@@ -167,6 +169,9 @@
                                             <td class="planneddate" data-order="[% missingissue.planneddateISO | html %]">
                                                 [% missingissue.planneddate | html %]
                                             </td>
+                                            <td class="publisheddate" data-order="[% missingissue.publisheddate | html %]">
+                                                [% missingissue.publisheddate | $KohaDates %]
+                                            </td>
                                             <td>[% missingissue.claims_count | html %]</td>
                                             <td data-order="[% missingissue.claimdateISO | html %]">
                                                 [% missingissue.claimdate | html %]
@@ -191,10 +196,11 @@
                                         <td><input type="text" class="filter" data-column_num="5" placeholder="Search issue number" /></td>
                                         <td><input type="text" class="filter" data-column_num="6" placeholder="Search status" /></td>
                                         <td><input type="text" class="filter" data-column_num="7" placeholder="Search since" /></td>
-                                        <td><input type="text" class="filter" data-column_num="8" placeholder="Search claim count" /></td>
-                                        <td><input type="text" class="filter" data-column_num="9" placeholder="Search claim date" /></td>
+                                        <td><input type="text" class="filter" data-column_num="8" placeholder="Search published on" /></td>
+                                        <td><input type="text" class="filter" data-column_num="9" placeholder="Search claim count" /></td>
+                                        <td><input type="text" class="filter" data-column_num="10" placeholder="Search claim date" /></td>
                                         [% FOR field IN additional_fields_for_subscription %]
-                                            <td><input type="text" class="filter" data-column_num="[% loop.count + 9 | html %]" placeholder="Search [% field.name | html %]" /></td>
+                                            <td><input type="text" class="filter" data-column_num="[% loop.count + 10 | html %]" placeholder="Search [% field.name | html %]" /></td>
                                         [% END %]
                                     </tr>
                                 </tfoot>
-- 
2.39.5