#!/usr/bin/env python3 """Generate the W20 smart-canteen weekly report HTML assets. The source of truth is the Markdown report plus the extracted Excel records. This script only renders user-facing HTML wrappers and small summary visuals. """ from __future__ import annotations import csv import html import subprocess from collections import Counter from pathlib import Path ROOT = Path(__file__).resolve().parents[3] OUT_DIR = ROOT / "work/weekly-reports/outputs/2026-W20/smart-canteen-project" REPORT_MD = OUT_DIR / "smart-canteen-weekly-report.md" REPORT_HTML = OUT_DIR / "smart-canteen-weekly-report.html" BRIEF_MD = OUT_DIR / "smart-canteen-weekly-leadership-brief.md" BRIEF_HTML = OUT_DIR / "smart-canteen-weekly-leadership-brief.html" EXCEL_EXTRACT = OUT_DIR / "excel-current-week-extract.csv" TEAM_FOCUS = [ ("李潇", "项目需求与售前支持", "金斯瑞、江西206、首通智诚、江苏国信、苏州福耀等项目需求确认、客户问题回复、报价和产品材料推进。"), ("孙海琴", "监管大屏与页面体验", "教委食安监管大屏、总览大屏、进销存大屏交互动效、Vue 样式转换和页面整合。"), ("王朔", "产品设计与市场支撑", "网信办、三全、广东反兴奋剂等项目支持，教委端大屏产品设计和 AI 原型链路推进。"), ("兰海军", "标准产品与交付支撑", "售前轻采集系统、金斯瑞标准产品优化、山西焦煤数据处理和产业园食安系统问题处理。"), ("尹旭亮", "设备链路与 AI 识别", "金斯瑞 AI 菜品识别、江西206 消费机/称重台、460 设备会话与重量轨迹能力推进。"), ("赖清涛", "接口开发与上线保障", "金斯瑞 OA/补贴接口、江西206 售卖柜开发上线、取餐柜方案和 Codex 协作开发。"), ("孙倩倩", "小程序、食安与联调", "首通智诚小程序加固、callScreen 叫号联调、食安设备和大屏问题排查、AI 营养师问答。"), ("郭东伟", "标准小程序与终端能力", "标准小程序、AI 运动营养师、乐心手环、银行对接流程、Android 460 和终端编程智能体验证。"), ] PROJECTS = [ ("金斯瑞", "取餐柜、OA 接口、补贴、麻辣烫小票、AI 菜品识别持续推进"), ("江西206", "售卖柜、消费机、称重台、离线消费和升级部署联动优化"), ("首通智诚", "缴费需求、原型页面、小程序加固和银行对接流程沉淀"), ("江苏国信", "合同需求梳理、个性化需求、报价和部署准备"), ("苏州福耀", "食堂场景个性化需求确认，进入售前方案和交付准备"), ("三全 / 网信办", "投标方案、等保范围、进销存培训和供应商协同继续推进"), ] def render_markdown(markdown_text: str) -> str: result = subprocess.run( ["pandoc", "-f", "gfm", "-t", "html5"], input=markdown_text, text=True, capture_output=True, check=True, ) return result.stdout def read_excel_counts() -> tuple[int, int, list[tuple[str, int]]]: people: Counter[str] = Counter() rows = 0 with EXCEL_EXTRACT.open("r", encoding="utf-8-sig", newline="") as f: reader = csv.DictReader(f) for row in reader: rows += 1 people[row["person"]] += 1 return len(people), rows, people.most_common() def team_cards() -> str: cards = [] for name, role, detail in TEAM_FOCUS: cards.append( f"""
{html.escape(name)} {html.escape(role)}

{html.escape(detail)}

""" ) return "\n".join(cards) def project_cards() -> str: cards = [] for project, detail in PROJECTS: cards.append( f"""
{html.escape(project)}

{html.escape(detail)}

""" ) return "\n".join(cards) def mini_bars(counts: list[tuple[str, int]]) -> str: max_count = max((count for _, count in counts), default=1) rows = [] for name, count in counts: width = 18 + int(82 * count / max_count) rows.append( f"""
{html.escape(name)}
{count}
""" ) return "\n".join(rows) def page_template(title: str, subtitle: str, body: str, *, is_brief: bool = False) -> str: people_count, row_count, people_counts = read_excel_counts() brief_class = " brief-mode" if is_brief else "" return f""" {html.escape(title)}
2026-W20 · 5月11日-5月17日

{html.escape(title)}

{html.escape(subtitle)}

项目交付 产品标准化 监管大屏 设备联调 AI 提效
智慧食堂项目周推进 当前项目需要 需求、上线、联调、客户问题 产品技术引领 标准产品、大屏、设备、AI 形成可复制的产品和交付能力
{people_count}位同事周输入已归纳，覆盖产品、研发、设计、设备和交付支撑。
{row_count}条 Excel 当前周记录进入本版报告，不再只依据项目控制记录。
10+个项目被纳入本周进展，包括金斯瑞、江西206、国信、苏州福耀等。
4类能力同步沉淀：标准产品、大屏方案、硬件设备链路、AI 工作流。

重点项目推进图

这部分按项目和客户场景归纳，便于经营层看到交付进度，也便于产品团队识别哪些能力可沉淀为标准产品。

{project_cards()}

团队贡献地图

按 Excel 周报归纳每位同事本周贡献，让报告体现跨项目、跨角色、跨部门协同。

{team_cards()}
当前周记录分布 {mini_bars(people_counts)}
{body}
""" def main() -> None: report_body = render_markdown(REPORT_MD.read_text(encoding="utf-8")) REPORT_HTML.write_text( page_template( "数字技术中心 / 交付实施部智慧食堂项目周报", "基于团队 Excel 周报归纳本周项目交付、产品建设、技术攻关和 AI 提效进展，突出满足当前项目需要与做好技术产品引领两条主线。", report_body, ), encoding="utf-8", ) brief_body = render_markdown(BRIEF_MD.read_text(encoding="utf-8")) BRIEF_HTML.write_text( page_template( "智慧食堂项目周报一页版", "面向经营层快速阅读：说明本周推进到哪里、形成了哪些可复用能力、下周需要抓住哪些闭环。", brief_body, is_brief=True, ), encoding="utf-8", ) if __name__ == "__main__": main()