创建菜单-insert.sql
12.6 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
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
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(), '市场化收费');
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, 7, 'reportForms', NULL, NULL, 1, 0, 'M', '0', '0', NULL, 'chart', 'admin', '2024-05-20 14:28:44', '', NULL, '');
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
('拜访报表', (SELECT m.menu_id FROM sys_menu m WHERE m.menu_name='报表'), 1, 'visitReport', 'market-charges/reportForms/visitReport/index', NULL, 1, 0, 'C', '0', '0', NULL, '#', 'admin', NOW(), '', NULL, '');
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
('收费明细报表', (SELECT m.menu_id FROM sys_menu m WHERE m.menu_name='报表'), 2, 'feeDetailsReport', 'market-charges/reportForms/feeDetailsReport/index', NULL, 1, 0, 'C', '0', '0', NULL, '#', 'admin', NOW(), '', NULL, '');
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
( '汇总表', (SELECT m.menu_id FROM sys_menu m WHERE m.menu_name='报表'), 3, 'summaryReport', 'market-charges/reportForms/summaryReport/index', NULL, 1, 0, 'C', '0', '0', NULL, '#', 'admin', NOW(), '', NULL, '');
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
( '列表', (SELECT m.menu_id FROM sys_menu m WHERE m.menu_name='拜访报表'), 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'schsf:mcVisit:visitList', '#', 'admin', NOW(), '', NULL, '');
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
( '导出', (SELECT m.menu_id FROM sys_menu m WHERE m.menu_name='拜访报表'), 2, '', NULL, NULL, 1, 0, 'F', '0', '0', 'schsf:mcVisit:visitListExport', '#', 'admin', NOW(), '', NULL, '');
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
( '列表', (SELECT m.menu_id FROM sys_menu m WHERE m.menu_name='收费明细报表'), 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'schsf:mcVisit:chargedList', '#', 'admin', NOW(), '', NULL, '');
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
( '导出', (SELECT m.menu_id FROM sys_menu m WHERE m.menu_name='收费明细报表'), 2, '', NULL, NULL, 1, 0, 'F', '0', '0', 'schsf:mcVisit:chargedListExport', '#', 'admin',NOW(), '', NULL, '');
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
( '户数-列表', (SELECT m.menu_id FROM sys_menu m WHERE m.menu_name='汇总表'), 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'schsf:mcBasicCmty:summaryList', '#', 'admin', NOW(), '', NULL, '');
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
( '户数-导出', (SELECT m.menu_id FROM sys_menu m WHERE m.menu_name='汇总表'), 2, '', NULL, NULL, 1, 0, 'F', '0', '0', 'schsf:mcBasicCmty:summaryExport', '#', 'admin', NOW(), '', NULL, '');
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
( '资金-列表', (SELECT m.menu_id FROM sys_menu m WHERE m.menu_name='汇总表'), 3, '', NULL, NULL, 1, 0, 'F', '0', '0', 'schsf:mcBasicMoney:summaryList', '#', 'admin', NOW(), '', NULL, '');
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
( '资金-导出', (SELECT m.menu_id FROM sys_menu m WHERE m.menu_name='汇总表'), 4, '', NULL, NULL, 1, 0, 'F', '0', '0', 'schsf:mcBasicMoney:summaryExport', '#', 'admin', NOW(), '', NULL, '');