Sp_chart_TodayReceive (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_TodayReceive'._

Narrative

Business context: 移动端工作台 → 图表分析 → 移动端管理 — the dashboard card 本月收款 breaks down this month's checked receipts by customer classification so AR can see which segments are paying.

What it does: Sums cahreceiptmaster.dTotalMoney joined to elecustomer and siscustomerclassify for the current brand/subsidiary, restricted to bCheck = 1 and date_format(tCreateDate,'%Y-%m') = current month, groups by classification name (union'd with a fallback row for unclassified customers), and emits a JSON pie payload {data: [{x: 分类, y: 元}…], hasLegend:true, subTitle:'单位:元'}.

Invocation: Bound via gdsconfigcharmaster.sProcedureName on chart card 15948867380001462563833029742300 under 移动端工作台 图表分析.