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

(-)a/circ/pendingreserves.pl (-2 / +5 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
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
- 

Return to bug 21320