src/main/resources/import.sql

INSERT INTO tb_operator(
	operid, closedate, opendate, opercode, opername, operpwd, opertype, transStatus)
	VALUES ('LOR2IwRkbOjp+sVG9KR2BpHZbwGKepS4', '20500101', '20190101', 'system', '系统管理员', '$2a$10$Ex9xp11.vCaD8D0a7ahiUOKqDij1TcCUBwRAmrqXeDvAkmzLibn4.', 'oper', 'normal');

INSERT INTO tb_role(
	roleid, createtime, editflag, lastsaved, rolecode, roledesc, rolename)
	VALUES ('d1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', '20190101000000', 0, '', 'ROLE_ADMIN', '超级管理员', '超级管理员');

INSERT INTO tb_oper_role(
	id, operid, roleid)
	VALUES ('1', 'LOR2IwRkbOjp+sVG9KR2BpHZbwGKepS4', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs');


INSERT INTO "tb_function" ("id", "createtime", "isleaf", "lastsaved", "menuicon",
"menuurl", "name", "ordernum", "parentid", "tenantid")
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 "public"."tb_role_function" ("id", "functionid", "roleid", "permissions")
VALUES
('ff8080816b7947ed016b7955772c0032', '1', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
('ff8080816b7947ed016b7955772d0033', '2', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
('ff8080816b7947ed016b7955772d0034', '3', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
('ff8080816b7947ed016b7955772d0035', '5', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
('ff8080816b7947ed016b79557730003b', '6', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
('ff8080816b7947ed016b795577310041', '4', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
('ff8080816b7947ed016b79557732004a', '9', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
('ff8080816b7947ed016b79557732004c', '7', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
('ff8080816b7947ed016b79557732004d', '23', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
('ff8080816b7947ed016b795577330052', '25', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
('ff8080816b7947ed016b79557733005a', '20', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
('ff8080816b7947ed016b79557733005b', '29', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
('ff8080816b7947ed016b79557733005d', '30', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
('ff8080816b7947ed016b79557733005f', '31', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
('ff8080816b7947ed016b795577340061', '19', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
('ff8080816b7947ed016b795577340062', '21', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
('ff8080816b7947ed016b795577350068', '24', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
('ff8080816b7947ed016b79557735006a', '22', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
('ff8080816b7947ed016b79557735006c', '26', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
('ff8080816b7947ed016b79557735006d', '27', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
('ff8080816b7947ed016b79557735006f', '28', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
('ff8080816b7947ed016b795577350071', '10', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
('ff8080816b7947ed016b795577350072', '11', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
('ff8080816b7947ed016b795577360074', '17', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
('ff8080816b7947ed016b79557736007b', '12', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
('ff8080816b7947ed016b795577370081', '18', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL);

Insert into TB_ROLE_FUNCTION (ID,FUNCTIONID,ROLEID) values ('5','5','d1yctWs5+ks0iQN3m9bUvRHus6HbKbrs');
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_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');

Insert into TB_PAYTYPE_CONFIG (PAYTYPE,CONFIGID,CONFIG_NAME,CONFIG_VALUE) values ('yktpay','appid',null,'100005');
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_syspara" ("paraid", "displayflag", "editflag", "lastsaved", "paraname",
"paraunit", "paraval", "remark", "valuetype")
VALUES ('1', 'yes', '1', '20190514165658', '账户最大余额默认值', '元', '10001', '账户开户时的默认账户最大余额', 'amount');



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'));

insert into TB_VOUCHERNOCTL(VOUCHERTYPE,PERIODMONTH,VOUCHERNO)
values (1,to_number(to_char(CURRENT_TIMESTAMP,'MM'),'99'),0);
Insert into TB_SUBJECT (SUBJNO,SUBJNAME,SUBJTYPE,BALFLAG,FSUBJNO,SUBJLEVEL,ENDFLAG,OPENDATE,DISPLAYFLAG) values ('112234','市民卡支付款',1,1,'1122',2,1,null,'y');

---------  end of script
commit;