Sp_init_groupConfig.md 1.55 KB

Sp_init_groupConfig (procedure)

初始化界面显示

  • Type: PROCEDURE
  • Deterministic: NO
  • SQL data access: CONTAINS SQL

Parameters

# Mode Name Type
1 IN s_sGroupId varchar(100)
2 IN sBrId varchar(100)
3 IN sSuId varchar(100)

Body

Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURESpinit_groupConfig'._

Narrative

Business context: 权限管理 / 初始化界面显示 — clones the per-user form-display layout (column visibility / fit-width / order) from one permission-group template s_sGroupId to every other group in the same tenant. Used so a newly-created 权限分类 (permission-classify) group inherits a sane default UI configuration from a reference group.

What it does: Cursors over sisjurisdictionclassify WHERE sId <> s_sGroupId for the (sBrId,sSuId) tenant. For each target group, DELETE FROM gdsconfigformuserslave WHERE sJurisdictionClassifyId=<target>, then INSERT INTO gdsconfigformuserslave copying every (iOrder, sName, sUserId, showName, iFitWidth, bVisible) row from the source group, swapping sJurisdictionClassifyId to the target. Destructive at the column-config level — replaces the target group's existing display config.

Invocation: Status: appears orphaned. No form-master, gdsmodule hook, workflow, or other-routine reference; not found in xly-src. Likely intended as a manual one-time admin call during permission setup; verify before relying on it from new code.