recycle-docker/tools/gen_koujian.py

import csv

# 所有评估项数据：[valueId, 评估项文本, 扣减比例]
deduction_data = [
    ["option_id", "itemText", "factor"],  # 表头
    [100039, "正常开机", 0.00],
    [100043, "无法开机", 0.40],
    [100029, "外壳完美", 0.00],
    [100034, "外壳缺失/裂缝/孔变形/翘起/刻字", 0.18],
    [100339, "全新机未拆封（质检时会进行拆封）", 0.00],
    [100341, "外壳有细微划痕", 0.05],
    [100342, "外壳有磕碰掉漆", 0.10],
    [100408, "机身有弯曲", 0.20],
    [100069, "屏幕外观完美", 0.00],
    [100335, "屏幕有细微划痕", 0.03],
    [100336, "屏幕有划伤/屏幕气泡/脱胶", 0.12],
    [100337, "屏幕有碎裂或磨损", 0.30],
    [100411, "屏幕有硬划痕（指甲划过划痕表面有停顿感）", 0.08],
    [100533, "屏幕较明显划痕", 0.08],
    [100534, "屏幕裂痕/小缺角/脱胶进灰", 0.25],
    [100085, "显示完美，无任何异常", 0.00],
    [100092, "显示异常（漏液/错乱/闪屏/屏生线/亮度坏）", 0.30],
    [100331, "显示轻微泛黄/亮点/亮斑（有其中一项）", 0.05],
    [100332, "显示有亮坏点/亮斑/色斑", 0.07],
    [100333, "显示有透图/透字", 0.15],
    [100535, "屏幕全花屏/无法显示", 0.50],
    [100329, "个人账号无法退出", 0.20],
    [100330, "个人账号可退出", 0.00],
    [100344, "机器无维修痕迹", 0.00],
    [100346, "屏幕维修（更换非原厂屏等）", 0.25],
    [100381, "电池维修（电池有更换）", 0.04],
    [100382, "维修前摄像头（前摄像头有更换）", 0.06],
    [100383, "维修后摄像头（后摄像头有更换）", 0.08],
    [100384, "主板维修/扩容", 0.40],
    [100410, "维修后壳/其他零件", 0.03],
    [100529, "更换电池/摄像头/外壳/其他配件", 0.10],
    [100530, "更换原厂屏", 0.15],
    [100370, "电池健康度<80%", 0.05],
    [100555, "展示机/资源机/官换机", 0.10],
    [100560, "已开启丢失模式", 0.60],
    [100398, "WiFi/蓝牙连接正常", 0.00],
    [100399, "WiFi/蓝牙连接异常", 0.10],
    [100402, "面容/指纹功能正常", 0.00],
    [100403, "面容/指纹功能异常", 0.15],
    [100392, "触摸正常", 0.00],
    [100394, "触摸异常（延迟/失灵）", 0.30],
    [100395, "拍摄正常", 0.00],
    [100397, "拍摄异常（抖动/模糊/不对焦/分层/颠倒）", 0.15],
    [100400, "通话正常", 0.00],
    [100401, "通话异常", 0.25],
    [100495, "转轴开合正常", 0.00],
    [100496, "转轴开合异常", 0.15]
]

# 写入CSV文件（utf-8-sig编码解决Excel中文乱码，保留2位小数）
with open("deduction_ratio.csv", "w", encoding="utf-8-sig", newline="") as f:
    writer = csv.writer(f)
    writer.writerows(deduction_data)

print("✅ CSV文件生成成功！文件名称：deduction_ratio.csv")
print("📌 特性：utf-8-sig编码（Excel打开无乱码）、含表头、扣减比例保留2位小数")