# -*- coding: utf-8 -*-
"""联营侧套内用户：convert 提供全城市套内 → gen_html2 联营表加列+合计目标 → build_card 加播报行"""
import io

# ---------- 1) refresh_convert.py：套内 cities 扩到全部城市（含联营） ----------
P = "/data/workspace/南部大区城市看板/refresh_convert.py"
s = io.open(P, encoding="utf-8").read()
def rep(a, b, tag):
    global s
    assert s.count(a) == 1, "%s %d" % (tag, s.count(a))
    s = s.replace(a, b)

rep('''_lym = [x for x in city_m if x.get("city_type") == "联营" and str(x["data_date_mounth"]) == M_MONTH]''',
'''_all_cm = {str(r["final_city_name"]): r for r in city_m if str(r["data_date_mounth"]) == M_MONTH}
_all_c1 = {c: cd.get(c, {}).get(D1) for c in _all_cm}
_all_c2 = {c: cd.get(c, {}).get(D2) for c in _all_cm}
_lym = [x for x in city_m if x.get("city_type") == "联营" and str(x["data_date_mounth"]) == M_MONTH]''', "allcities")

rep('''    "cities": {(c): {"mtd": cities[c]["套内用户"]["mtd"], "t1": cities[c]["套内用户"]["t1"],
                     "dod": cities[c]["套内用户"]["dod"], "target": cities[c]["套内用户目标"],
                     "gap": ((cities[c]["套内用户"]["mtd"] - cities[c]["套内用户目标"])
                             if cities[c]["套内用户"]["mtd"] is not None and cities[c]["套内用户目标"] else None)}
               for c in cities},''',
'''    # cities 覆盖全部有数城市（12 直营 + 联营各城/县）；目标只有 Q4 表给的 12 直营城市，其余为 None
    "cities": {c: _tn_city(c) for c in sorted(set(list(cities) + list(_all_cm)))},''', "cities")

# 在 taonei 块内定义 _tn_city（放 _tnblk 之后）
rep('''def _tnblk(mtd, t1, t2, tgt):''',
'''def _tn_city(c):
    r, r1, r2 = _all_cm.get(c), _all_c1.get(c), _all_c2.get(c)
    return _tnblk(mget(r, "taonei_users_ym") if r else None,
                  mget(r1, "taonei_users_ym") if r1 else None,
                  mget(r2, "taonei_users_ym") if r2 else None,
                  TGT_TN_CITY.get(c))
def _tnblk(mtd, t1, t2, tgt):''', "tncity")

# 校验打印：改口径（直营 12 城 + 联营 Σ = 大区）
rep('''_chk = sum((v["mtd"] or 0) for v in taonei["cities"].values())
_lychk = (_chk - (taonei["direct"]["mtd"] or 0))
print("套内用户校验：12直营Σ %.0f + 联营Σ %.0f = %.0f vs 大区 %.0f（差 %+.0f）" % (
    taonei["direct"]["mtd"] or 0, _lychk, _chk, taonei["region"]["mtd"] or 0,
    _chk - (taonei["region"]["mtd"] or 0)))''',
'''_chk = sum((v["mtd"] or 0) for v in taonei["cities"].values())
_dchk = taonei["direct"]["mtd"] or 0
_lchk = taonei["lianying"]["mtd"] or 0
print("套内用户校验：全城Σ %.0f ＝ 大区 %.0f（差 %+.0f）｜12直营 %.0f + 联营 %.0f = %.0f（差 %+.0f）" % (
    _chk, taonei["region"]["mtd"] or 0, _chk - (taonei["region"]["mtd"] or 0),
    _dchk, _lchk, _dchk + _lchk, _dchk + _lchk - (taonei["region"]["mtd"] or 0)))''', "check")
io.open(P, "w", encoding="utf-8").write(s)
print("convert patched")

# ---------- 2) gen_html2.py：联营表加「套内用户」列 + 合计行目标 ----------
P2 = "/data/workspace/南部大区城市看板/gen_html2.py"
s = io.open(P2, encoding="utf-8").read()

rep("""  const cols = [['city','城市'],['mode','模式'],['aug_rev','收入 '+ML+'MTD'],['aug_gpm','毛利率 '+ML],['aug_users','换电用户'],['aug_kedanjia','客单价'],""",
    """  const cols = [['city','城市'],['mode','模式'],['aug_rev','收入 '+ML+'MTD'],['aug_gpm','毛利率 '+ML],['aug_users','换电用户'],['aug_taonei','套内用户'],['aug_kedanjia','客单价'],""", "lycols")

rep("""        <td>${r.aug_users?.toLocaleString()||'-'}</td><td>${r.aug_kedanjia?.toFixed(0)||'-'}</td>""",
    """        <td>${r.aug_users?.toLocaleString()||'-'}</td>
        <td>${(()=>{const T=DATA.taonei.cities[r.city]||{}; return T.mtd!=null?T.mtd.toLocaleString():'-';})()}</td>
        <td>${r.aug_kedanjia?.toFixed(0)||'-'}</td>""", "lycell")

rep("""    h += `<tr style="font-weight:700;background:#f6f9fd;"><td class="cname">联营已开城</td><td>-</td>
      <td colspan="3" style="text-align:left;color:var(--sub);">${ML}毛利目标 <b style="color:var(--ink)">${wan(DATA.region['联营毛利额'].target)}</b></td>
      <td colspan="5" style="text-align:left;color:var(--sub);">收入目标 <b style="color:var(--ink)">${DATA.tgt.lianying_rev!=null?(DATA.tgt.lianying_rev/1e4).toFixed(1)+'万':'未提供'}</b> · 换电用户T-1 <b style="color:var(--ink)">${T.ly_total_t1.toLocaleString()}</b></td></tr>`;""",
    """    const TA=DATA.taonei;
    h += `<tr style="font-weight:700;background:#f6f9fd;"><td class="cname">联营已开城</td><td>-</td>
      <td colspan="2" style="text-align:left;color:var(--sub);">${ML}毛利目标 <b style="color:var(--ink)">${wan(DATA.region['联营毛利额'].target)}</b></td>
      <td style="color:var(--sub);font-weight:400;">T-1 <b style="color:var(--ink)">${T.ly_total_t1.toLocaleString()}</b></td>
      <td>${TA.lianying.mtd!=null?TA.lianying.mtd.toLocaleString():'-'}<div style="font-size:10.5px;color:var(--sub);font-weight:400;">月末目标 ${TA.lianying.target!=null?TA.lianying.target.toLocaleString():'未提供'} · 距目标 <span style="color:var(--sub)">${sgni(TA.lianying.gap)}</span></div></td>
      <td colspan="5" style="text-align:left;color:var(--sub);">收入目标 <b style="color:var(--ink)">${DATA.tgt.lianying_rev!=null?(DATA.tgt.lianying_rev/1e4).toFixed(1)+'万':'未提供'}</b></td></tr>`;""", "lytotal")
io.open(P2, "w", encoding="utf-8").write(s)
print("gen_html2 patched")

# ---------- 3) build_card.py：新增套内用户行（放在月度目标进度行之后） ----------
P3 = "/data/workspace/南部大区城市看板/build_card.py"
s = io.open(P3, encoding="utf-8").read()
rep("""lines = [
    f'📊 **南部大区经营日报**（数据截至 {as_of.month}/{as_of.day}）',""",
    """# 套内用户数（2026-10-08 起：17040 taonei_users_ym 实时取数；目标=Q4 表「套内用户数_月末」）
_TA = P.get('taonei') or {}
_tn = _TA.get('region') or {}
_tn_line = None
if _tn.get('mtd') is not None and _tn.get('target'):
    _d = _TA.get('direct') or {}
    _l = _TA.get('lianying') or {}
    _tn_line = (f'**套内用户 {_tn["mtd"]/1e4:.1f}万 · 月末目标 {_tn["target"]/1e4:.1f}万 · 距目标 {(_tn["mtd"]-_tn["target"])/1e4:+.1f}万**'
                f'（直营 {_d.get("mtd",0)/1e4:.1f}万 · 联营 {_l.get("mtd",0)/1e4:.1f}万'
                + (f' · 日环比 {_tn["dod"]:+,.0f}户' if _tn.get('dod') is not None else '') + '）')

lines = [
    f'📊 **南部大区经营日报**（数据截至 {as_of.month}/{as_of.day}）',""", "cardline")

rep("""    f'**{QL}换电毛利额目标进度：已达成 {wan(achieved)}万 = {ach_rate:.1f}% vs 时间进度 {t_prog:.1f}%**',""",
    """    *([_tn_line] if _tn_line else []),
    f'**{QL}换电毛利额目标进度：已达成 {wan(achieved)}万 = {ach_rate:.1f}% vs 时间进度 {t_prog:.1f}%**',""", "cardinsert")
io.open(P3, "w", encoding="utf-8").write(s)
print("build_card patched")