[Astpp-commit] SF.net SVN: astpp:[2298] trunk/modules/ASTPP/lib/ASTPP.pm

[<dar...@us...>]

Revision: 2298
          http://astpp.svn.sourceforge.net/astpp/?rev=2298&view=rev
Author:   darrenkw
Date:     2009-11-01 00:42:37 +0000 (Sun, 01 Nov 2009)

Log Message:
-----------
Fixed a bug in the balance calculation code.

Modified Paths:
--------------
    trunk/modules/ASTPP/lib/ASTPP.pm

Modified: trunk/modules/ASTPP/lib/ASTPP.pm
===================================================================
--- trunk/modules/ASTPP/lib/ASTPP.pm	2009-11-01 00:13:47 UTC (rev 2297)
+++ trunk/modules/ASTPP/lib/ASTPP.pm	2009-11-01 00:42:37 UTC (rev 2298)
@@ -1433,9 +1433,11 @@
 	my ($self, %arg) = @_;
     my ( $tmp, $sql, $row, $debit, $credit, $balance, $posted_balance );
     $tmp = "SELECT SUM(cdrs.debit),SUM(cdrs.credit),accounts.balance "
-	. " from cdrs,accounts WHERE cardnum = "
+	. " from cdrs,accounts WHERE cdrs.cardnum = "
         . $self->{_astpp_db}->quote($arg{account})
-	. " AND cdrs.status NOT IN(1,2)";
+	. " AND cdrs.status NOT IN(1,2)"
+	. " AND accounts.number = "
+        . $self->{_astpp_db}->quote($arg{account});
     $sql =
       $self->{_astpp_db}->prepare($tmp);
     $sql->execute;


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.