Lines 896-903
sub GetBiblioFromItemNumber {
Link Here
|
896 |
"SELECT items.*, biblio.*, biblioitems.*, itemtypes.notforloan as notforloan_per_itemtype FROM items |
896 |
"SELECT items.*, biblio.*, biblioitems.*, itemtypes.notforloan as notforloan_per_itemtype FROM items |
897 |
LEFT JOIN biblio ON biblio.biblionumber = items.biblionumber |
897 |
LEFT JOIN biblio ON biblio.biblionumber = items.biblionumber |
898 |
LEFT JOIN biblioitems ON biblioitems.biblioitemnumber = items.biblioitemnumber |
898 |
LEFT JOIN biblioitems ON biblioitems.biblioitemnumber = items.biblioitemnumber |
899 |
LEFT JOIN itemtypes ON itemtypes.itemtype = " . C4::Context->preference('item-level_itypes') ? 'items.itype' : 'biblioitems.itemtype' . " |
899 |
LEFT JOIN itemtypes ON itemtypes.itemtype = " . |
900 |
WHERE items.itemnumber = ?" |
900 |
(C4::Context->preference('item-level_itypes') ? 'items.itype' : 'biblioitems.itemtype') . |
|
|
901 |
" WHERE items.itemnumber = ?" |
901 |
); |
902 |
); |
902 |
$sth->execute($itemnumber); |
903 |
$sth->execute($itemnumber); |
903 |
} else { |
904 |
} else { |
904 |
- |
|
|