Lines 222-228
sub GetBibsWithPendingHoldRequests {
Link Here
|
222 |
FROM reserves |
222 |
FROM reserves |
223 |
WHERE found IS NULL |
223 |
WHERE found IS NULL |
224 |
AND priority > 0 |
224 |
AND priority > 0 |
225 |
AND reservedate <= CURRENT_DATE()"; |
225 |
AND reservedate <= CURRENT_DATE() |
|
|
226 |
AND suspend = 0 |
227 |
"; |
226 |
my $sth = $dbh->prepare($bib_query); |
228 |
my $sth = $dbh->prepare($bib_query); |
227 |
|
229 |
|
228 |
$sth->execute(); |
230 |
$sth->execute(); |
Lines 265-270
sub GetPendingHoldRequestsForBib {
Link Here
|
265 |
AND found IS NULL |
267 |
AND found IS NULL |
266 |
AND priority > 0 |
268 |
AND priority > 0 |
267 |
AND reservedate <= CURRENT_DATE() |
269 |
AND reservedate <= CURRENT_DATE() |
|
|
270 |
AND suspend = 0 |
268 |
ORDER BY priority"; |
271 |
ORDER BY priority"; |
269 |
my $sth = $dbh->prepare($request_query); |
272 |
my $sth = $dbh->prepare($request_query); |
270 |
$sth->execute($biblionumber); |
273 |
$sth->execute($biblionumber); |
271 |
- |
|
|