项目实训第三周1

sql语句

人员管理，成员调动sql

INSERT INTO SYS_MODULES (`MODULE_ID`, `MODULE_NAME`, `PARENT_MODULE_ID`, `IS_LEAF`, `SEQ`, `CREATOR`, `CREATE_TIME`, `LAST_EDITOR`, `LAST_TIME`, `MODULE_CODE`) VALUES ('13316d2ed2934857ba8c91dece5528e8', '人员管理', '1', '1', '11', 'superadmin', '2021-07-06 08:55:47', NULL, NULL, '0093');
INSERT INTO SYS_FUNCTIONS (`FUNCTION_ID`, `MODULE_ID`, `FUNCTION_CODE`, `FUNCTION_NAME`, `IS_SYS`, `DATA_RES_TYPE`, `SEQ`, `CREATOR`, `CREATE_TIME`, `LAST_EDITOR`, `LAST_TIME`) VALUES ('ef2ade3a2c684f3394612fc349c3728f', '13316d2ed2934857ba8c91dece5528e8', '00930105', '员工信息管理', '1', NULL, '1', 'superadmin', '2021-07-06 08:56:19', NULL, NULL);
INSERT INTO SYS_RESOURCES (`RESOURCE_ID`, `RESOURCE_NAME`, `RESOURCE_ALIAS`, `IS_DEFAULT`, `IS_AUDIT`, `FUNCTION_ID`, `RES_TYPE_ID`, `SEQ`, `IS_REPEAT_AUTHENTICATE`, `CREATOR`, `CREATE_TIME`, `LAST_EDITOR`, `LAST_TIME`, `RESOURCE_CODE`, `URL_NAMES`, `PERMISSIONS`) VALUES ('181a2c5e1033453195899eff4f4c1650', '员工信息管理', '主要包括人员入职、离职管理、人员调动、人员查询功能', '0', '0', 'ef2ade3a2c684f3394612fc349c3728f', '1', '1', '0', 'superadmin', '2021-07-06 08:58:26', 'superadmin', '2021-07-06 09:01:27', '009301050173', '/staffInfo/view', 'staffInfo:view');
INSERT INTO SYS_ROLE_RESOURCE (`ROLE_ID`, `RESOURCE_ID`, `CREATOR`, `CREATE_TIME`, `LAST_EDITOR`, `LAST_TIME`) VALUES ('superadmin_role', '181a2c5e1033453195899eff4f4c1650', 'superadmin', '2021-07-06 09:01:29', 'superadmin', '2021-07-06 09:01:29');
INSERT INTO SYS_FUNCTIONS (`FUNCTION_ID`, `MODULE_ID`, `FUNCTION_CODE`, `FUNCTION_NAME`, `IS_SYS`, `DATA_RES_TYPE`, `SEQ`, `CREATOR`, `CREATE_TIME`, `LAST_EDITOR`, `LAST_TIME`) VALUES ('2f94fb49818a43c18b0fa3f009a2f328', '13316d2ed2934857ba8c91dece5528e8', '00930106', '员工调动日志', '1', NULL, '2', 'superadmin', '2021-07-07 09:46:07', NULL, NULL);
INSERT INTO SYS_RESOURCES (`RESOURCE_ID`, `RESOURCE_NAME`, `RESOURCE_ALIAS`, `IS_DEFAULT`, `IS_AUDIT`, `FUNCTION_ID`, `RES_TYPE_ID`, `SEQ`, `IS_REPEAT_AUTHENTICATE`, `CREATOR`, `CREATE_TIME`, `LAST_EDITOR`, `LAST_TIME`, `RESOURCE_CODE`, `URL_NAMES`, `PERMISSIONS`) VALUES ('85ef7628f2a041c89d3995b9349e8cfd', '员工调动日志', '查看记录员工的调动记录', '0', '0', '2f94fb49818a43c18b0fa3f009a2f328', '1', '1', '0', 'superadmin', '2021-07-07 09:46:52', NULL, NULL, '009301060174', '/staffTransfer/view', 'staffTransfer:view');
INSERT INTO SYS_ROLE_RESOURCE (`ROLE_ID`, `RESOURCE_ID`, `CREATOR`, `CREATE_TIME`, `LAST_EDITOR`, `LAST_TIME`) VALUES ('superadmin_role', '85ef7628f2a041c89d3995b9349e8cfd', 'superadmin', '2021-07-07 09:46:55', 'superadmin', '2021-07-07 09:46:55');
INSERT INTO SYS_MENU (`MENU_ID`, `TEXT`, `MENU_ALIAS`, `TITLE`, `TYPE_ID`, `PARENT_ID`, `SEQ`, `IS_LEAF`, `TYPE`, `VALUE`, `TARGET`, `ICONS`, `RESOURCE_ID`, `OPEN_TYPE`) VALUES ('7b8520bd1eeb4fc691b0274f349d9206', '人员管理', '人员管理', '管理员工的各种信息', NULL, '1', '11', '0', NULL, NULL, NULL, '', '', 'tab');
INSERT INTO SYS_MENU (`MENU_ID`, `TEXT`, `MENU_ALIAS`, `TITLE`, `TYPE_ID`, `PARENT_ID`, `SEQ`, `IS_LEAF`, `TYPE`, `VALUE`, `TARGET`, `ICONS`, `RESOURCE_ID`, `OPEN_TYPE`) VALUES ('3f95139fd9104990a171bbbc23361a11', '员工基本信息', '员工基本信息', '可以查看，修改，录入员工信息以及', NULL, '7b8520bd1eeb4fc691b0274f349d9206', '1', '1', NULL, NULL, NULL, '', '181a2c5e1033453195899eff4f4c1650', 'tab');
INSERT INTO SYS_MENU (`MENU_ID`, `TEXT`, `MENU_ALIAS`, `TITLE`, `TYPE_ID`, `PARENT_ID`, `SEQ`, `IS_LEAF`, `TYPE`, `VALUE`, `TARGET`, `ICONS`, `RESOURCE_ID`, `OPEN_TYPE`) VALUES ('3c8559fc2a0441da894d06e159db7ca5', '员工调动日志', '员工调动日志', '查看记录员工的部门调动日志', NULL, '7b8520bd1eeb4fc691b0274f349d9206', '2', '1', NULL, NULL, NULL, '', '85ef7628f2a041c89d3995b9349e8cfd', 'tab');

权限管理

INSERT INTO SYS_MODULES (`MODULE_ID`, `MODULE_NAME`, `PARENT_MODULE_ID`, `IS_LEAF`, `SEQ`, `CREATOR`, `CREATE_TIME`, `LAST_EDITOR`, `LAST_TIME`, `MODULE_CODE`) VALUES ('0b3915ceb08f4c3a8a876486879faf2f', 'salary权限管理', '1', '1', 12, 'superadmin', '2021-07-02 11:20:26', NULL, NULL, '0080');

INSERT INTO SYS_FUNCTIONS (`FUNCTION_ID`, `MODULE_ID`, `FUNCTION_CODE`, `FUNCTION_NAME`, `IS_SYS`, `DATA_RES_TYPE`, `SEQ`, `CREATOR`, `CREATE_TIME`, `LAST_EDITOR`, `LAST_TIME`) VALUES ('180c13a8677b4ed98bdf7921dc771fa8', '0b3915ceb08f4c3a8a876486879faf2f', '00800095', '权限查询', '1', NULL, 1, 'superadmin', '2021-07-02 11:20:40', NULL, NULL);

INSERT INTO SYS_RESOURCES (`RESOURCE_ID`, `RESOURCE_NAME`, `RESOURCE_ALIAS`, `IS_DEFAULT`, `IS_AUDIT`, `FUNCTION_ID`, `RES_TYPE_ID`, `SEQ`, `IS_REPEAT_AUTHENTICATE`, `CREATOR`, `CREATE_TIME`, `LAST_EDITOR`, `LAST_TIME`, `RESOURCE_CODE`, `URL_NAMES`, `PERMISSIONS`) VALUES ('92a5172927c14685bd95084929b4a726', '查询', '查询', '0', '0', '180c13a8677b4ed98bdf7921dc771fa8', '1', 1, '0', 'superadmin', '2021-07-02 11:23:04', NULL, NULL, '008000950168', '/accessList/view', 'accessList:view');

INSERT INTO SYS_ROLE_RESOURCE (`ROLE_ID`, `RESOURCE_ID`, `CREATOR`, `CREATE_TIME`, `LAST_EDITOR`, `LAST_TIME`) VALUES ('superadmin_role', '92a5172927c14685bd95084929b4a726', 'superadmin', '2021-07-02 11:23:13', 'superadmin', '2021-07-02 11:23:13');

INSERT INTO SYS_ROLE_RESOURCE (`ROLE_ID`, `RESOURCE_ID`, `CREATOR`, `CREATE_TIME`, `LAST_EDITOR`, `LAST_TIME`) VALUES ('93c5ce67674d42a1bb3ba254f370d80e', '92a5172927c14685bd95084929b4a726', 'superadmin', '2021-07-06 16:27:16', 'superadmin', '2021-07-06 16:27:16');

INSERT INTO SYS_ROLE_RESOURCE (`ROLE_ID`, `RESOURCE_ID`, `CREATOR`, `CREATE_TIME`, `LAST_EDITOR`, `LAST_TIME`) VALUES ('93c5ce67674d42a1bb3ba254f370d80e', 'e2edd5c396a64958b5d22409ea8a922a', 'superadmin', '2021-07-06 16:27:16', 'superadmin', '2021-07-06 16:27:16');

INSERT INTO SYS_ROLE_RESOURCE (`ROLE_ID`, `RESOURCE_ID`, `CREATOR`, `CREATE_TIME`, `LAST_EDITOR`, `LAST_TIME`) VALUES ('93c5ce67674d42a1bb3ba254f370d80e', '9c578d1ff9cd41edba96044ee8f12ad6', 'superadmin', '2021-07-06 16:27:16', 'superadmin', '2021-07-06 16:27:16');

INSERT INTO `sys_menu` (`MENU_ID`, `TEXT`, `MENU_ALIAS`, `TITLE`, `TYPE_ID`, `PARENT_ID`, `SEQ`, `IS_LEAF`, `TYPE`, `VALUE`, `TARGET`, `ICONS`, `RESOURCE_ID`, `OPEN_TYPE`) VALUES ('94a9afecf96149f5af68a4494a002283', 'salary权限管理', 'salary权限管理', 'salary权限管理', NULL, '1', 12, '1', NULL, NULL, NULL, '', '92a5172927c14685bd95084929b4a726', 'tab');