View | Details | Raw Unified | Return to bug 30716
Collapse All | Expand All

(-)a/cataloguing/value_builder/cn_browser.pl (-2 / +2 lines)
Lines 94-100 my $launcher = sub { Link Here
94
        my $green = 0;
94
        my $green = 0;
95
95
96
        #Results before the cn_sort
96
        #Results before the cn_sort
97
        $query = "SELECT b.title, b.subtitle, itemcallnumber, biblionumber, barcode, cn_sort, branchname, author
97
        $query = "SELECT b.title, b.subtitle, itemcallnumber, biblionumber, barcode, cn_sort, branchname, author, ccode
98
        FROM items AS i
98
        FROM items AS i
99
        JOIN biblio AS b USING (biblionumber)
99
        JOIN biblio AS b USING (biblionumber)
100
        LEFT OUTER JOIN branches ON (branches.branchcode = homebranch)
100
        LEFT OUTER JOIN branches ON (branches.branchcode = homebranch)
Lines 124-130 my $launcher = sub { Link Here
124
        my $green = 0;
124
        my $green = 0;
125
125
126
        #Results after the cn_sort
126
        #Results after the cn_sort
127
        $query = "SELECT b.title, b.subtitle, itemcallnumber, biblionumber, barcode, cn_sort, branchname, author
127
        $query = "SELECT b.title, b.subtitle, itemcallnumber, biblionumber, barcode, cn_sort, branchname, author, ccode
128
        FROM items AS i
128
        FROM items AS i
129
        JOIN biblio AS b USING (biblionumber)
129
        JOIN biblio AS b USING (biblionumber)
130
        LEFT OUTER JOIN branches ON (branches.branchcode = homebranch)
130
        LEFT OUTER JOIN branches ON (branches.branchcode = homebranch)
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/cataloguing/value_builder/cn_browser.tt (-1 / +3 lines)
Lines 1-4 Link Here
1
[% USE Asset %]
1
[% USE Asset %]
2
[% USE AuthorisedValues %]
2
[% SET footerjs = 1 %]
3
[% SET footerjs = 1 %]
3
[% INCLUDE 'doc-head-open.inc' %]
4
[% INCLUDE 'doc-head-open.inc' %]
4
<title>Call number browser &rsaquo; Cataloging &rsaquo; Koha</title>
5
<title>Call number browser &rsaquo; Cataloging &rsaquo; Koha</title>
Lines 41-46 Link Here
41
        <th>Call number</th>
42
        <th>Call number</th>
42
        <th>Title</th>
43
        <th>Title</th>
43
        <th>Library</th>
44
        <th>Library</th>
45
        <th>Collection</th>
44
    </tr></thead>
46
    </tr></thead>
45
    <tbody>
47
    <tbody>
46
[% FOREACH cn_loo IN cn_loop %]
48
[% FOREACH cn_loo IN cn_loop %]
Lines 56-61 Link Here
56
        </a>
58
        </a>
57
    </td>
59
    </td>
58
    <td style="background:[% cn_loo.background | html %];">[% cn_loo.branchname | html %]</td>
60
    <td style="background:[% cn_loo.background | html %];">[% cn_loo.branchname | html %]</td>
61
    <td style="background:[% cn_loo.background | html %];">[% AuthorisedValues.GetByCode( 'CCODE', cn_loo.ccode ) | html %]</td>
59
    </tr>
62
    </tr>
60
[% END %]
63
[% END %]
61
    </tbody>
64
    </tbody>
62
- 

Return to bug 30716