GetPriorProcessPlan (function)

得到上道工序生产情况

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

Parameters

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

Body

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

Narrative

Business context: 得到上道工序生产情况 — for a current APS gantt row, builds the "prior process production status" text the planner sees on the schedule board. Shape: <priorProcessName>-<reportTime>(qty)/<startTime> or <priorProcessName>-未生产/无计划 if the upstream step has neither been reported nor scheduled. Walks back through 蓝纸确认 → 文件制作 → upstream sType<3 steps in priority order so the planner always sees the most relevant blocker first.

What it does: reads the current MftWorkOrderProcess row (iOrder, sType, sCombinePartsName). When sType='1' (印刷/main process), looks for prior steps with eleprocess.sProcessPhase = '蓝纸确认' in the same control group, joins to the matching mftproductionplanslave row (sWorkOrderProcessTbId match), formats processName-<报工时间(qty)>/<计划时间>. If nothing useful is found, falls back to 文件制作, then to any non-control prior step, then (when sCombinePartsName is set) widens to combined parts via mftworkordercontrolcombine. Each fallback uses the same (@rownum/@rank/@sPsId) ranking trick to pick the latest row per control group.

Invocation: referenced by Sp_Manufacture_GetAPSState — embedded in the APS state-column builder alongside GetPriorPlate and GetPriorProcess. Same module path: 工作中心 → 生产管理 → 排产 (APS gantt). Also referenced in xly-src script/标版/30100101/schedule/Sp_Manufacture_GetAPSstate.sql.