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

(-)a/cataloguing/value_builder/cn_browser.pl (-2 / +2 lines)
Lines 95-101 my $launcher = sub { Link Here
95
        my $green = 0;
95
        my $green = 0;
96
96
97
        #Results before the cn_sort
97
        #Results before the cn_sort
98
        $query = "SELECT b.title, b.subtitle, itemcallnumber, biblionumber, barcode, cn_sort, branchname, author, ccode
98
        $query = "SELECT b.title, b.subtitle, itemcallnumber, biblionumber, barcode, cn_sort, branchname, author, ccode, itype
99
        FROM items AS i
99
        FROM items AS i
100
        JOIN biblio AS b USING (biblionumber)
100
        JOIN biblio AS b USING (biblionumber)
101
        LEFT OUTER JOIN branches ON (branches.branchcode = homebranch)
101
        LEFT OUTER JOIN branches ON (branches.branchcode = homebranch)
Lines 125-131 my $launcher = sub { Link Here
125
        my $green = 0;
125
        my $green = 0;
126
126
127
        #Results after the cn_sort
127
        #Results after the cn_sort
128
        $query = "SELECT b.title, b.subtitle, itemcallnumber, biblionumber, barcode, cn_sort, branchname, author, ccode
128
        $query = "SELECT b.title, b.subtitle, itemcallnumber, biblionumber, barcode, cn_sort, branchname, author, ccode, itype
129
        FROM items AS i
129
        FROM items AS i
130
        JOIN biblio AS b USING (biblionumber)
130
        JOIN biblio AS b USING (biblionumber)
131
        LEFT OUTER JOIN branches ON (branches.branchcode = homebranch)
131
        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-5 Link Here
1
[% USE Asset %]
1
[% USE Asset %]
2
[% USE AuthorisedValues %]
2
[% USE AuthorisedValues %]
3
[% USE ItemTypes %]
3
[% SET footerjs = 1 %]
4
[% SET footerjs = 1 %]
4
[% INCLUDE 'doc-head-open.inc' %]
5
[% INCLUDE 'doc-head-open.inc' %]
5
<title>Call number browser &rsaquo; Cataloging &rsaquo; Koha</title>
6
<title>Call number browser &rsaquo; Cataloging &rsaquo; Koha</title>
Lines 50-55 Link Here
50
            <th>Title</th>
51
            <th>Title</th>
51
            <th>Library</th>
52
            <th>Library</th>
52
            <th>Collection</th>
53
            <th>Collection</th>
54
            <th>Item type</th>
53
        </tr></thead>
55
        </tr></thead>
54
        <tbody>
56
        <tbody>
55
    [% FOREACH cn_loo IN cn_loop %]
57
    [% FOREACH cn_loo IN cn_loop %]
Lines 66-71 Link Here
66
        </td>
68
        </td>
67
        <td style="background:[% cn_loo.background | html %];">[% cn_loo.branchname | html %]</td>
69
        <td style="background:[% cn_loo.background | html %];">[% cn_loo.branchname | html %]</td>
68
        <td style="background:[% cn_loo.background | html %];">[% AuthorisedValues.GetByCode( 'CCODE', cn_loo.ccode ) | html %]</td>
70
        <td style="background:[% cn_loo.background | html %];">[% AuthorisedValues.GetByCode( 'CCODE', cn_loo.ccode ) | html %]</td>
71
        <td style="background:[% cn_loo.background | html %];">[% ItemTypes.GetDescription( cn_loo.itype ) | html %]</td>
69
        </tr>
72
        </tr>
70
    [% END %]
73
    [% END %]
71
        </tbody>
74
        </tbody>
72
- 

Return to bug 33365