Recommit von r1001 von skoehler: Behebt/umgeht Bug 323. SQL-Fehler bei Kontenabgeleic...

diff --git a/SL/RC.pm b/SL/RC.pm
index 63a41f434c1e8bab99e1c5047cbf1f36593cfddd..6de28ab65e01ec8be997ab6f74a90f64d4604a63 100644 (file)
--- 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
   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}'
                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 2a174297456d5717c9dbaba4f9f823050c7720b1..d9e395cdab566982f1a7d9ad66c40673d1eb6898 100644 (file)
--- a/bin/mozilla/rc.pl
+++ b/bin/mozilla/rc.pl
@@ -147,13 +147,13 @@ sub display_form {
     $option .= "\n<br>" if ($option);
     $option .=
         $locale->text('From') . "&nbsp;"
     $option .= "\n<br>" if ($option);
     $option .=
         $locale->text('From') . "&nbsp;"

-      . $locale->date(\%myconfig, $form->{fromdate}, 1);
+      . $locale->date(\%myconfig, $form->{fromdate}, 0);

   }
   if ($form->{todate}) {
     $option .= "\n<br>" if ($option);
     $option .=
   }
   if ($form->{todate}) {
     $option .= "\n<br>" if ($option);
     $option .=

-        $locale->text('To') . "&nbsp;"
-      . $locale->date(\%myconfig, $form->{todate}, 1);
+        $locale->text('Bis') . "&nbsp;"
+      . $locale->date(\%myconfig, $form->{todate}, 0);

   }
 
   $form->{title} = "$form->{accno}--$form->{account}";
   }
 
   $form->{title} = "$form->{accno}--$form->{account}";