Attachment #134771 for bug #30716

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

Lines 94-100 my $launcher = sub { Link Here

(-)a/cataloguing/value_builder/cn_browser.pl (-2 / +2 lines)
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)




[% USE Asset %]
[% USE AuthorisedValues %]
[% SET footerjs = 1 %]
[% INCLUDE 'doc-head-open.inc' %]
<title>Call number browser &rsaquo; Cataloging &rsaquo; Koha</title>

        <th>Call number</th>
        <th>Title</th>
        <th>Library</th>
        <th>Collection</th>
    </tr></thead>
    <tbody>
[% FOREACH cn_loo IN cn_loop %]

        </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>
- 

Return to bug 30716

Lines 1-4 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/cataloguing/value_builder/cn_browser.tt (-1 / +3 lines)
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	-