# `Sp_MachinePoweranalysis_2` (procedure)

> 机台用电分析_折线


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

## Parameters

| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | `sLoginId` | `varchar(100)` |
| 2 | IN | `tStartDate` | `datetime` |
| 3 | IN | `tEndDate` | `datetime` |
| 4 | IN | `p_sMachineId` | `varchar(100)` |
| 5 | IN | `sBrId` | `varchar(100)` |
| 6 | IN | `sSuId` | `varchar(100)` |
| 7 | IN | `bFilter` | `varchar(5000)` |
| 8 | OUT | `sCode` | `int` |
| 9 | OUT | `sReturn` | `longtext` |

## Body

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

## Narrative

**Business context:** 生产管理 → 设备能耗看板 — single-machine 折线 dashboard chart returning the last ~25 hours of 度数 (`dElectricityQty`) on a 10-minute grid from `plc_machinedata`. Companion of `Sp_MachinePoweranalysis_1` (pie).

**What it does:** Treats `tEndDate` as "now" (truncated to the minute), seeds a 150-row `p_index` temp filled with 10-minute slots back to `tEndDate - 1500 min` (~25h). Walks `plc_machinedata` rows for `p_sMachineId` in the window via a cursor and distributes each row's `dElectricityQty` across the overlapping `p_index` slots (the proc reuses `Sp_MachineSpeedanalysis_2`-prefixed temp-table names — sibling layout, no CALL). Returns `sReturn` as a chart-master `{"data":[{x:tCreateDate, y:dRate}, …]}` JSON via `GROUP_CONCAT`.

**Invocation:** Status: appears orphaned. No `gdsconfigcharmaster.sProcedureName` binding, no `gdsmodule.sProcName`, not referenced by any other routine (only sibling temp-table name re-use), not present in xly-src. Output shape matches dashboard chart conventions — candidate for maintainer audit to confirm which chart tile owns it.