Revision 72b10cee
Von Jan Büren vor mehr als 5 Jahren hinzugefügt
| SL/Controller/BankTransaction.pm | ||
|---|---|---|
| 791 | 791 |
my $query = qq|UPDATE $type SET paid = |
| 792 | 792 |
(SELECT COALESCE(abs(sum(amount)),0) FROM acc_trans |
| 793 | 793 |
WHERE trans_id = ? |
| 794 |
AND chart_link ilike '%paid%')|; |
|
| 794 |
AND chart_link ilike '%paid%') |
|
| 795 |
WHERE id = ?|; |
|
| 795 | 796 |
|
| 796 |
die if (do_query($::form, $bank_transaction->db->dbh, $query, $trans_id) == -1); |
|
| 797 |
die if (do_query($::form, $bank_transaction->db->dbh, $query, $trans_id, $trans_id) == -1);
|
|
| 797 | 798 |
} |
| 798 | 799 |
# 4. and delete all (if any) record links |
| 799 | 800 |
my $rl = SL::DB::Manager::RecordLink->delete_all(where => [ from_id => $bt_id, from_table => 'bank_transactions' ]); |
Auch abrufbar als: Unified diff
Kontoauszug rückgängig machen: Nur bei aktuellem Beleg arap.paid neu setzen