From a304089774229b61dc43610c1810a1e36271093d Mon Sep 17 00:00:00 2001
From: Lucas Gass <lucas@bywatersolutions.com>
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' %]
 <title>Call number browser &rsaquo; Cataloging &rsaquo; Koha</title>
@@ -50,6 +51,7 @@
             <th>Title</th>
             <th>Library</th>
             <th>Collection</th>
+            <th>Item type</th>
         </tr></thead>
         <tbody>
     [% FOREACH cn_loo IN cn_loop %]
@@ -66,6 +68,7 @@
         </td>
         <td style="background:[% cn_loo.background | html %];">[% cn_loo.branchname | html %]</td>
         <td style="background:[% cn_loo.background | html %];">[% AuthorisedValues.GetByCode( 'CCODE', cn_loo.ccode ) | html %]</td>
+        <td style="background:[% cn_loo.background | html %];">[% ItemTypes.GetDescription( cn_loo.itype ) | html %]</td>
         </tr>
     [% END %]
         </tbody>
-- 
2.30.2