From f143b6901bcd8a20071193960cfc727ad3e68c5b Mon Sep 17 00:00:00 2001 From: Lucas Gass Date: Mon, 12 May 2025 18:51:58 +0000 Subject: [PATCH] Bug 39880: Add shelving location to cn_browser results To test: 0. APPLY PATCH and resart_all 1. Make sure you have items with itemcallnumber's in your DB 2. Visit http://localhost:8081/cgi-bin/koha/cataloguing/plugin_launcher.pl?q=1&plugin_name=cn_browser.pl and make a search 3. You should see a column for Shelving location now --- cataloguing/value_builder/cn_browser.pl | 4 ++-- .../prog/en/modules/cataloguing/value_builder/cn_browser.tt | 2 ++ 2 files changed, 4 insertions(+), 2 deletions(-) diff --git a/cataloguing/value_builder/cn_browser.pl b/cataloguing/value_builder/cn_browser.pl index 5619a68a3c3..da1d1468e21 100755 --- a/cataloguing/value_builder/cn_browser.pl +++ b/cataloguing/value_builder/cn_browser.pl @@ -110,7 +110,7 @@ my $launcher = sub { #Results before the cn_sort $query = - "SELECT b.title, b.subtitle, itemcallnumber, biblionumber, barcode, cn_sort, branchname, author, ccode, itype + "SELECT b.title, b.subtitle, itemcallnumber, biblionumber, barcode, cn_sort, branchname, author, ccode, location, itype FROM items AS i JOIN biblio AS b USING (biblionumber) LEFT OUTER JOIN branches ON (branches.branchcode = homebranch) @@ -141,7 +141,7 @@ my $launcher = sub { #Results after the cn_sort $query = - "SELECT b.title, b.subtitle, itemcallnumber, biblionumber, barcode, cn_sort, branchname, author, ccode, itype + "SELECT b.title, b.subtitle, itemcallnumber, biblionumber, barcode, cn_sort, branchname, author, ccode, location, itype FROM items AS i JOIN biblio AS b USING (biblionumber) LEFT OUTER JOIN branches ON (branches.branchcode = homebranch) diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/cataloguing/value_builder/cn_browser.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/cataloguing/value_builder/cn_browser.tt index 2a406599ce6..65f7c378527 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/cataloguing/value_builder/cn_browser.tt +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/cataloguing/value_builder/cn_browser.tt @@ -61,6 +61,7 @@ Title Library Collection + Shelving location [% IF Koha.Preference('item-level_itypes') %] Item type [% END %] @@ -81,6 +82,7 @@ [% cn_loo.branchname | html %] [% AuthorisedValues.GetByCode( 'CCODE', cn_loo.ccode ) | html %] + [% AuthorisedValues.GetByCode( 'LOC', cn_loo.location ) | html %] [% IF Koha.Preference('item-level_itypes') %] [% ItemTypes.GetDescription( cn_loo.itype ) | html %] [% END %] -- 2.39.5