# `Sp_Calc_sPdtFJ` (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_sPdtFJ`'`._

## Narrative

**Business context:** 质量管理 → finished-goods re-inspection audit (成品复检审核) on `QlyProductTestMaster` — a stripped-down sibling of `Sp_Calc_sPdt` covering re-test of already-tested finished goods. The comment `成品复检审核` distinguishes it from the initial inspection variant.

**What it does:** Guards on `sGuid`, `SysLocking`, and `bInvalid` against `QlyProductTestMaster`. On `iFlag=1` flips `bCheck=1, sStatus=1, sCheckPerson, tCheckDate` and propagates `tCheckedDate` to `eleproductstock` via `sSrcSlaveId`; on `iFlag=0` calls `Sp_Bill_Used` (form-key `SaleTrial`) to block uncheck when downstream rows exist, then clears the flags.

**Invocation:** Status: appears orphaned. No `gdsmodule.sProcName` binding, no `gdsconfigformmaster` references, no callers in `information_schema.ROUTINES`, no xly-src hits across all extensions. The `Sp_Calc_s<Code>` naming suggests it was a planned secondary-inspection variant of `Sp_Calc_sPdt` that was never wired into a form — candidate for maintainer audit.