Fun_GetCalcMaterialsKs (function)

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

Parameters

#	Mode	Name	Type
1	IN	dMatLength	decimal(18,6)
2	IN	dMatWidth	decimal(18,6)
3	IN	dLength	decimal(18,6)
4	IN	dWidth	decimal(18,6)

Body

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

Narrative

Business context: Sheets-per-stock estimator (Ks = 开数, the printing trade's "ups count"): given a parent sheet dMatLength × dMatWidth and a finished piece dLength × dWidth, returns how many finished pieces can be cut from one parent sheet. Used by the quotation and work-order calculation procs to derive material consumption.

What it does: simple axis-aligned packing — returns (dMatLength div dLength) * (dMatWidth div dWidth). The full mixed-orientation packing logic (vertical + horizontal arrangements) is commented out in the body, leaving only the straight tile. Fun_GetCalcMaterialsKs1 is the kept-alive richer variant that the commented branches would have called.

Invocation: invoked by the quotation calc family (Sp_Quotation_CalcDataBookStd, _CalcDataFlex, _CalcDataPackStd, _CalcDataSetStd, _CalcDataStd, _CalcDataPackLastStd, _CalcDataPackLastStd_zr, _CalcDataPackPartsStd) and the work-order calc family (Sp_WorkOrder_CalcDataBookStd, _CalcDataFlex, _CalcDataPackLastStd, _CalcDataPackPartsStd_child, _CalcDataPackStd, _CalcDataSetStd, _CalcDataStd, _CalcDataStdBeforeAfter, _CalcDataStdCenterProcess, _CalcDataStdCenterPrsAfter) — all of which sit on the 报价&估计管理 quotation modules and the 轮转工单/合版工单 work-order modules.