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

(-)a/C4/HoldsQueue.pm (-1 / +1 lines)
Lines 119-125 sub GetHoldsQueueItems { Link Here
119
    my $dbh   = C4::Context->dbh;
119
    my $dbh   = C4::Context->dbh;
120
120
121
    my @bind_params = ();
121
    my @bind_params = ();
122
    my $query = q/SELECT tmp_holdsqueue.*, biblio.author, items.ccode, items.location, items.enumchron, items.cn_sort, biblioitems.publishercode,biblio.copyrightdate,biblioitems.publicationyear,biblioitems.pages,biblioitems.size,biblioitems.publicationyear,biblioitems.isbn,items.copynumber
122
    my $query = q/SELECT tmp_holdsqueue.*, biblio.author, items.ccode, items.itype, items.location, items.enumchron, items.cn_sort, biblioitems.publishercode,biblio.copyrightdate,biblioitems.publicationyear,biblioitems.pages,biblioitems.size,biblioitems.publicationyear,biblioitems.isbn,items.copynumber
123
                  FROM tmp_holdsqueue
123
                  FROM tmp_holdsqueue
124
                       JOIN biblio      USING (biblionumber)
124
                       JOIN biblio      USING (biblionumber)
125
                  LEFT JOIN biblioitems USING (biblionumber)
125
                  LEFT JOIN biblioitems USING (biblionumber)
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/circ/view_holdsqueue.tt (-3 / +6 lines)
Lines 1-3 Link Here
1
[% USE ItemTypes %]
2
[% USE KohaAuthorisedValues %]
1
[% INCLUDE 'doc-head-open.inc' %]
3
[% INCLUDE 'doc-head-open.inc' %]
2
<title>Koha &rsaquo; Circulation &rsaquo; Holds queue</title>
4
<title>Koha &rsaquo; Circulation &rsaquo; Holds queue</title>
3
[% INCLUDE 'doc-head-close.inc' %]
5
[% INCLUDE 'doc-head-close.inc' %]
Lines 13-19 Link Here
13
<script type="text/javascript">//<![CDATA[
15
<script type="text/javascript">//<![CDATA[
14
$(document).ready(function() {
16
$(document).ready(function() {
15
    $("#holdst").dataTable({
17
    $("#holdst").dataTable({
16
        "aaSorting": [[ 2, "asc" ]],
18
        "aaSorting": [[ 3, "asc" ]],
17
        "bPaginate": false,
19
        "bPaginate": false,
18
        "bLengthChange": false,
20
        "bLengthChange": false,
19
        "bFilter": false,
21
        "bFilter": false,
Lines 53-58 $(document).ready(function() { Link Here
53
	<tr>
55
	<tr>
54
        <th class="hq-title">Title</th>
56
        <th class="hq-title">Title</th>
55
        <th class="hq-collection">Collection</th>
57
        <th class="hq-collection">Collection</th>
58
        <th class="hq-itemtype">Item type</th>
56
        <th class="hq-callnumber">Call number</th>
59
        <th class="hq-callnumber">Call number</th>
57
        <th class="hq-copynumber">Copy number</th>
60
        <th class="hq-copynumber">Copy number</th>
58
        <th class="hq-enumchron">Enumeration</th>
61
        <th class="hq-enumchron">Enumeration</th>
Lines 74-80 $(document).ready(function() { Link Here
74
                                         [% IF ( itemsloo.size ) %][% itemsloo.size %][% END %] [% IF ( itemsloo.isbn ) %]ISBN: [% itemsloo.isbn %][% END %]</p>
77
                                         [% IF ( itemsloo.size ) %][% itemsloo.size %][% END %] [% IF ( itemsloo.isbn ) %]ISBN: [% itemsloo.isbn %][% END %]</p>
75
			</div>
78
			</div>
76
			</td>
79
			</td>
77
            <td class="hq-collection">[% itemsloo.ccode %]</td>
80
            <td class="hq-collection">[% KohaAuthorisedValues.GetByCode( 'CCODE', itemsloo.ccode ) %]</td>
81
            <td class="hq-itemtype">[% ItemTypes.GetDescription( itemsloo.itype ) %]</td>
78
            <td class="hq-callnumber">[% itemsloo.location %] [% itemsloo.itemcallnumber %]</td>
82
            <td class="hq-callnumber">[% itemsloo.location %] [% itemsloo.itemcallnumber %]</td>
79
            <td class="hq-copynumber">[% itemsloo.copynumber %]</td>
83
            <td class="hq-copynumber">[% itemsloo.copynumber %]</td>
80
            <td class="hq-enumchron">[% itemsloo.enumchron %]</td>
84
            <td class="hq-enumchron">[% itemsloo.enumchron %]</td>
81
- 

Return to bug 5825