c4040263
 “wangming”
feat: V2.0.2 会员标签...
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
-- 大客卡金异常监控阈值（默认 50000 元）
INSERT INTO `base_sysconfig` (`F_Id`, `F_Name`, `F_Key`, `F_Value`, `F_Category`)
SELECT '197007301800000001', '大额开单监控阈值', 'largeAmountBillingThreshold', '50000', 'SysConfig'
WHERE NOT EXISTS (SELECT 1 FROM `base_sysconfig` WHERE `F_Category` = 'SysConfig' AND LOWER(`F_Key`) = 'largeamountbillingthreshold');
INSERT INTO `base_sysconfig` (`F_Id`, `F_Name`, `F_Key`, `F_Value`, `F_Category`)
SELECT '197007301800000002', '大额耗卡监控阈值', 'largeAmountConsumeThreshold', '50000', 'SysConfig'
WHERE NOT EXISTS (SELECT 1 FROM `base_sysconfig` WHERE `F_Category` = 'SysConfig' AND LOWER(`F_Key`) = 'largeamountconsumethreshold');
INSERT INTO `base_sysconfig` (`F_Id`, `F_Name`, `F_Key`, `F_Value`, `F_Category`)
SELECT '197007301800000003', '大额退卡监控阈值', 'largeAmountRefundThreshold', '50000', 'SysConfig'
WHERE NOT EXISTS (SELECT 1 FROM `base_sysconfig` WHERE `F_Category` = 'SysConfig' AND LOWER(`F_Key`) = 'largeamountrefundthreshold');
INSERT INTO `base_sysconfig` (`F_Id`, `F_Name`, `F_Key`, `F_Value`, `F_Category`)
SELECT '197007301800000004', '大额转卡监控阈值', 'largeAmountTransferThreshold', '50000', 'SysConfig'
WHERE NOT EXISTS (SELECT 1 FROM `base_sysconfig` WHERE `F_Category` = 'SysConfig' AND LOWER(`F_Key`) = 'largeamounttransferthreshold');
|
