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

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['毛利率']

# Q3 口径：目标=q_targets合计，日历算时间进度
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']['合计']
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}'

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}%**',
    f'**Q3换电毛利额目标进度：已达成 {wan(achieved)}万 = {ach_rate:.1f}% vs 时间进度 {t_prog:.1f}%**',
    f'口径：7月管报 {award["achieve_gp"]["202607"]/1e4:,.0f}万 + 8月管报 {award["achieve_gp"]["202608"]/1e4:,.0f}万 + 9月管报口径 {award["achieve_gp"]["202609"]/1e4:,.0f}万（9月=管报锚定+线上增量，月底管报终数锁定）',
    (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://brain.hellobike.cn/aiapp#/pub-center/detail?slug=south-region-ops-dashboard&singleDoc=true)',
]
open('/tmp/card.txt', 'w', encoding='utf-8').write('\n\n'.join(lines))
print(open('/tmp/card.txt', encoding='utf-8').read())
