SF.net SVN: ledger-smb: [2032] trunk/LedgerSMB/AA.pm

[..hidden..]

Revision: 2032
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2032&view=rev
Author:   einhverfr
Date:     2008-01-09 15:02:03 -0800 (Wed, 09 Jan 2008)

Log Message:
-----------
Fixing outstanding invoice reports to ignore unapproved transactions by default.

Modified Paths:
--------------
    trunk/LedgerSMB/AA.pm

Modified: trunk/LedgerSMB/AA.pm
===================================================================
--- trunk/LedgerSMB/AA.pm	2008-01-09 22:35:21 UTC (rev 2031)
+++ trunk/LedgerSMB/AA.pm	2008-01-09 23:02:03 UTC (rev 2032)
@@ -958,7 +958,8 @@
     
     # the third state, all invoices, sets no explicit toggles. It just selects them all, as normal. 
 
-    $query .= "WHERE $where
+    $approved = ($form->{approved}) ? 'NULL' : 'FALSE';
+    $query .= "WHERE (coalesce($approved, TRUE) OR a.approved) AND $where
 			ORDER BY $sortorder";
     my $sth = $dbh->prepare($query);
     $sth->execute(@paidargs) || $form->dberror($query);


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