Zmiany pomiędzy wersją 83 and wersją 84 dla DeployerGuide/AdvancedConfiguration/CustomRegisters

Data i czas:

05/19/17 13:38:09 (7 years temu)

Autor:

JP (IP: 83.144.106.170)

Komentarz:

--

DeployerGuide/AdvancedConfiguration/CustomRegisters

@@ -360 +360 @@
 Znacznik {FILTER_STRING} zostanie zastąpiony wartością z parametru "sql_filter"
 
-{{{
+
+{{{
+-- Lista użytkowników
 {"sql":"select usr_id, usrnam, 'USER' as clsnam FROM users WHERE {FILTER_STRING}","sql_filter":"firnam ~* E'^{SEARCH_TEXT}'","valueField":"usr_id","labelField":"usrnam"}
 
+-- Lista urządzeń
 {"sql":"SELECT devcid, name__ || ' - ' || COALESCE(sernum) AS device FROM cregisters.creg_devices WHERE {FILTER_STRING}","sql_filter":"sernum ~* E'^{SEARCH_TEXT}' OR name__ ~* E'^{SEARCH_TEXT}'","valueField":"devcid","labelField":"device"}
 
+-- Lista klientów z inicjowaniem domyślnej wartości z dokumentu
+{"sql": "SELECT contid,  name_1 || ' - ' || f_addr AS caption, 'CONTACT' as clsnam, contid AS keyval FROM contacts_view WHERE is_del IS FALSE AND {FILTER_STRING[AND]} ORDER BY caption",
+    "sql_filter": "(name_1 || ' ' || name_2) ~* E'{SEARCH_TEXT}'",
+    "valueField": "contid",
+    "labelField": "caption",
+    "defaultValue": "{SQL::select contid FROM doc_link_cont WHERE contid != 37 AND doc_id = COALESCE(NULLIF('{doc_id}',''),'0')::int }",
+    "widget": {
+        "width": "280px",
+        "top": "70px",
+        "left": "20px"
+    }
+}
+
+-- Lista klientów
 {"sql":"SELECT contid, COALESCE(name_2, name_1) || ' ' || f_addr AS caption, 'CONTACT' as clsnam FROM contacts_view WHERE is_del IS FALSE AND {FILTER_STRING} ORDER BY caption","sql_filter":"name_1 ~* E'^{SEARCH_TEXT}' OR name_2 ~* E'^{SEARCH_TEXT}'","valueField":"contid","labelField":"caption",
     "manager": {