Lines 943-951
sub GetItemsInfo {
Link Here
|
943 |
holding.branchname, |
943 |
holding.branchname, |
944 |
holding.opac_info as holding_branch_opac_info, |
944 |
holding.opac_info as holding_branch_opac_info, |
945 |
home.opac_info as home_branch_opac_info |
945 |
home.opac_info as home_branch_opac_info |
946 |
"; |
946 |
IF(tmp_holdsqueue.itemnumber,1,0) AS has_pending_hold |
947 |
$query .= ",IF(tmp_holdsqueue.itemnumber,1,0) AS has_pending_hold" if !C4::Context->preference('AllowItemsOnHoldCheckoutSIP'); |
|
|
948 |
$query .= " |
949 |
FROM items |
947 |
FROM items |
950 |
LEFT JOIN branches AS holding ON items.holdingbranch = holding.branchcode |
948 |
LEFT JOIN branches AS holding ON items.holdingbranch = holding.branchcode |
951 |
LEFT JOIN branches AS home ON items.homebranch=home.branchcode |
949 |
LEFT JOIN branches AS home ON items.homebranch=home.branchcode |
Lines 958-969
sub GetItemsInfo {
Link Here
|
958 |
LEFT JOIN itemtypes ON itemtypes.itemtype = " |
956 |
LEFT JOIN itemtypes ON itemtypes.itemtype = " |
959 |
. (C4::Context->preference('item-level_itypes') ? 'items.itype' : 'biblioitems.itemtype'); |
957 |
. (C4::Context->preference('item-level_itypes') ? 'items.itype' : 'biblioitems.itemtype'); |
960 |
$query .= " |
958 |
$query .= " |
961 |
LEFT JOIN tmp_holdsqueue USING (itemnumber)" if !C4::Context->preference('AllowItemsOnHoldCheckoutSIP'); |
959 |
LEFT JOIN tmp_holdsqueue USING (itemnumber) |
962 |
$query .= q| |
|
|
963 |
LEFT JOIN localization ON itemtypes.itemtype = localization.code |
960 |
LEFT JOIN localization ON itemtypes.itemtype = localization.code |
964 |
AND localization.entity = 'itemtypes' |
961 |
AND localization.entity = 'itemtypes' |
965 |
AND localization.lang = ? |
962 |
AND localization.lang = ? |
966 |
|; |
963 |
"; |
967 |
|
964 |
|
968 |
$query .= " WHERE items.biblionumber = ? ORDER BY home.branchname, items.enumchron, LPAD( items.copynumber, 8, '0' ), items.dateaccessioned DESC" ; |
965 |
$query .= " WHERE items.biblionumber = ? ORDER BY home.branchname, items.enumchron, LPAD( items.copynumber, 8, '0' ), items.dateaccessioned DESC" ; |
969 |
my $sth = $dbh->prepare($query); |
966 |
my $sth = $dbh->prepare($query); |
970 |
- |
|
|