Zmiany pomiędzy wersją 16 and wersją 17 dla UserGuide/AdvancedConfiguration/DefiningReports/ReportParams

Data i czas:

03/31/15 22:44:42 (9 years temu)

Autor:

JP (IP: 79.188.124.105)

Komentarz:

--

UserGuide/AdvancedConfiguration/DefiningReports/ReportParams

@@ -242 +242 @@
 GRUPY PRODUKTÓW
 {{{
-SELECT pgr_id, name__ FROM product_groups WHERE is_act IS TRUE AND is_del IS FALSE AND pgr_id NOT IN (SELECT prn_id FROM product_groups) ORDER BY prn_id, name__
+SELECT pgr_id, name__ FROM product_groups 
+WHERE is_act IS TRUE AND is_del IS FALSE AND pgr_id NOT IN (SELECT prn_id FROM product_groups) ORDER BY prn_id, name__
 }}}
 
@@ -303 +304 @@
 LEFT JOIN orgtree_view ov ON ov.usr_id = u.usr_id
 WHERE featid = 91
-AND (CASE WHEN (SELECT count(*) > 0 FROM users_link_group WHERE grp_id = 29 AND usr_id = {LOGGED_USR_ID}) THEN 1 = 1 ELSE chkUsrOrgAcc({LOGGED_USR_ID}, ov.orunid) IS TRUE END)
+AND (CASE WHEN (SELECT count(*) > 0 FROM users_link_group 
+WHERE grp_id = 29 AND usr_id = {LOGGED_USR_ID}) THEN 1 = 1 
+ELSE chkUsrOrgAcc({LOGGED_USR_ID}, ov.orunid) IS TRUE END)
 ORDER BY ftopnm
 
@@ -322 +325 @@
 -- Format zapytania do zwrócenia drzewka
 -- Może być wykonane na dowolnej strukturze danych, ważne by zwracało elementy: KLUCZ, RODZIC, NAZWA, TYP. 
-SELECT c.strcid AS keyval, c.prn_id, c.strnam AS name__, CASE WHEN (SELECT count(*) FROM cregisters.creg_structure_elements c2 WHERE c2.prn_id = c.strcid) > 0 THEN 'FOLDER' ELSE 'ITEM' END AS icon__ FROM cregisters.creg_structure_elements c WHERE c.is_del IS FALSE
+SELECT c.strcid AS keyval, c.prn_id, c.strnam AS name__, 
+CASE WHEN (SELECT count(*) FROM cregisters.creg_structure_elements c2 
+WHERE c2.prn_id = c.strcid) > 0 THEN 'FOLDER' ELSE 'ITEM' END AS icon__ 
+FROM cregisters.creg_structure_elements c WHERE c.is_del IS FALSE