﻿from fx import *
def F(n, e): return {"type": "formula", "name": n, "expression": e}
done = s.setdefault("fx_done", [])
fid = s["fields"]["任务表"]["任务名称"]
if "任务名称" not in done:
    r = lk("base", "+field-update", "--base-token", B, "--table-id", T["任务表"], "--field-id", fid,
           "--json", payload(F("任务名称", '[周期名称] & "·" & [办事处] & "·" & [活动类型]')), "--i-have-read-guide", "--yes", check=False)
    print("primary update:", r.get("ok"), json.dumps(r.get("error", ""), ensure_ascii=False)[:800])
    if r.get("ok"): done.append("任务名称"); save_state(s)
M = 'CurrentValue.[办事处] = [办事处] && ([活动类型] = "合计" || CurrentValue.[活动类型] = [活动类型]) && CurrentValue.[周序号] >= [开始周序] && CurrentValue.[周序号] <= [结束周序]'
A = lambda extra="": f'[活动表].COUNTIF({M}{extra})'
Fb = lambda extra="": f'[反馈表].COUNTIF({M}{extra})'
SA = lambda col: f'[活动表].FILTER({M}).[{col}].LISTCOMBINE().SUM()'
SF = lambda col: f'[反馈表].FILTER({M}).[{col}].LISTCOMBINE().SUM()'
groups = [
 [F("渠道", 'FIRST([办事处表].FILTER(CurrentValue.[办事处] = [办事处]).[渠道])'),
  F("办事处排序", 'FIRST([办事处表].FILTER(CurrentValue.[办事处] = [办事处]).[排序])'),
  F("开始周序", 'FIRST([周次表].FILTER(CurrentValue.[周次] = [开始周次]).[周序号])'),
  F("结束周序", 'FIRST([周次表].FILTER(CurrentValue.[周次] = [结束周次]).[周序号])'),
  F("结束日", 'FIRST([周次表].FILTER(CurrentValue.[周次] = [结束周次]).[周日])'),
  F("周状态", 'IF([周期类型] = "周", FIRST([周次表].FILTER(CurrentValue.[周次] = [开始周次]).[周状态]), "")')],
 [F("周任务汇总", '[任务表].FILTER(CurrentValue.[办事处] = [办事处] && CurrentValue.[活动类型] = "合计" && CurrentValue.[周期类型] = "周" && CurrentValue.[开始周序] >= [开始周序] && CurrentValue.[开始周序] <= [结束周序]).[要求场次].LISTCOMBINE().SUM()'),
  F("应完成场次", 'IF(NOT(ISBLANK([要求场次])), [要求场次], IF([活动类型] = "合计" && [周期类型] != "周", [周任务汇总], 0))')],
 [F("已提报场次", A()),
  F("按时提报场次", A(' && CurrentValue.[提报时效] != "逾期"')),
  F("逾期提报场次", A(' && CurrentValue.[提报时效] = "逾期"')),
  F("已反馈场次", A(' && CurrentValue.[反馈状态] = "已反馈"')),
  F("待反馈场次", A(' && CurrentValue.[反馈状态] = "待反馈"')),
  F("完成场次", Fb(' && CurrentValue.[是否如期举办] = "是"')),
  F("临时加场场次", Fb(' && CurrentValue.[反馈类型] = "临时加场"')),
  F("未举办场次", Fb(' && CurrentValue.[是否如期举办] = "否"')),
  F("逾期反馈场次", Fb(' && CurrentValue.[反馈时效] = "逾期"'))],
 [F("提报缺口", 'IF([应完成场次] = 0, 0, MAX([应完成场次] - [已提报场次], 0))'),
  F("完成缺口", 'IF([应完成场次] = 0, 0, MAX([应完成场次] - [完成场次], 0))'),
  F("提报达成率", 'IF([应完成场次] = 0, 0, [已提报场次] / [应完成场次])'),
  F("完成达成率", 'IF([应完成场次] = 0, 0, [完成场次] / [应完成场次])'),
  F("提报状态", 'IF([应完成场次] = 0, "无任务", IF([已提报场次] >= [应完成场次], "已足量", "缺" & [提报缺口] & "场"))'),
  F("完成状态", 'IF([应完成场次] = 0, "无任务", IF([完成场次] >= [应完成场次], "已达成", IF(TODAY() > [结束日], "未达成", "进行中")))')],
 [F("销额目标合计（万）", SA("销额目标（万）")), F("销量目标合计（套）", SA("销量目标（套）")),
  F("三柜三挂目标合计（套）", SA("新风三柜三挂目标（套）")),
  F("销额实际合计（万）", SF("销额实际（万）")), F("销量实际合计（套）", SF("销量实际（套）")),
  F("三柜三挂完成合计（套）", SF("新风三柜三挂完成（套）")), F("到场户数合计", SF("到场户数")),
  F("系统销额合计（万）", SF("系统销额（万）")), F("系统销量合计（套）", SF("系统销量（套）")),
  F("系统三柜三挂合计（套）", SF("系统三柜三挂（套）"))],
 [F("提报缺口文本", 'IF([提报缺口] > 0, [办事处] & "缺" & [提报缺口] & "场", "")'),
  F("待反馈文本", 'IF([待反馈场次] > 0, [办事处] & [待反馈场次] & "场", "")')],
]
for i, g in enumerate(groups):
    key = f"任务表-{i}"
    if key in done: continue
    fcreate("任务表", g); done.append(key); save_state(s)
