Sp_Manufacture_TeamEmployee (procedure)
- Type: PROCEDURE
- Deterministic: NO
- SQL data access: CONTAINS SQL
Parameters
| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | sBrId |
varchar(100) |
| 2 | IN | sSuId |
varchar(100) |
| 3 | OUT | sCode |
int |
| 4 | OUT | sReturn |
varchar(255) |
Body
Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURESpManufacture_TeamEmployee'._
Narrative
Business context: 生产管理 — utility lookup that returns the per-machine 班组 (team) + 员工 (employee) + 岗位 (position) roster for currently-scheduled production-plan rows. Used to drive a dropdown / picker for "who is at this machine right now" in the manufacturing UI.
What it does: Drops and re-creates the temp table TeamEmployeeTmp, then Insert into TeamEmployeeTmp rows from mftproductionplanslave A JOIN eleteamemployee B ON A.sTeamId = B.sParentId restricted to sMachineId<>'' and sState NOT IN (0,5) (skip 撤单 / 未排程). Several UPDATE TeamEmployeeTmp ... JOIN elemachine / eleteam / eleemployee / sisposition calls back-fill the display names. Final SELECT * FROM TeamEmployeeTmp returns the result set to the caller.
Invocation: No caller found in any channel — no gdsmodule hook, no form-master binding, no other proc CALLing it, no xly-src reference. Status: appears orphaned. Probably an unused lookup helper kept from an earlier UI iteration; candidate for maintainer audit.