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
| -- =============================================
| -- 管理驾驶舱与统计分析模块 初始化脚本
| -- 包含：顶级目录「统计分析」、页面「管理驾驶舱」、按钮权限（查询/导出）
| -- 本脚本自包含，可在全新数据库上完整创建目录与页面（均幂等，可重复执行）
| -- 适用库：mom-thzy（种子业务主库，含生产/质检/库存/出库/追溯全部业务表）
| -- 注意：若目标库缺少种子业务表，需先执行以下脚本：
| -- mes_pro_batch_bag_code_init.sql （生产批次/袋码/托盘）
| -- mes_seed_quality_init.sql （种子质检）
| -- mes_trace_consumer_scan_event.sql （消费者扫码事件）
| -- mes_trace_anti_cross_region_init.sql （窜货预警）
| -- mes_pro_scan_inbound_init.sql （生产线扫码入库）
| -- MySQL 8.4 适用
| -- =============================================
|
| SET NAMES utf8mb4;
|
| -- ----------------------------
| -- 0. 顶级目录：统计分析（不存在则创建）
| -- 排序 40：位于「质量管理(30)」之后、「决策BI大屏(45)」之前
| -- ----------------------------
| 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 602700, '统计分析', '', 1, 40, 0, '/statistics', 'ep:data-analysis', '', '',
| 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'
| FROM DUAL
| WHERE NOT EXISTS (
| SELECT 1 FROM system_menu
| WHERE (id = 602700 OR (parent_id = 0 AND name = '统计分析' AND deleted = 0)) AND deleted = 0
| );
|
| -- ----------------------------
| -- 1. 页面：管理驾驶舱（挂到「统计分析」目录 602700 下）
| -- ----------------------------
| 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 602701, '管理驾驶舱', '', 2, 1, 602700, 'management-cockpit', 'ep:monitor', 'management-cockpit/index', 'ManagementCockpit',
| 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'
| FROM DUAL
| WHERE NOT EXISTS (
| SELECT 1 FROM system_menu
| WHERE (id = 602701 OR (parent_id = 602700 AND path = 'management-cockpit' AND deleted = 0)) AND deleted = 0
| )
| AND EXISTS (SELECT 1 FROM system_menu WHERE id = 602700 AND deleted = 0);
|
| -- ----------------------------
| -- 2. 按钮权限：查询 / 导出
| -- ----------------------------
| 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 602702, '驾驶舱查询', 'mes:dashboard:query', 3, 1, 602701, '', '', '', '',
| 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'
| FROM DUAL
| WHERE NOT EXISTS (
| SELECT 1 FROM system_menu
| WHERE (id = 602702 OR (parent_id = 602701 AND permission = 'mes:dashboard:query' AND deleted = 0)) AND deleted = 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 602703, '驾驶舱导出', 'mes:dashboard:export', 3, 2, 602701, '', '', '', '',
| 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'
| FROM DUAL
| WHERE NOT EXISTS (
| SELECT 1 FROM system_menu
| WHERE (id = 602703 OR (parent_id = 602701 AND permission = 'mes:dashboard:export' AND deleted = 0)) AND deleted = 0
| );
|
|
