|
Lines 277-283
sub GetPendingHoldRequestsForBib {
Link Here
|
| 277 |
AND priority > 0 |
277 |
AND priority > 0 |
| 278 |
AND reservedate <= CURRENT_DATE() |
278 |
AND reservedate <= CURRENT_DATE() |
| 279 |
AND suspend = 0 "; |
279 |
AND suspend = 0 "; |
| 280 |
$request_query .= "AND reserve_id NOT IN (SELECT reserve_id FROM tmp_holdsqueue " if $unallocated; |
280 |
$request_query .= "AND reserve_id NOT IN (SELECT reserve_id FROM tmp_holdsqueue) " if $unallocated; |
| 281 |
$request_query .= "ORDER BY priority"; |
281 |
$request_query .= "ORDER BY priority"; |
| 282 |
my $sth = $dbh->prepare($request_query); |
282 |
my $sth = $dbh->prepare($request_query); |
| 283 |
$sth->execute($biblionumber); |
283 |
$sth->execute($biblionumber); |