SF.net SVN: ledger-smb:[4023] branches/1.3

[..hidden..]

Revision: 4023
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=4023&view=rev
Author:   einhverfr
Date:     2011-11-21 03:27:08 +0000 (Mon, 21 Nov 2011)
Log Message:
-----------
Correcting discount_terms not displayed after saving

Modified Paths:
--------------
    branches/1.3/Changelog
    branches/1.3/sql/modules/Company.sql

Modified: branches/1.3/Changelog
===================================================================
--- branches/1.3/Changelog	2011-11-21 01:44:06 UTC (rev 4022)
+++ branches/1.3/Changelog	2011-11-21 03:27:08 UTC (rev 4023)
@@ -14,6 +14,7 @@
 * Fixed SQL errors in Goods and Services/All Items report (David B)
 * Corrected issue saving country in contact.html (Pongracz I)
 * Corrected permission denied to partsgroup_id_seq (Chris T)
+* Corrected discount_terms not being displayed after saving (Chris T)
 
 Chris T is Chris Travers
 David B is David Bandel

Modified: branches/1.3/sql/modules/Company.sql
===================================================================
--- branches/1.3/sql/modules/Company.sql	2011-11-21 01:44:06 UTC (rev 4022)
+++ branches/1.3/sql/modules/Company.sql	2011-11-21 03:27:08 UTC (rev 4023)
@@ -430,11 +430,14 @@
         threshold numeric
 );
 
+DROP TYPE IF EXISTS entity_credit_retrieve CASCADE;
+
 CREATE TYPE entity_credit_retrieve AS (
         id int,
         entity_id int,
         entity_class int,
         discount numeric,
+        discount_terms int,
         taxincluded bool,
         creditlimit numeric,
         terms int2,
@@ -486,7 +489,8 @@
 BEGIN
 	
 	FOR out_row IN 
-		SELECT  c.id, e.id, ec.entity_class, ec.discount,
+		SELECT  c.id, e.id, ec.entity_class, ec.discount, 
+                        ec.discount_terms,
 			ec.taxincluded, ec.creditlimit, ec.terms, 
 			ec.meta_number, ec.description, ec.business_id, 
 			ec.language_code, 

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