mescloud/db/mysql/add_mes_batch_quality.sql

-- 批次码发货检记录表 + PC 菜单 + PDA 功能模块
-- 状态流转：仓库中(0) --发货检OK--> 合格(1)；NG 仍为仓库中，可再次检查；已发货(2)不可检查

CREATE TABLE IF NOT EXISTS `mes_batch_quality` (
  `id` varchar(64) NOT NULL COMMENT '主键',
  `batch_sn` varchar(255) DEFAULT '' COMMENT '批次码',
  `line_sn` varchar(100) DEFAULT '' COMMENT '产线编号',
  `result` char(1) DEFAULT '' COMMENT '结果：1=OK 2=NG',
  `remark` varchar(255) DEFAULT '' COMMENT '备注',
  `create_by` varchar(64) DEFAULT NULL COMMENT '检查人',
  `create_date` datetime DEFAULT NULL COMMENT '检查时间',
  `update_by` varchar(64) DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_batch_sn` (`batch_sn`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='批次码发货检记录';

-- PC 菜单：生产管理 / 发货检记录
INSERT INTO `js_sys_menu` (
  `menu_code`, `parent_code`, `parent_codes`, `tree_sort`, `tree_sorts`, `tree_leaf`, `tree_level`,
  `tree_names`, `menu_name`, `menu_type`, `menu_href`, `menu_target`, `menu_icon`, `menu_color`,
  `menu_title`, `permission`, `weight`, `is_show`, `sys_code`, `module_codes`, `component`, `params`,
  `status`, `create_by`, `create_date`, `update_by`, `update_date`, `remarks`
)
SELECT
  'mesBatchQuality',
  '1672118505143263232',
  '0,1672118505143263232,',
  158,
  '0000009290,0000000158,',
  '0',
  1,
  '生产管理/发货检记录',
  '发货检记录',
  '1',
  '/mes/mesBatchQuality/list',
  '',
  'icon-check',
  '',
  '',
  'mes:mesBatchQuality:view',
  80,
  '1',
  'default',
  'core',
  NULL,
  NULL,
  '0',
  'system',
  NOW(),
  'system',
  NOW(),
  ''
FROM DUAL
WHERE NOT EXISTS (
  SELECT 1 FROM `js_sys_menu` WHERE `menu_code` = 'mesBatchQuality'
);

-- PDA 接口权限（角色授权时勾选）
INSERT INTO `js_sys_menu` (
  `menu_code`, `parent_code`, `parent_codes`, `tree_sort`, `tree_sorts`, `tree_leaf`, `tree_level`,
  `tree_names`, `menu_name`, `menu_type`, `menu_href`, `menu_target`, `menu_icon`, `menu_color`,
  `menu_title`, `permission`, `weight`, `is_show`, `sys_code`, `module_codes`, `component`, `params`,
  `status`, `create_by`, `create_date`, `update_by`, `update_date`, `remarks`
)
SELECT
  'mesBatchQualityApi',
  'mesBatchQuality',
  '0,1672118505143263232,mesBatchQuality,',
  30,
  '0000009290,0000000158,0000000030,',
  '1',
  2,
  '生产管理/发货检记录/PDA接口',
  'PDA接口',
  '2',
  '',
  '',
  '',
  '',
  '',
  'mes:mesBatchQuality:api',
  40,
  '1',
  'default',
  'core',
  NULL,
  NULL,
  '0',
  'system',
  NOW(),
  'system',
  NOW(),
  ''
FROM DUAL
WHERE NOT EXISTS (
  SELECT 1 FROM `js_sys_menu` WHERE `menu_code` = 'mesBatchQualityApi'
);

-- PDA 功能模块：发货检（质量管理分类）
INSERT INTO `mes_icons` (
  `id`, `category_id`, `title`, `mode`, `remark`, `status`, `auth`,
  `create_by`, `create_date`, `update_by`, `update_date`
)
SELECT
  '2090000000000000235',
  '2075400793979899904',
  '发货检',
  '235',
  '',
  '0',
  'mes:mesBatchQuality:api',
  'system',
  NOW(),
  'system',
  NOW()
FROM DUAL
WHERE NOT EXISTS (
  SELECT 1 FROM `mes_icons` WHERE `id` = '2090000000000000235' OR (`title` = '发货检' AND `mode` = '235')
);