|
Lines 2164-2172
sub MarkIssueReturned {
Link Here
|
| 2164 |
# FIXME transaction |
2164 |
# FIXME transaction |
| 2165 |
my $sth_upd = $dbh->prepare($query); |
2165 |
my $sth_upd = $dbh->prepare($query); |
| 2166 |
$sth_upd->execute(@bind); |
2166 |
$sth_upd->execute(@bind); |
| 2167 |
my $sth_copy = $dbh->prepare('INSERT INTO old_issues SELECT * FROM issues |
2167 |
my $sth_copy = $dbh->prepare(q| |
| 2168 |
WHERE borrowernumber = ? |
2168 |
INSERT INTO old_issues( issue_id, borrowernumber, itemnumber, date_due, branchcode, returndate, lastreneweddate, `return`, renewals, auto_renew, timestamp, issuedate, onsite_checkout ) |
| 2169 |
AND itemnumber = ?'); |
2169 |
SELECT issue_id, borrowernumber, itemnumber, date_due, branchcode, returndate, lastreneweddate, `return`, renewals, auto_renew, timestamp, issuedate, onsite_checkout |
|
|
2170 |
FROM issues |
| 2171 |
WHERE borrowernumber = ? |
| 2172 |
AND itemnumber = ? |
| 2173 |
|); |
| 2170 |
$sth_copy->execute($borrowernumber, $itemnumber); |
2174 |
$sth_copy->execute($borrowernumber, $itemnumber); |
| 2171 |
# anonymise patron checkout immediately if $privacy set to 2 and AnonymousPatron is set to a valid borrowernumber |
2175 |
# anonymise patron checkout immediately if $privacy set to 2 and AnonymousPatron is set to a valid borrowernumber |
| 2172 |
if ( $privacy == 2) { |
2176 |
if ( $privacy == 2) { |
| 2173 |
- |
|
|