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