﻿from fx import *
def F(n, e): return {"type": "formula", "name": n, "expression": e}
common = [
 F("渠道", 'FIRST([办事处表].FILTER(CurrentValue.[办事处] = [办事处]).[渠道])'),
 F("周序号", 'FIRST([周次表].FILTER(CurrentValue.[周次] = [周次]).[周序号])'),
 F("所属月份", 'FIRST([周次表].FILTER(CurrentValue.[周次] = [周次]).[所属月份])'),
 F("周状态", 'FIRST([周次表].FILTER(CurrentValue.[周次] = [周次]).[周状态])'),
 F("活动日期", 'MONTH([开始日期]) & "." & DAY([开始日期]) & IF(TEXT([结束日期], "YYYY-MM-DD") = TEXT([开始日期], "YYYY-MM-DD"), "", "-" & MONTH([结束日期]) & "." & DAY([结束日期]))'),
 F("判定时间", 'IF(ISBLANK([提交时间修正]), [创建时间], [提交时间修正])'),
]
done = s.setdefault("fx_done", [])
if "活动表" not in done:
    fcreate("活动表", common + [
     F("提报截止", 'FIRST([周次表].FILTER(CurrentValue.[周次] = [周次]).[提报截止])'),
     F("提报时效", 'IF([数据来源] = "历史导入", "不判定", IF([判定时间] > [提报截止], "逾期", "按时"))'),
     F("反馈次数", 'COUNTA([反馈记录])'),
     F("反馈状态", 'IF([反馈次数] > 0, "已反馈", IF([开始日期] <= TODAY(), "待反馈", "未开始"))'),
     F("反馈结果", '[反馈记录].[是否如期举办].LISTCOMBINE().ARRAYJOIN("、")'),
    ]); done.append("活动表"); save_state(s)
if "反馈表" not in done:
    fcreate("反馈表", common + [
     F("反馈截止", 'FIRST([周次表].FILTER(CurrentValue.[周次] = [周次]).[反馈截止])'),
     F("反馈时效", 'IF([数据来源] = "历史导入", "不判定", IF([判定时间] > [反馈截止], "逾期", "按时"))'),
     F("达标提醒", 'IFS([是否如期举办] = "是" && [活动类型] = "璀璨新风品鉴会" && [邀约户数] < 15, "邀约不足15户", [是否如期举办] = "是" && [活动类型] = "培训订货会" && [参会人数] < 15, "参会不足15人", TRUE(), "")'),
     F("系统参考状态", 'IF([是否如期举办] = "是" && ISBLANK([系统销额（万）]), "待回填", "")'),
    ]); done.append("反馈表"); save_state(s)
