From b3e7f0164d41f3fae5631dd5e30736f40f49a998 Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Wed, 22 Nov 2006 15:33:08 +0000 Subject: [PATCH] Recommit von r1001 von skoehler: 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