# `Fun_GetTrunkQty` (function)

> 获取TrunkQty


- **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_GetTrunkQty`'`._

## Narrative

**Business context:** Trunk/箱 count estimator for OEE finished-goods labelling (生产管理 → OEE → 打印成品标签(OEE), form sId `16054917120005195223325896784000`). Given a product style code (paper-size names like `A4`, `A3`, `8开`, or millimetre styles like `210*285`) and a piece count, returns how many shipping trunks the run will fill.

**What it does:** big `CASE` over `LOCATE(<style-tag>, p_sProductStyle) > 0`: A5/210*140/32开/A4/210*285/16开 → `CEIL(qty/5000)`; A3/285*420/8开/A2/420*570/4开/A1/570*870/2开 → `CEIL(qty/2500)`; otherwise `NULL`. Returns the integer trunk count.

**Invocation:** referenced by the OEE label-print form-master sSqlStr at sId `16054917120005195223325896784000` (生产管理 → OEE → 打印成品标签(OEE)). The xly-src copy lives under `script/标版/30000101/Fun_GetTrunkQty.sql` and the form-master upgrade script under `script/标版/20210323/gdsconfigformmaster.sql`. The conversion ratios are hard-coded paper-product values; non-paper businesses will see `NULL`.
