# `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 PROCEDURE `Sp_Calc_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.