deleteMesg (procedure)

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

Parameters

#	Mode	Name	Type
1	IN	sGuid	varchar(100)
2	IN	sBrId	varchar(100)
3	IN	sSuId	varchar(100)

Body

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

Narrative

Business context: 系统消息 / 审批消息 — when a bill is hard-deleted, its in-app inbox notifications and approval-result trail need to disappear too. This routine removes the message + recipient + check-result rows for one (sBillId, sBrandsId, sSubsidiaryId) tuple.

What it does: Deletes from sysbillcheckresult, sysmsguser, and sysMsg in child-first order, scoped by sMsgId/sParentId IN (SELECT sId FROM sysMsg WHERE sBillId = sGuid AND sBrandsId = sBrId AND sSubsidiaryId = sSuId). An earlier guarded-by-sCheckStatus variant is commented out, so this version is unconditional.

Invocation: Status: appears orphaned. No caller found in any channel — no form-master sSqlStr, no gdsmodule hook, no other routine references it, and no xly-src match. Candidate for maintainer audit; the live message-cleanup path is most likely inlined inside the bill-delete workflow procedures rather than going through this helper.