Sp_Element_ProduceReportSum (procedure)

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

Parameters

#	Mode	Name	Type
1	IN	bSum	int
2	IN	iType	int
3	IN	sEmployeeGuid	varchar(100)
4	IN	sMachineGuid	varchar(100)
5	IN	sProcessGuid	varchar(100)
6	IN	sTeamGuid	varchar(100)
7	IN	sPalletGuid	varchar(100)
8	IN	tStartDate	datetime
9	IN	tEndDate	datetime
10	IN	sWhere	varchar(100)
11	IN	bJyOee	int
12	IN	sLoginId	varchar(100)
13	IN	sBrId	varchar(100)
14	IN	sSuId	varchar(100)
15	IN	bFilter	varchar(5000)
16	IN	pageNum	int
17	IN	pageSize	int
18	OUT	totalCount	int
19	IN	countCloumn	varchar(5000)
20	OUT	countMapJson	longtext
21	IN	sFilterOrderBy	varchar(5000)
22	IN	sGroupby_select_sql	varchar(5000)
23	IN	sGroupby_group_sql	varchar(5000)

Body

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

Narrative

No human-written narrative yet.