From eb98928ed43bd60e95f6566ac012ad2b696c1921 Mon Sep 17 00:00:00 2001
From: Petro Vashchuk <stalkernoid@gmail.com>
Date: Sat, 27 Jun 2020 00:06:47 +0300
Subject: [PATCH] Bug 25798: Add copyright year to "Holds to pull" report

Display copyright year (publication year) of book
together with title in "Holds to pull" report.

Copyright year is fetched from biblio -table as "copyrightyear"
and displayed when the preferred marc is set to MARC21.
Publication year is fetched from biblioitems -table as "publicationyear"
and displayed when the preferred marc is set to UNIMARC.

1. Place a hold on book with known copyright year.
2. Go to /cgi-bin/koha/circ/pendingreserves.pl and check the "title"
table of that book that you placed hold on.
3. Observe that there's no information about publication year in that
field.
4. Apply patch.
5. Repeat step 2.
6. Observe that copyright year (publication year) of book appeared
in the title table after book's title and author.

Mentored-by: Andrew Nugged <nugged@gmail.com>
---
 circ/pendingreserves.pl                                        | 3 +++
 .../intranet-tmpl/prog/en/modules/circ/pendingreserves.tt      | 1 +
 2 files changed, 4 insertions(+)

diff --git a/circ/pendingreserves.pl b/circ/pendingreserves.pl
index 22c93f7130..0417dfa89a 100755
--- a/circ/pendingreserves.pl
+++ b/circ/pendingreserves.pl
@@ -201,6 +201,8 @@ my $strsth =
             GROUP_CONCAT(DISTINCT items.copynumber
                     ORDER BY items.itemnumber SEPARATOR '|') l_copynumber,
             biblio.title,
+            biblio.copyrightdate,
+            biblioitems.publicationyear,
             biblio.subtitle,
             biblio.medium,
             biblio.part_number,
@@ -273,6 +275,7 @@ while ( my $data = $sth->fetchrow_hashref ) {
             holdingbranch    => $data->{holdingbranch},
             homebranch       => $data->{homebranch},
             itemnumber       => $data->{itemnumber},
+            publicationyear  => C4::Context->preference('marcflavour') eq "MARC21" ? $data->{copyrightdate} : $data->{publicationyear},
         }
     );
 }
diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/circ/pendingreserves.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/circ/pendingreserves.tt
index 7783acc707..af6c8114ff 100644
--- a/koha-tmpl/intranet-tmpl/prog/en/modules/circ/pendingreserves.tt
+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/circ/pendingreserves.tt
@@ -81,6 +81,7 @@
                 </a></p>
                 [% IF ( reserveloo.author ) %]<p> by [% reserveloo.author | html %]</p>[% END %]
                 [% IF ( reserveloo.editionstatement ) %]<p>[% reserveloo.editionstatement | html %]</p>[% END %]
+                [% IF ( reserveloo.publicationyear ) %]<p>[% reserveloo.publicationyear | html %]</p>[% END %]
             </td>
         [% ELSE %]
             <td>"</td>
-- 
2.17.1