Lines 768-776
sub CheckReserves {
Link Here
|
768 |
items.itemnumber |
768 |
items.itemnumber |
769 |
FROM items |
769 |
FROM items |
770 |
LEFT JOIN biblioitems ON items.biblioitemnumber = biblioitems.biblioitemnumber |
770 |
LEFT JOIN biblioitems ON items.biblioitemnumber = biblioitems.biblioitemnumber |
771 |
LEFT JOIN itemtypes ON biblioitems.itemtype = itemtypes.itemtype |
|
|
772 |
"; |
771 |
"; |
773 |
|
772 |
|
|
|
773 |
#ejb2011 - logic is wrong here - if itemlevel itypes then should join on itype not biblio item.type |
774 |
if (C4::Context->preference('item-level_itypes')) { |
775 |
$select .= " LEFT JOIN itemtypes ON items.itype = |
776 |
itemtypes.itemtype"; |
777 |
} else { |
778 |
$select .= " LEFT JOIN itemtypes ON biblioitems.itype = |
779 |
itemtypes.itemtype"; |
780 |
} |
781 |
} |
782 |
|
774 |
if ($item) { |
783 |
if ($item) { |
775 |
$sth = $dbh->prepare("$select WHERE itemnumber = ?"); |
784 |
$sth = $dbh->prepare("$select WHERE itemnumber = ?"); |
776 |
$sth->execute($item); |
785 |
$sth->execute($item); |
777 |
- |
|
|