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

SF.net SVN: ledger-smb:[6418] branches/1.3/sql/modules/EndOfYear.sql



Revision: 6418
          http://sourceforge.net/p/ledger-smb/code/6418
Author:   pongracz
Date:     2014-01-07 11:00:27 +0000 (Tue, 07 Jan 2014)
Log Message:
-----------
Moving this definition behind its referenced function, otherwise this function only will be created when running setup.pl second time: CREATE OR REPLACE FUNCTION eoy__reopen_books_at(in_reopen_date date)

Modified Paths:
--------------
    branches/1.3/sql/modules/EndOfYear.sql

Property Changed:
----------------
    branches/1.3/sql/modules/EndOfYear.sql

Modified: branches/1.3/sql/modules/EndOfYear.sql
===================================================================
--- branches/1.3/sql/modules/EndOfYear.sql	2014-01-07 10:03:55 UTC (rev 6417)
+++ branches/1.3/sql/modules/EndOfYear.sql	2014-01-07 11:00:27 UTC (rev 6418)
@@ -9,22 +9,6 @@
 is returned is non-determinative and so only the end date shoudl be relied on.
 $$;
 
-CREATE OR REPLACE FUNCTION eoy__reopen_books_at(in_reopen_date date) 
-RETURNS BOOL
-LANGUAGE SQL AS
-$$
-
-    SELECT eoy_reopen_books(end_date) 
-      FROM (SELECT end_date 
-              FROM account_checkpoint
-             WHERE end_date >= $1
-             GROUP BY end_date) eoy_dates
-  ORDER BY end_date;
-
-SELECT eoy_create_checkpoint($1 - 1) > 0;
-
-$$;
-
 CREATE OR REPLACE FUNCTION eoy_create_checkpoint(in_end_date date)
 RETURNS int AS
 $$
@@ -235,3 +219,21 @@
 
 COMMENT ON FUNCTION eoy_earnings_accounts() IS
 $$ Lists equity accounts for the retained earnings dropdown.$$;
+
+
+CREATE OR REPLACE FUNCTION eoy__reopen_books_at(in_reopen_date date) 
+RETURNS BOOL
+LANGUAGE SQL AS
+$$
+
+    SELECT eoy_reopen_books(end_date) 
+      FROM (SELECT end_date 
+              FROM account_checkpoint
+             WHERE end_date >= $1
+             GROUP BY end_date) eoy_dates
+  ORDER BY end_date;
+
+SELECT eoy_create_checkpoint($1 - 1) > 0;
+
+$$;
+


Property changes on: branches/1.3/sql/modules/EndOfYear.sql
___________________________________________________________________
Added: svn:text-time
## -0,0 +1 ##
+2014-01-02T12:27:14.000000Z
\ No newline at end of property
Added: svn:unix-mode
## -0,0 +1 ##
+0775
\ No newline at end of property
Added: svn:owner
## -0,0 +1 ##
+33 www-data
\ No newline at end of property
Added: svn:group
## -0,0 +1 ##
+33 www-data
\ No newline at end of property
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.


------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT 
organizations don't have a clear picture of how application performance 
affects their revenue. With AppDynamics, you get 100% visibility into your 
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits