# `Sp_Sys_GetMenu` (procedure)

> 根据模块sId删除模块（包含子模块）
需要执行：SET GLOBAL group_concat_max_len = 40960


- **Type:** PROCEDURE
- **Deterministic:** NO
- **SQL data access:** CONTAINS SQL

## Parameters

| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | `s_sbid` | `varchar(255)` |
| 2 | IN | `s_ssid` | `varchar(255)` |
| 3 | IN | `s_sLanguage` | `varchar(255)` |
| 4 | IN | `s_pSid` | `varchar(255)` |
| 5 | IN | `p_auSid` | `varchar(255)` |

## Body

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

## Narrative

**Business context:** 系统平台 → 菜单 — returns the menu tree (one branch at a time) for the BACK side-bar of the logged-in user, scoped to the current brand/subsidiary. The proc itself doesn't apply role-authorisation; that's layered by the calling Java service.

**What it does:** When `s_pSid` is empty, selects all root-level `gdsmodule` rows (`sParentId=''`) for the current `sBrandsId`/`sSubsidiaryId`, excluding `sDisplayType='System'` and the reserved sId `'100'`, ordered by `iOrder`. When `s_pSid` is given, selects descendants by `LOCATE(CONCAT('-', s_pSid), m.sAllId) > 0`. The `sMenuName` output column picks `sChinese`/`sEnglish`/`sBig5` based on `s_sLanguage`. Despite the auto-catalog header comment ("根据模块sId删除模块"), the body is a read-only SELECT — only the comment is misleading.

**Invocation:** Called by MyBatis `GdsmoduleMapper.getBuMenu` (`{call Sp_Sys_GetMenu(...)}`), wired into Java `MenuServiceImpl.getBuMenu(param)` — `@Cacheable(value="getBuMenu")` per `(sUserId, sBrandsId, sSubsidiaryId)`. Also referenced by `CleanRedisServiceImpl`, `BusinessParameterImpl`, `MenuChildServiceImpl`, `BusinessBaseService` for cache invalidation of the same key. Install script: `script/标版/30100101/Sp_Sys_GetMenu.sql`.