""" % (esc(title), esc(no), esc(title), desc)
def p_people():
rows = []
for i, p in enumerate(people_sorted, 1):
t, tn = tier(p["rate"])
tg = p["target"]
av = p["actual"]
rt = p["rate"]
w = 0 if rt is None else min(rt, 100)
def f(v):
return "—" if v is None else ("%.1f" % v)
rows.append(
'
%d
%s
%s
'
'
%s
%s
'
'
%s%s%s
'
'
'
'
%s
'
% (i, esc(p["name"]), esc(p["dept"][:30]), f(tg), f(av),
f(rt), "%" if rt is not None else "",
(' ⚠'
if p.get("recon") else ""),
t, w, t, tn))
return """
""" % "".join(
# 空季度不写 0（保持空白），已有季度沿用原 "%.1f" 格式，避免无谓的呈现变更
kpi("Q%d" % i, ("%.1f" % q_amt[k]) if q_amt.get(k) is not None else "—", "万",
("—" if (i == 1 or q_amt.get(k) is None or q_amt.get("2026-Q%d" % (i - 1)) is None)
else "环比 %+.1f%%" % (
(q_amt[k] - q_amt["2026-Q%d" % (i - 1)])
/ max(q_amt["2026-Q%d" % (i - 1)], 1) * 100)))
for i, k in enumerate(["2026-Q1", "2026-Q2", "2026-Q3"], 1))
def p_erp_dept():
return """
""" % (fm(q["total"], 1), fm(q["target"], 1), fm(q["rate"], 1), fm(q["yoy"], 1),
CONC["n_groups"], fm(q["total"], 1))
# ── 章节定义 + 页序（章节页码由 ORDER 索引自动推导，杜绝目录漂移）──
# ══════════════════════════════════════════════════════════════════════════
# 「生命科学部 Q3 报送专项」新增章节（本轮）
# 数据源：数据/2026Q3汇报_汇总.json → tables 三张 LS 表（原表直读）
# 数据/2026Q3_ERP对账.json → ERP 实绩（YTD 1–9 月，工作台归并口径）
# 数据/三部门逐月_2026.json → ERP 逐人逐月实际（取 7–9 月做 Q3 对照）
# 口径铁律：不做换算、不做跨人总额（月度目标表各人填报单位可能不一致），
# 凡汇总一律标注单位与覆盖行数；对照页必须写明两口径不可直接加减。
# ══════════════════════════════════════════════════════════════════════════
LS8 = ["黄建华", "王诗香", "陈彩红", "叶信福", "侯海瑜", "袁殿果", "吴云", "韩远怀"]
LS_SRC = json.load(open(os.path.join(DJ, "2026Q3汇报_汇总.json"), encoding="utf-8"))
ERPJ = json.load(open(os.path.join(DJ, "2026Q3_ERP对账.json"), encoding="utf-8"))
LST = LS_SRC.get("tables") or {}
FC_PROD = ["建库试剂盒", "提取试剂", "反转录", "qcpr", "高保真pcr", "普通pcr酶", "蛋白marker",
"同源重组酶", "其他"]
TGT_TC = "background:#FCFDFF;font-size:11px;line-height:1.5;white-space:normal;word-break:break-word"
def _ls_p(s):
for n in LS8:
if n in str(s):
return n
return str(s or "")
def _fn(v):
try:
return float(str(v).replace(",", "").strip())
except Exception:
return None
def _lsum(rows, f):
vs = [x for x in (_fn(r.get(f)) for r in rows) if x is not None]
return (round(sum(vs), 2), len(vs))
ls_tgt = LST.get("生命科学_月度目标") or []
ls_kt = LST.get("生命科学_课题组") or []
ls_fc = LST.get("生命科学_四季度预测") or []
# 月度目标：只做「按人」小计（跨人单位可能不一致）
ls_by = {n: [0.0, 0.0, 0, 0] for n in LS8} # [目标, 实际, 目标行数, 实际行数]
for r in ls_tgt:
p = _ls_p(r.get("汇报人") or r.get("来源文件"))
if p in ls_by:
a, b = _fn(r.get("销售目标")), _fn(r.get("实际完成"))
if a is not None:
ls_by[p][0] += a; ls_by[p][2] += 1
if b is not None:
ls_by[p][1] += b; ls_by[p][3] += 1
# 自报 Q3 达成（四季度预测表 · 单位随原表，多为万元）
ls_q3 = {}
for r in ls_fc:
p = _ls_p(r.get("汇报人") or r.get("来源文件"))
v = _fn(r.get("3季度达成"))
if v is not None:
ls_q3[p] = round(ls_q3.get(p, 0.0) + v, 2)
# ERP：Q3 实际（7–9 月）与 YTD（1–9 月）
erp_q3 = {}
for r in (d3.get("salespersons") or []):
if str(r.get("dept")) == "生命科学部" and str(r.get("month")) in Q3M:
erp_q3[r.get("sp")] = round(erp_q3.get(r.get("sp"), 0.0) + (r.get("amt") or 0.0), 2)
erp_ytd = {r.get("人"): r for r in (ERPJ.get("rows") or [])}
ls_tgt_people = sum(1 for n in LS8 if ls_by[n][2] or ls_by[n][3])
ls_kt_state = {}
ls_kt_mode = {}
for r in ls_kt:
ls_kt_state[str(r.get("商机状态") or "未填")] = ls_kt_state.get(str(r.get("商机状态") or "未填"), 0) + 1
ls_kt_mode[str(r.get("课题组模式") or "未填")] = ls_kt_mode.get(str(r.get("课题组模式") or "未填"), 0) + 1
ls_kt_goal, ls_kt_goal_n = _lsum(ls_kt, "年度目标（w）")
ls_fc_tot, _ = _lsum(ls_fc, "合计")
ls_fc_q3, _ = _lsum(ls_fc, "3季度达成")
ls_fc_q4, _ = _lsum(ls_fc, "4季度预测")
ls_fc_prod = [(c, _lsum(ls_fc, c)[0]) for c in FC_PROD]
DECK_GEN = __import__("datetime").datetime.now().strftime("%Y-%m-%d %H:%M")
LS_CAVEAT = ("⚠️ 口径：①「自报」= 各人 PPT 内嵌表原值（单位随原表，未做换算）；"
"②「ERP」= 标准销售订单 · 已审核 · 非赠品 · 剔除关联方，按工作台归并口径；"
"③ 两者统计范围不同（自报含未过账商机），不可直接相减当缺口；"
"④ 生命科学部为 Q3 起单独报送，不并入前两季度口径合计。")
def _cell(v, num=False, long=False):
st = "text-align:right;white-space:nowrap;font-variant-numeric:tabular-nums" if num else (
TGT_TC if long else "")
return '
') % (
esc(label), esc(value), esc(unit), esc(note))
def p_ls_summary():
rows = []
for n in LS8:
e = erp_ytd.get(n) or {}
rows.append(lambda r, n=n, e=e: None) # 占位（下面直接渲染静态行）
body = []
for n in LS8:
e = erp_ytd.get(n) or {}
body.append('
' + "".join([
_cell(n), _cell("生命科学部"),
_cell("已报送" if (ls_by[n][2] or ls_by[n][3] or ls_q3.get(n) is not None) else "—"),
_cell("%.2f" % ls_q3[n] if n in ls_q3 else "—", num=True),
_cell("%.2f" % erp_q3[n] if n in erp_q3 else "—", num=True),
_cell(("%.2f" % round(ls_q3.get(n, 0.0) - erp_q3.get(n, 0.0), 2)) if (n in ls_q3 and n in erp_q3) else "—", num=True),
_cell("%.2f" % (e.get("ERP实绩_万") or 0) if e else "—", num=True),
_cell("%s" % (e.get("ERP客户数") if e else "—"), num=True),
]) + '
';
}
function vbars(host,rows,opt){
opt=opt||{}; var mx=Math.max.apply(null,rows.map(function(r){return r.v==null?0:r.v;}).concat([1]));
var h=opt.h||150;
var html='
';
rows.forEach(function(r){
var v=(r.v==null?null:r.v); /* 空值 → 不画柱、不写 0 */
var bh=v==null?0:Math.max(2,v/mx*h);
html+='
';
}
function groupBars(host,labels,series,opt){
opt=opt||{}; var mx=1;
series.forEach(function(s){s.v.forEach(function(v){if(v!=null&&v>mx)mx=v;});});
var h=opt.h||150;
var html='
';
labels.forEach(function(lb,i){
html+='
'
+'
';
series.forEach(function(s){
var v=s.v[i]; /* 空月份 → 不画柱，绝不补 0 */
if(v==null){ html+=''; return; }
var bh=Math.max(1,v/mx*h);
html+='';
});
html+='
'+esc(lb)+'
';
});
var lg=series.map(function(s){return ''
+''+esc(s.n)+'';}).join('');
host.innerHTML=html+'
'+lg+'
';
}
/* ── 同页表格 → 图表取值（图表一律从本页已渲染表格读值，零外部库）── */
function cellN(s){var v=parseFloat(String(s==null?'':s).replace(/[,\s]/g,'')); return isNaN(v)?null:v;}
function mv(o,k){ var v=o?o[k]:null; return (v==null||v==='')?'—':v; } /* 空月份保持空白，不写 0 */
function tableRows(id,pick){
var host=el(id); if(!host) return [];
var trs=host.querySelectorAll('tbody tr'), out=[];
for(var i=0;i
'+(i+1)+'
'+esc(s.name)+'
'+s.total+'
'
+'
'+mv(m,'2026-07')+'
'+mv(m,'2026-08')+'
'
+'
'+mv(m,'2026-09')+'
';}).join('');
}
/* 图表②从本页 #tbActSales 表体渲染（先表后图）*/
hbar(el('chActSales'), tableRows('tbActSales', function(c){return {k:c[1], v:cellN(c[2])};})
.filter(function(r){return r.v!=null;}).slice(0,12), {lw:64,vw:56});
/* 活动 vs 产出 */
var erpSp={}; D.erp.top_sp.forEach(function(s){erpSp[s.name]=s.wan;});
var rows=D.act.by_sales.map(function(s){
var y=erpSp[s.name]; var per=(y!=null&&s.total>0)? (y/s.total*100) : null;
return {name:s.name, n:s.total, y:y, per:per};
}).sort(function(a,b){return b.n-a.n;});
var tb=el('tbActOut'); if(tb){
tb.innerHTML = rows.map(function(r,i){
var j = r.y==null ? '无出单'
: (r.per<1 ? '活动高·产出极低'
: r.per<6 ? '偏低'
: r.per<15 ? '一般' : '匹配');
return '
'+(i+1)+'
'+esc(r.name)+'
'+r.n+'
'
+'
'+(r.y==null?'—':fmt(r.y,1))+'
'
+'
'+(r.per==null?'—':fmt(r.per,2))+'
'+j+'
';}).join('');
}
var nt=el('actOutNote');
if(nt){ var sci=rows.filter(function(r){return r.per!=null&&r.per<3;}).slice(0,5).map(function(r){return r.name;});
nt.innerHTML='重点判读：活动条数 TOP 6 中有 5 人来自生命科学（科研）线，'
+'但其 ERP YTD 产出与活动量严重不匹配（如 '+esc(sci.join('、'))+' 的「万元/百条活动」均低于 3）。'
+'「活动量」是过程指标，不能代替结果指标；建议把科研线的活动质量（有效客户数、测试转化）单独设指标。';}
/* 高频客户 */
var tc=el('tbActCust');
if(tc){ var names=Object.keys(D.act.customers);
names.sort(function(a,b){var A=D.act.customers[a],B=D.act.customers[b];
return (B[Object.keys(B)[0]]||0)-(A[Object.keys(A)[0]]||0);});
tc.innerHTML=names.map(function(nm,i){
var o=D.act.customers[nm], ks=Object.keys(o).slice(0,5);
return '