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

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

Return to bug 18242