[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
SF.net SVN: ledger-smb:[2549] branches/1.2/LedgerSMB/IR.pm
- Subject: SF.net SVN: ledger-smb:[2549] branches/1.2/LedgerSMB/IR.pm
- From: ..hidden..
- Date: Mon, 13 Apr 2009 05:02:28 +0000
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.