Lines 168-175
sub GetItemsAvailableToFillHoldRequestsForBib {
Link Here
|
168 |
$items_query .= "WHERE items.notforloan = 0 |
168 |
$items_query .= "WHERE items.notforloan = 0 |
169 |
AND holdingbranch IS NOT NULL |
169 |
AND holdingbranch IS NOT NULL |
170 |
AND itemlost = 0 |
170 |
AND itemlost = 0 |
171 |
AND wthdrawn = 0 |
171 |
AND wthdrawn = 0"; |
172 |
AND items.onloan IS NULL |
172 |
$items_query .= " AND damaged = 0 " unless C4::Context->preference('AllowHoldsOnDamagedItems'); |
|
|
173 |
$items_query .= " AND items.onloan IS NULL |
173 |
AND (itemtypes.notforloan IS NULL OR itemtypes.notforloan = 0) |
174 |
AND (itemtypes.notforloan IS NULL OR itemtypes.notforloan = 0) |
174 |
AND itemnumber NOT IN ( |
175 |
AND itemnumber NOT IN ( |
175 |
SELECT itemnumber |
176 |
SELECT itemnumber |
176 |
- |
|
|