| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091 |
- -- 入库放行审核:生产 / 质检菜单(sys_menu)
- -- MySQL 5.7;可重复执行
- -- 市场 → 细胞存储 原菜单(biz:storageReleaseReview:list)保持不变
- -- 不写入 sys_role_menu:由管理员在角色管理中勾选新菜单
- SET @tenant_no = CONVERT('zkxw' USING utf8mb4) COLLATE utf8mb4_unicode_ci;
- SET @prm_id = CONVERT('PRM00000000000000000000000000001' USING utf8mb4) COLLATE utf8mb4_unicode_ci;
- SET @qcm_id = CONVERT('QCM00000000000000000000000000001' USING utf8mb4) COLLATE utf8mb4_unicode_ci;
- -- 注意:954…001 已占用「生产任务组合模版」,生产侧入库放行用 955…001
- SET @menu_prod = CONVERT('95500000000000000000000000000001' USING utf8mb4) COLLATE utf8mb4_unicode_ci;
- SET @menu_qc = CONVERT('70000000000000000000000000000014' USING utf8mb4) COLLATE utf8mb4_unicode_ci;
- -- 1) 生产 → 生产管理 → 入库放行审核
- INSERT INTO sys_menu (
- id, menu_name, parent_id, menu_type, path, component, perms,
- is_frame, visible, status, tenant_no, order_num, remark,
- create_by, create_dept_id, create_time, update_by, update_time, del_flag
- )
- SELECT
- @menu_prod,
- '入库放行审核',
- @prm_id,
- 'C',
- 'storage-release-review',
- '/quality-inspection/storage-release-review/index',
- 'production:storageReleaseReview:list',
- 1, '1', '1', @tenant_no, 4,
- '生产侧入库放行审核(仅审生产结论;双通过后可入库)',
- NULL, '', NOW(), NULL, NOW(), 0
- FROM DUAL
- WHERE NOT EXISTS (
- SELECT 1 FROM sys_menu m
- WHERE m.id COLLATE utf8mb4_unicode_ci = @menu_prod
- OR m.perms COLLATE utf8mb4_unicode_ci = 'production:storageReleaseReview:list'
- );
- UPDATE sys_menu
- SET
- menu_name = '入库放行审核',
- parent_id = @prm_id,
- menu_type = 'C',
- path = 'storage-release-review',
- component = '/quality-inspection/storage-release-review/index',
- perms = 'production:storageReleaseReview:list',
- visible = '1',
- status = '1',
- order_num = 4,
- remark = '生产侧入库放行审核(仅审生产结论;双通过后可入库)',
- del_flag = 0,
- update_time = NOW()
- WHERE id COLLATE utf8mb4_unicode_ci = @menu_prod;
- -- 2) 质检 → 质检管理 → 入库放行审核
- INSERT INTO sys_menu (
- id, menu_name, parent_id, menu_type, path, component, perms,
- is_frame, visible, status, tenant_no, order_num, remark,
- create_by, create_dept_id, create_time, update_by, update_time, del_flag
- )
- SELECT
- @menu_qc,
- '入库放行审核',
- @qcm_id,
- 'C',
- 'storage-release-review',
- '/quality-inspection/storage-release-review/index',
- 'quality:storageReleaseReview:list',
- 1, '1', '1', @tenant_no, 3,
- '质检侧入库放行审核(仅审质检结论;双通过后可入库)',
- NULL, '', NOW(), NULL, NOW(), 0
- FROM DUAL
- WHERE NOT EXISTS (
- SELECT 1 FROM sys_menu m
- WHERE m.id COLLATE utf8mb4_unicode_ci = @menu_qc
- OR m.perms COLLATE utf8mb4_unicode_ci = 'quality:storageReleaseReview:list'
- );
- UPDATE sys_menu
- SET
- menu_name = '入库放行审核',
- parent_id = @qcm_id,
- menu_type = 'C',
- path = 'storage-release-review',
- component = '/quality-inspection/storage-release-review/index',
- perms = 'quality:storageReleaseReview:list',
- visible = '1',
- status = '1',
- order_num = 3,
- remark = '质检侧入库放行审核(仅审质检结论;双通过后可入库)',
- del_flag = 0,
- update_time = NOW()
- WHERE id COLLATE utf8mb4_unicode_ci = @menu_qc;
|