# `Fun_get_show_config` (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 | `iFitWidth` | `int` |

## Body

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

## Narrative

**Business context:** Dynamic-report column-config builder ("动态配置返回函数" family). Thin wrapper around `Fun_get_show_config_hz` that lets callers override the default column width (`iFitWidth`) — used in dynamic-grid reports where some columns need a wider/narrower fit than the default 80.

**What it does:** calls `Fun_get_show_config_hz` with the supplied parameters (and `bSum=0` forced), then `JSON_REMOVE` the existing `iFitWidth` field and `JSON_MERGE` the caller-specified width back in. Returns the modified JSON.

**Invocation:** called by `Fun_get_show_config_sear` and by `Sp_CostAccount_CostCarryForward`, `Sp_CostAccount_WorkCenterToOperation`, `Sp_EquipmentOutput_Machine`, `Sp_EquipmentOutput_Machine_YH`, `Sp_Manufacture_CapacityStatistics`, `Sp_mes_Timeanalyse_Machine`, `Sp_MftPlan_MachineProcessLodading`, `Sp_SalesOrder_Analysis`. Reached from each report's button-click / open-form flow.
