SF.net SVN: ledger-smb:[6383] trunk/sql/modules/Transaction_Templates.sql

[..hidden..]

Revision: 6383
          http://sourceforge.net/p/ledger-smb/code/6383
Author:   einhverfr
Date:     2014-01-05 09:59:30 +0000 (Sun, 05 Jan 2014)
Log Message:
-----------
Removing not-yet-supported recurring logic of template transactions

Modified Paths:
--------------
    trunk/sql/modules/Transaction_Templates.sql

Modified: trunk/sql/modules/Transaction_Templates.sql
===================================================================
--- trunk/sql/modules/Transaction_Templates.sql	2014-01-05 09:52:59 UTC (rev 6382)
+++ trunk/sql/modules/Transaction_Templates.sql	2014-01-05 09:59:30 UTC (rev 6383)
@@ -102,7 +102,7 @@
 			j.is_template, eca.meta_number, 
 			e.name, ec.class, 
                         coalesce(
-                          r.startdate + r.recurring_interval,
+                          r.startdate + 0, -- r.recurring_interval,
                           j.transaction_date)
 		FROM journal_entry j
 		LEFT JOIN eca_invoice i ON (i.journal_id = j.id)
@@ -149,6 +149,7 @@
 $$ language sql;
 -- orders with inventory not supported yet.
 
+/*
 CREATE OR REPLACE FUNCTION journal__save_recurring
 (in_recurringreference text, in_recurringstartdate date, 
 in_recurring_interval interval, in_recurringhowmany int, in_id int) 
@@ -159,7 +160,7 @@
 insert into recurring (id, reference, startdate, recurring_interval, howmany)
 values ($5, $1, $2, $3, $4)
 returning *;
-$$;
+$$; */
 
 CREATE OR REPLACE FUNCTION journal__save_recurring_print
 (in_id int, in_formname text, in_printer text)
@@ -170,6 +171,7 @@
 returning *;
 $$;
 
+/*
 CREATE OR REPLACE FUNCTION journal__increment_recurring
 (in_id int, in_transdate date)
 RETURNS recurring LANGUAGE SQL AS
@@ -179,7 +181,7 @@
        nextdate = $2::timestamp + recurring_interval
  WHERE id = $1 AND howmany > 0
 RETURNING *;
-$$;
+$$; */
 
 update defaults set value = 'yes' where setting_key = 'module_load_ok';
 

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