Sp_SalesOrder_Analysis (procedure)

销售订单分析报表

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

Parameters

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

Body

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

Narrative

Business context: 销售管理 → 销售分析 — 销售订单分析报表 data-source. Pivot report keyed by configurable sGroupType (客户 / 业务员 / 产品 / 业务部门 / …), aggregating sales-order or 报价 bills across a date range. Returns one row per dimension+sCurrency combo with totals: dProductMoney (含税金额), dProductNoTaxMoney (不含税), dProductTaxMoney (税额), dProductQty (数量), dProductForeignMoney (外币). Also returns a dynamic sColumnNameConfig so the grid can render the show-hide column choices the user saved.

What it does: Resolves the date range (tStartDate is the string start,end; default = last 12 months), sets p_sDateType / p_sGroupType / p_sBillType from the input flags. Creates temp table p_SalesOrder_Analysis and emits a Fun_get_show_config row per displayed column (编号 / 币别 / 名称 / 总计-金额 / 不含税 / 税额 / 总数量 / 外币金额, …) accumulating the JSON config in p_sColumnNameConfig. Then it branches on sBillType (salsalesorder / salquotation / etc.) and sGroupType to build the dynamic insert into the temp table, joining viw_salsalesorder (or equivalent) to dimension tables (elecustomer, SisSalesMan, eleproduct, …) filtered to the date range and bInvalid=0. Final SELECT runs through the standard pager (Sp_Outstanding_Query shape) with bFilter → WHERE translation and grouping driven by sGroupby_select_sql / sGroupby_group_sql.

Invocation: Standard 报表 data-source signature (17 params ending in sColumnNameConfig OUT). Status: appears orphaned in this snapshot — no gdsconfigformmaster.sSqlStr matches in current DB, no gdsmodule ties it as a procName, no other proc references it, no install-script call beyond the self-defining script/标版/30100101/Sp_SalesOrder_Analysis.sql. The corresponding form is likely customer-seeded; if missing in your tenant, the report won't show. Candidate for maintainer audit to confirm whether a 销售订单分析 form-master row needs to be re-installed.