@@ -, +, @@ --- C4/HoldsQueue.pm | 18 +++++++++++++++++- .../prog/en/modules/circ/view_holdsqueue.tt | 2 +- 2 files changed, 18 insertions(+), 2 deletions(-) --- a/C4/HoldsQueue.pm +++ a/C4/HoldsQueue.pm @@ -136,7 +136,13 @@ sub GetHoldsQueueItems { my $dbh = C4::Context->dbh; my @bind_params = (); - my $query = q/SELECT tmp_holdsqueue.*, biblio.author, items.ccode, items.itype, biblioitems.itemtype, items.location, + my $query = q/SELECT borrowers.surname, + borrowers.othernames, + borrowers.firstname, + borrowers.cardnumber, + borrowers.borrowernumber, + borrowers.title AS borrower_title, + tmp_holdsqueue.*, biblio.author, items.ccode, items.itype, biblioitems.itemtype, items.location, items.enumchron, items.cn_sort, biblioitems.publishercode, biblio.copyrightdate, biblio.subtitle, biblio.medium, biblio.part_number, biblio.part_name, @@ -146,6 +152,7 @@ sub GetHoldsQueueItems { JOIN biblio USING (biblionumber) LEFT JOIN biblioitems USING (biblionumber) LEFT JOIN items USING ( itemnumber) + LEFT JOIN borrowers USING (borrowernumber) /; if ($branchlimit) { $query .=" WHERE tmp_holdsqueue.holdingbranch = ?"; @@ -162,6 +169,15 @@ sub GetHoldsQueueItems { } delete $row->{itemtype}; + $row->{borrower} = { + borrowernumber => $row->{borrowernumber}, + cardnumber => $row->{cardnumber}, + firstname => $row->{firstname}, + othernames => $row->{othernames}, + surname => $row->{surname}, + title => $row->{borrower_title}, + }; + push @$items, $row; } return $items; --- a/koha-tmpl/intranet-tmpl/prog/en/modules/circ/view_holdsqueue.tt +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/circ/view_holdsqueue.tt @@ -184,7 +184,7 @@

- [% INCLUDE 'patron-title.inc' invert_name=1 patron=itemsloo.patron hide_patron_infos_if_needed=1 link_to="circulation_reserves" %] + [% INCLUDE 'patron-title.inc' invert_name=1 borrower=itemsloo.borrower hide_patron_infos_if_needed=1 link_to="circulation_reserves" %]

[% UNLESS Koha.Preference('HidePatronName') %]

[% itemsloo.patron.phone | html %]

--