﻿from fx import *
import time
def upd(table, name, expr):
    r = lk("base", "+field-update", "--base-token", B, "--table-id", T[table], "--field-id", name,
           "--json", payload({"type": "formula", "name": name, "expression": expr}), "--i-have-read-guide", "--yes", check=False)
    print(table, name, "ok" if r.get("ok") else json.dumps(r.get("error"), ensure_ascii=False)[:500])
for k in ["C1", "C2", "C3", "C4", "C5", "C6", "C7", "C8"]:
    lk("base", "+field-delete", "--base-token", B, "--table-id", T["活动表"], "--field-id", k, "--yes")
upd("活动表", "提报时效", 'IF([数据来源] = "历史导入", "不判定", IF(MAX([判定时间]) > MAX([提报截止]), "逾期", "按时"))')
upd("反馈表", "反馈时效", 'IF([数据来源] = "历史导入", "不判定", IF(MAX([判定时间]) > MAX([反馈截止]), "逾期", "按时"))')
time.sleep(6)
for x in records(B, T["活动表"], ["活动名称", "提报时效"]):
    if x["活动名称"].startswith("【测试】") or x["活动名称"] == "资阳飞龙工厂直销节": print("ACT", x["活动名称"], x["提报时效"])
for x in records(B, T["任务表"], ["任务名称", "已提报场次", "按时提报场次", "逾期提报场次"]):
    if x["任务名称"] in ("W46·资阳·合计", "W48·资阳·合计"): print("TASK", {k: v for k, v in x.items() if k != "record_id"})
