Lines 140-146
if ( $run_report ) {
Link Here
|
140 |
$sqldatewhere |
140 |
$sqldatewhere |
141 |
AND (reserves.itemnumber IS NULL OR reserves.itemnumber = items.itemnumber) |
141 |
AND (reserves.itemnumber IS NULL OR reserves.itemnumber = items.itemnumber) |
142 |
AND items.itemnumber NOT IN (SELECT itemnumber FROM branchtransfers WHERE datearrived IS NULL) |
142 |
AND items.itemnumber NOT IN (SELECT itemnumber FROM branchtransfers WHERE datearrived IS NULL) |
143 |
AND items.itemnumber NOT IN (SELECT itemnumber FROM reserves WHERE found='W') |
143 |
AND items.itemnumber NOT IN (SELECT itemnumber FROM reserves WHERE found IS NOT NULL) |
144 |
AND issues.itemnumber IS NULL |
144 |
AND issues.itemnumber IS NULL |
145 |
AND reserves.priority <> 0 |
145 |
AND reserves.priority <> 0 |
146 |
AND reserves.suspend = 0 |
146 |
AND reserves.suspend = 0 |
147 |
- |
|
|