Sp_chart_MonthProfit (procedure)

PLC数据同步

• 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_MonthProfit'._

Narrative

Business context: 财务图表分析 → 图表分析 → 决策支持 — the dashboard card 销售VS标准成本 月度趋势分析 plots, per month, the brand's checked work-order sales revenue against summed standard cost so finance can spot margin drift over time.

What it does: Joins mftworkordermaster (filtered to bCheck = 1 for the current sBrandsId/sSubsidiaryId) to a mftworkorderslave aggregate of dProductMoney, groups by date_format(tCreateDate,'%Y%m'), scales totals by 0.001 (千元), and emits a JSON payload with two series — 销售额 and 标准成本 — in the chart-renderer's {data, xUnit, yUnit} shape.

Invocation: Bound to gdsconfigcharmaster row 15934049720005097053483739309000 (sCharType sBrokenLine) under module 财务图表分析; the chart-rendering layer calls procedures listed in sProcedureName to populate dashboard cards. Despite the routine's COMMENT 'PLC数据同步', the body is unrelated to PLC sync — the comment is a leftover copy/paste.