|
Lines 170-175
if ($enddate_iso) {
Link Here
|
| 170 |
|
170 |
|
| 171 |
my $item_type = C4::Context->preference('item-level_itypes') ? "items.itype" : "biblioitems.itemtype"; |
171 |
my $item_type = C4::Context->preference('item-level_itypes') ? "items.itype" : "biblioitems.itemtype"; |
| 172 |
|
172 |
|
|
|
173 |
if ( ! C4::Context->preference('AllowHoldsOnDamagedItems') ) { |
| 174 |
$sqldatewhere .= " AND damaged = 0"; |
| 175 |
} |
| 176 |
|
| 173 |
my $strsth = |
177 |
my $strsth = |
| 174 |
"SELECT min(reservedate) as l_reservedate, |
178 |
"SELECT min(reservedate) as l_reservedate, |
| 175 |
reserves.reserve_id, |
179 |
reserves.reserve_id, |
|
Lines 214-220
my $strsth =
Link Here
|
| 214 |
AND issues.itemnumber IS NULL |
218 |
AND issues.itemnumber IS NULL |
| 215 |
AND reserves.priority <> 0 |
219 |
AND reserves.priority <> 0 |
| 216 |
AND reserves.suspend = 0 |
220 |
AND reserves.suspend = 0 |
| 217 |
AND notforloan = 0 AND damaged = 0 AND itemlost = 0 AND withdrawn = 0 |
221 |
AND notforloan = 0 AND itemlost = 0 AND withdrawn = 0 |
| 218 |
"; |
222 |
"; |
| 219 |
# GROUP BY reserves.biblionumber allows only items that are not checked out, else multiples occur when |
223 |
# GROUP BY reserves.biblionumber allows only items that are not checked out, else multiples occur when |
| 220 |
# multiple patrons have a hold on an item |
224 |
# multiple patrons have a hold on an item |
| 221 |
- |
|
|