delete from sys_dict where `codeType`='fingercardState' and codeValue='0';
INSERT INTO `sys_dict` ( `isActive`, `updateTime`, `updateflag`, `codeType`, `tableName`, `description`, `codeValue`, `label`, `seq`)
VALUES ('1', NULL, NULL, 'fingercardState', NULL, '指纹卡号状态', '0', '待采集', '3');


delete from sys_dict where `codeType`='confirmOrder';
INSERT INTO `sys_dict` ( `isActive`, `updateTime`, `updateflag`, `codeType`, `tableName`, `description`, `codeValue`, `label`, `seq`)
VALUES ('1', NULL, NULL, 'confirmOrder', NULL, '确认成绩状态', '0', '未确认', '1'),
 ('1', NULL, NULL, 'confirmOrder', NULL, '确认成绩状态', '1', '已确认', '2');

delete from sys_dict where `codeType`='offApprovalStateBatch';
INSERT INTO `sys_dict` ( `isActive`, `updateTime`, `updateflag`, `codeType`, `tableName`, `description`, `codeValue`, `label`, `seq`)
VALUES ('1', NULL, NULL, 'offApprovalStateBatch', NULL, '线下审批状态', '002', '待审批', '1'),
 ('1', NULL, NULL, 'offApprovalStateBatch', NULL, '线下审批状态', '003', '初审通过', '2'),
 ('1', NULL, NULL, 'offApprovalStateBatch', NULL, '线下审批状态', '004', '审批不通过', '3'),
 ('1', NULL, NULL, 'offApprovalStateBatch', NULL, '线下审批状态', '005', '初审中', '4'),
 ('1', NULL, NULL, 'offApprovalStateBatch', NULL, '线下审批状态', '0031', '审批通过', '5'),
 ('1', NULL, NULL, 'offApprovalStateBatch', NULL, '线下审批状态', '0051', '线下审批中', '6');


delete from sys_dict where `codeType`='offApprovalState';
INSERT INTO `sys_dict` ( `isActive`, `updateTime`, `updateflag`, `codeType`, `tableName`, `description`, `codeValue`, `label`, `seq`)
VALUES ('1', NULL, NULL, 'offApprovalState', NULL, '线下审批状态', '003', '初审通过', '1'),
 ('1', NULL, NULL, 'offApprovalState', NULL, '线下审批状态', '004', '审批不通过', '2'),
 ('1', NULL, NULL, 'offApprovalState', NULL, '线下审批状态', '0031', '审批通过', '3'),
 ('1', NULL, NULL, 'offApprovalState', NULL, '线下审批状态', '0051', '线下审批中', '4'),
 ('1', NULL, NULL, 'offApprovalState', NULL, '线下审批状态', '009', '已撤销', '9');

INSERT INTO `sys_dict` ( `isActive`, `updateTime`, `updateflag`, `codeType`, `tableName`, `description`, `codeValue`, `label`, `seq`)
VALUES ( '1', NULL, NULL, 'testState', NULL, '考试状态', '2', '未考试', '3');

-- 菜单 SQL

delete from module_menu where parentIds like '%776400500833308672%';
INSERT INTO `module_menu`(`id`, `active`, `createTime`, `updateTime`, `updateBy`, `location`, `name`, `parentId`, `seq`, `menuType`,  `permission`, `parentIds`, `uniqueId`, `intranetFlag`, `superAdmin`, `platform`, `rankAuth`)
VALUES ('776400500833308672',true, now(), now(), 'system', '/subsidyOffline/list/index.do', '线下补贴审批单', '732603140909563904', '1000','0', NULL, '732603140909563904/776400500833308672/', 'subsidyOfflineList', '2', '0', '1', '1'),
('776400500841697280', true, now(), now(), 'system', NULL, '线下补贴审批单查询', '776400500833308672', '1', '1','subsidyOffline:view', '732603140909563904/776400500833308672/776400500841697280/', NULL, '2', '0', '1', '1'),
('776400500850085888', true, now(), now(), 'system', NULL, '线下补贴审批单审批', '776400500833308672', '2', '1','subsidyOffline:approve', '732603140909563904/776400500833308672/776400500850085888/', NULL, '1', '0', '1', '1');


# 20201113 增加理论学习进度字典
delete from sys_dict where codeType='learnRate';
INSERT INTO sys_dict( isActive, updateTime, updateflag, codeType, tableName, description, codeValue, label, seq) VALUES
( '1', '2020-11-13 15:19:52', true, 'learnRate', 'sb_personcertificate', '理论学习进度', '0', '未完成', null),
( '1', '2020-11-13 15:20:07', true, 'learnRate', 'sb_personcertificate', '理论学习进度', '1', '已完成', null);