﻿from fx import *
import time
base = 'CurrentValue.[周期类型] = "周" && CurrentValue.[活动类型] = "合计" && CurrentValue.[开始周次] = [周次]'
for name, cond, col in [("提报缺口名单", "CurrentValue.[提报缺口] > 0", "提报缺口文本"), ("待反馈名单", "CurrentValue.[待反馈场次] > 0", "待反馈文本")]:
    expr = f'[任务表].FILTER({base} && {cond}).SORTBY([任务表].[办事处排序]).[{col}].ARRAYJOIN("、")'
    r = lk("base", "+field-update", "--base-token", B, "--table-id", T["周次表"], "--field-id", name,
           "--json", payload({"type": "formula", "name": name, "expression": expr}), "--i-have-read-guide", "--yes", check=False)
    print(name, r.get("ok"), json.dumps(r.get("error", ""), ensure_ascii=False)[:400])
lk("base", "+field-delete", "--base-token", B, "--table-id", T["任务表"], "--field-id", "调试", "--yes")
time.sleep(4)
for r in records(B, T["周次表"], ["周次", "提报缺口名单"])[2:3]: print(r)
