Sp_Supply_submit (procedure)

@author:zhucx
@date: 2022/12/02
@describe: 供应商评估-提交评估

• 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 PROCEDURESpSupply_submit'._

Narrative

Business context: 基础资料 → 供应商与外协加工商 → 供应商评估 — 提交评估 toolbar action. Submits supplier-evaluation slave rows (elesupply.iLevel workflow) into the awaiting-review state so the qualification reviewer can pick them up via 资质审核.

What it does: Parses $.params[*].value[*].sSlaveId from sProInParam. For each p_sId runs UPDATE elesupply SET tSubmit=SYSDATE(), sSubmit=sMakePerson, iLevel=1 WHERE sId=p_sId AND sBrandsId/sSubsidiaryId. Errors out with the localised paramsErro constant (via Sp_Sis_GetConst) when sProInParam is empty. Despite operating on the sId parameter as sSlaveId, target table is elesupply directly — the slave-id key reflects how the evaluation grid embeds supplier rows.

Invocation: Dispatched dynamically by GenericProcedureCallServiceImpl.doGenericProcedureCall() — 供应商评估 grid's 提交评估 button names Sp_Supply_submit as the action. Forward pair with Sp_Supply_filecheck (资质审核 next step) and Sp_Supply_setLevel (final evaluation rating). Install script: script/标版/30100101/Sp_Supply_submit.sql. Author tag: @author:zhucx @date: 2022/12/02.