Sp_OpsOutSideProcess_BtnEventFinished (procedure)
- Type: PROCEDURE
- Deterministic: NO
- SQL data access: CONTAINS SQL
Parameters
| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | sProInParam |
varchar(10000) |
| 2 | IN | sMakePerson |
varchar(100) |
| 3 | IN | sBrId |
varchar(100) |
| 4 | IN | sSuId |
varchar(100) |
| 5 | OUT | sReturn |
varchar(1000) |
| 6 | OUT | sCode |
int |
Body
Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURESpOpsOutSideProcess_BtnEventFinished'._
Narrative
Business context: 外协管理 / 工序外发 — toolbar-button handler that marks selected 工序外发 lines as 完工/审核 (finished/examined) on mftworkorderprocess, with an optional free-text memo carried in the dialog's textareaValue.
What it does: Validates sProInParam length, then parses $.params[*].value[*].sSlaveId and $.changeValue.textareaValue. For each slave id runs UPDATE mftworkorderprocess SET bExamine=1, sExaminePerson=sMakePerson, tExamineDate=NOW() WHERE sId=p_sId AND sBrandsId=sBrId AND sSubsidiaryId=sSuId. On empty input it returns sCode=-1 with the localised paramsErro message from Sp_Sis_GetConst. (The captured textareaValue is parsed but not currently persisted by this version of the body.)
Invocation: Status: appears orphaned. No caller found in any channel (form-master, gdsmodule hooks, other routines, xly-src grep across all extensions, dynamic-dispatch search). JSON-input shape matches the generic Sp_BtnEvent_* contract dispatched by GenericProcedureCallServiceImpl.doGenericProcedureCall() — would have been wired to a 完工 / 审核 toolbar button on the 工序外发 grid; verify with maintainers before relying on it.