# `Sp_Add_Flow` (procedure)

> 插入流程


- **Type:** PROCEDURE
- **Deterministic:** NO
- **SQL data access:** CONTAINS SQL

## Parameters

| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | `sFormGuid` | `varchar(100)` |
| 2 | IN | `sGuid` | `varchar(100)` |
| 3 | IN | `sLoginId` | `varchar(100)` |
| 4 | IN | `sModuleflowId` | `varchar(100)` |
| 5 | IN | `sTableParams` | `longtext` |
| 6 | IN | `sDoCallPro` | `longtext` |
| 7 | IN | `sTableParamsValue` | `longtext` |
| 8 | OUT | `sReturn` | `varchar(4000)` |
| 9 | OUT | `sSrcReportData` | `longtext` |
| 10 | OUT | `sFlowId` | `varchar(100)` |
| 11 | IN | `sBrId` | `varchar(100)` |
| 12 | IN | `sSuId` | `varchar(100)` |
| 13 | OUT | `sCode` | `int` |

## Body

_Body is not pre-cached. To inspect: `mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURE `Sp_Add_Flow`'`._

## Narrative

**Business context:** Workflow engine — the canonical "submit-for-approval" entry point. Header says 插入流程 ("insert flow"). When a user clicks 审批 (Approve / submit-for-review) on any form that has a configured `gdsmoduleflow` row, this proc records the approval request as a `biz_flow` row carrying the source bill id, the form-defined column/value snapshot, the calc-proc name, and the do-call-proc payload — the workflow service then runs that flow asynchronously.

**What it does:** Looks up the flow definition from `gdsmoduleflow` by `sModuleflowId` (yielding `sFlowType`, `sFlowTypeName`, `sReportId`, `sSrcFormId`, `sCalcProName`, `sMasterTableName`, `bReturnStart`); resolves the form's primary slave-table id (`p_sMaintableId`) via `gdsconfigformmaster`; optionally rebuilds report-payload state from `Sp_System_ReplaceField_JSON`; generates `sFlowId = newId()`; `INSERT INTO biz_flow` with type/name/title/reason/start_time/apply-user/tenant fields and the caller-provided `sTableParams`/`sTableParamsValue`/`sDoCallPro`.

**Invocation:** Called by `CheckExamineFlowDataServiceImpl.doSendCheckFolwData()` via `doProByNameFlow(..., "Sp_Add_Flow", ...)`, which is itself invoked from `CheckExamineFlowServiceImpl.doSendCheckFolw()` — the approval-submit service endpoint. 47+ `Sp_Apply_Flow_*` specialised pre-flow procs (one per business object: SalSaleOrder, MaterialsApply, QualityAccident*, ProcessChange, PurpurchaseOrder, etc.) reference this name; in the flow architecture they are the per-form calc-procs invoked alongside this proc.

Caveats: body contains a stray `SELECT ddd FROM bbbb;` (~line 108) that looks like leftover debug — this would error at runtime unless the table exists; flag for maintainer audit. Also the version under `script/标版/upgrade/定时器/Sp_Add_Flow.sql` and `flyway/V1.0.7__202354_SpAddFlow.sql` / `V2.0.10__2023915_SpAddFlow.sql` are install/upgrade artefacts — the live version is whichever Flyway version migrated last.