|
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 |
- |
|
|