31:[] 2f:{"title":"Comparación de internaciones","cells":[{"id":0,"value":"md`# Comparación de internaciones`","pinned":false,"hidden":false,"mode":"ojs"},{"id":8,"value":"viewof yesterdayFile = file({\n title: \"Internaciones de ayer\",\n accept: \".xlsx\",\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":11,"value":"viewof todayFile = file({\n title: \"Internaciones de hoy\",\n accept: \".xlsx\",\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":91,"value":"md`## Egresos (${egresos.length})`","pinned":false,"hidden":false,"mode":"ojs"},{"id":89,"value":"table(egresos, {style: 'compact', columns: copiableTableColumns(egresos)})","pinned":false,"hidden":false,"mode":"ojs"},{"id":171,"value":"md`## Cambios (${cambiosDiff.length})`","pinned":false,"hidden":false,"mode":"ojs"},{"id":168,"value":"table(cambiosDiff, {\n style: 'compact',\n columns: diffTableColumns\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":102,"value":"md`## Ingresos (${ingresos.length})`","pinned":false,"hidden":false,"mode":"ojs"},{"id":105,"value":"table(ingresos, {style: 'compact', columns: copiableTableColumns(ingresos)})","pinned":false,"hidden":false,"mode":"ojs"},{"id":95,"value":"html`\n

\nIgnorar desde acá\n

\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":83,"value":"egresos = yesterdayData.filter(y => !todayData.some(t => t.Documento == y.Documento))","pinned":false,"hidden":false,"mode":"ojs"},{"id":100,"value":"ingresos = todayData.filter(t => !yesterdayData.some(y => t.Documento == y.Documento))","pinned":false,"hidden":false,"mode":"ojs"},{"id":118,"value":"selectFields = (obj, fields) => fields.reduce((r,f) => {r[f] = obj[f]; return r},{})","pinned":false,"hidden":false,"mode":"ojs"},{"id":216,"value":"diffTableColumns = Object.keys(cambiosDiff[0]).reduce((o, f) => { \n o[f] = {\n formatter(val, i) {\n if (Array.isArray(val)) {\n return html`

${formatValue(val[0])}

${formatValue(val[1])}

`\n } else {\n return html`${formatValue(val)}` \n }\n }\n }\n return o \n}, {})","pinned":false,"hidden":false,"mode":"ojs"},{"id":257,"value":"copiableTableColumns = data => Object.keys(data[0]).reduce((o, f) => { \n o[f] = {\n formatter(val, i) {\n return html`${formatValue(val)}` \n }\n }\n return o \n}, {})","pinned":false,"hidden":false,"mode":"ojs"},{"id":278,"value":"formatValue = v => {\n if (v instanceof Date) {\n return `${v.getDate()}/${v.getMonth()+1}/${v.getFullYear()}`\n } else {\n return v\n }\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":302,"value":"yesterdayData[0].Ingreso","pinned":true,"hidden":false,"mode":"ojs"},{"id":282,"value":"formatValue(yesterdayData[0].Ingreso)","pinned":true,"hidden":false,"mode":"ojs"},{"id":290,"value":"formatValue(yesterdayData[0].Sala)","pinned":true,"hidden":false,"mode":"ojs"},{"id":291,"value":"formatValue(yesterdayData[0].Edad)","pinned":true,"hidden":false,"mode":"ojs"},{"id":285,"value":"yesterdayData[0]","pinned":false,"hidden":false,"mode":"ojs"},{"id":164,"value":"cambiosDiff = yesterdayData.map(y => {\n const t = todayData.find(t => t.Documento == y.Documento)\n if (t && JSON.stringify(y) != JSON.stringify(t)) {\n const diff = {}\n for(let f of Object.keys(t)) {\n diff[f] = diffValue(formatValue(y[f]), formatValue(t[f]))\n }\n return diff\n } else {\n return null\n }\n}).filter(x => x != null)","pinned":false,"hidden":false,"mode":"ojs"},{"id":159,"value":"diffValue = (a, b) => {\n if (a == b) {\n return a\n } else {\n return [a, b]\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":65,"value":"yesterdayData = toJson(yesterdayFile)","pinned":false,"hidden":false,"mode":"ojs"},{"id":67,"value":"todayData = toJson(todayFile)","pinned":false,"hidden":false,"mode":"ojs"},{"id":58,"value":"toJson = async (file) => {\n const blob = new Uint8Array(await Files.buffer(file))\n const wb = xlsx.read(blob, {type: 'array', cellDates: true})\n const ws = wb.Sheets[wb.SheetNames[0]]\n \n // data range\n const range = xlsx.utils.decode_range(ws['!ref'])\n range.s.c = 0 // from A\n range.s.r = 3 // from rom 4\n range.e.c = 11 // to L\n const dataRange = xlsx.utils.encode_range(range)\n \n return xlsx.utils.sheet_to_json(ws, {range: dataRange})\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":4,"value":"xlsx = require('https://bundle.run/xlsx@0.14.1')","pinned":false,"hidden":false,"mode":"ojs"},{"id":6,"value":"import {select, file, checkbox} from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":86,"value":"import {table} from \"@tmcw/tables\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":249,"value":"document.addEventListener('click', e => {\n if (e.target.className === 'copiable') {\n copy(e.target.textContent);\n e.target.classList.add('copied');\n setTimeout(() => e.target.classList.remove('copied'), 500);\n }\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":247,"value":"function copy(text) {\n var fakeElem = document.body.appendChild(document.createElement('textarea'));\n fakeElem.style.position = 'absolute';\n fakeElem.style.left = '-9999px';\n fakeElem.setAttribute('readonly', '');\n fakeElem.value = text;\n fakeElem.select();\n try {\n return document.execCommand('copy');\n } catch (err) {\n return false;\n } finally {\n fakeElem.parentNode.removeChild(fakeElem);\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":251,"value":"html`\n`","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W31","stdlib":"1","titling":"auto"}