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

Data i czas:

12/31/18 12:13:07 (6 years temu)

Autor:

JP (IP: 83.144.106.170)

Komentarz:

--

DeployerGuide/Customization/ProcessAutomation/Examples

@@ -132 +132 @@
 
 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
+-- sprawdzenie czy są uzupełnione cechy na fakturze do którego nabywcy (lub odbiorcy jeśli jest uzupełniony) , albo klienta końcowego oznaczonego na cesze faktury jako klient z bazy - jest kierowana faktura - są uzupełnione cechy typ. segment, źródło, branża
 SELECT x.typ IS NOT NULL
 AND x.segment IS NOT NULL
@@ -139 +139 @@
 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
+ (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, c1.contid))) AS typ,
+ (SELECT ftopnm FROM features_opt_view fop WHERE fop.featid = 11 AND fop.tbl_id = (COALESCE(ftv.data__::int, c1.contid))) AS segment,
+ (SELECT ftopnm FROM features_opt_view fop WHERE fop.featid = 17 AND fop.tbl_id = (COALESCE(ftv.data__::int, c1.contid))) AS zrodlo,
+ (SELECT ftopnm FROM features_opt_view fop WHERE fop.featid = 13 AND fop.tbl_id = (COALESCE(ftv.data__::int, c1.contid))) AS branza
  FROM documents d 
  INNER JOIN vatnote v USING(doc_id)
- INNER JOIN contacts c1 ON c1.contid = v.toctid
+ INNER JOIN contacts c1 ON c1.contid = COALESCE(v.rectid, 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
+ WHERE d.doc_id = {DOC_ID}) x