﻿from lk import *
import datetime as dt
s = load_state(); B = s["base_token"]; T = s["tables"]
plan = json.load(open("import_plan.json", encoding="utf-8"))
today = dt.date(2026, 11, 14)
acts = []
for p in plan:
    a, actual = p[2], p[3]
    acts.append({"off": a["办事处"][0], "wk": int(a["周次"][0][1:]), "type": a["活动类型"][0], "start": dt.date.fromisoformat(a["开始日期"]),
                 "fb": bool(actual), "t1": a.get("销额目标（万）", 0), "t2": a.get("销量目标（套）", 0), "t3": a.get("新风三柜三挂目标（套）", 0),
                 "a1": actual.get("销额实际（万）", 0), "a2": actual.get("销量实际（套）", 0), "a3": actual.get("新风三柜三挂完成（套）", 0)})
F = ["任务名称", "办事处", "活动类型", "开始周序", "结束周序", "应完成场次", "已提报场次", "已反馈场次", "待反馈场次", "完成场次", "临时加场场次",
     "未举办场次", "逾期提报场次", "逾期反馈场次", "提报缺口", "提报状态", "完成状态", "销额目标合计（万）", "销量目标合计（套）",
     "三柜三挂目标合计（套）", "销额实际合计（万）", "销量实际合计（套）", "三柜三挂完成合计（套）", "提报达成率", "完成达成率"]
rows = records(B, T["任务表"], F)
bad = 0; checked = 0
def f(x):
    try: return float(x)
    except: return 0.0
for r in rows:
    off = r["办事处"][0]; typ = r["活动类型"][0]; w1 = int(f(r["开始周序"])); w2 = int(f(r["结束周序"]))
    m = [a for a in acts if a["off"] == off and (typ == "合计" or a["type"] == typ) and w1 <= a["wk"] <= w2]
    exp = {"已提报场次": len(m), "已反馈场次": sum(a["fb"] for a in m), "待反馈场次": sum((not a["fb"]) and a["start"] <= today for a in m),
           "完成场次": sum(a["fb"] for a in m), "临时加场场次": 0, "未举办场次": 0, "逾期提报场次": 0, "逾期反馈场次": 0,
           "销额目标合计（万）": sum(a["t1"] for a in m), "销量目标合计（套）": sum(a["t2"] for a in m), "三柜三挂目标合计（套）": sum(a["t3"] for a in m),
           "销额实际合计（万）": sum(a["a1"] for a in m), "销量实际合计（套）": sum(a["a2"] for a in m), "三柜三挂完成合计（套）": sum(a["a3"] for a in m)}
    req = f(r["应完成场次"])
    exp["提报缺口"] = max(req - exp["已提报场次"], 0)
    exp["提报达成率"] = 0 if req == 0 else exp["已提报场次"] / req
    exp["完成达成率"] = 0 if req == 0 else exp["完成场次"] / req
    for k, v in exp.items():
        checked += 1
        if abs(f(r.get(k)) - v) > 1e-6:
            bad += 1
            if bad <= 15: print("MISMATCH", r["任务名称"], k, "base=", r.get(k), "local=", v)
print("task rows", len(rows), "values checked", checked, "mismatches", bad)
want = {"W45·资阳·合计", "W45·眉山·合计", "W45·周边睢航·合计", "11月·仁雅·合计", "11-12月累计·前置·合计", "W46·前置·合计"}
for r in rows:
    if r["任务名称"] in want:
        print(r["任务名称"], "应", r["应完成场次"], "提", r["已提报场次"], "完", r["完成场次"], "待", r["待反馈场次"], r["提报状态"], r["完成状态"],
              "销额", r["销额目标合计（万）"], "/", r["销额实际合计（万）"], "达成", r["提报达成率"], r["完成达成率"])
for r in records(B, T["周次表"], ["周次", "待反馈名单", "提报缺口名单"])[:2]: print(r["周次"], "待反馈:", r.get("待反馈名单"))
