创建菜单-insert.sql
7.84 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark) VALUES ( '用户拜访/收费', 0, 5, 'visit', 'market-charges/visit/index', NULL, 1, 0, 'C', '0', '0', '', 'dashboard', '0', NOW(), '0', NOW(), '市场化收费');
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark) VALUES ('点火及施工维护', 0, 6, 'ignition', 'market-charges/ignition/index', NULL, 1, 0, 'C', '0', '0', NULL, 'clipboard', '0', NOW(), '0', NOW(), '市场化收费');
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark) VALUES ( '基础数据维护表', 0, 8, 'basicData', 'market-charges/basicData/index', NULL, 1, 0, 'C', '0', '0', '', 'excel', '0', NOW(), '0', NOW(), '市场化收费');
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, remark) VALUES
('用户下拉框', (SELECT m.menu_id FROM sys_menu m WHERE m.menu_name='用户拜访/收费'), 3, '', NULL, NULL, 1, 0, 'F', '0', '0', 'schsf:mcVisitUser:list', '#', '0', NOW(), '市场化收费');
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, remark) VALUES
('添加', (SELECT m.menu_id FROM sys_menu m WHERE m.menu_name='用户拜访/收费'), 8, '', NULL, NULL, 1, 0, 'F', '0', '0', 'schsf:mcVisit:add', '#', '0', NOW(), '市场化收费');
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, remark) VALUES
('修改', (SELECT m.menu_id FROM sys_menu m WHERE m.menu_name='用户拜访/收费'), 9, '', NULL, NULL, 1, 0, 'F', '0', '0', 'schsf:mcVisit:edit', '#', '0', NOW(), '市场化收费');
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, remark) VALUES
('列表', (SELECT m.menu_id FROM sys_menu m WHERE m.menu_name='用户拜访/收费'), 10, '', NULL, NULL, 1, 0, 'F', '0', '0', 'schsf:mcVisit:list', '#', '0', NOW(), '市场化收费');
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, remark) VALUES
('发布-一级审核', (SELECT m.menu_id FROM sys_menu m WHERE m.menu_name='用户拜访/收费'), 11, '', NULL, NULL, 1, 0, 'F', '0', '0', 'schsf:mcVisit:ticket_submitAuditOne', '#', '0', NOW(), '市场化收费');
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, remark) VALUES
('发布-二级审核', (SELECT m.menu_id FROM sys_menu m WHERE m.menu_name='用户拜访/收费'), 12, '', NULL, NULL, 1, 0, 'F', '0', '0', 'schsf:mcVisit:ticket_submitAuditTwo', '#', '0', NOW(), '市场化收费');
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, remark) VALUES
('异动-一级审核', (SELECT m.menu_id FROM sys_menu m WHERE m.menu_name='用户拜访/收费'), 13, '', NULL, NULL, 1, 0, 'F', '0', '0', 'schsf:mcVisit:modification_submitAuditOne', '#', '0', NOW(), '市场化收费');
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, remark) VALUES
('发起数据异动', (SELECT m.menu_id FROM sys_menu m WHERE m.menu_name='用户拜访/收费'), 16, '', NULL, NULL, 1, 0, 'F', '0', '0', 'schsf:mcVisit:modification', '#', '0', NOW(), '市场化收费');
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, remark) VALUES
('作废', (SELECT m.menu_id FROM sys_menu m WHERE m.menu_name='用户拜访/收费'), 19, '', NULL, NULL, 1, 0, 'F', '0', '0', 'schsf:mcVisit:cancel', '#', '0', NOW(), '市场化收费');
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, remark) VALUES
('点火-列表', (SELECT m.menu_id FROM sys_menu m WHERE m.menu_name='点火及施工维护'), 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'schsf:mcIgnition:list', '#', '0', NOW(), '市场化收费');
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, remark) VALUES
('点火-维护', (SELECT m.menu_id FROM sys_menu m WHERE m.menu_name='点火及施工维护'), 2, '', NULL, NULL, 1, 0, 'F', '0', '0', 'schsf:mcIgnition:maintenance', '#', '0', NOW(), '市场化收费');
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, remark) VALUES
('施工-列表', (SELECT m.menu_id FROM sys_menu m WHERE m.menu_name='点火及施工维护'), 3, '', NULL, NULL, 1, 0, 'F', '0', '0', 'schsf:mcConstruction:list', '#', '0', NOW(), '市场化收费');
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, remark) VALUES
('施工-工程维护', (SELECT m.menu_id FROM sys_menu m WHERE m.menu_name='点火及施工维护'), 4, '', NULL, NULL, 1, 0, 'F', '0', '0', 'schsf:mcConstruction:engineering', '#', '0', NOW(), '市场化收费');
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, remark) VALUES
('施工-运营维护', (SELECT m.menu_id FROM sys_menu m WHERE m.menu_name='点火及施工维护'), 5, '', NULL, NULL, 1, 0, 'F', '0', '0', 'schsf:mcConstruction:operations', '#', '0', NOW(), '市场化收费');
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, remark) VALUES
('列表查询(金额)', (SELECT m.menu_id FROM sys_menu m WHERE m.menu_name='基础数据维护表'), 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'schsf:mcBasicMoney:list', '#', '0', NOW(), '市场化收费');
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, remark) VALUES
('导入excel(金额)', (SELECT m.menu_id FROM sys_menu m WHERE m.menu_name='基础数据维护表'), 2, '', NULL, NULL, 1, 0, 'F', '0', '0', 'schsf:mcBasicMoney:importData', '#', '0', NOW(), '市场化收费');
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, remark) VALUES
('列表查询(户数)', (SELECT m.menu_id FROM sys_menu m WHERE m.menu_name='基础数据维护表'), 6, '', NULL, NULL, 1, 0, 'F', '0', '0', 'schsf:mcBasicCmty:list', '#', '0', NOW(), '市场化收费');
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, remark) VALUES
('导入excel(户数)', (SELECT m.menu_id FROM sys_menu m WHERE m.menu_name='基础数据维护表'), 4, '', NULL, NULL, 1, 0, 'F', '0', '0', 'schsf:mcBasicCmty:importData', '#', '0', NOW(), '市场化收费')