| 268 | | }}} |
| 269 | | |
| 270 | | |
| 271 | | == Zapytania do filtrów == |
| 272 | | {{{ |
| 273 | | -- Statusy dokumentów o dctpid = 2 (Faktury) |
| 274 | | SELECT tpstid, dscrpt FROM types_of_processes_states |
| 275 | | WHERE clsnam = 'DOCUMENT|2' ORDER BY state_ |
| 276 | | |
| 277 | | -- Statusy spraw (ogólne - nieprzypisanego do żadnego RWA) |
| 278 | | SELECT tpstid, dscrpt FROM types_of_processes_states |
| 279 | | WHERE clsnam = 'PROCESS' ORDER BY state_ |
| 280 | | |
| 281 | | -- Osoby do których użytkownik ma prawo |
| 282 | | SELECT ov.usr_id, ov.usrnam FROM orgtree_view ov where |
| 283 | | chkUsrOrgAcc({LOGGED_USR_ID}, ov.orunid) IS TRUE |
| 284 | | |
| 285 | | |
| 286 | | -- Wartości cechy osób do których uzytkownik ma prawo |
| 287 | | SELECT ftopid, ftopnm |
| 288 | | FROM |
| 289 | | features_options |
| 290 | | INNER JOIN features_options_def USING(fodfid) |
| 291 | | LEFT JOIN users u ON u.initls = ftopnm |
| 292 | | LEFT JOIN orgtree_view ov ON ov.usr_id = u.usr_id |
| 293 | | WHERE featid = 91 |
| 294 | | 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) |
| 295 | | ORDER BY ftopnm |
| 296 | | |
| 297 | | -- Wartości cechy tekstowej o featid 83 |
| 298 | | SELECT DISTINCT data__ AS value, data__ AS caption |
| 299 | | FROM |
| 300 | | features_text_view |
| 301 | | WHERE featid = 83 |
| 302 | | ORDER BY data__ |
| 303 | | |
| 304 | | -- Wybór komórek |
| 305 | | select orunid, COALESCE(orunsm, '') || ' - ' || ndenam AS stanowisko |
| 306 | | from orgtree_view |
| 307 | | WHERE orunid > 0 AND ndetpe = 'ORGCELL' AND orunsm IS NOT NULL |
| 308 | | |
| 309 | | |
| 310 | | -- Select listy dokumentów do których uprawniona jest grupa użytkownika |
| 311 | | SELECT * FROM documents_view WHERE is_del IS NOT TRUE AND (SELECT prtpid = 11) |
| 312 | | AND doc_id IN ( |
| 313 | | SELECT doc_id FROM doc_link_users dlu |
| 314 | | WHERE dlu.grp_id IN (SELECT grp_id FROM users_link_group glu WHERE glu.usr_id = 2) |
| 315 | | AND dlu.doc_id = doc_id |
| 316 | | ) |
| 317 | | |
| 318 | | |
