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
| -- MES 经销商管理菜单初始化
| -- 经销商复用 CRM 客户主数据，不新增业务表和后端权限。
| -- 执行前请确认当前数据库为项目实际业务库。
|
| SET @dealer_menu_id = (SELECT id FROM system_menu
| WHERE parent_id = 5780 AND path = 'dealer' AND deleted = b'0'
| ORDER BY id LIMIT 1);
|
| INSERT INTO system_menu
| (id, name, permission, type, sort, parent_id, path, icon, component, component_name,
| status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted)
| SELECT 6740, '经销商管理', '', 2, 11, 5780, 'dealer', 'ep:user', 'crm/customer/index', 'MesWmDealer',
| 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'
| WHERE @dealer_menu_id IS NULL
| AND NOT EXISTS (SELECT 1 FROM system_menu WHERE id = 6740);
|
| SET @dealer_menu_id = COALESCE(@dealer_menu_id, (SELECT id FROM system_menu WHERE id = 6740 AND deleted = b'0'));
|
| INSERT INTO system_menu
| (id, name, permission, type, sort, parent_id, path, icon, component, component_name,
| status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted)
| SELECT 6741, '查询经销商', 'crm:customer:query', 3, 1, @dealer_menu_id, '', '', '', NULL,
| 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'
| WHERE EXISTS (SELECT 1 FROM system_menu WHERE id = @dealer_menu_id AND deleted = b'0')
| AND NOT EXISTS (SELECT 1 FROM system_menu WHERE id = 6741);
|
| INSERT INTO system_menu
| (id, name, permission, type, sort, parent_id, path, icon, component, component_name,
| status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted)
| SELECT 6742, '创建经销商', 'crm:customer:create', 3, 2, @dealer_menu_id, '', '', '', NULL,
| 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'
| WHERE EXISTS (SELECT 1 FROM system_menu WHERE id = @dealer_menu_id AND deleted = b'0')
| AND NOT EXISTS (SELECT 1 FROM system_menu WHERE id = 6742);
|
| INSERT INTO system_menu
| (id, name, permission, type, sort, parent_id, path, icon, component, component_name,
| status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted)
| SELECT 6743, '更新经销商', 'crm:customer:update', 3, 3, @dealer_menu_id, '', '', '', NULL,
| 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'
| WHERE EXISTS (SELECT 1 FROM system_menu WHERE id = @dealer_menu_id AND deleted = b'0')
| AND NOT EXISTS (SELECT 1 FROM system_menu WHERE id = 6743);
|
| INSERT INTO system_menu
| (id, name, permission, type, sort, parent_id, path, icon, component, component_name,
| status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted)
| SELECT 6744, '删除经销商', 'crm:customer:delete', 3, 4, @dealer_menu_id, '', '', '', NULL,
| 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'
| WHERE EXISTS (SELECT 1 FROM system_menu WHERE id = @dealer_menu_id AND deleted = b'0')
| AND NOT EXISTS (SELECT 1 FROM system_menu WHERE id = 6744);
|
| INSERT INTO system_menu
| (id, name, permission, type, sort, parent_id, path, icon, component, component_name,
| status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted)
| SELECT 6745, '导出经销商', 'crm:customer:export', 3, 5, @dealer_menu_id, '', '', '', NULL,
| 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'
| WHERE EXISTS (SELECT 1 FROM system_menu WHERE id = @dealer_menu_id AND deleted = b'0')
| AND NOT EXISTS (SELECT 1 FROM system_menu WHERE id = 6745);
|
| INSERT INTO system_menu
| (id, name, permission, type, sort, parent_id, path, icon, component, component_name,
| status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted)
| SELECT 6746, '导入经销商', 'crm:customer:import', 3, 6, @dealer_menu_id, '', '', '', NULL,
| 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'
| WHERE EXISTS (SELECT 1 FROM system_menu WHERE id = @dealer_menu_id AND deleted = b'0')
| AND NOT EXISTS (SELECT 1 FROM system_menu WHERE id = 6746);
|
| SET @dealer_menu_id = NULL;
|
|
