# `Sp_Bd_cq_workshop_ys_nomes` (procedure)

> @author:zhucx
							@date:20211224 
							@describe: 印刷车间


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

## Parameters

| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | `iFlag` | `int` |
| 2 | IN | `iTmpCheck` | `int` |
| 3 | IN | `sFormGuid` | `varchar(100)` |
| 4 | IN | `sGuid` | `varchar(100)` |
| 5 | IN | `sLoginId` | `varchar(100)` |
| 6 | OUT | `sReturn` | `varchar(4000)` |
| 7 | IN | `sBrId` | `varchar(100)` |
| 8 | IN | `sSuId` | `varchar(100)` |
| 9 | OUT | `sCode` | `int` |

## Body

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

## Narrative

**Business context:** 印刷车间 — non-MES fork of `Sp_Bd_cq_workshop_ys`, same 印刷 (printing) 车间看板 but without MES-integrated work-order joins. Different PLC list `23, 12, 1, 2, 13` (5 PLCs, iNo gap at 5-6 — only positions 1,2,3,4,7 populated).

**What it does:** Same shape as `Sp_Bd_cq_workshop_ys`: hardcodes a PLC list, reads `elemachine`/`plc_currentmachinevalue` per PLC, assembles per-machine 当前状态/工单/产量 tiles into `p_Bd_workshop5`, emits a JSON board into `sReturn`. The MES-specific 工单 lookups are bypassed.

**Invocation:** No form-master sSqlStr, no `gdsmodule` hook, no other-routine caller, no install script under `xly-src/script/`, no Java caller. Status: appears orphan — likely a non-MES fallback that was forked but never wired. Candidate for maintainer audit. The MES-integrated `Sp_Bd_cq_workshop_ys` is the live one.

Flag: PLC list differs entirely from MES sibling (`23,12,1,2,13` vs `1-7`) — possibly targets a different deployment's hardware.
