Zmiany pomiędzy wersją 11 and wersją 12 dla UserGuide/AdvancedConfiguration/DefiningReports/ReportParams

Data i czas:

08/14/14 21:49:37 (10 years temu)

Autor:

JP (IP: 89.70.134.212)

Komentarz:

--

UserGuide/AdvancedConfiguration/DefiningReports/ReportParams

@@ -227 +227 @@
 }}}
 
-STATUSY
-{{{
-
-SELECT tpstid, dscrpt FROM  types_of_processes_states WHERE clsnam = 'PROCESS' ORDER BY state_
-}}}
-
 KOMÓRKI ORGANIZACYJNE 
 {{{
+-- z ograniczeniem do tych do których user ma prawo
 SELECT orunid, orunsm AS caption 
 FROM organization_units 
 WHERE is_del IS FALSE 
 AND ndetpe = 'ORGCELL'
-AND chkUsrOrgAcc({LOGGED_USR_ID}, orunid) - ten filtr ogranicza do tych do których user ma prawo
+AND chkUsrOrgAcc({LOGGED_USR_ID}, orunid) 
 ORDER BY orunsm
+
+-- Wybór komórek typu Komórka organizacyjna (same działy)
+SELECT orunid, COALESCE(orunsm, '') || ' - ' || ndenam AS stanowisko
+FROM orgtree_view 
+WHERE orunid > 0 AND ndetpe = 'ORGCELL' 
+AND orunsm IS NOT NULL AND is_del IS FALSE
 }}}
 
@@ -249 +250 @@
 }}}
 
-STATUS SPRAWY (lista statusów)
-{{{
+STATUSY (lista)
+{{{
+-- SPRAWY
 Filtr = state_ in ({value})
 SELECT tpstid, dscrpt FROM types_of_processes_states WHERE clsnam LIKE 'PROCESS%' ORDER BY state_
+
+-- DOKUMENTY typu dctpid = 2 (Faktury)
+SELECT tpstid, dscrpt FROM types_of_processes_states 
+WHERE clsnam = 'DOCUMENT|2' ORDER BY state_
 }}}
 
@@ -264 +270 @@
 forepa > COALESCE(NULLIF('{value}', '')::int,0)
 }}}
+
+{{{
+-- Osoby do których użytkownik ma prawo
+SELECT ov.usr_id, ov.usrnam FROM orgtree_view ov where
+chkUsrOrgAcc({LOGGED_USR_ID}, ov.orunid) IS TRUE
+
+
+-- Wartości cechy osób do których uzytkownik ma prawo
+SELECT ftopid, ftopnm
+FROM 
+features_options 
+INNER JOIN features_options_def USING(fodfid)
+LEFT JOIN users u ON u.initls = ftopnm
+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)
+ORDER BY ftopnm
+
+-- Wartości cechy tekstowej o featid 83
+SELECT DISTINCT data__ AS value, data__ AS caption
+FROM features_text_view
+WHERE featid = 83
+ORDER BY data__
+
+