[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

SF.net SVN: ledger-smb:[2549] branches/1.2/LedgerSMB/IR.pm



Revision: 2549
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2549&view=rev
Author:   einhverfr
Date:     2009-04-13 05:02:28 +0000 (Mon, 13 Apr 2009)

Log Message:
-----------
Further correcting never-closed handling

Modified Paths:
--------------
    branches/1.2/LedgerSMB/IR.pm

Modified: branches/1.2/LedgerSMB/IR.pm
===================================================================
--- branches/1.2/LedgerSMB/IR.pm	2009-04-13 04:31:43 UTC (rev 2548)
+++ branches/1.2/LedgerSMB/IR.pm	2009-04-13 05:02:28 UTC (rev 2549)
@@ -406,10 +406,10 @@
 				            project_id, invoice_id,
 				            transdate) 
 				     VALUES (?, ?, ?, ?,
-				            ?, (SELECT CASE WHEN ? > value::date
-				                            THEN ?
-				                            ELSE value::date +
+				            ?, (SELECT CASE WHEN ? <= value::date
+				                            THEN value::date +
 				                               '1 day'::interval
+				                            ELSE ?
 				                        END AS value 
 				                  FROM defaults
 				                  WHERE setting_key = 'closedto'


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