Sp_chart_TodayProfit (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_TodayProfit'._

Narrative

Business context: 财务图表分析 → 图表分析 → 决策支持 — the dashboard card 本月毛利 breaks down this month's gross profit (sales – standard cost) by product classification so finance can see which categories drove margin.

What it does: Joins mftworkorderslave to a mftworkordermaster aggregate filtered by bCheck = 1 and date_format(tCreateDate,'%Y-%m') = current month, computes per-row gross profit as dProductMoney − dCostMoney × (dProductMoney / dTotalMoney), then joins eleproduct→sisproductclassify, groups by classification, scales by 0.001 (千元), and emits a JSON pie payload {data, hasLegend, subTitle:'单位:千元'}.

Invocation: Bound via gdsconfigcharmaster.sProcedureName on chart card 15934048800005818183366101872000 under 财务图表分析.