Sp_bd_TmComplianceRate3 (procedure)
产量达标率
- Type: PROCEDURE
- Deterministic: NO
- SQL data access: CONTAINS SQL
Parameters
| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | sLoginId |
varchar(100) |
| 2 | IN | sBrId |
varchar(100) |
| 3 | IN | sSuId |
varchar(100) |
| 4 | IN | bFilter |
varchar(5000) |
| 5 | OUT | sCode |
int |
| 6 | OUT | sReturn |
longtext |
Body
Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURESpbd_TmComplianceRate3'._
Narrative
Business context: 看板管理 / 产量达标率 — third-group variant of Sp_bd_TmComplianceRate for machines with elemachine.iPlcNo 29-40 (final rotary-press group). Identical logic, identical four-shift buckets, identical JSON output shape.
What it does: Same body as Sp_bd_TmComplianceRate with the PLC filter shifted: elemachine.iPlcNo > 28 AND iPlcNo < 41. Outputs each machine's output / team-target ratio per 昨日白班 / 昨日晚班 / 今日白班 / 今日晚班 bucket.
Invocation: Installed by xly-src/script/标版/30100101/Sp_bd_TmComplianceRate3.sql. No form-master sSqlStr, no gdsmodule hook, no other-routine caller, no Java caller — reachable only via an external dashboard HTTP endpoint.