# -*- coding: utf-8 -*-
"""生成科研促销复盘图表：纯内联 SVG -> Chrome headless PNG"""
import json
import subprocess
from pathlib import Path
ROOT = Path('/Users/liuxinyuan/Desktop/Hermes输出-工作类')
OUT = ROOT / '营销活动' / '科研促销复盘_20261103' / '图表'
OUT.mkdir(parents=True, exist_ok=True)
DATA = json.load(open(ROOT / '营销活动' / '科研促销复盘_20261103' / '数据' / 'promo_review_2026.json', encoding='utf-8'))
FONT = "'Songti SC','STSong','SimSun',serif"
NAVY = '#1F4E79'
TEAL = '#2A9D8F'
ORANGE = '#E9A800'
LIGHT = '#EEF6FB'
GREY = '#5F6B7A'
def esc(s):
return str(s).replace('&', '&').replace('<', '<').replace('>', '>')
def frame(w, h, title, subtitle):
return f''''
def region_chart():
w, h = 1600, 820
vals = DATA['region']
s = frame(w, h, '区域：基线月均与促销折月', '同一批销售员；折月按浙江 42 天、广东 46 天折算')
x0, y0, pw, ph = 120, 160, 1320, 510
maxv = 50000
for i in range(0, 6):
y = y0 + ph - ph * i / 5
s += f''
s += f'{int(maxv*i/5/10000)}万'
group_w = 260
bar_w = 90
for i, row in enumerate(vals):
base = row['baseline_monthly']; promo = row['promo_monthly']
cx = x0 + pw * (i + 1) / (len(vals) + 1)
xb = cx - bar_w - 12
xp = cx + 12
hb = ph * base / maxv; hp = ph * promo / maxv
s += f''
s += f''
s += f'{yuan(base)}'
s += f'{yuan(promo)}'
s += f'{row["region"]}'
s += f'+{row["growth"]*100:.1f}%'
s += f'{row["orders"]} 单 / {row["groups"]} 组'
# legend
s += f'4–9 月月均'
s += f'促销折月'
return s + ''
def sales_chart():
rows = sorted(DATA['sales'], key=lambda x: x['amount'], reverse=True)
w, h = 1600, 1120
s = frame(w, h, '销售员：基线月均与促销折月', '按促销额降序；折月按所属区域窗口折算 30 天')
x0, y0, pw, row_h = 360, 170, 1130, 100
maxv = 18000
for i in range(0, 6):
x = x0 + pw * i / 5
s += f''
tick = '' if i == 0 else f'{maxv*i/5/10000:.1f}万'
s += f'{tick}'
for i, row in enumerate(rows):
y = y0 + i * row_h
base = row['baseline_monthly']; promo = row['promo_monthly']
s += f'{row["sales"]}'
s += f'{row["region"]} · {row["orders"]} 单'
wb = pw * base / maxv; wp = pw * promo / maxv
s += f''
s += f''
s += f'{yuan(base)}'
s += f'{yuan(promo)} ({row["growth"]*100:+.1f}%)'
s += f'4–9 月月均'
s += f'促销折月'
return s + ''
def tier_chart():
order = ['未达标', '1K', '2K', '5K', '1W']
vals = []
for t in order:
n = sum(1 for x in DATA['groups'] if x['tier'] == t)
vals.append(n)
w, h = 1600, 820
s = frame(w, h, '课题组档位分布：35 个达档，29 个未达 1,000 元', '按客户×课题组为归集实体；取最高档，赠品按现有促销统计口径')
x0, y0, pw, ph = 130, 160, 1320, 500
maxv = 35
for i in range(0, 8):
y = y0 + ph - ph * i / 7
s += f''
s += f'{int(maxv*i/7)}'
bw = 150
gap = (pw - bw * len(order)) / (len(order) + 1)
colors = ['#C9D3DF', '#9BB7D4', '#5B8DB8', NAVY, TEAL]
for i, (t, v) in enumerate(zip(order, vals)):
bh = ph * v / maxv
x = x0 + gap + i * (bw + gap)
y = y0 + ph - bh
s += f''
s += f'{v}'
s += f'{t}'
s += f'个课题组'
s += f'注：1K=1,000 元，2K=2,000 元，5K=5,000 元，1W=10,000 元；未达标不含测试单、赠品行。'
return s + ''
def render(name, svg, h):
html = f'''{svg}'''
hp = OUT / f'{name}.html'
hp.write_text(html, encoding='utf-8')
png = OUT / f'{name}.png'
cmd = ['/Applications/Google Chrome.app/Contents/MacOS/Google Chrome', '--headless', '--disable-gpu',
'--hide-scrollbars', f'--window-size=1600,{h}', f'--screenshot={png}', f'file://{hp}']
subprocess.run(cmd, check=False, stdout=subprocess.DEVNULL, stderr=subprocess.DEVNULL, timeout=60)
print(png, png.stat().st_size if png.exists() else 'MISSING')
if __name__ == '__main__':
render('01_月度趋势', monthly_chart(), 900)
render('02_区域对比', region_chart(), 820)
render('03_销售员对比', sales_chart(), 1120)
render('04_课题组档位', tier_chart(), 820)