Lines 224-230
my $strsth =
Link Here
|
224 |
$sqldatewhere |
224 |
$sqldatewhere |
225 |
AND (reserves.itemnumber IS NULL OR reserves.itemnumber = items.itemnumber) |
225 |
AND (reserves.itemnumber IS NULL OR reserves.itemnumber = items.itemnumber) |
226 |
AND items.itemnumber NOT IN (SELECT itemnumber FROM branchtransfers where datearrived IS NULL) |
226 |
AND items.itemnumber NOT IN (SELECT itemnumber FROM branchtransfers where datearrived IS NULL) |
227 |
AND items.itemnumber NOT IN (select itemnumber FROM reserves where found IS NOT NULL) |
227 |
AND items.itemnumber NOT IN (SELECT itemnumber FROM reserves WHERE found IS NOT NULL AND itemnumber IS NOT NULL) |
228 |
AND issues.itemnumber IS NULL |
228 |
AND issues.itemnumber IS NULL |
229 |
AND reserves.priority <> 0 |
229 |
AND reserves.priority <> 0 |
230 |
AND reserves.suspend = 0 |
230 |
AND reserves.suspend = 0 |
Lines 233-239
my $strsth =
Link Here
|
233 |
"; |
233 |
"; |
234 |
# GROUP BY reserves.biblionumber allows only items that are not checked out, else multiples occur when |
234 |
# GROUP BY reserves.biblionumber allows only items that are not checked out, else multiples occur when |
235 |
# multiple patrons have a hold on an item |
235 |
# multiple patrons have a hold on an item |
236 |
|
236 |
#FIXME "found IS NOT NULL AND itemnumber IS NOT NULL" is just a workaround: see BZ 25726 |
237 |
|
237 |
|
238 |
if (C4::Context->preference('IndependentBranches')){ |
238 |
if (C4::Context->preference('IndependentBranches')){ |
239 |
$strsth .= " AND items.holdingbranch=? "; |
239 |
$strsth .= " AND items.holdingbranch=? "; |
240 |
- |
|
|