ÎļþÃû´Ó sql/ry_20210908.sql ÐÞ¸Ä |
| | |
| | | insert into sys_menu values('500', 'æä½æ¥å¿', '108', '1', 'operlog', 'monitor/operlog/index', '', 1, 0, 'C', '0', '0', 'monitor:operlog:list', 'form', 'admin', sysdate(), '', null, 'æä½æ¥å¿èå');
|
| | | insert into sys_menu values('501', 'ç»å½æ¥å¿', '108', '2', 'logininfor', 'monitor/logininfor/index', '', 1, 0, 'C', '0', '0', 'monitor:logininfor:list', 'logininfor', 'admin', sysdate(), '', null, 'ç»å½æ¥å¿èå');
|
| | | -- ç¨æ·ç®¡çæé®
|
| | | insert into sys_menu values('1001', 'ç¨æ·æ¥è¯¢', '100', '1', '', '', '', 1, 0, 'F', '0', '0', 'system:user:query', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1002', 'ç¨æ·æ°å¢', '100', '2', '', '', '', 1, 0, 'F', '0', '0', 'system:user:add', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1003', 'ç¨æ·ä¿®æ¹', '100', '3', '', '', '', 1, 0, 'F', '0', '0', 'system:user:edit', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1004', 'ç¨æ·å é¤', '100', '4', '', '', '', 1, 0, 'F', '0', '0', 'system:user:remove', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1005', 'ç¨æ·å¯¼åº', '100', '5', '', '', '', 1, 0, 'F', '0', '0', 'system:user:export', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1006', 'ç¨æ·å¯¼å
¥', '100', '6', '', '', '', 1, 0, 'F', '0', '0', 'system:user:import', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1007', 'éç½®å¯ç ', '100', '7', '', '', '', 1, 0, 'F', '0', '0', 'system:user:resetPwd', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1000', 'ç¨æ·æ¥è¯¢', '100', '1', '', '', '', 1, 0, 'F', '0', '0', 'system:user:query', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1001', 'ç¨æ·æ°å¢', '100', '2', '', '', '', 1, 0, 'F', '0', '0', 'system:user:add', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1002', 'ç¨æ·ä¿®æ¹', '100', '3', '', '', '', 1, 0, 'F', '0', '0', 'system:user:edit', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1003', 'ç¨æ·å é¤', '100', '4', '', '', '', 1, 0, 'F', '0', '0', 'system:user:remove', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1004', 'ç¨æ·å¯¼åº', '100', '5', '', '', '', 1, 0, 'F', '0', '0', 'system:user:export', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1005', 'ç¨æ·å¯¼å
¥', '100', '6', '', '', '', 1, 0, 'F', '0', '0', 'system:user:import', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1006', 'éç½®å¯ç ', '100', '7', '', '', '', 1, 0, 'F', '0', '0', 'system:user:resetPwd', '#', 'admin', sysdate(), '', null, '');
|
| | | -- è§è²ç®¡çæé®
|
| | | insert into sys_menu values('1008', 'è§è²æ¥è¯¢', '101', '1', '', '', '', 1, 0, 'F', '0', '0', 'system:role:query', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1009', 'è§è²æ°å¢', '101', '2', '', '', '', 1, 0, 'F', '0', '0', 'system:role:add', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1010', 'è§è²ä¿®æ¹', '101', '3', '', '', '', 1, 0, 'F', '0', '0', 'system:role:edit', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1011', 'è§è²å é¤', '101', '4', '', '', '', 1, 0, 'F', '0', '0', 'system:role:remove', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1012', 'è§è²å¯¼åº', '101', '5', '', '', '', 1, 0, 'F', '0', '0', 'system:role:export', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1007', 'è§è²æ¥è¯¢', '101', '1', '', '', '', 1, 0, 'F', '0', '0', 'system:role:query', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1008', 'è§è²æ°å¢', '101', '2', '', '', '', 1, 0, 'F', '0', '0', 'system:role:add', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1009', 'è§è²ä¿®æ¹', '101', '3', '', '', '', 1, 0, 'F', '0', '0', 'system:role:edit', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1010', 'è§è²å é¤', '101', '4', '', '', '', 1, 0, 'F', '0', '0', 'system:role:remove', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1011', 'è§è²å¯¼åº', '101', '5', '', '', '', 1, 0, 'F', '0', '0', 'system:role:export', '#', 'admin', sysdate(), '', null, '');
|
| | | -- èå管çæé®
|
| | | insert into sys_menu values('1013', 'èåæ¥è¯¢', '102', '1', '', '', '', 1, 0, 'F', '0', '0', 'system:menu:query', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1014', 'èåæ°å¢', '102', '2', '', '', '', 1, 0, 'F', '0', '0', 'system:menu:add', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1015', 'èåä¿®æ¹', '102', '3', '', '', '', 1, 0, 'F', '0', '0', 'system:menu:edit', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1016', 'èåå é¤', '102', '4', '', '', '', 1, 0, 'F', '0', '0', 'system:menu:remove', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1012', 'èåæ¥è¯¢', '102', '1', '', '', '', 1, 0, 'F', '0', '0', 'system:menu:query', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1013', 'èåæ°å¢', '102', '2', '', '', '', 1, 0, 'F', '0', '0', 'system:menu:add', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1014', 'èåä¿®æ¹', '102', '3', '', '', '', 1, 0, 'F', '0', '0', 'system:menu:edit', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1015', 'èåå é¤', '102', '4', '', '', '', 1, 0, 'F', '0', '0', 'system:menu:remove', '#', 'admin', sysdate(), '', null, '');
|
| | | -- é¨é¨ç®¡çæé®
|
| | | insert into sys_menu values('1017', 'é¨é¨æ¥è¯¢', '103', '1', '', '', '', 1, 0, 'F', '0', '0', 'system:dept:query', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1018', 'é¨é¨æ°å¢', '103', '2', '', '', '', 1, 0, 'F', '0', '0', 'system:dept:add', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1019', 'é¨é¨ä¿®æ¹', '103', '3', '', '', '', 1, 0, 'F', '0', '0', 'system:dept:edit', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1020', 'é¨é¨å é¤', '103', '4', '', '', '', 1, 0, 'F', '0', '0', 'system:dept:remove', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1016', 'é¨é¨æ¥è¯¢', '103', '1', '', '', '', 1, 0, 'F', '0', '0', 'system:dept:query', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1017', 'é¨é¨æ°å¢', '103', '2', '', '', '', 1, 0, 'F', '0', '0', 'system:dept:add', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1018', 'é¨é¨ä¿®æ¹', '103', '3', '', '', '', 1, 0, 'F', '0', '0', 'system:dept:edit', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1019', 'é¨é¨å é¤', '103', '4', '', '', '', 1, 0, 'F', '0', '0', 'system:dept:remove', '#', 'admin', sysdate(), '', null, '');
|
| | | -- å²ä½ç®¡çæé®
|
| | | insert into sys_menu values('1021', 'å²ä½æ¥è¯¢', '104', '1', '', '', '', 1, 0, 'F', '0', '0', 'system:post:query', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1022', 'å²ä½æ°å¢', '104', '2', '', '', '', 1, 0, 'F', '0', '0', 'system:post:add', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1023', 'å²ä½ä¿®æ¹', '104', '3', '', '', '', 1, 0, 'F', '0', '0', 'system:post:edit', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1024', 'å²ä½å é¤', '104', '4', '', '', '', 1, 0, 'F', '0', '0', 'system:post:remove', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1025', 'å²ä½å¯¼åº', '104', '5', '', '', '', 1, 0, 'F', '0', '0', 'system:post:export', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1020', 'å²ä½æ¥è¯¢', '104', '1', '', '', '', 1, 0, 'F', '0', '0', 'system:post:query', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1021', 'å²ä½æ°å¢', '104', '2', '', '', '', 1, 0, 'F', '0', '0', 'system:post:add', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1022', 'å²ä½ä¿®æ¹', '104', '3', '', '', '', 1, 0, 'F', '0', '0', 'system:post:edit', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1023', 'å²ä½å é¤', '104', '4', '', '', '', 1, 0, 'F', '0', '0', 'system:post:remove', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1024', 'å²ä½å¯¼åº', '104', '5', '', '', '', 1, 0, 'F', '0', '0', 'system:post:export', '#', 'admin', sysdate(), '', null, '');
|
| | | -- åå
¸ç®¡çæé®
|
| | | insert into sys_menu values('1026', 'åå
¸æ¥è¯¢', '105', '1', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:query', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1027', 'åå
¸æ°å¢', '105', '2', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:add', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1028', 'åå
¸ä¿®æ¹', '105', '3', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:edit', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1029', 'åå
¸å é¤', '105', '4', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:remove', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1030', 'åå
¸å¯¼åº', '105', '5', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:export', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1025', 'åå
¸æ¥è¯¢', '105', '1', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:query', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1026', 'åå
¸æ°å¢', '105', '2', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:add', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1027', 'åå
¸ä¿®æ¹', '105', '3', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:edit', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1028', 'åå
¸å é¤', '105', '4', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:remove', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1029', 'åå
¸å¯¼åº', '105', '5', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:export', '#', 'admin', sysdate(), '', null, '');
|
| | | -- åæ°è®¾ç½®æé®
|
| | | insert into sys_menu values('1031', 'åæ°æ¥è¯¢', '106', '1', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:query', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1032', 'åæ°æ°å¢', '106', '2', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:add', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1033', 'åæ°ä¿®æ¹', '106', '3', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:edit', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1034', 'åæ°å é¤', '106', '4', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:remove', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1035', '忰坼åº', '106', '5', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:export', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1030', 'åæ°æ¥è¯¢', '106', '1', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:query', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1031', 'åæ°æ°å¢', '106', '2', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:add', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1032', 'åæ°ä¿®æ¹', '106', '3', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:edit', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1033', 'åæ°å é¤', '106', '4', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:remove', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1034', '忰坼åº', '106', '5', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:export', '#', 'admin', sysdate(), '', null, '');
|
| | | -- éç¥å
¬åæé®
|
| | | insert into sys_menu values('1036', 'å
¬åæ¥è¯¢', '107', '1', '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:query', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1037', 'å
¬åæ°å¢', '107', '2', '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:add', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1038', 'å
¬åä¿®æ¹', '107', '3', '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:edit', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1039', 'å
¬åå é¤', '107', '4', '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:remove', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1035', 'å
¬åæ¥è¯¢', '107', '1', '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:query', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1036', 'å
¬åæ°å¢', '107', '2', '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:add', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1037', 'å
¬åä¿®æ¹', '107', '3', '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:edit', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1038', 'å
¬åå é¤', '107', '4', '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:remove', '#', 'admin', sysdate(), '', null, '');
|
| | | -- æä½æ¥å¿æé®
|
| | | insert into sys_menu values('1040', 'æä½æ¥è¯¢', '500', '1', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:query', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1041', 'æä½å é¤', '500', '2', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:remove', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1042', 'æ¥å¿å¯¼åº', '500', '4', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:export', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1039', 'æä½æ¥è¯¢', '500', '1', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:query', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1040', 'æä½å é¤', '500', '2', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:remove', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1041', 'æ¥å¿å¯¼åº', '500', '4', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:export', '#', 'admin', sysdate(), '', null, '');
|
| | | -- ç»å½æ¥å¿æé®
|
| | | insert into sys_menu values('1043', 'ç»å½æ¥è¯¢', '501', '1', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:query', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1044', 'ç»å½å é¤', '501', '2', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:remove', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1045', 'æ¥å¿å¯¼åº', '501', '3', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:export', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1042', 'ç»å½æ¥è¯¢', '501', '1', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:query', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1043', 'ç»å½å é¤', '501', '2', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:remove', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1044', 'æ¥å¿å¯¼åº', '501', '3', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:export', '#', 'admin', sysdate(), '', null, '');
|
| | | -- å¨çº¿ç¨æ·æé®
|
| | | insert into sys_menu values('1046', 'å¨çº¿æ¥è¯¢', '109', '1', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:query', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1047', 'æ¹é强é', '109', '2', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:batchLogout', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1048', 'åæ¡å¼ºé', '109', '3', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:forceLogout', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1045', 'å¨çº¿æ¥è¯¢', '109', '1', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:query', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1046', 'æ¹é强é', '109', '2', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:batchLogout', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1047', 'åæ¡å¼ºé', '109', '3', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:forceLogout', '#', 'admin', sysdate(), '', null, '');
|
| | | -- 宿¶ä»»å¡æé®
|
| | | insert into sys_menu values('1049', '任塿¥è¯¢', '110', '1', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:query', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1050', '任塿°å¢', '110', '2', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:add', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1051', 'ä»»å¡ä¿®æ¹', '110', '3', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:edit', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1052', 'ä»»å¡å é¤', '110', '4', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:remove', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1053', 'ç¶æä¿®æ¹', '110', '5', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:changeStatus', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1054', 'ä»»å¡å¯¼åº', '110', '7', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:export', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1048', '任塿¥è¯¢', '110', '1', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:query', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1049', '任塿°å¢', '110', '2', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:add', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1050', 'ä»»å¡ä¿®æ¹', '110', '3', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:edit', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1051', 'ä»»å¡å é¤', '110', '4', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:remove', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1052', 'ç¶æä¿®æ¹', '110', '5', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:changeStatus', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1053', 'ä»»å¡å¯¼åº', '110', '7', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:export', '#', 'admin', sysdate(), '', null, '');
|
| | | -- 代ç çææé®
|
| | | insert into sys_menu values('1055', 'çææ¥è¯¢', '115', '1', '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:query', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1056', 'çæä¿®æ¹', '115', '2', '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:edit', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1057', 'çæå é¤', '115', '3', '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:remove', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1058', '导å
¥ä»£ç ', '115', '2', '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:import', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1059', 'é¢è§ä»£ç ', '115', '4', '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:preview', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1060', 'çæä»£ç ', '115', '5', '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:code', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1054', 'çææ¥è¯¢', '115', '1', '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:query', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1055', 'çæä¿®æ¹', '115', '2', '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:edit', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1056', 'çæå é¤', '115', '3', '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:remove', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1057', '导å
¥ä»£ç ', '115', '2', '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:import', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1058', 'é¢è§ä»£ç ', '115', '4', '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:preview', '#', 'admin', sysdate(), '', null, '');
|
| | | insert into sys_menu values('1059', 'çæä»£ç ', '115', '5', '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:code', '#', 'admin', sysdate(), '', null, '');
|
| | |
|
| | |
|
| | | -- ----------------------------
|
| | |
| | | insert into sys_role_menu values ('2', '1057');
|
| | | insert into sys_role_menu values ('2', '1058');
|
| | | insert into sys_role_menu values ('2', '1059');
|
| | | insert into sys_role_menu values ('2', '1060');
|
| | |
|
| | | -- ----------------------------
|
| | | -- 8ãè§è²åé¨é¨å
³è表 è§è²1-Né¨é¨
|
| | |
| | | else
|
| | | {
|
| | | // æ°æ®æé为ä»
æ¬äººä¸æ²¡æuserAliaså«å䏿¥è¯¢ä»»ä½æ°æ®
|
| | | sqlString.append(" OR 1=0 ");
|
| | | sqlString.append(StringUtils.format(" OR {}.dept_id = 0 ", deptAlias));
|
| | | }
|
| | | }
|
| | | }
|
| | |
| | | public boolean hasChildByDeptId(Long deptId)
|
| | | {
|
| | | int result = deptMapper.hasChildByDeptId(deptId);
|
| | | return result > 0 ? true : false;
|
| | | return result > 0;
|
| | | }
|
| | |
|
| | | /**
|
| | |
| | | public boolean hasChildByMenuId(Long menuId)
|
| | | {
|
| | | int result = menuMapper.hasChildByMenuId(menuId);
|
| | | return result > 0 ? true : false;
|
| | | return result > 0;
|
| | | }
|
| | |
|
| | | /**
|
| | |
| | | public boolean checkMenuExistRole(Long menuId)
|
| | | {
|
| | | int result = roleMenuMapper.checkMenuExistRole(menuId);
|
| | | return result > 0 ? true : false;
|
| | | return result > 0;
|
| | | }
|
| | |
|
| | | /**
|
| | |
| | | */
|
| | | public void insertUserRole(SysUser user)
|
| | | {
|
| | | Long[] roles = user.getRoleIds();
|
| | | if (StringUtils.isNotNull(roles))
|
| | | {
|
| | | // æ°å¢ç¨æ·ä¸è§è²ç®¡ç
|
| | | List<SysUserRole> list = new ArrayList<SysUserRole>();
|
| | | for (Long roleId : roles)
|
| | | {
|
| | | SysUserRole ur = new SysUserRole();
|
| | | ur.setUserId(user.getUserId());
|
| | | ur.setRoleId(roleId);
|
| | | list.add(ur);
|
| | | }
|
| | | if (list.size() > 0)
|
| | | {
|
| | | userRoleMapper.batchUserRole(list);
|
| | | }
|
| | | }
|
| | | this.insertUserRole(user.getUserId(), user.getRoleIds());
|
| | | }
|
| | |
|
| | | /**
|
| | |
| | | public void insertUserPost(SysUser user)
|
| | | {
|
| | | Long[] posts = user.getPostIds();
|
| | | if (StringUtils.isNotNull(posts))
|
| | | if (StringUtils.isNotEmpty(posts))
|
| | | {
|
| | | // æ°å¢ç¨æ·ä¸å²ä½ç®¡ç
|
| | | List<SysUserPost> list = new ArrayList<SysUserPost>();
|
| | | List<SysUserPost> list = new ArrayList<SysUserPost>(posts.length);
|
| | | for (Long postId : posts)
|
| | | {
|
| | | SysUserPost up = new SysUserPost();
|
| | |
| | | up.setPostId(postId);
|
| | | list.add(up);
|
| | | }
|
| | | if (list.size() > 0)
|
| | | {
|
| | | userPostMapper.batchUserPost(list);
|
| | | }
|
| | | userPostMapper.batchUserPost(list);
|
| | | }
|
| | | }
|
| | |
|
| | |
| | | */
|
| | | public void insertUserRole(Long userId, Long[] roleIds)
|
| | | {
|
| | | if (StringUtils.isNotNull(roleIds))
|
| | | if (StringUtils.isNotEmpty(roleIds))
|
| | | {
|
| | | // æ°å¢ç¨æ·ä¸è§è²ç®¡ç
|
| | | List<SysUserRole> list = new ArrayList<SysUserRole>();
|
| | | List<SysUserRole> list = new ArrayList<SysUserRole>(roleIds.length);
|
| | | for (Long roleId : roleIds)
|
| | | {
|
| | | SysUserRole ur = new SysUserRole();
|
| | |
| | | ur.setRoleId(roleId);
|
| | | list.add(ur);
|
| | | }
|
| | | if (list.size() > 0)
|
| | | {
|
| | | userRoleMapper.batchUserRole(list);
|
| | | }
|
| | | userRoleMapper.batchUserRole(list);
|
| | | }
|
| | | }
|
| | |
|