-- ============================================================
-- 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';