#!/usr/bin/env python3 """Build the self-contained local HTML gallery from the reviewed CSV bases.""" from __future__ import annotations import csv import json from collections import defaultdict from pathlib import Path ROOT = Path(__file__).resolve().parents[1] DATA = ROOT / "data" OUTPUT = ROOT / "public" / "index.html" def read_csv(name: str) -> list[dict[str, str]]: with (DATA / name).open(encoding="utf-8-sig", newline="") as handle: return list(csv.DictReader(handle)) def unique(values: list[str]) -> list[str]: seen: set[str] = set() result: list[str] = [] for value in values: value = value.strip() if value and value not in seen: seen.add(value) result.append(value) return result def build_projects() -> list[dict[str, object]]: selections = read_csv("project-image-selection.csv") bases = {row["项目ID"]: row for row in read_csv("project-case-base.csv")} people: dict[str, list[dict[str, str]]] = defaultdict(list) for row in read_csv("people-detail.csv"): people[row["项目ID"]].append(row) software: dict[str, list[dict[str, str]]] = defaultdict(list) for row in read_csv("software-detail.csv"): software[row["项目ID"]].append(row) hardware: dict[str, list[dict[str, str]]] = defaultdict(list) for row in read_csv("hardware-detail.csv"): hardware[row["项目ID"]].append(row) projects: list[dict[str, object]] = [] for selection in selections: project_id = selection["项目ID"] base = bases[project_id] image = selection["唯一主图"] image_path = ROOT / image if not image_path.is_file(): raise FileNotFoundError(f"Missing selected image: {image_path}") actual_software = unique([ row["软件模块"] for row in software[project_id] if row["事实/建议"] != "场景建议" ]) suggested_software = unique([ row["软件模块"] for row in software[project_id] if row["事实/建议"] == "场景建议" ]) actual_hardware: list[dict[str, str]] = [] for row in hardware[project_id]: if row["事实/建议"] == "场景建议": continue quantity = row["数量原文"].strip() unit = row["单位"].strip() actual_hardware.append({ "name": row["硬件名称"].strip(), "model": (row["标准型号"] or row["项目写法/型号"]).strip(), "quantity": f"{quantity}{unit}" if quantity else "数量待补证", "grade": row["证据等级"].strip(), "mapping": row["映射状态"].strip(), }) metrics: list[dict[str, str]] = [] metric_fields = [ ("注册账户", "已观察注册账户", "个"), ("日日活", "已观察日日活", "人"), ("30日活跃", "已观察30日活跃", "人"), ("累计订单", "累计有效订单", "笔"), ("近30日订单", "近30日订单", "笔"), ] for label, field, unit in metric_fields: value = base[field].strip() if value: metrics.append({"label": label, "value": value, "unit": unit}) correction = selection["纠偏说明"].strip() if project_id == "P028": correction = ( "照片错配已纠正：原图误用了P005城市副中心照片，已隔离；" "本卡仅使用证据占位图，禁止引用隔离图。" ) if "quarantine" in image or "misattributed" in image: raise ValueError("P028 must never select a quarantined or misattributed image") projects.append({ "id": project_id, "name": selection["项目名称"], "shortName": base["简称"], "scene": selection["场景类型"], "sceneSummary": base["一句话场景"], "grade": selection["总体证据等级"], "oneToOne": selection["是否可1比1"], "image": "../" + image, "imageStatus": selection["主图状态"], "people": [item.strip() for item in base["服务人群"].split("、") if item.strip()], "metrics": metrics, "problems": base["主要问题"], "actualSoftware": actual_software, "suggestedSoftware": suggested_software, "actualSoftwareFallback": base["实际软件观察"], "hardwareCountBasis": selection["数量证据"] or base["设备观察口径"], "hardware": actual_hardware, "frontFlow": base["前厅主流程"], "kitchenFlow": base["后厨主流程"], "blocker": selection["正式出图阻断"], "boundary": base["验证能力/证据边界"], "correction": correction, "sourceTable": selection["源证据表"], }) if len(projects) != 28: raise ValueError(f"Expected 28 projects, found {len(projects)}") images = [project["image"] for project in projects] if len(images) != len(set(images)): raise ValueError("Every project must have a unique selected image") return projects HTML_HEAD = r''' 智慧食堂 · 28项目场景证据图册
Smart Canteen Case Atlas · 2026

28 个项目，一图理解场景，一表追溯证据

面向销售、渠道与交付团队的智慧食堂案例导航。先看人、场景与主流程，再看已验证的软件、硬件数量口径和仍未闭环的证据。

图负责理解，表负责证据场景图不替代合同 BOM、出库记录、设备 SN、验收点位和现场照片；A/B/C/D 表示本图的还原证据等级，不是项目商业价值评分。
''' def main() -> None: projects = build_projects() payload = json.dumps(projects, ensure_ascii=False, separators=(",", ":")).replace("