Sp_chart_TodayReceivables (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_TodayReceivables'._

Narrative

Business context: Dashboard chart card 今日收款 — intended to show customer-level cash receipts as a pie/donut, labelled in 千元.

What it does: Joins cahreceiptmaster to elecustomer for the current brand/subsidiary, sums dTotalMoney × 0.001 per customer, and emits a JSON pie payload {data: [{x: 客户名, y: 千元}…], hasLegend:true, subTitle:'单位:千元'}. The date filter (v.tCreateDate = today) is commented out, so the result is cumulative across all receipts.

Invocation: Status: appears orphaned. No caller found in any channel — gdsconfigcharmaster.sProcedureName does not reference this routine, no module hook, no form embed, no other-routine call, no xly-src reference. The companion proc Sp_chart_TodayReceive is wired up on a chart card; this near-duplicate appears to be a superseded variant. Candidate for maintainer audit.