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

(-)a/circ/pendingreserves.pl (-3 / +2 lines)
Lines 214-220 my $strsth = Link Here
214
        LEFT JOIN branchtransfers ON items.itemnumber=branchtransfers.itemnumber
214
        LEFT JOIN branchtransfers ON items.itemnumber=branchtransfers.itemnumber
215
        LEFT JOIN issues ON items.itemnumber=issues.itemnumber
215
        LEFT JOIN issues ON items.itemnumber=issues.itemnumber
216
        LEFT JOIN borrowers ON reserves.borrowernumber=borrowers.borrowernumber
216
        LEFT JOIN borrowers ON reserves.borrowernumber=borrowers.borrowernumber
217
        LEFT JOIN default_branch_item_rules ON items.itype=default_branch_item_rules.itemtype
217
        LEFT JOIN circulation_rules ON items.itype=circulation_rules.itemtype AND rule_name = 'holdallowed' AND circulation_rules.branchcode IS NULL AND circulation_rules.categorycode IS NULL
218
    WHERE
218
    WHERE
219
    reserves.found IS NULL
219
    reserves.found IS NULL
220
    $sqldatewhere
220
    $sqldatewhere
Lines 225-231 my $strsth = Link Here
225
    AND reserves.priority <> 0 
225
    AND reserves.priority <> 0 
226
    AND reserves.suspend = 0
226
    AND reserves.suspend = 0
227
    AND notforloan = 0 AND itemlost = 0 AND withdrawn = 0
227
    AND notforloan = 0 AND itemlost = 0 AND withdrawn = 0
228
    AND ( default_branch_item_rules.holdallowed IS NULL OR default_branch_item_rules.holdallowed != 0 )
228
    AND ( circulation_rules.rule_value IS NULL OR circulation_rules.rule_value != 0 )
229
    ";
229
    ";
230
    # GROUP BY reserves.biblionumber allows only items that are not checked out, else multiples occur when 
230
    # GROUP BY reserves.biblionumber allows only items that are not checked out, else multiples occur when 
231
    #    multiple patrons have a hold on an item
231
    #    multiple patrons have a hold on an item
232
- 

Return to bug 23484