From a304089774229b61dc43610c1810a1e36271093d 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 --- 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