Sp_Reachingrate_Machine (procedure)

@author:zhucx

    @date:20210621 封存

    @describe: 班组-机器计划达标率分析

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

Parameters

#	Mode	Name	Type
1	IN	sAttribute	varchar(100)
2	IN	tBetweenDate	varchar(100)
3	IN	sPMachineID	varchar(100)
4	IN	sProcessId	varchar(100)
5	IN	sWorkCenterId	varchar(100)
6	IN	sType	char(1)
7	IN	sBrId	varchar(100)
8	IN	sSuId	varchar(100)
9	IN	sLoginId	varchar(100)
10	IN	bFilter	varchar(5000)
11	IN	pageNum	int
12	IN	pageSize	int
13	OUT	totalCount	int
14	IN	countCloumn	varchar(5000)
15	OUT	countMapJson	longtext
16	IN	sFilterOrderBy	varchar(5000)
17	IN	sGroupby_select_sql	varchar(5000)
18	IN	sGroupby_group_sql	varchar(5000)

Body

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

Narrative

No human-written narrative yet.