From d8af621238e3dadb88a52c8ab9c0dfbd27b865e5 Mon Sep 17 00:00:00 2001 From: Lucas Gass Date: Wed, 29 Mar 2023 22:58:34 +0000 Subject: [PATCH] Bug 33365: Add item type column to cn_browser results To test: 1. Go to MARC bibliographic framework, pick a framework and go to 952, subfield "o". Turn the cn_browser plugin on. 2. Pick or create an item in that framework, edit that item. 3. TO the right of the 952$o notice the "...". Click that start the call number browser. 4. Notice there is no column for item type. 5. Apply patch, restart_all 6. Notice there is now a column for item type. --- cataloguing/value_builder/cn_browser.pl | 4 ++-- .../prog/en/modules/cataloguing/value_builder/cn_browser.tt | 3 +++ 2 files changed, 5 insertions(+), 2 deletions(-) diff --git a/cataloguing/value_builder/cn_browser.pl b/cataloguing/value_builder/cn_browser.pl index 41e7c2d738..55128fc7bc 100755 --- a/cataloguing/value_builder/cn_browser.pl +++ b/cataloguing/value_builder/cn_browser.pl @@ -95,7 +95,7 @@ my $launcher = sub { my $green = 0; #Results before the cn_sort - $query = "SELECT b.title, b.subtitle, itemcallnumber, biblionumber, barcode, cn_sort, branchname, author, ccode + $query = "SELECT b.title, b.subtitle, itemcallnumber, biblionumber, barcode, cn_sort, branchname, author, ccode, itype FROM items AS i JOIN biblio AS b USING (biblionumber) LEFT OUTER JOIN branches ON (branches.branchcode = homebranch) @@ -125,7 +125,7 @@ my $launcher = sub { my $green = 0; #Results after the cn_sort - $query = "SELECT b.title, b.subtitle, itemcallnumber, biblionumber, barcode, cn_sort, branchname, author, ccode + $query = "SELECT b.title, b.subtitle, itemcallnumber, biblionumber, barcode, cn_sort, branchname, author, ccode, 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 591a646dca..38f1896b08 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 @@ -1,5 +1,6 @@ [% USE Asset %] [% USE AuthorisedValues %] +[% USE ItemTypes %] [% SET footerjs = 1 %] [% INCLUDE 'doc-head-open.inc' %] Call number browser › Cataloging › Koha @@ -50,6 +51,7 @@ Title Library Collection + Item type [% FOREACH cn_loo IN cn_loop %] @@ -66,6 +68,7 @@ [% cn_loo.branchname | html %] [% AuthorisedValues.GetByCode( 'CCODE', cn_loo.ccode ) | html %] + [% ItemTypes.GetDescription( cn_loo.itype ) | html %] [% END %] -- 2.30.2