Sp_Calc_sPctOEE (procedure)

@author:zhucx @date:2021.11.21 封存 @describe: 1.移动端-生产首检-保存自动调用本过程,当系统设定中本单据为自动审核时

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

Parameters

#	Mode	Name	Type
1	IN	iFlag	int
2	IN	iTmpCheck	int
3	IN	sFormGuid	varchar(100)
4	IN	sGuid	varchar(100)
5	IN	sLoginId	varchar(100)
6	OUT	sReturn	varchar(4000)
7	IN	sBrId	varchar(100)
8	IN	sSuId	varchar(100)
9	OUT	sCode	int

Body

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

Narrative

Business context: Audit handler for an OEE-side 生产首检 doc on QlyProcessTestMaster. Header authorship: zhucx 2021.11.21 封存. Same business shape as Sp_Calc_sPct3 (OEE 机长首检登记) — validates the inspection master, flips audit flags, and joins through plc_machinedata to mark mftproductionplanslave.bFirst1Inspection=1. Likely the original name before the production-bound version was renamed to Sp_Calc_sPct3.

What it does: Validates sGuid, guards on bInvalid and on existing bCheck. Additionally checks SysLocking (refuses when the doc is row-locked, returning the localised SysLocking error). On iFlag=1 it Updates QlyProcessTestMaster to set the audit fields and joins through plc_machinedata ← QlyProcessTestMaster to flag mftproductionplanslave.bFirst1Inspection=1. iFlag=0 reverses the flags.

Invocation: Status: appears orphaned. The live OEE 机长首检登记(OEE) module (sId 12012615914116373127639240) is bound to Sp_Calc_sPct3, not Sp_Calc_sPctOEE. No gdsmodule.sProcName/sSaveProName, gdsconfigformmaster form-master, sibling routine, or xly-src reference picks Sp_Calc_sPctOEE. Candidate for maintainer audit — almost certainly a superseded predecessor of Sp_Calc_sPct3.