﻿from fx import *
import time
L = 'MAX([周次表].FILTER(CurrentValue.[周次] = [周次]).[提报截止])'
defs = {
 "D1": 'WEEKDAY(DATE(2026,11,15),2) & "|" & WEEKDAY(DATE(2026,11,9),2) & "|" & WEEKDAY(DATE(2026,11,14),2) & "|" & WEEKDAY(TODAY(),2)',
 "D2": f'DATE(1899,12,30) + {L}',
 "D3": f'TODATE(TEXT(DATE(1899,12,30) + {L}, "YYYY-MM-DD HH:mm"))',
 "D4": f'FIRST([周次表].FILTER(CurrentValue.[周次] = [周次]).[提报截止])',
 "D5": 'IF(ISBLANK([提交时间修正]), [创建时间], [提交时间修正])',
 "D6": 'DATE(1899,12,30) + IF(ISBLANK([提交时间修正]), [创建时间] - DATE(1899,12,30), [提交时间修正] - DATE(1899,12,30))',
}
fcreate("活动表", [{"type": "formula", "name": k, "expression": v} for k, v in defs.items()])
time.sleep(4)
args = ["base", "+record-list", "--base-token", B, "--table-id", T["活动表"], "--limit", "2"]
for k in ["活动名称"] + list(defs): args += ["--field-id", k]
m = lk(*args)
print(json.dumps(m.get("columns"), ensure_ascii=False, indent=0)[:2500])
print(open(m["record_file"], encoding="utf-8").read()[:1500])
os.remove(m["record_file"]); os.remove(m["manifest_file"])
