Fun_GetMachineLenWidthAPS (function)

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

Parameters

#	Mode	Name	Type
1	IN	sMachineLength	int
2	IN	sMachineWidth	int
3	IN	dMaxLength	int
4	IN	dMaxWidth	int
5	IN	dMinLength	int
6	IN	dMinWidth	int

Body

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

Narrative

Business context: APS (advanced planning) machine-eligibility check — given a sheet's sMachineLength/sMachineWidth and a candidate machine's (dMin..dMax) × (dMin..dMax) window, returns 1 when the sheet falls outside the window (i.e. the machine is unsuitable), else 0.

What it does: Sorts length ≥ width, then flags out-of-range against the four limits in either orientation.

Invocation: Called by Sp_GetMachineByApsRule — the procedure that ranks/filters machines when auto-assigning a work order to a press, comparing the order's sheet size against each machine's configured min/max. Parameterised replacement for the now-orphan Fun_GetMachineLenWidth.