Sp_Calc_sClfbx (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 PROCEDURESpCalc_sClfbx'._

Narrative

Business context: 差旅费用报销 — travel-expense-reimbursement check / uncheck on travelExpenseApplyMaster. An employee files a 差旅费报销 application and finance/manager approval flips its check state.

What it does: Validates sGuid. Reads master bInvalid, tCreateDate; refuses if invalid. Enforces the accounting-period freeze guard: when SysSystemSettings.CkxIntervalMonthModifyBill=0, checks sysaccountperiod.bFrozen for the row's tCreateDate and refuses if the period is frozen. With iFlag=1: refuses if already checked, otherwise sets master bCheck=1 (and the rest of the body posts the reimbursement amount into the expense-accounting ledger). With iFlag=0: symmetric uncheck.

Invocation: Status: appears orphaned. No gdsmodule hook, no form-master, no other procedure caller, no xly-src reference. The travelExpenseApplyMaster table exists; the audit handler is unwired in this DB instance. Candidate for maintainer audit — likely the 差旅费报销 module was authored but not deployed to default modules.