Sp_OutSideProcess_ProgressOfImplementation (procedure)

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

Parameters

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

Body

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

Narrative

Business context: 外协管理 → 分析报表 → 外加工执行情况 — paged execution-progress report that, for each outsourced 工序 line, lists the master bill, customer, supplier, work-order, process, the quantities, costs and the 到货 (arrival) timestamps + receiver, so ops can audit how each outsourced step is progressing.

What it does: Builds the temp table P_tmpTable with the full reporting shape (bill no, dates, supplier, customer, product, order/work-order, process, quantities, prices, money, arrival columns, etc.), populates it from the outsourcing slave tables joined to customers/products/processes, applies Fun_bFilter_toWhere translation of bFilter, paginates with pageNum/pageSize, and feeds the standard countCloumn/sGroupby_* framework so the front-end gets paged rows plus per-column totals via countMapJson.

Invocation: Bound as the data-source of the 外加工执行情况 form gfm.sId=19211681019715708477023400 via gdsconfigformmaster.sSqlStr — module 外加工执行情况 under 分析报表 → 外协管理. Loaded when the user opens the report. Install scripts ship at script/标版/30100101/Sp_OutSideProcess_ProgressOfImplementation.sql and a perf patch under script/标版/20210323/optimizeprocedure.sql.