GetPriorProcess (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	sControlId	varchar(100)

Body

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

Narrative

Business context: 得到前道工序 — for a given work-order process row, returns a one-line "prior process" label with a status symbol so 产量上报 / OEE 报工 / APS gantt screens can show at a glance whether the upstream step is done. Glyph legend: ★ = upstream produced output (dProductionReportQty>0), ◎ = upstream's downstream is in state 2, ☆ = pending. Outsourced steps get a (外) suffix.

What it does: reads the current row's iOrder/sType/process-name from MftWorkOrderProcess (treating sType='3' rows as iOrder+10000). Empty result for cutting/制作 leaf steps. For sType 0/1/2 picks the largest-iOrder row that is upstream within the same control group and composes <glyph><processName><outsideFlag>. For sType='3' (special control-group type), it falls back to a control-group view: either reports the prior sType='3' step or aggregates completion (★全部完工 or ☆完工<done>/<total>) across auto-arrange (bAutoArrange=1) processes upstream.

Invocation: referenced by Sp_Manufacture_PlanReport, Sp_Manufacture_ProcessReport, Sp_Manufacture_ProductionPlanInfo12, Sp_Manufacture_ProductionReport, Sp_Manufacture_Report, Sp_OEE_PlanByProcess, Sp_OEE_ProductionReport. Companion of GetNextMachine (downstream-machine list), GetPriorPlate (mould/proof preparation), and GetPriorProcessPlan (prior step's plan-side info). Caveat: one branch references @uGuid/@sCurProcessName (session vars) instead of the proc-local uGuid/p_sCurProcessName — the auto-arrange count branch will always see those vars as NULL unless the caller set them, suggesting copy-paste bug.