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

(-)a/cataloguing/value_builder/cn_browser.pl (-2 / +2 lines)
Lines 110-116 my $launcher = sub { Link Here
110
110
111
        #Results before the cn_sort
111
        #Results before the cn_sort
112
        $query =
112
        $query =
113
            "SELECT b.title, b.subtitle, itemcallnumber, biblionumber, barcode, cn_sort, branchname, author, ccode, itype
113
            "SELECT b.title, b.subtitle, itemcallnumber, biblionumber, barcode, cn_sort, branchname, author, ccode, location, itype
114
        FROM items AS i
114
        FROM items AS i
115
        JOIN biblio AS b USING (biblionumber)
115
        JOIN biblio AS b USING (biblionumber)
116
        LEFT OUTER JOIN branches ON (branches.branchcode = homebranch)
116
        LEFT OUTER JOIN branches ON (branches.branchcode = homebranch)
Lines 141-147 my $launcher = sub { Link Here
141
141
142
        #Results after the cn_sort
142
        #Results after the cn_sort
143
        $query =
143
        $query =
144
            "SELECT b.title, b.subtitle, itemcallnumber, biblionumber, barcode, cn_sort, branchname, author, ccode, itype
144
            "SELECT b.title, b.subtitle, itemcallnumber, biblionumber, barcode, cn_sort, branchname, author, ccode, location, itype
145
        FROM items AS i
145
        FROM items AS i
146
        JOIN biblio AS b USING (biblionumber)
146
        JOIN biblio AS b USING (biblionumber)
147
        LEFT OUTER JOIN branches ON (branches.branchcode = homebranch)
147
        LEFT OUTER JOIN branches ON (branches.branchcode = homebranch)
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/cataloguing/value_builder/cn_browser.tt (-1 / +2 lines)
Lines 61-66 Link Here
61
                    <th>Title</th>
61
                    <th>Title</th>
62
                    <th>Library</th>
62
                    <th>Library</th>
63
                    <th>Collection</th>
63
                    <th>Collection</th>
64
                    <th>Shelving location</th>
64
                    [% IF Koha.Preference('item-level_itypes') %]
65
                    [% IF Koha.Preference('item-level_itypes') %]
65
                        <th>Item type</th>
66
                        <th>Item type</th>
66
                    [% END %]
67
                    [% END %]
Lines 81-86 Link Here
81
                        </td>
82
                        </td>
82
                        <td style="background:[% cn_loo.background | html %];">[% cn_loo.branchname | html %]</td>
83
                        <td style="background:[% cn_loo.background | html %];">[% cn_loo.branchname | html %]</td>
83
                        <td style="background:[% cn_loo.background | html %];">[% AuthorisedValues.GetByCode( 'CCODE', cn_loo.ccode ) | html %]</td>
84
                        <td style="background:[% cn_loo.background | html %];">[% AuthorisedValues.GetByCode( 'CCODE', cn_loo.ccode ) | html %]</td>
85
                        <td style="background:[% cn_loo.background | html %];">[% AuthorisedValues.GetByCode( 'LOC', cn_loo.location ) | html %]</td>
84
                        [% IF Koha.Preference('item-level_itypes') %]
86
                        [% IF Koha.Preference('item-level_itypes') %]
85
                            <td style="background:[% cn_loo.background | html %];">[% ItemTypes.GetDescription( cn_loo.itype ) | html %]</td>
87
                            <td style="background:[% cn_loo.background | html %];">[% ItemTypes.GetDescription( cn_loo.itype ) | html %]</td>
86
                        [% END %]
88
                        [% END %]
87
- 

Return to bug 39880