|
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 |
|