{"id":3730,"date":"2017-09-29T11:33:49","date_gmt":"2017-09-29T09:33:49","guid":{"rendered":"http:\/\/developer.edokumenty.eu\/?page_id=3730"},"modified":"2017-09-29T12:50:18","modified_gmt":"2017-09-29T10:50:18","slug":"dane-wejsciowe","status":"publish","type":"page","link":"http:\/\/developer.edokumenty.eu\/index.php\/dokumentacja-online-systemu-edokumenty\/rozwiazania-wdrozeniowe\/workflow\/dane-wejsciowe\/","title":{"rendered":"Dane wej\u015bciowe"},"content":{"rendered":"<p>Dane wej\u015bciowe s\u0142u\u017c\u0105 tym samym czym odczyt standardowego wej\u015bcia w konsoli czy programie (czyli pobraniu od u\u017cytkownika znak\u00f3w). Mo\u017cna je pobiera\u0107 z r\u00f3\u017cnych formant\u00f3w (p\u00f3l tekstowych, list wyboru, list pracownik\u00f3w). Najciekawsz\u0105 opcj\u0105 jest opcja SELECT kt\u00f3ra pozwala zdefiniowa\u0107 dowoln\u0105 kwerend\u0119 SQL zwracaj\u0105c\u0105 potrzebn\u0105 nam w danym etapie list\u0119 (np. kierownik\u00f3w, ksi\u0119gowych, zasob\u00f3w itp). Przyk\u0142adowa lista dla atrybutu CZ\u0141ONEK ZARZ\u0104DU potrzebna do wyboru osoby podpisuj\u0105cej umow\u0119:<\/p>\n<div class=\"code-highlight code-highlight-with-label\" data-label=\"SQL\"><span class=\"js-copy-to-clipboard copy-code\">copy<\/span>\n\t<pre><code class=\"language-sql js-code\">\n{\"sql\":\"SELECT\u00a0orunid\u00a0as\u00a0value,\u00a0fullnm\u00a0||\u00a0'\u00a0-\u00a0'\u00a0||\u00a0ndenam\u00a0as\u00a0caption\u00a0FROM\u00a0orgtree_view\u00a0WHERE\u00a0orunid\u00a0IN\u00a0(3,14,15,16)\"}\n<\/code><\/pre><\/div>\n<p>Przyk\u0142adowa powy\u017csza lista b\u0119dzie widoczna na procedurze jako lista wyboru, w tym wypadku mo\u017cemy wybra\u0107 tylko jedn\u0105 osob\u0119, czasem jednak potrzebna jest mo\u017cliwo\u015b\u0107 wyboru wi\u0119cej pozycji ni\u017c jedna do tego celu stosujemy multiselect. Nale\u017cy pami\u0119ta\u0107 \u017ce przekazywany parametr jest w tablicy\u00a0 wi wygl\u0105da tak [11,23]. W celu zmiany typu tablicy na tablic\u0119 {11,23} stosujemy warunek SQL. Przyk\u0142adowo w nast\u0119pnym etapie mo\u017cemy przypisa\u0107 etap do wybranych os\u00f3b poprzez przypisanie {stages.orgarr} poni\u017cszy select<\/p>\n<div class=\"code-highlight code-highlight-with-label\" data-label=\"SQL\"><span class=\"js-copy-to-clipboard copy-code\">copy<\/span>\n\t<pre><code class=\"language-sql js-code\">\n\u00a0SELECT TRANSLATE('{$ORUNID}','[]','{}')::int[]\n<\/code><\/pre><\/div>\n<p><a href=\"http:\/\/developer.edokumenty.eu\/wp-content\/uploads\/2017\/09\/Screenshot_2.png\"><img loading=\"lazy\" class=\"alignnone wp-image-3737\" src=\"http:\/\/developer.edokumenty.eu\/wp-content\/uploads\/2017\/09\/Screenshot_2-1024x861.png\" alt=\"\" width=\"552\" height=\"464\" srcset=\"http:\/\/developer.edokumenty.eu\/wp-content\/uploads\/2017\/09\/Screenshot_2-1024x861.png 1024w, http:\/\/developer.edokumenty.eu\/wp-content\/uploads\/2017\/09\/Screenshot_2-300x252.png 300w, http:\/\/developer.edokumenty.eu\/wp-content\/uploads\/2017\/09\/Screenshot_2-768x646.png 768w, http:\/\/developer.edokumenty.eu\/wp-content\/uploads\/2017\/09\/Screenshot_2.png 1026w\" sizes=\"(max-width: 552px) 100vw, 552px\" \/><\/a><\/p>\n<div class=\"code-highlight code-highlight-with-label\" data-label=\"\"><span class=\"js-copy-to-clipboard copy-code\">copy<\/span>\n\t<pre><code class=\"language- js-code\">\n{\r\n\"sql\":\"select\u00a0orunid,\u00a0lasfir,\u00a0'USER'\u00a0as\u00a0clsnam\u00a0FROM\u00a0orgtree_view\u00a0WHERE\u00a0{FILTER_STRING}\",\r\n\"sql_filter\":\"lasfir\u00a0~*\u00a0E'^{SEARCH_TEXT}'\",\r\n\"valueField\":\"orunid\",\r\n\"labelField\":\"lasfir\",\r\n\"multiselect\":true\r\n}\n<\/code><\/pre><\/div>\n<p>&nbsp;<\/p>\n<p><a href=\"http:\/\/developer.edokumenty.eu\/wp-content\/uploads\/2017\/09\/procedury_02.png\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-3731\" src=\"http:\/\/developer.edokumenty.eu\/wp-content\/uploads\/2017\/09\/procedury_02.png\" alt=\"\" width=\"814\" height=\"640\" srcset=\"http:\/\/developer.edokumenty.eu\/wp-content\/uploads\/2017\/09\/procedury_02.png 814w, http:\/\/developer.edokumenty.eu\/wp-content\/uploads\/2017\/09\/procedury_02-300x236.png 300w, http:\/\/developer.edokumenty.eu\/wp-content\/uploads\/2017\/09\/procedury_02-768x604.png 768w\" sizes=\"(max-width: 814px) 100vw, 814px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dane wej\u015bciowe s\u0142u\u017c\u0105 tym samym czym odczyt standardowego wej\u015bcia w konsoli czy programie (czyli pobraniu od u\u017cytkownika znak\u00f3w). Mo\u017cna je pobiera\u0107 z r\u00f3\u017cnych formant\u00f3w (p\u00f3l tekstowych, list wyboru, list pracownik\u00f3w). Najciekawsz\u0105 opcj\u0105 jest opcja SELECT kt\u00f3ra pozwala zdefiniowa\u0107 dowoln\u0105 kwerend\u0119 SQL zwracaj\u0105c\u0105 potrzebn\u0105 nam w danym etapie list\u0119 (np. kierownik\u00f3w, ksi\u0119gowych, zasob\u00f3w itp). Przyk\u0142adowa lista [&hellip;]<\/p>\n","protected":false},"author":41,"featured_media":0,"parent":3725,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"tags":[],"_links":{"self":[{"href":"http:\/\/developer.edokumenty.eu\/index.php\/wp-json\/wp\/v2\/pages\/3730"}],"collection":[{"href":"http:\/\/developer.edokumenty.eu\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/developer.edokumenty.eu\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/developer.edokumenty.eu\/index.php\/wp-json\/wp\/v2\/users\/41"}],"replies":[{"embeddable":true,"href":"http:\/\/developer.edokumenty.eu\/index.php\/wp-json\/wp\/v2\/comments?post=3730"}],"version-history":[{"count":6,"href":"http:\/\/developer.edokumenty.eu\/index.php\/wp-json\/wp\/v2\/pages\/3730\/revisions"}],"predecessor-version":[{"id":3739,"href":"http:\/\/developer.edokumenty.eu\/index.php\/wp-json\/wp\/v2\/pages\/3730\/revisions\/3739"}],"up":[{"embeddable":true,"href":"http:\/\/developer.edokumenty.eu\/index.php\/wp-json\/wp\/v2\/pages\/3725"}],"wp:attachment":[{"href":"http:\/\/developer.edokumenty.eu\/index.php\/wp-json\/wp\/v2\/media?parent=3730"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/developer.edokumenty.eu\/index.php\/wp-json\/wp\/v2\/tags?post=3730"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}