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

(-)a/C4/HoldsQueue.pm (-1 / +17 lines)
Lines 136-142 sub GetHoldsQueueItems { Link Here
136
    my $dbh   = C4::Context->dbh;
136
    my $dbh   = C4::Context->dbh;
137
137
138
    my @bind_params = ();
138
    my @bind_params = ();
139
    my $query = q/SELECT tmp_holdsqueue.*, biblio.author, items.ccode, items.itype, biblioitems.itemtype, items.location,
139
    my $query = q/SELECT borrowers.surname,
140
                         borrowers.othernames,
141
                         borrowers.firstname,
142
                         borrowers.cardnumber,
143
                         borrowers.borrowernumber,
144
                         borrowers.title AS borrower_title,
145
                         tmp_holdsqueue.*, biblio.author, items.ccode, items.itype, biblioitems.itemtype, items.location,
140
                         items.enumchron, items.cn_sort, biblioitems.publishercode,
146
                         items.enumchron, items.cn_sort, biblioitems.publishercode,
141
                         biblio.copyrightdate, biblio.subtitle, biblio.medium,
147
                         biblio.copyrightdate, biblio.subtitle, biblio.medium,
142
                         biblio.part_number, biblio.part_name,
148
                         biblio.part_number, biblio.part_name,
Lines 146-151 sub GetHoldsQueueItems { Link Here
146
                       JOIN biblio      USING (biblionumber)
152
                       JOIN biblio      USING (biblionumber)
147
                  LEFT JOIN biblioitems USING (biblionumber)
153
                  LEFT JOIN biblioitems USING (biblionumber)
148
                  LEFT JOIN items       USING (  itemnumber)
154
                  LEFT JOIN items       USING (  itemnumber)
155
                  LEFT JOIN borrowers   USING (borrowernumber)
149
                /;
156
                /;
150
    if ($branchlimit) {
157
    if ($branchlimit) {
151
        $query .=" WHERE tmp_holdsqueue.holdingbranch = ?";
158
        $query .=" WHERE tmp_holdsqueue.holdingbranch = ?";
Lines 162-167 sub GetHoldsQueueItems { Link Here
162
        }
169
        }
163
        delete $row->{itemtype};
170
        delete $row->{itemtype};
164
171
172
        $row->{borrower} = {
173
            borrowernumber => $row->{borrowernumber},
174
            cardnumber     => $row->{cardnumber},
175
            firstname      => $row->{firstname},
176
            othernames     => $row->{othernames},
177
            surname        => $row->{surname},
178
            title          => $row->{borrower_title},
179
        };
180
165
        push @$items, $row;
181
        push @$items, $row;
166
    }
182
    }
167
    return $items;
183
    return $items;
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/circ/view_holdsqueue.tt (-2 / +1 lines)
Lines 184-190 Link Here
184
            </td>
184
            </td>
185
            <td class="hq-patron">
185
            <td class="hq-patron">
186
              <p>
186
              <p>
187
                  [% INCLUDE 'patron-title.inc' invert_name=1 patron=itemsloo.patron hide_patron_infos_if_needed=1 link_to="circulation_reserves" %]
187
                  [% INCLUDE 'patron-title.inc' invert_name=1 borrower=itemsloo.borrower hide_patron_infos_if_needed=1 link_to="circulation_reserves" %]
188
              </p>
188
              </p>
189
              [% UNLESS Koha.Preference('HidePatronName') %]
189
              [% UNLESS Koha.Preference('HidePatronName') %]
190
                 <p>[% itemsloo.patron.phone | html %]</p>
190
                 <p>[% itemsloo.patron.phone | html %]</p>
191
- 

Return to bug 28966