Lines 2171-2177
sub _FixAccountForLostAndReturned {
Link Here
|
2171 |
# FIXME: move prepares outside while loop! |
2171 |
# FIXME: move prepares outside while loop! |
2172 |
my $usth = $dbh->prepare("UPDATE accountlines SET amountoutstanding= ? |
2172 |
my $usth = $dbh->prepare("UPDATE accountlines SET amountoutstanding= ? |
2173 |
WHERE (accountlines_id = ?)"); |
2173 |
WHERE (accountlines_id = ?)"); |
2174 |
$usth->execute($newamtos,'$thisacct'); # FIXME: '$thisacct' is a string literal! |
2174 |
$usth->execute($newamtos,$thisacct); |
2175 |
$usth = $dbh->prepare("INSERT INTO accountoffsets |
2175 |
$usth = $dbh->prepare("INSERT INTO accountoffsets |
2176 |
(borrowernumber, accountno, offsetaccount, offsetamount) |
2176 |
(borrowernumber, accountno, offsetaccount, offsetamount) |
2177 |
VALUES |
2177 |
VALUES |
2178 |
- |
|
|