企业🤖AI智能体构建引擎，智能编排和调试，一键部署，支持私有化部署方案 广告
alter table t_recharge add interest_time varchar2(200) ; comment on column t_recharge.interest_time is '节节高转入计息的时间'; alter table t_recharge add conversion_type varchar2(5) default 1; comment on column t_recharge.conversion_type is '内部转化过程（1，未转换，2天天赠转节节高，3，定存转天天赠，4.定存转天天赠转节节高）'; alter table t_recharge add end_type varchar2(5) default 1; comment on column t_recharge.end_type is '最终的订单状态 1:天天赠,2:定存,3:节节高'; alter table t_recharge add jjg_amount NUMBER(10,2) default 0; comment on column t_recharge.jjg_amount is ' 充值前节节高余额'; alter table t_recharge add ttz_amount NUMBER(10,2) default 0; comment on column t_recharge.ttz_amount is ' 充值前天天赠余额'; alter table t_consume add cttz_amount NUMBER(10,2) default 0 ; comment on column t_consume.cttz_amount is ' 消费天天赠金额'; alter table t_consume add cjjg_amount NUMBER(10,2) default 0 ; comment on column t_consume.cjjg_amount is ' 消费节节高金额'; alter table t_consume_child add customid CHAR(8 BYTE) ; comment on column t_consume_child.customid is '会员id'; alter table t_consume_back add customid CHAR(8 BYTE) ; comment on column t_consume_back.customid is '会员id'; alter table t_ransom add order_type varchar2(5) default 1; comment on column t_ransom.order_type is '1:天天赠赎回,3:节节高赎回'; alter table t_accountdetails add type_child varchar2(5) ; comment on column t_accountdetails .type_child is '21:节节高充值,22:天天赠转节节高,23:节节高退回 24 天天赠退回'; alter table t_ransom_child add customid CHAR(8 BYTE) ; comment on column t_ransom_child.customid is '会员id'; alter table t_ransom_back add customid CHAR(8 BYTE) ; comment on column t_ransom_back.customid is '会员id'; alter table t_deposit_time add amount NUMBER(10,2) default 0 ; comment on column t_deposit_time.amount is '最小金额限制'; alter table t_deposit_time add status varchar2(10) default 1 ; comment on column t_deposit_time.status is '1:正常,2:禁用'; alter table t_orders add order_type varchar2(5) default 1; comment on column t_orders.order_type is '1:天天赠购买,3:节节高购买'; alter table t_special_recharge add order_type varchar2(5) default 1; comment on column t_special_recharge.order_type is '1:天天赠大额购买,3:节节高大额购买'; --更新最终订单类型 update t_recharge set end_type=business_type; --更新节节高计息时间 update t_recharge set interest_time=endday; --更新定存最终订单类型 update t_recharge set end_type='1',conversion_type='3' where status='5'; --插入节节高时间设置 Insert into TONGBAO.T_DEPOSIT_TIME (ID,MIN_TIME,MAX_TIME,TYPE,USERID,USERNAME,DATETIME,RATE,AMOUNT,STATUS) values ('3','1','3','3','9','xiayunfeng','1595915389','20',0,'1'); Insert into TONGBAO.T_ADDRESS_CONFIG (ID,IP,WITH_PARAMETERS,TITLE,DESCRIBE,USERID,USERNAME,DATETIME,UPDATETIME,STATUS,TYPE,IDENTIFYING) values (18,'tongbao-20191126-20191230-01',null,'通宝+订单版本号',null,'8','qiweiwei','1608622093','1608622093','1','1','TB_VARSIONS'); Insert into TONGBAO.T_ADDRESS_CONFIG (ID,IP,WITH_PARAMETERS,TITLE,DESCRIBE,USERID,USERNAME,DATETIME,UPDATETIME,STATUS,TYPE,IDENTIFYING) values (19,'https://tongbao.9617777.com',null,'一家下单购买通宝+支付完成回调',null,'8','qiweiwei','1608803122','1608803122','1','1','TBJ_URL'); Insert into TONGBAO.T_ADDRESS_CONFIG (ID,IP,WITH_PARAMETERS,TITLE,DESCRIBE,USERID,USERNAME,DATETIME,UPDATETIME,STATUS,TYPE,IDENTIFYING) values (20,'nojycoin,noqpay,nojycoinplus,noupacp,no_credit,nosupervip',null,'一家支付方式','购买通宝+调取收银台得支付方式限制','8','qiweiwei','1608803582','1608803582','1','1','YJ_CHANNEL'); Insert into TONGBAO.T_ADDRESS_CONFIG (ID,IP,WITH_PARAMETERS,TITLE,DESCRIBE,USERID,USERNAME,DATETIME,UPDATETIME,STATUS,TYPE,IDENTIFYING) values (21,'https://zz.9617777.com/zzser/pwdlibs/#/bank-list/',null,'银行卡组件接口地址',null,'8','qiweiwei','1610445589','1610445589','1','1','BANK_URL'); Insert into TONGBAO.T_ADDRESS_CONFIG (ID,IP,WITH_PARAMETERS,TITLE,DESCRIBE,USERID,USERNAME,DATETIME,UPDATETIME,STATUS,TYPE,IDENTIFYING) values (22,'/home/jyzz/wwwroot/tongbao/runtime/',null,'seaslog日志路径',null,'9','xiayunfeng','1609216239','1609216239','1','1','seaslog'); Insert into TONGBAO.T_ADDRESS_CONFIG (ID,IP,WITH_PARAMETERS,TITLE,DESCRIBE,USERID,USERNAME,DATETIME,UPDATETIME,STATUS,TYPE,IDENTIFYING) values (23,'JYO2O01',null,'加密使用Code','通宝+接口加密使用','8','qiweiwei','1608365892','1608365892','1','1','ENCRYPT_CODE'); Insert into TONGBAO.T_ADDRESS_CONFIG (ID,IP,WITH_PARAMETERS,TITLE,DESCRIBE,USERID,USERNAME,DATETIME,UPDATETIME,STATUS,TYPE,IDENTIFYING) values (24,'YJWYNF06',null,'一家下单接口参数加密','一家下单接口参数加密','8','qiweiwei','1608802756','1608802756','1','1','YJ_ORDER_KEY'); Insert into TONGBAO.T_ADDRESS_CONFIG (ID,IP,WITH_PARAMETERS,TITLE,DESCRIBE,USERID,USERNAME,DATETIME,UPDATETIME,STATUS,TYPE,IDENTIFYING) values (25,'http://mall.yijiahn.com/mall/app/goods/quickbuy.json?',null,'一家下单接口地址',null,'8','qiweiwei','1608803753','1608803753','1','1','JY_ORDER_URL'); Insert into TONGBAO.T_ADDRESS_CONFIG (ID,IP,WITH_PARAMETERS,TITLE,DESCRIBE,USERID,USERNAME,DATETIME,UPDATETIME,STATUS,TYPE,IDENTIFYING) values (26,'http://o2o.yijiahn.com/jyo2o_web/app/user/accountinfo.json',null,'查询一家用户信息接口','通宝+入口查询一家信息接口地址','8','qiweiwei','1609396354','1609396354','1','1','YJ_USER_URL'); Insert into TONGBAO.T_ADDRESS_CONFIG (ID,IP,WITH_PARAMETERS,TITLE,DESCRIBE,USERID,USERNAME,DATETIME,UPDATETIME,STATUS,TYPE,IDENTIFYING) values (27,'https://zz.9617777.com/zzser/pwdlibs/#/setting-password/',null,'设置密码组件','设置密码组件','8','qiweiwei','1610445765','1610445765','1','1','SET_PWD_URL'); Insert into TONGBAO.T_ADDRESS_CONFIG (ID,IP,WITH_PARAMETERS,TITLE,DESCRIBE,USERID,USERNAME,DATETIME,UPDATETIME,STATUS,TYPE,IDENTIFYING) values (28,'https://zz.9617777.com/zzser/pwdlibs/#/change-password/',null,'修改密码组件','修改密码组件','8','qiweiwei','1610445805','1610445805','1','1','CHANGE_PWD_URL'); Insert into TONGBAO.T_ADDRESS_CONFIG (ID,IP,WITH_PARAMETERS,TITLE,DESCRIBE,USERID,USERNAME,DATETIME,UPDATETIME,STATUS,TYPE,IDENTIFYING) values (29,'30',null,'通宝+赎回时间天数的限制',null,'8','qiweiwei','1608552317','1608552317','1','1','REDEEM_LIMIT'); Insert into TONGBAO.T_ADDRESS_CONFIG (ID,IP,WITH_PARAMETERS,TITLE,DESCRIBE,USERID,USERNAME,DATETIME,UPDATETIME,STATUS,TYPE,IDENTIFYING) values (30,'https://zz.9617777.com/zzkp.php/OutCards/examPayPwd',null,'卡系统用户密码校验',null,'8','qiweiwei','1608629679','1608629679','1','1','ZZK_PWD_URL'); Insert into TONGBAO.T_ADDRESS_CONFIG (ID,IP,WITH_PARAMETERS,TITLE,DESCRIBE,USERID,USERNAME,DATETIME,UPDATETIME,STATUS,TYPE,IDENTIFYING) values (31,'100',null,'天天赠充值限额',null,'9','xiayunfeng','1610002929','1610002929','1','1','TTZ_QUPTA');