2026-08-19-storage-release-dual-gate-menu.sql 3.3 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091
  1. -- 入库放行审核:生产 / 质检菜单(sys_menu)
  2. -- MySQL 5.7;可重复执行
  3. -- 市场 → 细胞存储 原菜单(biz:storageReleaseReview:list)保持不变
  4. -- 不写入 sys_role_menu:由管理员在角色管理中勾选新菜单
  5. SET @tenant_no = CONVERT('zkxw' USING utf8mb4) COLLATE utf8mb4_unicode_ci;
  6. SET @prm_id = CONVERT('PRM00000000000000000000000000001' USING utf8mb4) COLLATE utf8mb4_unicode_ci;
  7. SET @qcm_id = CONVERT('QCM00000000000000000000000000001' USING utf8mb4) COLLATE utf8mb4_unicode_ci;
  8. -- 注意:954…001 已占用「生产任务组合模版」,生产侧入库放行用 955…001
  9. SET @menu_prod = CONVERT('95500000000000000000000000000001' USING utf8mb4) COLLATE utf8mb4_unicode_ci;
  10. SET @menu_qc = CONVERT('70000000000000000000000000000014' USING utf8mb4) COLLATE utf8mb4_unicode_ci;
  11. -- 1) 生产 → 生产管理 → 入库放行审核
  12. INSERT INTO sys_menu (
  13. id, menu_name, parent_id, menu_type, path, component, perms,
  14. is_frame, visible, status, tenant_no, order_num, remark,
  15. create_by, create_dept_id, create_time, update_by, update_time, del_flag
  16. )
  17. SELECT
  18. @menu_prod,
  19. '入库放行审核',
  20. @prm_id,
  21. 'C',
  22. 'storage-release-review',
  23. '/quality-inspection/storage-release-review/index',
  24. 'production:storageReleaseReview:list',
  25. 1, '1', '1', @tenant_no, 4,
  26. '生产侧入库放行审核(仅审生产结论;双通过后可入库)',
  27. NULL, '', NOW(), NULL, NOW(), 0
  28. FROM DUAL
  29. WHERE NOT EXISTS (
  30. SELECT 1 FROM sys_menu m
  31. WHERE m.id COLLATE utf8mb4_unicode_ci = @menu_prod
  32. OR m.perms COLLATE utf8mb4_unicode_ci = 'production:storageReleaseReview:list'
  33. );
  34. UPDATE sys_menu
  35. SET
  36. menu_name = '入库放行审核',
  37. parent_id = @prm_id,
  38. menu_type = 'C',
  39. path = 'storage-release-review',
  40. component = '/quality-inspection/storage-release-review/index',
  41. perms = 'production:storageReleaseReview:list',
  42. visible = '1',
  43. status = '1',
  44. order_num = 4,
  45. remark = '生产侧入库放行审核(仅审生产结论;双通过后可入库)',
  46. del_flag = 0,
  47. update_time = NOW()
  48. WHERE id COLLATE utf8mb4_unicode_ci = @menu_prod;
  49. -- 2) 质检 → 质检管理 → 入库放行审核
  50. INSERT INTO sys_menu (
  51. id, menu_name, parent_id, menu_type, path, component, perms,
  52. is_frame, visible, status, tenant_no, order_num, remark,
  53. create_by, create_dept_id, create_time, update_by, update_time, del_flag
  54. )
  55. SELECT
  56. @menu_qc,
  57. '入库放行审核',
  58. @qcm_id,
  59. 'C',
  60. 'storage-release-review',
  61. '/quality-inspection/storage-release-review/index',
  62. 'quality:storageReleaseReview:list',
  63. 1, '1', '1', @tenant_no, 3,
  64. '质检侧入库放行审核(仅审质检结论;双通过后可入库)',
  65. NULL, '', NOW(), NULL, NOW(), 0
  66. FROM DUAL
  67. WHERE NOT EXISTS (
  68. SELECT 1 FROM sys_menu m
  69. WHERE m.id COLLATE utf8mb4_unicode_ci = @menu_qc
  70. OR m.perms COLLATE utf8mb4_unicode_ci = 'quality:storageReleaseReview:list'
  71. );
  72. UPDATE sys_menu
  73. SET
  74. menu_name = '入库放行审核',
  75. parent_id = @qcm_id,
  76. menu_type = 'C',
  77. path = 'storage-release-review',
  78. component = '/quality-inspection/storage-release-review/index',
  79. perms = 'quality:storageReleaseReview:list',
  80. visible = '1',
  81. status = '1',
  82. order_num = 3,
  83. remark = '质检侧入库放行审核(仅审质检结论;双通过后可入库)',
  84. del_flag = 0,
  85. update_time = NOW()
  86. WHERE id COLLATE utf8mb4_unicode_ci = @menu_qc;