25:["$","title",null,{"children":"Untitled | hidehalo's Workspace | Observable"}] 49:Tb53,resolved = { const workbooks = await Promise.allSettled( xlsxFiles.map(async (xlsFile) => await xlsFile.xlsx()) ); const rows = workbooks .map((workbook) => workbook.value.sheet(workbook.value.sheetNames[0]).slice(1) ) .flat(); const uniqueRows = Array.from( new Map(rows.map((row) => [Object.values(row), row])).values() ) .map((row) => { // 原始日期字符串（无时区） const localDate = TimeLib.parseAsLocalDate(row.A); // const localOffset = localDate.getTimezoneOffset(); // 目标时区：上海时间（UTC+8） // const targetOffset = 8 * 60; // 转换为分钟 // const adjustedTime = // localDate.getTime() + (localOffset - targetOffset) * 60 * 1000; const adjustedTime = localDate.getTime(); return { purchaseMilliTs: adjustedTime, productSerialNo: String(row.B).trim(), productName: String(row.C), specification: String(row.D || ""), clientName: String(row.E), sellsCount: Number(row.F || 0), price: Number(row.G || 0), amount: Number(row.H || 0), note: String(row.I || "") }; }) .sort((itemA, itemB) => { return itemA.purchaseMilliTs - itemB.purchaseMilliTs; }); const clientSellsType = await FileAttachment("直分销@4.xlsx") .xlsx() .then((workbook) => workbook .sheet(0, { headers: false // range: "A1:J10" }) .map((item) => { return { clientName: item.A.trim(), typeName: item.B.trim() }; }) .slice(1) ); const productCategories = await FileAttachment("分类表.xlsx") .xlsx() .then((workbook) => Array.from( new Map( workbook .sheet(0, { headers: false // range: "A1:J10" }) .slice(1) .map((item) => { return [ String(item.A).trim(), { productSerialNo: String(item.A).trim(), productCategory: item.B } ]; }) ).values() ) ); const productFabs = await FileAttachment("产线分类.xlsx") .xlsx() .then((workbook) => Array.from( new Map( workbook .sheet(0, { headers: false // range: "A1:J10" }) .slice(1) .map((item) => { return [ String(item.B).trim(), { fabName: String(item.A).trim(), productSerialNo: String(item.B).trim() } ]; }) ).values() ) ); return { sells: uniqueRows, clientSellsType, productCategories, productFabs }; }4a:T2616,CalcLib = { // 定义一个函数，用于计算总和 function sumAggFn(sumField) { // 返回一个函数，该函数接受两个参数：carry和item return (carry, item) => { // 如果carry不是数字，则将其设置为0 if (Number(carry) === NaN) { carry = 0; } // 返回carry和item[sumField]的和 return carry + item[sumField]; }; } // 定义一个函数，用于计算月度增长率 function calculateMoMGrowth(start, end, data) { // 调用calculateGrowthPeriodOverPeriod函数，传入参数start、end、data、getTsFn、offsetFn和sumAggFn("amount") return calculateGrowthPeriodOverPeriod( start, end, data, (item) => item["purchaseMilliTs"], (s, e) => { // 将start和end转换为Date对象 const ds = new Date(s), de = new Date(e); // 将start的月份减1，得到上个月的起始日期 TimeLib.startOfMonth(ds.setMonth(ds.getMonth() - 1)); // 将end的月份减1，得到上个月的结束日期 TimeLib.endOfMonth(de.setMonth(de.getMonth() - 1)); // 返回上个月的起始日期和结束日期 return [ds.getTime(), de.getTime()]; }, sumAggFn("amount") ); } // 定义一个函数，用于计算年度增长率 function calculateYoYGrowth(start, end, data) { // 调用calculateGrowthPeriodOverPeriod函数，传入参数start、end、data、getTsFn、offsetFn和sumAggFn("amount") return calculateGrowthPeriodOverPeriod( start, end, data, (item) => item["purchaseMilliTs"], (s, e) => { // 将start和end转换为Date对象 const ds = new Date(s), de = new Date(e); // 将start的年份减1，得到去年的起始日期 TimeLib.startOfYear(ds.setFullYear(ds.getFullYear() - 1)); // 将end的年份减1，得到去年的结束日期 TimeLib.endOfYear(de.setFullYear(de.getFullYear() - 1)); // 返回去年的起始日期和结束日期 return [ds.getTime(), de.getTime()]; }, sumAggFn("amount") ); } // 定义一个函数，用于计算周期增长率 function calculateGrowthPeriodOverPeriod( startDateStr, endDateStr, data, getTsFn, offsetFn, aggFn ) { // 将startDateStr和endDateStr转换为时间戳 const startTs = Date.parse(startDateStr); const endTs = Date.parse(endDateStr); // 根据时间范围过滤数据 const current = filterByTimeRange(data, getTsFn, startTs, endTs); // 计算当前时间范围内的总和 const currentTotal = current.reduce(aggFn, 0); // 调用offsetFn函数，获取上个月的起始日期和结束日期 const [prevStartTs, prevEndTs] = offsetFn(startTs, endTs); // 根据时间范围过滤数据 const previous = filterByTimeRange(data, getTsFn, prevStartTs, prevEndTs); // 计算上个月时间范围内的总和 const prevTotal = previous.reduce(aggFn, 0); // 计算增长率 const growth = prevTotal !== 0 ? ((currentTotal - prevTotal) / prevTotal) * 100 : Infinity; // 返回结果 return { currentTotal, prevTotal, growth }; } // 定义一个函数，用于计算月度总和 function calculateMTDTotal(end, data) { // 获取当前月份的起始日期 const start = TimeLib.startOfMonth(new Date(end)); // 将end转换为时间戳 const endTs = Date.parse(end); // 将start转换为时间戳 const startTs = start.getTime(); // 根据时间范围过滤数据 const mtdData = filterByTimeRange( data, (item) => item["purchaseMilliTs"], startTs, endTs ); // 计算月度总和 const mtdTotal = mtdData.reduce(sumAggFn("amount"), 0); // 返回结果 return { total: mtdTotal, from: start, to: new Date(endTs) }; } // 计算从年初到指定日期的总和 function calculateYTDTotal(end, data) { // 获取年初日期 const start = TimeLib.startOfYear(new Date(end)); // 将指定日期转换为时间戳 const endTs = Date.parse(end); // 将年初日期转换为时间戳 const startTs = start.getTime(); // 根据时间范围过滤数据 const ytdData = filterByTimeRange( data, (item) => item["purchaseMilliTs"], startTs, endTs ); // 计算总和 const ytdTotal = ytdData.reduce(sumAggFn("amount"), 0); // 返回总和、起始日期和结束日期 return { total: ytdTotal, from: start, to: new Date(endTs) }; } // 工具函数：获取周期起始标识 function getLocalPeriodKey(timestamp, cycle) { const date = new Date(timestamp); if (cycle === "year") { return TimeLib.getLocalYearIndexSinceUnixEpoch(date); } if (cycle === "month") { return TimeLib.getLocalMonthIndexSinceUnixEpoch(date); } if (cycle === "week") { return TimeLib.getLocalWeekIndexSinceUnixEpoch(date); } throw new Error(`Invalid cycle: ${cycle}`); } // 根据时间范围过滤数据 function filterByTimeRange(data, getTsFn, start, end) { return data.filter( (item) => getTsFn(item) >= start && getTsFn(item) <= end ); } // 根据键值对数据进行聚合 function aggregateByKey(data, hashFn, getInitialValue, mergeValue) { // 创建一个空数组，用于存放聚合后的数据 const result = []; // 遍历数据 for (const item of data) { // 使用hashFn函数获取当前数据的键值 const key = hashFn(item); // 在result数组中查找是否存在相同的键值 const existing = result.find((r) => r.key === key); // 如果存在相同的键值，则调用mergeValue函数将当前数据合并到已有的数据中 if (existing) { mergeValue(existing, item); // 如果不存在相同的键值，则调用getInitialValue函数获取初始值，并将初始值添加到result数组中 } else { result.push(getInitialValue(item, key)); } } // 返回聚合后的数据 return result; } // 定义一个函数，用于根据周期聚合销售数据 function aggregateSalesByCycle( data, aggKeys, cycle = "month", field = "purchaseMilliTs" ) { // 调用aggregateByKey函数，传入参数data、hashFn、getInitialValue和mergeValue return aggregateByKey( data, (item) => { // 获取周期起始标识 const periodIndex = getLocalPeriodKey(item[field], cycle); // 将aggKeys中的元素拼接成一个字符串 const parts = aggKeys.map((k) => item[k]); // 将cycle、periodIndex和parts拼接成一个字符串 return parts.concat(`${cycle}#${periodIndex}`).join("__"); }, (item, key) => ({ // 返回一个对象，包含key和value key, value: { // value是一个对象，包含cycle、cycleIndex、clientName、productSerialNo、productName、specification、sellsCount和amount cycle, cycleIndex: getLocalPeriodKey(item[field], cycle), clientName: item.clientName, productSerialNo: item.productSerialNo, productName: item.productName, specification: item.specification, sellsCount: item.sellsCount, amount: item.amount } }), (existing, item) => { // 将existing和item中的sellsCount和amount相加 existing.value.sellsCount += item.sellsCount; existing.value.amount += item.amount; } ); } // 定义一个函数，用于根据时间范围聚合销售数据 function aggregateSalesByTimeRange( data, aggKeys, [start, end], field = "purchaseMilliTs" ) { // 根据时间范围过滤数据 const filtered = filterByTimeRange( data, (item) => item["field"], start, end ); // 调用aggregateByKey函数，传入参数filtered、hashFn、getInitialValue和mergeValue return aggregateByKey( filtered, (item) => aggKeys.map((k) => item[k]).join("__"), (item, key) => ({ // 返回一个对象，包含key和clientName、productSerialNo、productName、specification、sellsCount和amount key, clientName: item.clientName, productSerialNo: item.productSerialNo, productName: item.productName, specification: item.specification, sellsCount: item.sellsCount, amount: item.amount }), (existing, item) => { // 将existing和item中的sellsCount和amount相加 existing.sellsCount += item.sellsCount; existing.amount += item.amount; } ); } // 定义一个函数，用于将月度时间范围向后移动一个周期 function shiftMonthRangeBackOneCycle(s, e) { // 将s和e转换为Date对象 const ds = new Date(s), de = new Date(e); // 将s的月份减1 ds.setMonth(ds.getMonth() - 1); // 将e的月份减1 de.setMonth(de.getMonth() - 1); return [ds.getTime(), de.getTime()]; } // 定义一个函数，用于将年度时间范围向后移动一个周期 function shiftYearRangeBackOneCycle(date) { const prevTerm = new Date(date.getTime()); prevTerm.setFullYear(date.getFullYear() - 1); return prevTerm; } return { calculateMoMGrowth, calculateYoYGrowth, calculateMTDTotal, calculateYTDTotal, calculateGrowthPeriodOverPeriod, aggregateSalesByCycle, aggregateSalesByTimeRange, filterByTimeRange, shiftYearRangeBackOneCycle, shiftMonthRangeBackOneCycle }; }4b:T1184,TimeLib = { // 定义一个函数，用于获取指定日期的当天的开始时间 function startOfDay(date) { const d = new Date(date); d.setHours(0, 0, 0, 0); return d; } // 定义一个函数，用于获取指定日期的当天的结束时间 function endOfDay(date) { const d = new Date(date); d.setHours(23, 59, 59, 999); return d; } // 定义一个函数，用于获取指定日期的当月的第一天 function startOfMonth(date) { const d = new Date(date); return new Date(d.getFullYear(), d.getMonth(), 1, 0, 0, 0, 0); } // 定义一个函数，用于获取指定日期的当月的最后一天 function endOfMonth(date) { const d = new Date(date); return new Date(d.getFullYear(), d.getMonth() + 1, 0, 23, 59, 59, 999); } // 定义一个函数，用于获取指定日期的当年的第一天 function startOfYear(date) { const d = new Date(date); return new Date(d.getFullYear(), 0, 1, 0, 0, 0, 0); } // 定义一个函数，用于获取指定日期的当年的最后一天 function endOfYear(date) { const d = new Date(date); return new Date(d.getFullYear(), 11, 31, 23, 59, 59, 999); } // 定义一个函数，用于获取指定日期的当周的第一天 function startOfWeek(date) { const d = new Date(date); const day = d.getDay() || 7; if (day !== 1) d.setHours(-24 * (day - 1)); d.setHours(0, 0, 0, 0); return d; } // 定义一个函数，用于获取指定日期的当周的最后一天 function endOfWeek(date) { const start = startOfWeek(date); const end = new Date(start); end.setDate(start.getDate() + 6); end.setHours(23, 59, 59, 999); return end; } // 定义一个函数，用于获取指定日期的当季度的第一天 function startOfQuarter(date) { const d = new Date(date); const quarterStartMonth = Math.floor(d.getMonth() / 3) * 3; return new Date(d.getFullYear(), quarterStartMonth, 1, 0, 0, 0, 0); } // 定义一个函数，用于获取指定日期的当季度的最后一天 function endOfQuarter(date) { const quarterStart = startOfQuarter(date); return new Date( quarterStart.getFullYear(), quarterStart.getMonth() + 3, 0, 23, 59, 59, 999 ); } // 定义一个函数，用于获取指定日期相对于Unix Epoch的年索引 function getLocalYearIndexSinceUnixEpoch(date) { // 返回指定日期的年份减去1970 return date.getFullYear() - 1970; } // 定义一个函数，用于获取指定日期相对于Unix Epoch的月索引 function getLocalMonthIndexSinceUnixEpoch(date) { // 返回指定日期的年份减去1970，乘以12，加上指定日期的月份 return (date.getFullYear() - 1970) * 12 + date.getMonth(); } // 定义一个函数，用于获取指定日期相对于Unix Epoch的周索引 function getLocalWeekIndexSinceUnixEpoch(date) { // 定义一天的毫秒数 const oneDayMs = 24 * 60 * 60 * 1000; // 调用getStartOfFirstMonday函数，获取Unix Epoch的周一日期 const epochMonday = getStartOfFirstMonday(); // 获取指定日期的午夜时间 const localMidnight = new Date( date.getFullYear(), date.getMonth(), date.getDate() ); // 计算指定日期与Unix Epoch的周一日期的差值，以天为单位 const diffDays = Math.floor((localMidnight - epochMonday) / oneDayMs); // 返回指定日期相对于Unix Epoch的周索引 return Math.floor(diffDays / 7); } // 1970-01-01 之后第一个自然周一 function getStartOfFirstMonday() { const epoch = new Date(1970, 0, 1); // 1970-01-01 const day = epoch.getDay(); // 周几（0=周日） const offset = day === 0 ? 1 : 8 - day; // 到下一个周一 return new Date(1970, 0, 1 + offset); } function parseAsLocalDate(str) { const utcMillis = Date.parse(str); // 按 UTC 解析 const offsetMillis = new Date().getTimezoneOffset() * 60 * 1000; // 本地偏移（分钟→毫秒） return new Date(utcMillis + offsetMillis); } // 返回一个对象，包含上述所有函数 return { startOfDay, endOfDay, startOfWeek, endOfWeek, startOfQuarter, endOfQuarter, startOfMonth, endOfMonth, startOfYear, endOfYear, getLocalYearIndexSinceUnixEpoch, getLocalMonthIndexSinceUnixEpoch, getLocalWeekIndexSinceUnixEpoch, parseAsLocalDate }; }4c:T69d,{ function generateSalesSummary({ year, lastYear = year - 1, growthRateYTD = null, topClients = [], keyProductLines = [], topHotProducts = [], stuckProducts = [], profitStructure = { high: 0, medium: 0, low: 0 }, summaryTips = "" }) { return ` 销售分析摘要（截至${year}年YTD）： 1. ${year}年YTD整体销售出库额较${lastYear}年同期${ growthRateYTD !== null ? `增长${growthRateYTD}%` : "进行了对比分析" }，覆盖总量及分月走势。 2. 分析了直销与分销模式的出库占比变化，识别渠道结构调整趋势。 3. 对主要客户（如 ${ topClients.length ? topClients.join("、") : "暂无数据" }）的销售额进行了同期与当月YTD对比，识别客户销售贡献变化。 4. 按客户维度追踪销售产品类型结构变化，洞察需求偏好。 5. 针对试剂类产品，提供各客户的同期及当月YTD出库情况的对比。 6. 基于产品线（如 ${ keyProductLines.length ? keyProductLines.join("、") : "暂无数据" }）分析各类产品线的销售表现和增长动能。 7. 产品类型分析： - 热销产品TOP5：${ topHotProducts.length ? topHotProducts.join("、") : "暂无数据" } - 滞销产品：${stuckProducts.length ? stuckProducts.join("、") : "暂无数据"} - 利润结构分布：高利润${profitStructure.high}%、中利润${ profitStructure.medium }%、低利润${profitStructure.low}% ${ summaryTips ? `提示：${summaryTips}` : "本报告可辅助渠道优化、产品结构调整及重点客户跟踪。" } `.trim(); } return generateSalesSummary({ year: 2025 }); }4d:T1c39,function drawPieChart(data, getLabelFn, getValueFn, uiOptions = {}) { const width = uiOptions.width || 300; const height = uiOptions.height || 300; const radius = Math.min(width, height) / 2; const legendItemHeight = uiOptions.legendItemHeight || 40; const legendMaxHeight = height - 40; const color = d3 .scaleOrdinal() .domain(uiOptions.domain) .range(uiOptions.domainColors); const pie = d3.pie().sort(null).value(getValueFn); const arc = d3 .arc() .innerRadius(0) .outerRadius(radius - 1); const labelRadius = arc.outerRadius()() * 0.5; const arcLabel = d3.arc().innerRadius(labelRadius).outerRadius(labelRadius); const arcs = pie(data); const activeSet = new Set(uiOptions.domain); const svg = d3 .create("svg") .attr("width", width + 240) .attr("height", height + 60) .attr("viewBox", [-width / 2, -height / 2, width + 240, height + 60]) .style("font", "10px sans-serif"); const chartGroup = svg.append("g"); const tooltip = d3 .select("body") .append("div") .style("position", "absolute") .style("background", "#fff") .style("padding", "6px 10px") .style("border", "1px solid #ccc") .style("border-radius", "4px") .style("pointer-events", "none") .style("opacity", 0); function renderArcs() { chartGroup.selectAll("path").remove(); chartGroup.selectAll("text").remove(); const filtered = arcs.filter((d) => activeSet.has(getLabelFn(d.data))); const sectors = chartGroup .selectAll("path") .data(filtered) .join("path") .attr("fill", (d) => color(getLabelFn(d.data))) .attr("d", arc) .attr("stroke", "#fff") .on("mouseover", function (event, d) { tooltip.transition().duration(200).style("opacity", 0.9); tooltip .html(`${getLabelFn(d.data)}: ${getValueFn(d.data)}`) .style("left", event.pageX + 10 + "px") .style("top", event.pageY - 28 + "px"); d3.select(this).attr( "fill", d3.rgb(color(getLabelFn(d.data))).darker(1) ); }) .on("mouseout", function (event, d) { tooltip.transition().duration(300).style("opacity", 0); d3.select(this).attr("fill", color(getLabelFn(d.data))); }); const labels = chartGroup .selectAll("text") .data(filtered) .join("text") .attr("transform", (d) => `translate(${arcLabel.centroid(d)})`) .attr("text-anchor", "middle") .style("fill", "white"); labels .append("tspan") .attr("y", "-0.4em") .attr("font-weight", "bold") .text((d) => getLabelFn(d.data)); if (uiOptions.tspanTexts) { for (let i = 0; i < uiOptions.tspanTexts.length; i++) { let getTspanTextFn = uiOptions.tspanTexts[i]; labels .append("tspan") .attr("x", 0) .attr("y", `${1.2 * (i + 1) - 0.4}em`) .text((d) => getTspanTextFn(d.data)); } } } // -------- 图例区 ---------- const controlGroup = svg .append("g") .attr("transform", `translate(${width / 2},${-height / 2 + 20})`); // controlGroup // .append("foreignObject") // .attr("width", 120) // .attr("height", 36) // .append("xhtml:button") // .html("📥 导出 CSV") // .style("cursor", "pointer") // .style("background-color", "#007bff") // .style("color", "white") // .style("border", "none") // .style("border-radius", "6px") // .style("padding", "6px 14px") // .style("font-size", "13px") // .on("click", () => { // const csv = [ // ["label", "value"], // ...data.map((d) => [getLabelFn(d), getValueFn(d)]) // ] // .map((row) => row.join(",")) // .join("\n"); // const blob = new Blob([csv], { type: "text/csv;charset=utf-8;" }); // const link = document.createElement("a"); // link.href = URL.createObjectURL(blob); // link.download = "pie-data.csv"; // document.body.appendChild(link); // link.click(); // document.body.removeChild(link); // }); // controlGroup // .append("foreignObject") // .attr("y", 40) // .attr("width", 160) // .attr("height", 36) // .append("xhtml:input") // .attr("placeholder", "🔍 搜索图例") // .style("width", "100%") // .style("padding", "4px 8px") // .style("font-size", "12px") // .style("border-radius", "4px") // .style("border", "1px solid #ccc") // .on("input", function () { // const keyword = this.value.toLowerCase(); // legendItems.attr("display", (d) => // d.toLowerCase().includes(keyword) ? null : "none" // ); // }); const legendClipId = "legend-clip-path"; svg .append("clipPath") .attr("id", legendClipId) .append("rect") .attr("width", 160) .attr("height", legendMaxHeight); const legendContainer = controlGroup .append("g") .attr("transform", `translate(0, 80)`); const legendScrollable = legendContainer .append("g") .attr("clip-path", `url(#${legendClipId})`); const legendItems = legendScrollable .selectAll(".legend-item") .data(uiOptions.domain) .join("g") .attr("class", "legend-item") .attr("transform", (_, i) => `translate(0, ${i * legendItemHeight})`) .style("cursor", "pointer") .on("click", function (_, key) { if (activeSet.has(key)) activeSet.delete(key); else activeSet.add(key); updateLegendHighlight(); renderArcs(); }); legendItems .append("rect") .attr("width", 18) .attr("height", 18) .attr("fill", (d) => color(d)); const maxLineLength = 10; legendItems.each(function (key) { const group = d3.select(this); const lines = key.length > maxLineLength ? key.match(new RegExp(`.{1,${maxLineLength}}`, "g")) : [key]; lines.forEach((line, j) => { group .append("text") .attr("x", 24) .attr("y", 13 + j * 14) .text(line) .style("font", "12px sans-serif"); }); }); function updateLegendHighlight() { legendItems .select("rect") .attr("fill", (d) => (activeSet.has(d) ? color(d) : "#ccc")); } // 分页按钮 // let scrollOffset = 0; // const maxOffset = Math.max( // 0, // uiOptions.domain.length * legendItemHeight - legendMaxHeight // ); // const scrollStep = 40; // function scrollLegend(dy) { // scrollOffset = Math.max(0, Math.min(scrollOffset + dy, maxOffset)); // legendScrollable.attr("transform", `translate(0, ${-scrollOffset})`); // } // const scrollButtons = legendContainer.append("g"); // scrollButtons // .append("text") // .attr("x", 0) // .attr("y", -10) // .text("▲") // .style("cursor", "pointer") // .style("font-size", "16px") // .on("click", () => scrollLegend(-scrollStep)); // scrollButtons // .append("text") // .attr("x", 0) // .attr("y", legendMaxHeight + 20) // .text("▼") // .style("cursor", "pointer") // .style("font-size", "16px") // .on("click", () => scrollLegend(scrollStep)); updateLegendHighlight(); renderArcs(); return svg.node(); }4e:Tfac,viewof todoProgress = { const tasks = [ "输入时间范围，总销售金额同期对比（柱状图）", "输入时间范围，直分销金额同期占比对比（柱状图）", "输入时间范围，直销客户同期销售金额筛选销售金额top5（柱状图）", "输入时间范围，分销客户同期销售金额筛选销售金额top5（柱状图）", "输入时间范围，直销客户试剂销售金额对比筛选销售金额top5（柱状图）", "输入时间范围，分销客户试剂销售金额对比筛选销售金额top5（柱状图）", "输入时间范围，按产品类型排名TOP5 例：产品类型：试剂/配件/设备销售数量排名（柱状图）", "输入时间范围，按产品类型排名TOP5 例：产品类型：试剂/配件/设备销售金额的排名（柱状图）", "输入时间范围，分别展示每个类型销售金额TOP5的产品及对应销售金额（柱状图）", "输入时间范围，分别展示每个类型销售数量TOP5的产品及对应销售数量（柱状图）", "输入时间范围，按产线类型做销售数量的占比，例：在指定期间内赛比亚产线和欧根泰克产线的销售数量占总销售数量的占比（饼图）", "输入时间范围，按产线类型做销售金额的占比，例：在指定期间内赛比亚产线和欧根泰克产线的销售金额占总销售金额的占比（饼图）" ]; const container = html`

`; const title = html`

📋 当前任务清单

`; const checkbox = Inputs.checkbox(tasks, { label: "", value: [ "输入时间范围，总销售金额同期对比（柱状图）", "输入时间范围，直分销金额同期占比对比（柱状图）", "输入时间范围，直分销金额同期占比对比（柱状图）", "输入时间范围，直销客户同期销售金额筛选销售金额top5（柱状图）", "输入时间范围，分销客户同期销售金额筛选销售金额top5（柱状图）", "输入时间范围，直销客户试剂销售金额对比筛选销售金额top5（柱状图）", "输入时间范围，分销客户试剂销售金额对比筛选销售金额top5（柱状图）", "输入时间范围，按产品类型排名TOP5 例：产品类型：试剂/配件/设备销售数量排名（柱状图）", "输入时间范围，按产品类型排名TOP5 例：产品类型：试剂/配件/设备销售金额的排名（柱状图）", "输入时间范围，分别展示每个类型销售金额TOP5的产品及对应销售金额（柱状图）", "输入时间范围，分别展示每个类型销售数量TOP5的产品及对应销售数量（柱状图）", "输入时间范围，按产线类型做销售数量的占比，例：在指定期间内赛比亚产线和欧根泰克产线的销售数量占总销售数量的占比（饼图）", "输入时间范围，按产线类型做销售金额的占比，例：在指定期间内赛比亚产线和欧根泰克产线的销售金额占总销售金额的占比（饼图）" ] // 可选：预设已完成 }); const progressText = html`

`; function updateProgress(value) { const percent = Math.round((value.length / tasks.length) * 100); progressText.textContent = `✅ 已完成 ${value.length} / ${tasks.length} 项（${percent}%）`; } checkbox.addEventListener("input", () => { updateProgress(checkbox.value); }); // 初始时设置进度 updateProgress(checkbox.value); container.append(title, checkbox, progressText); // 返回 viewof return Object.assign(container, { value: checkbox.value, onchange: checkbox.onchange, get form() { return checkbox.form; } }); }4f:T87f,{ const currtentTerms = [ TimeLib.parseAsLocalDate(startDate), TimeLib.parseAsLocalDate(endDate) ]; const prevTerms = currtentTerms.map((term) => CalcLib.shiftYearRangeBackOneCycle(term) ); const currentTermSells = CalcLib.filterByTimeRange( resolved.sells, (item) => item["purchaseMilliTs"], currtentTerms[0].getTime(), currtentTerms[1].getTime() ); const prevTermSells = CalcLib.filterByTimeRange( resolved.sells, (item) => item["purchaseMilliTs"], prevTerms[0].getTime(), prevTerms[1].getTime() ); const prevTermSellsBarData = Array.from( prevTermSells .map((item) => { return { period: `${prevTerms[0].toLocaleDateString()}-${prevTerms[1].toLocaleDateString()}`, category: `总销售金额-${prevTerms[0].toLocaleDateString()}-${prevTerms[1].toLocaleDateString()}`, value: item.amount }; }) .reduce((carry, current) => { const key = [current.period, current.category].join("__"); if (!carry.has(key)) { carry.set(key, { ...current }); } else { carry.get(key).value += current.value; } return carry; }, new Map()) .values() ); const currentTermSellsBarData = Array.from( currentTermSells .map((item) => { return { period: `${currtentTerms[0].toLocaleDateString()}-${currtentTerms[1].toLocaleDateString()}`, category: `总销售金额-${currtentTerms[0].toLocaleDateString()}-${currtentTerms[1].toLocaleDateString()}`, value: item.amount }; }) .reduce((carry, current) => { const key = [current.period, current.category].join("__"); if (!carry.has(key)) { carry.set(key, { ...current }); } else { carry.get(key).value += current.value; } return carry; }, new Map()) .values() ); return drawGroupedBarChart( prevTermSellsBarData.concat(currentTermSellsBarData), "period", "value", "category", (sum) => sum.toLocaleString("zh-CN", { style: "currency", currency: "CNY" }) ); }50:T951,{ const currtentTerms = [ TimeLib.parseAsLocalDate(startDate), TimeLib.parseAsLocalDate(endDate) ]; const prevTerms = currtentTerms.map((term) => CalcLib.shiftYearRangeBackOneCycle(term) ); const currentTermSells = CalcLib.filterByTimeRange( resolved.sells, (item) => item["purchaseMilliTs"], currtentTerms[0].getTime(), currtentTerms[1].getTime() ); const prevTermSells = CalcLib.filterByTimeRange( resolved.sells, (item) => item["purchaseMilliTs"], prevTerms[0].getTime(), prevTerms[1].getTime() ); const prevTermSellsBarData = Array.from( prevTermSells .map((item) => { return { period: `${prevTerms[0].toLocaleDateString()}-${prevTerms[1].toLocaleDateString()}`, category: resolved.clientSellsType.filter( (sellsType) => sellsType.clientName == item.clientName )[0]["typeName"], value: item.amount }; }) .reduce((carry, current) => { const key = [current.period, current.category].join("__"); if (!carry.has(key)) { carry.set(key, { ...current }); } else { carry.get(key).value += current.value; } return carry; }, new Map()) .values() ); const currentTermSellsBarData = Array.from( currentTermSells .map((item) => { const findCategory = resolved.clientSellsType.filter( (sellsType) => sellsType.clientName == item.clientName ); let category = "数据缺失"; if (findCategory.length > 0) { category = findCategory[0]["typeName"]; } return { period: `${currtentTerms[0].toLocaleDateString()}-${currtentTerms[1].toLocaleDateString()}`, category, value: item.amount }; }) .reduce((carry, current) => { const key = [current.period, current.category].join("__"); if (!carry.has(key)) { carry.set(key, { ...current }); } else { carry.get(key).value += current.value; } return carry; }, new Map()) .values() ); return drawGroupedBarChart( prevTermSellsBarData.concat(currentTermSellsBarData), "period", "value", "category", (sum) => sum.toLocaleString("zh-CN", { style: "currency", currency: "CNY" }) ); }51:Tac6,{ const currtentTerms = [ TimeLib.parseAsLocalDate(startDate), TimeLib.parseAsLocalDate(endDate) ]; const prevTerms = currtentTerms.map((term) => CalcLib.shiftYearRangeBackOneCycle(term) ); const currentTermSells = CalcLib.filterByTimeRange( resolved.sells, (item) => item["purchaseMilliTs"], currtentTerms[0].getTime(), currtentTerms[1].getTime() ); const prevTermSells = CalcLib.filterByTimeRange( resolved.sells, (item) => item["purchaseMilliTs"], prevTerms[0].getTime(), prevTerms[1].getTime() ); const prevTermSellsBarData = Array.from( prevTermSells .filter((item) => { return ( resolved.clientSellsType.filter( (sellsType) => sellsType.clientName == item.clientName && sellsType.typeName == "直销" ).length > 0 && item.amount > 0 ); }) .map((item) => { return { period: `${prevTerms[0].toLocaleDateString()}-${prevTerms[1].toLocaleDateString()}`, category: item.clientName, value: item.amount }; }) .reduce((carry, current) => { const key = [current.period, current.category].join("__"); if (!carry.has(key)) { carry.set(key, { ...current }); } else { carry.get(key).value += current.value; } return carry; }, new Map()) .values() ) .sort((a, b) => b.value - a.value) .filter((item) => item.value > 0) .slice(0, 5); const currentTermSellsBarData = Array.from( currentTermSells .filter((item) => { return ( resolved.clientSellsType.filter( (sellsType) => sellsType.clientName == item.clientName && sellsType.typeName == "直销" ).length > 0 && item.amount > 0 ); }) .map((item) => { return { period: `${currtentTerms[0].toLocaleDateString()}-${currtentTerms[1].toLocaleDateString()}`, category: item.clientName, value: item.amount }; }) .reduce((carry, current) => { const key = [current.period, current.category].join("__"); if (!carry.has(key)) { carry.set(key, { ...current }); } else { carry.get(key).value += current.value; } return carry; }, new Map()) .values() ) .sort((a, b) => b.value - a.value) .filter((item) => item.value > 0) .slice(0, 5); return drawGroupedBarChart( prevTermSellsBarData.concat(currentTermSellsBarData), "period", "value", "category", (sum) => sum.toLocaleString("zh-CN", { style: "currency", currency: "CNY" }) ); }52:Tac6,{ const currtentTerms = [ TimeLib.parseAsLocalDate(startDate), TimeLib.parseAsLocalDate(endDate) ]; const prevTerms = currtentTerms.map((term) => CalcLib.shiftYearRangeBackOneCycle(term) ); const currentTermSells = CalcLib.filterByTimeRange( resolved.sells, (item) => item["purchaseMilliTs"], currtentTerms[0].getTime(), currtentTerms[1].getTime() ); const prevTermSells = CalcLib.filterByTimeRange( resolved.sells, (item) => item["purchaseMilliTs"], prevTerms[0].getTime(), prevTerms[1].getTime() ); const prevTermSellsBarData = Array.from( prevTermSells .filter((item) => { return ( resolved.clientSellsType.filter( (sellsType) => sellsType.clientName == item.clientName && sellsType.typeName == "分销" ).length > 0 && item.amount > 0 ); }) .map((item) => { return { period: `${prevTerms[0].toLocaleDateString()}-${prevTerms[1].toLocaleDateString()}`, category: item.clientName, value: item.amount }; }) .reduce((carry, current) => { const key = [current.period, current.category].join("__"); if (!carry.has(key)) { carry.set(key, { ...current }); } else { carry.get(key).value += current.value; } return carry; }, new Map()) .values() ) .sort((a, b) => b.value - a.value) .filter((item) => item.value > 0) .slice(0, 5); const currentTermSellsBarData = Array.from( currentTermSells .filter((item) => { return ( resolved.clientSellsType.filter( (sellsType) => sellsType.clientName == item.clientName && sellsType.typeName == "分销" ).length > 0 && item.amount > 0 ); }) .map((item) => { return { period: `${currtentTerms[0].toLocaleDateString()}-${currtentTerms[1].toLocaleDateString()}`, category: item.clientName, value: item.amount }; }) .reduce((carry, current) => { const key = [current.period, current.category].join("__"); if (!carry.has(key)) { carry.set(key, { ...current }); } else { carry.get(key).value += current.value; } return carry; }, new Map()) .values() ) .sort((a, b) => b.value - a.value) .filter((item) => item.value > 0) .slice(0, 5); return drawGroupedBarChart( prevTermSellsBarData.concat(currentTermSellsBarData), "period", "value", "category", (sum) => sum.toLocaleString("zh-CN", { style: "currency", currency: "CNY" }) ); }53:Td3a,{ const currtentTerms = [ TimeLib.parseAsLocalDate(startDate), TimeLib.parseAsLocalDate(endDate) ]; const prevTerms = currtentTerms.map((term) => CalcLib.shiftYearRangeBackOneCycle(term) ); const currentTermSells = CalcLib.filterByTimeRange( resolved.sells, (item) => item["purchaseMilliTs"], currtentTerms[0].getTime(), currtentTerms[1].getTime() ); const prevTermSells = CalcLib.filterByTimeRange( resolved.sells, (item) => item["purchaseMilliTs"], prevTerms[0].getTime(), prevTerms[1].getTime() ); const prevTermSellsBarData = Array.from( prevTermSells .filter((item) => { return ( resolved.clientSellsType.filter( (sellsType) => sellsType.clientName == item.clientName && sellsType.typeName == "直销" ).length > 0 && item.amount > 0 ); }) .filter((item) => { return ( resolved.productCategories.filter( (productCategory) => productCategory.productSerialNo == item.productSerialNo && productCategory.productCategory == "试剂" ).length > 0 && item.amount > 0 ); }) .map((item) => { return { period: `${prevTerms[0].toLocaleDateString()}-${prevTerms[1].toLocaleDateString()}`, category: item.clientName, value: item.amount }; }) .reduce((carry, current) => { const key = [current.period, current.category].join("__"); if (!carry.has(key)) { carry.set(key, { ...current }); } else { carry.get(key).value += current.value; } return carry; }, new Map()) .values() ) .sort((a, b) => b.value - a.value) .filter((item) => item.value > 0) .slice(0, 5); const currentTermSellsBarData = Array.from( currentTermSells .filter((item) => { return ( resolved.clientSellsType.filter( (sellsType) => sellsType.clientName == item.clientName && sellsType.typeName == "直销" ).length > 0 && item.amount > 0 ); }) .filter((item) => { return ( resolved.productCategories.filter( (productCategory) => productCategory.productSerialNo == item.productSerialNo && productCategory.productCategory == "试剂" ).length > 0 && item.amount > 0 ); }) .map((item) => { return { period: `${currtentTerms[0].toLocaleDateString()}-${currtentTerms[1].toLocaleDateString()}`, category: item.clientName, value: item.amount }; }) .reduce((carry, current) => { const key = [current.period, current.category].join("__"); if (!carry.has(key)) { carry.set(key, { ...current }); } else { carry.get(key).value += current.value; } return carry; }, new Map()) .values() ) .sort((a, b) => b.value - a.value) .filter((item) => item.value > 0) .slice(0, 5); return drawGroupedBarChart( prevTermSellsBarData.concat(currentTermSellsBarData), "period", "value", "category", (sum) => sum.toLocaleString("zh-CN", { style: "currency", currency: "CNY" }) ); }54:Td3a,{ const currtentTerms = [ TimeLib.parseAsLocalDate(startDate), TimeLib.parseAsLocalDate(endDate) ]; const prevTerms = currtentTerms.map((term) => CalcLib.shiftYearRangeBackOneCycle(term) ); const currentTermSells = CalcLib.filterByTimeRange( resolved.sells, (item) => item["purchaseMilliTs"], currtentTerms[0].getTime(), currtentTerms[1].getTime() ); const prevTermSells = CalcLib.filterByTimeRange( resolved.sells, (item) => item["purchaseMilliTs"], prevTerms[0].getTime(), prevTerms[1].getTime() ); const prevTermSellsBarData = Array.from( prevTermSells .filter((item) => { return ( resolved.clientSellsType.filter( (sellsType) => sellsType.clientName == item.clientName && sellsType.typeName == "分销" ).length > 0 && item.amount > 0 ); }) .filter((item) => { return ( resolved.productCategories.filter( (productCategory) => productCategory.productSerialNo == item.productSerialNo && productCategory.productCategory == "试剂" ).length > 0 && item.amount > 0 ); }) .map((item) => { return { period: `${prevTerms[0].toLocaleDateString()}-${prevTerms[1].toLocaleDateString()}`, category: item.clientName, value: item.amount }; }) .reduce((carry, current) => { const key = [current.period, current.category].join("__"); if (!carry.has(key)) { carry.set(key, { ...current }); } else { carry.get(key).value += current.value; } return carry; }, new Map()) .values() ) .sort((a, b) => b.value - a.value) .filter((item) => item.value > 0) .slice(0, 5); const currentTermSellsBarData = Array.from( currentTermSells .filter((item) => { return ( resolved.clientSellsType.filter( (sellsType) => sellsType.clientName == item.clientName && sellsType.typeName == "分销" ).length > 0 && item.amount > 0 ); }) .filter((item) => { return ( resolved.productCategories.filter( (productCategory) => productCategory.productSerialNo == item.productSerialNo && productCategory.productCategory == "试剂" ).length > 0 && item.amount > 0 ); }) .map((item) => { return { period: `${currtentTerms[0].toLocaleDateString()}-${currtentTerms[1].toLocaleDateString()}`, category: item.clientName, value: item.amount }; }) .reduce((carry, current) => { const key = [current.period, current.category].join("__"); if (!carry.has(key)) { carry.set(key, { ...current }); } else { carry.get(key).value += current.value; } return carry; }, new Map()) .values() ) .sort((a, b) => b.value - a.value) .filter((item) => item.value > 0) .slice(0, 5); return drawGroupedBarChart( prevTermSellsBarData.concat(currentTermSellsBarData), "period", "value", "category", (sum) => sum.toLocaleString("zh-CN", { style: "currency", currency: "CNY" }) ); }55:T935,{ const currtentTerms = [ TimeLib.parseAsLocalDate(startDate), TimeLib.parseAsLocalDate(endDate) ]; const prevTerms = currtentTerms.map((term) => CalcLib.shiftYearRangeBackOneCycle(term) ); const currentTermSells = CalcLib.filterByTimeRange( resolved.sells, (item) => item["purchaseMilliTs"], currtentTerms[0].getTime(), currtentTerms[1].getTime() ); const prevTermSells = CalcLib.filterByTimeRange( resolved.sells, (item) => item["purchaseMilliTs"], prevTerms[0].getTime(), prevTerms[1].getTime() ); const prevTermSellsBarData = Object.entries( prevTermSells.reduce((grouped, item) => { for (let productCategory of resolved.productCategories) { if (productCategory.productSerialNo == item.productSerialNo) { if (grouped[productCategory.productCategory] === undefined) { grouped[productCategory.productCategory] = []; } grouped[productCategory.productCategory].push(item); break; } } return grouped; }, {}) ) .map(([key, items]) => { return { period: `${prevTerms[0].toLocaleDateString()}-${prevTerms[1].toLocaleDateString()}`, category: key, value: items.reduce((sum, item) => sum + item.sellsCount, 0) }; }) .sort((a, b) => b.value - a.value) .slice(0, 5); const currentTermSellsBarData = Object.entries( currentTermSells.reduce((grouped, item) => { for (let productCategory of resolved.productCategories) { if (productCategory.productSerialNo == item.productSerialNo) { if (grouped[productCategory.productCategory] === undefined) { grouped[productCategory.productCategory] = []; } grouped[productCategory.productCategory].push(item); break; } } return grouped; }, {}) ) .map(([key, items]) => { return { period: `${currtentTerms[0].toLocaleDateString()}-${currtentTerms[1].toLocaleDateString()}`, category: key, value: items.reduce((sum, item) => sum + item.sellsCount, 0) }; }) .sort((a, b) => b.value - a.value) .slice(0, 5); return drawGroupedBarChart( prevTermSellsBarData.concat(currentTermSellsBarData), "period", "value", "category", (sum) => sum.toFixed(0) ); }56:T97e,{ const currtentTerms = [ TimeLib.parseAsLocalDate(startDate), TimeLib.parseAsLocalDate(endDate) ]; const prevTerms = currtentTerms.map((term) => CalcLib.shiftYearRangeBackOneCycle(term) ); const currentTermSells = CalcLib.filterByTimeRange( resolved.sells, (item) => item["purchaseMilliTs"], currtentTerms[0].getTime(), currtentTerms[1].getTime() ); const prevTermSells = CalcLib.filterByTimeRange( resolved.sells, (item) => item["purchaseMilliTs"], prevTerms[0].getTime(), prevTerms[1].getTime() ); const prevTermSellsBarData = Object.entries( prevTermSells.reduce((grouped, item) => { for (let productCategory of resolved.productCategories) { if (productCategory.productSerialNo == item.productSerialNo) { if (grouped[productCategory.productCategory] === undefined) { grouped[productCategory.productCategory] = []; } grouped[productCategory.productCategory].push(item); break; } } return grouped; }, {}) ) .map(([key, items]) => { return { period: `${prevTerms[0].toLocaleDateString()}-${prevTerms[1].toLocaleDateString()}`, category: key, value: items.reduce((sum, item) => sum + item.amount, 0) }; }) .sort((a, b) => b.value - a.value) .slice(0, 5); const currentTermSellsBarData = Object.entries( currentTermSells.reduce((grouped, item) => { for (let productCategory of resolved.productCategories) { if (productCategory.productSerialNo == item.productSerialNo) { if (grouped[productCategory.productCategory] === undefined) { grouped[productCategory.productCategory] = []; } grouped[productCategory.productCategory].push(item); break; } } return grouped; }, {}) ) .map(([key, items]) => { return { period: `${currtentTerms[0].toLocaleDateString()}-${currtentTerms[1].toLocaleDateString()}`, category: key, value: items.reduce((sum, item) => sum + item.amount, 0) }; }) .sort((a, b) => b.value - a.value) .slice(0, 5); return drawGroupedBarChart( prevTermSellsBarData.concat(currentTermSellsBarData), "period", "value", "category", (sum) => sum.toLocaleString("zh-CN", { style: "currency", currency: "CNY" }) ); }57:Tf0c,function drawTopKProductsBarChart( startDate, endDate, k, productCategoryPicked, topKSortFn, getValueFn, valueFormatFn, options = {} ) { const currtentTerms = [ TimeLib.parseAsLocalDate(startDate), TimeLib.parseAsLocalDate(endDate) ]; const prevTerms = currtentTerms.map((term) => CalcLib.shiftYearRangeBackOneCycle(term) ); const currentTermSells = CalcLib.filterByTimeRange( resolved.sells, (item) => item["purchaseMilliTs"], currtentTerms[0].getTime(), currtentTerms[1].getTime() ); const prevTermSells = CalcLib.filterByTimeRange( resolved.sells, (item) => item["purchaseMilliTs"], prevTerms[0].getTime(), prevTerms[1].getTime() ); // Calculate previous terms sells const groupedPrevTermSells = groupBy( prevTermSells, (item) => item.productSerialNo ); const prevProductSellsAgg = []; for (let productSells of Object.values(groupedPrevTermSells)) { if (productSells.length > 0) { let sellsCount = productSells.reduce( (sum, subItem) => sum + subItem.sellsCount, 0 ); let sellsAmount = productSells.reduce( (sum, subItem) => sum + subItem.amount, 0 ); let aggItem = { ...productSells[0] }; aggItem.sellsCount = sellsCount; aggItem.amount = sellsAmount; prevProductSellsAgg.push(aggItem); } } const prevGroupedAggItems = groupBy(prevProductSellsAgg, (item) => { const find = resolved.productCategories.filter((category) => { return category.productSerialNo == item.productSerialNo; }); if (find.length > 0) { return find[0].productCategory; } return "未分类"; }); const prevTermSellsBarData = []; for (let category in prevGroupedAggItems) { if (category != productCategoryPicked) { continue; } const topK = prevGroupedAggItems[category].sort(topKSortFn).slice(0, k); topK.map((topItem) => { prevTermSellsBarData.push({ period: `${prevTerms[0].toLocaleDateString()}-${prevTerms[1].toLocaleDateString()} ${category}`, category: topItem.productName, value: getValueFn(topItem) }); }); } // Calculate current terms sells const groupedCurrentTermSells = groupBy( currentTermSells, (item) => item.productSerialNo ); const currentProductSellsAgg = []; for (let productSells of Object.values(groupedCurrentTermSells)) { if (productSells.length > 0) { let sellsCount = productSells.reduce( (sum, subItem) => sum + subItem.sellsCount, 0 ); let sellsAmount = productSells.reduce( (sum, subItem) => sum + subItem.amount, 0 ); let aggItem = { ...productSells[0] }; aggItem.sellsCount = sellsCount; aggItem.amount = sellsAmount; currentProductSellsAgg.push(aggItem); } } const currentGroupedAggItems = groupBy(currentProductSellsAgg, (item) => { const find = resolved.productCategories.filter((category) => { return category.productSerialNo == item.productSerialNo; }); if (find.length > 0) { return find[0].productCategory; } return "未分类"; }); const currentTermSellsBarData = []; for (let category in currentGroupedAggItems) { if (category != productCategoryPicked) { continue; } const topK = currentGroupedAggItems[category].sort(topKSortFn).slice(0, k); topK.map((topItem) => { currentTermSellsBarData.push({ period: `${currtentTerms[0].toLocaleDateString()}-${currtentTerms[1].toLocaleDateString()} ${category}`, category: topItem.productName, value: getValueFn(topItem) }); }); } return drawGroupedBarChart( prevTermSellsBarData.concat(currentTermSellsBarData), "period", "value", "category", valueFormatFn, options ); }58:T744,{ const currtentTerms = [ TimeLib.parseAsLocalDate(startDate), TimeLib.parseAsLocalDate(endDate) ]; const currentTermSells = CalcLib.filterByTimeRange( resolved.sells, (item) => item["purchaseMilliTs"], currtentTerms[0].getTime(), currtentTerms[1].getTime() ); const domain = Array.from( new Set(resolved.productFabs.map((item) => item.fabName)).values() ); const groupedCurrentTermSells = groupBy(currentTermSells, (item) => { const find = resolved.productFabs.filter( (fabItem) => fabItem.productSerialNo == item.productSerialNo ); if (find.length > 0) { return find[0].fabName; } return "未分类"; }); const currentTermSellsAgg = []; const currentTermSellsAmountSum = Object.values(groupedCurrentTermSells) .flat() .reduce((sum, item) => sum + item.amount, 0); for (let fabName in groupedCurrentTermSells) { if (groupedCurrentTermSells[fabName].length > 0) { let aggItem = { label: fabName, value: groupedCurrentTermSells[fabName].reduce( (sum, item) => sum + item.amount, 0 ), ratio: 0 }; aggItem.ratio = aggItem.value / currentTermSellsAmountSum; currentTermSellsAgg.push(aggItem); } } return drawPieChart( currentTermSellsAgg, (item) => item.label, (item) => item.value, { width: 600, height: 300, domain, domainColors: d3.schemePastel2, getTitleFn: (d) => `${d.label}: ${d.value.toLocaleString("zh-CN", { style: "currency", currency: "CNY" })}`, tspanTexts: [ (d) => `销售额：${d.value.toLocaleString("zh-CN", { style: "currency", currency: "CNY" })}`, (d) => `占比：${d3.format(".2%")(d.ratio)}` ] } ); }59:T6eb,{ const currtentTerms = [ TimeLib.parseAsLocalDate(startDate), TimeLib.parseAsLocalDate(endDate) ]; const currentTermSells = CalcLib.filterByTimeRange( resolved.sells, (item) => item["purchaseMilliTs"], currtentTerms[0].getTime(), currtentTerms[1].getTime() ); const domain = Array.from( new Set(resolved.productFabs.map((item) => item.fabName)).values() ); const groupedCurrentTermSells = groupBy(currentTermSells, (item) => { const find = resolved.productFabs.filter( (fabItem) => fabItem.productSerialNo == item.productSerialNo ); if (find.length > 0) { return find[0].fabName; } return "未分类"; }); const currentTermSellsAgg = []; const currentTermSellsAmountSum = Object.values(groupedCurrentTermSells) .flat() .reduce((sum, item) => sum + item.sellsCount, 0); for (let fabName in groupedCurrentTermSells) { if (groupedCurrentTermSells[fabName].length > 0) { let aggItem = { label: fabName, value: groupedCurrentTermSells[fabName].reduce( (sum, item) => sum + item.sellsCount, 0 ), ratio: 0 }; aggItem.ratio = aggItem.value / currentTermSellsAmountSum; currentTermSellsAgg.push(aggItem); } } return drawPieChart( currentTermSellsAgg, (item) => item.label, (item) => item.value, { width: 600, height: 300, domain, domainColors: d3.schemePastel2, getTitleFn: (d) => `${d.label}: ${d.value.toLocaleString("zh-CN", { style: "currency", currency: "CNY" })}`, tspanTexts: [ (d) => `销售量：${d.value.toFixed(0)}`, (d) => `占比：${d3.format(".2%")(d.ratio)}` ] } ); }5a:Tc37,{ const sellsData = resolved.sells.filter( (item) => item.clientName == vendorSpecified ); const currtentTerms = [ TimeLib.parseAsLocalDate(startDate), TimeLib.parseAsLocalDate(endDate) ]; const prevTerms = currtentTerms.map((term) => CalcLib.shiftYearRangeBackOneCycle(term) ); const currentTermSells = CalcLib.filterByTimeRange( sellsData, (item) => item["purchaseMilliTs"], currtentTerms[0].getTime(), currtentTerms[1].getTime() ); const prevTermSells = CalcLib.filterByTimeRange( sellsData, (item) => item["purchaseMilliTs"], prevTerms[0].getTime(), prevTerms[1].getTime() ); const prevTermSellsBarData = Array.from( prevTermSells .filter((item) => item.amount > 0) .filter((item) => { if (!productTypeSpecified) { return true; } const find = resolved.productCategories.filter( (productCategory) => item.productSerialNo == productCategory.productSerialNo && productCategory.productCategory == productTypeSpecified ); return find.length > 0; }) .map((item) => { return { period: `${prevTerms[0].toLocaleDateString()}-${prevTerms[1].toLocaleDateString()}`, category: item.productName, value: item.amount }; }) .reduce((carry, current) => { const key = [current.period, current.category].join("__"); if (!carry.has(key)) { carry.set(key, { ...current }); } else { carry.get(key).value += current.value; } return carry; }, new Map()) .values() ) .sort((a, b) => b.value - a.value) .filter((item) => item.value > 0); // .slice(0, 5); const currentTermSellsBarData = Array.from( currentTermSells .filter((item) => item.amount > 0) .filter((item) => { if (!productTypeSpecified) { return true; } const find = resolved.productCategories.filter( (productCategory) => item.productSerialNo == productCategory.productSerialNo && productCategory.productCategory == productTypeSpecified ); return find.length > 0; }) .map((item) => { return { period: `${currtentTerms[0].toLocaleDateString()}-${currtentTerms[1].toLocaleDateString()}`, category: item.productName, value: item.amount }; }) .reduce((carry, current) => { const key = [current.period, current.category].join("__"); if (!carry.has(key)) { carry.set(key, { ...current }); } else { carry.get(key).value += current.value; } return carry; }, new Map()) .values() ) .sort((a, b) => b.value - a.value) .filter((item) => item.value > 0); // .slice(0, 5); return drawGroupedBarChart( prevTermSellsBarData.concat(currentTermSellsBarData), "period", "value", "category", (sum) => sum.toLocaleString("zh-CN", { style: "currency", currency: "CNY" }) ); }5b:T5c5,{ const clientSellsTypeMap = new Map( resolved.clientSellsType.map((item) => [item.clientName, item.typeName]) ); const data = resolved.sells.reduce((bucket, item) => { // test "直销" or "分销" const sellsType = clientSellsTypeMap.get(item.clientName); if (bucket[sellsType] === undefined) { bucket[sellsType] = { sum: 0, count: 0 }; } bucket[sellsType].count++; bucket[sellsType].sum += item.amount; return bucket; }, {}); data["直销"].percentage = data["直销"].sum / (data["直销"].sum + data["分销"].sum); data["分销"].percentage = data["分销"].sum / (data["直销"].sum + data["分销"].sum); const pieChatData = [ { label: "直销", value: data["直销"] }, { label: "分销", value: data["分销"] } ]; return drawPieChart( pieChatData, (item) => item.label, (item) => item.value.sum, { width: 600, height: 300, domain: ["直销", "分销"], domainColors: ["blue", "orange"], getTitleFn: (d) => `${d.label}: ${d.value.sum.toLocaleString("zh-CN", { style: "currency", currency: "CNY" })}`, tspanTexts: [ (d) => `销售额：${d.value.sum.toLocaleString("zh-CN", { style: "currency", currency: "CNY" })}`, (d) => `占比：${d3.format(".2%")(d.value.percentage)}` ] } ); }5c:T29e1,// drawGroupedBarChart 函数：绘制支持每组局部子分组（x1）的分组柱状图 // 提供 tooltip、图例点击高亮与过滤、柱体标签、导出 CSV、图例搜索、图例分页等功能 // 可直接在 Observable 中运行（不依赖 Vue/React 框架） function drawGroupedBarChart( data, // 输入数据数组 xKey, // 主分组字段，例如 x 轴上的“月份”或“地区” yKey, // 数值字段，即柱状图的高度字段 categoryKey, // 子分组字段，例如不同“产品类型”、“渠道” formatY = (d) => d, // 可选格式化函数，用于显示数值标签和 tooltip 的值 options = {} // 可选配置项，例如是否启用导出、图例搜索、分页等 ) { // --- 基本图表配置 --- const margin = { top: 120, right: 240, bottom: 60, left: 120 }; let width = options.width || 960; let height = options.height || 640; width = width - margin.left - margin.right; height = height - margin.top - margin.bottom; const legendMaxHeight = height - 24; const legendItemHeight = options.legendItemHeight || 40; // 创建 SVG 元素并设置尺寸与基础样式 const svg = d3 .create("svg") .attr("width", width + margin.left + margin.right) .attr("height", height + margin.top + margin.bottom) .style("font-family", "sans-serif") .style("background", "transparent"); // 创建绘图区主容器（g 元素），应用 margin 偏移 const chart = svg .append("g") .attr("transform", `translate(${margin.left},${margin.top})`); // 获取主分组和所有子分组（即横轴大类 + legend 小类） const groups = Array.from(new Set(data.map((d) => d[xKey]))); const allSubgroups = Array.from(new Set(data.map((d) => d[categoryKey]))); // 主轴 x0：大组的分布 const x0 = d3.scaleBand().domain(groups).range([0, width]).paddingInner(0.1); // y 轴：根据最大值设定比例尺 const maxDataValue = d3.max(data, (d) => d[yKey]); const y = d3 .scaleLinear() .domain([0, maxDataValue]) .nice() .range([height, 0]); // 色彩映射（每个子组一个颜色） const color = d3 .scaleOrdinal() .domain(allSubgroups) .range( ["rgb(43, 69, 121)", "rgb(243, 190, 14)"] .concat(d3.schemeSet2) .concat(d3.schemePastel1) ); // 控制功能开关 const enableLegendPaging = options.enableLegendPaging ?? false; const enableExport = options.enableExport ?? false; const enableLegendSearch = options.enableLegendSearch ?? false; // tooltip 初始化 const tooltip = d3 .select("body") .append("div") .style("position", "absolute") .style("background", "#fff") .style("padding", "6px 10px") .style("border", "1px solid #ccc") .style("border-radius", "4px") .style("pointer-events", "none") .style("opacity", 0); // 绘制 x 轴（底部主轴） chart .append("g") .attr("transform", `translate(0,${height})`) .call(d3.axisBottom(x0)); // 绘制 y 轴与网格线 chart .append("g") .call(d3.axisLeft(y)) .call((g) => g .selectAll(".tick line") .clone() .attr("x2", width) .attr("stroke-opacity", 0.1) ); // 局部子组比例尺函数（每个主分组下的子类可能不同） function getLocalX1Scale(groupData) { const localSubgroups = Array.from( new Set(groupData.map((d) => d[categoryKey])) ); return d3 .scaleBand() .domain(localSubgroups) .range([0, x0.bandwidth()]) .padding(0.05); } // 渲染一个主组下的所有子组柱子 function renderGroupBars(group, activeKeys) { const groupData = data.filter( (d) => d[xKey] === group && d[yKey] !== 0 && activeKeys.has(d[categoryKey]) ); if (groupData.length === 0) return; const localX1 = getLocalX1Scale(groupData); const layer = chart .append("g") .attr("class", "layer") .attr("transform", `translate(${x0(group)},0)`); // 绘制柱子，带动画过渡 layer .selectAll("rect") .data(groupData) .join("rect") .attr("x", (d) => localX1(d[categoryKey])) .attr("y", y(0)) .attr("width", localX1.bandwidth()) .attr("height", 0) .attr("fill", (d) => color(d[categoryKey])) .transition() .duration(600) .attr("y", (d) => y(d[yKey])) .attr("height", (d) => y(0) - y(d[yKey])); // 添加数值标签 layer .selectAll("text") .data(groupData) .join("text") .attr("x", (d) => localX1(d[categoryKey]) + localX1.bandwidth() / 2) .attr("y", (d) => y(d[yKey]) - 5) .text((d) => formatY(d[yKey])) .attr("text-anchor", "middle") .attr("fill", "#000") .style("font-size", "12px") .style("pointer-events", "none"); // tooltip 交互逻辑 layer .selectAll("rect") .on("mouseover", function (event, d) { tooltip.transition().duration(200).style("opacity", 0.9); tooltip .html( `${xKey}: ${d[xKey]}
${categoryKey}: ${ d[categoryKey] }
Value: ${formatY(d[yKey])}` ) .style("left", event.pageX + 10 + "px") .style("top", event.pageY - 28 + "px"); d3.select(this).attr("fill", d3.rgb(color(d[categoryKey])).darker(1)); }) .on("mouseout", function (event, d) { tooltip.transition().duration(300).style("opacity", 0); d3.select(this).attr("fill", color(d[categoryKey])); }); } // 激活子组列表（用于过滤图例） const activeSet = new Set(allSubgroups); // 主渲染函数：对所有组执行 render function renderAll() { chart.selectAll(".layer").remove(); groups.forEach((g) => renderGroupBars(g, activeSet)); } renderAll(); // 图例控制区域容器（右侧控制栏） const controlGroup = svg .append("g") .attr("transform", `translate(${width + margin.left}, ${margin.top / 2})`); // --- 导出 CSV 按钮 --- if (enableExport) { controlGroup .append("foreignObject") .attr("x", margin.left / 2) .attr("y", 0) .attr("width", 120) .attr("height", 36) .append("xhtml:button") .html("📥 导出 CSV") .attr("class", "export-btn") .style("cursor", "pointer") .style("background-color", "#007bff") .style("color", "white") .style("border", "none") .style("border-radius", "6px") .style("padding", "6px 14px") .style("font-size", "13px") .style("box-shadow", "0 1px 3px rgba(0, 0, 0, 0.2)") .on("click", () => { const csv = [ [xKey, categoryKey, yKey], ...data.map((d) => [d[xKey], d[categoryKey], d[yKey]]) ] .map((row) => row.join(",")) .join("\n"); const blob = new Blob([csv], { type: "text/csv;charset=utf-8;" }); const link = document.createElement("a"); link.href = URL.createObjectURL(blob); link.download = "grouped-bar-data.csv"; document.body.appendChild(link); link.click(); document.body.removeChild(link); }); } // --- 图例搜索栏 --- if (enableLegendSearch) { controlGroup .append("foreignObject") .attr("x", -width) .attr("y", 0) .attr("width", 160) .attr("height", 80) .append("xhtml:input") .attr("placeholder", "🔍 搜索图例") .style("width", "100%") .style("padding", "8px 8px") .style("font-size", "12px") .style("border-radius", "4px") .style("border", "1px solid #ccc") .on("input", function () { const keyword = this.value.toLowerCase(); legendItems.attr("display", (d) => d.toLowerCase().includes(keyword) ? null : "none" ); }); } // --- 图例列表区域 --- const legendContainer = svg .append("g") .attr( "transform", `translate(${width + margin.left + 50}, ${margin.top + 50})` ); // 创建 legend 裁剪区域（用于分页滚动） const legendClipId = "legend-clip-path"; svg .append("clipPath") .attr("id", legendClipId) .append("rect") .attr("width", margin.right - 20) .attr("height", legendMaxHeight); const legendScrollable = legendContainer .append("g") .attr("clip-path", `url(#${legendClipId})`); // 绘制 legend 条目 const legendItems = legendScrollable .selectAll(".legend-item") .data(allSubgroups) .join("g") .attr("class", "legend-item") .attr("transform", (_, i) => `translate(0, ${i * legendItemHeight})`) .style("cursor", "pointer") .on("click", function (_, key) { if (activeSet.has(key)) activeSet.delete(key); else activeSet.add(key); renderAll(); updateLegendHighlight(); }); // legend 矩形 legendItems .append("rect") .attr("width", 18) .attr("height", 18) .attr("fill", (d) => color(d)); // legend 文本换行处理 const maxLineLength = 10; legendItems.each(function (key) { const group = d3.select(this); const lines = key.length > maxLineLength ? key.match(new RegExp(`.{1,${maxLineLength}}`, "g")) : [key]; lines.forEach((line, j) => { group .append("text") .attr("x", 24) .attr("y", 13 + j * 14) .text(line) .style("font", "12px sans-serif"); }); }); // 高亮 legend（根据 active 状态变化颜色） function updateLegendHighlight() { legendItems .select("rect") .attr("fill", (d) => (activeSet.has(d) ? color(d) : "#ccc")); } updateLegendHighlight(); // --- 图例分页按钮（上下滚动）--- if (enableLegendPaging) { let scrollOffset = 0; const maxOffset = Math.max( 0, allSubgroups.length * legendItemHeight - legendMaxHeight ); const scrollStep = 40; function scrollLegend(dy) { scrollOffset = Math.max(0, Math.min(scrollOffset + dy, maxOffset)); legendScrollable.attr("transform", `translate(0, ${-scrollOffset})`); } const scrollButtons = legendContainer.append("g"); scrollButtons .append("text") .attr("x", 0) .attr("y", -10) .text("▲") .style("cursor", "pointer") .style("font-size", "16px") .on("click", () => scrollLegend(-scrollStep)); scrollButtons .append("text") .attr("x", 0) .attr("y", legendMaxHeight - margin.bottom / 2) .text("▼") .style("cursor", "pointer") .style("font-size", "16px") .on("click", () => scrollLegend(scrollStep)); } // 返回完整 SVG 节点 return svg.node(); }5d:[{"id":"3a7e9d5a2726b5888979b481a11f05c91df4321ad9be07e73f37d54aec2b72894721ba827e3ad6bb8734729c1f70867b0682cbc5269148e973cdef8ea05b0c0e","href":"https://static.observableusercontent.com/files/3a7e9d5a2726b5888979b481a11f05c91df4321ad9be07e73f37d54aec2b72894721ba827e3ad6bb8734729c1f70867b0682cbc5269148e973cdef8ea05b0c0e","name":"分类表.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1749569522517.038,"size":19124},{"id":"a3b0c2268cef2c34fe2dec1829ccccc5fbb33e26168b841b16f929a60ea885bbda5ba0111592419948c0d7968057cb34d5798a1296721f170fa9deb611282b95","href":"https://static.observableusercontent.com/files/a3b0c2268cef2c34fe2dec1829ccccc5fbb33e26168b841b16f929a60ea885bbda5ba0111592419948c0d7968057cb34d5798a1296721f170fa9deb611282b95","name":"直分销@2.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1749569630094.643,"size":10844},{"id":"49f41a1435340eb1590543526a81abe6b263aadf6c2f0d966afed038cbafa7bbc6d9a80d00be88064a48cbee945d1259aac1fbba77d023d9a0db4c3f7b2b9415","href":"https://static.observableusercontent.com/files/49f41a1435340eb1590543526a81abe6b263aadf6c2f0d966afed038cbafa7bbc6d9a80d00be88064a48cbee945d1259aac1fbba77d023d9a0db4c3f7b2b9415","name":"直分销@3.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1750002257980.882,"size":10627},{"id":"a99557829767a798280831cb38b8d2859476c9c44596462e54b261d1506c3120536ec9b128045a3dc83bac7046e63b1c63524c9f6acc616a31ab5913c6f02329","href":"https://static.observableusercontent.com/files/a99557829767a798280831cb38b8d2859476c9c44596462e54b261d1506c3120536ec9b128045a3dc83bac7046e63b1c63524c9f6acc616a31ab5913c6f02329","name":"直分销@4.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1750692431460.145,"size":11251},{"id":"b11a5d91f3832180a35cdf8c7e38541e30797ffff82a5e19619be6262191e5e84c7963622ef9e93440d24ba3eb42d4c90d14b62ee23957a4019e72d3d8900e81","href":"https://static.observableusercontent.com/files/b11a5d91f3832180a35cdf8c7e38541e30797ffff82a5e19619be6262191e5e84c7963622ef9e93440d24ba3eb42d4c90d14b62ee23957a4019e72d3d8900e81","name":"产线分类.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1750174407875.055,"size":10678}] 29:{"id":"2c5153a304292c1f","slug":null,"title":"","thumbnail":"2cd22c2bf9663157bc0e3d835bff987f2cad24efcd1311ecc2b5d53d738382a4","access_level":"public","create_time":"$D2025-06-09T15:40:00.819Z","update_time":"$D2025-06-23T16:07:31.122Z","view_time":null,"first_public_time":"$D2025-06-10T15:27:38.533Z","has_unpublished_edits":null,"fork":{"id":"66588daff875278c","slug":"sql-chart","title":"SQL + Chart","owner":{"id":"f35c755083683fe5","login":"observablehq","name":"Observable"}},"stars":0,"starred":false,"owner":{"type":"team","id":"84b86532449eee03","login":"hidehalo-ws","name":"hidehalo's Workspace","avatar_url":"https://avatars-next.observableusercontent.com/a6b65bb92c36cc1542ec4fbff31036e47acb3bcce8dc985e884e1b55f1e1aad1","tier":"starter_2024","bio":"","followed_by_you":false,"follows_you":false},"version":1507,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"c806388635ba2ba3","login":"hidehalo","name":"hidehalo","avatar_url":"https://avatars-next.observableusercontent.com/0b41e56ffa682d1ff4037e5c63a83be4a6c1dbe19f8339d0f32ec515dc9a9713","tier":null,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"individual","id":"c806388635ba2ba3","login":"hidehalo","name":"hidehalo","avatar_url":"https://avatars-next.observableusercontent.com/0b41e56ffa682d1ff4037e5c63a83be4a6c1dbe19f8339d0f32ec515dc9a9713","tier":null,"role":"editor"},{"type":"team","id":"84b86532449eee03","login":"hidehalo-ws","name":"hidehalo's Workspace","avatar_url":"https://avatars-next.observableusercontent.com/a6b65bb92c36cc1542ec4fbff31036e47acb3bcce8dc985e884e1b55f1e1aad1","tier":"starter_2024","role":"viewer"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"","cells":[{"id":177,"value":"## 1. 上传数据源文件\n\n- 上传销售数据文件，仅支持XLSX格式。\n- 支持一次上传多个文件。","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":164,"value":"viewof xlsxFiles = Inputs.file({\n label: \"请选择销售数据文件\",\n multiple: true,\n accept: \".xlsx\",\n required: true\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":191,"value":"$49","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":342,"value":"{\n return resolved.sells != undefined\n ? `共载入了 ${resolved.sells.length} 条销售数据`\n : `未上传销售数据呢`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":280,"value":"## 2. 选择进行同期分析的时间周期\n\n接下来需要手动选择数据分析的开始日期及截止日期","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":371,"value":"viewof startDate = Inputs.date({ label: \"开始日期\", required: true })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":382,"value":"viewof endDate = Inputs.date({ label: \"截止日期\", required: true })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":565,"value":"$4a","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":655,"value":"CalcLib.aggregateSalesByCycle(\n resolved.sells,\n [\"productSerialNo\", \"clientName\"],\n \"month\",\n \"purchaseMilliTs\"\n).reduce((grouped, item) => {\n const key = item.value.clientName;\n if (grouped[key] === undefined) {\n grouped[key] = [];\n }\n grouped[key].push(item);\n return grouped;\n}, {})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":555,"value":"$4b","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":407,"value":"### 2.1. 分析摘要","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":331,"value":"$4c","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":457,"value":"## 3. 报表与图表绘制","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":449,"value":"$4d","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":993,"value":"$4e","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1002,"value":"### 3.1 输入时间范围，总销售金额同期对比（柱状图）","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1014,"value":"$4f","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":950,"value":"### 3.2 输入时间范围，直分销金额同期占比对比（柱状图）","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":919,"value":"$50","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1016,"value":"### 3.3 输入时间范围，直销客户同期销售金额筛选销售金额top5（柱状图）","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1018,"value":"$51","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1020,"value":"### 3.4 输入时间范围，分销客户同期销售金额筛选销售金额top5（柱状图）","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1022,"value":"$52","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1024,"value":"### 3.5 输入时间范围，直销客户试剂销售金额对比筛选销售金额top5（柱状图）","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1026,"value":"$53","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1028,"value":"### 3.6 输入时间范围，分销客户试剂销售金额对比筛选销售金额top5（柱状图）","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1031,"value":"$54","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1232,"value":"### 3.7 输入时间范围，按产品类型排名TOP5 例：产品类型：试剂/配件/设备销售数量排名（柱状图）","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1234,"value":"$55","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1238,"value":"### 3.8 输入时间范围，按产品类型排名TOP5 例：产品类型：试剂/配件/设备销售金额的排名（柱状图）","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1241,"value":"$56","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1278,"value":"### 3.9 输入时间范围，分别展示每个类型销售金额TOP5的产品及对应销售金额（柱状图）","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1280,"value":"$57","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1444,"value":"#### 3.9.1 设备","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1369,"value":"drawTopKProductsBarChart(\n startDate,\n endDate,\n 5,\n \"设备\",\n (a, b) => b.amount - a.amount,\n (item) => item.amount,\n (value) =>\n value.toLocaleString(\"zh-CN\", {\n style: \"currency\",\n currency: \"CNY\"\n })\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1446,"value":"#### 3.9.2 配件","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1381,"value":"drawTopKProductsBarChart(\n startDate,\n endDate,\n 5,\n \"配件\",\n (a, b) => b.amount - a.amount,\n (item) => item.amount,\n (value) =>\n value.toLocaleString(\"zh-CN\", {\n style: \"currency\",\n currency: \"CNY\"\n })\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1448,"value":"#### 3.9.3 试剂","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1378,"value":"drawTopKProductsBarChart(\n startDate,\n endDate,\n 5,\n \"试剂\",\n (a, b) => b.amount - a.amount,\n (item) => item.amount,\n (value) =>\n value.toLocaleString(\"zh-CN\", {\n style: \"currency\",\n currency: \"CNY\"\n })\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1282,"value":"### 3.10 输入时间范围，分别展示每个类型销售数量TOP5的产品及对应销售数量（柱状图）","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1450,"value":"#### 3.10.1 设备","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1284,"value":"drawTopKProductsBarChart(\n startDate,\n endDate,\n 5,\n \"设备\",\n (a, b) => b.sellsCount - a.sellsCount,\n (item) => item.sellsCount,\n (value) => value.toFixed(0)\n)\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1452,"value":"#### 3.10.2 试剂","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1386,"value":"drawTopKProductsBarChart(\n startDate,\n endDate,\n 5,\n \"试剂\",\n (a, b) => b.sellsCount - a.sellsCount,\n (item) => item.sellsCount,\n (value) => value.toFixed(0),\n {\n legendItemHeight: 70\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1454,"value":"#### 3.10.3 配件","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1389,"value":"drawTopKProductsBarChart(\n startDate,\n endDate,\n 5,\n \"配件\",\n (a, b) => b.sellsCount - a.sellsCount,\n (item) => item.sellsCount,\n (value) => value.toFixed(0)\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1403,"value":"### 3.11 输入时间范围，按产线类型做销售金额的占比","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1405,"value":"$58","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1407,"value":"### 3.12 输入时间范围，按产线类型做销售数量的占比","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1409,"value":"$59","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1476,"value":"### 3.13 输入时间范围，指定分销商进行销售产品金额的同期比较","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1478,"value":"viewof vendorSpecified = Inputs.select(\n resolved.clientSellsType\n .filter((item) => item.typeName == \"分销\")\n .map((item) => item.clientName),\n { label: \"指定分销商\" }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1496,"value":"viewof productTypeSpecified = Inputs.select(\n new Set(resolved.productCategories.map((item) => item.productCategory)),\n {\n label: \"指定产品类型\"\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1490,"value":"$5a","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1144,"value":"## Testing...","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":688,"value":"$5b","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":816,"value":"$5c","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1317,"value":"function groupBy(array, keyFn) {\n return array.reduce((acc, item) => {\n const key = keyFn(item);\n if (!acc[key]) acc[key] = [];\n acc[key].push(item);\n return acc;\n }, {});\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W5d","stdlib":"1"}} 24:null