Sp_chart_MonthTeamQty (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_MonthTeamQty'._

Narrative

Business context: 生产图表分析 → 图表分析 → 决策支持 (also reused under 工作台 → 移动端管理 and 看板系统 → 大屏展示) — the dashboard card 本月班组产量 ranks teams by reported production quantity so the shop floor and managers can compare team output at a glance.

What it does: Aggregates viw_mftproductionreport joined to eleteam for the current sBrandsId/sSubsidiaryId, filters to checked rows with a non-empty sTeamId, groups by team name, sums dProcessQty, and emits a JSON payload of {x: 数量, y: 班组名称} rows for the chart renderer. The month filter on tCheckDate is commented out, so despite the name, the result is actually cumulative across all checked reports.

Invocation: Bound via gdsconfigcharmaster.sProcedureName on three chart cards (rows 15934060610..., 15934066450..., 101251240115016238222206346) under 生产图表分析, 移动端工作台 图表分析, and 看板系统 左中右布局模板.