From 6f677493438eb2226278304ce903cc6a2c1554e0 Mon Sep 17 00:00:00 2001
From: Katrin Fischer <katrin.fischer@bsz-bw.de>
Date: Fri, 7 Jul 2023 16:10:30 +0000
Subject: [PATCH] Bug 34230: Add part_name and part_number to subscription
 search results

This adds biblio.part_name and biblio.part_number to the SELECT of
SearchSubscriptions in order to be able to display the information in
the results list. It does not affect search.

To test:
* Add one or more subscriptions
* Make sure at least one is linked to a title with 245$abnp
* Verify that the result list only shows 245$ab
* Apply patch
* Verify full title information is now shown
---
 C4/Serials.pm                                                   | 2 ++
 .../intranet-tmpl/prog/en/modules/serials/serials-search.tt     | 2 +-
 2 files changed, 3 insertions(+), 1 deletion(-)

diff --git a/C4/Serials.pm b/C4/Serials.pm
index 31a61c05fa..c7105d8248 100644
--- a/C4/Serials.pm
+++ b/C4/Serials.pm
@@ -535,6 +535,8 @@ sub SearchSubscriptions {
             biblio.notes AS biblionotes,
             biblio.title,
             biblio.subtitle,
+            biblio.part_number,
+            biblio.part_name,
             biblio.author,
             biblio.biblionumber,
             aqbooksellers.name AS vendorname,
diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/serials/serials-search.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/serials/serials-search.tt
index 2ee33a3ba5..e5f8cf49f6 100644
--- a/koha-tmpl/intranet-tmpl/prog/en/modules/serials/serials-search.tt
+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/serials/serials-search.tt
@@ -98,7 +98,7 @@
                                     [% END %]
                                 </td>
                                 <td>
-                                    <a href="/cgi-bin/koha/serials/subscription-detail.pl?subscriptionid=[% subscription.subscriptionid | uri %]" class="button" title="subscription detail">[% subscription.title | html %] [% subscription.subtitle | html %]</a>
+                                    <a href="/cgi-bin/koha/serials/subscription-detail.pl?subscriptionid=[% subscription.subscriptionid | uri %]" class="button" title="subscription detail">[% subscription.title | html %] [% subscription.subtitle | html %] [% subscription.part_number | html %] [%subscription.part_name | html %]</a>
                                 </td>
                                 <td>
                                     [% IF ( subscription.publicnotes ) %][% subscription.publicnotes | html %][% END %]
-- 
2.30.2