Sp_Calc_about (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	longtext
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 PROCEDURESpCalc_about'._

Narrative

Business context: 固定资产 / 固定资产闲置申请单 — fixed-asset "idle" (闲置) application: marks an asset-idle request as approved (or reverts) on eptmachinefixedsabout.

What it does: Refuses if sGuid is empty or the row is bInvalid=1 (returns localized paramsErro/sNoCanCheckBybInvalid). With iFlag=1: refuses if already bCheck=1 else sets bCheck=1, sStatus=1, sCheckPersON=sLoginId, tCheckDate=NOW(). With iFlag=0: refuses if already bCheck=0 else clears the same fields. All queries are scoped by sBrandsId/sSubsidiaryId. Member of the Sp_Calc_* fixed-asset family (sibling of Sp_Calc_borrow, Sp_Calc_Change, Sp_Calc_clear).

Invocation: Status: appears orphaned. No caller found in any channel — gdsmodule.sCalcProName/sSaveProName family, gdsmoduleflow, gdsconfigformmaster, other routines, or xly-src grep. The Sp_Calc_* signature matches the workflow check-hook contract (iFlag, iTmpCheck, sFormGuid, sGuid, ...) but no binding row exists in this DB — candidate for maintainer audit (likely bound only in customer-specific overrides).

Flag: sTmpReturn is declared but never assigned — the trailing IF sTmpReturn <> '' branch is dead. Sibling family shares the same dead branch.