增加了tenantid 字段
diff --git a/src/main/resources/import.sql b/src/main/resources/import.sql
index 2e4595d..4760e09 100644
--- a/src/main/resources/import.sql
+++ b/src/main/resources/import.sql
@@ -1,5 +1,3 @@
-insert into tb_apiclient(appid, secret, transStatus, roles)
-values ('100001', 'oUw2NmA09ficiVWD4TUQLDOkPyzQa3VzbjjsW0B2qTk=', 'normal', 'ROLE_THIRD_ADMIN');
INSERT INTO tb_operator(
operid, closedate, opendate, opercode, opername, operpwd, opertype, transStatus)
VALUES ('LOR2IwRkbOjp+sVG9KR2BpHZbwGKepS4', '20500101', '20190101', 'system', '系统管理员', '$2a$10$Ex9xp11.vCaD8D0a7ahiUOKqDij1TcCUBwRAmrqXeDvAkmzLibn4.', 'oper', 'normal');
@@ -12,20 +10,34 @@
id, operid, roleid)
VALUES ('1', 'LOR2IwRkbOjp+sVG9KR2BpHZbwGKepS4', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs');
--- 功能表
---Insert into TB_FUNCTION (ID,PARENTID,NAME,ORDERNUM,MENUURL,MENUICON,ISLEAF)
---values ('1','-1','系统中心',1,'#','layui-icon-set',0);
---Insert into TB_FUNCTION (ID,PARENTID,NAME,ORDERNUM,MENUURL,MENUICON,ISLEAF)
---values ('2','1','管理员维护',1,'#','layui-icon-set',1);
---Insert into TB_ROLE_FUNCTION (ID,FUNCTIONID,ROLEID) values ('1','1','d1yctWs5+ks0iQN3m9bUvRHus6HbKbrs');
---Insert into TB_ROLE_FUNCTION (ID,FUNCTIONID,ROLEID) values ('2','2','d1yctWs5+ks0iQN3m9bUvRHus6HbKbrs');
-
-Insert into TB_FUNCTION (ID,CREATETIME,ISLEAF,LASTSAVED,MENUICON,MENUURL,NAME,ORDERNUM,PARENTID) values ('1',null,0,null,'layui-icon-home','#','主页',1,'-1');
-Insert into TB_FUNCTION (ID,CREATETIME,ISLEAF,LASTSAVED,MENUICON,MENUURL,NAME,ORDERNUM,PARENTID) values ('2',null,1,null,'layui-icon-home','/home/console','控制台',1,'1');
-Insert into TB_FUNCTION (ID,CREATETIME,ISLEAF,LASTSAVED,MENUICON,MENUURL,NAME,ORDERNUM,PARENTID) values ('3',null,0,null,'layui-icon-set','#','系统中心',2,'-1');
-Insert into TB_FUNCTION (ID,CREATETIME,ISLEAF,LASTSAVED,MENUICON,MENUURL,NAME,ORDERNUM,PARENTID) values ('4',null,1,null,'layui-icon-set','/operator/index','管理员维护',1,'3');
-Insert into TB_FUNCTION (ID,CREATETIME,ISLEAF,LASTSAVED,MENUICON,MENUURL,NAME,ORDERNUM,PARENTID) values ('5',null,1,null,'layui-icon-set','/role/index','角色管理',2,'3');
+INSERT INTO "tb_function" ("id", "createtime", "isleaf", "lastsaved", "menuicon", "menuurl", "name", "ordernum", "parentid")
+VALUES ('1', NULL, '0', NULL, 'layui-icon-home', '#', '主页', '1', '-1'),
+('2', NULL, '1', NULL, 'layui-icon-home', '/home/console', '控制台', '1', '1'),
+('3', NULL, '0', NULL, 'layui-icon-set', '#', '系统中心', '2', '-1'),
+('4', NULL, '1', NULL, 'layui-icon-set', '/function/index', '功能维护', '1', '3'),
+('5', NULL, '1', NULL, 'layui-icon-set', '/role/index', '角色管理', '2', '3'),
+('6', NULL, '1', NULL, 'layui-icon-set', '/operator/index', '操作员管理', '4', '3'),
+('7', NULL, '0', NULL, 'layui-icon-release', '#', '商户中心', '4', '-1'),
+('9', NULL, '1', NULL, '', '/operator/logs', '操作日志', '4', '3'),
+('10', NULL, '0', NULL, 'layui-icon-util', '#', '参数管理', '3', '-1'),
+('11', NULL, '1', NULL, 'layui-icon-util', '/param/syspara', '全局参数配置', '1', '10'),
+('12', NULL, '1', NULL, 'layui-icon-util', '/param/businesspara', '业务参数配置', '2', '10'),
+('17', NULL, '1', NULL, 'layui-icon-util', '/param/apiclientpara', '应用参数配置', '3', '10'),
+('18', NULL, '1', NULL, 'layui-icon-util', '/param/paytype', '支付能力配置', '4', '10'),
+('19', NULL, '0', NULL, 'layui-icon-user', '#', '用户中心', '5', '-1'),
+('20', NULL, '0', NULL, 'layui-icon-rmb', '#', '结算中心', '6', '-1'),
+('21', NULL, '1', NULL, '', '/user/index', '用户管理', '1', '19'),
+('22', NULL, '1', NULL, '', '/user/acc', '账户管理', '2', '19'),
+('23', NULL, '1', NULL, '', '/shop/index', '商户管理', '1', '7'),
+('24', NULL, '1', NULL, '', '/user/point', '积分管理', '3', '19'),
+('25', NULL, '1', NULL, '', '/shop/config', '商户支付能力配置', '2', '7'),
+('26', NULL, '0', NULL, 'layui-icon-tabs', '#', '流水管理', '3', '-1'),
+('27', NULL, '1', NULL, '', '/dtl/userdtl', '个人流水查询', '1', '26'),
+('28', NULL, '1', NULL, '', '/dtl/shopdtl', '商户流水查询', '2', '26'),
+('29', NULL, '1', NULL, '', '/report/subjectday', '科目汇总表', '1', '20'),
+('30', NULL, '1', NULL, '', '/report/subjectdetail', '科目明细账', NULL, '20'),
+('31', NULL, '1', NULL, '', '/report/shopbusiness', '商户营业情况表', NULL, '20');
Insert into TB_ROLE_FUNCTION (ID,FUNCTIONID,ROLEID) values ('5','5','d1yctWs5+ks0iQN3m9bUvRHus6HbKbrs');
@@ -34,6 +46,118 @@
Insert into TB_ROLE_FUNCTION (ID,FUNCTIONID,ROLEID) values ('3','3','d1yctWs5+ks0iQN3m9bUvRHus6HbKbrs');
Insert into TB_ROLE_FUNCTION (ID,FUNCTIONID,ROLEID) values ('4','4','d1yctWs5+ks0iQN3m9bUvRHus6HbKbrs');
+
+
+INSERT INTO "tb_resource" ("id", "code", "function_id", "name", "uri")
+VALUES ('4', '1', '4', '添加功能', '/function/add'),
+('5', '', '4', '添加父功能', '/function/loadadd'),
+('6', '1', '6', '查询', '/operator/index'),
+('7', '', '6', '添加查询', '/operator/load4add'),
+('8', '', '6', '添加和修改', '/operator/add'),
+('9', '', '6', '重置密码', '/operator/resetpwd'),
+('10', '', '4', '查询', '/function/index'),
+('11', '', '4', '删除', '/function/delfunc'),
+('12', '', '4', '添加子功能', '/function/loadsubadd'),
+('13', '', '4', '维护资源', '/function/loadres'),
+('14', '', '4', '添加资源', '/function/addres'),
+('15', '', '4', '删除资源', '/function/delres'),
+('16', '', '5', '查询', '/role/index'),
+('17', '', '5', '添加', '/role/add'),
+('19', '', '5', '分配功能', '/role/addfunc'),
+('20', '', '5', '加载分配功能', '/role/loadfunc'),
+('21', '', '5', '删除角色', '/role/del'),
+('22', '', '6', '修改状态', '/operator/updatestate'),
+('24', '', '9', '查询', '/operator/logslist'),
+('26', '', '11', '修改', '/param/sysparaupdate'),
+('27', '', '11', '查询', '/param/syspara'),
+('28', '', '12', '查询', '/param/businesspara'),
+('29', '', '12', '删除', '/param/deletebusinesspara'),
+('30', '', '12', '修改', '/param/businessparaupdate'),
+('32', '', '12', '新增', '/param/addbusinesspara'),
+('33', '', '12', '新增跳转', '/param/load4addbuspara'),
+('34', '', '17', '查询', '/param/apiclientpara'),
+('35', '', '17', '新增修改跳转', '/param/load4addapiclient'),
+('36', '', '17', '修改状态', '/param/updateapiclientstate'),
+('37', '', '17', '删除', '/param/deleteapiclient'),
+('39', '', '17', '修改', '/param/updateapiclientpara'),
+('40', '', '17', '新增', '/param/addapiclientpara'),
+('41', '', '18', '查询', '/param/paytype'),
+('42', '', '21', '查询', '/user/list'),
+('43', '', '18', '新增跳转', '/param/load4addpaytype'),
+('44', '', '18', '切换状态', '/param/updatepaytypestate'),
+('45', '', '18', '修改', '/param/updatepaytypename'),
+('46', '', '18', '删除', '/param/deletepaytype'),
+('48', '', '18', '配置跳转', '/param/load4paytypeconfig'),
+('49', '', '18', '配置参数', '/param/addpaytypeconfig'),
+('50', '', '22', '查询', '/user/account'),
+('52', '', '24', '查询', '/user/pointlist'),
+('53', '', '23', '删除', '/shop/deleteshop'),
+('54', '', '21', '添加', '/user/add'),
+('56', '', '23', '查询', '/shop/getshopinfo'),
+('57', '', '23', '商户树', '/shop/index'),
+('58', '', '23', '新增修改', '/shop/saveorupdate'),
+('59', '', '21', '删除', '/user/del'),
+('60', '', '21', '注销账户', '/user/delacc'),
+('61', '', '21', '删除积分账户', '/user/delpoint'),
+('63', '', '25', '商户树', '/shop/config'),
+('64', '', '25', '查询', '/shop/shoppaytypelist'),
+('65', '', '25', '切换状态', '/shop/updatepaytypestat'),
+('66', '', '25', '新增跳转', '/shop/load4addpaytype'),
+('67', '', '25', '新增', '/shop/addshoppaytype'),
+('68', '', '25', '配置跳转', '/shop/load4paytypepara'),
+('69', '', '25', '配置', '/shop/addpaytypepara'),
+('70', '', '27', '查询', '/dtl/userdtl'),
+('71', '', '28', '查询', '/dtl/shopdtl'),
+('72', '', '29', '查询', '/report/subjectday'),
+('73', '', '30', '查询', '/report/subjectdetail'),
+('74', '', '31', '查询', '/report/shopbusiness'),
+('76', '', '18', '新增', '/param/addpaytype');
+
+
+INSERT INTO "tb_subject" ("subjno", "balflag", "displayflag", "endflag", "fsubjno", "opendate", "subjlevel", "subjname", "subjtype")
+VALUES ('1001', '1', 'y', '1', NULL, '20190430', '1', '库存现金', '1'),
+('1002', '1', 'y', '1', NULL, '20190430', '1', '银行存款', '1'),
+('1121', '1', 'n', '0', NULL, '20190430', '1', '应收票据', '1'),
+('112101', '1', 'n', '1', '1121', '20190430', '2', '支票', '1'),
+('112102', '1', 'n', '1', '1121', '20190430', '2', '经费本', '1'),
+('1122', '1', 'y', '0', NULL, '20190430', '1', '应收账款', '1'),
+('112201', '1', 'y', '1', '1122', '20190430', '2', '现金充值款', '1'),
+('112209', '1', 'y', '1', '1122', '20190617', '2', '其他第三方充值款', '1'),
+('112210', '1', 'y', '1', '1122', '20190430', '2', '支付宝充值款', '1'),
+('112211', '1', 'y', '1', '1122', '20190430', '2', '微信充值款', '1'),
+('112212', '1', 'n', '1', '1122', '20190430', '2', '银联充值款', '1'),
+('112213', '1', 'y', '1', '1122', '20190430', '2', '一卡通充值款', '1'),
+('112230', '1', 'y', '1', '1122', '20190430', '2', '支付宝支付款', '1'),
+('112231', '1', 'y', '1', '1122', '20190430', '2', '微信支付款', '1'),
+('112232', '1', 'n', '1', '1122', '20190430', '2', '银联支付款', '1'),
+('112233', '1', 'y', '1', '1122', '20190430', '2', '一卡通支付款', '1'),
+('112234', '1', 'y', '1', '1122', NULL, '2', '市民卡支付款', '1'),
+('2001', '2', 'n', '1', NULL, '20190430', '1', '用户押金', '2'),
+('2004', '2', 'y', '1', NULL, '20190430', '1', '商户营业款', '2'),
+('2202', '2', 'y', '0', NULL, '20190430', '1', '应付账款', '2'),
+('220201', '2', 'y', '1', '2202', '20190430', '2', '个人存款', '2'),
+('220211', '2', 'n', '1', '2202', '20190430', '2', '销户退款', '2'),
+('6021', '2', 'y', '0', NULL, '20190430', '1', '手续费收入', '6'),
+('602101', '2', 'y', '1', '6021', '20190430', '2', '支付宝充值手续费', '6'),
+('602102', '2', 'y', '1', '6021', '20190430', '2', '微信充值手续费', '6'),
+('602103', '2', 'n', '1', '6021', '20190430', '2', '银联充值手续费', '6'),
+('6601', '2', 'y', '0', NULL, '20190430', '1', '销售费用', '6'),
+('660101', '2', 'y', '1', '6601', '20190430', '2', '折扣优惠款', '6'),
+('660102', '2', 'y', '1', '6601', '20190430', '2', '积分抵扣款', '6'),
+('6602', '2', 'y', '1', NULL, '20190430', '1', '管理费收入', '6');
+
+update TB_SUBJECT set opendate = to_number(to_char(CURRENT_TIMESTAMP,'yyyymmdd'),'99999999');
+
+
+INSERT INTO "tb_sourcetype" ("sourcetype", "checkable", "paydesc", "reversable", "dps_enable",
+"anonymous_enable", "charge_enable", "consume_enable", "enable")
+VALUES ('alipay', 't', '支付宝', 't', 't', 't', 't', 't', 't'),
+('balance', 't', '账户余额', 't', 't', 't', 't', 't', 't'),
+('citizenCard', 't', '大理市民卡', 't', 't', 't', 't', 't', 't'),
+('thirdpart', 'f', '其他第三方支付', NULL, NULL, 'f', 't', 'f', 't'),
+('wechat', 't', '微信支付', 't', 't', 't', 't', 't', 't'),
+('yktpay', 't', '一卡通支付', 't', 't', 't', 't', 't', 't');
+
-- 支付方式
Insert into TB_PAYTYPE (PAYTYPE,DPS_ENABLE,ENABLE,REVERSE_ENABLE) values ('yktpay','no','yes','yes');
@@ -41,63 +165,43 @@
Insert into TB_PAYTYPE_CONFIG (PAYTYPE,CONFIGID,CONFIG_NAME,CONFIG_VALUE) values ('yktpay','appkey',null,'adc4ac6822fd462780f878b86cb94688');
Insert into TB_PAYTYPE_CONFIG (PAYTYPE,CONFIGID,CONFIG_NAME,CONFIG_VALUE) values ('yktpay','orderurl',null,'http://172.28.201.101:9116/epayapi/services/thirdparty/common/pay');
Insert into TB_PAYTYPE_CONFIG (PAYTYPE,CONFIGID,CONFIG_NAME,CONFIG_VALUE) values ('yktpay','reverseurl',null,'http://172.28.201.101:9116/epayapi/services/thirdparty/common/payreverse');
--- 资产类
-Insert into TB_SUBJECT (SUBJNO,SUBJNAME,SUBJTYPE,BALFLAG,FSUBJNO,SUBJLEVEL,ENDFLAG,OPENDATE,DISPLAYFLAG) values ('1001','库存现金',1,1,null,1,1,null,'y');
-Insert into TB_SUBJECT (SUBJNO,SUBJNAME,SUBJTYPE,BALFLAG,FSUBJNO,SUBJLEVEL,ENDFLAG,OPENDATE,DISPLAYFLAG) values ('1002','银行存款',1,1,null,1,1,null,'y');
-
-Insert into TB_SUBJECT (SUBJNO,SUBJNAME,SUBJTYPE,BALFLAG,FSUBJNO,SUBJLEVEL,ENDFLAG,OPENDATE,DISPLAYFLAG) values ('1121','应收票据',1,1,null,1,0,null,'y');
-Insert into TB_SUBJECT (SUBJNO,SUBJNAME,SUBJTYPE,BALFLAG,FSUBJNO,SUBJLEVEL,ENDFLAG,OPENDATE,DISPLAYFLAG) values ('112101','支票',1,1,'1121',2,1,null,'y');
-Insert into TB_SUBJECT (SUBJNO,SUBJNAME,SUBJTYPE,BALFLAG,FSUBJNO,SUBJLEVEL,ENDFLAG,OPENDATE,DISPLAYFLAG) values ('112102','经费本',1,1,'1121',2,1,null,'y');
-
-Insert into TB_SUBJECT (SUBJNO,SUBJNAME,SUBJTYPE,BALFLAG,FSUBJNO,SUBJLEVEL,ENDFLAG,OPENDATE,DISPLAYFLAG) values ('1122','应收账款',1,1,null,1,0,null,'y');
-Insert into TB_SUBJECT (SUBJNO,SUBJNAME,SUBJTYPE,BALFLAG,FSUBJNO,SUBJLEVEL,ENDFLAG,OPENDATE,DISPLAYFLAG) values ('112201','现金充值款',1,1,'1122',2,1,null,'y');
-
-Insert into TB_SUBJECT (SUBJNO,SUBJNAME,SUBJTYPE,BALFLAG,FSUBJNO,SUBJLEVEL,ENDFLAG,OPENDATE,DISPLAYFLAG) values ('112210','支付宝充值款',1,1,'1122',2,1,null,'y');
-Insert into TB_SUBJECT (SUBJNO,SUBJNAME,SUBJTYPE,BALFLAG,FSUBJNO,SUBJLEVEL,ENDFLAG,OPENDATE,DISPLAYFLAG) values ('112211','微信充值款',1,1,'1122',2,1,null,'y');
-Insert into TB_SUBJECT (SUBJNO,SUBJNAME,SUBJTYPE,BALFLAG,FSUBJNO,SUBJLEVEL,ENDFLAG,OPENDATE,DISPLAYFLAG) values ('112212','银联充值款',1,1,'1122',2,1,null,'y');
-Insert into TB_SUBJECT (SUBJNO,SUBJNAME,SUBJTYPE,BALFLAG,FSUBJNO,SUBJLEVEL,ENDFLAG,OPENDATE,DISPLAYFLAG) values ('112213','一卡通充值款',1,1,'1122',2,1,null,'y');
-
-Insert into TB_SUBJECT (SUBJNO,SUBJNAME,SUBJTYPE,BALFLAG,FSUBJNO,SUBJLEVEL,ENDFLAG,OPENDATE,DISPLAYFLAG) values ('112230','支付宝支付款',1,1,'1122',2,1,null,'y');
-Insert into TB_SUBJECT (SUBJNO,SUBJNAME,SUBJTYPE,BALFLAG,FSUBJNO,SUBJLEVEL,ENDFLAG,OPENDATE,DISPLAYFLAG) values ('112231','微信支付款',1,1,'1122',2,1,null,'y');
-Insert into TB_SUBJECT (SUBJNO,SUBJNAME,SUBJTYPE,BALFLAG,FSUBJNO,SUBJLEVEL,ENDFLAG,OPENDATE,DISPLAYFLAG) values ('112232','银联支付款',1,1,'1122',2,1,null,'y');
-Insert into TB_SUBJECT (SUBJNO,SUBJNAME,SUBJTYPE,BALFLAG,FSUBJNO,SUBJLEVEL,ENDFLAG,OPENDATE,DISPLAYFLAG) values ('112233','一卡通支付款',1,1,'1122',2,1,null,'y');
-
--- 负债类
-Insert into TB_SUBJECT (SUBJNO,SUBJNAME,SUBJTYPE,BALFLAG,FSUBJNO,SUBJLEVEL,ENDFLAG,OPENDATE,DISPLAYFLAG) values ('2001','用户押金',2,2,null,1,1,null,'y');
-Insert into TB_SUBJECT (SUBJNO,SUBJNAME,SUBJTYPE,BALFLAG,FSUBJNO,SUBJLEVEL,ENDFLAG,OPENDATE,DISPLAYFLAG) values ('2004','商户营业款',2,2,null,1,1,null,'y');
-
-Insert into TB_SUBJECT (SUBJNO,SUBJNAME,SUBJTYPE,BALFLAG,FSUBJNO,SUBJLEVEL,ENDFLAG,OPENDATE,DISPLAYFLAG) values ('2202','应付账款',2,2,null,1,0,null,'y');
-Insert into TB_SUBJECT (SUBJNO,SUBJNAME,SUBJTYPE,BALFLAG,FSUBJNO,SUBJLEVEL,ENDFLAG,OPENDATE,DISPLAYFLAG) values ('220201','个人存款',2,2,'2202',2,1,null,'y');
-Insert into TB_SUBJECT (SUBJNO,SUBJNAME,SUBJTYPE,BALFLAG,FSUBJNO,SUBJLEVEL,ENDFLAG,OPENDATE,DISPLAYFLAG) values ('220211','销户退款',2,2,'2202',2,1,null,'y');
-
--- 损益类
-Insert into TB_SUBJECT (SUBJNO,SUBJNAME,SUBJTYPE,BALFLAG,FSUBJNO,SUBJLEVEL,ENDFLAG,OPENDATE,DISPLAYFLAG) values ('6021','手续费收入',6,2,null,1,0,null,'y');
-Insert into TB_SUBJECT (SUBJNO,SUBJNAME,SUBJTYPE,BALFLAG,FSUBJNO,SUBJLEVEL,ENDFLAG,OPENDATE,DISPLAYFLAG) values ('602101','支付宝充值手续费',6,2,'6021',2,1,null,'y');
-Insert into TB_SUBJECT (SUBJNO,SUBJNAME,SUBJTYPE,BALFLAG,FSUBJNO,SUBJLEVEL,ENDFLAG,OPENDATE,DISPLAYFLAG) values ('602102','微信充值手续费',6,2,'6021',2,1,null,'y');
-Insert into TB_SUBJECT (SUBJNO,SUBJNAME,SUBJTYPE,BALFLAG,FSUBJNO,SUBJLEVEL,ENDFLAG,OPENDATE,DISPLAYFLAG) values ('602103','银联充值手续费',6,2,'6021',2,1,null,'y');
-
-Insert into TB_SUBJECT (SUBJNO,SUBJNAME,SUBJTYPE,BALFLAG,FSUBJNO,SUBJLEVEL,ENDFLAG,OPENDATE,DISPLAYFLAG) values ('6601','销售费用',6,2,null,1,0,null,'y');
-Insert into TB_SUBJECT (SUBJNO,SUBJNAME,SUBJTYPE,BALFLAG,FSUBJNO,SUBJLEVEL,ENDFLAG,OPENDATE,DISPLAYFLAG) values ('660101','折扣优惠款',6,2,'6601',2,1,null,'y');
-Insert into TB_SUBJECT (SUBJNO,SUBJNAME,SUBJTYPE,BALFLAG,FSUBJNO,SUBJLEVEL,ENDFLAG,OPENDATE,DISPLAYFLAG) values ('660102','积分抵扣款',6,2,'6601',2,1,null,'y');
-
-Insert into TB_SUBJECT (SUBJNO,SUBJNAME,SUBJTYPE,BALFLAG,FSUBJNO,SUBJLEVEL,ENDFLAG,OPENDATE,DISPLAYFLAG) values ('6602','管理费收入',6,2,null,1,1,null,'y');
--- -- oracle --
--- update TB_SUBJECT set opendate = to_char(sysdate,'yyyyMMdd');
-update TB_SUBJECT set opendate = to_number(to_char(CURRENT_TIMESTAMP,'yyyymmdd'),'99999999');
- -- oracle --
-/*
-insert into TB_SETTLECTL(BOOKSETNO,PERIODYEAR,PERIODMONTH,STATDATE,SETTLEDATE,STATUS,updtime)
-values (1,to_number(to_char(sysdate,'yyyy')),to_number(to_char(sysdate,'MM')),to_number(to_char(sysdate,'yyyyMMdd')),to_number(to_char(sysdate,'yyyyMMdd')),0,to_char(sysdate,'yyyyMMddhh24miss'));
-insert into TB_VOUCHERNOCTL(VOUCHERTYPE,PERIODMONTH,VOUCHERNO)
-values (1,to_number(to_char(sysdate,'MM')),0);
+INSERT INTO "tb_syspara" ("paraid", "displayflag", "editflag", "lastsaved", "paraname",
+"paraunit", "paraval", "remark", "valuetype")
+VALUES ('1', 'yes', '1', '20190514165658', '账户最大余额默认值', '元', '10001', '账户开户时的默认账户最大余额', 'amount');
-commit;
-*/
--- --pg--
+
+INSERT INTO "tb_task_lock" ("taskcode", "remark", "taskstatus", "tasktime")
+VALUES ('DAYENDSETTLETASK', '日终结算', '0', '20190619100600');
+
+
+INSERT INTO "tb_transcode" ("transcode", "transname")
+VALUES ('3010', '市民卡代扣'),
+('3500', '账户充值');
+
+
+INSERT INTO "tb_dictionary" ("dictval", "dicttype", "dictcaption", "dicttypename")
+VALUES ('cancel', '1', '冲正', '冲正状态'),
+('cancel', '2', '交易取消', '流水状态'),
+('fail', '2', '交易失败', '流水状态'),
+('init', '2', '初始化', '流水状态'),
+('none', '1', ' ', '冲正状态'),
+('reverse', '1', '手工撤销', '冲正状态'),
+('success', '2', '交易成功', '流水状态'),
+('wip', '2', '待支付', '流水状态');
+
+
+
+INSERT INTO "public"."tb_apiclient" ("appid", "roles", "secret", "status", "bcrypt_secret", "thirdurl")
+VALUES ('100001', 'ROLE_THIRD_ADMIN;ROLE_THIRD_CONSUME;ROLE_THIRD_DEPOSIT', '$2a$10$Xa/UKDQ/WkiKVQAyv5Hu4eiqt6HtwVK3YA0Glg1/y1uiEsXnG7ZeS', 'normal', '$2a$10$VXISc2jXrJCZHIaOZ4Fc3OPvlT9QihAkC2h9n6uNe317HzIbuZU6a', NULL),
+('200001', 'ROLE_THIRD_ADMIN;ROLE_THIRD_DEPOSIT;ROLE_THIRD_CONSUME;ROLE_THIRD_SHOP;ROLE_THIRD_COMMON', 'oUw2NmA09ficiVWD4TUQLDOkPyzQa3VzbjjsW0B2qTk=', 'normal', '$2a$10$UR8FYSu4jpE3Mj/CwfWrlOqocMAKHDEiaFZghBFonxTJN1KAQZfyO', NULL),
+('700001', 'ROLE_THIRD_DEPOSIT;ROLE_THIRD_ADMIN;ROLE_THIRD_CONSUME;ROLE_THIRD_COMMON', '8455ff2162c0438583cb3f974cf214b4', 'normal', '$2a$10$2zp6c0PaUkTEftKt.PLznOFW/ncMeun4Z7pKtpE5Do5C/rrKo98fe', NULL);
+
+
+--pg--
insert into TB_SETTLECTL(BOOKSETNO,PERIODYEAR,PERIODMONTH,STATDATE,SETTLEDATE,STATUS,updtime)
values (1,to_number(to_char(CURRENT_TIMESTAMP,'yyyy'),'9999'),to_number(to_char(CURRENT_TIMESTAMP,'MM'),'99'),to_number(to_char(CURRENT_TIMESTAMP,'yyyyMMdd'),'99999999'),to_number(to_char(CURRENT_TIMESTAMP,'yyyyMMdd'),'99999999'),0,to_char(CURRENT_TIMESTAMP,'yyyyMMddhh24miss'));