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
| -- 质检审核人配置：仅种子质检：按初检审核/复检审核节点维护，可配置多人。
| CREATE TABLE IF NOT EXISTS mes_qc_approver_config (
| id bigint NOT NULL AUTO_INCREMENT,
| qc_type tinyint NOT NULL COMMENT '质检类型：1种子质检',
| approve_node tinyint NOT NULL COMMENT '审核节点：1初检审核 3复检审核',
| user_id bigint NOT NULL COMMENT '审核人用户ID',
| status tinyint NOT NULL DEFAULT 0 COMMENT '状态：0启用 1停用',
| remark varchar(255) DEFAULT NULL COMMENT '备注',
| creator varchar(64) DEFAULT '',
| create_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
| updater varchar(64) DEFAULT '',
| update_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
| deleted bit(1) NOT NULL DEFAULT b'0',
| PRIMARY KEY (id),
| KEY idx_qc_type_node (qc_type, approve_node)
| ) ENGINE=InnoDB COMMENT='质检审核人配置';
|
| -- 质量管理 / 质检审核人 菜单及按钮权限
| INSERT INTO system_menu (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 '质检审核人', '', 2, 9, 5500, 'approver-config', 'ep:user', 'mes/qc/approverConfig/index', 'MesQcApproverConfig', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'
| FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM system_menu WHERE parent_id = 5500 AND path = 'approver-config' AND deleted = b'0');
|
| INSERT INTO system_menu (name, permission, type, sort, parent_id, path, icon, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted)
| SELECT '查询', 'mes:qc-approver:query', 3, 1, id, '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'
| FROM system_menu WHERE parent_id = 5500 AND path = 'approver-config' AND deleted = b'0'
| AND NOT EXISTS (SELECT 1 FROM system_menu m WHERE m.parent_id = system_menu.id AND m.permission = 'mes:qc-approver:query' AND m.deleted = b'0');
| INSERT INTO system_menu (name, permission, type, sort, parent_id, path, icon, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted)
| SELECT '新增', 'mes:qc-approver:create', 3, 2, id, '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'
| FROM system_menu WHERE parent_id = 5500 AND path = 'approver-config' AND deleted = b'0'
| AND NOT EXISTS (SELECT 1 FROM system_menu m WHERE m.parent_id = system_menu.id AND m.permission = 'mes:qc-approver:create' AND m.deleted = b'0');
| INSERT INTO system_menu (name, permission, type, sort, parent_id, path, icon, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted)
| SELECT '修改', 'mes:qc-approver:update', 3, 3, id, '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'
| FROM system_menu WHERE parent_id = 5500 AND path = 'approver-config' AND deleted = b'0'
| AND NOT EXISTS (SELECT 1 FROM system_menu m WHERE m.parent_id = system_menu.id AND m.permission = 'mes:qc-approver:update' AND m.deleted = b'0');
| INSERT INTO system_menu (name, permission, type, sort, parent_id, path, icon, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted)
| SELECT '删除', 'mes:qc-approver:delete', 3, 4, id, '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'
| FROM system_menu WHERE parent_id = 5500 AND path = 'approver-config' AND deleted = b'0'
| AND NOT EXISTS (SELECT 1 FROM system_menu m WHERE m.parent_id = system_menu.id AND m.permission = 'mes:qc-approver:delete' AND m.deleted = b'0');
|
|
