Zmiany pomiędzy wersją 7 and wersją 8 dla DeployerGuide/Customization/ProcessAutomation/Examples

Data i czas:

01/19/12 20:54:52 (12 years temu)

Autor:

JP (IP: 89.72.141.179)

Komentarz:

--

DeployerGuide/Customization/ProcessAutomation/Examples

@@ -64 +64 @@
 SELECT ARRAY(SELECT o.orunid FROM orgtree_view WHERE o.usr_id IN ({procedures.OSOBY}))
 
+-- 
+-- P6. Przypisanie osoby odpowiedzialnej za MPK wpisane w fakturze (do etapu MULTI)
+SELECT ARRAY ( 
+  SELECT CASE 
+    WHEN x.ndetpe = 'POST' THEN x.orunid 
+    WHEN x.ndetpe = 'ORGCELL' THEN (SELECT o2.orunid FROM orgtree_view o2 WHERE o2.prn_id = x.orunid LIMIT 1) END 
+  FROM 
+  (SELECT DISTINCT mpk.orunid, o.ndetpe FROM vatnote_costs 
+   LEFT JOIN places_of_vcosts AS mpk USING (povcid) 
+   LEFT JOIN orgtree_view AS o ON mpk.orunid = o.orunid 
+   WHERE doc_id = {DOC_ID}) 
+  AS x)
+
 }}}