Merging in David Mora's payment changes. Still working on the template and workflow scripts.

git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1735 4979c152-3d1c-0410-bac9-87ea11338e46

1 files changed, 17 insertions, 0 deletions

diff --git a/sql/modules/Date.sql b/sql/modules/Date.sql
new file mode 100644
index 00000000..7b942c2a
--- /dev/null
+++ b/sql/modules/Date.sql
@@ -0,0 +1,17 @@
+CREATE OR REPLACE FUNCTION date_get_all_years() returns setof INT AS
+$$
+DECLARE
+    date_out record;
+    BEGIN
+        FOR date_out IN
+           SELECT EXTRACT('YEAR' from transdate) AS year
+           FROM acc_trans
+           GROUP BY EXTRACT('YEAR' from transdate)
+           ORDER BY year
+        LOOP
+             return next date_out.year;
+        END LOOP;
+    END;
+$$ language plpgsql;                                                                  
+COMMENT ON FUNCTION date_get_all_years() IS
+$$ This function return each year inside transdate in transactions. $$;