From e2cf91039d3348cb733e66d04734926c2c9da209 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Stephan=20K=C3=B6hler?= Date: Mon, 20 Mar 2006 14:41:34 +0000 Subject: [PATCH] Behebt/umgeht Bug 323. SQL-Fehler bei Kontenabgeleich, wenn Datum ausgewaehlt wurde. Anzeige des Datums im Bericht als Ziffern (Routine date(...) gibt den Monat nicht in der deutschen Sprache zurueck) --- SL/RC.pm | 2 +- bin/mozilla/rc.pl | 6 +++--- 2 files changed, 4 insertions(+), 4 deletions(-) diff --git a/SL/RC.pm b/SL/RC.pm index 63a41f434..6de28ab65 100644 --- a/SL/RC.pm +++ b/SL/RC.pm @@ -73,7 +73,7 @@ sub payment_transactions { if ($form->{fromdate}) { $query = qq|SELECT sum(a.amount), (SELECT DISTINCT c2.category FROM chart c2 - WHERE c2accno = '$form->{accno}') AS category + WHERE c2.accno = '$form->{accno}') AS category FROM acc_trans a JOIN chart c ON (c.id = a.chart_id) WHERE a.transdate < date '$form->{fromdate}' diff --git a/bin/mozilla/rc.pl b/bin/mozilla/rc.pl index 2a1742974..d9e395cda 100644 --- a/bin/mozilla/rc.pl +++ b/bin/mozilla/rc.pl @@ -147,13 +147,13 @@ sub display_form { $option .= "\n
" if ($option); $option .= $locale->text('From') . " " - . $locale->date(\%myconfig, $form->{fromdate}, 1); + . $locale->date(\%myconfig, $form->{fromdate}, 0); } if ($form->{todate}) { $option .= "\n
" if ($option); $option .= - $locale->text('To') . " " - . $locale->date(\%myconfig, $form->{todate}, 1); + $locale->text('Bis') . " " + . $locale->date(\%myconfig, $form->{todate}, 0); } $form->{title} = "$form->{accno}--$form->{account}"; -- 2.20.1