# `Sp_Calc_sPst` (procedure)

> 成品入库


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

## Parameters

| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | `iFlag` | `int` |
| 2 | IN | `iTmpCheck` | `int` |
| 3 | IN | `sFormGuid` | `varchar(100)` |
| 4 | IN | `sGuid` | `varchar(100)` |
| 5 | IN | `sLoginId` | `varchar(100)` |
| 6 | OUT | `sReturn` | `varchar(4000)` |
| 7 | IN | `sBrId` | `varchar(100)` |
| 8 | IN | `sSuId` | `varchar(100)` |
| 9 | OUT | `sCode` | `int` |

## Body

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

## Narrative

**Business context:** 成品库存 → 成品库单据 (and KPI流程操作菜单 → 销售送货流程) — audit / un-audit of a 成品入库 (finished-goods receipt) bill on `PitProductInStoreMaster`/`PitProductInStoreSlave`. On approval, qty is posted into `PitProductStore`, the source work-order (`MftWorkOrderMaster`/`Slave`) is back-written with completed quantity, and the linked sales-order slave (`salsalesorderslave`) is updated to reflect what's now on hand.

**What it does:** Long body. Validates `sGuid`, calls `Sp_Bill_Used` to verify the bill is not consumed downstream; on `iFlag=1` cursors slave rows, `INSERT INTO PitProductStore` and `INSERT INTO MitMaterialsStoreVirtual` for the receipt, `CALL Sp_calc_productstoreLimit`/`SP_Inventory_ProductCalcQty`/`SP_Inventory_ProductInOutWareHouse`, back-writes `mftworkordermaster`/`mftworkorderslave` completed-qty + status, syncs `mftproductionplan(slave/billslave)`, updates `eleproduct(stock)`, posts `qlyproducttestmaster` (quality test rows), updates `sgdsemigoodsmatchbillmaster/slave` (半成品 match) and `salsalesorderslave`; flips `PitProductInStoreMaster.bCheck=1`. `iFlag=0` reverses inventory deltas and master/slave flags. Resolves the inventory form-guid via `Sp_Sis_GetProductInventoryFormGuid`.

**Invocation:** Bound to `gdsmodule.sProcName` on two modules — `成品扫码入库(单据）` (sId `101251240115016189918441220`, under 现场 → 功能操作) and `成品入库` (sId `192116810113315228246447250`, under KPI流程操作菜单 → 销售送货流程). Dispatched by Java `BusinessBaseServiceImpl.getPrcName(sFormGuid, …)` on the audit/un-audit button. Install scripts: `script/标版/30100101/Sp_Calc_sPst.sql`, an upgrade patch `script/标版/upgrade/20220126-2861-仓库冻结后，入库、领料、送货单不可消审/Sp_Calc_sPst.sql`, plus customer overrides at `script/客户/千彩/` and `script/客户/朝阳/` — verify which is deployed per tenant.
