# `sp_refreshJur` (procedure)


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

## Parameters

_No parameters._

## Body

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

## Narrative

**Business context:** Platform-admin helper — rebuilds the per-module permission catalog (`gdsjurisdiction`) for every "list-page" module (`gdsmodule.sName LIKE '%indexPage/commonList%'`) so the permission UI reflects the current set of grid-toolbar buttons (`gdsconfigformslave` rows where `sControlName LIKE 'Btn%'`). Twin of `sp_refreshJurBill` (which does the same for billing-form modules).

**What it does:** Cursors through every list-page module, deletes its existing `gdsjurisdiction` rows, ensures `BtnRefresh` and `BtnOut` (导出Excel) jurisdiction rows exist, force-shows `BtnForceComplete` when present, then iterates the form's visible toolbar buttons and upserts a matching `gdsjurisdiction(sId, sParentId=sModuleId, sName=sControlName, sChinese, iOrder)` row per button. Inner commented-out blocks suggest a follow-on `sysjurisdiction` populate that is currently skipped — admins typically run that separately.

**Invocation:** No bindings found. Not referenced by `gdsconfigformmaster.sSqlStr`, no `gdsmodule` hook, no other routine calls it, no xly-src match. Status: appears orphaned — invoked manually by an admin via mysql client during permission-catalog regen; not part of any automated flow. Candidate for maintainer audit.