SF.net SVN: ledger-smb: [2130] trunk

[..hidden..]

Revision: 2130
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2130&view=rev
Author:   einhverfr
Date:     2008-05-09 10:49:14 -0700 (Fri, 09 May 2008)

Log Message:
-----------
Correcting issues saving/retriving tax id for vendors/customers, and retrieving the cash id.

Modified Paths:
--------------
    trunk/UI/Contact/contact.html
    trunk/sql/modules/Company.sql
    trunk/sql/modules/Roles.sql

Modified: trunk/UI/Contact/contact.html
===================================================================
--- trunk/UI/Contact/contact.html	2008-04-07 22:28:06 UTC (rev 2129)
+++ trunk/UI/Contact/contact.html	2008-05-09 17:49:14 UTC (rev 2130)
@@ -220,8 +220,8 @@
             <td>
 		<?lsmb INCLUDE input element_data = {
 			label = text('Tax Number/SSN:'),
-			name = "taxnumber",
-			value = taxnumber,
+			name = "tax_id",
+			value = tax_id,
 			type = "text",
 			size = "19"
 		} #' ?>
@@ -276,8 +276,8 @@
                 } ?>
            </td>
            <td> <?lsmb INCLUDE select element_data = {
-			name = "payment_account_id"
-			default_values = [payment_account_id]
+			name = "cash_account_id"
+			default_values = [cash_account_id]
 			options = cash_acc_list
 			label = text('Payment')
 			text_attr = "text"

Modified: trunk/sql/modules/Company.sql
===================================================================
--- trunk/sql/modules/Company.sql	2008-04-07 22:28:06 UTC (rev 2129)
+++ trunk/sql/modules/Company.sql	2008-05-09 17:49:14 UTC (rev 2130)
@@ -144,6 +144,7 @@
         enddate date,
         ar_ap_account_id int,
         cash_account_id int,
+	tax_id text,
         threshold numeric
 );
 
@@ -161,7 +162,7 @@
 		ec.taxincluded, ec.creditlimit, ec.terms, ec.meta_number,
 		ec.business_id, ec.language_code, ec.pricegroup_id, 
 		ec.curr::char(3), ec.startdate, ec.enddate, ec.ar_ap_account_id,
-		ec.cash_account_id, ec.threshold
+		ec.cash_account_id, c.tax_id, ec.threshold
 	INTO out_row
 	FROM company c
 	JOIN entity e ON (c.entity_id = e.id)

Modified: trunk/sql/modules/Roles.sql
===================================================================
--- trunk/sql/modules/Roles.sql	2008-04-07 22:28:06 UTC (rev 2129)
+++ trunk/sql/modules/Roles.sql	2008-05-09 17:49:14 UTC (rev 2130)
@@ -577,6 +577,7 @@
 
 GRANT INSERT ON acc_trans TO "lsmb_<?lsmb dbname ?>__process_payment";
 GRANT ALL ON acc_trans_entry_id_seq TO "lsmb_<?lsmb dbname ?>__process_payment";
+GRANT UPDATE ON ap TO "lsmb_<?lsmb dbname ?>__process_payment";
 
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
@@ -591,6 +592,7 @@
 
 GRANT INSERT ON acc_trans TO "lsmb_<?lsmb dbname ?>__process_receipt";
 GRANT ALL ON acc_trans_entry_id_seq TO "lsmb_<?lsmb dbname ?>__process_receipt";
+GRANT UPDATE ON ar TO "lsmb_<?lsmb dbname ?>__process_receipt";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (35, 'allow', 'lsmb_<?lsmb dbname ?>__process_receipt');


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