From c4cea46304b614d334cb4cb932aa65e53cf9abf2 Mon Sep 17 00:00:00 2001 From: "G. Richardson" Date: Tue, 30 Jun 2020 14:02:41 +0200 Subject: [PATCH] Chart cache_taxkeys - startdate korrekt abfragen Ansonsten werden Buchungen am 1.7.2020 (= startdate) nicht richtig zugeordnet. --- SL/DB/Manager/Chart.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/SL/DB/Manager/Chart.pm b/SL/DB/Manager/Chart.pm index 4d11960d7..d70e7f939 100644 --- a/SL/DB/Manager/Chart.pm +++ b/SL/DB/Manager/Chart.pm @@ -135,7 +135,7 @@ sub cache_taxkeys { my $rows = selectall_hashref_query($::form, $::form->get_standard_dbh, <<"", $date); SELECT DISTINCT ON (chart_id) chart_id, startdate, id FROM taxkeys - WHERE startdate < ? + WHERE startdate <= ? ORDER BY chart_id, startdate DESC; for (@$rows) { -- 2.20.1