{"id":3207,"date":"2016-05-25T16:37:54","date_gmt":"2016-05-25T15:37:54","guid":{"rendered":"http:\/\/iamwcew.fr.oracle.com\/blog\/?p=3207"},"modified":"2016-05-25T16:37:54","modified_gmt":"2016-05-25T15:37:54","slug":"pcs-ajout-dune-dropbox-basee-sur-un-service-rest","status":"publish","type":"post","link":"https:\/\/gpmfactory.com\/index.php\/2016\/05\/25\/pcs-ajout-dune-dropbox-basee-sur-un-service-rest\/","title":{"rendered":"PCS &#8211; Ajout d&rsquo;une dropbox bas\u00e9e sur un service REST"},"content":{"rendered":"<p>Lors de la r\u00e9alisation d&rsquo;un formulaire Freevo (webfom) dans PCS, il faut savoir que l&rsquo;ajout d&rsquo;un \u00a0champs de type Dropbox n\u00e9cessite l&rsquo;\u00e9criture d&rsquo;un peu de Javascript. Le plus souvent, il faut aller alimenter les donn\u00e9es du champs \u00e0 partir d&rsquo;un appel de service REST.<\/p>\n<p>J&rsquo;ai cr\u00e9\u00e9 les services REST suivants qui sont accessibles en https (mode GET seulement) )et qui ne n\u00e9cessitent pas d\u2019authentification particuli\u00e8re :<\/p>\n<ul>\n<li><a href=\"https:\/\/apex.oracle.com\/pls\/apex\/teamfr\/hr\/country\">https:\/\/apex.oracle.com\/pls\/apex\/teamfr\/hr\/country <\/a>\u00a0 (liste de 35 pays)<\/li>\n<li><a href=\"https:\/\/apex.oracle.com\/pls\/apex\/teamfr\/hr\/country\/{code}\">https:\/\/apex.oracle.com\/pls\/apex\/teamfr\/hr\/country\/{code}<\/a> \u00a0(d\u00e9tail sur un pays \u00e0 partir de son code sur deux lettres en majuscule)<\/li>\n<li><a href=\"https:\/\/apex.oracle.com\/pls\/apex\/teamfr\/hr\/empinfo\/\">https:\/\/apex.oracle.com\/pls\/apex\/teamfr\/hr\/empinfo\/<\/a> \u00a0(liste de 14 employ\u00e9e)<\/li>\n<\/ul>\n<p>Le service REST est fourni ici par une instance APEX \u00e0 partir de la v\u00e9n\u00e9rable table EMP.<\/p>\n<p>Source: <a href=\"http:\/\/docs.oracle.com\/cloud\/latest\/process_gs\/CPRCW\/GUID-07DD07E2-59C3-4371-9C88-DB847874ED7A.htm#CPRCW-GUID-07DD07E2-59C3-4371-9C88-DB847874ED7A\">Documentation Oracle PCS exemples de Rules<\/a>)<\/p>\n<p><a href=\"http:\/\/iamwcew.fr.oracle.com\/blog\/wp-content\/uploads\/2016\/05\/snap02309.jpg\" rel=\"attachment wp-att-3209\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3209 size-full\" src=\"http:\/\/iamwcew.fr.oracle.com\/blog\/wp-content\/uploads\/2016\/05\/snap02309.jpg\" alt=\"Cr\u00e9ation d'une rule pour le remplissage d'une dropbox\" width=\"992\" height=\"618\" \/><\/a><\/p>\n<p>Il faut ajouter un champs de type dropbox dans la webform et ajouter une <em>Rules<\/em> avec le code suivant:<\/p>\n<p>(on suppose que le champs s&rsquo;appelle userlist)<\/p>\n<p>&nbsp;<\/p>\n<pre>\/*member empno, ename, items*\/\nvar emp;\nif(form.load) {\nvar x = '';\neval('x=' + http.get('https:\/\/apex.oracle.com\/pls\/apex\/teamfr\/hr\/empinfo\/'));\nvar opts1 = []; \nvar opts2 = []; \n for (var i=0; i &lt; x.items.length; i++) { \n   if (x.items[i]) { \n     opts1[i] = x.items[i].ename; \n     opts2[i] = x.items[i].empno; \n   }\n }\nuserlist.options=opts1;\nuserlist.value=opts2;\n}\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Lors de la r\u00e9alisation d&rsquo;un formulaire Freevo (webfom) dans PCS, il faut savoir que l&rsquo;ajout d&rsquo;un \u00a0champs de type Dropbox n\u00e9cessite l&rsquo;\u00e9criture d&rsquo;un peu&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,7,10],"tags":[],"ppma_author":[150],"class_list":["post-3207","post","type-post","status-publish","format-standard","hentry","category-demo-2","category-dev","category-notes"],"authors":[{"term_id":150,"user_id":1,"is_guest":0,"slug":"admin8700","display_name":"Patrick","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/209d5ed69b74d288390621ab4c1d3773?s=96&d=mm&r=g","0":null,"1":"","2":"","3":"","4":"","5":"","6":"","7":"","8":""}],"_links":{"self":[{"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/posts\/3207","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/comments?post=3207"}],"version-history":[{"count":0,"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/posts\/3207\/revisions"}],"wp:attachment":[{"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/media?parent=3207"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/categories?post=3207"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/tags?post=3207"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/ppma_author?post=3207"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}