/* WAREHOUSE 2.0 · 報表 — Swiss 版式,真後端(/api/reports/summary) */ (() => { const W2 = window.W2; const { t } = window.W2_LANG; window.W2_LANG.addEN({ "報表": "Reports", "經營報表駕駛艙 · 出入庫走勢 · 儲值與消耗 · 頁面只讀,生成與導出交秘書": "Business reporting cockpit · in/out trends · value & consumption · read-only, generation and export via Secretary", "導出匯總 CSV": "Export summary CSV", "問秘書": "Ask Secretary", "刷新": "Refresh", "正在從資料庫計算報表…": "Computing reports from the database…", "COMPUTING": "COMPUTING", "暫無數據": "No data yet", // KPI(後端中文 key) "本期入庫": "Inbound orders", "本期出庫": "Outbound orders", "庫存總儲值": "Total stock value", "緊急搶修單": "Urgent repair orders", "單": "", "件": "", "萬": "×10k", "按單價估算": "by unit price", "本期": "this period", "{n} 件": "{n} pcs", // 走勢 "出入庫走勢": "In / out trend", "單據量 · 按月": "Orders per month", "近 6 月": "Last 6 mo", "全週期": "All time", "入庫": "Inbound", "出庫": "Outbound", "還沒有出入庫流水": "No in/out records yet", "產生單據後,月度走勢會出現在這裡。": "Monthly trends will appear here once orders exist.", // 儲值分佈 "庫存儲值分佈": "Stock value by category", "總儲值": "Total value", "暫無帶單價的庫存資料": "No priced stock data yet", "對秘書說「幫物資補上單價」,儲值分析就會出現。": "Tell the Secretary to fill in unit prices and this analysis will appear.", // 消耗 "物資消耗 TOP 5": "Top 5 consumed items", "出庫 / 領用數量排行": "by outbound / requisition quantity", "分析消耗結構": "Analyze consumption", "暫無出庫消耗資料": "No consumption data yet", "有出庫或領用後,排行自動生成。": "The ranking builds itself once outbound activity exists.", // 預警與週轉 "預警處理與週轉": "Alerts & turnover", "AI 掃描 · 人工拍板": "AI scans · humans decide", "處理率": "Handled rate", "累計預警": "Total alerts", "已處理": "Handled", "待歸還": "Pending returns", "庫存週轉率": "Stock turnover", "逐條處置": "Handle each", // 報表目錄 "報表目錄": "Report catalogue", "1.0 全部報表 · 生成與導出交秘書": "All 1.0 reports · generate & export via Secretary", "月度出入庫匯總表": "Monthly in/out summary", "庫存儲值與週轉分析": "Stock value & turnover analysis", "物資消耗排行": "Consumption ranking", "未關閉預警清單": "Open alerts list", "全部入庫與出庫單據流水,含物資、數量與時間,按月匯總。": "Every inbound and outbound order line with item, quantity and time, summarized by month.", "按分類統計庫存儲值,配合週轉率看資金佔用是否健康。": "Stock value by category, with turnover rate to judge capital efficiency.", "出庫與領用數量排行,找出消耗最快、最該盯緊的物資。": "Ranking by outbound and requisition quantity — the items burning fastest.", "全部未關閉預警與處置建議,含待歸還工器具。": "All open alerts with suggested actions, including tools pending return.", "業務": "OPS", "財務": "FIN", "安全": "SAFETY", "月報": "MONTHLY", "週報": "WEEKLY", "秘書生成導出": "Generate & export", "問要點": "Key points", "關鍵數字": "Key figure", "入庫 {a} 單 · 出庫 {b} 單": "In {a} · Out {b}", "週轉": "turnover", "{n} 條未關閉": "{n} open", "2.0 約定:頁面只讀,報表由秘書按最新數據生成與導出,全程留痕。": "2.0 covenant: the page is read-only. Reports are generated and exported by the Secretary from live data, fully audited.", // 秘書指令 "把本期經營報表的要點講給我聽:出入庫、庫存儲值、消耗排行、預警處理,各給關鍵數字和一句判斷": "Walk me through this period's reports: in/out, stock value, consumption ranking, alert handling — key figures plus one-line verdicts", "生成本期出入庫匯總表,整理成表格給我,並導出 CSV": "Generate this period's in/out summary as a table and export it to CSV", "分析本期物資消耗結構:哪些消耗最快、是否合理、要不要調整安全庫存": "Analyze consumption structure: what burns fastest, is it reasonable, should safety stocks change", "把未關閉的預警和待歸還工器具逐條列出,給出處置建議,經我確認後執行": "List every open alert and pending tool return with suggested actions; execute after my confirmation", "生成「{name}」({cycle}),先用表格把要點給我,再導出 CSV": "Generate \"{name}\" ({cycle}): show key points as a table first, then export CSV", "「{name}」這份報表,直接把本期要點和異常講給我": "For \"{name}\": give me this period's key points and anomalies directly", }); const { useState: _s, useEffect: _e, useMemo: _mm } = React; const { Icon: I, Btn: B, Tag: T, Label: LB, Empty: EM, Kpi, Meter, StackBar, Folio, Band, pad2, num } = W2; const ask = (p) => W2.openSecretary(p); /* 後端動態文案(如「123 件」)的可譯處理:數字+單位拆開走 {n} 詞條 */ const tExtra = (x) => { const m = /^(\d+(?:\.\d+)?)\s*件$/.exec(String(x)); return m ? t("{n} 件", { n: m[1] }) : t(x); }; /* ── 報表目錄(1.0 exportable 的說明與圖標;後端返回時以後端名單為準)── */ const CATALOG = [ { name: "月度出入庫匯總表", type: "業務", cycle: "月報", icon: "swap", desc: "全部入庫與出庫單據流水,含物資、數量與時間,按月匯總。" }, { name: "庫存儲值與週轉分析", type: "財務", cycle: "月報", icon: "wallet", desc: "按分類統計庫存儲值,配合週轉率看資金佔用是否健康。" }, { name: "物資消耗排行", type: "業務", cycle: "月報", icon: "trend", desc: "出庫與領用數量排行,找出消耗最快、最該盯緊的物資。" }, { name: "未關閉預警清單", type: "安全", cycle: "週報", icon: "alert", desc: "全部未關閉預警與處置建議,含待歸還工器具。" }, ]; /* ── 分組柱狀圖(Swiss:矩形、無圓角,墨=入庫 / 灰=出庫)── */ const Bars2 = ({ labels, a, b }) => { const H = 150; const max = Math.max(1, ...a.map(num), ...b.map(num)); const hOf = (v) => { const n = num(v); return n > 0 ? Math.max(3, Math.round(n / max * H)) : 1; }; return (
{labels.map((lb, i) => (
{lb}
))}
); }; const LegendSq = ({ color, label }) => ( {label} ); const Page = ({ boot }) => { const [data, setData] = _s(null); const [rng, setRng] = _s("m6"); const [tick, setTick] = _s(0); _e(() => { let alive = true; W2.json("/api/reports/summary").then(d => alive && setData(d && typeof d === "object" ? d : {})).catch(() => alive && setData({})); return () => { alive = false; }; }, [tick]); const d = data || {}; /* KPI:後端數組;缺失時退回固定四格(值 —) */ const kpisRaw = Array.isArray(d.kpis) && d.kpis.length ? d.kpis : [{ key: "本期入庫", unit: "單" }, { key: "本期出庫", unit: "單" }, { key: "庫存總儲值", unit: "萬" }, { key: "緊急搶修單", unit: "單" }]; const kpis = kpisRaw.slice(0, 4); const kByKey = {}; kpis.forEach(k => { if (k && k.key) kByKey[k.key] = k; }); /* 走勢 */ const tr = d.trend && typeof d.trend === "object" ? d.trend : {}; const tLabels = Array.isArray(tr.labels) ? tr.labels : []; const tIn = Array.isArray(tr.inbound) ? tr.inbound : []; const tOut = Array.isArray(tr.outbound) ? tr.outbound : []; const hasTrend = tLabels.length > 0 && (tIn.some(v => num(v) > 0) || tOut.some(v => num(v) > 0)); const cut = rng === "m6" ? 6 : tLabels.length; const vLabels = tLabels.slice(-cut), vIn = tIn.slice(-cut), vOut = tOut.slice(-cut); /* 儲值分佈(顏色統一映射到 Swiss 圖表色) */ const dist = (Array.isArray(d.value_dist) ? d.value_dist : []).filter(x => x && num(x.value) > 0); const totalVal = dist.reduce((s, x) => s + num(x.value), 0); const stack = dist.map((x, i) => ({ value: num(x.value), color: W2.CHART_COLORS[i % W2.CHART_COLORS.length], label: x.label || "—" })); /* 消耗 Top */ const top = (Array.isArray(d.top_consume) ? d.top_consume : []).filter(x => x && x.name); const topMax = top.reduce((m, x) => Math.max(m, num(x.value)), 0) || 1; /* 預警統計與週轉 */ const as = d.alert_stats && typeof d.alert_stats === "object" ? d.alert_stats : {}; const aTotal = num(as.total), aHandled = num(as.handled); const aRate = as.rate != null ? num(as.rate) : (aTotal ? Math.round(aHandled / aTotal * 100) : 0); const aPending = num(as.pending_returns); const turnover = d.turnover != null ? d.turnover : null; const bootAlerts = Array.isArray(boot && boot.ALERTS) ? boot.ALERTS.length : 0; const openAlerts = d.alert_stats ? Math.max(0, aTotal - aHandled) : bootAlerts; /* 報表目錄:後端 exportable 為準,補上本地說明;缺失時退回固定四份 */ const exportable = Array.isArray(d.exportable) && d.exportable.length ? d.exportable : CATALOG; const figOf = (name) => { if (name === "月度出入庫匯總表") { const a = kByKey["本期入庫"], b = kByKey["本期出庫"]; return (a && a.value != null) || (b && b.value != null) ? t("入庫 {a} 單 · 出庫 {b} 單", { a: a && a.value != null ? a.value : "—", b: b && b.value != null ? b.value : "—" }) : "—"; } if (name === "庫存儲值與週轉分析") return totalVal > 0 ? "¥" + totalVal.toFixed(1) + t("萬") + (turnover != null ? " · " + t("週轉") + " " + turnover : "") : "—"; if (name === "物資消耗排行") return top.length ? "TOP1 · " + top[0].name : "—"; if (name === "未關閉預警清單") return t("{n} 條未關閉", { n: openAlerts }); return "—"; }; const reports = exportable.map(r => { const meta = CATALOG.find(c => c.name === (r && r.name)) || {}; return { name: (r && r.name) || "—", type: (r && r.type) || meta.type || "業務", cycle: (r && r.cycle) || meta.cycle || "月報", icon: meta.icon || "doc", desc: meta.desc || "", fig: figOf(r && r.name) }; }); const folio = ( { setData(null); setTick(v => v + 1); }}>{t("刷新")} ask(t("生成本期出入庫匯總表,整理成表格給我,並導出 CSV"))}>{t("導出匯總 CSV")} ask(t("把本期經營報表的要點講給我聽:出入庫、庫存儲值、消耗排行、預警處理,各給關鍵數字和一句判斷"))}>{t("問秘書")} }/> ); if (data === null) return (<> {folio}
{t("COMPUTING")}
{t("正在從資料庫計算報表…")}
); return (<> {folio}
{kpis.map((k, i) => { const red = (k.key === "緊急搶修單") && num(k.value) > 0; return ( {k.extra ? tExtra(k.extra) : t("暫無數據")}}/> ); })}
{[["m6", "近 6 月"], ["all", "全週期"]].map(([id, label]) => ( ))}
}>
{hasTrend ? : }
0 ? t("總儲值") + " ¥" + totalVal.toFixed(1) + t("萬") : t("暫無數據")} delay={.15}> {stack.length ? (
{stack.map(x => (
{x.label} ¥{x.value.toFixed(1)}{t("萬")} {totalVal ? Math.round(x.value / totalVal * 100) : 0}%
))}
) : }
ask(t("分析本期物資消耗結構:哪些消耗最快、是否合理、要不要調整安全庫存"))}>{t("分析消耗結構")}}> {top.length ? (
{top.slice(0, 5).map((x, i) => (
{pad2(i + 1)} {x.name}
{num(x.value)}
))}
) : } 0 || aPending > 0) && ask(t("把未關閉的預警和待歸還工器具逐條列出,給出處置建議,經我確認後執行"))}>{t("逐條處置")}}>
{aRate}% {t("處理率")}
{[[t("累計預警"), aTotal, false], [t("已處理"), aHandled, false], [t("待歸還"), aPending, aPending > 0], [t("庫存週轉率"), turnover != null ? turnover : "—", false]].map(([k, v, red]) => (
{k} {v}
))}
{reports.map((r, i) => (
{t(r.name)}
{pad2(i + 1)}
{r.desc &&
{t(r.desc)}
}
{t(r.type)} {t(r.cycle)} {r.fig}
ask(t("生成「{name}」({cycle}),先用表格把要點給我,再導出 CSV", { name: t(r.name), cycle: t(r.cycle) }))}>{t("秘書生成導出")} ask(t("「{name}」這份報表,直接把本期要點和異常講給我", { name: t(r.name) }))}>{t("問要點")}
))}
{t("2.0 約定:頁面只讀,報表由秘書按最新數據生成與導出,全程留痕。")}
 ); }; window.W2.PAGES["reports"] = Page; })();