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