From: Edmund Balnaves --- C4/Reserves.pm | 11 ++++++++++- 1 files changed, 10 insertions(+), 1 deletions(-) diff --git a/C4/Reserves.pm b/C4/Reserves.pm index ca8f2fb..dd3d4c0 100644 --- a/C4/Reserves.pm +++ b/C4/Reserves.pm @@ -768,9 +768,18 @@ sub CheckReserves { items.itemnumber FROM items LEFT JOIN biblioitems ON items.biblioitemnumber = biblioitems.biblioitemnumber - LEFT JOIN itemtypes ON biblioitems.itemtype = itemtypes.itemtype "; + #ejb2011 - logic is wrong here - if itemlevel itypes then should join on itype not biblio item.type + if (C4::Context->preference('item-level_itypes')) { + $select .= " LEFT JOIN itemtypes ON items.itype = +itemtypes.itemtype"; + } else { + $select .= " LEFT JOIN itemtypes ON biblioitems.itype = +itemtypes.itemtype"; + } + } + if ($item) { $sth = $dbh->prepare("$select WHERE itemnumber = ?"); $sth->execute($item); -- 1.6.0.2