Sp_chart_ThisMonthQty (procedure)

本月设备产量

• Type: PROCEDURE
• Deterministic: NO
• SQL data access: CONTAINS SQL

Parameters

#	Mode	Name	Type
1	IN	sLoginId	varchar(100)
2	IN	sBrId	varchar(100)
3	IN	sSuId	varchar(100)
4	IN	bFilter	varchar(5000)
5	OUT	sCode	int
6	OUT	sReturn	varchar(5000)

Body

Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURESpchart_ThisMonthQty'._

Narrative

Business context: 生产图表分析 → 图表分析 → 决策支持 (also reused under 移动端工作台 → 图表分析 and the 大屏展示 → 看板系统 template family) — the dashboard card 本月设备产量 / 达标指数 ranks machines by reported production quantity so managers can compare equipment throughput.

What it does: Aggregates viw_mftproductionreport joined to elemachine for the current sBrandsId/sSubsidiaryId, restricts to checked rows with a non-empty sMachineId, groups by machine name, sums dProcessQty, and emits a JSON {data: [{y: 设备名称, x: 数量}…]} payload. The intended DATE_FORMAT(tCheckDate,'%Y-%m') = p_dNow filter is commented out — despite the name, the result is cumulative across all checked reports.

Invocation: Bound via gdsconfigcharmaster.sProcedureName on chart cards including 15922812410008049188179768108000, 15934052500006102241076896059000, several 101251240115016087751856320 (3*5 55" 拼接屏) layout cards, and 101251240115016238222206297 (T2-1-3-达标指数) on 左中右布局模板.