sp_cs1 (procedure)

• Type: PROCEDURE
• Deterministic: NO
• SQL data access: CONTAINS SQL

Parameters

No parameters.

Body

Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDUREspcs1'._

Narrative

Business context: Developer scratchpad — a hard-coded one-off batch that replays salary calculation against mftproductionreportmaster rows audited between 2022-07-01 and 2022-08-09. The name (sp_cs1 = 测试1) and the literal date window confirm it was a manual reprocess script, not a production routine.

What it does: Opens a cursor over mftproductionreportmaster rows with bCheck=1 in the hard-coded date window, and for each row calls Sp_CalculationWages(tCreateDate, '1111111111', '1111111111') followed by Sp_SumWages(...) with dummy paging params. Sp_CalculationWages1 is commented out. No params, no table writes of its own — purely orchestration.

Invocation: Status: appears orphaned. No caller found in any channel — no form-master binding, no gdsmodule hook, no other routine references, no xly-src reference. The hard-coded date range and cs1 (测试1) naming suggest a one-shot manual reprocess; safe to ignore in production and a candidate for cleanup.