2c:null 2d:["$","title",null,{"children":"Ferramentas de Trabalho | Guilherme Ranoya | Observable"}] 32:Ta36,estaile = ``33:Tbd7,34:[] 30:{"id":"5b72225abccffff1","slug":"v2-ferramentas","title":"Ferramentas de Trabalho","thumbnail":"58e39e90f28a52fb9330dd4522b5888e52c5eac910271a26641a029d829d1174","access_level":"public","create_time":"$D2024-10-19T16:22:14.741Z","update_time":"$D2025-02-22T23:57:23.699Z","view_time":null,"first_public_time":"$D2024-10-19T16:22:14.741Z","fork":{"id":"3266c13996b70f70","slug":"ferramentas-vis","title":"Ferramentas de visualização","owner":{"id":"0a78bc4380cdd0f8","login":"ranoya","name":"Guilherme Ranoya"}},"stars":0,"starred":false,"owner":{"type":"team","id":"0a78bc4380cdd0f8","login":"ranoya","name":"Guilherme Ranoya","avatar_url":"https://avatars-next.observableusercontent.com/f2bd0349885993a7b110789aa4741bda605eb0a795d20940d586f0ced4c0f91a","tier":"starter_2024"},"version":2027,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"92bd7310c7ec23d5","login":"ranoya","name":"Guilherme Ranoya","avatar_url":"https://avatars-next.observableusercontent.com/f2bd0349885993a7b110789aa4741bda605eb0a795d20940d586f0ced4c0f91a","tier":null}],"members":[{"type":"team","id":"0a78bc4380cdd0f8","login":"ranoya","name":"Guilherme Ranoya","avatar_url":"https://avatars-next.observableusercontent.com/f2bd0349885993a7b110789aa4741bda605eb0a795d20940d586f0ced4c0f91a","tier":"starter_2024","role":"editor"},{"type":"individual","id":"92bd7310c7ec23d5","login":"ranoya","name":"Guilherme Ranoya","avatar_url":"https://avatars-next.observableusercontent.com/f2bd0349885993a7b110789aa4741bda605eb0a795d20940d586f0ced4c0f91a","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"subscribed":null,"forks":2,"collection":{"id":"4ae1cba32fe8289b","slug":"visse-v2","title":"VISSE-V2","owner":{"id":"0a78bc4380cdd0f8","login":"ranoya","name":"Guilherme Ranoya"}},"type":"notebook","body":{"title":"Ferramentas de Trabalho","cells":[{"id":0,"value":"# Ferramentas de Trabalho","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":2009,"value":"titulo = html`Ferramentas de Trabalho`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1818,"value":"
\n
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":240,"value":"viewof filtros = Inputs.text({\n placeholder: \"Ex: plataforma, python, react, drag & drop\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":2019,"value":"botoes = html`${custombuttons(grupos)}`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":901,"value":"curadoria = html`${ferramenta_mats(matselect)}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1599,"value":"
","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined"},{"id":10,"value":"
\n
\n
\n
\n
\n\n------------------\n## Apêndice","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":29,"value":"#### 1. Captura dos dados da planilha","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":33,"value":"##### Função que captura dados do banco","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":1073,"value":"import {\n getcsvdata,\n GoogleSheetCsvURL,\n imagefromallsources,\n tags,\n unique,\n eslect\n} from \"@ranoya/datat\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":2000,"value":"import { stijl } from \"@ranoya/vissev2-producaocompleta\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":777,"value":"materiais = getcsvdata(\n GoogleSheetCsvURL(\n \"https://docs.google.com/spreadsheets/d/1d9eKw82lnM5GvVkBUe8wLcHSxpmDm5B6dUqWRbazOik/edit#gid=2129066370\"\n )\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":898,"value":"viewof matselect = Inputs.search(materiais, {\n label: \"matselect\",\n placeholder: \"Nenhum filtro\",\n query: filtros + shadowfiltro,\n disabled: true\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1743,"value":"shadowfiltro:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":2015,"value":"grupos = tags(materiais, \"Group\", \",\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1673,"value":"viewof shadowfiltro = Inputs.text({\n placeholder: \"\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1680,"value":"somafiltros = function (f1, f2) {\n if (f1 == \"\" && f2 == \"\") {\n return \"\";\n } else {\n return f1 + \" \" + f2;\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1062,"value":"function set(input, value) {\n input.value = value;\n input.dispatchEvent(new Event(\"input\", { bubbles: true }));\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1058,"value":"acionasearch = function (nome) {\n set(viewof filtros, nome);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1153,"value":"limpaarray = function (arr) {\n let newarr = [];\n for (let i = 0; i < arr.length; i++) {\n if (typeof arr[i] != \"undefined\" && arr[i] != \"\") {\n newarr.push(arr[i]);\n }\n }\n\n return newarr;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1060,"value":"custombuttons = function (arr) {\n let button = [];\n\n button[0] = html`

Tudo

`;\n button[0].onclick = function () {\n acionasearch(\"\");\n };\n\n for (let i = 0; i < arr.length; i++) {\n button[i + 1] = html`

${arr[i]}

`;\n\n button[i + 1].onclick = function () {\n acionasearch(arr[i]);\n };\n }\n\n return button;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1447,"value":"custombuttonsnotudo = function (arr) {\n let button = [];\n\n for (let i = 0; i < arr.length; i++) {\n button[i] = html`

${arr[i]}

`;\n\n button[i].onclick = function () {\n acionasearch(arr[i]);\n };\n }\n\n return button;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":63,"value":"
\n#### 2. Blocos HTML","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":2004,"value":"estilo = html`${estaile} ${stijl}`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":2002,"value":"$32","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":225,"value":"$33","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined"},{"id":784,"value":"ferramenta_mats = function (data) {\n let code = \"\";\n let c = 0;\n let recode = \"\";\n\n let grupos = tags(materiais, \"Group\", \",\");\n\n for (let g in grupos) {\n code += `

${grupos[g]}

`;\n c = 0;\n\n for (let i = 0; i < data.length; i++) {\n if (data[i].Group.match(grupos[g])) {\n c++;\n code += `

${data[i].Name}
${data[i].descrit}

`;\n }\n }\n code += `

`;\n\n if (c > 0) {\n recode = recode + code;\n }\n code = \"\";\n }\n\n return recode;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"}],"files":"$W34","stdlib":"1","titling":"auto"}} 31:"$30:body"