# `Sp_Create_sControlFaceNameTable` (procedure)

> 插入ControlFaceName


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

## Parameters

| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | `p_sControlFaceName` | `longtext` |
| 2 | IN | `p_iArrangeSrcValue` | `int` |

## Body

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

## Narrative

**Business context:** 生产管理 → 排版/拼版 (printing imposition layout) — entry point of the 控版面名 (`sControlFaceName`) splitter. Parses a printer's signature/imposition string such as `A`, `A+B`, `A+B,C+D` or `1+2-9+10` into a row-per-signature temp table that downstream 排程/拼版 code reads when generating per-fold signature plans.

**What it does:** Drops and recreates the `sControlFaceName_tmp` TEMPORARY TABLE (columns: `iIndex`, `sControlFaceNameNum`, `sControlFacesChar`, `sId`, `dSumPQtyBs`), normalises punctuation (`_`/`——` → `-`, `、`/`，` → `,`, `(`/`)` → `[`/`]`, drops the `贴` suffix, rewrites `+2P粘页` → `~2P粘页`), then branches on `p_iArrangeSrcValue` (3/4/2 take the multi-signature path) and delegates to `Sp_Create_sControlFaceNameTableOne`…`Five` for the `A`, `A,B`, `A+B`, `A+B-C+D`, `A+B,C+D` shapes, accumulating rows into `sControlFaceName_tmp`.

**Invocation:** Called by `Sp_Create_sControlFaceNameTableFour` and `Sp_Manufacture_InsertMftPlanSlave` — i.e. it is the public entry point used during 制造计划 slave creation to materialise the signature breakdown for each plan row.
