# `Sp_GET_OeeFistOneDataByMachineId` (procedure)

> OEE获取第一条数据


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

## Parameters

| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | `sPlcId` | `varchar(100)` |
| 2 | IN | `sReportTag` | `varchar(10)` |
| 3 | IN | `sBrId` | `varchar(100)` |
| 4 | IN | `sSuId` | `varchar(100)` |
| 5 | OUT | `sCode` | `int` |
| 6 | OUT | `sReturn` | `longtext` |

## Body

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

## Narrative

**Business context:** OEE 看板 / 报工 (Overall Equipment Effectiveness, shopfloor terminal). Header banner `OEE获取第一条数据`. Returns the latest `plc_machinedata` row for a machine plus the rolling adjust/produce/abnormal-time totals since the last production-report tCreateDate — used by the OEE terminal to bootstrap the screen and by the 上报 button to compute the time deltas it will write back.

**What it does:** With `sReportTag='1'` (the 上报按钮 path): looks up the latest `plc_machinedata` row for `sMachineId` to get `p_sPlcDateId, p_sPlanSlaveId`; reads `viw_mftproductionreport` for the last report `tCreateDate` (`p_tlastreportDate`). Then aggregates `plc_machinedata` per machine + plan-slave between `p_tlastreportDate` and now into three totals: `p_dAdjustHour, p_dAdjustQty` from rows with `sStatus='adjustment'` and `dHour*60 > 1`; `p_dHour` from `sStatus IN ('startWorking','waitingWork','doWorkEnd')`; `p_dAbnormalHour` from stops over 15 minutes. Returns these alongside the latest PLC snapshot.

**Invocation:** Called from Java by three call sites — all use `procedureService.getDoProMap("Sp_GET_OeeFistOneDataByMachineId", …)` + `procedureService.getCallPro(…)`:
- `LoginController.userOeelogin(...)` (`/userOeelogin/{sBrandsId}/{sSubsidiaryId}/{sTeamId}/{sMachineId}`) — bootstrap when the operator logs in at the machine terminal.
- `OeeServiceImpl` (~line 459) — main OEE service refresh.
- `OeeHandleServiceImpl` (~line 1022) — used by the 上报 handler.
xly-src ships `script/标版/30100101/schedule/Sp_GET_OeeFistOneDataByMachineId.sql`.