Bugzilla – Attachment 182318 Details for
Bug 39880
Add shelving location to cn_browser.tt
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 39880: Add shelving location to cn_browser results
Bug-39880-Add-shelving-location-to-cnbrowser-resul.patch (text/plain), 3.32 KB, created by
David Nind
on 2025-05-13 02:46:31 UTC
(
hide
)
Description:
Bug 39880: Add shelving location to cn_browser results
Filename:
MIME Type:
Creator:
David Nind
Created:
2025-05-13 02:46:31 UTC
Size:
3.32 KB
patch
obsolete
>From bad5c8fe2ef6f0f36795cbcbbb7929774263d612 Mon Sep 17 00:00:00 2001 >From: Lucas Gass <lucas@bywatersolutions.com> >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 > >Signed-off-by: David Nind <david@davidnind.com> >--- > 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 5619a68a3c..da1d1468e2 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 2a406599ce..65f7c37852 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 @@ > <th>Title</th> > <th>Library</th> > <th>Collection</th> >+ <th>Shelving location</th> > [% IF Koha.Preference('item-level_itypes') %] > <th>Item type</th> > [% END %] >@@ -81,6 +82,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 %];">[% AuthorisedValues.GetByCode( 'LOC', cn_loo.location ) | html %]</td> > [% IF Koha.Preference('item-level_itypes') %] > <td style="background:[% cn_loo.background | html %];">[% ItemTypes.GetDescription( cn_loo.itype ) | html %]</td> > [% END %] >-- >2.39.5
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 39880
:
182303
| 182318