30198c7191
包含完整功能模块： - 设备激活（直销激活码模式 + 代销免激活码模式） - 微信支付 + 天卡订单 - 天卡池管理 + 异步橘视厅SDK激活 - 第三方合作伙伴接口（代销模式） - 签名鉴权（appKey/appSecret + nonce防重放） - 天卡消耗（事务 + 幂等 + 并发控制） - 媒资接口（三级授权过滤） - 审计日志 - 定价策略（3层：门店 > 渠道 > 平台） - 分账（微信分账 + 分润规则） - Docker部署（含Redis容器）
62 lines
3.2 KiB
SQL
62 lines
3.2 KiB
SQL
-- ============================================================
|
||
-- 1. 还原测试卡（在云服务器数据库 jstopenapi 上执行）
|
||
-- ============================================================
|
||
|
||
-- 1.1 重置平台天卡池：USED -> RESERVED，清除激活状态和设备绑定
|
||
UPDATE day_card_pool
|
||
SET status = 'RESERVED',
|
||
activate_status = NULL,
|
||
activate_error = NULL,
|
||
device_id = NULL,
|
||
used_at = NULL,
|
||
expire_at = NULL,
|
||
activated_at = NULL,
|
||
updated_at = NOW()
|
||
WHERE third_card_no = 'DKMMqjJKgpdwUahip5l4hGzjS'
|
||
AND status = 'USED';
|
||
|
||
-- 1.2 重置partner天卡池：CONSUMED -> AVAILABLE，清除设备绑定
|
||
UPDATE open_api_partner_card_pool
|
||
SET status = 'AVAILABLE',
|
||
device_id = NULL,
|
||
channel_org_id = NULL,
|
||
consumed_at = NULL,
|
||
updated_at = NOW()
|
||
WHERE third_card_no = 'DKMMqjJKgpdwUahip5l4hGzjS'
|
||
AND status = 'CONSUMED';
|
||
|
||
-- 1.3 验证还原结果
|
||
SELECT 'day_card_pool' AS tbl, id, card_code, third_card_no, status, activate_status, device_id
|
||
FROM day_card_pool WHERE third_card_no = 'DKMMqjJKgpdwUahip5l4hGzjS';
|
||
|
||
SELECT 'partner_card_pool' AS tbl, id, partner_id, pool_id, card_code, third_card_no, status, device_id
|
||
FROM open_api_partner_card_pool WHERE third_card_no = 'DKMMqjJKgpdwUahip5l4hGzjS';
|
||
|
||
-- 1.4 清除Redis缓存（在服务器上执行，防止Token缓存和激活锁干扰重试）
|
||
-- docker exec daycard-redis redis-cli DEL "api:thirdparty:activate:DKMMqjJKgpdwUahip5l4hGzjS"
|
||
-- docker exec daycard-redis redis-cli KEYS "api:thirdparty:activate:lock:*" | xargs -I{} docker exec daycard-redis redis-cli DEL {}
|
||
-- docker exec daycard-redis redis-cli KEYS "daycard:partner:consume:*" | xargs -I{} docker exec daycard-redis redis-cli DEL {}
|
||
|
||
|
||
-- ============================================================
|
||
-- 2. 导入橘视厅配置（在云服务器数据库 jstopenapi 上执行）
|
||
-- ============================================================
|
||
|
||
-- sys_config 表结构: id(PK), param_key(UNIQUE), param_value(varchar2000), status(tinyint default 1), remark(varchar500)
|
||
-- param_key 有 UNIQUE 约束，ON DUPLICATE KEY UPDATE 自动处理已存在情况
|
||
|
||
INSERT INTO sys_config (param_key, param_value, status, remark)
|
||
VALUES (
|
||
'JST_PLATFORM_CONFIG',
|
||
'{"jushitingBaseUrl":"https://api.future.jetsentv.com","vipQueryBaseUrl":"https://api.future.jetsentv.com","jushitingTenant":"huashitv","jushitingAccesser":"JSTASJD","jushitingBusinessLine":"4100450011381755998420012","jushitingServiceComboCode":"1100121010200494755850172","jushitingLoginRsaPublicKey":"MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAtlfaNsJwQ8wuVdITMLJPrXMeD9idJ0aTziOgkZZhigwzhyPNDAqw+nCKeJGGoTJyhbjPXKtnyI8eNpj+xhCCMXUD3BxOVMFWBhFxzIl83IQJG43mPRXwsJrI4oCYDaKv5aeZZBqF0OLPglXU+q19/28ltONvxcKp8YxXagmixzz1SDgLITM3s3ExqiaScK1dcpPtXbCpI4GXPP9l0ekkCBAo/d1oQqbxHvdE5ufAhEZ042k5tVHUgX9cUoedA9F2JcPhc+zUNCJUAQLvfVXxqNdhwxA4TY+64OX2iSje/cTqxp+4RcrX4rbUIYZitVQCRexZjKz7Yd/KXp8CKCho6wIDAQAB","jushitingActivateSignKey":"hhDEHY1qC4r","vipQuerySignKey":"c25svtwbTyCE"}',
|
||
1,
|
||
'聚视厅/橘视厅第三方平台配置(JSON)'
|
||
)
|
||
ON DUPLICATE KEY UPDATE
|
||
param_value = VALUES(param_value),
|
||
status = 1,
|
||
remark = VALUES(remark);
|
||
|
||
-- 验证
|
||
SELECT param_key, param_value, remark FROM sys_config WHERE param_key = 'JST_PLATFORM_CONFIG';
|