﻿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])
W = lambda col, key="[周次]": f'MAX([周次表].FILTER(CurrentValue.[周次] = {key}).[{col}])'
for t in ["活动表", "反馈表"]:
    upd(t, "周序号", W("周序号"))
upd("活动表", "提报截止", W("提报截止"))
upd("反馈表", "反馈截止", W("反馈截止"))
upd("任务表", "开始周序", W("周序号", "[开始周次]"))
upd("任务表", "结束周序", W("周序号", "[结束周次]"))
upd("任务表", "结束日", W("周日", "[结束周次]"))
upd("任务表", "办事处排序", 'MAX([办事处表].FILTER(CurrentValue.[办事处] = [办事处]).[排序])')
upd("任务表", "应完成场次", 'IF(NOT(ISBLANK([要求场次])), [要求场次] + 0, IF([活动类型] = "合计" && [周期类型] != "周", [周任务汇总] + 0, 0))')
r = lk("base", "+field-delete", "--base-token", B, "--table-id", T["任务表"], "--field-id", "调试", "--yes", check=False)
print("delete 调试", r.get("ok"))
time.sleep(5)
for r in records(B, T["任务表"], ["任务名称", "开始周序", "应完成场次", "提报状态", "完成状态", "结束日", "办事处排序"]):
    if r["任务名称"] in ("W45·资阳·合计", "W49·资阳·合计", "11月·资阳·合计", "W47·苏宁·合计", "11月·京东五星·璀璨新风品鉴会"): print(r)
for r in records(B, T["周次表"], ["周次", "周状态", "提报缺口名单", "待反馈名单"])[:3]: print(r)
