From 7b2401c03d30dc5c7b3d2af679d52843ffcd39bb Mon Sep 17 00:00:00 2001 From: Administrator <15274802129@163.com> Date: Mon, 22 Jun 2026 22:34:21 +0800 Subject: [PATCH] feat(system): 添加售后服务配置功能 --- sql/xc_mall_pay_config.sql | 30 ++++++++++++++++++++++++++++++ 1 files changed, 30 insertions(+), 0 deletions(-) diff --git a/sql/xc_mall_pay_config.sql b/sql/xc_mall_pay_config.sql new file mode 100644 index 0000000..ec91d39 --- /dev/null +++ b/sql/xc_mall_pay_config.sql @@ -0,0 +1,30 @@ +-- ============================================================ +-- 支付 & Webhook 配置数据 +-- 插入 data_dictionary_custom 表 +-- ============================================================ + +-- ---------------------------- +-- 1. LWPAY 支付配置 +-- ---------------------------- +INSERT INTO data_dictionary_custom (REVISION, CREATED_BY, CREATED_TIME, UPDATED_BY, UPDATED_TIME, type, code, value, description) +VALUES +(1, 'system', NOW(), 'system', NOW(), 'LWPAY_CONFIG', 'MEMBER_ID', '请替换为商户号', 'LWPAY商户号'), +(1, 'system', NOW(), 'system', NOW(), 'LWPAY_CONFIG', 'SECRET_KEY', '请替换为签名密钥', 'LWPAY签名密钥'), +(1, 'system', NOW(), 'system', NOW(), 'LWPAY_CONFIG', 'NOTIFY_URL', 'https://your-domain/api/order/lwPayNotify', 'LWPAY异步回调地址'), +(1, 'system', NOW(), 'system', NOW(), 'LWPAY_CONFIG', 'RETURN_URL', 'https://your-domain/api/order/lwPayReturn', 'LWPAY支付完成跳转地址'); + +-- ---------------------------- +-- 2. Tokenview Webhook 配置（签名密钥） +-- ---------------------------- +INSERT INTO data_dictionary_custom (REVISION, CREATED_BY, CREATED_TIME, UPDATED_BY, UPDATED_TIME, type, code, value, description) +VALUES +(1, 'system', NOW(), 'system', NOW(), 'TOKENVIEW_CONFIG', 'WEBHOOK_SECRET', 'dd12521274e434115df5c4277755839766349007fb57936d9d5be0a7a4f0e42f', 'Tokenview Webhook HMAC-SHA256 签名密钥'), +(1, 'system', NOW(), 'system', NOW(), 'TOKENVIEW_CONFIG', 'TRC20_USDT_ADDRESS', '请替换为TRC20收款地址', 'TRC20 USDT 收款地址'); + +-- ---------------------------- +-- 说明： +-- 1. MEMBER_ID / SECRET_KEY：从 LWPAY 商户后台获取 +-- 2. NOTIFY_URL / RETURN_URL：替换 your-domain 为实际域名 +-- 3. WEBHOOK_SECRET：需与 Tokenview 后台配置的 Secret Key 一致 +-- 4. TRC20_USDT_ADDRESS：系统接收 USDT 的 TRC20 钱包地址（同时用于 SALES_SERVICE/TRC_ADDRESS） +-- ============================================================ -- Gitblit v1.9.1