# `Fun_GetPackQty` (function)

> 获取PackQty


- **Type:** FUNCTION
- **Returns:** `varchar(100)`
- **Deterministic:** NO
- **SQL data access:** CONTAINS SQL

## Parameters

| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | `p_sProductStyle` | `varchar(255)` |
| 2 | IN | `p_dProductQty` | `decimal(18,6)` |

## Body

_Body is not pre-cached. To inspect: `mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE FUNCTION `Fun_GetPackQty`'`._

## Narrative

**Business context:** OEE管理 → 打印成品标签(OEE) — when printing finished-product carton labels, decides how many pieces go into one pack based on the product's paper size (A5/A4/A3/A2/A1, 32开/16开/8开/4开/2开, or explicit `WxH` like `210*140`, `285*210`, `570*870`) so each carton stays under a per-size cap (5000, 2500, or 2000 pieces, scaled by `CEIL(qty/cap)`).

**What it does:** A large `CASE` keyed on `LOCATE(<size>, p_sProductStyle)`; for each size class, returns either the full qty when it fits in one carton, or `qty / CEIL(qty / cap)` (an even split into the minimum number of cartons). Unknown styles return `null`.

**Invocation:** Embedded in form `gdsconfigformmaster.sId='16054917120005195223325896784000'` (parent module `打印成品标签(OEE)` → `OEE管理`), alongside the sibling `Fun_GetTrunkQty`, against `mftworkorderslave` + `eleproduct`.