﻿from lk import *
s = load_state(); B = s["base_token"]; T = s["tables"]
plan = json.load(open("import_plan.json", encoding="utf-8"))
assert all(p[0] == "OK" for p in plan)
if not s.get("imported"):
    acts = [p[2] for p in plan]
    r = lk("base", "+record-batch-create", "--base-token", B, "--table-id", T["活动表"], "--json", payload({"create_records": acts}))
    ids = r["data"].get("record_id_list")
    assert ids and len(ids) == len(acts), r
    fbs = []
    for p, rid in zip(plan, ids):
        a, actual, sr = p[2], p[3], p[4]
        if not actual: continue
        fb = {"反馈类型": ["已提报活动"], "关联活动": [{"id": rid}], "是否如期举办": ["是"], "数据来源": ["历史导入"]}
        for k in ["办事处", "周次", "活动名称", "活动类型", "开始日期", "结束日期", "门店全称", "商家全称", "填报人"]:
            if k in a: fb[k] = a[k]
        fb.update(actual)
        if sr and sr[0] != "UNPARSED":
            for v, k in zip(sr, ["系统销额（万）", "系统销量（套）", "系统三柜三挂（套）"]):
                if v is not None: fb[k] = v
        fbs.append(fb)
    r2 = lk("base", "+record-batch-create", "--base-token", B, "--table-id", T["反馈表"], "--json", payload({"create_records": fbs}))
    fids = r2["data"].get("record_id_list")
    s["imported"] = {"活动表": ids, "反馈表": fids}; save_state(s)
    print("activities", len(ids), "feedback", len(fids))
