# -*- 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
need_daily = (q_total - achieved) / remaining / 1e4
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} {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}'
now = datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S')

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"], 0)}万）',
    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'**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'剩余 {remaining} 天需日均 **{need_daily:.1f}万/天**，当前水位 {cur_level:.1f}万/天',
    '✅ 略高于达标线' 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)',
    f'⏰ {now}',
]
open('/tmp/card.txt', 'w', encoding='utf-8').write('\n\n'.join(lines))
print(open('/tmp/card.txt', encoding='utf-8').read())
