﻿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])
upd("任务表", "应完成场次", 'MAX(IF(NOT(ISBLANK([要求场次])), [要求场次], IF([活动类型] = "合计" && [周期类型] != "周", [周任务汇总], 0)), 0)')
upd("任务表", "提报缺口", 'MAX([应完成场次] - [已提报场次], 0)')
upd("任务表", "完成缺口", 'MAX([应完成场次] - [完成场次], 0)')
upd("任务表", "提报达成率", 'MAX(IF([应完成场次] = 0, 0, [已提报场次] / [应完成场次]), 0)')
upd("任务表", "完成达成率", 'MAX(IF([应完成场次] = 0, 0, [完成场次] / [应完成场次]), 0)')
for f in ["X1", "X2", "X3", "X4"]:
    lk("base", "+field-delete", "--base-token", B, "--table-id", T["任务表"], "--field-id", f, "--yes")
parts = ['ISNUMBER([应完成场次])', 'ISNUMBER([提报缺口])', 'ISNUMBER([提报达成率])', 'ISNUMBER([销额目标合计（万）])', 'ISNUMBER([周任务汇总])', 'ISNUMBER([待反馈场次])']
r = lk("base", "+field-update", "--base-token", B, "--table-id", T["任务表"], "--field-id", "调试",
       "--json", payload({"type": "formula", "name": "调试", "expression": ' & "|" & '.join('(' + p + ')' for p in parts)}), "--i-have-read-guide", "--yes")
time.sleep(5)
for r in records(B, T["任务表"], ["任务名称", "调试", "应完成场次", "提报缺口", "提报状态", "完成状态", "提报缺口文本"]):
    if r["任务名称"] in ("W45·资阳·合计", "W49·资阳·合计", "11月·资阳·合计", "W47·苏宁·合计", "W47·资阳·合计"): print(r)
for r in records(B, T["周次表"], ["周次", "周状态", "提报缺口名单", "待反馈名单"])[:4]: print(r)
