Fun_GetBookStickQty (function)

• Type: FUNCTION
• Returns: decimal(18,6)
• Deterministic: NO
• SQL data access: CONTAINS SQL

Parameters

#	Mode	Name	Type
1	IN	dQty	decimal(18,6)

Body

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

Narrative

Business context: Book-binding glue-allocation rounding rule. In book manufacturing, glue/贴 is dispensed in quarter-unit increments; the planning system rounds fractional sticker quantities to the discrete pour size before charging materials.

What it does: lookup table on dQty: 0.125 → 0.125; 0.25 → 0.25; 0.375 → 0.25; 0.5/0.625/0.75/0.875 → 0.5; all other values pass through unchanged. Returns 0 if NULL.

Invocation: called from Sp_Manufacture_InsertMftPlanBook (book-style manufacturing plan generator) and the formula-engine replace-field family Sp_System_ReplaceField, Sp_System_ReplaceFieldNew, Sp_System_ReplaceField_Detail, Sp_System_ReplaceField_NEW, Sp_System_ReplaceField_NEW_ACT — those procs in turn are driven by BtnCalculationServiceImpl (doSetTimeCalcMachineHour) via the cost-formula module 成本公式.