Correcting NULL entity_id errors saving vendor

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

1 files changed, 8 insertions, 8 deletions

diff --git a/sql/modules/Company.sql b/sql/modules/Company.sql
index b5dd76cc..d653d9f7 100644
--- a/sql/modules/Company.sql
+++ b/sql/modules/Company.sql
@@ -237,8 +237,11 @@ CREATE OR REPLACE FUNCTION company_save (
 DECLARE t_entity_id INT;
 	t_company_id INT;
 BEGIN
+	t_company_id := in_id;
+
 	IF in_entity_id IS NULL THEN
 		IF in_id IS NULL THEN
+			RAISE NOTICE 'in_id is null';
 			SELECT id INTO t_company_id FROM company
 			WHERE legal_name = in_name AND 
 				(tax_id = in_tax_id OR 
@@ -247,32 +250,29 @@ BEGIN
 		IF t_company_id IS NOT NULL THEN
 			SELECT entity_id INTO t_entity_id FROM company
 			WHERE id = t_company_id;
+			
 		END IF;
 	ELSE
 		t_entity_id := in_entity_id;
 	END IF;
-	IF in_entity_id IS NULL THEN
+	IF t_entity_id IS NULL THEN
 		INSERT INTO entity (name, entity_class)
 		VALUES (in_name, in_entity_class);
 		t_entity_id := currval('entity_id_seq');
-	ELSE 
-		t_entity_id := in_entity_id;
 	END IF;
 
 	UPDATE company
 	SET legal_name = in_name,
 		tax_id = in_tax_id,
 		sic_code = in_sic_code
-	WHERE id = in_id;
+	WHERE id = t_company_id;
 
-	IF FOUND THEN
-		RETURN in_id;
-	ELSE
+	IF NOT FOUND THEN
 		INSERT INTO company(entity_id, legal_name, tax_id, sic_code)
 		VALUES (t_entity_id, in_name, in_tax_id, in_sic_code);
 
-		RETURN currval('company_id_seq');
 	END IF;
+	RETURN t_entity_id;
 END;
 $$ LANGUAGE PLPGSQL;