SF.net SVN: ledger-smb:[2800] addons/1.3/assets/trunk/sql/modules/Assets. sql

[..hidden..]

Revision: 2800
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2800&view=rev
Author:   einhverfr
Date:     2009-12-04 20:31:24 +0000 (Fri, 04 Dec 2009)

Log Message:
-----------
Committing missing change on asset save routines.

Modified Paths:
--------------
    addons/1.3/assets/trunk/sql/modules/Assets.sql

Modified: addons/1.3/assets/trunk/sql/modules/Assets.sql
===================================================================
--- addons/1.3/assets/trunk/sql/modules/Assets.sql	2009-12-04 20:26:21 UTC (rev 2799)
+++ addons/1.3/assets/trunk/sql/modules/Assets.sql	2009-12-04 20:31:24 UTC (rev 2800)
@@ -245,7 +245,8 @@
 (in_id int, in_asset_class int, in_description text, in_tag text, 
 in_purchase_date date, in_purchase_value numeric,
 in_usable_life numeric, in_salvage_value numeric, in_location_id int, 
-in_department_id int, in_invoice_id int)
+in_department_id int, in_invoice_id int, 
+in_asset_account_id int, in_dep_account_id int)
 returns asset_item AS
 $$
 DECLARE ret_val asset_item;
@@ -260,7 +261,9 @@
 		location_id = in_location_id,
 		department_id = in_department_id,
 		invoice_id = in_invoice_id,
-		salvage_value = in_salvage_value
+		salvage_value = in_salvage_value,
+                asset_account_id = in_asset_account_id,
+                dep_account_id = in_dep_account_id
 	WHERE id = in_id;
 	IF FOUND THEN
 		SELECT * INTO ret_val WHERE id = in_id;
@@ -269,10 +272,11 @@
 
 	INSERT INTO asset_item (asset_class_id, description, tag, purchase_date,
 		purchase_value, usable_life, salvage_value, department_id,
-		warehouse_id, invoice_id)
+		warehouse_id, invoice_id, asset_account_id, dep_account_id)
 	VALUES (in_asset_class, in_description, in_tag, in_purchase_date,
 		in_purchase_value, in_usable_life, in_salvage_value,
-		in_department_id, in_warehouse_id, in_invoice_id);
+		in_department_id, in_warehouse_id, in_invoice_id,
+                in_asset_account_id, in_dep_account_id);
 
 	SELECT * INTO ret_val FROM asset_item 
 	WHERE id = currval('asset_item_id_seq');


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