Attachment 135970 Details for Bug 30716 – Bug 30716: Add collection to cn_browser results

[patch] Bug 30716: Add collection to cn_browser results

Bug-30716-Add-collection-to-cnbrowser-results.patch (text/plain), 3.13 KB, created by Katrin Fischer on 2022-06-12 12:04:34 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Katrin Fischer

Created: 2022-06-12 12:04:34 UTC

Size: 3.13 KB

patch

obsolete

>From aaceb4d8d2ebdcd684eaab460486321081b8db7a Mon Sep 17 00:00:00 2001
>From: Lucas Gass <lucas@bywatersolutions.com>
>Date: Fri, 6 May 2022 21:50:05 +0000
>Subject: [PATCH] Bug 30716: Add collection 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 collection.
>5. Apply patch, restart_all
>6. Notice there is now a column for with the items collection.
>
>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 8abdca75df..832ca51bf2 100755
>--- a/cataloguing/value_builder/cn_browser.pl
>+++ b/cataloguing/value_builder/cn_browser.pl
>@@ -94,7 +94,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
>+        $query = "SELECT b.title, b.subtitle, itemcallnumber, biblionumber, barcode, cn_sort, branchname, author, ccode
>         FROM items AS i
>         JOIN biblio AS b USING (biblionumber)
>         LEFT OUTER JOIN branches ON (branches.branchcode = homebranch)
>@@ -124,7 +124,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
>+        $query = "SELECT b.title, b.subtitle, itemcallnumber, biblionumber, barcode, cn_sort, branchname, author, ccode
>         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 c480e095ee..dc239e2624 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,4 +1,5 @@
> [% USE Asset %]
>+[% USE AuthorisedValues %]
> [% SET footerjs = 1 %]
> [% INCLUDE 'doc-head-open.inc' %]
> <title>Call number browser &rsaquo; Cataloging &rsaquo; Koha</title>
>@@ -41,6 +42,7 @@
>         <th>Call number</th>
>         <th>Title</th>
>         <th>Library</th>
>+        <th>Collection</th>
>     </tr></thead>
>     <tbody>
> [% FOREACH cn_loo IN cn_loop %]
>@@ -56,6 +58,7 @@
>         </a>
>     </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>
>     </tr>
> [% END %]
>     </tbody>
>-- 
>2.30.2

Actions: View | Diff | Splinter Review

Attachments on bug 30716: 134767 | 134771 | 135970