|
Lines 1185-1198
sub GetItemsInfo {
Link Here
|
| 1185 |
items.notforloan as itemnotforloan, |
1185 |
items.notforloan as itemnotforloan, |
| 1186 |
itemtypes.description, |
1186 |
itemtypes.description, |
| 1187 |
itemtypes.notforloan as notforloan_per_itemtype, |
1187 |
itemtypes.notforloan as notforloan_per_itemtype, |
| 1188 |
branchurl |
1188 |
holding.branchurl |
| 1189 |
FROM items |
1189 |
FROM items |
| 1190 |
LEFT JOIN branches ON items.holdingbranch = branches.branchcode |
1190 |
LEFT JOIN branches AS holding ON items.holdingbranch = holding.branchcode |
|
|
1191 |
LEFT JOIN branches AS home ON items.homebranch=home.branchcode |
| 1191 |
LEFT JOIN biblio ON biblio.biblionumber = items.biblionumber |
1192 |
LEFT JOIN biblio ON biblio.biblionumber = items.biblionumber |
| 1192 |
LEFT JOIN biblioitems ON biblioitems.biblioitemnumber = items.biblioitemnumber |
1193 |
LEFT JOIN biblioitems ON biblioitems.biblioitemnumber = items.biblioitemnumber |
| 1193 |
LEFT JOIN itemtypes ON itemtypes.itemtype = " |
1194 |
LEFT JOIN itemtypes ON itemtypes.itemtype = " |
| 1194 |
. (C4::Context->preference('item-level_itypes') ? 'items.itype' : 'biblioitems.itemtype'); |
1195 |
. (C4::Context->preference('item-level_itypes') ? 'items.itype' : 'biblioitems.itemtype'); |
| 1195 |
$query .= " WHERE items.biblionumber = ? ORDER BY branches.branchname,items.dateaccessioned desc" ; |
1196 |
$query .= " WHERE items.biblionumber = ? ORDER BY home.branchname,items.dateaccessioned desc" ; |
| 1196 |
my $sth = $dbh->prepare($query); |
1197 |
my $sth = $dbh->prepare($query); |
| 1197 |
$sth->execute($biblionumber); |
1198 |
$sth->execute($biblionumber); |
| 1198 |
my $i = 0; |
1199 |
my $i = 0; |
| 1199 |
- |
|
|