Sp_title_CommonModel1 (procedure)
通用界面自定义模板1
- Type: PROCEDURE
- Deterministic: NO
- SQL data access: CONTAINS SQL
Parameters
| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | sLoginId |
varchar(100) |
| 2 | IN | sBrId |
varchar(100) |
| 3 | IN | sSuId |
varchar(100) |
| 4 | IN | bFilter |
varchar(5000) |
| 5 | OUT | sCode |
int |
| 6 | OUT | sReturn |
varchar(5000) |
Body
Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURESptitle_CommonModel1'._
Narrative
Business context: 通用界面自定义模板1 (per the proc COMMENT) — sample/demo data-source for a generic UI title-card template. Returns a static name/value pair list ("A1"→"1"…"A6"→"6", "B"→"36度", "C"→"56%") to fill a card-style widget on the home dashboard.
What it does: Defaults its IN params, creates temp table p_CommonModel1 (sName, sValue), inserts the eight hard-coded sample rows, and SELECT * FROM p_CommonModel1.
Invocation: No callers found in any channel — gdsmodule, form-master, other routines, and full xly-src grep all empty (only the install script script/标版/30100101/Sp_title_CommonModel1.sql). Status: appears orphaned — a shipped sample/template that no live form binds. Candidate for maintainer audit.