From 08e4db540ef5dc2b8ca90e27b11b5f8406d68224 Mon Sep 17 00:00:00 2001
From: einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>
Date: Wed, 9 Jan 2008 23:02:03 +0000
Subject: Fixing outstanding invoice reports to ignore unapproved transactions
 by default.

git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2032 4979c152-3d1c-0410-bac9-87ea11338e46
---
 LedgerSMB/AA.pm | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'LedgerSMB/AA.pm')

diff --git a/LedgerSMB/AA.pm b/LedgerSMB/AA.pm
index 835dbe0d..182a6867 100644
--- a/LedgerSMB/AA.pm
+++ b/LedgerSMB/AA.pm
@@ -958,7 +958,8 @@ sub transactions {
     
     # 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);
-- 
cgit v1.2.3