Sp_Manufacture_CapacityStatistics (procedure)

@author: qmj

                            @date:20210714  封存

                            @describe :     机台负荷

                            各机台后推14天展示排产工时，并显示机台负荷状态

• Type: PROCEDURE
• Deterministic: NO
• SQL data access: CONTAINS SQL
• Created: 2026-04-27 19:10:36
• Last altered: 2026-04-27 19:10:36

Parameters

#	Mode	Name	Type
1	IN	sLoginId	varchar(4000)
2	IN	sAttribute	varchar(100)
3	IN	sMachineName	varchar(100)
4	IN	sProcessName	varchar(100)
5	IN	sWorkcenterName	varchar(100)
6	IN	iType	char(1)
7	IN	tStartDate	datetime
8	IN	tEndDate	datetime
9	IN	sBrId	varchar(100)
10	IN	sSuId	varchar(100)
11	IN	bFilter	varchar(5000)
12	IN	pageNum	int
13	IN	pageSize	int
14	OUT	totalCount	int
15	IN	countCloumn	varchar(5000)
16	OUT	countMapJson	longtext
17	IN	sFilterOrderBy	varchar(5000)
18	IN	sGroupby_select_sql	varchar(5000)
19	IN	sGroupby_group_sql	varchar(5000)
20	OUT	sColumnNameConfig	longtext

Body

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

Narrative

No human-written narrative yet.