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');
- 通寶+后臺
- 新數據字典
- 測試數據庫配置
- 核心賬戶改造需求文檔
- 物業霸王餐
- 物業霸王餐上線流程
- 4月27版本上線數據庫變動情況
- 5月7日2.22版本上線數據庫變動情況
- 5月7日2.22版本上線須知
- 5月26日2.23版本數據庫變動情況
- 6月9日2.24版本數據庫變動情況
- 7月22日2.25版本數據庫變動情況
- 9月4日2.26版本數據庫變動情況
- 11月11日添加匯款規則設置
- 20.11.23大額轉賬轉用大額組件
- 20.11.25監控mns異常消息
- 20.12.04 通寶+入口限制
- 20.12.24 3.0通寶+階梯利率
- 21.01.08 通寶+遷移景安方案
- 21.01.29 物業霸王餐2.0
- 21.02.02 結算添加88折補貼金額
- 21.03.22 大額匯款贈送活動增加限制條件
- 21.05.20 代他付
- 21.06.28 充值對賬
- 21.07.03 添加折扣退款補貼
- 8月14版本,前端icon優化
- D0對賬
- 賬戶注銷
- 通寶+充值作廢
- 通寶+商家商戶信息
- 上線注意事項
- 上線執行sql語句
- 物業繳費
- 1.查詢用戶欠費綁定的信息
- 2.1手機號查詢信息接口