# `Sp_Customerlist_BtnEventUnCheck1` (procedure)

> @author:zhucx 
		     @date:20210521 封存 
				 @describe:客户审核界面 1级消审


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

## Parameters

| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | `sProInParam` | `varchar(10000)` |
| 2 | IN | `sMakePerson` | `varchar(100)` |
| 3 | IN | `sBrId` | `varchar(100)` |
| 4 | IN | `sSuId` | `varchar(100)` |
| 5 | OUT | `sReturn` | `varchar(1000)` |
| 6 | OUT | `sCode` | `int` |

## Body

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

## Narrative

**Business context:** 基础资料 → 客户审核 (Customerlist) — author-comment header says "封存 (deprecated/archived) 2021-05-21, 客户审核界面 1级消审 (level-1 un-audit of customer-list)". Inverse of `Sp_Customerlist_BtnEventCheck1`: flips `elecustomer.bCheck=0` for selected rows.

**What it does:** Validates `sProInParam`, parses `$.params[].value[].sId` from the JSON payload, and for each `sId` runs `UPDATE elecustomer SET bCheck=0 WHERE sId=p_sId AND sBrandsId=sBrId AND sSubsidiaryId=sSuId`. No syslog, no flow.

**Invocation:** Status: appears orphaned and **封存 by author note** dated 2021-05-21. No caller in any channel — no form-master binding, no `gdsmodule` hook, no other routine references, no xly-src reference. Replaced by the standard 反审核 workflow. Safe to ignore in production.
