Sp_bd_TeamDayMonthCompare1 (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_TeamDayMonthCompare1'._
Narrative
Business context: 看板管理 — "时间嫁动率(分组报表)机台" tile. Identical-shape sibling of Sp_bd_TeamDayMonthCompare for the team-level board.
What it does: Same body as Sp_bd_TeamDayMonthCompare — hard-codes value 89% for all eight series (本班/本月 × 速度稼动率/时间稼动率/OEE效率/计划达标率) into p_bd_tmTime and serialises to JSON via OUT sReturn. No table lookups; input params are unused.
Invocation: No install script in xly-src, no form-master, no gdsmodule hook, no Java caller, no other-routine caller. Reached only by an external dashboard HTTP endpoint that calls the proc by name. The output is entirely demo data — verify before relying on it.