Sp_OEE_ScanInsertToERP.md 1.88 KB

Edit Raw Blame History



Sp_OEE_ScanInsertToERP (procedure)


@author:zhucx 
                    @date:20210817 封存 
                    @describe:PLC服务器调用


Type: PROCEDURE

Deterministic: NO

SQL data access: CONTAINS SQL


Parameters


#
Mode
Name
Type


1
IN
sBrId
varchar(100)


2
IN
sSuId
varchar(100)


3
IN
sPlcAddr
longtext


4
IN
sValues
longtext


5
IN
p_doDate
varchar(100)


6
IN
sDosIds
longtext


Body

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


Narrative

Business context: OEE / PLC integration — sealed (封存) PLC-to-ERP scan ingester. The procedure's own COMMENT marks it 20210817 封存; production traffic now flows through Sp_OEE_ScanInsertToERP2013, which is the procedure that calls this one. Historically: parses PLC address/value pair strings (sPlcAddr, sValues) into machine + counter readings and writes them back to ERP production tables.

What it does: Accepts sPlcAddr and sValues blobs from the xlyPlc Java service (Siemens PLC reader), tokenises the per-channel values, locates the matching elemachine/work-order rows, and inserts/updates ERP-side counters and event rows. Sealed body is preserved for back-compat but the 2013 variant supersedes it.

Invocation: Called by Java PlcToErpServiceImpl in xlyPlc (assigns String splc = "Sp_OEE_ScanInsertToERP"; then call splc(...)) — Siemens S7 scheduler reads PLC blocks then synchronously executes the proc per machine. Also referenced as a dispatched-call literal by Sp_OEE_ScanInsertToERP2013. Install scripts: script/标版/30100101/schedule/Sp_OEE_ScanInsertToERP.sql and the PLC variant under plcNew/.

Status caveat: marked sealed in body COMMENT — current deployments may route through the 2013 successor instead.