View | Details | Raw Unified | Return to bug 40529
Collapse All | Expand All

(-)a/C4/HoldsQueue.pm (-2 / +4 lines)
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
- 

Return to bug 40529