Sem dados no período.
';\n const max = Math.max(1, ...items.map((i) => i.value));\n return items.map((i) => {\n const pct = Math.max(2, Math.round((i.value / max) * 100));\n return ` {\n const active = path === it.path;\n return `\n ${it.label}\n ${it.disabled ? 'em breve' : ''}\n
`;\n }).join('');\n\n let contentHtml;\n if (path === '/vendas') {\n try {\n contentHtml = `${d2.render('modenafs-app@zJlTKXWalfhfnfsLp3MHw', { dataset: d2.param('salesDs') }, { key: 'vendas', style: 'height:100%;display:block' })}
${SOON_LABEL[path]}
Em construção — próximo item do backlog do broker.
Visão geral
\n Falha ao renderizar a visão geral: ${esc((e && e.message) || String(e))}\n \n
\n
\n
MODENAFS
\n
${navHtml}
\n
\n
${esc((user && user.email) || '')}
\n
\n
\n
\n
\n
${contentHtml}
\n ${d2.render('modenafs-app@fichaCC', {\n mlAdsDs: d2.param('mlAdsDs'), plugDs: d2.param('plugDs'), productsDs: d2.param('productsDs'),\n freteRealDs: d2.param('freteRealDs'), snapshotsDs: 'snapshotsDataSet',\n itemVisitsDs: 'item-visitsDataSet', contentDs: 'contentDataSet',\n }, { key: 'ficha-overlay', width: 0, height: 0, style: 'overflow:visible;pointer-events:none' })}\n
\n Falha ao renderizar ${esc(label)}: ${esc((e && e.message) || String(e))}\n \n
\n \n
`;\n}\n\nfunction buildAdvHeatmapHtml(hm) {\n if (!hm || !hm.rows.length) return 'Sem dados para essas dimensoes.
';\n const flat = hm.cells.reduce((acc, row) => acc.concat(row), []).filter((v) => v != null).map((v) => Math.abs(v));\n const maxAbs = Math.max(1, flat.length ? Math.max.apply(null, flat) : 1);\n const fmt = (v) => {\n if (v == null) return '-';\n if (v === 0) return '0';\n if (hm.valueKind === 'money') return Math.abs(v) >= 1000 ? `R$ ${Math.round(v / 1000)}k` : `R$ ${Math.round(v)}`;\n if (hm.valueKind === 'pct') return `${v}%`;\n return Number(v).toLocaleString('pt-BR');\n };\n const bg = (v) => {\n if (v == null) return '#171b21';\n if (hm.valueKind === 'pct') return v >= 20 ? 'rgba(92,189,138,.4)' : v >= 10 ? 'rgba(226,162,74,.4)' : 'rgba(226,104,90,.4)';\n return heatColor(Math.abs(v) / maxAbs);\n };\n const fg = (v) => (v != null && hm.valueKind !== 'pct' && Math.abs(v) / maxAbs > 0.55) ? '#0f1115' : '#cbd0d8';\n const colHeads = hm.cols.map((c) => `${esc(c)}
`).join('');\n const body = hm.rows.map((rl, ri) => {\n const rowCells = hm.cells[ri].map((v) => `${fmt(v)}
`).join('');\n return `${esc(rl)}
${rowCells}`;\n }).join('');\n return ``;\n}\n\nfunction buildAdvQuadrantHtml(adv) {\n const q = adv.quad || {};\n const defs = [\n ['estrela', 'Estrelas', 'alta demanda + alta margem', 'good'],\n ['vaca', 'Volume', 'alta demanda, margem fina', 'warn'],\n ['nicho', 'Nicho', 'baixa demanda, margem alta', 'accent'],\n ['duvida', 'Duvida', 'baixa demanda + margem baixa', 'muted'],\n ];\n const cellsHtml = defs.map((d) => {\n const k = d[0]; const t = d[1]; const desc = d[2]; const c = d[3];\n return `\n
${(q[k] || 0).toLocaleString('pt-BR')}
\n
${t} ›
${desc}
| ${esc(m.code)} | ${esc(m.description)} | ${esc(m.category)} | ${(m.demand || 0).toLocaleString('pt-BR')} | ${marginTxt} | ${profitTxt} |
`;\n }).join('');\n detail = `| codigo | peca | categoria | vendidos | margem | lucro |
|---|
${rowsHtml}
`;\n } else if (adv.openQuadrant) {\n detail = 'Sem SKUs nesta faixa.
';\n }\n return `${cellsHtml}
${detail}`;\n}\nfunction buildAdvPressureHtml(byCategory) {\n if (!byCategory.length) return 'Sem dados.
';\n const rowsHtml = byCategory.map((c) => {\n const compTxt = c.avgCompetition != null ? c.avgCompetition : '-';\n const discTxt = c.discAvg != null ? `${c.discAvg}%` : '-';\n return `| ${esc(c.category)} | ${compTxt} | ${c.adsRate}% | ${c.promoRate}% | ${discTxt} |
`;\n }).join('');\n return `| categoria | conc. med | % ADS | % promo | desc. med |
|---|
${rowsHtml}
`;\n}\nfunction buildAdvBrandHtml(byBrand) {\n if (!byBrand.length) return 'Sem dados de marca.
';\n const maxM = Math.max(10, Math.max.apply(null, byBrand.map((b) => b.avgMargin || 0)));\n return byBrand.map((b) => {\n const pct = Math.max(2, Math.round((100 * (b.avgMargin || 0)) / maxM));\n const marginTxt = b.avgMargin != null ? `${b.avgMargin}%` : '-';\n return `${esc(b.brand)} (${b.count})\n
\n
${marginTxt} `;\n }).join('');\n}\nfunction buildAdvLensTabsHtml(current) {\n return Object.keys(ADV_LENS_INFO).map((k) => ``).join('');\n}\nfunction buildAdvLensTableHtml(rows) {\n if (!rows || !rows.length) return 'Sem dados ainda para esta lente.
';\n const rowsHtml = rows.map((o) => {\n const marginTxt = o.margin != null ? `${Math.round(o.margin)}%` : '-';\n const profitTxt = o.profit != null ? `R$ ${o.profit.toFixed(2)}` : '-';\n const stockTxt = o.stock != null ? o.stock : '-';\n return `| ${esc(o.code)} | ${esc(o.description)} | ${esc(o.category)} | \n R$ ${(o.cost || 0).toFixed(2)} | R$ ${(o.price || 0).toFixed(2)} | \n ${marginTxt} | ${profitTxt} | \n ${o.comp} | ${(o.demand || 0).toLocaleString('pt-BR')} | ${stockTxt} |
`;\n }).join('');\n return `| codigo | peca | categoria | custo | preco | margem | lucro | concorr. | vendidos | estoque |
|---|
${rowsHtml}
`;\n}\nfunction renderAdvancedSection(d2) {\n const adv = d2.state.adv;\n if (!adv || adv.loading) return 'Analise avancada
Carregando analise avancada (cruza snapshots, plug, anuncios e vendas -- pode levar alguns segundos)...
Falha ao carregar analise avancada: ${esc(adv.error)}
\n
Heatmap configuravel (${adv.universe} SKUs cruzados, ${adv.priced} com margem calculada)
\n
\n \n \n \n
\n
Cruze qualquer dimensao -- ex: faixa de demanda x faixa de desconto com valor no de SKUs mostra esforco promocional por volume.
\n ${heatmapHtml}\n
\n
\n
Quadrante de oportunidade (demanda x margem, mediana ${marginMedTxt})
\n ${quadrantHtml}\n
\n
\n
Pressao competitiva (ADS, promocao, desconto por categoria)
\n ${pressureHtml}\n
\n
\n
Margem por marca (top 14)
\n ${brandHtml}\n
\n
Ranking de oportunidade -- 6 lentes (demanda e concorrencia = mercado ML, via snapshots)
\n
${lensTabsHtml}
\n
${lensHint}
\n ${lensTableHtml}\n
${esc(c)}
`).join('');\n const body = rows.map((rowLabel, ri) => {\n const rowCells = (cells[ri] || []).map((v) => {\n const pct = max ? v / max : 0;\n const bg = heatColor(pct);\n const textColor = pct > 0.55 ? '#0f1115' : '#8a8f9a';\n const label = v > 0 ? `R$ ${compact(v)}` : '·';\n return `${label}
`;\n }).join('');\n return `${esc(rowLabel)}
${rowCells}`;\n }).join('');\n return ``;\n}\n\nfunction buildHotListHtml(items) {\n if (!items || !items.length) return 'Sem dados no período.
';\n const max = Math.max(1, ...items.map((i) => i.value));\n return items.map((i) => {\n const pct = Math.max(2, Math.round((i.value / max) * 100));\n const badge = i.trendBadge ? `${esc(i.trendBadge)}` : '';\n return `\n
${esc(i.label)}
\n
\n
${esc(i.valueLabel)} ${badge}
\n
Visão geral
\n Não foi possível carregar a visão geral: ${esc(err)}\n \n
Sem dados no período.
';\n return `\n
Visão geral
\n
\n
Receita · 30d
R$ ${compact(g.revenue30)}
\n
Lucro · 30d
R$ ${compact(g.profit30)}
\n
Margem média · 30d
${g.margin30.toFixed(1)}%
\n
Pedidos · 30d
${g.count30}
\n
\n
\n
\n
Receita diária (14d)
\n
\n ${dailyChartHtml}\n
\n
\n
\n ${g.hourly ? `
\n
Distribuição por horário do dia (30d)
\n
\n ${hourlyChartHtml}\n
\n
\n
` : ''}\n ${heatmapHtml ? `
\n
Mapa de calor · dia da semana × horário (30d)
\n ${heatmapHtml}\n
` : ''}\n
\n
Mais vendidos (14d)
\n ${buildHotListHtml(g.hot)}\n
\n
\n
Receita & margem por categoria (14d)
\n
${catChartHtml}
\n
cor da barra = margem média · ≥20% 10–20% <10%
\n
\n
\n
Anúncios por status
\n
\n ${g.adsActive} ativos\n ${g.adsPaused} pausados\n ${g.adsReview} em revisão\n
\n
\n
\n ${renderAdvancedToggle(d2)}\n ${d2.state.advOpen ? renderAdvancedSection(d2) : ''}\n
${esc(title)}
${esc(value)}
`;\n tooltip.style.display = 'block';\n const wrapRect = wrap.getBoundingClientRect();\n tooltip.style.left = `${e.clientX - wrapRect.left}px`;\n tooltip.style.top = `${e.clientY - wrapRect.top}px`;\n });\n d2.on(svg, 'mouseleave', () => {\n tooltip.style.display = 'none';\n svg.querySelectorAll('.bar').forEach((b) => b.classList.remove('active'));\n });\n}\n\nfunction bindGeralCharts(d2) {\n bindChartHover(d2, '.daily-chart', '[data-role=\"daily-tooltip\"]',\n () => (d2.state.geral && d2.state.geral.daily) || [],\n (d) => ({ title: d.dateLabel || d.label, value: `R$ ${d.revenue.toFixed(2)}` }));\n bindChartHover(d2, '.hourly-chart', '[data-role=\"hourly-tooltip\"]',\n () => (d2.state.geral && d2.state.geral.hourly) || [],\n (h) => ({ title: `${String(h.hour).padStart(2, '0')}h`, value: `R$ ${h.revenue.toFixed(2)} · ${h.count} pedido${h.count === 1 ? '' : 's'}` }));\n}\n\nfunction triggerGeralLoad(d2) {\n if (d2.state._geralLoading) return;\n loadGeral(d2).finally(() => { d2.state._geralLoading = false; });\n}\n\nasync function loadPlugStatus(d2) {\n d2.state._plugStatusLoading = true;\n try {\n const ds = await waitForDataset(d2, 'integrationTokensDs');\n const rows = await ds.query({ service: 'plug' });\n const rowsArr = Array.isArray(rows) ? rows : (rows && Array.isArray(rows.data) ? rows.data : []);\n const rec = rowsArr[0] || null;\n const updatedAtMs = rec && rec.updatedAt ? Date.parse(rec.updatedAt) : NaN;\n d2.state.plugStatus = {\n hasToken: !!(rec && rec.access_token),\n updatedAtMs: Number.isFinite(updatedAtMs) ? updatedAtMs : null,\n };\n } catch (e) {\n d2.state.plugStatus = { hasToken: false, updatedAtMs: null, error: (e && e.message) || String(e) };\n } finally {\n d2.state._plugStatusLoading = false;\n }\n}\n\nfunction triggerPlugStatusLoad(d2) {\n if (d2.state._plugStatusLoading) return;\n loadPlugStatus(d2);\n}\n\nfunction plugStatusView(d2) {\n const s = d2.state.plugStatus;\n if (!s) return { label: 'checando…', cls: 'pending' };\n if (!s.hasToken) return { label: 'erro', cls: 'bad' };\n const ageSec = s.updatedAtMs ? Math.max(0, Math.round((Date.now() - s.updatedAtMs) / 1000)) : null;\n if (ageSec === null || ageSec > 900) return { label: 'expirado', cls: 'bad' };\n return { label: 'ok', cls: 'good' };\n}\n\nfunction primaryCode(sku) {\n if (!sku) return '';\n return String(sku).split('-')[0].trim();\n}\n\nfunction buildBarListHtml(items) {\n if (!items || !items.length) return 'Sem dados no período.
';\n const max = Math.max(1, ...items.map((i) => i.value));\n return items.map((i) => {\n const pct = Math.max(2, Math.round((i.value / max) * 100));\n return `\n
${esc(i.label)}
\n
\n
${esc(i.valueLabel)}
\n
\n ${it.label}\n ${it.disabled ? 'em breve' : ''}\n
`;\n }).join('');\n\n let contentHtml;\n if (path === '/vendas') {\n try {\n contentHtml = `${d2.render('modenafs-app@zJlTKXWalfhfnfsLp3MHw', { dataset: d2.param('salesDs') }, { key: 'vendas', style: 'height:100%;display:block' })}
${SOON_LABEL[path]}
Em construção — próximo item do backlog do broker.
Visão geral
\n Falha ao renderizar a visão geral: ${esc((e && e.message) || String(e))}\n \n
\n
\n
MODENAFS
\n
${navHtml}
\n
\n
${esc((user && user.email) || '')}
\n
\n
\n
\n
\n
${contentHtml}
\n ${d2.render('modenafs-app@fichaCC', {\n mlAdsDs: d2.param('mlAdsDs'), plugDs: d2.param('plugDs'), productsDs: d2.param('productsDs'),\n freteRealDs: d2.param('freteRealDs'), snapshotsDs: 'snapshotsDataSet',\n itemVisitsDs: 'item-visitsDataSet', contentDs: 'contentDataSet',\n }, { key: 'ficha-overlay', width: 0, height: 0, style: 'overflow:visible;pointer-events:none' })}\n
\n Falha ao renderizar ${esc(label)}: ${esc((e && e.message) || String(e))}\n \n
\n \n
`;\n}\n\nfunction buildAdvHeatmapHtml(hm) {\n if (!hm || !hm.rows.length) return 'Sem dados para essas dimensoes.
';\n const flat = hm.cells.reduce((acc, row) => acc.concat(row), []).filter((v) => v != null).map((v) => Math.abs(v));\n const maxAbs = Math.max(1, flat.length ? Math.max.apply(null, flat) : 1);\n const fmt = (v) => {\n if (v == null) return '-';\n if (v === 0) return '0';\n if (hm.valueKind === 'money') return Math.abs(v) >= 1000 ? `R$ ${Math.round(v / 1000)}k` : `R$ ${Math.round(v)}`;\n if (hm.valueKind === 'pct') return `${v}%`;\n return Number(v).toLocaleString('pt-BR');\n };\n const bg = (v) => {\n if (v == null) return '#171b21';\n if (hm.valueKind === 'pct') return v >= 20 ? 'rgba(92,189,138,.4)' : v >= 10 ? 'rgba(226,162,74,.4)' : 'rgba(226,104,90,.4)';\n return heatColor(Math.abs(v) / maxAbs);\n };\n const fg = (v) => (v != null && hm.valueKind !== 'pct' && Math.abs(v) / maxAbs > 0.55) ? '#0f1115' : '#cbd0d8';\n const colHeads = hm.cols.map((c) => `${esc(c)}
`).join('');\n const body = hm.rows.map((rl, ri) => {\n const rowCells = hm.cells[ri].map((v) => `${fmt(v)}
`).join('');\n return `${esc(rl)}
${rowCells}`;\n }).join('');\n return ``;\n}\n\nfunction buildAdvQuadrantHtml(adv) {\n const q = adv.quad || {};\n const defs = [\n ['estrela', 'Estrelas', 'alta demanda + alta margem', 'good'],\n ['vaca', 'Volume', 'alta demanda, margem fina', 'warn'],\n ['nicho', 'Nicho', 'baixa demanda, margem alta', 'accent'],\n ['duvida', 'Duvida', 'baixa demanda + margem baixa', 'muted'],\n ];\n const cellsHtml = defs.map((d) => {\n const k = d[0]; const t = d[1]; const desc = d[2]; const c = d[3];\n return `\n
${(q[k] || 0).toLocaleString('pt-BR')}
\n
${t} ›
${desc}
| ${esc(m.code)} | ${esc(m.description)} | ${esc(m.category)} | ${(m.demand || 0).toLocaleString('pt-BR')} | ${marginTxt} | ${profitTxt} |
`;\n }).join('');\n detail = `| codigo | peca | categoria | vendidos | margem | lucro |
|---|
${rowsHtml}
`;\n } else if (adv.openQuadrant) {\n detail = 'Sem SKUs nesta faixa.
';\n }\n return `${cellsHtml}
${detail}`;\n}\nfunction buildAdvPressureHtml(byCategory) {\n if (!byCategory.length) return 'Sem dados.
';\n const rowsHtml = byCategory.map((c) => {\n const compTxt = c.avgCompetition != null ? c.avgCompetition : '-';\n const discTxt = c.discAvg != null ? `${c.discAvg}%` : '-';\n return `| ${esc(c.category)} | ${compTxt} | ${c.adsRate}% | ${c.promoRate}% | ${discTxt} |
`;\n }).join('');\n return `| categoria | conc. med | % ADS | % promo | desc. med |
|---|
${rowsHtml}
`;\n}\nfunction buildAdvBrandHtml(byBrand) {\n if (!byBrand.length) return 'Sem dados de marca.
';\n const maxM = Math.max(10, Math.max.apply(null, byBrand.map((b) => b.avgMargin || 0)));\n return byBrand.map((b) => {\n const pct = Math.max(2, Math.round((100 * (b.avgMargin || 0)) / maxM));\n const marginTxt = b.avgMargin != null ? `${b.avgMargin}%` : '-';\n return `${esc(b.brand)} (${b.count})\n
\n
${marginTxt} `;\n }).join('');\n}\nfunction buildAdvLensTabsHtml(current) {\n return Object.keys(ADV_LENS_INFO).map((k) => ``).join('');\n}\nfunction buildAdvLensTableHtml(rows) {\n if (!rows || !rows.length) return 'Sem dados ainda para esta lente.
';\n const rowsHtml = rows.map((o) => {\n const marginTxt = o.margin != null ? `${Math.round(o.margin)}%` : '-';\n const profitTxt = o.profit != null ? `R$ ${o.profit.toFixed(2)}` : '-';\n const stockTxt = o.stock != null ? o.stock : '-';\n return `| ${esc(o.code)} | ${esc(o.description)} | ${esc(o.category)} | \n R$ ${(o.cost || 0).toFixed(2)} | R$ ${(o.price || 0).toFixed(2)} | \n ${marginTxt} | ${profitTxt} | \n ${o.comp} | ${(o.demand || 0).toLocaleString('pt-BR')} | ${stockTxt} |
`;\n }).join('');\n return `| codigo | peca | categoria | custo | preco | margem | lucro | concorr. | vendidos | estoque |
|---|
${rowsHtml}
`;\n}\nfunction renderAdvancedSection(d2) {\n const adv = d2.state.adv;\n if (!adv || adv.loading) return 'Analise avancada
Carregando analise avancada (cruza snapshots, plug, anuncios e vendas -- pode levar alguns segundos)...
Falha ao carregar analise avancada: ${esc(adv.error)}
\n
Heatmap configuravel (${adv.universe} SKUs cruzados, ${adv.priced} com margem calculada)
\n
\n \n \n \n
\n
Cruze qualquer dimensao -- ex: faixa de demanda x faixa de desconto com valor no de SKUs mostra esforco promocional por volume.
\n ${heatmapHtml}\n
\n
\n
Quadrante de oportunidade (demanda x margem, mediana ${marginMedTxt})
\n ${quadrantHtml}\n
\n
\n
Pressao competitiva (ADS, promocao, desconto por categoria)
\n ${pressureHtml}\n
\n
\n
Margem por marca (top 14)
\n ${brandHtml}\n
\n
Ranking de oportunidade -- 6 lentes (demanda e concorrencia = mercado ML, via snapshots)
\n
${lensTabsHtml}
\n
${lensHint}
\n ${lensTableHtml}\n
${esc(c)}
`).join('');\n const body = rows.map((rowLabel, ri) => {\n const rowCells = (cells[ri] || []).map((v) => {\n const pct = max ? v / max : 0;\n const bg = heatColor(pct);\n const textColor = pct > 0.55 ? '#0f1115' : '#8a8f9a';\n const label = v > 0 ? `R$ ${compact(v)}` : '·';\n return `${label}
`;\n }).join('');\n return `${esc(rowLabel)}
${rowCells}`;\n }).join('');\n return ``;\n}\n\nfunction buildHotListHtml(items) {\n if (!items || !items.length) return 'Sem dados no período.
';\n const max = Math.max(1, ...items.map((i) => i.value));\n return items.map((i) => {\n const pct = Math.max(2, Math.round((i.value / max) * 100));\n const badge = i.trendBadge ? `${esc(i.trendBadge)}` : '';\n return `\n
${esc(i.label)}
\n
\n
${esc(i.valueLabel)} ${badge}
\n
Visão geral
\n Não foi possível carregar a visão geral: ${esc(err)}\n \n
Sem dados no período.
';\n return `\n
Visão geral
\n
\n
Receita · 30d
R$ ${compact(g.revenue30)}
\n
Lucro · 30d
R$ ${compact(g.profit30)}
\n
Margem média · 30d
${g.margin30.toFixed(1)}%
\n
Pedidos · 30d
${g.count30}
\n
\n
\n
\n
Receita diária (14d)
\n
\n ${dailyChartHtml}\n
\n
\n
\n ${g.hourly ? `
\n
Distribuição por horário do dia (30d)
\n
\n ${hourlyChartHtml}\n
\n
\n
` : ''}\n ${heatmapHtml ? `
\n
Mapa de calor · dia da semana × horário (30d)
\n ${heatmapHtml}\n
` : ''}\n
\n
Mais vendidos (14d)
\n ${buildHotListHtml(g.hot)}\n
\n
\n
Receita & margem por categoria (14d)
\n
${catChartHtml}
\n
cor da barra = margem média · ≥20% 10–20% <10%
\n
\n
\n
Anúncios por status
\n
\n ${g.adsActive} ativos\n ${g.adsPaused} pausados\n ${g.adsReview} em revisão\n
\n
\n
\n ${renderAdvancedToggle(d2)}\n ${d2.state.advOpen ? renderAdvancedSection(d2) : ''}\n