GetPriorPlate (function)

得到模具或蓝纸准备情况

• Type: FUNCTION
• Returns: text
• Deterministic: NO
• SQL data access: CONTAINS SQL

Parameters

#	Mode	Name	Type
1	IN	sPlanId	varchar(100)
2	IN	uGuid	varchar(100)
3	IN	uProcessGuid	varchar(100)
4	IN	sControlId	varchar(100)
5	IN	sBrId	varchar(100)
6	IN	sSuId	varchar(100)

Body

Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE FUNCTIONGetPriorPlate'.

Narrative

Business context: 得到模具或蓝纸准备情况 — for an APS gantt row (a MftProductionPlanSlave), returns a one-line preparation-status string for the prior plate/mould/proof step. Examples: "模切刀(外)发外", "调墨OK 12号08:30(3)", "<NN>组 专色待调", "<processName> 待发外". Drives the "状态" column on APS scheduling boards so planners see whether the mould / blueprint / ink is ready before letting the current job start.

What it does: reads the current MftWorkOrderProcess row to get sType and process name. Branches on process name keyword (模切/凹凸/烫金 → look up the prior 刀版/模具 step in mftworkorderprocess; otherwise → look up the prior 蓝纸/制版 step). For each candidate prior step, joins to opsoutsideprocessmaster/opsoutsideinstoreslave to check outsourcing-receipt status, and to mftproductionplanslave to check tMakeup (ink-mixing done time). Composes a Chinese status fragment depending on what's missing. For the special sType='1' ink-prep case, formats 调墨OK<date>(<dCalcQty2>组) or <dCalcQty2>组 专色待调.

Invocation: referenced by Sp_Manufacture_GetAPSState (the APS state-column builder used by 排产 gantt). Also referenced in xly-src schedule/Sp_Manufacture_GetAPSstate.sql. Companion of GetPriorProcess, GetPriorProcessPlan, and GetNextMachine — the family of upstream/downstream context functions for APS rows.