30:Ta36,estaile = ``31:Tbd7,32:[] 2e:{"title":"Ferramentas de Trabalho","cells":[{"id":0,"value":"# Ferramentas de Trabalho","pinned":false,"hidden":false,"mode":"md"},{"id":2009,"value":"titulo = html`Ferramentas de Trabalho`","pinned":true,"hidden":false,"mode":"ojs"},{"id":1818,"value":"
\n
","pinned":false,"hidden":false,"mode":"md"},{"id":240,"value":"viewof filtros = Inputs.text({\n placeholder: \"Ex: plataforma, python, react, drag & drop\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":2019,"value":"botoes = html`${custombuttons(grupos)}`","pinned":true,"hidden":false,"mode":"ojs"},{"id":901,"value":"curadoria = html`${ferramenta_mats(matselect)}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1599,"value":"
","pinned":false,"hidden":false,"mode":"html"},{"id":10,"value":"
\n
\n
\n
\n
\n\n------------------\n## Apêndice","pinned":false,"hidden":false,"mode":"md"},{"id":29,"value":"#### 1. Captura dos dados da planilha","pinned":false,"hidden":false,"mode":"md"},{"id":33,"value":"##### Função que captura dados do banco","pinned":false,"hidden":false,"mode":"md"},{"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"},{"id":2000,"value":"import { stijl } from \"@ranoya/vissev2-producaocompleta\"","pinned":true,"hidden":false,"mode":"ojs"},{"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"},{"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"},{"id":1743,"value":"shadowfiltro:","pinned":false,"hidden":false,"mode":"md"},{"id":2015,"value":"grupos = tags(materiais, \"Group\", \",\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":1673,"value":"viewof shadowfiltro = Inputs.text({\n placeholder: \"\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"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"},{"id":1058,"value":"acionasearch = function (nome) {\n set(viewof filtros, nome);\n}","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"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"},{"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"},{"id":63,"value":"
\n#### 2. Blocos HTML","pinned":false,"hidden":false,"mode":"md"},{"id":2004,"value":"estilo = html`${estaile} ${stijl}`","pinned":true,"hidden":false,"mode":"ojs"},{"id":2002,"value":"$30","pinned":true,"hidden":false,"mode":"ojs"},{"id":225,"value":"$31","pinned":false,"hidden":false,"mode":"html"},{"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"}],"files":"$W32","stdlib":"1","titling":"auto"}