Zmiany pomiędzy wersją 63 and wersją 64 dla DeployerGuide/Customization/ProcessAutomation/Examples

Data i czas:

12/31/18 12:07:57 (7 years temu)

Autor:

JP (IP: 83.144.106.170)

Komentarz:

--

DeployerGuide/Customization/ProcessAutomation/Examples

@@ -111 +111 @@
 SELECT EXISTS(SELECT * FROM global_sys_conf WHERE (SELECT regexp_matches(objnam,  '_(\d+)$'))[1]::int = {LOGGED_USR_ID})
 }}}
+
+
+W14. 
+-- sprawdzenie czy są uzupełnione cechy na kliencie, do którego jest kierowana oferta
+SELECT x.potrzeba IS NOT NULL
+AND x.segment IS NOT NULL
+AND x.zrodlo IS NOT NULL
+AND x.branza IS NOT NULL
+FROM (  
+ SELECT 
+ (SELECT ftopnm FROM features_opt_view fop WHERE fop.featid = 11 AND fop.tbl_id = fod.contid) AS segment,
+ (SELECT ftopnm FROM features_opt_view fop WHERE fop.featid = 17 AND fop.tbl_id = fod.contid) AS zrodlo,
+ (SELECT ftopnm FROM features_opt_view fop WHERE fop.featid = 13 AND fop.tbl_id = fod.contid) AS branza,
+ (SELECT data__ FROM features_text_view ftv WHERE ftv.featid = 26 AND ftv.tbl_id = fod.contid) AS potrzeba      
+ FROM documents d 
+ INNER JOIN fk_offer_documents fod USING(doc_id)
+ INNER JOIN contacts c1 ON c1.contid = fod.contid
+ WHERE d.doc_id = {DOC_ID}) x
+
+
+W15.
+-- sprawdzenie czy są uzupełnione cechy na fakturze do którego odbiorcy, lub klienta końcowego oznaczonego na cesze faktury jako klient z bazy - jest kierowana faktura
+SELECT x.typ IS NOT NULL
+AND x.segment IS NOT NULL
+AND x.zrodlo IS NOT NULL
+AND x.branza IS NOT NULL
+FROM (
+SELECT 
+ (SELECT text_sum(ftopnm) FROM features_opt_view fop WHERE fop.featid = 12 AND fop.ftopid IN (7,9, 28) AND fop.tbl_id = (COALESCE(ftv.data__::int, v.toctid))) AS typ,
+ (SELECT ftopnm FROM features_opt_view fop WHERE fop.featid = 11 AND fop.tbl_id = (COALESCE(ftv.data__::int, v.toctid))) AS segment,
+ (SELECT ftopnm FROM features_opt_view fop WHERE fop.featid = 17 AND fop.tbl_id = (COALESCE(ftv.data__::int, v.toctid))) AS zrodlo,
+ (SELECT ftopnm FROM features_opt_view fop WHERE fop.featid = 13 AND fop.tbl_id = (COALESCE(ftv.data__::int, v.toctid))) AS branza
+ FROM documents d 
+ INNER JOIN vatnote v USING(doc_id)
+ INNER JOIN contacts c1 ON c1.contid = v.toctid
+ LEFT JOIN features_text_view ftv ON ftv.tbl_id = d.doc_id AND ftv.featid = 15 -- klient końcowy
+ LEFT JOIN contacts c2 ON c2.contid = ftv.data__::int 
+ WHERE d.doc_id = 352273) x
+
 
 == PRZYPISANIA ==