11 (procedure)

现金日记帐

• Type: PROCEDURE
• Deterministic: NO
• SQL data access: CONTAINS SQL

Parameters

#	Mode	Name	Type
1	IN	tStartDate	datetime
2	IN	tEndDate	datetime
3	IN	sBrId	varchar(100)
4	IN	sSuId	varchar(100)
5	IN	sLoginId	varchar(100)
6	IN	bFilter	varchar(5000)
7	IN	pageNum	int
8	IN	pageSize	int
9	OUT	totalCount	int
10	IN	countCloumn	varchar(5000)
11	OUT	countMapJson	longtext
12	IN	sFilterOrderBy	varchar(5000)
13	IN	sGroupby_select_sql	varchar(5000)
14	IN	sGroupby_group_sql	varchar(5000)

Body

Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURE11'.

Narrative

Business context: A scratch/debug fragment of the product-class sales-revenue summary report — groups viw_salsalesorder by sisproductclassify, totals product money / receipt money / unpaid balance per class, then percentages each class against the grand total. The numeric name 11 and the standalone SELECT p_sSql debug echo mark this as developer leftover, not production code. The catalog header 现金日记帐 (cash journal) is mis-copied — the body has nothing to do with a cash journal.

What it does: builds a dynamic SQL string that INSERTs into temp table SAS per-class sums (dProductMoney/dReceiptMoney/balance), then concatenates an UPDATE that fills percentages (dRate/dPayRate/dBalanceRate), finally hands the assembled SQL to Sp_Outstanding_Query for paging/filtering. Builds a Fun_GetLookCustomer data-scope clause into p_sLookCustomer but never injects it into the WHERE.

Invocation: Status: appears orphaned. No caller found in any channel (form-master sSqlStr, gdsmodule hooks, other routines, exhaustive xly-src grep) — candidate for maintainer audit / deletion.