# `Sp_PlanListMakeup_BtnEventFinishedfhpb` (procedure)


- **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_PlanListMakeup_BtnEventFinishedfhpb`'`._

## Narrative

**Business context:** 生产管理 → 计划、排程 → 计划列表 — fhpb (反核拼版 / un-makeup) handler that reverses `Sp_PlanListMakeup_BtnEventFinished`. Used when an operator marked a plan row as makeup-finished by mistake and the shop wants to clear the flag plus the cost figure without deleting the row.

**What it does:** Parses `$.params[*].value[*].sId` for the picked `mftproductionplanslave` rows; for each, `UPDATE mftproductionplanslave SET tMakeup=NULL, bMakeup=0, sMakeupPerson=NULL`. Also runs the `valueKey`-driven dynamic clear `Update mftproductionplanslave Set dMakeupMoney=NULL` so the cost is voided. JSON-shape and error handling identical to its forward counterpart.

**Invocation:** Dispatched by `GenericProcedureCallServiceImpl.doGenericProcedureCall()` — the 撤销拼版完工 / 反核拼版 toolbar button on the 计划列表 grid names this proc. DB-only; no install script in xly-src `30100101`.
