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