Bugzilla – Attachment 150079 Details for
Bug 33365
Add item type column to call number browser's results table
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 33365: Add item type column to cn_browser results
Bug-33365-Add-item-type-column-to-cnbrowser-result.patch (text/plain), 3.32 KB, created by
Katrin Fischer
on 2023-04-22 13:46:33 UTC
(
hide
)
Description:
Bug 33365: Add item type column to cn_browser results
Filename:
MIME Type:
Creator:
Katrin Fischer
Created:
2023-04-22 13:46:33 UTC
Size:
3.32 KB
patch
obsolete
>From 49be1025b3cbf6503683f2f66f48f4ac04bdc098 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 > >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. > >Signed-off-by: David Nind <david@davidnind.com> >Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de> >--- > 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 › Cataloging › 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
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 33365
:
148941
|
148942
|
149139
| 150079 |
150080