Lines 267-273
sub GetBibsWithPendingHoldRequests {
Link Here
|
267 |
|
267 |
|
268 |
$sth->execute(); |
268 |
$sth->execute(); |
269 |
my $biblionumbers = $sth->fetchall_arrayref(); |
269 |
my $biblionumbers = $sth->fetchall_arrayref(); |
270 |
|
|
|
271 |
return [ map { $_->[0] } @$biblionumbers ]; |
270 |
return [ map { $_->[0] } @$biblionumbers ]; |
272 |
} |
271 |
} |
273 |
|
272 |
|
Lines 299-304
sub GetPendingHoldRequestsForBib {
Link Here
|
299 |
|
298 |
|
300 |
my $dbh = C4::Context->dbh; |
299 |
my $dbh = C4::Context->dbh; |
301 |
|
300 |
|
|
|
301 |
my $skip_non_target_holds_query = Koha::HoldGroup::skip_non_target_holds_query('sql'); |
302 |
my $skip_non_target_holds_query_sql = $skip_non_target_holds_query ? " $skip_non_target_holds_query" : ''; |
303 |
|
302 |
my $request_query = "SELECT biblionumber, borrowernumber, itemnumber, priority, reserve_id, reserves.branchcode, |
304 |
my $request_query = "SELECT biblionumber, borrowernumber, itemnumber, priority, reserve_id, reserves.branchcode, |
303 |
reservedate, reservenotes, borrowers.branchcode AS borrowerbranch, itemtype, item_level_hold, item_group_id |
305 |
reservedate, reservenotes, borrowers.branchcode AS borrowerbranch, itemtype, item_level_hold, item_group_id |
304 |
FROM reserves |
306 |
FROM reserves |
Lines 309-314
sub GetPendingHoldRequestsForBib {
Link Here
|
309 |
AND reservedate <= CURRENT_DATE() |
311 |
AND reservedate <= CURRENT_DATE() |
310 |
AND suspend = 0 "; |
312 |
AND suspend = 0 "; |
311 |
$request_query .= "AND reserve_id NOT IN (SELECT reserve_id FROM hold_fill_targets) " if $unallocated; |
313 |
$request_query .= "AND reserve_id NOT IN (SELECT reserve_id FROM hold_fill_targets) " if $unallocated; |
|
|
314 |
$request_query .= $skip_non_target_holds_query_sql; |
312 |
$request_query .= "ORDER BY priority"; |
315 |
$request_query .= "ORDER BY priority"; |
313 |
my $sth = $dbh->prepare($request_query); |
316 |
my $sth = $dbh->prepare($request_query); |
314 |
$sth->execute($biblionumber); |
317 |
$sth->execute($biblionumber); |
315 |
- |
|
|