# `Sp_report_test` (procedure)

> @author:  qmj
								@date:20210714  封存
								@describe :     机台负荷
								各机台后推14天展示排产工时，并显示机台负荷状态


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

## Parameters

| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | `sParentId` | `varchar(50)` |
| 2 | OUT | `iCount` | `int` |

## Body

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

## Narrative

**Business context:** Test/scratch proc — body COMMENT marks it as `@author: qmj` / `@date: 20210714 封存` (sealed/retired on 2021-07-14). Originally probed `mftworkorderslave` joined to `elecustomer` and returned customer names per work-order — kept around as a reference snippet for the 机台负荷 dashboard work.

**What it does:** Creates TEMP `p_tmp_T(sOrderNo, sCustomerName, sCustomerId)`, inserts `(sOrderNo, sCustomerId) FROM mftworkorderslave WHERE sParentId = sParentId`, then `UPDATE p_tmp_T INNER JOIN elecustomer ON sCustomerId = sId SET sCustomerName = sCustomerName`, sets `iCount = 111` (placeholder), and returns the temp table.

**Invocation:** Status: appears orphaned — intentionally so. The body comment marks the proc as `封存` (retired) by author `qmj` on 2021-07-14; no caller exists in `gdsmodule`, form-master, other routines, or xly-src. Safe to drop on the next cleanup pass.
