﻿from fx import *
import time
parts = ['ISNUMBER([应完成场次])', '[应完成场次] = 0', '[应完成场次] + 0 = 0', 'VALUE([应完成场次] & "") = 0',
         'ISNUMBER([开始周序])', '[开始周序] >= 45', 'ISNUMBER([已提报场次])', '[已提报场次] >= [应完成场次]', 'ISNUMBER([提报缺口])', '[提报缺口] > 0']
expr = ' & "|" & '.join('(' + p + ')' for p in parts)
fcreate("任务表", [{"type": "formula", "name": "调试", "expression": expr}])
time.sleep(4)
for r in records(B, T["任务表"], ["任务名称", "调试"]):
    if r["任务名称"] in ("W45·资阳·合计", "W49·资阳·合计"): print(r)
