from copy import copy
from pathlib import Path

from openpyxl import load_workbook
from openpyxl.drawing.image import Image


ROOT = Path(__file__).resolve().parent
BOOK = ROOT / "output" / "哈尔滨膳质舍-场景说明.xlsx"
SCENE = ROOT / "output" / "哈尔滨膳质舍-3D场景图-真实设备校准版.png"

wb = load_workbook(BOOK)
ws = wb["场景说明"]
ws["D3"] = "C级：场地文档校准；设备图已校准"
ws["A16"] = "2. 3D主图（真实设备校准版；场地仍为方案复原）"
ws._images = []
img = Image(SCENE)
img.width = 1672
img.height = 941
ws.add_image(img, "A19")

src = wb["来源明细"]
items = [
    (
        "SH-V20标准产品实拍图",
        "/Users/jack/Library/Containers/com.tencent.WeWorkMac/Data/WeDrive/康比特/项目交付管理共享空间/⭐️标准产品/000宣传素材工具包/营养结算系统/智能互联健康体检一体机SH-V20/9ac1438317fb028e2dc6633bcd0e4108.jpg",
        "主图与清单中的SH-V20真实外观",
        "标准产品实拍；透明底提取不改变型号口径",
    ),
    (
        "CPT-BP001标准产品图",
        "/Users/jack/Library/Containers/com.tencent.WeWorkMac/Data/WeDrive/康比特/项目交付管理共享空间/⭐️标准产品/000宣传素材工具包/营养结算系统/膳识智能台/智能绑盘终端/智能绑盘终端-右侧.png",
        "主图与清单中的绑盘终端真实外观",
        "标准产品图；到货铭牌与SN待验收",
    ),
    (
        "450型膳识智能台（双秤）标准产品图",
        "/Users/jack/Library/Containers/com.tencent.WeWorkMac/Data/WeDrive/康比特/项目交付管理共享空间/⭐️标准产品/000宣传素材工具包/营养结算系统/膳识智能台/450型膳识智能台（双秤）/450型膳识智能台（双秤）-侧面-排菜.png",
        "主图中10台双秤设备真实外观",
        "合同保留全型号CPT-Nutr-DOB-GMSC450；产品图按450双秤族校准",
    ),
    (
        "后厨小票打印机标准产品详情图",
        "/Users/jack/Library/Containers/com.tencent.WeWorkMac/Data/WeDrive/康比特/项目交付管理共享空间/⭐️标准产品/000宣传素材工具包/营养结算系统/其他备选硬件/后厨小票打印机/后厨小票打印机详情.jpg",
        "主图中的XP-C58H产品外观参考",
        "标准产品详情图；到货铭牌、接口与SN待验收",
    ),
    (
        "哈尔滨TC-40EA型号资料图",
        "/Users/jack/code/010-cpt/008-zhct/zhctprompt/work/weekly-reports/2026-W37/weekly-report-visual/output/周报图文包/assets/harbin-robot.jpg",
        "主图与清单中的TC-40EA真实外观",
        "哈尔滨项目型号资料；安装现场仍待补证",
    ),
]

template_row = 2
for item in items:
    row = src.max_row + 1
    for col, value in enumerate(item, 1):
        cell = src.cell(row, col, value)
        template = src.cell(template_row, col)
        if template.has_style:
            cell._style = copy(template._style)
        cell.alignment = copy(template.alignment)
    src.row_dimensions[row].height = src.row_dimensions[template_row].height

wb.save(BOOK)