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