# `Sp_eptmachinemaintenance_OEE` (procedure)

> 维修后机长确认


- **Type:** PROCEDURE
- **Deterministic:** NO
- **SQL data access:** CONTAINS SQL

## Parameters

| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | `sProInParam` | `varchar(10000)` |
| 2 | IN | `sMakePerson` | `varchar(100)` |
| 3 | IN | `sUserId` | `varchar(100)` |
| 4 | IN | `sMachineId` | `varchar(255)` |
| 5 | IN | `sBrId` | `varchar(100)` |
| 6 | IN | `sSuId` | `varchar(100)` |
| 7 | OUT | `sReturn` | `varchar(1000)` |
| 8 | OUT | `sCode` | `int` |

## Body

_Body is not pre-cached. To inspect: `mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURE `Sp_eptmachinemaintenance_OEE`'`._

## Narrative

**Business context:** 维修后机长确认 — machine-operator (机长) confirmation step after equipment maintenance is completed. Sibling of `Sp_eptmachinemaintenance_Lader`: where that one stamps the 领导 sign-off, this one stamps the 机长 sign-off on selected 设备维修单 rows.

**What it does:** Parses `sProInParam` JSON for `$.params[*].value[*].sId` (selected row IDs) and `UPDATE eptmachinemaintenancemaster SET bCommand=1, sCommandPerson=sMakePerson, tCommandDate=NOW() WHERE sId=p_sId` per row. On `LENGTH(sProInParam)<5` aborts with `sReturn` from `Sp_Sis_GetConst('paramsErro', ...)` and `sCode=-1`. Despite the `_OEE` suffix the body has no OEE math — only the flag stamp.

**Invocation:** Status: appears orphaned. Not bound to any gdsmodule hook, no form-master reference, no other routine references it, no xly-src reference. Same generic-procedure-call signature as the 领导 variant; likely intended as the 机长确认 grid button on the 设备维修 form but never wired. Candidate for maintainer audit alongside `Sp_eptmachinemaintenance_Lader`.
