@@ -, +, @@ "item-level_itypes" types. "record" This is the bug. --- circ/pendingreserves.pl | 9 ++++++--- .../intranet-tmpl/prog/en/modules/circ/pendingreserves.tt | 10 +++++----- 2 files changed, 11 insertions(+), 8 deletions(-) --- a/circ/pendingreserves.pl +++ a/circ/pendingreserves.pl @@ -89,6 +89,8 @@ if ($enddate_iso) { push @query_params, $enddate_iso; } +my $item_type = C4::Context->preference('item-level_itypes') ? "items.itype" : "biblioitems.itemtype"; + my $strsth = "SELECT min(reservedate) as l_reservedate, reserves.borrowernumber as borrowernumber, @@ -96,8 +98,8 @@ my $strsth = ORDER BY items.itemnumber SEPARATOR '|') l_holdingbranch, reserves.biblionumber, reserves.branchcode as l_branch, - GROUP_CONCAT(DISTINCT items.itype - ORDER BY items.itemnumber SEPARATOR '|') l_itype, + GROUP_CONCAT(DISTINCT $item_type + ORDER BY items.itemnumber SEPARATOR '|') l_item_type, GROUP_CONCAT(DISTINCT items.location ORDER BY items.itemnumber SEPARATOR '|') l_location, GROUP_CONCAT(DISTINCT items.itemcallnumber @@ -115,6 +117,7 @@ my $strsth = FROM reserves LEFT JOIN items ON items.biblionumber=reserves.biblionumber LEFT JOIN biblio ON reserves.biblionumber=biblio.biblionumber + LEFT JOIN biblioitems ON biblio.biblionumber=biblioitems.biblionumber LEFT JOIN branchtransfers ON items.itemnumber=branchtransfers.itemnumber LEFT JOIN issues ON items.itemnumber=issues.itemnumber LEFT JOIN borrowers ON reserves.borrowernumber=borrowers.borrowernumber @@ -165,7 +168,7 @@ while ( my $data = $sth->fetchrow_hashref ) { count => $data->{icount}, rcount => $data->{rcount}, pullcount => $data->{icount} <= $data->{rcount} ? $data->{icount} : $data->{rcount}, - itypes => [split('\|', $data->{l_itype})], + itemTypes => [split('\|', $data->{l_item_type})], locations => [split('\|', $data->{l_location})], } ); --- a/koha-tmpl/intranet-tmpl/prog/en/modules/circ/pendingreserves.tt +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/circ/pendingreserves.tt @@ -40,7 +40,7 @@
[% reserveloo.copyno %]
[% reserveloo.enumchron %]