# `Fun_get_show_config_hz` (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` |

## Body

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

## Narrative

**Business context:** Dynamic-report column-config builder ("动态配置返回函数" family). Base/seed function in the show_config family. Used by analytical procedures that build a result-grid on the fly and need each output column to carry a JSON config block — the same shape that `gdsconfigformslaver` rows would carry if they were declared statically — so FROUNT can render the column with sensible defaults (sortable, visible, no merge, fit-width 80).

**What it does:** returns a single `JSON_OBJECT(...)` containing the standard column-config keys (`sName`, `sChinese`/`sBig5` = `showName`, `iOrder`, `iFitWidth=80`, `bVisible`, `bSum`, etc.) plus tenant fields (`sBrandsId`, `sSubsidiaryId`, `sMakePerson`). NULL-safe defaults via `IFNULL`. `sRelation = 'noQuery'`.

**Invocation:** called by `Fun_get_show_config` (which adds `iFitWidth` override) and by `Sp_SalesOrder_Analysis`. Reached when the report runs from its module entry-point (销售分析 report grid).
