﻿from fx import *
import time
orig = 'IF(NOT(ISBLANK([要求场次])), [要求场次], IF([活动类型] = "合计" && [周期类型] != "周", [周任务汇总], 0))'
cands = {
 "X1": 'IF(ISBLANK([要求场次]), IF([活动类型] = "合计" && [周期类型] != "周", [周任务汇总], 0), [要求场次])',
 "X2": f'VALUE({orig} & "")',
 "X3": f'MAX({orig}, 0)',
 "X4": 'IF(ISBLANK([要求场次]), 0, [要求场次]) + IF(ISBLANK([要求场次]) && [活动类型] = "合计" && [周期类型] != "周", [周任务汇总], 0)',
}
fcreate("任务表", [{"type": "formula", "name": k, "expression": v} for k, v in cands.items()])
time.sleep(3)
parts = []
for k in cands: parts += [f'ISNUMBER([{k}])', f'[{k}] = 0', f'[已提报场次] >= [{k}]']
expr = ' & "|" & '.join('(' + p + ')' for p in parts)
r = lk("base", "+field-update", "--base-token", B, "--table-id", T["任务表"], "--field-id", "调试",
       "--json", payload({"type": "formula", "name": "调试", "expression": expr}), "--i-have-read-guide", "--yes")
time.sleep(4)
for r in records(B, T["任务表"], ["任务名称", "调试", "X1", "X2", "X3", "X4"]):
    if r["任务名称"] in ("W45·资阳·合计", "W49·资阳·合计", "11月·资阳·合计"): print(r)
