From 2eaabab4703f9142b2bdf9b55deeb74cfdf6ab38 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Jan=20B=C3=BCren?= Date: Sun, 3 Mar 2019 16:47:33 +0100 Subject: [PATCH] SelfTest Transaction zum commit von gerade: weniger false positives MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Bei Buchungen, bei denen nicht ein RecordLink existiert (GL), gelöscht, ist es nicht mehr möglich sauber auf verwaiste Einträge zu testen. Entsprechend min(itime) from bank_transaction_acc_trans als Schwellenwert für Startpunkt der Prüfung von bank_transactions.transdate genommen --- SL/BackgroundJob/SelfTest/Transactions.pm | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/SL/BackgroundJob/SelfTest/Transactions.pm b/SL/BackgroundJob/SelfTest/Transactions.pm index 4d67c35e3..7b70925ed 100644 --- a/SL/BackgroundJob/SelfTest/Transactions.pm +++ b/SL/BackgroundJob/SelfTest/Transactions.pm @@ -15,7 +15,7 @@ sub run { $self->_setup; - $self->tester->plan(tests => 26); + $self->tester->plan(tests => 29); $self->check_konten_mit_saldo_nicht_in_guv; $self->check_bilanzkonten_mit_pos_eur; @@ -681,6 +681,7 @@ sub check_orphaned_bank_transaction_acc_trans_links { SELECT purpose from bank_transactions WHERE invoice_amount <> 0 AND id not in (SELECT bank_transaction_id from bank_transaction_acc_trans) + AND itime > (SELECT min(itime) from bank_transaction_acc_trans) AND transdate >= ? AND transdate <= ?|; my $bt_assigned_no_link = selectall_hashref_query($::form, $self->dbh, $query, $self->fromdate, $self->todate); -- 2.20.1