﻿from lk import *
import time
s = load_state(); B = s["base_token"]; T = s["tables"]
for k in ["D1", "D2", "D3", "D4", "D5", "D6"]:
    lk("base", "+field-delete", "--base-token", B, "--table-id", T["活动表"], "--field-id", k, "--yes")
base = {"办事处": ["资阳"], "活动类型": ["门店主推活动"], "门店全称": "测试门店", "商家全称": "测试商家", "填报人": "测试",
        "销额目标（万）": 1, "销量目标（套）": 2, "新风三柜三挂目标（套）": 1, "数据来源": ["页面提交"]}
acts = [dict(base, 活动名称="【测试】W46补报-应逾期", 周次=["W46"], 开始日期="2026-11-13", 结束日期="2026-11-14"),
        dict(base, 活动名称="【测试】W48提报-应按时", 周次=["W48"], 开始日期="2026-11-24", 结束日期="2026-11-24"),
        dict(base, 活动名称="【测试】W46修正时间-应按时", 周次=["W46"], 开始日期="2026-11-10", 结束日期="2026-11-10", 提交时间修正="2026-11-07 10:00")]
r = lk("base", "+record-batch-create", "--base-token", B, "--table-id", T["活动表"], "--json", payload({"create_records": acts}))
aids = r["data"]["record_id_list"]
fbase = {"办事处": ["资阳"], "周次": ["W46"], "填报人": "测试", "数据来源": ["页面提交"], "是否如期举办": ["是"], "门店全称": "测试门店", "商家全称": "测试商家",
         "销额实际（万）": 1.5, "销量实际（套）": 3, "新风三柜三挂完成（套）": 1, "到场户数": 12}
fbs = [dict(fbase, 反馈类型=["已提报活动"], 关联活动=[{"id": aids[0]}], 活动名称=acts[0]["活动名称"], 活动类型=["门店主推活动"], 开始日期="2026-11-13", 结束日期="2026-11-14"),
       dict(fbase, 反馈类型=["临时加场"], 活动名称="【测试】临时加场品鉴会", 活动类型=["璀璨新风品鉴会"], 开始日期="2026-11-12", 结束日期="2026-11-12",
            邀约户数=10, 交定金户数=2, 意向户数=5),
       dict(fbase, 反馈类型=["已提报活动"], 关联活动=[{"id": aids[2]}], 活动名称=acts[2]["活动名称"], 活动类型=["门店主推活动"], 开始日期="2026-11-10", 结束日期="2026-11-10",
            是否如期举办=["否"], 未举办原因="测试未举办")]
for k in ["销额实际（万）", "销量实际（套）", "新风三柜三挂完成（套）", "到场户数"]: fbs[2].pop(k)
r = lk("base", "+record-batch-create", "--base-token", B, "--table-id", T["反馈表"], "--json", payload({"create_records": fbs}))
fids = r["data"]["record_id_list"]
s["test_records"] = {"活动表": aids, "反馈表": fids}; save_state(s)
time.sleep(6)
for x in records(B, T["活动表"], ["活动名称", "判定时间", "提报截止", "提报时效", "反馈状态", "反馈结果"]):
    if x["活动名称"].startswith("【测试】"): print("ACT", x["活动名称"], x["提报时效"], x["反馈状态"], x.get("反馈结果"))
for x in records(B, T["反馈表"], ["活动名称", "反馈时效", "达标提醒", "系统参考状态"]):
    if x["活动名称"].startswith("【测试】"): print("FB ", x["活动名称"], x["反馈时效"], x.get("达标提醒"), x.get("系统参考状态"))
for x in records(B, T["任务表"], ["任务名称", "已提报场次", "逾期提报场次", "完成场次", "临时加场场次", "未举办场次", "已反馈场次", "待反馈场次", "提报状态"]):
    if x["任务名称"] in ("W46·资阳·合计", "W48·资阳·合计", "11月·资阳·合计"): print("TASK", {k: v for k, v in x.items() if k != "record_id"})
