# `Sp_Calc_sCoach` (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(5000)` |
| 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_sCoach`'`._

## Narrative

**Business context:** 产品指导价 (material guide-price update) — check / uncheck on `elematerialscoachmaster`. Approving a 指导价 (guide-price) batch posts the new prices back into `elematerials.dGuidePrice` so later quotation / BOM lookups pick them up.

**What it does:** Validates `sGuid`. With `iFlag=1`: refuses if already checked; sets `elematerialscoachmaster.bCheck=1`, `sStatus=1`, `sCheckPerson=sLoginId`, `tCheckDate=NOW()`. Then runs `UPDATE elematerials A INNER JOIN elematerialscoachslave B ON A.sId=B.sMaterialsId SET A.dGuidePrice=B.dNewPrice WHERE B.sParentId=sGuid` — sweeping the new prices onto the live material rows. With `iFlag=0`: clears the master flags (does not roll back the dGuidePrice writes — flagged below).

**Invocation:** Status: appears orphaned. No `gdsmodule` hook, no form-master, no other procedure caller, no xly-src reference. The `elematerialscoach*` tables exist; the audit handler is unwired in this DB instance. Candidate for maintainer audit.

Flag: the uncheck branch does not reverse the `elematerials.dGuidePrice` overwrite — once a guide-price batch is checked, the price change sticks even if the batch is later un-audited. Maintainer should confirm this is intended.