Lines 276-282
sub GetPendingHoldRequestsForBib {
Link Here
|
276 |
|
276 |
|
277 |
my $dbh = C4::Context->dbh; |
277 |
my $dbh = C4::Context->dbh; |
278 |
|
278 |
|
279 |
my $request_query = "SELECT biblionumber, borrowernumber, itemnumber, priority, reserves.branchcode, |
279 |
my $request_query = "SELECT biblionumber, borrowernumber, itemnumber, priority, reserve_id, reserves.branchcode, |
280 |
reservedate, reservenotes, borrowers.branchcode AS borrowerbranch, itemtype, item_level_hold |
280 |
reservedate, reservenotes, borrowers.branchcode AS borrowerbranch, itemtype, item_level_hold |
281 |
FROM reserves |
281 |
FROM reserves |
282 |
JOIN borrowers USING (borrowernumber) |
282 |
JOIN borrowers USING (borrowernumber) |
Lines 441-446
sub MapItemsToHoldRequests {
Link Here
|
441 |
holdingbranch => $item->{holdingbranch}, |
441 |
holdingbranch => $item->{holdingbranch}, |
442 |
pickup_branch => $request->{branchcode} |
442 |
pickup_branch => $request->{branchcode} |
443 |
|| $request->{borrowerbranch}, |
443 |
|| $request->{borrowerbranch}, |
|
|
444 |
reserve_id => $request->{reserve_id}, |
444 |
item_level => $request->{item_level_hold}, |
445 |
item_level => $request->{item_level_hold}, |
445 |
reservedate => $request->{reservedate}, |
446 |
reservedate => $request->{reservedate}, |
446 |
reservenotes => $request->{reservenotes}, |
447 |
reservenotes => $request->{reservenotes}, |
Lines 720-734
sub AddToHoldTargetMap {
Link Here
|
720 |
my $dbh = C4::Context->dbh; |
721 |
my $dbh = C4::Context->dbh; |
721 |
|
722 |
|
722 |
my $insert_sql = q( |
723 |
my $insert_sql = q( |
723 |
INSERT INTO hold_fill_targets (borrowernumber, biblionumber, itemnumber, source_branchcode, item_level_request) |
724 |
INSERT INTO hold_fill_targets (borrowernumber, biblionumber, itemnumber, source_branchcode, item_level_request, reserve_id) |
724 |
VALUES (?, ?, ?, ?, ?) |
725 |
VALUES (?, ?, ?, ?, ?, ?) |
725 |
); |
726 |
); |
726 |
my $sth_insert = $dbh->prepare($insert_sql); |
727 |
my $sth_insert = $dbh->prepare($insert_sql); |
727 |
|
728 |
|
728 |
foreach my $itemnumber (keys %$item_map) { |
729 |
foreach my $itemnumber (keys %$item_map) { |
729 |
my $mapped_item = $item_map->{$itemnumber}; |
730 |
my $mapped_item = $item_map->{$itemnumber}; |
730 |
$sth_insert->execute($mapped_item->{borrowernumber}, $mapped_item->{biblionumber}, $itemnumber, |
731 |
$sth_insert->execute($mapped_item->{borrowernumber}, $mapped_item->{biblionumber}, $itemnumber, |
731 |
$mapped_item->{holdingbranch}, $mapped_item->{item_level}); |
732 |
$mapped_item->{holdingbranch}, $mapped_item->{item_level}, $mapped_item->{reserve_id}); |
732 |
} |
733 |
} |
733 |
} |
734 |
} |
734 |
|
735 |
|