getModuleKeyPro (procedure)
根据sId获取模块在树种的key
- Type: PROCEDURE
- Deterministic: NO
- SQL data access: CONTAINS SQL
Parameters
| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | sbid |
varchar(255) |
| 2 | IN | ssid |
varchar(255) |
| 3 | IN | id |
varchar(255) |
Body
Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDUREgetModuleKeyPro'.
Narrative
Business context: 系统管理 / 模块树 — translates a single gdsmodule.sId to its full hierarchical "key" path (0-<root>-<parent>-...-<leaf>). Lets the front-end module-tree UI auto-expand to a specific module when a user navigates by deep-link or after edit.
What it does: Walks gdsmodule.sParentId upward from id, prepending each ancestor's sId to the running key, and returns SELECT CONCAT('0', '-', p_key) AS pkey as a single-row resultset.
Invocation: Reached from GdsmoduleServiceImpl.getModuleKeyPro() via DAO GdsmoduleDao.getModuleKeyPro and MyBatis mapper GdsmoduleMapper.xml (<select id="getModuleKeyPro" statementType="CALLABLE">). HTTP endpoint GdsmoduleController.getModuleKeyPro() at GET /getModuleKeyPro.