|
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 |
- |
|
|