SF.net SVN: ledger-smb:[6705] trunk/sql/modules/arap.sql

[..hidden..]

Revision: 6705
          http://sourceforge.net/p/ledger-smb/code/6705
Author:   tshvr
Date:     2014-01-29 09:44:41 +0000 (Wed, 29 Jan 2014)
Log Message:
-----------
attempt to mimic AA.pm,sub post_transaction

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

Modified: trunk/sql/modules/arap.sql
===================================================================
--- trunk/sql/modules/arap.sql	2014-01-29 09:40:08 UTC (rev 6704)
+++ trunk/sql/modules/arap.sql	2014-01-29 09:44:41 UTC (rev 6705)
@@ -174,7 +174,8 @@
  select person__get_my_entity_id into person_id from person__get_my_entity_id();
  SELECT value::bool INTO separate_duties FROM defaults WHERE setting_key='separate_duties';
  IF separate_duties = true THEN
-  RAISE EXCEPTION 'separate_duties not yet treated';
+  --RAISE EXCEPTION 'separate_duties not yet treated';
+  approved=false;
  END IF;
  select eca.taxform_id::int into taxform_id from entity_credit_account eca where eca.id=in_entity_credit_account;
  IF taxform_id <> 0 THEN
@@ -185,7 +186,8 @@
  duedate=coalesce(in_duedate,'today');
  crdate=now();
 
- IF in_invnumber IS NULL OR (length(trim(in_invnumber))=0) THEN
+ --IF in_invnumber IS NULL OR (length(trim(in_invnumber))=0) THEN --NULL as only designator for "no value supplied"
+ IF in_invnumber IS NULL THEN
   select setting_increment::text INTO invnumber FROM setting_increment('vinumber');
  ELSE
   invnumber=in_invnumber;
@@ -262,6 +264,7 @@
 --To Test:
 --select * from AP_simple_post(4,66,null,null,null,'DL','descr','ordnr','notes','intnotes','ponr',ARRAY['a','b'],ARRAY[100.556,205.308],ARRAY[71,95],ARRAY[0.06,0.21],ARRAY[74,70]);
 --select * from AP_simple_post(4,66,null,null,null,null,'descr','ordnr','notes','intnotes','ponr',ARRAY['a','b'],ARRAY[100.556,205.308],ARRAY[71,95],ARRAY[0.06,0.21],ARRAY[74,70]);
+--select * from AP_simple_post(4,66,'',null,null,null,'descr','ordnr','notes','intnotes','ponr',ARRAY['a','b'],ARRAY[100.556,205.308],ARRAY[71,95],ARRAY[0.06,0.21],ARRAY[74,70]);
 --select * from AP_simple_post(4,66,null,null,null,null,'descr','ordnr','notes','intnotes','ponr',ARRAY['a','b'],ARRAY[100.556,205.308],ARRAY[71,95],ARRAY[null,0.21],ARRAY[74,70]);
 --select * from AP_simple_post(4,66,null,null,null,null,'descr','ordnr','notes','intnotes','ponr',ARRAY['a','b'],ARRAY[100.556,205.308],ARRAY[71,95],ARRAY[0.06,0.21],ARRAY[null,70]);
 --tshvr4 first attempt to mimic AA.pm,sub post_transaction in PLPGSQL function end

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


------------------------------------------------------------------------------
WatchGuard Dimension instantly turns raw network data into actionable 
security intelligence. It gives you real-time visual feedback on key
security issues and trends.  Skip the complicated setup - simply import
a virtual appliance and go from zero to informed in seconds.
http://pubads.g.doubleclick.net/gampad/clk?id=123612991&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits