Sp_Create_sControlFaceNameTable.md 1.59 KB

Edit Raw Blame History



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 PROCEDURESpCreate_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.