View | Details | Raw Unified | Return to bug 21320
Collapse All | Expand All

(-)a/circ/pendingreserves.pl (-2 / +6 lines)
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
# Bug 21320
174
if ( ! C4::Context->preference('AllowHoldsOnDamagedItems') ) {
175
    $sqldatewhere .= " AND damaged = 0";
176
}
177
173
my $strsth =
178
my $strsth =
174
    "SELECT min(reservedate) as l_reservedate,
179
    "SELECT min(reservedate) as l_reservedate,
175
            reserves.reserve_id,
180
            reserves.reserve_id,
Lines 214-220 my $strsth = Link Here
214
    AND issues.itemnumber IS NULL
219
    AND issues.itemnumber IS NULL
215
    AND reserves.priority <> 0 
220
    AND reserves.priority <> 0 
216
    AND reserves.suspend = 0
221
    AND reserves.suspend = 0
217
    AND notforloan = 0 AND damaged = 0 AND itemlost = 0 AND withdrawn = 0
222
    AND notforloan = 0 AND itemlost = 0 AND withdrawn = 0
218
    ";
223
    ";
219
    # GROUP BY reserves.biblionumber allows only items that are not checked out, else multiples occur when 
224
    # 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
225
    #    multiple patrons have a hold on an item
221
- 

Return to bug 21320