# `Fun_get_show_config_pup120` (function)

> 根据传入的字段，字段名称，组装显示JSON配置


- **Type:** FUNCTION
- **Returns:** `longtext`
- **Deterministic:** NO
- **SQL data access:** CONTAINS SQL

## Parameters

| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | `sName` | `varchar(50)` |
| 2 | IN | `showName` | `varchar(50)` |
| 3 | IN | `iOrder` | `int` |
| 4 | IN | `sBrId` | `varchar(50)` |
| 5 | IN | `sSuId` | `varchar(50)` |
| 6 | IN | `sParentId` | `varchar(50)` |
| 7 | IN | `sLoginId` | `varchar(50)` |
| 8 | IN | `bVisible` | `int` |
| 9 | IN | `bSum` | `int` |
| 10 | IN | `sColorTerms` | `longtext` |
| 11 | IN | `sActiveId` | `varchar(50)` |
| 12 | IN | `sDropDownType` | `varchar(50)` |
| 13 | IN | `sActiveKey` | `varchar(255)` |

## Body

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

## Narrative

**Business context:** Dynamic-report column-config builder ("动态配置返回函数" family) — "下拉(120宽)" variant. Emits a column-config that renders as a dropdown (`sDropDownType`/`sActiveId`/`sActiveKey` populated) at width 120 in the FROUNT grid.

**What it does:** returns a `JSON_OBJECT` shaped like `_hz` but with `iFitWidth=120` and the dropdown fields populated from `sActiveId`/`sActiveKey`/`sDropDownType`/`sColorTerms` parameters. NULL-safe defaults.

**Invocation:** called by `Sp_Manufacture_CapacityStatistics` (生产管理 → 产能统计报表). No other callers found.
