﻿from fx import *
import time
fid = None
r = lk("base", "+field-get", "--base-token", B, "--table-id", T["任务表"], "--field-id", "调试")
fid = r["data"]["field"]["id"]
parts = [
 'ISNUMBER(VALUE(FIRST([周次表].FILTER(CurrentValue.[周次] = [开始周次]).[周序号]) & ""))',
 'ISNUMBER(VALUE(SUBSTITUTE([开始周次] & "", "W", "")))',
 'ISNUMBER(SUM([应完成场次]))',
 'ISNUMBER(IF(NOT(ISBLANK([要求场次])), [要求场次] + 0, 0))',
 'ISNUMBER(IF(ISBLANK([要求场次]), 0, [要求场次]))',
 '(TODAY() > DATE(2026, 11, 2) + (VALUE(SUBSTITUTE([结束周次] & "", "W", "")) - 45) * 7 + 6)',
 'ISNUMBER(FIRST(LIST(1,2)))',
 'ISNUMBER(MAX([周次表].FILTER(CurrentValue.[周次] = [开始周次]).[周序号]))',
 '(TODAY() > MAX([周次表].FILTER(CurrentValue.[周次] = [结束周次]).[周日]))',
 '([开始周次] = "W45")',
 'FIRST([办事处表].FILTER(CurrentValue.[办事处] = [办事处]).[渠道]) = "自有渠道"',
]
expr = ' & "|" & '.join('(' + p + ')' for p in parts)
r = lk("base", "+field-update", "--base-token", B, "--table-id", T["任务表"], "--field-id", fid,
       "--json", payload({"type": "formula", "name": "调试", "expression": expr}), "--i-have-read-guide", "--yes")
time.sleep(4)
for r in records(B, T["任务表"], ["任务名称", "调试"]):
    if r["任务名称"] in ("W45·资阳·合计", "W49·资阳·合计", "11月·资阳·合计"): print(r)

