# -*- coding: utf-8 -*-
"""南部大区看板｜管报值周度核对（每周五）——只看【当月】

管报每周五回刷当天/当月数据。本脚本只监控**当月**：
  · 大区当月毛利额（管报锚定口径，取自 daqu_parsed.award.achieve_gp）
  · 12 城当月毛利额、大区 7 项成本（电费/租金/电柜折旧/电池折旧/全职人力/安装/营销）

关键设计：用「同日期口径」拆开两类变化，避免把"又过了 7 天"误当回刷。
  · 新增天数贡献 = 上周五之后新增的日期的值
  · 回刷        = 上周五已存在的日期，值发生了变化（这才是要报的）

阈值：同日期回刷合计 |Δ| ≥ 1 万元即报（消息里列明项目、旧值、新值、Δ）

用法：
  python3 scripts/mgmt_watch.py --init    # 建立/重置基线（不发消息）
  python3 scripts/mgmt_watch.py           # 比对并打印，不发送
  python3 scripts/mgmt_watch.py --send    # 比对，有回刷则钉钉私聊唐雯
  python3 scripts/mgmt_watch.py --send --force   # 无回刷也发（测试）
"""
import argparse
import json
import os
import sys
import urllib.request
from datetime import datetime, timedelta, timezone

K = "/data/workspace/南部大区城市看板"
STATE = f"{K}/state/mgmt_watch.json"
LOG = f"{K}/state/mgmt_watch.log"
BASE = "http://127.0.0.1:8765"
CHANNEL = "dingtalk_public"
USER_IDS = ["023503122604713695"]
BOARD = "https://jarvis.hellobike.com/aiapp#/pub-center/detail?slug=south-region-ops-dashboard&singleDoc=true"

CITIES = ["广州市", "深圳市", "东莞市", "佛山市", "厦门市", "中山市",
          "泉州市", "福州市", "惠州市", "江门市", "珠海市", "漳州市"]
COST_ITEMS = [
    ("电费", "SUM(pay_ele_fee_merchant)"),
    ("租金", "pay_hand"),
    ("电柜折旧", "SUM(cabt_depre_cost)"),
    ("电池折旧", "SUM(btry_depre_cost)"),
    ("全职人力", "quanzhirenli"),
    ("安装成本", "anzhuangchengben"),
    ("营销费", "SUM(yxf_total)"),
]
TH = 10000  # 同日期回刷合计 ≥1 万元即报


def bj_now():
    return datetime.now(timezone.utc) + timedelta(hours=8)


def log(line):
    os.makedirs(os.path.dirname(LOG), exist_ok=True)
    with open(LOG, "a", encoding="utf-8") as f:
        f.write(f"{bj_now():%Y-%m-%d %H:%M:%S} {line}\n")


def load_json(p, d=None):
    try:
        with open(p, encoding="utf-8") as f:
            return json.load(f)
    except Exception:
        return d


def build_snapshot():
    P = load_json(f"{K}/daqu_parsed.json")
    if not P:
        raise SystemExit("[FAIL] 读不到 daqu_parsed.json，先跑 refresh_convert.py")
    as_of = P["meta"]["as_of"]
    cur = as_of[:4] + as_of[5:7]
    rows = (load_json(f"{K}/raw_city_d.json", {}) or {}).get("data", {}).get("result", [])
    days = {}
    for r in rows:
        d = r.get("data_date_day") or ""
        if not d.startswith(cur):
            continue
        slot = days.setdefault(d, {})
        c = r.get("final_city_name")
        if c in CITIES:
            slot[f"{c}|毛利额"] = r.get("huandianyewuyunyingmaoli") or 0
    # 大区级（12 城合计）
    for d, slot in days.items():
        slot["__REGION__|毛利额"] = sum(v for k, v in slot.items() if k.endswith("|毛利额"))
    for lab, key in COST_ITEMS:
        per = {}
        for r in rows:
            d = r.get("data_date_day") or ""
            if d.startswith(cur) and r.get("final_city_name") in CITIES:
                per[d] = per.get(d, 0) + (r.get(key) or 0)
        for d, v in per.items():
            days.setdefault(d, {})[f"__REGION__|{lab}"] = v
    ach = (P.get("award") or {}).get("achieve_gp") or {}
    return {"as_of": as_of, "cur_month": cur,
            "mt_mtd": {"__REGION__|毛利额": ach.get(cur)},
            "days": days}


def label(k):
    if "|" not in k:
        return k
    who, item = k.split("|", 1)
    who = "大区" if who == "__REGION__" else who.rstrip("市")
    return f"{who} {item}"


def diff(old, new):
    """同日期口径回刷：只比两边都有的日期"""
    od, nd = old.get("days") or {}, new.get("days") or {}
    agg = {}
    for d in sorted(set(od) & set(nd)):
        for k, nv in nd[d].items():
            if k not in od[d]:
                continue
            delta = (nv or 0) - (od[d][k] or 0)
            if abs(delta) >= 1:
                a = agg.setdefault(k, {"old": 0.0, "new": 0.0, "n": 0, "days": []})
                a["old"] += od[d][k] or 0
                a["new"] += nv or 0
                a["n"] += 1
                if abs(delta) >= 10000:
                    a["days"].append((d, od[d][k], nv))
    out = [(k, v) for k, v in agg.items() if abs(v["new"] - v["old"]) >= TH]
    out.sort(key=lambda x: -abs(x[1]["new"] - x[1]["old"]))
    return out


def new_days_contrib(old, new):
    od, nd = old.get("days") or {}, new.get("days") or {}
    only = [d for d in nd if d not in od]
    return sum(nd[d].get("__REGION__|毛利额", 0) for d in only), sorted(only)


def build_text(old, new, changes):
    od, nd = old.get("days") or {}, new.get("days") or {}
    as_of = new["as_of"]
    over = [d for d in sorted(set(od) & set(nd))]
    ndc, nds = new_days_contrib(old, new)
    mtd_now = sum(nd[d].get("__REGION__|毛利额", 0) for d in nd)
    mtd_old = sum(od[d].get("__REGION__|毛利额", 0) for d in od)
    lb = int(as_of[5:7])
    head = (f"📊 **南部大区｜管报值周度核对**（{bj_now():%m/%d}）\n"
            f"当月 {lb}月｜累计至 {as_of[5:].replace('-', '/')}\n\n"
            f"· 大区毛利额 MTD **{mtd_now/1e4:,.2f}万**（上周五 {mtd_old/1e4:,.2f}万，"
            f"共 {(mtd_now-mtd_old)/1e4:+,.2f}万）\n"
            f"· 其中：新增 {len(nds)} 天贡献 {ndc/1e4:+,.2f}万；"
            f"同日期回刷 {sum(v['new']-v['old'] for _, v in changes)/1e4:+,.2f}万\n\n")
    if not changes:
        body = "**同日期口径无回刷**（已存在的日期数值与上周五一致）。\n"
    else:
        body = f"⚠️ 检测到 **{len(changes)} 项** 回刷（已剔除新增天数）：\n\n"
        for i, (k, v) in enumerate(changes[:12], 1):
            d = v["new"] - v["old"]
            pct = d / abs(v["old"]) * 100 if abs(v["old"]) > 1 else 0
            body += f"{i}. {label(k)}：{v['old']/1e4:,.2f}万 → **{v['new']/1e4:,.2f}万**（{d/1e4:+,.2f}万，{pct:+.2f}%，涉及 {v['n']} 天）\n"
            if v["days"]:
                top = sorted(v["days"], key=lambda x: -abs(x[2] - x[1]))[:3]
                body += "　　" + " · ".join(f"{d[5:].replace('-', '/')} {a/1e4:.2f}→{b/1e4:.2f}万" for d, a, b in top) + "\n"
        if len(changes) > 12:
            body += f"…另有 {len(changes)-12} 项\n"
        body += "\n以上为上游回刷，看板按最新值展示；**管报锚点如需更新，请回最新数值**。\n"
    return head + body + f"\n看板：{BOARD}"


def send(text):
    payload = {"channel": CHANNEL, "direct_user_ids": USER_IDS, "text": text}
    req = urllib.request.Request(
        f"{BASE}/api/messages/send",
        data=json.dumps(payload, ensure_ascii=False).encode("utf-8"),
        headers={"Content-Type": "application/json"}, method="POST")
    with urllib.request.urlopen(req, timeout=30) as r:
        return json.loads(r.read().decode("utf-8"))


def main():
    ap = argparse.ArgumentParser()
    ap.add_argument("--init", action="store_true")
    ap.add_argument("--send", action="store_true")
    ap.add_argument("--force", action="store_true")
    ap.add_argument("--dry", action="store_true")
    args = ap.parse_args()

    new = build_snapshot()
    old = load_json(STATE, {}) or {}
    first = not (old.get("days") or {}) or old.get("cur_month") != new["cur_month"]

    if args.init or first:
        os.makedirs(os.path.dirname(STATE), exist_ok=True)
        with open(STATE, "w", encoding="utf-8") as f:
            json.dump(new, f, ensure_ascii=False, indent=1)
        txt = (f"📊 管报值周度核对（{bj_now():%m/%d}）\n当月 {int(new['cur_month'][4:6])}月｜"
               f"{'新月份，' if first and old else ''}已建立基线，下周五开始只报同日期回刷。")
        log(f"INIT month={new['cur_month']} as_of={new['as_of']} days={len(new['days'])}")
        print(txt)
        if args.send and not args.dry:
            print("[SEND]", send(txt))
        return 0

    changes = diff(old, new)
    txt = build_text(old, new, changes)

    if args.dry:
        print("---- PREVIEW ----\n" + txt + "\n---- /PREVIEW ----")
        print(f"[diff] {len(changes)} 项")
        return 0

    with open(STATE, "w", encoding="utf-8") as f:
        json.dump(new, f, ensure_ascii=False, indent=1)

    if not changes and not args.force:
        ndc, nds = new_days_contrib(old, new)
        log(f"NOCHANGE month={new['cur_month']} as_of={new['as_of']} new_days={len(nds)} contrib={ndc:.0f}")
        print("[skip] 同日期口径无回刷，不发送")
        return 0

    print(txt)
    log(f"CHANGE n={len(changes)} " + ";".join(f"{label(k)}={(v['new']-v['old']):+.0f}" for k, v in changes[:8]))
    if args.send:
        try:
            print("[SEND]", send(txt))
            log("SENT ok")
        except Exception as e:  # noqa: BLE001
            print(f"[FAIL] 钉钉发送失败 {type(e).__name__}: {e}", file=sys.stderr)
            log(f"SEND-FAIL {type(e).__name__}: {e}")
            return 1
    return 0


if __name__ == "__main__":
    sys.exit(main())
