# `Fun_getInitColumnByProName` (function)

> 根据存储过程名字获取返回字段


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

## Parameters

| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | `sProductName` | `varchar(100)` |

## Body

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

## Narrative

**Business context:** Dispatcher that returns the canonical column list for a stored-procedure-backed report given its name. Wired into the metadata-config tooling under `gdsconfigtb*` — when an admin generates the SQL script for a report-style proc, the platform asks this function which columns to declare in the wrapper.

**What it does:** a long chain of `IF lower(sProductName) = lower('Sp_…') THEN @sColumns := 'sId,…' ; RETURN @sColumns;` blocks. Each branch hard-codes the master+slave column union for one report proc — `Sp_Sales_NotDeliverGoodList`, `Sp_BillOfNoPicking`, `Sp_Receivables_AR*`, `Sp_Payables_AP*`, `Sp_NotPayables`, `Sp_NotReceivables`, `Sp_Inventory_InOutStore`, `Sp_Inventory_ProductInOutStore`, `Sp_Manufacture_Production*`, `Sp_Cashier_OrderMoneyWarning`, `Sp_Element_ProduceReportSum`, `SP_DeliverGoods_Warning`, etc. Pure string concatenation; no table access.

**Invocation:** called by MyBatis mapper `GdsconfigtbMapper.getInitColumnByProName` (`select Fun_getInitColumnByProName(#{sTbName}) as sColumns…`) during gdsconfigtb script generation for the named report procedure.