# -*- coding: utf-8 -*-
import json, datetime, sys

K = '/data/workspace/南部大区城市看板'
P = json.load(open(f'{K}/daqu_parsed.json', encoding='utf-8'))
meta, region, award = P['meta'], P['region'], P['award']
as_of = datetime.date.fromisoformat(meta['as_of'])

rev, gp, gpm = region['收入'], region['毛利额'], region['毛利率']

# 季度口径（10/6 季度化）：目标=q_targets合计（本季三个月，来自 targets.json），日历算时间进度
q_start = datetime.date(as_of.year, (as_of.month - 1) // 3 * 3 + 1, 1)
qm = q_start.month + 2
q_end = datetime.date(as_of.year, qm, [31,28,31,30,31,30,31,31,30,31,30,31][qm-1])
elapsed = (as_of - q_start).days + 1
total_days = (q_end - q_start).days + 1
remaining = total_days - elapsed
q_total = award['q_targets']['合计']
achieved = award['achieve_gp']['合计']
# 季度标签与已达成月份明细（10/6 起动态化，不再硬编码 Q3 的 7/8/9 月）
_qms = award.get('q_months') or []
QL = 'Q%d' % ((int(_qms[0][4:6]) - 1) // 3 + 1) if _qms else '本季'
_ams = [m for m in _qms if award['achieve_gp'].get(m) is not None]
ACH_TXT = ' + '.join(f'{int(m[4:6])}月 {award["achieve_gp"][m]/1e4:,.0f}万' for m in _ams) or '—（本季尚无已过月份）'
_ams_lab = '+'.join(f'{int(m[4:6])}月' for m in _ams) or '本季' 
ach_rate = achieved / q_total * 100
t_prog = elapsed / total_days * 100
# 季末收官守卫（2026-10-01 加，口径同 gen_html2.py）：as_of=季末最后一天时 remaining=0，原式除零崩；
# 收官日不再有“剩余需日均”，其余日子行为完全不变。
quarter_closed = remaining <= 0
need_daily = (q_total - achieved) / remaining / 1e4 if not quarter_closed else 0.0
cur_level = gp['t1'] / 1e4

# 落后城市：城市自带「月度目标达成进度VS时间进度」字段（毛利进度−时间进度）；无阈值固定取最落后3城，≥1pp 标⚠
lags = []
for city, m in P['cities'].items():
    v = m.get('月度目标达成进度VS时间进度')
    if v is not None:
        lags.append((v * 100, city))
lags.sort()
top3 = lags[:3]  # 9/3 用户口径：无阈值固定显示最落后3城，落后≥1pp 额外标⚠
lag_txt = ' · '.join(f'{c.rstrip("市")} {g:.1f}pp' + (' ⚠' if g <= -1 else '') for g, c in top3) if top3 else '无'

wan = lambda v: f'{v/1e4:,.0f}'
sgn = lambda v, d=1: ('+' if v >= 0 else '') + f'{v/1e4:.{d}f}'

# 套内用户数（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}）',
    f'**{as_of.month}月MTD收入 {wan(rev["mtd"])}万**（T-1 {as_of.month}/{as_of.day}: {wan(rev["t1"])}万，环比 {sgn(rev["dod"], 1)}万）',
    f'**MTD毛利 {wan(gp["mtd"])}万 · 毛利率 {gpm["mtd"]*100:.1f}%**（T-1毛利 {gp["t1"]/1e4:.1f}万 · {gpm["t1"]*100:.1f}%，毛利率环比 {("+" if gpm["dod"]>=0 else "")}{gpm["dod"]*100:.1f}pp）',
    (f'**{as_of.month}月目标进度：收入 {rev["mtd"]/P["targets"]["region"]["rev"]*100:.1f}% · 毛利 {gp["mtd"]/P["targets"]["region"]["gp"]*100:.1f}% vs 时间进度 {meta["time_progress"]*100:.1f}%**'
     if P['targets']['region'].get('rev') else
     f'**{as_of.month}月目标进度：毛利 {gp["mtd"]/P["targets"]["region"]["gp"]*100:.1f}% vs 时间进度 {meta["time_progress"]*100:.1f}%**（本月收入/毛利率目标未提供）'),
    *([_tn_line] if _tn_line else []),
    f'**{QL}换电毛利额目标进度：已达成 {wan(achieved)}万 = {ach_rate:.1f}% vs 时间进度 {t_prog:.1f}%**',
    f'口径：{ACH_TXT}（{QL}累计，未锚定月为线上MTD，月底管报终数锁定）',
    (f'**季度已收官**（剩余 0 天）：本季达成 {wan(achieved)}万 ÷ 目标 {wan(q_total)}万，缺口 {sgn(achieved - q_total, 1)}万'
     if quarter_closed else
     f'剩余 {remaining} 天需日均 **{need_daily:.1f}万/天**，当前水位 {cur_level:.1f}万/天'),
    ('⚠️ 未达目标线' if ach_rate < 100 else '✅ 已达目标线') if quarter_closed
     else ('✅ 略高于达标线' if cur_level >= need_daily else '⚠️ 低于达标线'),
    f'⚠️ **进度落后城市**（月度目标进度 vs 时间进度）：{lag_txt}',
    '[📱 手机打开看板](https://south-dash.tail53d536.ts.net/south.html)',
    '[🏢 稳定链接（需登录）](https://jarvis.hellobike.com/aiapp#/pub-center/detail?slug=south-region-ops-dashboard&singleDoc=true)',
]
if '--no-links' in sys.argv:   # 按钮式卡片：链接走按钮，正文不带链接行
    lines = lines[:-2]
open('/tmp/card.txt', 'w', encoding='utf-8').write('\n\n'.join(lines))
print(open('/tmp/card.txt', encoding='utf-8').read())
