Sp_Quality_Materials (procedure)

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

Parameters

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

Body

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

Narrative

Business context: 质量管理 — would serve a materials-inspection pass-rate report grouped by 材料分类 (sismaterialsclassify), with one row per material category plus a 总计 grand-total row. Date-window driven (tStartDate/tEndDate), scoped to the two 来料检验单 form-ids 15827054010002527067474512475000 and 12012615914116374731613080.

What it does: Counts batches in qlycomematerialstestmaster (filtered by sBrId/sSuId/sFormId/tCreateDate window), joined to elematerials to roll up by sParentId. Builds temp p_TempTable (sSlaveId, sMaterialsClassifyId, sMaterialsClassifyName, iCount, iDisqualified, sRate, sMemo); a parallel temp p_TempTable1 re-runs the same scan filtered to iTestResult=1 for the disqualified count, then UPDATE-joins to merge. sRate = ROUND((iCount-iDisqualified)/iCount*100,2) || '%'. Appends a synthetic 总计 row with sMaterialsClassifyId='111111'. Returns via dynamic SELECT * FROM p_TempTable — note the proc never calls a paging helper despite declaring page_num/page_size/totalCount/countMapJson parameters.

Invocation: No gdsconfigformmaster.sSqlStr binding, no gdsmodule hook, no other routine references it, and grep -rln on xly-src returns nothing. Status: appears orphaned; candidate for maintainer audit.