"manager_detail":{
// #region 开启扩展入库配置
"saveSqlExtand": true,
// #endregion 开启扩展入库配置
}
"saveSqlExtand": {
// #region 数据变更后执行的操作
"bt-policy-item": {
"sortId": 25,
"connName": "ConnAct",
"sqlUpdate": "update bt_policy_item,bt_policy set bt_policy_item.family_id=bt_policy.family_id,bt_policy_item.bd_tbr_uid=bt_policy.bd_tbr_uid,bt_policy_item.bd_bbr_uid=bt_policy.bd_bbr_uid where bt_policy.policy_id=@policyId and bt_policy_item.policy_id=bt_policy.policy_id"
},
"bt-policy-status": {
"sortId": 30,
"connName": "ConnAct",
"sqlUpdate": "update bt_policy_status,bt_policy set bt_policy_status.family_id=bt_policy.family_id,bt_policy_status.bd_tbr_uid=bt_policy.bd_tbr_uid,bt_policy_status.bd_bbr_uid=bt_policy.bd_bbr_uid where bt_policy.policy_id=@policyId and bt_policy_status.policy_id=bt_policy.policy_id"
}
// #endregion 数据变更后执行的操作
},
"saveSqlExtand": {
// #region 数据变更后执行的操作
"activity-blacklist-ip": {
"sortId": 5,
"connName": "ConnAct",
"sqlUpdate": "update activity_blacklist_ip set activity_name=(select max(activity_name) from activity_config where activity_id=@activityId) where activity_id=@activityId"
// 必须自动,如果为空,不执行方法
//"need": [
// {
// "field": "activityName",
// "value": ""
// },
// {
// "field": "activityId",
// "value": ""
// }
//]
},
"activity-blacklist-user": {
"sortId": 10,
"connName": "ConnAct",
"sqlUpdate": "update activity_blacklist_user set activity_name=(select max(activity_name) from activity_config where activity_id=@activityId) where activity_id=@activityId"
},
"activity-whitelist-ip": {
"sortId": 15,
"connName": "ConnAct",
"sqlUpdate": "update activity_whitelist_ip set activity_name=(select max(activity_name) from activity_config where activity_id=@activityId) where activity_id=@activityId"
},
"activity-whitelist-user": {
"sortId": 20,
"connName": "ConnAct",
"sqlUpdate": "update activity_whitelist_user set activity_name=(select max(activity_name) from activity_config where activity_id=@activityId) where activity_id=@activityId"
},
"activity-config-content": {
"sortId": 25,
"connName": "ConnAct",
"sqlUpdate": "update activity_config_content set activity_name=(select max(activity_name) from activity_config where activity_id=@activityId) where activity_id=@activityId"
}
// #endregion 数据变更后执行的操作
},
文档更新时间: 2022-07-29 07:23 作者:admin