Sp_Reachingrate_Machine.md 1.28 KB

Edit Raw Blame History



Sp_Reachingrate_Machine (procedure)


@author:zhucx             @date:20210621 封存             @describe: 班组-机器计划达标率分析


Type: PROCEDURE

Deterministic: NO

SQL data access: CONTAINS SQL

Created: 2026-04-27 19:10:43

Last altered: 2026-04-27 19:10:43


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.