Sp_SingleReceipt_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 PROCEDURESpSingleReceipt_BtnEventFinished'._
Narrative
Business context: 移动端管理 → 现场 → 功能操作 → 送货回执 (101251240115015892027636750) — mobile-side button "确认回执" on the 送货回执 module. The driver / receiver confirms that the delivery lines were received in full; this proc stamps the receipt-confirmed flag, receiver name, timestamp and full received qty on the upstream 送货单从表 saldelivergoodsslave.
What it does: Parses the standard $.params[*].value[*].sId JSON. For each sId it UPDATE saldelivergoodsslave SET tSingleReceipt=NOW(), sSingleReceipt=sMakePerson, dSingleReceiptQty=dProductQty, bSingleReceipt=1 WHERE sId=p_sId AND sBrandsId=sBrId AND sSubsidiaryId=sSuId — i.e. accepts the full shipped qty as the received qty (no per-line override). Refuses with the localised paramsErro from Sp_Sis_GetConst when the JSON is too short.
Invocation: Dispatched dynamically by GenericProcedureCallServiceImpl.doGenericProcedureCall() (POST /procedureCall/doGenericProcedureCall) — the 确认回执 button on the mobile 送货回执 grid names Sp_SingleReceipt_BtnEventFinished as the action. Sibling: Sp_SingleReceipt_BtnEventAbnormal (异常回执). Customer override: script/客户/千彩/Sp_SingleReceipt_BtnEventFinished.sql. Standard install: script/标版/30100101/Sp_SingleReceipt_BtnEventFinished.sql.