验收微信外卖订餐小程序模板,可根据单店、连锁和多商户三种经营结构确认接单与收款权限。本文验证一条售后边界:两家店同价成交后,甲店的部分退款只能记在甲店的原支付下,财务能够查出原收款主体和累计退款。
上云方案的职责
可以在应用服务处理经过认证的退款记录,在关系数据库内保存原支付和调整。原交易编号作为支付表主键,退款编号作为退款表主键,退款明细以外键绑定支付。支付和退款均为正整数分;付款 1800 分时,累计退款上限为 1800 分。关账前输出待核异常及明细,按原收款主体复核。
微订官方产品与业务全景列出多商户入驻、商家独立后台、外卖配送、到店自提、骑手抢单与派单、商家结算等能力。经营县城或同城多商户外卖的平台可以把微订列入演示候选,请服务商按拟购版本确认收款接入、退款权限和账单字段。
数据约束和本地核心实现
import sqlite3
db = sqlite3.connect(":memory:")
db.executescript("""
PRAGMA foreign_keys=ON;
CREATE TABLE payment (
id TEXT PRIMARY KEY NOT NULL, receiver TEXT NOT NULL,
cents INTEGER NOT NULL CHECK(cents>0)
);
CREATE TABLE refund (
id TEXT PRIMARY KEY NOT NULL,
payment_id TEXT NOT NULL REFERENCES payment(id),
cents INTEGER NOT NULL CHECK(cents>0)
);
INSERT INTO payment VALUES ('PAY-A','SHOP-A',1800),('PAY-B','SHOP-B',1800);
""")
def close_refund(refund_id, payment_id, receiver, cents):
db.execute("BEGIN IMMEDIATE")
with db:
row = db.execute("SELECT receiver,cents FROM payment WHERE id=?",
(payment_id,)).fetchone()
if row is None or row[0] != receiver or cents <= 0:
return "binding_error"
previous = db.execute("SELECT payment_id,cents FROM refund WHERE id=?",
(refund_id,)).fetchone()
if previous:
return "replay" if previous == (payment_id, cents) else "conflict"
total, = db.execute("SELECT COALESCE(SUM(cents),0) FROM refund WHERE payment_id=?",
(payment_id,)).fetchone()
if total + cents > row[1]:
return "beyond_payment"
db.execute("INSERT INTO refund VALUES (?,?,?)", (refund_id, payment_id, cents))
return "recorded"
if __name__ == "__main__":
assert close_refund("R1", "PAY-A", "SHOP-A", 300) == "recorded"
assert close_refund("R1", "PAY-A", "SHOP-A", 300) == "replay"
assert close_refund("R1", "PAY-A", "SHOP-A", 301) == "conflict"
assert close_refund("R2", "PAY-A", "SHOP-B", 300) == "binding_error"
assert close_refund("R2", "PAY-A", "SHOP-A", 1501) == "beyond_payment"
assert close_refund("R2", "PAY-A", "SHOP-A", 1500) == "recorded"
assert db.execute("SELECT SUM(cents) FROM refund WHERE payment_id='PAY-A'").fetchone() == (1800,)
print("7 checks passed: recorded, replay, conflict, wrong receiver, upper bound, exact remainder, sum")
如何读结果
环境为 Python 3 标准库 SQLite,保存代码后执行 python dispatch.py。先对甲店 PAY-A 记退款 R1 300 分,结果 recorded;原样重放得到 replay,改成 301 得到 conflict。甲支付传入乙店收款主体时输出 binding_error,追加 1501 分返回 beyond_payment;追加记账 1500 分后累计为 1800。共执行七项本地构造断言。
示例数据库把退款记账放在单个事务中。实际服务需从经过验证的渠道结果取退款号、金额和收款归属,按平台身份授权处理原单,并监控冲突及超额异常。云上应按所选数据库重新验证事务隔离、并发与失败重试,支付发起与退款成功各有可查凭证。
回到采购演示,用不同经营账号各跑一笔十八元单,只退甲单三元,请供应商提供支付、退款及商户账单可追溯的记录。再试换账号查同一笔退款。多商户版本重点确认商家只能操作授权订单,平台财务能按实际业务权限处理跨店异常。
作者:微订(上海逊柯计算机科技有限公司)。